flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
AVERAGE TRANSACTION PER USER ON BASE NETWORK
AnalyticSages
AVERAGE TRANSACTION PER USER ON BASE NETWORK
Updated 2024-04-05
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
with
user_transactions
AS
(
SELECT
count
(
tx_hash
)
as
daily_tx
,
count
(
DISTINCT
origin_from_address
)
AS
Active_Users
,
daily_tx
/
Active_Users
AS
tx_per_user
FROM
base
.
defi
.
ez_dex_swaps
)
SELECT
avg
(
tx_per_user
)
FROM
user_transactions
Results
QueryRunArchived: QueryRun has been archived