SWAPS | SWAPPERS | VOLUME_USD | AVERAGE_AMOUNT_USD | DAILY_AVERAGE_SWAPS | DAILY_AVERAGE_SWAPPERS | |
|---|---|---|---|---|---|---|
1 | 5334125 | 214190 | 1836153624.36616 | 308.862662043 | 16164.015152 | 649.060606 |
Afonso_DiazTotal
Updated 2 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 '0x80eede496655fb9047dd39d9f418d5483ed600df' 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: 2 days ago
1
73B
107s