binhachonVolume Market Share - Raw volume
    Updated 2022-02-12
    with swap_volume as (
    select
    date_trunc('day', block_timestamp) as blocktime,
    case when platform like '%uniswap%' then 'uniswap' else platform end as adjusted_platform,
    sum(amount_usd) as volume
    from ethereum.dex_swaps
    where blocktime > getdate() - interval'60 days'
    and amount_usd < 1e9
    group by blocktime, adjusted_platform
    )
    select
    *
    from swap_volume
    order by volume desc

    Run a query to Download Data