RECEIVERS | VOLUME | USD_VOLUME | AVERAGE_VOLUME | AVERAGE_USD_VOLUME | MEDIAN_VOLUME | MEDIAN_USD_VOLUME | |
|---|---|---|---|---|---|---|---|
1 | 500 | 1468000 | 80000 | 2936 | 130.586702575 | 1314.473633848 | 58.251087051 |
Ali3NOverview (Arena $WINK Airdrop - 2 February 2025)
Updated 2025-03-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
›
⌄
with pricet as (
select date_trunc (day,block_timestamp) as day,
median (amount_in_usd/amount_out) as usdprice
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-05'
group by 1
union all
select date_trunc (day,block_timestamp) as day,
median (amount_out_usd/amount_in) as usdprice
from avalanche.defi.ez_dex_swaps
where symbol_out in ('WAVAX','USDC')
and (symbol_in = 'WINK' or token_in = '0x7698a5311da174a95253ce86c21ca7272b9b05f8')
and block_timestamp >= '2025-02-05'
group by 1
order by 1 desc)
select count (distinct to_address) as Receivers,
sum (amount/2) as volume,
'80000' as USD_Volume,
avg (amount) as Average_Volume,
avg (amount*usdprice) as Average_USD_Volume,
median (amount) as Median_Volume,
median (amount*usdprice) as Median_USD_Volume
from avalanche.core.ez_token_transfers t1 join pricet t2 on t1.block_timestamp::date = t2.day
where tx_hash in ('0x8e0983163c215704f0a4de3575a798be2e421bf9a8688e83b3d84590256274a7','0x034ac41a301b8726e2745ab916b4282e8936f046d0ca55b9a24471a353b041b3')
and contract_address = '0x7698a5311da174a95253ce86c21ca7272b9b05f8'
and from_address = '0xebf747761b6942adabaa58a594ba24931afa0a3f'
and block_timestamp::date = '2025-02-12'
Last run: about 1 month ago
1
70B
6s