alitaslimiSwap Volume by Blockchain/Protocol
Updated 2023-04-19
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
26
27
28
29
›
⌄
WITH
swaps AS (
SELECT
date,
chain,
protocol,
volume
FROM
external.defillama.fact_dex_volume
WHERE
chain IN ('arbitrum', 'optimism', 'avalanche', 'polygon')
)
SELECT
INITCAP(chain) AS "Blockchain",
INITCAP(protocol) AS "Protocol",
SUM(volume) AS "Total Volume",
SUM(CASE WHEN date >= CURRENT_DATE - 7 THEN volume ELSE 0 END) AS "Volume (7D)",
SUM(CASE WHEN date >= CURRENT_DATE - 30 THEN volume ELSE 0 END) AS "Volume (30D)",
SUM(CASE WHEN date >= CURRENT_DATE - 90 THEN volume ELSE 0 END) AS "Volume (90D)",
SUM(CASE WHEN date >= CURRENT_DATE - 180 THEN volume ELSE 0 END) AS "Volume (180D)",
SUM(CASE WHEN date >= CURRENT_DATE - 365 THEN volume ELSE 0 END) AS "Volume (365D)"
FROM
swaps
GROUP BY
"Blockchain",
"Protocol"
ORDER BY
"Blockchain",
"Total Volume" DESC
Run a query to Download Data