mrwildcatdex volume on ethereum
Updated 2023-11-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
-- forked from CURVE DEX VOLUME @ https://flipsidecrypto.xyz/edit/queries/d5f02b4a-5789-4e0a-8b15-683897d3774a
-- forked from exploring cross chain activity copy @ https://flipsidecrypto.xyz/edit/queries/e5283ae4-e740-472c-8acb-6b63fe37bb60
-- forked from 01 exploring cross chain activity @ https://flipsidecrypto.xyz/edit/queries/4aaf90dd-5ae8-4cd2-8c3d-dccf561fef44
SELECT
date_trunc('month', date) AS month,
protocol,
sum(volume)
FROM external.defillama.fact_dex_volume
WHERE date BETWEEN '2023-05-10' AND CURRENT_TIMESTAMP()
AND chain = 'ethereum'
GROUP BY month, protocol
HAVING
SUM(volume) > 0
ORDER BY month, 3
Run a query to Download Data