date_trunc(week,block_timestamp)::date as date ,

sum(zeroifnull(INNER_INSTRUCTION:instructions[1]:parsed:info:amount))/1e9 as staked_amount ,

count (DISTINCT INNER_INSTRUCTION:instructions[1]:parsed:info:authority) num_stakers ,

count (DISTINCT tx_id) as num_stake,

sum (num_stake) over (order by date) as cum_stake

from solana.core.fact_events

where program_id ='STkwf3sbMapjy7KV3hgrJtcVvY4SvRxWQ8pj4Enw1i5'

and SUCCEEDED = true

and INNER_INSTRUCTION:instructions[0]:parsed:info:mintAuthority = 'FysGks3izhgVhrUkub9QQWCTEVAdhkZKYSNK2F25maGD'

group by 1