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