connorhWETH-ALCX SLP Volumes
    Updated 2021-04-05
    -- swap volumes for the two tokens in the sushiswap pool: https://sushiswap.vision/pair/0xc3f279090a47e80990fe3a9c30d24cb117ef91a8
    SELECT DATE(block_timestamp) AS date, pool_name, symbol,
    SUM(amount_usd) AS volume,
    SUM(amount_in) AS token_amount,
    COUNT(DISTINCT tx_id) AS N_TXN
    FROM ethereum.dex_swaps s
    LEFT JOIN
    silver.cmc_assets c ON s.token_address = c.token_address
    WHERE pool_address = '0xc3f279090a47e80990fe3a9c30d24cb117ef91a8' AND block_timestamp >= CURRENT_DATE - 15
    GROUP BY 1,2,3
    ORDER BY 1,3
    Run a query to Download Data