select
date_trunc('day',BLOCK_TIMESTAMP) as dt,
SYMBOL_OUT,
sum(AMOUNT_OUT_USD) as amount_out,
count(TX_HASH) as count_swap_out
from ethereum_core.ez_dex_swaps
where SYMBOL_OUT in ('DAI','USDT','UST','USDC')
and dt<= '2022-05-13'
and dt>='2022-05-08'
group by 1,2