--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