0xaimanUntitled Query
    Updated 2022-05-10
    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