flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
active users
BlockTracker
active users
Updated 2024-10-15
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
date_trunc
(
'{{granularity}}'
,
block_timestamp
)
as
date
,
count
(
DISTINCT
sender
)
as
user
from
aptos
.
core
.
fact_transactions
where
block_timestamp
::
date
>=
dateadd
(
day
,
-
{
{
past_days
}
}
,
current_date
(
)
)
and
date
<
current_date
group
by
1
Results
QueryRunArchived: QueryRun has been archived