cryptonerd-iBCnogSwapFactory.KeyAdded
    Updated 2024-04-25
    WITH KEY_ADDED AS (
    SELECT *
    FROM FLOW.CORE.FACT_EVENTS
    WHERE EVENT_CONTRACT LIKE 'flow' AND EVENT_TYPE LIKE 'AccountKeyAdded'
    LIMIT 100
    )

    SELECT TX_ID, BLOCK_TIMESTAMP, EVENT_CONTRACT, EVENT_TYPE, EVENT_DATA:address::TEXT as ADDRESS
    FROM KEY_ADDED
    WHERE ADDRESS LIKE '0xc7a4476eb54ca0bd'
    QueryRunArchived: QueryRun has been archived