connorhWETH-ALCX SLP Volumes
Updated 2021-04-05
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
-- 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