Query editor
-- Tron hop endpoints: CEX labels, decoded contracts, USDT0 OFT, USDT token,-- and addresses that are tx_to on ≥100 USDT transfers in the window.SELECTaddress,CAST(stop_reason AS varchar) AS stop_reasonFROM (SELECTaddress,CAST('cex' AS varchar) AS stop_reasonFROM dune.fruitman8592.dataset_cex_tron_labelsWHERE address IS NOT NULLUNIONSELECTaddress,CAST('decoded_contract' AS varchar) AS stop_reasonFROM tron.contractsWHERE address IS NOT NULLUNIONSELECTdestination_contract AS address,CAST('oft' AS varchar) AS stop_reasonFROM query_8935765WHERE destination_contract IS NOT NULLUNIONSELECT0xa614f803b6fd780986a42c78ec9c7f77e6ded13c AS address,CAST('usdt_token' AS varchar) AS stop_reasonUNIONSELECTtx_to AS address,CAST('hot_tx_to' AS varchar) AS stop_reasonFROM (SELECTtx_to,COUNT(*) AS tx_countFROM tokens_tron.transfersWHERE block_month IN (DATE '2026-09-01', DATE '2026-10-01')AND block_date >= DATE '2026-09-01'AND block_date < DATE '2026-10-13'AND contract_address = 0xa614f803b6fd780986a42c78ec9c7f77e6ded13cAND tx_to IS NOT NULLAND tx_to <> 0xa614f803b6fd780986a42c78ec9c7f77e6ded13cGROUP BY 1) AS tWHERE tx_count >= 100) AS stopsWHERE address IS NOT NULL