dayvidjoshAverage Block Reward per halving
Updated 2024-05-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
With halving AS (
SELECT BLOCK_NUMBER,
COUNT(*) OVER (PARTITION BY NULL ORDER BY BLOCK_NUMBER) AS Halving
FROM bitcoin.core.fact_blocks
WHERE BLOCK_NUMBER IN (840000, 630000, 420000, 210000)
),
Block_rewards AS (
SELECT Block_Number,
Block_reward
FROM bitcoin.gov.ez_miner_rewards
)
SELECT halving.halving,
AVG(block_rewards.BLOCK_REWARD) AS average_block_reward
FROM halving
JOIN block_rewards
ON halving.Block_number = Block_rewards.Block_Number
GROUP BY halving.halving
ORDER BY halving.halving
;
QueryRunArchived: QueryRun has been archived