USER | TXNS | VOLUME_USD | AVERAGE_AMOUNT_USD | MEDIAN_AMOUNT_USD | |
|---|---|---|---|---|---|
1 | 0x751b77c43643a63362ab024d466fcc1d75354295 | 188833 | 360172958.19 | 1907.362368813 | 1561.86 |
2 | 0x4b9773f7da8e3757eacb6054b70f9dcb7c0f2ed7 | 18488 | 293886626.46 | 14505.756488648 | 8734.78 |
3 | 0xfb1c505c975e229a7c9746141971abdab71f46c4 | 251923 | 281358475.22 | 1116.843143421 | 662.99 |
4 | 0xe75df324cb1ffa8810f4644431b3737a49c92426 | 286849 | 250799358.06 | 874.325370003 | 391.6 |
5 | 0x2ae25cd7f366d3e194e3635808b5e399f55d6fbd | 56127 | 250789761.35 | 4468.255230994 | 3360 |
6 | 0xd13da05b9288ba4961973110594bd0fe3428791f | 200831 | 223859442.14 | 1114.665774407 | 604.39 |
7 | 0xe1b602fb1d4379ae1d6ad9e60b71e7142e645382 | 3456 | 209376608.52 | 17745.284220697 | 266.99 |
8 | 0x2dfc00f5ca5a92ff33a933beaba5f55001628371 | 32851 | 186120121.96 | 5665.239763796 | 5106.74 |
9 | 0x310fbfe67d134f952571287a75f9f4031fa70a9a | 48079 | 177175472.43 | 3685.090630629 | 1246.61 |
10 | 0xb0bada5d45d939a03c6d211d24a61a4418d7cd13 | 206067 | 142918267.56 | 441.758858188 | 25.03 |
Afonso_DiazTop users
Updated 4 days ago
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
35
36
›
⌄
with
main as (
select
tx_hash,
block_timestamp,
origin_from_address as user,
nvl(amount_in_usd, amount_out_usd) as amount_usd,
symbol_in,
symbol_out,
iff(symbol_in > symbol_out, symbol_in || ' - ' || symbol_out, symbol_out || ' - ' || symbol_in) as token_pair
from
base.defi.ez_dex_swaps
where
platform = 'aerodrome'
and amount_usd > 0
and amount_usd < 1e6
)
select
user,
count(distinct tx_hash) as txns,
sum(amount_usd) as volume_usd,
avg(amount_usd) as average_amount_usd,
median(amount_usd) as median_amount_usd
from main
group by 1
order by volume_usd desc
limit 10
Last run: 4 days ago
10
885B
53s