WEEK | Total volume | Cumulative volume | |
|---|---|---|---|
1 | 2024-01-01 00:00:00.000 | 1165473300 | 1165473300 |
2 | 2024-01-08 00:00:00.000 | 1295315857 | 2460789157 |
3 | 2024-01-15 00:00:00.000 | 702538019 | 3163327176 |
4 | 2024-01-22 00:00:00.000 | 621159884 | 3784487060 |
5 | 2024-01-29 00:00:00.000 | 689846202 | 4474333262 |
6 | 2024-02-05 00:00:00.000 | 808862956 | 5283196218 |
7 | 2024-02-12 00:00:00.000 | 915816928 | 6199013146 |
8 | 2024-02-19 00:00:00.000 | 740080017 | 6939093163 |
9 | 2024-02-26 00:00:00.000 | 1377108357 | 8316201520 |
10 | 2024-03-04 00:00:00.000 | 2088248890 | 10404450410 |
11 | 2024-03-11 00:00:00.000 | 4643761678 | 15048212088 |
12 | 2024-03-18 00:00:00.000 | 3253649885 | 18301861973 |
13 | 2024-03-25 00:00:00.000 | 1310220139 | 19612082112 |
14 | 2024-04-01 00:00:00.000 | 968508386 | 20580590498 |
15 | 2024-04-08 00:00:00.000 | 1055698151 | 21636288649 |
16 | 2024-04-15 00:00:00.000 | 739311904 | 22375600553 |
17 | 2024-04-22 00:00:00.000 | 548350550 | 22923951103 |
18 | 2024-04-29 00:00:00.000 | 541417842 | 23465368945 |
19 | 2024-05-06 00:00:00.000 | 488201313 | 23953570258 |
20 | 2024-05-13 00:00:00.000 | 463586126 | 24417156384 |
Mrfti2024-05-07 07:19 PM copy copy
Updated 2025-03-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
-- forked from 2024-05-07 07:19 PM copy @ https://flipsidecrypto.xyz/studio/queries/2ce0b8b1-3189-4963-bf7b-a209d33396e3
SELECT
date_trunc (week, date) as week,
sum(volume) as "Total volume",
sum ("Total volume") over (order by week) as "Cumulative volume"
from
external.defillama.fact_dex_volume
where
chain = 'avalanche'
and date >= '2024-01-01 00:00:00.000'
GROUP by 1
order by 1
Last run: 3 months agoAuto-refreshes every 12 hours
48
2KB
2s