flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Comparison of unique users and fee volume
vendetta
Comparison of unique users and fee volume
Updated 2024-08-02
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
BLOCK_TIMESTAMP
::
date
as
day
,
SUM
(
TX_FEE_PRECISE
)
as
Fee_Volume
,
COUNT
(
DISTINCT
FROM_ADDRESS
)
as
Unique_users
,
from
base
.
core
.
fact_transactions
WHERE
STATUS
=
'SUCCESS'
GROUP
BY
1
Results
QueryRunArchived: QueryRun has been archived