Tobi_12024-05-28 02:49 PM
    Updated 2024-05-28
    SELECT
    ACCOUNT_ADDRESS,
    BLOCK_NUMBER,
    BLOCK_TIMESTAMP,
    CREATION_NUMBER,
    EVENT_ADDRESS,
    EVENT_DATA,
    EVENT_INDEX,
    EVENT_MODULE,
    EVENT_RESOURCE,
    EVENT_TYPE,
    FACT_EVENTS_ID,
    INSERTED_TIMESTAMP,
    MODIFIED_TIMESTAMP,
    PAYLOAD_FUNCTION,
    SEQUENCE_NUMBER,
    SUCCESS,
    TX_HASH,
    TX_TYPE,
    VERSION
    FROM
    aptos.core.fact_events;
    WHERE
    (EVENT_TYPE LIKE '%mint%' OR PAYLOAD_FUNCTION LIKE '%mint%')
    AND SUCCESS = TRUE
    ORDER BY
    BLOCK_TIMESTAMP DESC;

    QueryRunArchived: QueryRun has been archived