ChiefCursory exploration
    Updated 2023-04-13
    -- -- DESCRIBE TABLE solana.core.fact_transactions;
    -- DESCRIBE TABLE solana.core.fact_transactions;

    -- instructions:program_id

    SELECT *
    FROM solana.core.fact_events
    WHERE program_id = '8BnEgHoWFysVcuFFX7QztDmzuH8r5ZFvyP3sYwn1XTh6'
    LIMIT 20
    -- with agg as (
    -- SELECT tx.tx_id, program_id, log_messages, account_keys, inner_instructions, instructions, signers
    -- FROM solana.core.fact_transactions as tx
    -- JOIN (SELECT tx_id, program_id FROM solana.core.fact_events WHERE program_id = '4MangoMjqJ2firMokCjjGgoK8d4MXcrgL7XJaL3w6fVg' AND block_timestamp >= current_date - 1 ORDER BY tx_id) e
    -- ON tx.tx_id = e.tx_id
    -- WHERE block_timestamp >= current_date - 10
    -- -- LIMIT 25
    -- )
    -- -- ,

    -- -- agg1 as (
    -- SELECT log.value as value
    -- FROM agg, lateral flatten(input => agg.log_messages) as log
    -- -- WHERE NOT (value ~ 'TokenUpdateIndexAndRate|PerpUpdateFunding|PerpPlaceOrder|PerpCancelAllOrders')
    -- WHERE value NOT LIKE '%TokenUpdateIndexAndRate%'
    -- AND value NOT LIKE '%TokenLiqWithToken%'
    -- AND value NOT LIKE '%liquidated%'
    -- AND value NOT LIKE '%TokenLiqBankruptcy%'
    -- AND value NOT LIKE '%CreateOrder%'
    -- AND value NOT LIKE '%insufficient funds%'
    -- AND value NOT LIKE '%Withdraw%'
    -- AND value NOT LIKE '%Deposit%'
    -- AND value NOT LIKE '%Burn%'
    -- AND value NOT LIKE '%PerpUpdateFunding%'
    -- AND value NOT LIKE '%PerpDeactivatePosition%'
    -- AND value NOT LIKE '%PerpPlaceOrder%'
    -- AND value NOT LIKE '%PerpSettlePnl%'
    Run a query to Download Data