date_trunc('hour',block_timestamp) as block_hour,

date_trunc('minute',block_timestamp) as block_minute,

case

when sender = 'terra1r0aav8sjxakmedwe8ds43juj4qj6fe09rddkeh' then 'me'

else 'everyone else'

end as depositor,

count(*) as transaction_count -- * in count() means count 'all results' in query

from anchor.deposits

where block_hour = '2022-01-30 18:00:00.000'

group by block_hour, block_minute, depositor