SWAPPER | SWAPS | VOLUME_USD | AVERAGE_AMOUNT_USD | |
|---|---|---|---|---|
1 | 0x21442343c7c6e133be8d6910ef6e5c042caada20 | 2407 | 496274215.58 | 206179.566090569 |
2 | 0x2feefe024193c110e2e9bc0d19a395aef00283e6 | 2366 | 434791491.81 | 183766.480054945 |
3 | 0x99e71e85676af59eb7d1584b0b37600436006388 | 1432 | 350726603.08 | 244920.812206704 |
4 | 0xe4b45d13ebba2357b6760b1587d48237a686e63a | 2127 | 342422882.03 | 160988.661039022 |
5 | 0xcc69e7f9c896acc66837a1cbec715e05ad4b6307 | 1633 | 329769614.72 | 201940.976558481 |
6 | 0x0e07c8f2781a1f35a4ff183f6db58c9a9bdeea34 | 700 | 190504828.76 | 272149.755371429 |
7 | 0xd161d70751f974f96bc16af52c8eac2e1cc6a8b2 | 610 | 166335995.83 | 272681.960377049 |
8 | 0x31eaf8923ea786baed08510ce21ac25e7b579982 | 1271 | 137673523.59 | 105658.882264006 |
9 | 0xe41f1c3dcb812b67c4cf7b6193e3602efc3d66ae | 503 | 121525280.01 | 241600.954294235 |
10 | 0x61124f46d41de23e692aae97a7cb11d5049dec2f | 431 | 120776271.02 | 280223.366635731 |
11 | 0x3c59e5663e0ba85f8f3bf541268641a2eb059153 | 426 | 113610513.43 | 266691.346079812 |
12 | 0xfdc92ac0dff3acf91a16d0a0222e776c07f81ff7 | 1352 | 102661372.36 | 75932.967721893 |
13 | 0xa43898a0ff23a7ceb0531c6e2a31e04910fc4608 | 713 | 96119869.59 | 134810.47628331 |
14 | 0xc94a967c11c9258f48bfeb9dc0b127e896aa9023 | 623 | 96011278.62 | 154111.201637239 |
15 | 0x1111e09c4d899ba268dc0d6e5a3bb13379ac6051 | 24238 | 93438090.56 | 3828.017967143 |
16 | 0x041e6a523f32bbd9ab21f0fe87e593820801618e | 309 | 93279328.26 | 301874.848737864 |
17 | 0x23ea12973e37099db89f14ad42b709474f87edec | 1177 | 92802321.78 | 78846.492591334 |
18 | 0xe7435f45cc2f589f79709cd398eeaff3d9f71013 | 1201 | 90364814.45 | 75241.310949209 |
19 | 0x91f47f2b895d511c1e54f232b3cfe4d85e958095 | 393 | 88923972.11 | 226269.64913486 |
20 | 0xe1354adc6806edb245dc2140d80fde5cb4bea6f0 | 617 | 88250794.4 | 143032.081685575 |
Afonso_DiazTop 100 swappers
Updated 18 hours 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 swapper,
symbol_in,
symbol_out,
token_in,
token_out,
greatest(symbol_in, symbol_out) || ' - ' || least(symbol_in, symbol_out) as token_pair,
nvl(amount_in_usd, amount_out_usd) as amount_usd
from
bsc.defi.ez_dex_swaps
where
amount_usd < 1e7
and platform ilike 'dodo%'
)
select
swapper,
count(distinct tx_hash) as swaps,
sum(amount_usd) as volume_usd,
avg(amount_usd) as average_amount_usd
from
main
where
block_timestamp between '{{ start_date }}' and '{{ end_date }}'
group by 1
order by volume_usd desc
limit 100
Last run: about 18 hours ago
100
8KB
24s