select count(*) as txn_count, native_to_address,
sum(to_amount_usd) as swap_volume,
case when to_asset like '%/%' then 'synths'
when to_asset like '%.%' then 'non-synths'
else 'unknown'
end as asset_type
from flipside_prod_db.thorchain.swaps
where from_address = '0x53b8021dad6dc1ca045488b399113b9083bc0988'
and block_timestamp >='2022-01-01'
and blockchain = 'ETH'
group by 2,4
order by 1 desc