block_timestamp::date as day

,count(DISTINCT tx_id) as tx_count

,avg(inner_instruction:instructions[1]:parsed:info:lamports/pow(10,9)) as avg_staked_sol

from solana.core.fact_events

where block_timestamp::date >= '2022-02-01'

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

and instruction:programId = 'MarBmsSgKXdrN1egZf5sqe1TMai9K1rChYNDJgjq7aD'

group by 1

order by 1