CURRENT_PRICE | Q1_HIGH | Q1_LOW | |
|---|---|---|---|
1 | 1.357719626 | 11.383763421 | 3.794637094 |
deevhynTHORCHAIN Price Analysis
Updated 2025-01-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
WITH current_price AS (
SELECT
date_trunc('day', hour),
price
FROM thorchain.price.ez_prices_hourly
LIMIT 1
)
,
Q1_price AS (
SELECT
MAX(price) AS Q1_high,
MIN(price) AS Q1_low
FROM thorchain.price.ez_prices_hourly
WHERE date_part('quarter', hour) = 1
AND date_part('year', hour) = 2024
)
SELECT
cp.price AS current_price,
q1.Q1_high,
q1.Q1_low
FROM
current_price cp,
Q1_price q1;
Last run: 3 months ago
1
40B
2s