MasiDaily Swap
    Updated 2022-11-17
    select trunc(block_timestamp,'day') as day,
    count(DISTINCT origin_from_address) as count_tx,
    count(DISTINCT tx_hash) as count_tx,
    sum(amount_in_usd) as Volume_usd,
    avg(amount_in_usd) as average_volume,
    max(amount_in_usd) as max_volume
    from optimism.velodrome.ez_swaps
    where block_timestamp::date >= '2022-06-15'
    group by 1
    Run a query to Download Data