flipside

    Receivers (Stablejack Yak Airdrop April 2025)
    Ali3NReceivers (Stablejack Yak Airdrop April 2025)
    Updated 2025-04-09
    with pricet as (
    select hour,
    avg (price) as yakprice
    from avalanche.price.ez_prices_hourly
    where token_address = lower ('0x59414b3089ce2AF0010e7523Dea7E2b35d776ec7')
    and hour >= '2025-04-08'
    group by 1)

    select decoded_log:to as Receivers,
    sum (decoded_log:value/1e18) as Amount,
    sum (decoded_log:value*yakprice/1e18) as Amount_USD
    from avalanche.core.ez_decoded_event_logs t1 join pricet t2 on date_trunc (hour,block_timestamp) = t2.hour
    where tx_hash in ('0x4959b6e298aca1d12c5363126e690eb3e9955ce96a1135df56def2bcbc137261','0x1be4e80432092f07da9b7d4cf81e73fe4c0341fcb6a96380a51556aa706ac812') -- Feb 4- 28 / March 1 - 31
    and event_name = 'Transfer'
    and tx_succeeded
    and decoded_log:to != '0x88888c037df4527933fa8ab203a89e1e6e58db70'
    group by 1
    order by 2 desc


    Last run: 16 days ago
    RECEIVERS
    AMOUNT
    AMOUNT_USD
    1
    0xc7829bf1c534959a1a28f4837b2176cc5cc85e09
    		0.338748985.023455831
    2
    0x9ee059d06a9f8eddc16ed1d24160dc530dc75be7
    		0.315646278.938468458
    3
    0x95c6ca5eaadfa1eb503868b5ef577053845563b0
    		0.281830470.711275636
    4
    0xd328097602b9cef563a294eb940f6f9f781a2e0f
    		0.240347960.310359561
    5
    0xae8decc85b9ce5d1fe31fad9e76a85320ca5175c
    		0.14493436.48056389
    6
    0x08fe4f98d1447dd0429e68725a8406484db51646
    		0.144197436.270590716
    7
    0x34fc4134dc4956955164d8f7ec08d0f78955ac00
    		0.109003527.184382865
    8
    0x7b25b25a3425ef44704a0ac96327a2b085b06ec9
    		0.106103426.697354986
    9
    0xb57d6e248f0cc14b90659efea2931497df3eae89
    		0.104967426.344462866
    10
    0x7ab48e5c0b76594a4f63be2ac4c5440f694a65e3
    		0.102473225.698845188
    11
    0x95f13ded482934c8d90a9bb86a3c1edbceae8c8b
    		0.089565122.571565729
    12
    0xcae71304b39959e66c06faf99e35e458d0433bc4
    		0.084928821.369441662
    13
    0x038673370955eb929d94f9d0c7992bb48137e998
    		0.081381120.414810479
    14
    0x3b6ff039272c26207efd86044810e92f17540d46
    		0.079939520.091371995
    15
    0xe8d5ec4375a6787c5e49c7f2a86eab770d849613
    		0.075348618.791391644
    16
    0xdd338adfffd68f6d77e7d489c291bed4ec486c3e
    		0.072948918.291862311
    17
    0xb29fc57a24fb71bc9ef194ef4dd7461f22366a43
    		0.070603917.815734341
    18
    0x807b755d5374769dd5282a05ebaca84ca70af607
    		0.064134816.112963982
    19
    0x6f3fd43511a1368d1e1e63d9306f6472e2cfa7bb
    		0.062366715.587455103
    20
    0x8dc7d2d0ce9b6d7f57486381aad7015b24af5d30
    		0.05036612.65473371
    ...
    244
    16KB
    1s