the amount of wallets which are staking SOL

jacobhpthe amount of wallets which are staking SOL

Updated 2022-05-23

select block_timestamp::date as day,

sum(inner_instruction:instructions[0]:parsed:info:amount/POW(10,9)) as mSOLamount

from solana.fact_events

where date_trunc('day', block_timestamp) Between '2022-03-01' and '2022-03-31'

and instruction:programId = 'MarBmsSgKXdrN1egZf5sqe1TMai9K1rChYNDJgjq7aD'

and inner_instruction:instructions[0]:parsed:info:source = '7GgPYjS5Dza89wV6FpZ23kUJRG5vbQ1GM25ezspYFSoE'

group by day

order by day

Run a query to Download Data

flipside