SELECT

date_trunc('day', hour),

price

FROM thorchain.price.ez_prices_hourly

LIMIT 1

,

Q2_price AS (

SELECT

MAX(price) AS Q2_high,

MIN(price) AS Q2_low

FROM thorchain.price.ez_prices_hourly

WHERE date_part('quarter', hour) = 2

AND date_part('year', hour) = 2024

SELECT

cp.price AS current_price,

q2.Q2_high,

q2.Q2_low

FROM

current_price cp,

Q2_price q2