flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
managing-magenta
Samurai
managing-magenta
Updated 2024-12-23
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
SELECT
DATE_TRUNC
(
'DAY'
,
block_timestamp
)
AS
"Day"
,
COUNT
(
DISTINCT
from_address
)
AS
"Active Addresses"
FROM
ink
.
core
.
fact_transactions
GROUP
BY
"Day"
ORDER
BY
"Day"
;
Results
QueryRunArchived: QueryRun has been archived