select
date_trunc('hours', block_timestamp) as hours,
case when sender = 'V3WKMY7WTOUYXGB5PAPICM5FOEQVZ4C62ZZC6U3WO2EPRIJFSTHS3TNV2A' then 'me' else 'others' end as transaction_sender,
count(*) as transaction_count
from algorand.asset_transfer_transaction
where asset_receiver = 'FMBXOFAQCSAD4UWU4Q7IX5AV4FRV6AKURJQYGXLW3CTPTQ7XBX6MALMSPY'
and tx_type = 'axfer'
and block_timestamp::date = '2022-01-24'
group by hours, transaction_sender