TEN_MIN_BUCKET | UNIQUE_SENDERS | UNIQUE_RECEIVERS | TOTAL_UNIQUE_ADDRESSES | PREVIOUS_PERIOD_ACTIVE | TEN_MIN_GROWTH_RATE | |
|---|---|---|---|---|---|---|
1 | 2025-02-19 15:00:00.000 | 3105 | 1773 | 3105 | ||
2 | 2025-02-19 15:10:00.000 | 3604 | 2852 | 3604 | 3105 | 16.07 |
3 | 2025-02-19 15:20:00.000 | 3512 | 3087 | 3512 | 3604 | -2.55 |
4 | 2025-02-19 15:30:00.000 | 3964 | 2803 | 3964 | 3512 | 12.87 |
5 | 2025-02-19 15:40:00.000 | 4427 | 2910 | 4427 | 3964 | 11.68 |
6 | 2025-02-19 15:50:00.000 | 4459 | 3213 | 4459 | 4427 | 0.72 |
7 | 2025-02-19 16:00:00.000 | 3382 | 2683 | 3382 | 4459 | -24.15 |
8 | 2025-02-19 16:10:00.000 | 4003 | 2556 | 4003 | 3382 | 18.36 |
9 | 2025-02-19 16:20:00.000 | 3968 | 2863 | 3968 | 4003 | -0.87 |
10 | 2025-02-19 16:30:00.000 | 3926 | 1713 | 3926 | 3968 | -1.06 |
11 | 2025-02-19 16:40:00.000 | 4337 | 872 | 4337 | 3926 | 10.47 |
12 | 2025-02-19 16:50:00.000 | 3456 | 603 | 3456 | 4337 | -20.31 |
13 | 2025-02-19 17:00:00.000 | 4303 | 590 | 4303 | 3456 | 24.51 |
14 | 2025-02-19 17:10:00.000 | 5640 | 767 | 5640 | 4303 | 31.07 |
15 | 2025-02-19 17:20:00.000 | 5792 | 1499 | 5792 | 5640 | 2.7 |
16 | 2025-02-19 17:30:00.000 | 6088 | 1275 | 6088 | 5792 | 5.11 |
17 | 2025-02-19 17:40:00.000 | 5745 | 1254 | 5745 | 6088 | -5.63 |
18 | 2025-02-19 17:50:00.000 | 5151 | 1297 | 5151 | 5745 | -10.34 |
19 | 2025-02-19 18:00:00.000 | 5238 | 1915 | 5238 | 5151 | 1.69 |
20 | 2025-02-19 18:10:00.000 | 6473 | 1442 | 6473 | 5238 | 23.58 |
ravelActive wallets
Updated 2025-03-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH ten_min_active_wallets AS (
SELECT
TO_TIMESTAMP(FLOOR(EXTRACT(EPOCH FROM block_timestamp) / (10 * 60)) * (10 * 60)) AS ten_min_bucket,
COUNT(DISTINCT from_address) AS unique_senders,
COUNT(DISTINCT to_address) AS unique_receivers,
COUNT(DISTINCT COALESCE(from_address, to_address)) AS total_unique_addresses
FROM monad.testnet.fact_transactions
WHERE block_timestamp >= '2025-02-19 15:00:00.000'
AND tx_succeeded = TRUE
GROUP BY ten_min_bucket
ORDER BY ten_min_bucket DESC
)
SELECT
ten_min_bucket,
unique_senders,
unique_receivers,
total_unique_addresses,
LAG(total_unique_addresses, 1) OVER (ORDER BY ten_min_bucket) AS previous_period_active,
((total_unique_addresses - LAG(total_unique_addresses, 1) OVER (ORDER BY ten_min_bucket)) /
NULLIF(LAG(total_unique_addresses, 1) OVER (ORDER BY ten_min_bucket), 0) * 100)::DECIMAL(10,2) AS ten_min_growth_rate
FROM ten_min_active_wallets;
Last run: about 2 months ago
...
1648
89KB
11s