SELECT

day,

CASE

WHEN from_asset LIKE '%/%' OR to_asset LIKE '%/%' THEN 'Synth'

WHEN from_asset LIKE '%~%' OR to_asset LIKE '%~%' THEN 'Trade'

ELSE 'L1'

END AS TYPE,

SUM(volume) AS volume

FROM (

SELECT

block_timestamp::date AS day,

from_asset,

to_asset,

from_amount_usd AS volume

FROM

thorchain.defi.fact_swaps

WHERE

block_timestamp >= '2024-01-01'

) sub

GROUP BY

day,

TYPE;