DAILY | Transactions | Blocks | Cumulative Blocks | |
|---|---|---|---|---|
1 | 2025-02-10 00:00:00.000 | 150 | 50 | 4028 |
2 | 2024-12-24 00:00:00.000 | 72 | 24 | 3199 |
3 | 2024-12-13 00:00:00.000 | 6 | 2 | 14 |
4 | 2025-02-04 00:00:00.000 | 15 | 5 | 3880 |
5 | 2024-12-20 00:00:00.000 | 1671 | 251 | 3088 |
6 | 2025-01-18 00:00:00.000 | 72 | 24 | 3816 |
7 | 2025-04-04 00:00:00.000 | 15738 | 5024 | 327212 |
8 | 2025-01-04 00:00:00.000 | 72 | 24 | 3458 |
9 | 2025-03-31 00:00:00.000 | 21130 | 9100 | 295305 |
10 | 2025-02-13 00:00:00.000 | 434 | 147 | 4534 |
11 | 2025-02-17 00:00:00.000 | 460 | 156 | 5112 |
12 | 2025-02-16 00:00:00.000 | 155 | 52 | 4956 |
13 | 2025-03-02 00:00:00.000 | 7258 | 2424 | 15628 |
14 | 2025-01-10 00:00:00.000 | 72 | 24 | 3605 |
15 | 2025-03-22 00:00:00.000 | 34775 | 10703 | 223893 |
16 | 2025-03-24 00:00:00.000 | 26815 | 8655 | 239836 |
17 | 2025-01-02 00:00:00.000 | 69 | 23 | 3410 |
18 | 2025-04-19 00:00:00.000 | 51490 | 13931 | 488524 |
19 | 2025-02-11 00:00:00.000 | 547 | 187 | 4215 |
20 | 2025-04-12 00:00:00.000 | 38915 | 11283 | 386402 |
Movement Team0. Transactions (Day)
Updated 2 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with base as (Select
date_trunc('day',BLOCK_TIMESTAMP) as daily,
count(*) as "Transactions",
sum("Transactions") over (order by daily asc) as "Cumulative Transactions"
from movement.core.fact_transactions
where SUCCESS = 'TRUE'
group by 1)
,
blocks as ( select date_trunc('day',BLOCK_TIMESTAMP) as daily,
count(distinct BLOCK_NUMBER) as "Blocks",
sum("Blocks") over (order by daily asc) as "Cumulative Blocks"
from movement.core.fact_blocks
group by 1
)
select a.daily,
"Transactions",
"Blocks",
"Cumulative Blocks"
from base a left outer join blocks b on a.daily = b.daily
Last run: 2 days ago
...
113
5KB
1s