0-MIDTop 10 To Tokens By Swap From USDC After Depeg
Updated 2023-03-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select --date_trunc('hour',BLOCK_TIMESTAMP)as hour
SYMBOL_OUT
--,case
--when date_trunc('hour',BLOCK_TIMESTAMP)>='2023-03-10 19:00:00' and date_trunc('hour',BLOCK_TIMESTAMP)<='2023-03-12 19:00:00' then '72 HOURS AFTER DEPEGGING'
--when date_trunc('hour',BLOCK_TIMESTAMP)>='2023-03-08 19:00:00' and date_trunc('hour',BLOCK_TIMESTAMP)<'2023-03-10 19:00:00' then '72 HOURS BEFORE DEPEGGING' end as depeg_time
--,sum(AMOUNT_IN_USD) as usdc_inflow
,sum(AMOUNT_OUT_USD) as usdc_outflow
,count(distinct TX_HASH) as swap_count
--,count(distinct ORIGIN_FROM_ADDRESS)as swappers
from ethereum.core.ez_dex_swaps
where date_trunc('hour',BLOCK_TIMESTAMP)>='2023-03-10 19:00:00' and date_trunc('hour',BLOCK_TIMESTAMP)<='2023-03-12 19:00:00'
and SYMBOL_IN='USDC'
and AMOUNT_OUT_USD is not null
group by 1
order by 2 desc
limit 10
Run a query to Download Data