deevhynQ1 total volume
Updated 2024-06-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
WITH total_volume AS (
SELECT
SUM((to_amount + from_amount) / 2) AS Q1_volume
FROM thorchain.defi.fact_swaps
WHERE date_part('quarter', block_timestamp) = 1
AND date_part('year', block_timestamp) = 2024
)
,
max_volume AS (
SELECT
MAX((from_amount + to_amount)/2) AS Max_Q1_volume
FROM thorchain.defi.fact_swaps
WHERE date_part('quarter', block_timestamp) = 1
AND date_part ('year', block_timestamp) = 2024
)
SELECT
tv.Q1_volume,
mv.Max_Q1_volume
FROM
total_volume tv,
max_volume mv;
QueryRunArchived: QueryRun has been archived