Tobi_1dynamic-moccasin
Updated 2024-09-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
⌄
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS transaction_day,
COUNT(TX_ID) AS successful_transactions
FROM
flow.core.fact_transactions;
WHERE
TX_SUCCEEDED = TRUE
AND BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_TIMESTAMP)
GROUP BY
transaction_day
ORDER BY
transaction_day ASC;
QueryRunArchived: QueryRun has been archived