select att.block_timestamp::date as DATE,

sum(asset_amount)*1e-6 as amount,

(case

when asset_receiver = 'MBZCPCZ63NG4QV3T7CTID7SR67NE5DO74DNHHPS2763L6B7YXG2EYRYCKM' then 'goBTC-ALGO'

when asset_receiver = 'JAWQ5G3PUUHDW5I2UKRYKCSZDGYZVBL4SOIX42KPEUDUO7K7XUU4OBAG7U' then 'goBTC-USDC'

end) as pool

from flipside_prod_db.algorand.asset_transfer_transaction att

inner join flipside_prod_db.algorand.application_call_transaction act on act.tx_group_id = att.tx_group_id

inner join flipside_prod_db.algorand.labels al on al.address = att.asset_receiver

where TRY_BASE64_DECODE_STRING(act.tx_message:txn:apaa[0]::STRING) = 'mint'

and att.asset_receiver in ('MBZCPCZ63NG4QV3T7CTID7SR67NE5DO74DNHHPS2763L6B7YXG2EYRYCKM', 'JAWQ5G3PUUHDW5I2UKRYKCSZDGYZVBL4SOIX42KPEUDUO7K7XUU4OBAG7U')

and act.app_id = '552635992'

and att.asset_id = '386192725'

AND att.tx_type_name = 'asset transfer'

and att.block_timestamp > '2022-01-01'

group by DATE, pool

),

eth_stake as (

select att.block_timestamp::date as DATE,

sum(asset_amount)*1e-6 as amount,

(case

when asset_receiver = 'Y5DNQWYUJCSYCAJPKX6JNSMZCR5OWDMQGCEVGHCBGJZ7J2LA7EJ7SO74AI' then 'goETH-ALGO'

when asset_receiver = 'CDBQM4WBOGHUZNB5YF4GEKX7YTKDMLDQGKZNBK4753Q6DLBRV2SWYUJBBM' then 'goETH-STBL'

end) as pool

from flipside_prod_db.algorand.asset_transfer_transaction att

inner join flipside_prod_db.algorand.application_call_transaction act on act.tx_group_id = att.tx_group_id

inner join flipside_prod_db.algorand.labels al on al.address = att.asset_receiver

where TRY_BASE64_DECODE_STRING(act.tx_message:txn:apaa[0]::STRING) = 'mint'

and att.asset_receiver in ('Y5DNQWYUJCSYCAJPKX6JNSMZCR5OWDMQGCEVGHCBGJZ7J2LA7EJ7SO74AI', 'CDBQM4WBOGHUZNB5YF4GEKX7YTKDMLDQGKZNBK4753Q6DLBRV2SWYUJBBM')

and act.app_id = '552635992'

and att.asset_id = '386195940'

AND att.tx_type_name = 'asset transfer'

and att.block_timestamp > '2022-01-01'

group by DATE, pool