MLDZMNOPvs2
    Updated 2022-10-05
    SELECT
    BLOCK_TIMESTAMP::date as day,
    'Velodrome' as DEX,
    count(distinct tx_hash) as swap_no,
    count(distinct ORIGIN_FROM_ADDRESS) as swappers,
    sum(AMOUNT_IN_USD) as volume,
    volume/swap_no as average_volume
    FROM optimism.velodrome.ez_swaps
    group by 1
    union all
    SELECT
    BLOCK_TIMESTAMP::date as day,
    'Sushiswap' as DEX,
    count(distinct tx_hash) as swap_no,
    count(distinct ORIGIN_FROM_ADDRESS) as swappers,
    sum(AMOUNT_IN_USD) as volume,
    volume/swap_no as average_volume
    FROM optimism.sushi.ez_swaps
    group by 1
    Run a query to Download Data