picasotransaction
Updated 2025-02-14Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
WITH daily_active_TX_HASH AS (
SELECT
DATE_TRUNC('DAY', block_timestamp) AS activity_date,
TX_HASH AS tx
FROM ronin.core.fact_transactions
),
daily_counts AS (
SELECT
activity_date,
COUNT(DISTINCT tx) AS daily_active_tx_hash
FROM daily_active_TX_HASH
GROUP BY activity_date
)
SELECT
activity_date,
daily_active_tx_hash,
SUM(daily_active_tx_hash) OVER (ORDER BY activity_date) AS cumulative_active_tx_hash
FROM daily_counts
ORDER BY activity_date DESC;
QueryRunArchived: QueryRun has been archived