date_trunc('day',block_timestamp) as date

, pool_name

, CASE WHEN memo like '%/%' THEN 'synth' ELSE 'not_synth' END AS is_synth

, COUNT('synth') AS nb

FROM thorchain.swap_events

WHERE date >= '2022-03-01'

and to_asset like 'BTC%' or from_asset like 'BTC%'

GROUP BY 1, 2, 3

ORDER BY 1 DESC

limit 26