LTirrellUntitled Query
Updated 2022-01-23
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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- select *, try_base64_decode_string(tx_message :txn :note) as note
-- from algorand.asset_configuration_transaction
-- where tx_id = '6Z5R47GSIMQC4JDCTRAPLPC5BTNCC5K5DJ2QKSACW4KV5RZFZDQQ'
-- select asset_id, asset_name, created_at, creator_address, closed_at
-- from algorand.asset where total_supply = 1 and asset_url like '%#arc3' and closed_at is NULL
-- limit 10
-- select * from algorand.asset
-- where asset_id=326189642
-- limit 10
-- with arc69 as (
-- select
-- asset_id,
-- block_id,
-- try_base64_decode_string(tx_message :txn :note :: string) as note,
-- 'arc69' as asset_type,
-- asset_supply,
-- tx_id
-- from
-- algorand.asset_configuration_transaction
-- where
-- try_parse_json(note) :standard = 'arc69'
-- )
-- select
-- arc69.*, a.closed_at
-- from
-- arc69
-- inner join algorand.asset a on (arc69.asset_id=a.asset_id and a.closed_at is NULL)
with datetime_info as (
select
block_id,
block_timestamp
from
algorand.block
),
Run a query to Download Data