SWAP_ROUTE | SWAPS | SWAPPERS | VOLUME_USD | AVERAGE_AMOUNT_USD | DAILY_AVERAGE_SWAPS | DAILY_AVERAGE_SWAPPERS | |
|---|---|---|---|---|---|---|---|
1 | StableCoin => Other tokens | 1782008 | 51024 | 743459481.057617 | 409.355215837 | 5272.213018 | 150.95858 |
2 | Other tokens => StableCoin | 1792793 | 56576 | 745558827.422059 | 408.850673205 | 5288.474926 | 166.890855 |
3 | StableCoin => StableCoin | 422397 | 21142 | 79901057.8086348 | 188.232353883 | 1249.695266 | 62.550296 |
4 | Other tokens => Other tokens | 1975583 | 193394 | 321390107.331869 | 158.21487725 | 5844.920118 | 572.171598 |
Afonso_DiazSwap route
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
stablecoins as (
select '0x37a4dd9ced2b19cfe8fac251cd727b5787e45269' as token_address
union all
select '0xb75d0b03c06a926e488e2659df1a861f860bd3d1' as token_address
union all
select '0x059a6b0ba116c63191182a0956cf697d0d2213ec' as token_address
union all
select '0x3894085ef7ff0f0aedf52e2a2704928d1ec074f1' as token_address
union all
select '0x0bbda0f76e205fc6a160b90a09975fa443b3fe44' as token_address
),
main as (
select
tx_id,
block_timestamp,
swapper,
platform,
symbol_in,
symbol_out,
case
when amount_in_usd is not null then amount_in_usd
when amount_out_usd is not null then amount_out_usd
when token_in in (select token_address from stablecoins) then amount_in
when token_out in (select token_address from stablecoins) then amount_out
end as amount_usd,
Last run: 4 days ago
4
394B
7s