PapasotSTBL Algofi
Updated 2022-02-17
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
date_trunc('day',block_timestamp) as Date,
(count(DISTINCT(sender))) as Wallets,
sum(asset_amount)/1000000 as Total_Amount
from algorand.asset_transfer_transaction
WHERE
asset_receiver = 'OPY7XNB5LVMECF3PHJGQV2U33LZPM5FBUXA3JJPHANAG5B7GEYUPZJVYRE' AND
asset_id = 465865291 AND
date(block_timestamp) > '2021-12-16' and date(block_timestamp) < '2022-02-02'
group by Date
order by Date
Run a query to Download Data