date_trunc('day',block_timestamp) as block_day,

date_trunc('hour',block_timestamp) as block_hour,

case when tx_id = '4HR8UifpeXmFQwuPvyxa5H3xnhBpJmebFe1ewiPb94xye4ZMnxBi752N5w5fX9iqqCvqFAGFX1YkKaJaCAP89T6F' then 'me'

else 'everyone else' end as staker,

-- these three aren't involved in grouping or aggregating, let's remove them:

--instruction:programId as programid,

--inner_instruction:instructions[0]:parsed:info:source as source,

--inner_instruction:instructions[0]:parsed:info:amount / 1e9 as amount,

count(*) as stake_count

from solana.events

where date_trunc('day', block_timestamp) = '2022-02-18 00:00:00.000'

and instruction:programId = 'MarBmsSgKXdrN1egZf5sqe1TMai9K1rChYNDJgjq7aD'

and ( inner_instruction:instructions[0]:parsed:info:source = '7GgPYjS5Dza89wV6FpZ23kUJRG5vbQ1GM25ezspYFSoE' or inner_instruction:instructions[0]:parsed:info:destination = 'Du3Ysj1wKbxPKkuPPnvzQLQh8oMSVifs3jGZjJWXFmHN' )

and succeeded = TRUE

group by block_day, block_hour, staker;