-- date_trunc('day',block_timestamp) as block_day,

date_trunc('day',block_timestamp) as block_day,

case

when sender = 'terra1amr42cacpt6jjspctxjalehsulx30nmvpp4uhx' 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_day between '2021-12-04 13:35:37' and '2022-01-06 13:35:37'

group by block_day, depositor