zakkisyedSushi swap sizes
    Updated 2022-02-09

    select
    date_trunc('day', block_timestamp) AS daily,
    --block_timestamp,

    pool_name,
    avg(amount_usd)


    from ethereum.dex_swaps

    where
    pool_address = '0x6a091a3406e0073c3cd6340122143009adac0eda' ----top 10 pools
    or pool_address = '0x397ff1542f962076d0bfe58ea045ffa2d347aca0'
    or pool_address = '0xe12af1218b4e9272e9628d7c7dc6354d137d024e'
    or pool_address = '0xd4e7a6e2d03e4e48dfc27dd3f46df1c176647e38'
    or pool_address = '0xceff51756c56ceffca006cd410b03ffc46dd3a58'
    or pool_address = '0x055475920a8c93cffb64d039a8205f7acc7722d3'
    or pool_address = '0x06da0fd433c1a5d7a4faa01111c044910a184553'
    or pool_address = '0xc3f279090a47e80990fe3a9c30d24cb117ef91a8'
    or pool_address = '0xc3d03e4f041fd4cd388c549ee2a29a9e5075882f'
    or pool_address = '0x69b81152c5a8d35a67b32a4d3772795d96cae4da'
    --token_address = '0x6b3595068778dd592e39a122f4f5a5cf09c90fe2'
    and
    platform = 'sushiswap'
    and block_timestamp > CURRENT_DATE - 30

    group by 2,1
    order by 1 desc
    -- )
    Run a query to Download Data