0xaimanUntitled Query
Updated 2022-05-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with a as (select date_trunc('hour',block_timestamp) as hour1 ,count(sender) as a1 --, symbol_in, amount_in_usd, symbol_out
from ethereum_core.ez_dex_swaps
where event_name='Swap' and symbol_in='UST' and block_timestamp>='2022-05-03'
group by 1 order by 1),
b as (select date_trunc('hour',block_timestamp) as hour2 ,count(sender) as b1 --, symbol_in, amount_in_usd, symbol_out
from ethereum_core.ez_dex_swaps
where event_name='Swap' and symbol_out='UST' and block_timestamp>='2022-05-03'
group by 1 order by 1)
select hour1, a1 as n_UST_bailer, b1 as n_ust_baller
from a
inner join b on a.hour1=b.hour2
Run a query to Download Data