mohammad23Untitled Query
Updated 2022-01-30
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
date_trunc('hour',block_timestamp) as block_hour,
date_trunc('minute',block_timestamp) as block_minute,
case
when sender = 'terra1esqrrjp9tsev7cq6092pvkgs2er89nqpz3mykr' then 'me'
else 'everyone else'
end as depositor,
count(*) as transaction_count
from anchor.deposits
where block_hour = '2022-01-28 14:00:00.000'
group by block_hour, block_minute, depositor