princefarzamThe amount of staked $GENE overtime
    Updated 2022-06-04
    SELECT
    DATE_TRUNC('DAY',BLOCK_TIMESTAMP)::DATE AS DAY,
    COUNT(DISTINCT INSTRUCTION:accounts[0]::string) AS Unique_Stakers,
    sum(INNER_INSTRUCTION:instructions[2]:parsed:info:amount)/1e9 AS Stake_amount
    FROM flipside_prod_db.solana.fact_events
    WHERE PROGRAM_ID='StaKe9nb7aUjXpjpZ45o6uJBsZxj2BWCDBtjk8LCg2v'
    AND INDEX= 3
    AND INSTRUCTION:accounts[3]::string='GENEtH5amGSi8kHAtQoezp1XEXwZJ8vcuePYnXdKrMYz' --GENE account
    AND INSTRUCTION:accounts[8]::string='GkpbHQu2zYmJxyp93p9wTX3uHjsFt8ZGeomVwZkGwXLH' --sGENE account
    AND BLOCK_TIMESTAMP <= '2022-06-01'
    GROUP BY 1
    ORDER BY 1 ASC
    Run a query to Download Data