flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Number of New Users in New year
hess
Number of New Users in New year
Updated 2023-01-11
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
with
sender
as
(
select
min
(
block_timestamp
)
as
dates
,
tx_sender
from
terra
.
core
.
fact_transactions
group
by
2
)
select
count
(
DISTINCT
(
tx_sender
)
)
as
total_user
from
sender
where
dates
>=
'2023-01-01'
Results
Run a query to Download Data