Query editor
SELECTblock_time AS trade_time,tx_hash,evt_index,maker,taker,-- outcome labeling (works even if token_outcome_name isn't exactly "Yes-..." / "No-...")COALESCE(NULLIF(REGEXP_EXTRACT(token_outcome_name, '^(Yes|No)', 1), ''),token_outcome_name) AS outcome_raw,CASEWHEN REGEXP_LIKE(token_outcome_name, '^Yes') THEN 'Yes'WHEN REGEXP_LIKE(token_outcome_name, '^No') THEN 'No'ELSE NULLEND AS outcome_yes_no,amount AS usd_amount,price,shares,fee,token_outcome_nameFROM polymarket_polygon.market_tradesWHEREcondition_id = 0x8b46b1eb5cc486b2c9bbed162e9f15a62e4db942bfb00c128c39ec34cdd69ee7AND action = 'CLOB trade'AND amount > 0ORDER BY block_time ASC, tx_hash, evt_index;