-- forked from devops_pyth_ci_checker @ https://flipsidecrypto.xyz/edit/queries/96fcb6dc-b096-4969-b41f-4d6c5f202761

    WITH e AS (
    SELECT tx_id AS e_id
    FROM solana.core.fact_events
    WHERE block_timestamp >= CURRENT_DATE - 1
    AND program_id = 'FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe4975bi2epH'
    AND instruction:accounts[1] = 'Gnt27xtC473ZT2Mw5u8wZ68Z3gULkSTb5DuxJy7eJotD'
    )

    SELECT *
    FROM solana.core.fact_transactions t
    JOIN e ON e.e_id = t.tx_id
    WHERE block_timestamp >= CURRENT_DATE - 1
    LIMIT 100


    Run a query to Download Data