flyingfishPolygon - weekly volume tracker copy
    Updated 2023-01-26
    SELECT
    block_timestamp::date as date
    , pool_name
    -- , symbol_in
    -- , symbol_out
    , sum(CASE when symbol_in = 'WMATIC' THEN amount_in ELSE 0 end) as weth_in
    , sum(CASE when symbol_out = 'WMATIC' THEN amount_out ELSE 0 end) as weth_out
    , weth_in + weth_out AS volume
    , weth_in - weth_out AS delta
    , sum(amount_in) as amount_in
    , sum(amount_in_usd) as amount_in_usd
    , sum(amount_out) as amount_out
    , sum(amount_out_usd) as amount_out_usd
    -- , token_in
    -- , token_out
    FROM polygon.sushi.ez_swaps
    WHERE block_timestamp::date > '2023-01-01' AND block_timestamp < current_date() -- and pool_name IN ('MAGIC-WETH', 'WETH-USDC')
    -- AND (symbol_in = 'WMATIC' OR symbol_out = 'WMATIC')
    -- AND pool_name = 'WMATIC-IXT'
    -- AND pool_name NOT IN ('DPX-WETH', 'RDPX-WETH','MAGIC-WETH', 'WETH-MIM',
    -- 'WETH-USDT', 'RDNT-WETH', 'WETH-gOHM')
    -- AND (token_in = '0x82af49447d8a07e3bd95bd0d56f35241523fbab1' OR
    -- token_out = '0x82af49447d8a07e3bd95bd0d56f35241523fbab1')
    GROUP BY date, pool_name --, token_in, token_out --, symbol_in, symbol_out
    HAVING volume > 10
    -- ORDER BY block_timestamp DESC
    ORDER BY date, weth_in DESC
    -- LIMIT 10

    SELECT amount_in / pow(10,18) as amin,
    amount_out / pow(10,18) as amout,
    *
    FROM polygon.sushi.ez_swaps
    WHERE block_timestamp::date = '2023-01-02'
    AND pool_name = 'NXTT-WMATIC' and symbol_in = 'WMATIC'
    ORDER BY amount_in DESC
    Run a query to Download Data