masoud-mojUntitled Query
Updated 2022-02-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
apt.block_id,
apt.sender,
apt.asset_receiver,
date_trunc('hour',ab.block_timestamp) as block_hour,
case
when apt.sender = 'AC6XF5QGE3IGW7ZVUOYUDZ3IZOA3SNB6G7RHONK22HCPBPMOPVQMQYIVHY' then 'me'
else 'others' end as transaction_sender
from algorand.asset_transfer_transaction apt
left join algorand.block ab
on ab.block_id = apt.block_id
where apt.asset_receiver = 'FMBXOFAQCSAD4UWU4Q7IX5AV4FRV6AKURJQYGXLW3CTPTQ7XBX6MALMSPY'
and apt.block_timestamp::date = '2021-11-25'
group by block_hour, transaction_sender
Run a query to Download Data