nitsUntitled Query
Updated 2022-05-27
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with ids as
(SELECT asset_id, asset_name
FROM algorand.asset
WHERE asset_name LIKE 'Al Goanna%'),
usage_ as
(SELECT asset_id as id, max(block_timestamp) as last_holder_time from algorand.transactions
where asset_id in (SELECT asset_id from ids)
GROUP by 1 )
SELECT * from algorand.payment_transaction
where asset_id in (SELECT asset_id from ids )
limit 1000
Run a query to Download Data