crypto_edgar2024-05-05 12:53 PM
    Updated 2024-05-05
    -- 6aLonYaGPjTnnbUGtcQKMtmS4gi3uRy9aEpV53BYHERW
    -- SELECT
    -- INSTRUCTION:accounts[7] AS TICKET_ADDRESS
    -- FROM
    -- solana.core.fact_events
    -- WHERE
    -- BLOCK_TIMESTAMP >= '2024-04-06'
    -- AND BLOCK_TIMESTAMP <= '2024-04-21'
    -- AND SUCCEEDED
    -- AND PROGRAM_ID = 'TFCGs5oBAZmVNTsGWPMquE8uqXUtZt6zRY1LBxQs35G'
    -- AND SIGNERS [2] = 'AqaY1ZEFrZ5cPoEEHS48fPG4ctkrBweUKxWztqL2Y9Vj'
    -- AND INNER_INSTRUCTION:instructions[0]:parsed:type = 'transfer'
    -- AND INNER_INSTRUCTION:instructions[0]:parsed:info:lamports = 100000000
    -- AND TX_ID = 'AXbgTm4eiJscY5YNZCmRfsaKtzjJs29nGnhs2EAKcBAmaXuGQsWzwDNfeNgK5BXbt4DKAFhg2dBqztUbFFVPGBx'

    SELECT
    INSTRUCTION:accounts[5] AS TICKET_ADDRESS
    FROM
    solana.core.fact_events
    WHERE
    PROGRAM_ID = 'WAFFcc6NZowztN8mFeEdct8sSNr8CVAf9gqmBMcr8S2'
    AND BLOCK_TIMESTAMP >= '2024-04-01'
    AND BLOCK_TIMESTAMP <= '2024-04-21'
    AND SIGNERS [2] = 'AqaY1ZEFrZ5cPoEEHS48fPG4ctkrBweUKxWztqL2Y9Vj'
    AND SUCCEEDED
    AND array_size(INNER_INSTRUCTION:instructions) = 3
    AND INNER_INSTRUCTION:instructions [2] :parsed:type = 'transfer'
    LIMIT 5
    QueryRunArchived: QueryRun has been archived