flipside_prod_db.algorand.asset.asset_name as asset,

date(block_timestamp) as date

from flipside_prod_db.algorand.transfers join flipside_prod_db.algorand.asset

on flipside_prod_db.algorand.transfers.asset_id = flipside_prod_db.algorand.asset.asset_id

where flipside_prod_db.algorand.transfers.asset_id in (552647097, 552719953, 552888874)

and block_timestamp::date > current_date -90

and tx_group_id in (select tx_group_id

from (select tx_group_id from flipside_prod_db.algorand.application_call_transaction

where app_id = 552635992

and try_base64_decode_string(tx_message:txn:apaa[0]::string) = 'burn'))

group by date, asset