ChiefZeta Markets
    Updated 2023-03-31
    -- if two here are tx's that means it is a transfer
    -- this tx looks like perp-funding payment 4eg4GMY8YVgq9XRcRUftm3goVSLDHtEPqZEgLfP731BRAtxcuvtaJaNkMPZUFminnr9zJ4ExZLKhW374H2TJa7eH
    with
    events as (
    SELECT
    tx_id
    -- index
    -- inner_instruction
    FROM
    solana.core.fact_events as e
    WHERE
    program_id = 'ZETAxsqBRek56DhiGXrn75yj2NHU3aYUnxvHXpkf3aD'
    AND block_timestamp > current_date - 5
    AND succeeded = True
    -- AND tx_id = '4aSbEzqLEpsmXuHB28ndTbCqsdmgfLF9H2MgqocgKVzo4WereTcU5jfDcVwgHhYigEX7onevQt7e5AgDa3wsxZmJ'
    ORDER BY
    tx_id
    -- LIMIT
    -- 150
    ),
    txs as (
    SELECT
    -- REGEXP_SUBSTR(log_messages, 'CrankEventQueue') AS log_message_array,
    -- Instruction: Deposit,
    -- split(log_messages[1], ':') [1] as sequence,
    -- split(log_messages[1], ':') [2] as perp_order,
    -- split(log_messages[2], ':') [2] as perp_price,
    -- split(log_messages[3], ':') [1] as prune_orders,
    log_messages,
    t.tx_id,
    block_timestamp
    FROM
    solana.core.fact_transactions t
    JOIN events ON t.tx_id = events.tx_id
    WHERE
    1 = 1
    Run a query to Download Data