block_timestamp::date as date,

count(distinct inner_instruction:instructions[0]:parsed:info:source) as Unique_wallets,

count(inner_instruction:instructions[0]:parsed:type) as Total_transfers,

sum(inner_instruction:instructions[0]:parsed:info:lamports/pow(10,9)) as Staked_SOL,

count(inner_instruction:instructions[1]:parsed:type) as Total_mints,

sum(inner_instruction:instructions[1]:parsed:info:amount/pow(10,9)) as minted_mSOL

from solana.fact_events

where block_timestamp::date >= '2022-03-01' and block_timestamp::date < '2022-04-01'

and instruction:programId = 'MarBmsSgKXdrN1egZf5sqe1TMai9K1rChYNDJgjq7aD' --Marinade

and instruction:accounts[1] = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' --mSOL

and inner_instruction:instructions[0]:parsed:type = 'transfer'

group by date