flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
BECOME A PARTNER
flipside
avalanche5
bachi
avalanche5
Updated 2023-04-13
Copy Reference
Fork
9
1
2
3
4
›
⌄
select
date
(
block_timestamp
)
as
day
,
sum
(
tx_count
)
as
tot_txn_count
,
round
(
(
sum
(
tx_count
)
)
/
(
24
*
60
*
60
)
,
2
)
as
txns_per_sec
from
avalanche
.
core
.
fact_blocks
group
by
day
order
by
day
desc
Results
Run a query to Download Data