ErsvanF - VIEWS - TYPES OF LOG_MESSAGES - Genopets Staking
    Updated 2022-05-31
    SELECT
    LOG_MESSAGES[1] AS LOG_MESSAGES,
    COUNT(*) AS TOTAL
    FROM
    flipside_prod_db.solana.FACT_TRANSACTIONS
    WHERE
    INSTRUCTIONS[0]:programId = 'StaKe9nb7aUjXpjpZ45o6uJBsZxj2BWCDBtjk8LCg2v'
    GROUP BY LOG_MESSAGES[1]

    Run a query to Download Data