flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
2024-04-28 11:10 AM
Cluetopz
2024-04-28 11:10 AM
Updated 2024-04-28
Copy Reference
Fork
9
1
2
3
4
›
⌄
SELECT
COUNT
(
DISTINCT
tx_from
)
AS
total_new_users
FROM
cosmos
.
core
.
fact_transactions
WHERE
block_timestamp
>=
DATEADD
(
DAY
,
-
90
,
CURRENT_DATE
)
Results
QueryRunArchived: QueryRun has been archived