SELECT date_trunc('day', hour) AS date,

AVG(price) AS "bitcoin price"

FROM ethereum.price.ez_hourly_token_prices

WHERE symbol = 'WBTC'

AND hour >= current_date() - 90

GROUP BY date

),

Table1 AS (

SELECT date_trunc('day', block_timestamp) AS date,

SUM(block_reward * "bitcoin price") AS "Block reward",

SUM(fees * "bitcoin price") AS "reward from fees",

SUM(total_reward * "bitcoin price") AS "Total reward"

FROM bitcoin.gov.ez_miner_rewards a

JOIN price b

ON date_trunc('day', block_timestamp) = b.date

WHERE block_timestamp >= current_date() - 90

GROUP BY 1

ORDER BY 1 DESC

SELECT SUM("Block reward") AS "Cumulative block reward",

SUM("reward from fees") AS "Cumulative rewards from fees",

SUM("Total reward") AS "Cumulative total reward"

FROM Table1

;