DAY | NUMBER_OF_TX | |
---|---|---|
1 | 2024-12-06 00:00:00.000 | 31188 |
2 | 2024-12-07 00:00:00.000 | 86402 |
3 | 2024-12-08 00:00:00.000 | 86402 |
4 | 2024-12-09 00:00:00.000 | 86475 |
5 | 2024-12-10 00:00:00.000 | 86430 |
6 | 2024-12-11 00:00:00.000 | 86596 |
7 | 2024-12-12 00:00:00.000 | 86686 |
8 | 2024-12-13 00:00:00.000 | 86637 |
9 | 2024-12-14 00:00:00.000 | 86537 |
10 | 2024-12-15 00:00:00.000 | 86508 |
11 | 2024-12-16 00:00:00.000 | 87083 |
12 | 2024-12-17 00:00:00.000 | 102672 |
13 | 2024-12-18 00:00:00.000 | 120546 |
14 | 2024-12-19 00:00:00.000 | 114781 |
15 | 2024-12-20 00:00:00.000 | 103046 |
16 | 2024-12-21 00:00:00.000 | 99087 |
17 | 2024-12-22 00:00:00.000 | 99128 |
18 | 2024-12-23 00:00:00.000 | 103033 |
19 | 2024-12-24 00:00:00.000 | 114504 |
20 | 2024-12-25 00:00:00.000 | 115239 |
Updated 2025-01-29
9
1
2
3
›
⌄
SELECT BLOCK_TIMESTAMP::date as day, count (DISTINCT TX_HASH) as number_of_TX
from ink.core.fact_transactions
GROUP by 1 order by 1
Last run: 27 days ago
55
2KB
7s