flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
Number of blocks and txn and avg txn/block
SocioCrypto
Number of blocks and txn and avg txn/block
Updated 2022-07-01
Copy Reference
Fork
9
1
2
3
4
5
6
7
›
⌄
SELECT
date_trunc
(
'day'
,
block_timestamp
)
as
date
,
count
(
block_number
)
as
n_blocks
,
avg
(
tx_count
)
as
avg_n_txn
,
sum
(
tx_count
)
as
n_txn
FROM
bsc
.
core
.
fact_blocks
GROUP
BY
date
ORDER
by
date
DESC
Results
Run a query to Download Data