TIME | Traded $GYFI | Cumulative trading volume | |
|---|---|---|---|
1 | 2025-03-18 17:00:00.000 | 1 | 1 |
2 | 2025-03-18 18:00:00.000 | 203.366106538 | 204.366106538 |
3 | 2025-03-18 19:00:00.000 | 13898.012741906 | 14102.378848444 |
4 | 2025-03-18 20:00:00.000 | 16178.19039993 | 30280.569248374 |
5 | 2025-03-18 21:00:00.000 | 14680.934403481 | 44961.503651854 |
6 | 2025-03-18 22:00:00.000 | 7491.891181116 | 52453.39483297 |
7 | 2025-03-18 23:00:00.000 | 2541.889560079 | 54995.28439305 |
8 | 2025-03-19 00:00:00.000 | 3316.141934452 | 58311.426327502 |
9 | 2025-03-19 01:00:00.000 | 3079.646074257 | 61391.072401759 |
10 | 2025-03-19 02:00:00.000 | 1603.976545751 | 62995.048947509 |
11 | 2025-03-19 03:00:00.000 | 32.843765598 | 63027.892713107 |
12 | 2025-03-19 04:00:00.000 | 5364.530178117 | 68392.422891224 |
13 | 2025-03-19 05:00:00.000 | 1526.684061925 | 69919.106953149 |
14 | 2025-03-19 06:00:00.000 | 780.645516998 | 70699.752470147 |
15 | 2025-03-19 07:00:00.000 | 1269.017418474 | 71968.769888621 |
16 | 2025-03-19 08:00:00.000 | 840.114725331 | 72808.884613952 |
17 | 2025-03-19 09:00:00.000 | 1165.330008663 | 73974.214622615 |
18 | 2025-03-19 10:00:00.000 | 5700.871541035 | 79675.08616365 |
19 | 2025-03-19 11:00:00.000 | 1422.026549775 | 81097.112713424 |
20 | 2025-03-19 12:00:00.000 | 3511.69677415 | 84608.809487575 |
Mrfti2024-03-18 03:57 PM copy
Updated 17 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
-- forked from 2024-03-18 03:57 PM @ https://flipsidecrypto.xyz/studio/queries/5d10ba6d-f816-4692-948b-808a69c89b24
select
date_trunc('hour', block_timestamp) as time,
sum(amount_in) as "Traded $GYFI",
sum ("Traded $GYFI") over (order by time) as "Cumulative trading volume"
from
base.defi.ez_dex_swaps
where
token_in = lower('0xc63529297dE076eB15fcbE873AE9136E446cFbB9')
group by 1
order by 1
Last run: about 17 hours agoAuto-refreshes every 12 hours
...
1012
57KB
79s