Query editor
WITH raw AS (SELECTblock_time,tx_hash,CASEWHEN token_standard = 'bep20' THEN 'buy'WHEN token_standard = 'native' THEN 'sell'ELSE NULLEND AS action,tx_from,tx_to,"from","to",amount,symbolFROM tokens.transfersWHERE blockchain = 'bnb'AND tx_to = 0xF5817927593C47ddaBf78344BA43dACf43cD73e6),buybnbs AS (SELECTblock_time,tx_hash,'buy' AS action,tx_from,amount,symbolFROM tokens.transfersWHERE blockchain = 'bnb'AND tx_to = 0xF5817927593C47ddaBf78344BA43dACf43cD73e6AND token_standard = 'bep20'ORDER BY block_time DESC),sellbnbs AS (SELECTblock_time,tx_hash,'sell' AS action,tx_from,amount,symbolFROM tokens.transfersWHERE blockchain = 'bnb'AND tx_to = 0xF5817927593C47ddaBf78344BA43dACf43cD73e6AND token_standard = 'native'ORDER BY block_time DESC)SELECT *FROM rawORDER BY block_time DESCLIMIT 100