princefarzamThe amount of staked $GENE overtime
Updated 2022-06-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
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