shadilGenopets Staking - total staked GENE
    Updated 2022-05-29
    SELECT
    round(sum(zeroifnull(INNER_INSTRUCTION:instructions[1]:parsed:info:amount) + zeroifnull(INNER_INSTRUCTION:instructions[2]:parsed:info:amount))::float/1e9, 2) as staked_amount,
    count(DISTINCT INSTRUCTION:accounts[0]::string) as wallets_count
    from flipside_prod_db.solana.fact_events
    WHERE PROGRAM_ID = 'StaKe9nb7aUjXpjpZ45o6uJBsZxj2BWCDBtjk8LCg2v'
    -- and tx_id = '3HMo5PDQvEeDigWnsDNUBgqvGUPGem4KD7P85NFw5Xp5Gyw4aSZZUmpwaN1X2Rwr4oX643NHuH75BLbJR1BYaTv1' -- sample stake tx
    and date(block_timestamp) >= '2022-05-18'
    Run a query to Download Data