DAY | DOMAIN_LENGTH | TXN_COUNT | VOLUME | |
|---|---|---|---|---|
1 | 2025-01-11 00:00:00.000 | 8 | 185 | 0.019037887 |
2 | 2025-01-19 00:00:00.000 | 11 | 391 | 0.037488796 |
3 | 2025-01-19 00:00:00.000 | 9 | 232 | 0.026153173 |
4 | 2025-01-25 00:00:00.000 | 12 | 296 | 0.029053758 |
5 | 2025-01-06 00:00:00.000 | 10 | 480 | 0.044090376 |
6 | 2025-01-11 00:00:00.000 | 9 | 254 | 0.024902884 |
7 | 2025-01-02 00:00:00.000 | 12 | 487 | 0.042907516 |
8 | 2025-01-11 00:00:00.000 | 14 | 527 | 0.04582146 |
9 | 2025-01-07 00:00:00.000 | 10 | 515 | 0.053165652 |
10 | 2025-01-30 00:00:00.000 | 7 | 84 | 0.007420872 |
11 | 2025-01-24 00:00:00.000 | 11 | 259 | 0.026674347 |
12 | 2025-01-25 00:00:00.000 | 5 | 5 | 0.000439576 |
13 | 2025-01-16 00:00:00.000 | 5 | 7 | 0.000627048 |
14 | 2025-01-02 00:00:00.000 | 14 | 526 | 0.044735695 |
15 | 2025-01-04 00:00:00.000 | 12 | 513 | 0.054345058 |
16 | 2025-01-07 00:00:00.000 | 7 | 154 | 0.01352496 |
17 | 2025-01-06 00:00:00.000 | 6 | 59 | 0.01039158 |
18 | 2025-01-04 00:00:00.000 | 13 | 827 | 0.07251227 |
19 | 2025-01-17 00:00:00.000 | 11 | 403 | 0.036019168 |
20 | 2025-01-31 00:00:00.000 | 15 | 1435 | 0.124646293 |
abhishek281196alldomain eclipse copy copy 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
22
›
⌄
-- forked from alldomain eclipse copy copy @ https://flipsidecrypto.xyz/studio/queries/f34e9615-e186-427f-ad33-fb35a984388e
SELECT
DATE(BLOCK_TIMESTAMP) AS day,
LENGTH(SPLIT_PART(SPLIT_PART(f.value, 'Creating new domain ', 2), '.', 1)) AS domain_length,
COUNT(distinct SPLIT_PART(SPLIT_PART(f.value, 'Creating new domain ', 2), '.', 1)) AS txn_count,
SUM(PRE_BALANCES[0] - POST_BALANCES[0]) / 1e9 AS volume
FROM eclipse.core.fact_transactions t,
LATERAL FLATTEN(input => log_messages) f
WHERE
DATE(BLOCK_TIMESTAMP) >= DATE'2025-01-01' and DATE(BLOCK_TIMESTAMP) < DATE'2025-02-01'
AND SUCCEEDED
AND f.value LIKE '%Program log: Creating new domain%'
AND ENDSWITH(f.value, '.turbo')
GROUP BY 1,2
Last run: about 1 month ago
...
348
16KB
399s