ErsvanF - Genopets Staking - Wallets have staked and number of stakes made
    Updated 2022-05-31
    --How many unique wallets have staked $GENE since its inception on May 18th?
    WITH RECURSIVE w_address (address,Total) AS
    (
    SELECT
    SIGNERS[0] AS address,
    COUNT(*) AS TotalStaking
    FROM
    flipside_prod_db.solana.FACT_TRANSACTIONS
    WHERE
    INSTRUCTIONS[0]:programId = 'StaKe9nb7aUjXpjpZ45o6uJBsZxj2BWCDBtjk8LCg2v'
    AND LOG_MESSAGES[1] = 'Program log: Instruction: Stake'
    GROUP BY address
    )

    SELECT * FROM w_address
    Run a query to Download Data