0xHaM-dAptos I Dex volume
Updated 2024-12-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
date_trunc('week', date) as "Date",
sum(volume) as "Weekly volume",
sum("Weekly volume") over (
ORDER by
"Date"
) as "Cum Weekly volume"
from
external.defillama.fact_dex_volume
where
chain = 'aptos'
-- and date_trunc('week', date) != date_trunc('week', current_date())
group by 1
order by 1 desc , 2 desc
QueryRunArchived: QueryRun has been archived