DAY | DAILY_TRANSACTIONS | DAILY_BLOCKS | DAILY_SUCCESS_RATE_PERCENTAGE | DAILY_PROGRAMS | AVG_TX_PER_BLOCK | AVG_TIME_BETWEEN_BLOCKS_SECONDS | CUMULATIVE_TRANSACTIONS | CUMULATIVE_BLOCKS | AVG_SUCCESS_RATE_PERCENTAGE | CUMULATIVE_AVG_TX_PER_BLOCK | CUMULATIVE_AVG_TIME_BETWEEN_BLOCKS_SECONDS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2024-09-04 00:00:00.000 | 7 | 1778 | 100 | 1 | 0.003937 | 18.232414 | 7 | 1778 | 100 | 0.003937 | 18.232414 |
2 | 2024-09-05 00:00:00.000 | 520 | 29652 | 99.294533 | 17 | 0.018211 | 2.913763 | 527 | 31430 | 99.6472665 | 0.011074 | 10.5730885 |
3 | 2024-09-06 00:00:00.000 | 745 | 29796 | 98.849105 | 16 | 0.025305 | 2.899782 | 1272 | 61226 | 99.381212666667 | 0.015817666667 | 8.015319666667 |
4 | 2024-09-07 00:00:00.000 | 970 | 29930 | 99.794872 | 4 | 0.032409 | 2.886699 | 2242 | 91156 | 99.4846275 | 0.0199655 | 6.7331645 |
5 | 2024-09-08 00:00:00.000 | 1513 | 30100 | 99.478827 | 5 | 0.050266 | 2.870328 | 3755 | 121256 | 99.4834674 | 0.0260256 | 5.9605972 |
6 | 2024-09-09 00:00:00.000 | 1099 | 30623 | 99.284436 | 5 | 0.035888 | 2.821468 | 4854 | 151879 | 99.4502955 | 0.027669333333 | 5.437409 |
7 | 2024-09-10 00:00:00.000 | 2076 | 29944 | 99.811942 | 17 | 0.06943 | 2.885382 | 6930 | 181823 | 99.501959285714 | 0.033635142857 | 5.072833714286 |
8 | 2024-09-11 00:00:00.000 | 2494 | 28864 | 98.445998 | 34 | 0.08696 | 2.993313 | 9424 | 210687 | 99.369964125 | 0.04030075 | 4.812893625 |
9 | 2024-09-12 00:00:00.000 | 2558 | 28705 | 98.894817 | 28 | 0.089322 | 3.009929 | 11982 | 239392 | 99.31717 | 0.045747555556 | 4.612564222222 |
10 | 2024-09-13 00:00:00.000 | 3110 | 30114 | 96.607579 | 28 | 0.103473 | 2.869126 | 15092 | 269506 | 99.0462109 | 0.0515201 | 4.4382204 |
11 | 2024-09-14 00:00:00.000 | 3627 | 30166 | 99.424184 | 6 | 0.120235 | 2.864114 | 18719 | 299672 | 99.080572090909 | 0.057766909091 | 4.295119818182 |
12 | 2024-09-15 00:00:00.000 | 3518 | 30192 | 99.246021 | 12 | 0.116521 | 2.861648 | 22237 | 329864 | 99.0943595 | 0.062663083333 | 4.175663833333 |
13 | 2024-09-16 00:00:00.000 | 4302 | 29924 | 99.398983 | 9 | 0.143898 | 2.887344 | 26539 | 359788 | 99.117792076923 | 0.068911923077 | 4.076562307692 |
14 | 2024-09-17 00:00:00.000 | 4869 | 29640 | 99.060841 | 6 | 0.164271 | 2.914909 | 31408 | 389428 | 99.113724142857 | 0.075723285714 | 3.993587071429 |
15 | 2024-09-18 00:00:00.000 | 6655 | 29787 | 98.524039 | 23 | 0.223688 | 2.900658 | 38063 | 419215 | 99.0744118 | 0.0855876 | 3.920725133333 |
16 | 2024-09-19 00:00:00.000 | 86227 | 30274 | 99.820552 | 19 | 2.84822 | 2.853962 | 124290 | 449489 | 99.1210455625 | 0.258252125 | 3.8540524375 |
17 | 2024-09-20 00:00:00.000 | 76646 | 28908 | 99.760868 | 14 | 2.651377 | 2.988826 | 200936 | 478397 | 99.158682176471 | 0.399024176471 | 3.803156764706 |
18 | 2024-09-21 00:00:00.000 | 10568 | 29133 | 99.106222 | 28 | 0.36275 | 2.965708 | 211504 | 507530 | 99.155767722222 | 0.397008944444 | 3.756631833333 |
19 | 2024-09-22 00:00:00.000 | 8009 | 28834 | 99.219378 | 18 | 0.277762 | 2.996497 | 219513 | 536364 | 99.159115631579 | 0.390732789474 | 3.716624736842 |
20 | 2024-09-23 00:00:00.000 | 8681 | 29442 | 98.037354 | 27 | 0.294919 | 2.934615 | 228194 | 565806 | 99.10302755 | 0.3859421 | 3.67752425 |
js699aleo dash 2
Updated 2025-04-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH transaction_stats AS (
SELECT
DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS day,
COUNT(DISTINCT TX_ID) AS daily_transactions,
COUNT(CASE WHEN SUCCEEDED = TRUE THEN 1 END) * 100 / COUNT(*) AS daily_success_rate_percentage,
COUNT(DISTINCT program_id) as daily_programs
FROM aleo.core.fact_transitions
GROUP BY day
),
block_stats AS (
SELECT
DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS day,
COUNT(DISTINCT BLOCK_ID) AS daily_blocks,
AVG(TX_COUNT) AS avg_tx_per_block
FROM aleo.core.fact_blocks
GROUP BY day
),
block_time_diffs AS (
SELECT
DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS day,
DATEDIFF(SECOND,
LAG(BLOCK_TIMESTAMP) OVER (PARTITION BY DATE_TRUNC('DAY', BLOCK_TIMESTAMP) ORDER BY BLOCK_TIMESTAMP),
BLOCK_TIMESTAMP) AS time_diff_seconds
FROM aleo.core.fact_blocks
),
block_time_stats AS (
SELECT
day,
AVG(time_diff_seconds) AS avg_time_between_blocks_seconds
FROM block_time_diffs
WHERE time_diff_seconds IS NOT NULL
GROUP BY day
),
cumulative_stats AS (
SELECT
t.day,
Last run: about 1 month ago
...
239
31KB
4s