CryptoLionUntitled Query
Updated 2021-08-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
-- (
-- SELECT trunc(block_timestamp, 'day') as date,COUNT(DISTINCT tx_id) as total_swaps,platform
-- FROM ethereum.dex_swaps
-- WHERE platform IN ('uniswap-v3') AND date >= CURRENT_DATE - 90
-- GROUP BY 1,3
-- ORDER BY 1 DESC
-- )
-- UNION ALL
-- (
SELECT trunc(block_timestamp, 'day') as date,COUNT(DISTINCT tx_id) as total_swaps,platform
FROM ethereum.dex_swaps
WHERE platform IN ('uniswap-v2') AND date >= CURRENT_DATE - 90
GROUP BY 1,3
ORDER BY 1 DESC
-- )
Run a query to Download Data