SELECT date_trunc('day', block_timestamp) as dayz,
--from_asset, to_asset, pool_name,
CASE WHEN memo like '%/%' THEN 1 ELSE 0 END AS is_synth,
count (distinct tx_id) as N,
case when from_asset like '%/%' THEN 'burn' ELSE 'mint' END AS burn_mint
FROM thorchain.swap_events
WHERE block_timestamp >= '2022-03-09'
and is_synth = 1
-- and from_asset like '%/%' -- mint
GROUP BY 1,2,4
ORDER BY 3 DESC