SWAP_ROUTE | SWAPS | SWAPPERS | VOLUME_USD | AVERAGE_AMOUNT_USD | VOLUME | AVERAGE_AMOUNT | |
|---|---|---|---|---|---|---|---|
1 | WRON -> Ronke | 45050 | 5407 | 8716816 | 121.680360707 | 12148342973.4886 | 169581.961465285 |
2 | Ronke -> USDC | 2274 | 736 | 1047200.88 | 259.465034688 | 431783492.522941 | 106983.025897656 |
3 | USDC -> Ronke | 2433 | 746 | 556061.14 | 130.930336708 | 364621813.784647 | 85853.970752213 |
4 | CAG -> Ronke | 753 | 381 | 186913.3 | 165.117756184 | 193785944.083026 | 171188.996539776 |
5 | Ronke -> CAG | 510 | 238 | 162106.57 | 218.178425303 | 133367413.431385 | 179498.537592713 |
6 | WETH -> Ronke | 621 | 319 | 155578.5 | 159.40420082 | 143239649.519488 | 146761.935983082 |
7 | KOKU -> Ronke | 557 | 332 | 133613.12 | 139.909026178 | 101312518.06289 | 106086.406348576 |
8 | AXS -> Ronke | 530 | 301 | 108536.7 | 139.328241335 | 158418573.113431 | 203361.454574366 |
9 | COCK -> Ronke | 229 | 121 | 89818.38 | 230.303538462 | 27633990.6509006 | 70856.386284361 |
10 | Ronke -> KOKU | 319 | 167 | 84074.78 | 140.828777219 | 40470502.4768231 | 67789.786393339 |
Afonso_DiazTop Trade Routes
Updated 2025-04-03
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
swaps as (
select
tx_hash,
block_timestamp,
origin_from_address as swapper,
a.contract_address as token_in,
b.contract_address as token_out,
a.amount as amount_in,
b.amount as amount_out,
a.amount_usd as amount_in_usd,
b.amount_usd as amount_out_usd,
a.symbol as symbol_in,
b.symbol as symbol_out
from
ronin.core.ez_token_transfers a
join
ronin.core.ez_token_transfers b using (tx_hash, block_timestamp)
where
a.contract_address != b.contract_address
and b.to_address = origin_from_address
and a.to_address != '0x22cefc91e9b7c0f3890ebf9527ea89053490694e'
and b.to_address != '0x22cefc91e9b7c0f3890ebf9527ea89053490694e'
and a.from_address != '0x0000000000000000000000000000000000000000'
and b.from_address != '0x0000000000000000000000000000000000000000'
and tx_hash not in (select distinct tx_hash from ronin.core.fact_transactions where input_data = '0x')
),
main as (
select
*,
nvl(amount_in_usd, amount_out_usd) as amount_usd,
iff(token_in = '0xf988f63bf26c3ed3fbf39922149e3e7b1e5c27cb', amount_in, amount_out) as amount,
iff(token_in = '0xf988f63bf26c3ed3fbf39922149e3e7b1e5c27cb', 'Sell', 'Buy') as type
Last run: 21 days ago
10
832B
22s