maybeyonasmim_vol_txs
    Updated 2022-02-08
    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
    Run a query to Download Data