flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
BECOME A PARTNER
flipside
Average Transaction Per Day in 2023
superfly
Average Transaction Per Day in 2023
Updated 2023-01-14
Copy Reference
Fork
9
1
2
3
4
›
⌄
select
avg
(
n_txn
)
from
(
select
date
(
block_timestamp
)
,
count
(
distinct
tx_hash
)
as
n_txn
from
arbitrum
.
core
.
fact_transactions
where
datediff
(
'day'
,
block_timestamp
,
getdate
(
)
)
<=
13
group
by
1
)
Results
Run a query to Download Data