Query editor
SELECTblock_time AS trade_time,tx_hash,evt_index,maker,taker,token_outcome_name AS raw_outcome_name,CASEWHEN 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 = 0xd4bbf7f6707c67beb736135ad32a41f6db41f8ae52d3ac4919650de9eeb94ed8AND action = 'CLOB trade'AND amount > 0ORDER BY block_time ASC;