table1 AS

SELECT *

FROM thorchain.swap_events

WHERE (block_id >= 4897156)

--Synth utilisation cap raised to 15%

AND (pool_name = 'BTC.BTC')

AND (block_id NOT IN (SELECT DISTINCT block_id FROM thorchain.stake_events WHERE (block_id >= 4897156) AND (pool_name = 'BTC.BTC')))

AND (block_id NOT IN (SELECT DISTINCT block_id FROM thorchain.unstake_events WHERE (block_id >= 4897156) AND (pool_name = 'BTC.BTC')))

QUALIFY COUNT(block_id) OVER(PARTITION BY block_id) = 1

),

table2 AS

SELECT *

FROM table1

WHERE to_asset LIKE '%/%'

SELECT *

FROM table2

ORDER BY block_id DESC