Query editor
WITH bridge_messages AS (SELECTts_destination AS tx_time,addr_from AS tac_address,tx_hash_source AS tac_bridge_tx,tx_hash_destination AS bsc_bridge_tx,usd_value,source_chain,destination_chain,tx_hash_source AS tac_tx_hashFROM layerzero.messagesWHERE source_chain_key = 'tac'AND destination_chain_key = 'bsc'AND lower(destination_contract) = '0x1219c409fabe2c27bd0d1a565daeed9bd9f271de'AND ts_destination >= TIMESTAMP '2025-01-01 00:00:00'AND ts_destination < TIMESTAMP '2026-07-17 00:00:00'AND usd_value >= 50AND lower(addr_from) IN ('0x9390e7d8d72a5f5d280d63ad35aff943cc98b01a','0x4824c46e7dc06beb69971c8f6c6b63dd4777a7d7','0x24ccbe2e3e403f22270ea3566df1e925a265d137','0x0b75b7f58593789d9f8455e0f10b41702a7b870a','0x1a823d98ffe95b94445f39981c189892e1f41425','0x8ff96eedaa115f79b17e51522ffc294f23dcc086','0x25dce013d7e89ecfb5e96df948052ec21257dff5','0x352636a7f334db6d2ef02036127f67f6f9ca6e3b','0x425d16B0e08a28A3Ff9e4404AE99D78C0a076C5A')),token_transfers AS (SELECTtx_hash,CAST(amount AS DOUBLE) AS token_transfer_amount,to AS bsc_address,tx_hash AS bsc_tx_hashFROM tokens.transfersWHERE contract_address = 0x1219c409fabe2c27bd0d1a565daeed9bd9f271de)SELECTbm.tx_time,bm.source_chain,bm.destination_chain,tt.bsc_address,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(replace(lower(bm.bsc_bridge_tx), '0x', ''))ORDER BY bm.usd_value DESC;