brucethebeast-eJL0UMDex volume 24H copy
Updated 2024-03-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
-- forked from andreafiandro / Dex volume 24H @ https://flipsidecrypto.xyz/andreafiandro/q/_o-vWfCDTfzY/dex-volume-24h
SELECT
CASE
WHEN protocol = 'thalaswap' THEN 'thala'
ELSE protocol
END AS protocol,
volume
FROM
external.defillama.fact_dex_volume
WHERE
chain = 'aptos'
AND date = (
SELECT
MAX(DATE)
FROM
external.defillama.fact_dex_volume
WHERE
chain = 'aptos'
)
QueryRunArchived: QueryRun has been archived