connorhETH-ALCX
Updated 2021-04-01
9
1
2
3
4
5
6
7
›
⌄
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