flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
Total Number of Users & Txs 🌊
0xHaM-d
Total Number of Users & Txs 🌊
Updated 2024-07-14
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
-- forked from Total Number of Users @ https://flipsidecrypto.xyz/edit/queries/eb618dbd-514c-4501-9ec9-a68509eed9c5
SELECT
count
(
DISTINCT
authorizers
[
0
]
)
as
"User Count"
,
count
(
*
)
as
"Transaction Count"
FROM
flow
.
core
.
fact_transactions
Results
QueryRunArchived: QueryRun has been archived