date_trunc('day',block_timestamp) as DATE,

coalesce(sum(from_amount_usd), sum(to_amount_usd)) as sum_amount_usd,

case when to_asset like '%/%' then 'mint' when from_asset like '%/%' then 'burn' end as synth_action

from thorchain.swaps

where to_asset like '%/%' or from_asset like '%/%'

group by 1 ,3

order by 1 desc, 3