kiacryptominers daily info
Updated 2022-09-25
9
1
2
3
4
5
›
⌄
select case when block_number >= 15537393 then 'After Merge' else 'Before Merge' end as type, date_trunc('day', block_timestamp) as date, count(distinct block_number) as block_count,
count(distinct miner) as unique_miner, sum(tx_count) as total_tx_count, avg(tx_count) as avg_tx_count_
from ethereum.core.fact_blocks
where date >= '2022-09-01' and date < current_date and tx_count > 0
group by 1, 2
Run a query to Download Data