datavortexVolume Change 24Hrs
Updated 2024-11-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
WITH DexVolumes AS (
SELECT
chain,
SUM(volume) AS total_volume
FROM
EXTERNAL.defillama.fact_dex_volume
WHERE
date = CURRENT_DATE - 1
AND chain IN ('ethereum', 'solana')
GROUP BY
chain
)
SELECT
MAX(CASE WHEN chain = 'ethereum' THEN total_volume ELSE NULL END) AS EthereumYesterdayVolume,
MAX(CASE WHEN chain = 'solana' THEN total_volume ELSE NULL END) AS SolanaYesterdayVolume
FROM
DexVolumes;
QueryRunArchived: QueryRun has been archived