select

block_timestamp::date as date,

inner_instruction:instructions[0]:parsed:info:destination as wallet,

(inner_instruction:instructions[0]:parsed:info:amount/1e9) as amount

from solana.core.fact_events

where block_timestamp >= current_date-90

and instruction:programId = 'SSwpkEEcbUqx4vtoEByFjSkhKdCT862DNVb52nZg1UZ'

and inner_instruction:instructions[0]:parsed:info:amount is not NULL

group by 1,2,3

)

select

date,

sum(amount) as "Staked SOL"

from stake

group by 1

order by 1 desc