MLDZMNxdai14
Updated 2023-03-06Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
concat(SYMBOL_in,'->',SYMBOL_out) as swap_pair,
count(distinct tx_hash) as swaps,
count(distinct ORIGIN_FROM_ADDRESS) as swappers,
sum( AMOUNT_OUT_USD ) swap_usd
from
ethereum.core.ez_dex_swaps
where
(TOKEN_IN ilike '0x6B175474E89094C44Da98b954EedeAC495271d0F'
or
TOKEN_OUT ilike '0x6B175474E89094C44Da98b954EedeAC495271d0F')
and BLOCK_TIMESTAMP>=CURRENT_DATE- {{Time_period_days}}
group by 1 having swap_usd is not null
order by 4 desc limit 10
Run a query to Download Data