DATE_TRUNC(DAY, T1.BLOCK_TIMESTAMP) AS SWAP_DAY,

T1.TX_ID as tx,

T1.FROM_ASSET as FROM_ASSET,

T2.TO_ASSET as TO_ASSET,

T1.FROM_AMOUNT as FROM_AMOUNT,

T2.TO_AMOUNT as TO_AMOUNT,

T1.TO_AMOUNT_USD as TO_AMOUNT_USD,

T2.TO_AMOUNT_USD as TO_AMOUNT_USD2

from thorchain.swaps T1

LEFT JOIN thorchain.swaps T2 ON t1.tx_id = t2.tx_id AND t2.TO_ASSET <> 'THOR.RUNE'

WHERE T1.from_asset <> 'THOR.RUNE' and T1.FROM_ASSET = 'ETH.SNX-0XC011A73EE8576FB46F5E1C5751CA3B9FE0AF2A6F' and t2.TO_ASSET = 'BNB.BUSD-BD1'

order by swap_day desc