0xHaM-dMNDE Buying Top 50 Addresses
    Updated 2025-02-26
    WITH priceTb as (
    select
    '2025-02-12'::date as dt,
    0.05 as price
    from avalanche.price.ez_prices_hourly
    where hour::date = '2025-02-12'
    group by 1
    union all
    select
    trunc(block_timestamp, 'day') as dt,
    avg(amount_in_usd/amount_out) as price
    from avalanche.defi.ez_dex_swaps
    where symbol_in in ('WAVAX','USDC')
    and (symbol_out = 'WINK'
    or token_out = '0x7698a5311da174a95253ce86c21ca7272b9b05f8')
    and block_timestamp >= '2025-02-12'
    and block_timestamp < '2025-02-18'
    group by 1
    having price < 1
    union all
    select
    date_trunc('day',hour) as dt,
    avg(price) as price
    from avalanche.price.ez_prices_hourly
    where token_address = '0x7698a5311da174a95253ce86c21ca7272b9b05f8'
    and hour::date >= '2025-02-18'
    group by 1
    ),
    buy as ( -- swaps
    SELECT
    block_timestamp,
    TX_HASH,
    ORIGIN_FROM_ADDRESS as swapper,
    AMOUNT_OUT as swap_to_amount,
    AMOUNT_OUT*price as swap_to_amount_usd,
    upper(symbol) as swap_from_token,
    Last run: about 1 month ago
    RANK
    WALLET
    BUY_VOLUME_WINK
    BUY_VOLUME_USD
    SWAP_COUNT
    TYPE
    1
    10x3bb7c44cbf236abc045add195d02b0f3a150a91311462485.79573124.291Buy >= 1M WINK
    2
    20x4fb0aaef5a7007817e5caf83d98c4a35525f77cc10474003.6523702.642Buy >= 1M WINK
    3
    30x11902dc458d7e2ce6bac74859ddb07c7861b70ad9086530.75713311.08568Buy < 10M WINK
    4
    40xd3f197e0a726b5e783af01c0ff84c64e2719051b7952711.16397635.561Buy < 10M WINK
    5
    50x0f5796510612a1856d73233568994a3ceb9095f37869736.74496227.8621Buy < 10M WINK
    6
    60xd056c0eee354b24fe7c5d4ee762c4d7574badac16185017.77549311.841255Buy < 7.5M WINK
    7
    70x25378b4200e3bd002b696b10a4f5e2e5b5786cdd6029672.22568721.781205Buy < 7.5M WINK
    8
    80x00c31321aca709862b8f7de0566a29ebb3c7ba815774199.32288709.971Buy < 7.5M WINK
    9
    90xa18966364948708f13e2358eb9bd2678ae1075b25694893.69284744.681Buy < 7.5M WINK
    10
    100xf83099378f73dc9cce34bf295e738919645d1cac5470240.17349980.4525Buy < 7.5M WINK
    11
    110x3e3dff29a3f8f3d69d043eada2a7baabdd0a0b365360624.63467259.7544Buy < 7.5M WINK
    12
    120xd29b98dfbe030bc9857e4b956d1ffa8cdaf9fc3b5310831.03340236.8820Buy < 7.5M WINK
    13
    130xce630da2e66d08cb9e474f2a17a3963e82b6b63c5089614.74254480.742Buy < 7.5M WINK
    14
    140x97e4212dd88024df99d0bf419c6a81d1a8bded555042241313780.072Buy < 7.5M WINK
    15
    150xb60afc036e86cb7fdfd5db7268df3527e21139334894452415773.381209Buy < 5M WINK
    16
    160x5ba63dae7c59312bc5814e7e2678af2c3bbba8504869183.41311421.3329Buy < 5M WINK
    17
    170x7470a213536b7fb86a84e31c148ef11a1dd3ca524728186.89398308.771152Buy < 5M WINK
    18
    180x714eb52b91ce8b8e3ea2d99d786f0cd46b8e2f614716854.87235842.741Buy < 5M WINK
    19
    190xe447c21dc23867e3752489c9f108efeddbf9f9c24598101.48407098.17347Buy < 5M WINK
    20
    200x63bc58d703c0807826207ad4367638f876fc013d4440617.48222030.871Buy < 5M WINK
    50
    4KB
    6s