SELECT
date_trunc('hour',ab.block_timestamp) as block_hour,
case
when apt.sender = 'T3KUK2B4TZANYKKPISBBKVBKFIDFNGKXLEXHM26DQAGD3SOC3MGN6TVHWA' 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-01'
group by block_hour, transaction_sender