Query editor
WITH bridge_messages AS (SELECTts_destination AS tx_time,tx_hash_source AS tac_bridge_tx,tx_hash_destination AS bsc_bridge_tx,usd_value,source_chain,destination_chainFROM layerzero.messagesWHERE source_chain_key = 'tac'AND destination_chain_key = 'bsc'AND destination_contract = '0x1219c409fabe2c27bd0d1a565daeed9bd9f271de'AND ts_destination >= TIMESTAMP '2026-07-01 00:00:00'AND ts_destination < TIMESTAMP '2026-07-02 00:00:00'AND usd_value >= 5000),token_transfers AS (SELECTtx_hash,SUM(CAST(amount AS DOUBLE)) AS token_transfer_amountFROM tokens.transfersWHERE contract_address = 0x1219c409fabe2c27bd0d1a565daeed9bd9f271deGROUP BY 1)SELECTbm.tx_time,CASEWHEN bm.tac_bridge_tx = '0xdcf22ebb1d753cb7dd0d3bdbf931a0a844378d8e86dd329fd72817cda9a9e998'THEN trueELSE falseEND AS tax_tx_check,CASEWHEN bm.bsc_bridge_tx = '0x703ab85eda14d6befe3d573e6e31e19d88c36959efc1d9794be03d3b71bb6905'THEN trueELSE falseEND AS bsc_tx_check,bm.source_chain,bm.destination_chain,bm.usd_value,tt.token_transfer_amount,bm.usd_value / NULLIF(tt.token_transfer_amount, 0) AS token_priceFROM bridge_messages bmLEFT JOIN token_transfers ttON tt.tx_hash = from_hex(substr(replace(lower(bm.bsc_bridge_tx), '0x', ''), 1))ORDER BY bm.usd_value DESC;