ErsvanGenopets Staking - Wallets have staked $GENE TABLE EVENTS
    Updated 2022-05-31
    --How many unique wallets have staked $GENE since its inception on May 18th?
    /*
    This data is from the table events in database solana where PROGRAM_IS = 'StaKe9nb7aUjXpjpZ45o6uJBsZxj2BWCDBtjk8LCg2v'
    */
    WITH RECURSIVE w_address (address,Total) AS
    (
    SELECT
    INSTRUCTION:accounts[0] AS address, COUNT(*)
    FROM
    flipside_prod_db.solana.fact_events
    WHERE
    PROGRAM_ID = 'StaKe9nb7aUjXpjpZ45o6uJBsZxj2BWCDBtjk8LCg2v'
    GROUP BY INSTRUCTION:accounts[0]
    )

    SELECT COUNT(*) AS Total_Wallets_staking FROM w_address
    Run a query to Download Data