flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Average wallet txs
Keyrock
Average wallet txs
Updated 2024-03-04
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
AVG
(
total_transactions
)
as
average_txs
FROM
(
SELECT
sender
as
wallet
,
COUNT
(
DISTINCT
tx_hash
)
as
total_transactions
FROM
aptos
.
core
.
fact_transactions
where
success
=
TRUE
AND
wallet
!=
''
GROUP
BY
wallet
)
Results
Last run: about 1 year ago
AVERAGE_TXS
1
14.687884
1
1
13B
64s