TEXT_DATE | TRANSACTIONCOUNT | |
|---|---|---|
1 | -01-01 | 585258 |
2 | -01-02 | 622261 |
3 | -01-03 | 525784 |
4 | -01-04 | 564910 |
5 | -01-05 | 572532 |
6 | -01-06 | 451972 |
7 | -01-07 | 385925 |
8 | -01-08 | 374621 |
9 | -01-09 | 330651 |
10 | -01-10 | 369422 |
11 | -01-11 | 396539 |
12 | -01-12 | 369694 |
13 | -01-13 | 391096 |
14 | -01-14 | 354090 |
15 | -01-15 | 323561 |
16 | -01-16 | 386665 |
17 | -01-17 | 371734 |
18 | -01-18 | 337865 |
19 | -01-19 | 470115 |
20 | -01-20 | 439576 |
SpecterDaily Transaction Trends
Updated 2025-03-01
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
--To get daily transaction count since Feb
WITH WhDAILY_TRANSACION AS
(
SELECT SUBSTR(TO_DATE(DATE_TRUNC('DAY', BLOCK_TIMESTAMP)), 5) AS Limited_Level,
COUNT(TX_HASH) AS TransactionCount
From blast.core.fact_transactions
WHERE STATUS = 'SUCCESS'
GROUP by Limited_Level
)
SELECT Limited_Level AS Text_Date, TransactionCount
FROM WhDAILY_TRANSACION
ORDER BY Limited_Level
Last run: about 2 months ago
...
366
6KB
9s