Eman-RazBlock Stats
Updated 2023-08-22
9
1
2
3
4
5
6
7
8
9
›
⌄
select avg(block_reward) as "Avg Block Reward", avg(fees) as "Avg Block Fee", case
when block_timestamp::date>='2012-11-28' and block_timestamp::date<'2016-07-09' then 'After 1st Halving: Nov 28, 2012'
when block_timestamp::date>='2016-07-09' and block_timestamp::date<'2020-05-11' then 'After 2st Halving: Jul 9, 2016'
when block_timestamp::date>='2020-05-11' then 'After 3st Halving: May 11, 2020'
else 'Before the first Halving'
end as "Time Period"
from bitcoin.core.ez_miner_rewards
group by 3
Run a query to Download Data