winnie-fsNew query
Updated 2024-10-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
-- forked from 0xHaM-d / Aptos DEXs Volume by Platform @ https://flipsidecrypto.xyz/0xHaM-d/q/yLcN23qt4kD3/aptos-dexs-volume-by-platform
select
date,
protocol,
sum(volume) as volume_usd,
sum(volume_usd) over (partition by protocol order by date) as cum_volume_usd
from external.defillama.fact_dex_volume
where chain = 'aptos'
and date >= '2024-01-01 00:00:00.000 '
group by 1,2
order by 1 desc
QueryRunArchived: QueryRun has been archived