0-MIDHourly inflow stats by platform
Updated 2023-03-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select date_trunc('hour',BLOCK_TIMESTAMP)as hour
,PLATFORM
,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-08 19:00:00'and date_trunc('hour',BLOCK_TIMESTAMP)<='2023-03-12 19:00:00'
and SYMBOL_IN='USDC'
group by 1,2,3
Run a query to Download Data