LTirrellgen3_mints transactions
    Updated 2023-09-10
    -- forked from gen3_mints @ https://flipsidecrypto.xyz/edit/queries/b0dcc4f4-ceff-40f6-8cf5-03127a13dec8
    -- forked from barrel_mints minters @ https://flipsidecrypto.xyz/edit/queries/a9d94fa9-6729-4fe2-85d6-8c561bb91bd2
    -- forked from barrel_mints @ https://flipsidecrypto.xyz/edit/queries/b5c36594-6872-461c-969e-675862b52439
    with
    init_barrel_mints as (
    select
    instruction:accounts[6] as mint,
    null as minter,
    'initialized' as mint_type
    from
    solana.core.fact_events
    WHERE
    succeeded
    and block_timestamp > '2023-06-26'
    and program_id = 'CSGrdwbJ5z58tLGKjjcmiNMj8bG1Zazthk3cXMrbSZoX'
    and instruction:accounts[13] = 'Ce92PLCQrz2gLNAE5DFovvmpoeLBLtpTzqqeD4Px76hp' --barrel collection
    and instruction:data = 'B2ztApDvp684ifio4s' -- initialize mint
    ),
    all_barrel_mints as (
    --barrels from fcfs for Gen2 holders, and raffle winners
    select
    mint,
    tx_to as minter
    FROM
    solana.core.fact_transfers
    where
    mint in (
    SELECT
    mint
    from
    init_barrel_mints
    )
    and block_timestamp > '2023-06-26'
    and tx_from = 'smbRrq8tmAXn5ycy7qQooadtBADVduiAygmNb2VHk5u'
    union
    --barrels minted directly by gen2 holders
    Run a query to Download Data