zakkisyedSushi AMM
    Updated 2022-04-13

    select daily, 0.0025*volume as fees_collected
    FROM
    (
    SELECT
    date_trunc('day',block_timestamp) as daily , sum(amount_usd) as volume
    --CASE WHEN platform like 'sushiswap' THEN 'sushi' ELSE 'uni' END AS platforms
    from ethereum.dex_swaps
    where platform = 'sushiswap'
    --or platform = 'uniswap-v2'
    and block_timestamp > CURRENT_DATE - 102
    group by 1
    order by 1 desc
    )
    Run a query to Download Data