–bi tabloda farkli kayitlar arasindaki saat farklarina gore kayitlari isaretlemem gerekti.
–borsaci oldugumuzdan birbirine cok yakin tradeleri isaretlemekti
–CustomerID ParityID ProcessDate BuySell OrderID isSuspicious
–30 22 2009-06-19 01:18:32.420 Buy 10124566 0
–31 22 2009-06-19 01:18:32.420 Buy 10124565 0
–70 22 2009-06-19 01:18:32.420 Buy 10122029 0
–192 22 2009-06-19 01:18:32.420 Buy 10122028 0
–737 5 2009-06-19 11:56:55.310 Buy 10125624 0
–737 5 2009-06-19 11:58:18.760 Sell 10125635 1
–737 5 2009-06-19 11:58:54.950 Sell 10125640 1
–737 5 2009-06-19 11:59:16.870 Sell 10125641 1
–737 5 2009-06-19 12:00:30.550 Sell 10125654 1
–737 5 2009-06-19 12:00:51.800 Sell 10125659 1
–737 5 2009-06-19 12:02:29.800 Sell 10125666 0
–737 5 2009-06-19 12:10:09.850 Buy 10125690 2
–737 5 2009-06-19 12:11:04.400 Sell 10125694 2
–737 5 2009-06-19 12:12:09.450 Sell 10125697 0
–737 5 2009-06-19 12:21:46.620 Sell 10125715 0
–cozumum asagidaki gibi oldu
============================
–temp tablo
============================
CREATE
TABLE #Scalpers(
CustomerID INT,
ParityID INT,
ProcessDate DATETIME,
BuySell [...]