2844Number of swaps before and after war
    Updated 2022-04-22
    select count (tx_id) as swap_Daily,
    platform,
    case when platform='sushiswap' then 'sushiswap-after war'
    when platform='uniswap-v2' then 'uniswap-v2-after war'
    when platform='uniswap-v3' then 'uniswap-v3-after war'
    end as platforms
    from ethereum.dex_swaps
    where
    platform != 'curve'
    and direction = 'IN'
    and amount_in > '0'
    and block_timestamp between '2022-02-24' and '2022-03-15'
    GROUP by platform
    UNION
    select count (tx_id) as swap_Daily,
    platform,
    case when platform='sushiswap' then 'sushiswap-before war'
    when platform='uniswap-v2' then 'uniswap-v2-before war'
    when platform='uniswap-v3' then 'uniswap-v3-before war'
    end as platforms
    from ethereum.dex_swaps
    where
    platform != 'curve'
    and direction = 'IN'
    and amount_in > '0'
    and block_timestamp between '2022-02-04' and '2022-02-23'
    GROUP by platform


    Run a query to Download Data