Query editor
SELECTblock_time AS trade_time,tx_hash,evt_index,maker,taker,-- Normalize outcome into clean Yes/NoCASEWHEN 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 = 0x9a85860222480097c4fbafa1a0fde962fea0f535a282f4f799cc28f86dacf763AND action = 'CLOB trade'AND amount > 0ORDER BY block_time ASC;