Papasotuniswap dex dominance pools1
    Updated 2022-11-28
    select
    pool_name,
    platform as Dex,
    count(tx_id) as Swaps,
    sum(amount_usd) as Volume,
    count(DISTINCT(pool_address)) as Pools
    from ethereum.dex_swaps

    where
    block_timestamp >= '2021-08-01' AND
    amount_usd < 1000000000
    -- AND platform != 'curve'
    group by pool_name, Dex
    order by Volume DESC
    limit 20
    Run a query to Download Data