nitsALGO NFT Monthly launches
Updated 2022-06-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
with arc3 as (select * from algorand.asset
where asset_url like '%#arc3'),
arc69 as
(select * from algorand.asset
where asset_id in (select asset_id from (select try_base64_decode_string(tx_message:txn:note::string) as xyz, * from algorand.asset_configuration_transaction )
-- where tx_id like '%6Z5R47GSIMQC4JDCTRAPLPC5BTNCC5K5DJ2QKSACW4KV5RZFZDQQ%')
where xyz like '{"standard":"arc69",%')),
a3 as
( SELECT trunc(block_timestamp,'month') as mon, count(DISTINCT asset_id) as total_launched,
sum(total_launched) over (order by mon) as cumulative_launched, 'arc3' as type
from arc3
inner join algorand.block
on created_at = block_id
GROUP by 1 ),
a69 as
(SELECT trunc(block_timestamp,'month') as mon, count(DISTINCT asset_id) as total_launched,
sum(total_launched) over (order by mon) as cumulative_launched, 'arc69' as type
from arc69
inner join algorand.block
on created_at = block_id
GROUP by 1 )
SELECT * from a3
UNION ALL
SELECT * from a69
limit 100
Run a query to Download Data