flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
Ethereum Transactions Per Block
cryptocat
Ethereum Transactions Per Block
Updated 2023-05-20
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
SELECT
block_timestamp
::
date
AS
Day
,
SUM
(
tx_count
)
/
COUNT
(
tx_count
)
AS
Avg_Tx_Block
FROM
ethereum
.
core
.
fact_blocks
WHERE
block_timestamp
::
date
>
'2021-06-30'
GROUP
BY
Day
ORDER
BY
Day
ASC
Results
Run a query to Download Data