with pUSDC AS
(select
*
from flipside_prod_db.algorand.application_call_transaction
where
base64_decode_string(tx_message:txn:apaa[0]::String) = 'swap' and
app_id = 770103640
or app_id = 770102986)
SELECT
a.block_timestamp,
asset_sender,
asset_receiver,
a.asset_amount/1e6 as stablecoin_inflow,
a.asset_id
from algorand.asset_transfer_transaction a
inner join pUSDC b on b.tx_id = a.tx_id
where asset_id = 748211185 or asset_id = 748208047
and asset_amount > 400
order by stablecoin_inflow desc
limit 5
-- Query tips
-- select distinct base64_decode_string(tx_message:txn:apaa[0]::String) from algorand.application_call_transaction where app_id = 770103640