connorhETH-ALCX
    Updated 2021-04-01
    SELECT DATE(block_timestamp) AS date, pool_name, symbol, SUM(amount_usd) AS volume, SUM(amount_in) AS token_amount
    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