case when from_asset like '%ETH/USDC%' then 'synthetics USDC'

when from_asset like '%ETH.USDC%' then 'non synthetics USDC' end as "synthetics ?",

BLOCK_TIMESTAMP::date date,

sum(TO_AMOUNT) daily_swapped_rune, count(distinct tx_id) daily_swaps

from flipside_prod_db.thorchain.swaps

where from_asset in ('ETH/USDC-0XA0B86991C6218B36C1D19D4A2E9EB0CE3606EB48',

'ETH.USDC-0XA0B86991C6218B36C1D19D4A2E9EB0CE3606EB48')

and TO_ASSET in ('THOR.RUNE')

and year(BLOCK_TIMESTAMP)=2022

group by 1,2