date | daily logins | daily Log in Users | |
|---|---|---|---|
1 | 2025-01-27 00:00:00.000 | 1 | 2 |
2 | 2025-01-28 00:00:00.000 | 1 | 1 |
3 | 2025-01-29 00:00:00.000 | 11168 | 11168 |
4 | 2025-01-30 00:00:00.000 | 27889 | 27988 |
5 | 2025-01-31 00:00:00.000 | 42957 | 43849 |
6 | 2025-02-01 00:00:00.000 | 74382 | 75206 |
7 | 2025-02-02 00:00:00.000 | 52697 | 53332 |
8 | 2025-02-03 00:00:00.000 | 43596 | 45174 |
9 | 2025-02-04 00:00:00.000 | 23764 | 24259 |
10 | 2025-02-05 00:00:00.000 | 10473 | 11029 |
11 | 2025-02-06 00:00:00.000 | 18627 | 18684 |
12 | 2025-02-07 00:00:00.000 | 20403 | 20796 |
13 | 2025-02-08 00:00:00.000 | 102785 | 107056 |
14 | 2025-02-09 00:00:00.000 | 123014 | 123282 |
15 | 2025-02-10 00:00:00.000 | 6315 | 6359 |
16 | 2025-02-11 00:00:00.000 | 13393 | 13784 |
17 | 2025-02-12 00:00:00.000 | 11630 | 11648 |
18 | 2025-02-13 00:00:00.000 | 11158 | 11167 |
19 | 2025-02-14 00:00:00.000 | 12584 | 12602 |
20 | 2025-02-15 00:00:00.000 | 14842 | 14852 |
datavortexDaily Log Ins
Updated 2025-02-27
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
DATE_TRUNC('day', block_timestamp) AS "date",
COUNT(DISTINCT from_address) AS "daily logins",
COUNT(DISTINCT tx_hash) AS "daily Log in Users"
FROM
kaia.core.fact_traces
WHERE
to_address = '0x2e930f07b30c566e8ac7dd018ee895cfa0732a71'
GROUP BY
1
ORDER BY
1;
Last run: 2 months ago
28
1KB
3s