FROM thorchain.defi.fact_swaps_events

WHERE BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '{{days}} DAY'

AND SPLIT_PART(MEMO, ':', 5) = 'ss'

AND UPPER(SPLIT_PART(MEMO, ':', 1)) NOT IN ('S', 'SWAP', '=')