select
date(block_timestamp) as date,
count(distinct tx_id) as txs,
sum(amount) as volume
from ethereum.udm_events
where symbol = 'MIM'
-- and block_timestamp > current_date - interval '180 days'
and year(block_timestamp) = 2022
group by 1
-- limit 100