standard69 as (

SELECT

asset_id from algorand.asset where asset_id in (

select distinct asset_id from algorand.asset_configuration_transaction where try_base64_decode_string(tx_message:txn:note::string) like '%{"standard":"arc69"%') and closed_at is null

),

standard3 as (

select distinct asset_id from algorand.asset where asset_url like '%#arc3%' and closed_at is null

),

datetimes as (

SELECT

block_timestamp,

block_id

from algorand.block

),

transactions as (

SELECT

x.asset_id,

y.block_id,

y.tx_message:txn:amt/1e6 as amount,

y.tx_id

from algorand.asset_transfer_transaction x, algorand.payment_transaction y where x.tx_group_id=y.tx_group_id and y.tx_message:txn:amt is not null

),

s69_final as (

SELECT

y.asset_id,

y.block_id,

y.tx_id,

y.amount,--ttx_message:txn:amt/1e6 as

'ARC69' as standard

from standard69 x, transactions y where x.asset_id=y.asset_id --and y.tx_message:txn:amt is not null

),

s3_final as (

SELECT

y.asset_id,

y.block_id,