Query editor
SELECTblock_time AS trade_time,tx_hash,evt_index,maker,taker,token_outcome_name AS raw_outcome,-- Clean YES/NO outcome labelCASEWHEN token_outcome_name LIKE 'Yes-%' THEN 'Yes'WHEN token_outcome_name LIKE 'No-%' THEN 'No'ELSE token_outcome_nameEND AS outcome,amount AS usd_amount,price,shares,feeFROM polymarket_polygon.market_tradesWHEREcondition_id = 0x03ddc235d917eb09fded05d1d2e0326a12e261c1922a2f7f049f0e44251efdf1AND action = 'CLOB trade'AND amount > 0ORDER BY block_time ASC;