flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
total active users
SocioAnalytica
total active users
Updated 2024-02-01
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
count
(
DISTINCT
from_address
)
as
"Active Users"
,
count
(
DISTINCT
tx_hash
)
as
"Number of Txns"
FROM
polygon
.
core
.
fact_transactions
WHERE
block_timestamp
::
date
BETWEEN
'2023-01-01'
AND
'2023-12-31'
AND
STATUS
=
'SUCCESS'
Results
Last run: about 1 year ago
Active Users
Number of Txns
1
32625775
1068814885
1
1
23B
524s