rdp AS (

SELECT

day,

((total_value_pooled_usd + total_value_bonded_usd)) / 420000000 AS deterministic_rune_price,

(total_value_pooled_usd + total_value_bonded_usd) AS total_value_lock,

total_value_pooled_usd AS pooled_usd,

total_value_bonded_usd AS bonded_usd

FROM

thorchain.defi.fact_daily_tvl

ORDER BY

day

),

rp AS (

SELECT

DATE(hour) AS day,

hour,

price AS rune_price

FROM

thorchain.price.ez_prices_hourly

WHERE

EXTRACT(HOUR FROM hour) = 22

ORDER BY

hour

SELECT

e.hour,

rune_price,

deterministic_rune_price,

rune_price/deterministic_rune_price AS premium,

total_value_lock

FROM

rdp AS c

LEFT JOIN

rp AS e

ON