flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
total unique miners, total transactions and average transactions per block-annually (Given Period 2015 to 2022)
nsa2000
total unique miners, total transactions and average transactions per block-annually (Given Period 2015 to 2022)
Updated 2022-09-17
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
9
›
⌄
select
date_trunc
(
year
,
block_timestamp
)
::
date
as
date
,
count
(
distinct
miner
)
as
tot_unique_miners
,
sum
(
tx_count
)
as
tot_txs
,
avg
(
tx_count
)
as
avg_txs
,
count
(
BLOCK_NUMBER
)
as
tot_blocks
from
ethereum
.
core
.
fact_blocks
where
tx_count
>
0
group
by
1
Results
Run a query to Download Data