-- forked from alldomain eclipse copy copy @ https://flipsidecrypto.xyz/studio/queries/f34e9615-e186-427f-ad33-fb35a984388e
SELECT BLOCK_TIMESTAMP,
tx_id,f.value as log_message,
FROM eclipse.core.fact_transactions t,
LATERAL FLATTEN(input => log_messages) f
WHERE
DATE(BLOCK_TIMESTAMP) = DATE'2025-05-25'
AND SUCCEEDED
AND (
f.value LIKE '%Program log: Creating new domain%'
OR f.value LIKE '%Program log: Signing for%'
)
AND ENDSWITH(f.value, '.turbo')