farokhtiabMy Anchor Deposit in Context
    Updated 2023-03-27
    select
    date_trunc('hour',block_timestamp) as block_hour,
    date_trunc('minute',block_timestamp) as block_minute,
    case
    when sender = 'terra1ft94vtqpnh9q7agzxlnkjk7gtrrmeth2ev8f29' then 'me'
    else 'everyone else'
    end as depositor,
    count(*) as transaction_count
    from anchor.deposits
    where block_hour = '2022-01-29 03:00:00.000'
    group by block_hour, block_minute, depositor
    Run a query to Download Data