binhachon2. Monthly Swap Volume - Both
    Updated 2021-11-15
    with dexswap as (
    select distinct tx_id, block_timestamp, amount_usd, platform from ethereum.dex_swaps
    where amount_usd < 100000000000
    )
    select date_trunc('month', block_timestamp) as blocktime, sum(amount_usd) as volume, 'Uniswap' as symbol from dexswap
    where platform in ('uniswap-v2', 'uniswap-v3')
    group by blocktime, symbol
    union all
    select date_trunc('month', block_timestamp) as blocktime, sum(amount_usd) as volume, 'Sushiswap' as symbol from dexswap
    where platform = 'sushiswap'
    group by blocktime, symbol


    Run a query to Download Data