count(swap_from_amount) AS count,

date_trunc('day', block_timestamp::DATE) AS DATE,

(CASE

WHEN asset_name = 'USDC' THEN 'USDC'

WHEN asset_name = 'Yieldly' THEN 'Yieldly'

WHEN asset_name = 'Defly Token' THEN 'Defly Token'

WHEN asset_name = 'PLANET' THEN 'PLANET'

WHEN asset_name = 'AlgoStake' THEN 'AlgoStake'

WHEN asset_name = 'HEADLINE' THEN 'HEADLINE'

WHEN asset_name = 'Opulous' THEN 'Opulous'

WHEN asset_name = 'AKITA INU' THEN 'AKITA INU'

WHEN asset_name = 'ZONE' THEN 'ZONE'

WHEN asset_name = 'STBL' THEN 'STBL'

ELSE 'others'

END) AS asset_name

FROM algorand.swaps a

INNER JOIN algorand.asset aa ON a.swap_to_asset_id = aa.asset_id

WHERE block_timestamp >= '2022-01-01'

AND swap_from_asset_id = 0

AND asset_name IN ('USDC','Yieldly','Defly Token','PLANET','AlgoStake','HEADLINE','Opulous','AKITA INU','ZONE','STBL')

GROUP BY asset_name, DATE