DAY | DOMAIN_LENGTH | TXN_COUNT | VOLUME | |
|---|---|---|---|---|
1 | 2025-03-20 00:00:00.000 | 12 | 36 | 0.003246112 |
2 | 2025-03-10 00:00:00.000 | 12 | 67 | 0.004362236 |
3 | 2025-03-19 00:00:00.000 | 10 | 51 | 0.004565044 |
4 | 2025-03-14 00:00:00.000 | 14 | 25 | 0.001951244 |
5 | 2025-03-09 00:00:00.000 | 7 | 12 | 0.000777216 |
6 | 2025-03-07 00:00:00.000 | 5 | 5 | 0.00032316 |
7 | 2025-03-17 00:00:00.000 | 8 | 30 | 0.002701784 |
8 | 2025-03-24 00:00:00.000 | 6 | 5 | 0.00046902 |
9 | 2025-03-19 00:00:00.000 | 6 | 3 | 0.000252308 |
10 | 2025-03-06 00:00:00.000 | 11 | 41 | 0.002643588 |
11 | 2025-03-17 00:00:00.000 | 10 | 63 | 0.005257396 |
12 | 2025-03-16 00:00:00.000 | 6 | 4 | 0.000375216 |
13 | 2025-03-09 00:00:00.000 | 8 | 19 | 0.001231884 |
14 | 2025-03-05 00:00:00.000 | 8 | 19 | 0.001231884 |
15 | 2025-03-12 00:00:00.000 | 14 | 55 | 0.003603788 |
16 | 2025-03-07 00:00:00.000 | 12 | 78 | 0.005078424 |
17 | 2025-03-11 00:00:00.000 | 11 | 72 | 0.004597608 |
18 | 2025-03-05 00:00:00.000 | 9 | 39 | 0.002531256 |
19 | 2025-03-04 00:00:00.000 | 8 | 24 | 0.001556064 |
20 | 2025-03-11 00:00:00.000 | 12 | 60 | 0.003863776 |
abhishek281196alldomain eclipse copy
Updated 2025-03-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
SELECT
day,
COUNT(DISTINCT signer) AS active_user,
COUNT(DISTINCT CASE WHEN rn = 1 THEN signer END) AS unique_user
FROM (
SELECT
DATE(BLOCK_TIMESTAMP) AS day,
SIGNERS[0] AS signer,
ROW_NUMBER() OVER (PARTITION BY SIGNERS[0] ORDER BY BLOCK_TIMESTAMP) AS rn
FROM eclipse.core.fact_transactions t,
LATERAL FLATTEN(input => log_messages) f
WHERE
DATE(BLOCK_TIMESTAMP) >= DATE'2025-01-01'
AND SUCCEEDED
AND f.value LIKE '%Program log: Creating new domain%'
AND ENDSWITH(f.value, '.turbo')
)
GROUP BY 1
ORDER BY 1
Last run: about 1 month ago
...
280
12KB
340s