ACTIVITY_DATE | DAILY_ACTIVE_TX_HASH | CUMULATIVE_ACTIVE_TX_HASH | |
|---|---|---|---|
1 | 2025-02-14 00:00:00.000 | 614078 | 173706567 |
2 | 2025-02-13 00:00:00.000 | 1002850 | 173092489 |
3 | 2025-02-12 00:00:00.000 | 985886 | 172089639 |
4 | 2025-02-11 00:00:00.000 | 923584 | 171103753 |
5 | 2025-02-10 00:00:00.000 | 887537 | 170180169 |
6 | 2025-02-09 00:00:00.000 | 1299944 | 169292632 |
7 | 2025-02-08 00:00:00.000 | 1013201 | 167992688 |
8 | 2025-02-07 00:00:00.000 | 846450 | 166979487 |
9 | 2025-02-06 00:00:00.000 | 953701 | 166133037 |
10 | 2025-02-05 00:00:00.000 | 936017 | 165179336 |
11 | 2025-02-04 00:00:00.000 | 1026938 | 164243319 |
12 | 2025-02-03 00:00:00.000 | 954052 | 163216381 |
13 | 2025-02-02 00:00:00.000 | 797036 | 162262329 |
14 | 2025-02-01 00:00:00.000 | 965422 | 161465293 |
15 | 2025-01-31 00:00:00.000 | 951872 | 160499871 |
16 | 2025-01-30 00:00:00.000 | 1057826 | 159547999 |
17 | 2025-01-29 00:00:00.000 | 1092925 | 158490173 |
18 | 2025-01-28 00:00:00.000 | 1004694 | 157397248 |
19 | 2025-01-27 00:00:00.000 | 1148347 | 156392554 |
20 | 2025-01-26 00:00:00.000 | 1056495 | 155244207 |
picasotransaction
Updated 2025-02-14
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;
Last run: about 1 month ago
...
137
6KB
30s