ErsvanF - VIEWS - w_detail_events - Genopets Staking
    Updated 2022-05-31
    WITH RECURSIVE w_detail_events (INDEX,TX_ID, ADDRESS, INNER_INSTRUCTION, addresses) AS
    (
    SELECT
    INDEX,
    TX_ID,
    INSTRUCTION:accounts[0] AS ADDRESS,
    INNER_INSTRUCTION,
    INSTRUCTION as addresses
    FROM
    flipside_prod_db.solana.fact_events
    WHERE
    PROGRAM_ID = 'StaKe9nb7aUjXpjpZ45o6uJBsZxj2BWCDBtjk8LCg2v'
    )
    SELECT * FROM w_detail_events LIMIT 5
    Run a query to Download Data