date_trunc('hour',ab.block_timestamp) as block_hour,

case

when apt.sender = 'JAFKXQEQMFP7NISLI3TX2JCYMYROQQNR7UFIHLY7X3TUC47ICR5A742DH4' then 'me'

else 'others' end as transaction_sender,

count(*) as transaction_count

from algorand.asset_transfer_transaction apt

left join algorand.block ab

on ab.block_id = apt.block_id

where apt.asset_receiver = 'FMBXOFAQCSAD4UWU4Q7IX5AV4FRV6AKURJQYGXLW3CTPTQ7XBX6MALMSPY'

and apt.block_timestamp::date = '2022-02-06'

group by block_hour, transaction_sender