LTirrellUntitled Query
    Updated 2022-01-23
    -- 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