flipside
FLIPSIDEAI
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
enormous-white
permary
enormous-white
Updated 2025-02-19
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
DATE_TRUNC
(
'day'
,
closed_at
)
AS
day
,
COUNT
(
DISTINCT
id
)
AS
total_ledgers
FROM
stellar
.
core
.
fact_ledgers
WHERE
closed_at
>=
DATEADD
(
'day'
,
-
30
,
CURRENT_TIMESTAMP
(
)
)
AND
closed_at
<=
CURRENT_TIMESTAMP
(
)
GROUP
BY
1
ORDER
BY
1
;
Results
QueryRunArchived: QueryRun has been archived