COUNT(DISTINCT TX_ID) | SUM(VOLUME) | |
|---|---|---|
1 | 3824 | 8.222607712 |
abhishek281196dom base 2 copy
Updated 2025-05-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from alldomain eclipse copy copy @ https://flipsidecrypto.xyz/studio/queries/6502bba7-396c-49d8-bf6c-a79eb2b26714
-- forked from alldomain eclipse copy @ https://flipsidecrypto.xyz/studio/queries/5226b7d7-4e81-44a5-873f-b1e90b99923d
select count(distinct tx_id),sum(volume)
from
(SELECT
distinct DATE(BLOCK_TIMESTAMP) AS day,tx_id,
SPLIT_PART(
SPLIT_PART(
f.value,
CASE
WHEN f.value LIKE '%Program log: Creating new domain%' THEN 'Creating new domain '
ELSE 'Signing for '
END,
2
),
'.',
1
) AS domain,
(
(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-03-19'
AND SUCCEEDED
AND (
f.value LIKE '%Program log: Creating new domain%'
OR f.value LIKE '%Program log: Signing for%'
)
AND ENDSWITH(f.value, '.turbo')
)
Last run: 28 days ago
1
20B
44s