USER | TRANSACTIONS | VOLUME_USD | AVERAGE_AMOUNT_USD | PLATFORM_FEE_VOLUME_USD | AVERAGE_PLATFORM_FEE_USD | |
|---|---|---|---|---|---|---|
1 | 0x002836e844528fe5 | 70 | 2220540.24246581 | 31722.003463797 | 2220540.24246581 | 31722.003463797 |
2 | 0xb2ea0fe697fdb4ff | 56 | 1975783.86890618 | 21018.977328789 | 1975783.86890618 | 21018.977328789 |
3 | 0x8f8baf3f4afa5791 | 128 | 1735719.14092117 | 10519.509944977 | 1735719.14092117 | 10519.509944977 |
4 | 0xea48abd736c8aabe | 97 | 1583193.90862721 | 13304.150492666 | 1583193.90862721 | 13304.150492666 |
5 | 0x24263c125b7770e0 | 233 | 1457133.44187876 | 5477.945270221 | 1457133.44187876 | 5477.945270221 |
6 | 0x4cc3b4e2f848d5ca | 30 | 1450192.77255453 | 31525.929838142 | 1450192.77255453 | 31525.929838142 |
7 | 0x187b859ff7464547 | 79 | 1396845.21079864 | 13968.452107986 | 1396845.21079864 | 13968.452107986 |
8 | 0xcd2fe9ffd61cfd13 | 59 | 928422.919980277 | 12216.091052372 | 928422.919980277 | 12216.091052372 |
9 | 0xf0bdf1d3b66b8932 | 19 | 653251.96686447 | 26130.078674579 | 653251.96686447 | 26130.078674579 |
10 | 0xeaa1a54cf6818832 | 18 | 567646.659554081 | 29876.139976531 | 567646.659554081 | 29876.139976531 |
11 | 0x1802fed8a061d497 | 18 | 567000.282569719 | 13500.00672785 | 567000.282569719 | 13500.00672785 |
12 | 0x9847bda5eca280e2 | 12 | 487685.589361666 | 34834.684954405 | 487685.589361666 | 34834.684954405 |
13 | 0xc96837936f60c546 | 45 | 486711.489527374 | 7264.350589961 | 486711.489527374 | 7264.350589961 |
14 | 0xe79c28b59fff8e80 | 6 | 436809.673352 | 72801.612225333 | 436809.673352 | 72801.612225333 |
15 | 0x1ff07a976b14f7c4 | 19 | 433929.519515755 | 12762.632926934 | 433929.519515755 | 12762.632926934 |
16 | 0x6995914b0e552704 | 27 | 371484.162417058 | 11608.880075533 | 371484.162417058 | 11608.880075533 |
17 | 0x154129c8f7b5cc8e | 274 | 342136.281310313 | 706.893143203 | 342136.281310313 | 706.893143203 |
18 | 0x09e6fd73000f7b57 | 15 | 339869.344215987 | 22657.956281066 | 339869.344215987 | 22657.956281066 |
19 | 0x0121e7c874277d86 | 9 | 338326.47942511 | 37591.831047234 | 338326.47942511 | 37591.831047234 |
20 | 0x6a1142285bbb7526 | 14 | 322116.785467721 | 23008.341819123 | 322116.785467721 | 23008.341819123 |
Afonso_DiazTop swappers
Updated 2025-03-04
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
›
⌄
with
main as (
select
tx_id,
block_timestamp,
trader as user,
nvl(amount_in_usd, amount_out_usd) as amount_usd,
token_in_symbol as symbol_in,
token_out_symbol as symbol_out
from
flow.defi.ez_dex_swaps
where
amount_usd <= 1e6
and platform ilike 'increment%'
)
select
user,
count(distinct tx_id) as transactions,
sum(amount_usd) as volume_usd,
avg(amount_usd) as average_amount_usd,
sum(amount_usd) as platform_fee_volume_usd,
avg(amount_usd) as average_platform_fee_usd
from
main
where
user is not null
group by 1
order by volume_usd desc
limit 100
Last run: 2 months ago
100
9KB
3s