ML6daily Comparing statistics of Optimism vs Sushiswap
    Updated 2022-10-23
    select 'Optimism' ,block_timestamp::date, count(*) , sum(amount_in_usd) , count(distinct origin_from_address ), avg(amount_in_usd) from optimism.sushi.ez_swaps
    where year(block_timestamp::date) =2022 and month (block_timestamp::date) > 4
    group by 2
    UNION
    select 'ETH' ,block_timestamp::date, count(*) , sum(amount_in_usd) , count(distinct origin_from_address ), avg(amount_in_usd) from ethereum.sushi.ez_swaps
    where year(block_timestamp::date) =2022 and month (block_timestamp::date) > 4
    group by 2
    Run a query to Download Data