select date_trunc('day', block_timestamp) as dt, symbol, sum(amount_usd) as volume_mim, count(distinct tx_id) as tx_count
from ethereum.udm_events
where symbol in ('MIM','USDC','UST','DAI','USDT') and event_type = 'erc20_transfer' and to_label_type = 'dex' and block_timestamp >= '2022-01-23'
group by 1,2