SELECT *

FROM FLOW.CORE.FACT_EVENTS

WHERE EVENT_CONTRACT LIKE 'flow' AND EVENT_TYPE LIKE 'AccountCreated' AND TX_SUCCEEDED

)

SELECT TX_ID, BLOCK_TIMESTAMP, EVENT_CONTRACT, EVENT_TYPE, EVENT_DATA:address::TEXT as ADDRESS

FROM ACCOUNT_CREATION

WHERE ADDRESS LIKE "0xecfad18ba9582d4f"