date | daily transactions | daily active wallets | daily fees | |
|---|---|---|---|---|
1 | 2025-01-19 00:00:00.000 | 3 | 1 | 0.22240812 |
2 | 2025-01-20 00:00:00.000 | 5 | 2 | 0.01227622 |
3 | 2025-01-21 00:00:00.000 | 20 | 10 | 0.1084078325 |
4 | 2025-01-22 00:00:00.000 | 11625 | 10186 | 1189.750862486 |
5 | 2025-01-23 00:00:00.000 | 54566 | 17294 | 116.779104147 |
6 | 2025-01-24 00:00:00.000 | 31764 | 31223 | 83.537124467 |
7 | 2025-01-25 00:00:00.000 | 7957 | 6596 | 21.808354314 |
8 | 2025-01-26 00:00:00.000 | 24230 | 19607 | 66.775960509 |
9 | 2025-01-27 00:00:00.000 | 30646 | 24843 | 84.852747278 |
10 | 2025-01-28 00:00:00.000 | 40575 | 35262 | 111.922677043 |
11 | 2025-01-29 00:00:00.000 | 76965 | 55230 | 213.558929216 |
12 | 2025-01-30 00:00:00.000 | 94539 | 54748 | 260.779989048 |
13 | 2025-01-31 00:00:00.000 | 127048 | 82549 | 341.821772706 |
14 | 2025-02-01 00:00:00.000 | 191659 | 111258 | 516.81968252 |
15 | 2025-02-02 00:00:00.000 | 68884 | 57492 | 187.736804264 |
16 | 2025-02-03 00:00:00.000 | 135264 | 79493 | 393.447980977 |
17 | 2025-02-04 00:00:00.000 | 109426 | 45203 | 327.551037514 |
18 | 2025-02-05 00:00:00.000 | 66790 | 10479 | 221.236339823 |
19 | 2025-02-06 00:00:00.000 | 19380 | 18697 | 49.224388292 |
20 | 2025-02-07 00:00:00.000 | 119517 | 20437 | 390.636052752 |
datavortexDaily
Updated 2025-02-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
SELECT
DATE_TRUNC('day', t.block_timestamp) AS "date",
COUNT(DISTINCT t.tx_hash) AS "daily transactions",
COUNT(DISTINCT t.from_address) AS "daily active wallets",
SUM(f.tx_fee) AS "daily fees"
FROM
kaia.core.fact_traces t
JOIN kaia.core.fact_transactions f ON t.tx_hash = f.tx_hash
WHERE
t.to_address IN (
'0x0d0966da8e610376f723e42fdfc7a7383a1efd05',
'0x2f0bcecce06b6eb32a83073984d0b793640aeaf6',
'0xd37f28c6c51420054b1fb1362288d07ba40440e8',
'0xb06cef4ff184f218c5318a2f2319d8a77a3b7dc2',
'0x97fa0937b99896f2415baf37ce002623dc3b905d',
'0x2e930f07b30c566e8ac7dd018ee895cfa0732a71'
)
AND t.tx_succeeded = TRUE
GROUP BY
DATE_TRUNC('day', t.block_timestamp)
ORDER BY
"date";
Last run: 2 months ago
40
2KB
34s