PapasotSushiswap/Uniswap volume before and after Ukraine war
    Updated 2022-04-22
    select
    date_trunc('day',block_timestamp) as date,
    platform as Dex,
    count(tx_id) as Swaps,
    sum(amount_usd) as Volume_USD,
    count(DISTINCT(pool_address)) as Pools
    from ethereum.dex_swaps


    where
    date > '2022-01-01' AND
    amount_usd < 1000000000
    AND platform != 'curve'
    AND platform != 'uniswap-v2'
    group by date, Dex
    order by date


    Run a query to Download Data