check_skedL2 DEX VOLUME SHARE
Updated 2023-05-20
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
30
31
32
33
34
35
36
›
⌄
SELECT
DATE_TRUNC('DAY', DATE) AS dt,
SUM(
CASE
WHEN CHAIN = 'ethereum' THEN VOLUME
ELSE 0
END
) AS ETH_VOLUME,
SUM(
CASE
WHEN CHAIN = 'optimism' THEN VOLUME
ELSE 0
END
) AS OP_VOLUME,
SUM(
CASE
WHEN CHAIN = 'arbitrum' THEN VOLUME
ELSE 0
END
) AS ARB_VOLUME,
SUM(
CASE
WHEN CHAIN = 'polygon' THEN VOLUME
ELSE 0
END
) AS MATIC_VOLUME,
(OP_VOLUME / ETH_VOLUME) * 100 AS OP_SHARE,
(ARB_VOLUME / ETH_VOLUME) * 100 AS ARB_SHARE,
(MATIC_VOLUME / ETH_VOLUME) * 100 AS MATIC_SHARE
FROM
external.defillama.fact_dex_volume
GROUP BY
dt
ORDER BY
dt DESC
LIMIT
Run a query to Download Data