flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Total Transactions
Sniper
Total Transactions
Updated 2024-10-02
Copy Reference
Fork
9
1
2
3
4
5
6
7
›
⌄
select
count
(
DISTINCT
tx_hash
)
as
transactions
,
count
(
DISTINCT
from_address
)
as
users
,
transactions
/
users
as
"Avg Tx Per User"
from
kaia
.
core
.
fact_transactions
where
TX_SUCCEEDED
=
'TRUE'
or
TX_SUCCEEDED
=
'true'
and
block_timestamp
>=
'2024-01-01'
Results