date_trunc('day',block_timestamp) as days,

sum(asset_amount)as amount,

sender,

TX_TYPE_NAME,

CASE

when asset_id='744665252' then 'pBTC'

when asset_id='748211185' then 'pUSDC'

when asset_id='748208047' then 'pUSDT'

end as coin

from flipside_prod_db.algorand.asset_transfer_transaction

where

(asset_id='744665252' --pBTC assetID

or asset_id='748211185 ' --pUSDC assseiID

or asset_id='748208047' --pUSDT assetID

and asset_amount>'0'

group by 1,3, 4, 5

order by 2