LTirrellxNFT_all_summary_with_old
    Updated 2023-03-15
    with
    all_data as (
    select
    block_timestamp,
    block_id,
    tx_id,
    instructions[0]:accounts[0] as xnft, -- only the xNFT account for certain instructions
    instructions[0]:data as program_data, -- can be used to find instruction name
    case
    when program_data = '7tyNegi96Ez' then 'createInstall'
    else program_data
    end as instruction_type,
    instructions[0]:programId as programId,
    signers[0] as fee_payer,
    succeeded,
    instructions[0]:accounts as all_accounts -- unparsed account info
    from
    solana.core.fact_transactions
    where
    programId in (
    'xnft5aaToUM4UFETUQfj7NUDUBdvYHTVhNFThEYTm55',
    'BaHSGaf883GA3u8qSC5wNigcXyaScJLSBJZbALWvPcjs'
    )
    and block_timestamp::date > current_date - 90
    order by
    block_timestamp desc
    )
    -- select
    -- count(distinct tx_id) as count,
    -- programId
    -- from all_data
    -- where instruction_type = 'createInstall'
    -- group by programId

    select
    block_timestamp::date as date,
    Run a query to Download Data