Query editor
-- Polymarket whale detector: large YES/NO buys in last 6 hours-- Parameter: {{token_id}} = the YES CLOB token ID for the marketSELECTSUM(CASEWHEN takerAssetId = CAST('{{token_id}}' AS uint256)THEN CAST(makerAmountFilled AS DOUBLE)/1e6ELSE 0END) AS yes_volume_usd,SUM(CASEWHEN makerAssetId = CAST('{{token_id}}' AS uint256)THEN CAST(takerAmountFilled AS DOUBLE)/1e6ELSE 0END) AS no_volume_usd,COUNT(DISTINCT maker) AS unique_whalesFROM polymarket_polygon.CTFExchange_evt_OrderFilledWHERE evt_block_time >= NOW() - INTERVAL '6' HOURAND (takerAssetId = CAST('{{token_id}}' AS uint256)OR makerAssetId = CAST('{{token_id}}' AS uint256))AND CAST(makerAmountFilled AS DOUBLE)/1e6 > 5000