Query editor
-- LayerZero USDT0 deliveries to Tron from 2026-09-01 through 2026-10-12, ≥ $1,000,000.SELECTtry(from_hex(substr(m.tx_hash_source, 3))) AS source_tx_hash,try(from_hex(substr(m.tx_hash_destination, 3))) AS dest_tx_hash,CAST(m.ts_source AS timestamp(3)) AS source_time,CAST(m.ts_destination AS timestamp(3)) AS block_time,CAST(m.ts_destination AS date) AS block_date,CAST(m.block_number_destination AS bigint) AS block_number,CAST(m.primary_key AS varchar) AS message_key,CAST(m.source_chain AS varchar) AS source_chain,CAST(m.destination_chain AS varchar) AS destination_chain,try(from_hex(substr(m.destination_contract, 3))) AS destination_contract,CAST(t.symbol AS varchar) AS symbol,COALESCE(t.usd_value, m.usd_value) AS usd_valueFROM layerzero.messages AS mINNER JOIN layerzero.transfers AS tON t.messages_foreign_key = m.primary_keyWHERE m.ts_destination >= TIMESTAMP '2026-09-01'AND m.ts_destination < TIMESTAMP '2026-10-13'AND (lower(m.destination_chain) = 'tron'OR lower(coalesce(m.destination_chain_key, '')) IN ('tron', 'trx'))AND t.symbol = 'USDT0'AND COALESCE(t.usd_value, m.usd_value) >= 1000000ORDER BYblock_time,dest_tx_hash