Link to home
Start Free TrialLog in
Avatar of happy 1001
happy 1001

asked on

SQL Server - Slabs

Hi Experts

I am trying to create a query that will give Scores based on different conditions. But for doing this, I have to perform multiple steps. The steps are as follows -

First of all I have to define 5 ScoreSlabs, based on column [ price_spot ]
The process of defining these 5 ScoreSlabs is very simple. We just need to put the data in Descending Order. And then pick up the
value that falls at Number 5, as ScoreSlab1
value that falls at Number 10, as ScoreSlab2
value that falls at Number 15, as ScoreSlab3
value that falls at Number 20, as ScoreSlab4
value that falls at Number 25, as ScoreSlab5

Once these 5 ScoreSlabs are defined, then the next step is to give score to each day's value, based on the ScoreSlab to which it belongs.

If [ price_spot ] value is,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,            then give this Score

If >= ScoreSlab1                                                                    2
If >= ScoreSlab2 and < ScoreSlab1                                    1
If < ScoreSlab1 and > ScoreSlab4                                      0
If <= ScoreSlab4 and > ScoreSlab5                                    -1
If <= ScoreSlab5                                                                    -2

So basically  each of the rows in the table, will have any of these 5 values 2,1,0,-1,-2 .
The output of this query will have all the original columns as such, just one new column named [ price_spot_slabranks ] will get added at the end, showing the score values for [ price_spot ] column, based on the 5 slabs.

I am using the following software versions -
Microsoft SQL Server Management Studio version-  12.0.2000.8,
Microsoft Office 2016 x64
and Windows 7 x64

Thanks a lot for any help.

Regards


PS: Please note,
1. I have to create this in the form of a Query / View and then link it to excel to get the data into excel directly. So please do not use those methods which cannot be easily converted into View.

2. We do not necessarily have to arrange the data in descending order, if there is some DIRECT METHOD available within SQL Server, by which we can pick up the 5th,10th,15th,20th and 25th Highest Values, which are needed for defining the values for our 5 ScoreSlabs. If this could be done directly by using some Function etc. that would be great, otherwise we will have to use the lengthy method of first arranging the data in descending order and then picking up the Nth highest values from there. Hopefully you understand, what I mean.

3. I have to do this kind of scoring work for MULTIPLE COLUMNS and not just single column "as we are doing it just for [ price_spot ] column in this example, to keep it simple. So please suggest the method which could be applied on a lot of different columns, in the same query. Otherwise I will have to create a new separate query for every separate column, on which I need to do the scoring.

4. If any doubts about any steps, then please ask, and I will explain in more details.

Here is the script that will create the Sample Database named " TestDB1001 "  and Table named " Table1004" used in this work.

CREATE DATABASE TestDB1001
GO

USE TestDB1001
GO



CREATE TABLE TestDB1001.dbo.Table1004 (
  xdate DATETIME2(0) NULL,
  symbol NVARCHAR(255) NULL,
  sector NVARCHAR(255) NULL,
  lotsize FLOAT NULL,
  price_spot FLOAT NULL,
  price_future FLOAT NULL,
  price_future_previous FLOAT NULL,
  price_future_change FLOAT NULL,
  price_future_percent FLOAT NULL,
  price_future_sign NVARCHAR(255) NULL,
  volume_spot FLOAT NULL,
  volume_future FLOAT NULL,
  volume_future_previous FLOAT NULL,
  volume_future_change FLOAT NULL,
  volume_future_percent FLOAT NULL,
  volume_value FLOAT NULL,
  volume_value_previous FLOAT NULL,
  volume_value_change FLOAT NULL,
  volume_value_percent FLOAT NULL,
  oi_total FLOAT NULL,
  oi_total_previous FLOAT NULL,
  oi_total_change FLOAT NULL,
  oi_total_percent FLOAT NULL,
  oi_value FLOAT NULL,
  oi_value_previous FLOAT NULL,
  oi_value_change FLOAT NULL,
  oi_value_percent FLOAT NULL,
  rollover FLOAT NULL,
  rollover_percent FLOAT NULL,
  daystoexpiry FLOAT NULL,
  expirydate DATETIME2(0) NULL,
  [open] FLOAT NULL,
  high FLOAT NULL,
  low FLOAT NULL,
  [close] FLOAT NULL,

) ON [PRIMARY]
GO





SET DATEFORMAT ymd
SET ARITHABORT, ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER, ANSI_NULLS, NOCOUNT ON
SET NUMERIC_ROUNDABORT, IMPLICIT_TRANSACTIONS, XACT_ABORT OFF
GO





INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-27 00:00:00.0000000', N'AXISBANK', N'Banking', 500, 555.8, 557.05, 582.05, -25, -4.3, N'-3', 9829067, 44095, 74863, -30768, -41.1, 239998.92, 445126.83, -205127.91, -46.08, 42124000, 40019500, 2104500, 5.26, 2406.53, 2351.34, 55.19, 2.35, 7078500, 27.02, 3, '2015-07-30 00:00:00.0000000', 577.5, 579.45, 553.75, 555.8)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-27 00:00:00.0000000', N'ICICIBANK', N'Banking', 1000, 291.1, 291.85, 301.4, -9.55, -3.17, N'-2', 10193223, 43102, 45530, -2428, -5.33, 177698.97, 208966.89, -31267.92, -14.96, 80130000, 74726000, 5404000, 7.23, 2395.8, 2289.48, 106.32, 4.64, 24916000, 42.63, 3, '2015-07-30 00:00:00.0000000', 299.85, 299.85, 290.1, 291.1)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-27 00:00:00.0000000', N'UCOBANK', N'Banking', 4000, 50.35, 50.3, 52.9, -2.6, -4.91, N'-3', 2248877, 2054, 720, 1334, 185.28, 4963.17, 1939.44, 3023.73, 155.91, 22568000, 21224000, 1344000, 6.33, 115.5, 113.46, 2.04, 1.8, 5656000, 28.47, 3, '2015-07-30 00:00:00.0000000', 52.9, 52.9, 50.1, 50.35)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-27 00:00:00.0000000', N'BANKNIFTY', N'Index', 25, 18213.05, 18251.45, 18675.95, -424.5, -2.27, N'-2', 0, 155538, 113869, 41669, 36.59, 5807859.59, 3723142.51, 2084717.08, 55.99, 10699575, 9636750, 1062825, 11.03, 19850.01, 18018.67, 1831.34, 10.16, 547700, 24.71, 3, '2015-07-30 00:00:00.0000000', 18566.55, 18566.55, 18187.45, 18213.05)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-27 00:00:00.0000000', N'NIFTY', N'Index', 25, 8361, 8372.8, 8534.35, -161.55, -1.8900000000000001, N'-1', 296906150, 723071, 380502, 342569, 90.03, 28429682.23, 17312126.88, 11117555.35, 64.22, 179853100, 174972125, 4880975, 2.79, 148861.36, 145194.52, 3666.84, 2.5300000000000002, 5576650, 23.69, 3, '2015-07-30 00:00:00.0000000', 8492.1, 8492.2, 8351.55, 8361)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-27 00:00:00.0000000', N'DLF', N'Realty', 2000, 101.2, 101.15, 103.1, -1.95, -1.8900000000000001, N'-1', 5861376, 12507, 8124, 4383, 53.95, 41143.76, 35341.01, 5802.75, 16.42, 45690000, 45276000, 414000, 0.91, 484.36, 486.43, -2.07, -0.43, 9230000, 35.42, 3, '2015-07-30 00:00:00.0000000', 102.2, 104.45, 100.5, 101.2)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-27 00:00:00.0000000', N'UNITECH', N'Realty', 11000, 6.65, 6.65, 6.85, -0.2, -2.92, N'-2', 25200131, 8042, 2963, 5079, 171.41, 6202.17, 2873.79, 3328.38, 115.82, 251680000, 242220000, 9460000, 3.91, 176.25, 173.73, 2.52, 1.45, 47740000, 23.49, 3, '2015-07-30 00:00:00.0000000', 6.8, 6.9, 6.6, 6.65)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-27 00:00:00.0000000', N'RCOM', N'Telecom', 4000, 67.15, 67.2, 68.05, -0.85, -1.25, N'-1', 6347046, 11558, 3762, 7796, 207.23, 40094.33, 16310.29, 23784.04, 145.82, 89776000, 90908000, -1132000, -1.25, 606.98, 619.3, -12.32, -1.99, 12992000, 21.64, 3, '2015-07-30 00:00:00.0000000', 68, 69.65, 66.8, 67.15)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-27 00:00:00.0000000', N'TATACOMM', N'Telecom', 500, 470.35, 471, 480.85, -9.85, -2.05, N'-2', 332277, 4707, 6750, -2043, -30.27, 12385.35, 19940.37, -7555.02, -37.89, 6012500, 5794500, 218000, 3.76, 283.31, 277.98, 5.33, 1.92, 1276000, 23.63, 3, '2015-07-30 00:00:00.0000000', 477, 478.25, 466.7, 470.35)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-28 00:00:00.0000000', N'AXISBANK', N'Banking', 500, 561.25, 562.45, 557.05, 5.4, 0.97, N'1', 8129213, 48392, 44095, 4297, 9.74, 200900.38, 239998.92, -39098.54, -16.29, 42488500, 42124000, 364500, 0.87, 2438.5, 2406.53, 31.97, 1.33, 12940000, 47.71, 2, '2015-07-30 00:00:00.0000000', 558.6, 564, 550.45, 561.25)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-28 00:00:00.0000000', N'ICICIBANK', N'Banking', 1000, 285, 285.85, 291.85, -6, -2.06, N'-2', 23086612, 55363, 43102, 12261, 28.45, 217215.73, 177698.97, 39516.76, 22.24, 89056000, 80130000, 8926000, 11.14, 2617.19, 2395.8, 221.39, 9.24, 37071000, 56.88, 2, '2015-07-30 00:00:00.0000000', 291.7, 295.35, 282.7, 285)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-28 00:00:00.0000000', N'UCOBANK', N'Banking', 4000, 50.65, 50.8, 50.3, 0.5, 0.99, N'1', 1639242, 2928, 2054, 874, 42.55, 6319.71, 4963.17, 1356.54, 27.33, 21400000, 22568000, -1168000, -5.18, 110.61, 115.5, -4.89, -4.23, 8260000, 44.14, 2, '2015-07-30 00:00:00.0000000', 50.5, 51.75, 50.1, 50.65)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-28 00:00:00.0000000', N'BANKNIFTY', N'Index', 25, 18282.8, 18314.2, 18251.45, 62.75, 0.34, N'1', 0, 158978, 155538, 3440, 2.21, 5786961.83, 5807859.59, -20897.76, -0.36, 11468575, 10699575, 769000, 7.19, 21239.37, 19850.01, 1389.36, 7, 880475, 37.17, 2, '2015-07-30 00:00:00.0000000', 18250.65, 18379.1, 18174.2, 18282.8)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-28 00:00:00.0000000', N'NIFTY', N'Index', 25, 8337, 8350.95, 8372.8, -21.85, -0.26, N'-1', 296906150, 811203, 723071, 88132, 12.19, 26648449.51, 28429682.23, -1781232.72, -6.27, 185142700, 179853100, 5289600, 2.94, 153166.92, 148861.36, 4305.56, 2.89, 10076925, 40.4, 2, '2015-07-30 00:00:00.0000000', 8371.1, 8397.4, 8321.75, 8337)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-28 00:00:00.0000000', N'DLF', N'Realty', 2000, 95.4, 95.6, 101.15, -5.55, -5.49, N'-3', 8686984, 14285, 12507, 1778, 14.22, 48277.02, 41143.76, 7133.26, 17.34, 48540000, 45690000, 2850000, 6.24, 496.28, 484.36, 11.92, 2.46, 13092000, 48, 2, '2015-07-30 00:00:00.0000000', 102, 102, 95, 95.4)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-28 00:00:00.0000000', N'UNITECH', N'Realty', 11000, 6.5, 6.55, 6.65, -0.1, -1.5, N'-1', 33551771, 8978, 8042, 936, 11.64, 6883.47, 6202.17, 681.3, 10.98, 265386000, 251680000, 13706000, 5.45, 183.07, 176.25, 6.82, 3.87, 70906000, 32.84, 2, '2015-07-30 00:00:00.0000000', 6.7, 6.75, 6.45, 6.5)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-28 00:00:00.0000000', N'RCOM', N'Telecom', 4000, 65.75, 65.9, 67.2, -1.3, -1.9300000000000002, N'-1', 5883355, 15899, 11558, 4341, 37.56, 50510.26, 40094.33, 10415.93, 25.98, 89400000, 89776000, -376000, -0.42, 596.98, 606.98, -10, -1.65, 26492000, 44.11, 2, '2015-07-30 00:00:00.0000000', 67.5, 68.25, 65.35, 65.75)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-28 00:00:00.0000000', N'TATACOMM', N'Telecom', 500, 474.35, 474.35, 471, 3.35, 0.71, N'1', 293193, 6127, 4707, 1420, 30.17, 16784.42, 12385.35, 4399.07, 35.52, 6266000, 6012500, 253500, 4.22, 297.27, 283.31, 13.96, 4.93, 2195500, 39.4, 2, '2015-07-30 00:00:00.0000000', 470, 478.7, 469, 474.35)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-29 00:00:00.0000000', N'AXISBANK', N'Banking', 500, 567.2, 566.95, 562.45, 4.5, 0.8, N'1', 4635380, 38872, 48392, -9520, -19.67, 156111.33, 200900.38, -44789.05, -22.29, 40365000, 42488500, -2123500, -5, 2327.37, 2438.5, -111.13, -4.5600000000000005, 16586500, 63.31, 1, '2015-07-30 00:00:00.0000000', 563.3, 568.15, 562, 567.2)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-29 00:00:00.0000000', N'ICICIBANK', N'Banking', 1000, 289.25, 289.25, 285.85, 3.4, 1.19, N'1', 11968942, 38296, 55363, -17067, -30.83, 146652.97, 217215.73, -70562.76, -32.49, 89833000, 89056000, 777000, 0.87, 2662.31, 2617.19, 45.12, 1.72, 45348000, 68.62, 1, '2015-07-30 00:00:00.0000000', 287.5, 289.9, 284.05, 289.25)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-29 00:00:00.0000000', N'UCOBANK', N'Banking', 4000, 48.7, 48.7, 50.8, -2.1, -4.13, N'-3', 2205464, 4678, 2928, 1750, 59.77, 9835.23, 6319.71, 3515.52, 55.63, 21872000, 21400000, 472000, 2.21, 109.2, 110.61, -1.41, -1.27, 11052000, 58.17, 1, '2015-07-30 00:00:00.0000000', 50.5, 51.2, 48.3, 48.7)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-29 00:00:00.0000000', N'BANKNIFTY', N'Index', 25, 18323.4, 18329.1, 18314.2, 14.9, 0.08, N'1', 0, 118501, 158978, -40477, -25.46, 4239815.73, 5786961.83, -1547146.1, -26.74, 11265975, 11468575, -202600, -1.77, 20856.74, 21239.37, -382.63, -1.8, 1262550, 52.22, 1, '2015-07-30 00:00:00.0000000', 18331.55, 18383.65, 18264.3, 18323.4)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-29 00:00:00.0000000', N'NIFTY', N'Index', 25, 8375.05, 8377.65, 8350.95, 26.7, 0.32, N'1', 296906150, 694615, 811203, -116588, -14.37, 23378030.48, 26648449.51, -3270419.03, -12.27, 184599000, 185142700, -543700, -0.29, 152719.32, 153166.92, -447.6, -0.29, 13085325, 53.25, 1, '2015-07-30 00:00:00.0000000', 8365.6, 8381.5, 8338.45, 8375.05)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-29 00:00:00.0000000', N'DLF', N'Realty', 2000, 101.55, 101.55, 95.6, 5.95, 6.22, N'3', 12340725, 33209, 14285, 18924, 132.47, 107946.21, 48277.02, 59669.19, 123.6, 50262000, 48540000, 1722000, 3.55, 527.93, 496.28, 31.65, 6.38, 19592000, 70.82, 1, '2015-07-30 00:00:00.0000000', 96.8, 104.4, 94.2, 101.55)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-29 00:00:00.0000000', N'UNITECH', N'Realty', 11000, 6.25, 6.3, 6.55, -0.25, -3.82, N'-2', 40109110, 14150, 8978, 5172, 57.61, 10371.17, 6883.47, 3487.7, 50.67, 287386000, 265386000, 22000000, 8.29, 192.43, 183.07, 9.36, 5.11, 110913000, 46.72, 1, '2015-07-30 00:00:00.0000000', 6.55, 6.55, 6.1, 6.25)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-29 00:00:00.0000000', N'RCOM', N'Telecom', 4000, 65.05, 65.1, 65.9, -0.8, -1.21, N'-1', 6189069, 17196, 15899, 1297, 8.16, 55699.29, 50510.26, 5189.03, 10.27, 89308000, 89400000, -92000, -0.1, 591.65, 596.98, -5.33, -0.89, 38924000, 65.35, 1, '2015-07-30 00:00:00.0000000', 65.95, 66.6, 63.7, 65.05)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-29 00:00:00.0000000', N'TATACOMM', N'Telecom', 500, 439.8, 440.05, 474.35, -34.3, -7.23, N'-3', 1920475, 14864, 6127, 8737, 142.6, 40177.21, 16784.42, 23392.79, 139.37, 6762000, 6266000, 496000, 7.92, 300.24, 297.27, 2.9699999999999998, 1, 3551000, 60.73, 1, '2015-07-30 00:00:00.0000000', 467.9, 467.9, 433.2, 439.8)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-30 00:00:00.0000000', N'AXISBANK', N'Banking', 500, 565.7, 569.3, 569.85, -0.55, -0.1, N'-1', 6484751, 48828, 38872, 9956, 25.61, 177104.36, 156111.33, 20993.03, 13.45, 24758000, 40365000, -15607000, -38.66, 2317.07, 2327.37, -10.3, -0.44, 21874500, 81.07, 0, '2015-07-30 00:00:00.0000000', 571.4, 575.75, 563.1, 565.7)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-30 00:00:00.0000000', N'ICICIBANK', N'Banking', 1000, 291, 292.6, 290.8, 1.8, 0.62, N'1', 12459821, 54005, 38296, 15709, 41.02, 197971.37, 146652.97, 51318.4, 34.99, 66409000, 89833000, -23424000, -26.08, 2754.7, 2662.31, 92.39, 3.4699999999999998, 56838000, 84.33, 0, '2015-07-30 00:00:00.0000000', 290, 293.65, 287.5, 291)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-30 00:00:00.0000000', N'UCOBANK', N'Banking', 4000, 51.05, 51.4, 49.05, 2.35, 4.79, N'3', 2076155, 6337, 4678, 1659, 35.46, 13927.58, 9835.23, 4092.35, 41.61, 17296000, 21872000, -4576000, -20.92, 109.84, 109.2, 0.64, 0.59, 15912000, 91.03, 0, '2015-07-30 00:00:00.0000000', 48.8, 51.35, 48.8, 51.05)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-30 00:00:00.0000000', N'BANKNIFTY', N'Index', 25, 18440.4, 18535.85, 18440, 95.85, 0.52, N'1', 0, 182847, 118501, 64346, 54.3, 7825582.28, 4239815.73, 3585766.55, 84.57, 4127150, 11265975, -7138825, -63.37, 21585.99, 20856.74, 729.25, 3.5, 1972175, 78.67, 0, '2015-07-30 00:00:00.0000000', 18383, 18521.75, 18367.2, 18440.4)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-30 00:00:00.0000000', N'NIFTY', N'Index', 25, 8421.8, 8461.75, 8417.95, 43.8, 0.52, N'1', 296906150, 890542, 694615, 195927, 28.21, 37164599.97, 23378030.48, 13786569.49, 58.97, 109974275, 184599000, -74624725, -40.43, 162024.56, 152719.32, 9305.24, 6.09, 17141700, 65.92, 0, '2015-07-30 00:00:00.0000000', 8417, 8458.9, 8408.3, 8421.8)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-30 00:00:00.0000000', N'DLF', N'Realty', 2000, 109.7, 108.3, 100.45, 7.85, 7.8100000000000005, N'3', 17880156, 28170, 33209, -5039, -15.17, 119610.18, 107946.21, 11663.97, 10.81, 28916000, 50262000, -21346000, -42.47, 599.33, 527.93, 71.4, 13.52, 23090000, 81.45, 0, '2015-07-30 00:00:00.0000000', 102.9, 110.95, 102, 109.7)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-30 00:00:00.0000000', N'UNITECH', N'Realty', 11000, 7.4, 7.45, 6.35, 1.1, 17.32, N'3', 113452514, 26783, 14150, 12633, 89.28, 23940.37, 10371.17, 13569.2, 130.84, 166001000, 287386000, -121385000, -42.24, 184.54, 192.43, -7.89, -4.1, 153835000, 81.23, 0, '2015-07-30 00:00:00.0000000', 6.35, 7.5, 6.25, 7.4)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-30 00:00:00.0000000', N'RCOM', N'Telecom', 4000, 68.4, 68.75, 65.35, 3.4, 5.2, N'3', 10687324, 17517, 17196, 321, 1.87, 61672.11, 55699.29, 5972.82, 10.72, 56100000, 89308000, -33208000, -37.18, 634.46, 591.65, 42.81, 7.24, 50696000, 82.27, 0, '2015-07-30 00:00:00.0000000', 65.7, 69, 65.15, 68.4)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-30 00:00:00.0000000', N'TATACOMM', N'Telecom', 500, 452.45, 454.05, 442.4, 11.65, 2.63, N'2', 2249587, 16407, 14864, 1543, 10.38, 40255.74, 40177.21, 78.53, 0.2, 5426500, 6762000, -1335500, -19.75, 310.63, 300.24, 10.39, 3.46, 5169000, 86.56, 0, '2015-07-30 00:00:00.0000000', 440, 474, 429.1, 452.45)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-31 00:00:00.0000000', N'AXISBANK', N'Banking', 500, 573.5, 577.25, 569.3, 7.95, 1.4, N'1', 6283549, 21340, 48828, -27488, -56.3, 85499.92, 177104.36, -91604.44, -51.72, 26068000, 24758000, 1310000, 5.29, 1509.74, 2317.07, -807.33, -34.84, 141000, 0.62, 27, '2015-08-27 00:00:00.0000000', 567.7, 579.3, 567, 573.5)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-31 00:00:00.0000000', N'ICICIBANK', N'Banking', 1000, 302.4, 304.55, 292.6, 11.95, 4.08, N'3', 35425264, 69889, 54005, 15884, 29.41, 385751.52, 197971.37, 187780.15, 94.85, 80296000, 66409000, 13887000, 20.91, 2454.91, 2754.7, -299.79, -10.88, 576000, 0.92, 27, '2015-08-27 00:00:00.0000000', 294.45, 308.9, 294.1, 302.4)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-31 00:00:00.0000000', N'UCOBANK', N'Banking', 4000, 52.7, 53.05, 51.4, 1.65, 3.21, N'2', 2937373, 1740, 6337, -4597, -72.54, 4636.93, 13927.58, -9290.65, -66.71, 17984000, 17296000, 688000, 3.98, 95.84, 109.84, -14, -12.75, 200000, 1.24, 27, '2015-08-27 00:00:00.0000000', 51.3, 53.4, 50.85, 52.7)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-31 00:00:00.0000000', N'BANKNIFTY', N'Index', 25, 18729.85, 18835.8, 18535.85, 299.95, 1.62, N'1', 0, 120987, 182847, -61860, -33.83, 1963359.14, 7825582.28, -5862223.14, -74.91, 4929550, 4127150, 802400, 19.44, 9247.98, 21585.99, -12338.01, -57.16, 62625, 3, 27, '2015-08-27 00:00:00.0000000', 18489.85, 18828.85, 18474.8, 18729.85)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-31 00:00:00.0000000', N'NIFTY', N'Index', 25, 8532.85, 8569.65, 8461.75, 107.9, 1.28, N'1', 296906150, 434763, 890542, -455779, -51.18, 10341782.56, 37164599.97, -26822817.41, -72.17, 116571375, 109974275, 6597100, 6, 96422.48, 162024.56, -65602.08, -40.49, 619175, 3.46, 27, '2015-08-27 00:00:00.0000000', 8456.1, 8548.95, 8448, 8532.85)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-31 00:00:00.0000000', N'DLF', N'Realty', 2000, 115.05, 113.35, 108.3, 5.05, 4.66, N'3', 10625318, 10958, 28170, -17212, -61.1, 43130, 119610.18, -76480.18, -63.94, 32454000, 28916000, 3538000, 12.24, 365.55, 599.33, -233.78, -39.01, 528000, 2.19, 27, '2015-08-27 00:00:00.0000000', 109, 116.6, 108.05, 115.05)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-31 00:00:00.0000000', N'UNITECH', N'Realty', 11000, 7.6, 7.65, 7.45, 0.2, 2.68, N'2', 49755965, 3942, 26783, -22841, -85.28, 4977.42, 23940.37, -18962.95, -79.21, 180213000, 166001000, 14212000, 8.56, 139.93, 184.54, -44.61, -24.17, 1826000, 1.12, 27, '2015-08-27 00:00:00.0000000', 7.45, 7.9, 7.4, 7.6)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-31 00:00:00.0000000', N'RCOM', N'Telecom', 4000, 70.5, 70.9, 68.75, 2.15, 3.13, N'2', 11108451, 8148, 17517, -9369, -53.49, 43399.17, 61672.11, -18272.94, -29.63, 62016000, 56100000, 5916000, 10.55, 441.33, 634.46, -193.13, -30.44, 836000, 1.67, 27, '2015-08-27 00:00:00.0000000', 69.7, 72.5, 68.85, 70.5)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-07-31 00:00:00.0000000', N'TATACOMM', N'Telecom', 500, 450.45, 452.5, 454.05, -1.55, -0.34, N'-1', 330638, 3022, 16407, -13385, -81.58, 7623.2, 40255.74, -32632.54, -81.06, 5557000, 5426500, 130500, 2.4, 251.63, 310.63, -59, -18.99, 17000, 0.32, 27, '2015-08-27 00:00:00.0000000', 454, 460.3, 444.4, 450.45)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-03 00:00:00.0000000', N'AXISBANK', N'Banking', 500, 576.7, 578.1, 577.25, 0.85, 0.15, N'1', 4355574, 17919, 21340, -3421, -16.03, 80520.11, 85499.92, -4979.81, -5.82, 26555000, 26068000, 487000, 1.87, 1542.31, 1509.74, 32.57, 2.16, 167500, 0.75, 24, '2015-08-27 00:00:00.0000000', 576, 582.7, 573.4, 576.7)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-03 00:00:00.0000000', N'ICICIBANK', N'Banking', 1000, 312.9, 313.65, 304.55, 9.1, 2.99, N'2', 26099623, 38235, 69889, -31654, -45.29, 194213.27, 385751.52, -191538.25, -49.65, 72628000, 80296000, -7668000, -9.55, 2272.72, 2454.91, -182.19, -7.42, 624000, 1.13, 24, '2015-08-27 00:00:00.0000000', 304.45, 314, 304.2, 312.9)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-03 00:00:00.0000000', N'UCOBANK', N'Banking', 4000, 54.1, 54.35, 53.05, 1.3, 2.45, N'2', 3268584, 2050, 1740, 310, 17.82, 5662.61, 4636.93, 1025.68, 22.12, 18052000, 17984000, 68000, 0.38, 98.37, 95.84, 2.5300000000000002, 2.64, 220000, 1.38, 24, '2015-08-27 00:00:00.0000000', 53.25, 55.5, 52.75, 54.1)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-03 00:00:00.0000000', N'BANKNIFTY', N'Index', 25, 18914.7, 18959.45, 18835.8, 123.65, 0.66, N'1', 0, 96416, 120987, -24571, -20.31, 1595977.42, 1963359.14, -367381.72, -18.71, 5635025, 4929550, 705475, 14.31, 10617.14, 9247.98, 1369.16, 14.8, 70400, 3.42, 24, '2015-08-27 00:00:00.0000000', 18782.65, 19016.4, 18782.65, 18914.7)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-03 00:00:00.0000000', N'NIFTY', N'Index', 25, 8543.05, 8561.7, 8569.65, -7.95, -0.09, N'-1', 296906150, 216574, 434763, -218189, -50.19, 6618565.72, 10341782.56, -3723216.84, -36, 119021250, 116571375, 2449875, 2.1, 98519.42, 96422.48, 2096.94, 2.17, 650450, 3.7199999999999998, 24, '2015-08-27 00:00:00.0000000', 8510.65, 8563.95, 8508.1, 8543.05)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-03 00:00:00.0000000', N'DLF', N'Realty', 2000, 115.5, 114.25, 113.35, 0.9, 0.79, N'1', 6223109, 6315, 10958, -4643, -42.37, 24106.11, 43130, -19023.89, -44.11, 33476000, 32454000, 1022000, 3.15, 379.2, 365.55, 13.65, 3.73, 678000, 2.83, 24, '2015-08-27 00:00:00.0000000', 115.1, 117.7, 113.5, 115.5)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-03 00:00:00.0000000', N'UNITECH', N'Realty', 11000, 7.7, 7.7, 7.65, 0.05, 0.65, N'1', 77729041, 6531, 3942, 2589, 65.68, 7611.54, 4977.42, 2634.12, 52.92, 188903000, 180213000, 8690000, 4.82, 148.25, 139.93, 8.32, 5.95, 3003000, 1.8, 24, '2015-08-27 00:00:00.0000000', 7.55, 8.1, 7.5, 7.7)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-03 00:00:00.0000000', N'RCOM', N'Telecom', 4000, 70.85, 71.1, 70.9, 0.2, 0.28, N'1', 5036056, 4014, 8148, -4134, -50.74, 16193.54, 43399.17, -27205.63, -62.69, 61588000, 62016000, -428000, -0.69, 439.88, 441.33, -1.45, -0.33, 836000, 1.71, 24, '2015-08-27 00:00:00.0000000', 70.45, 71.85, 70.1, 70.85)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-03 00:00:00.0000000', N'TATACOMM', N'Telecom', 500, 440, 441.3, 452.5, -11.2, -2.48, N'-2', 253029, 2487, 3022, -535, -17.7, 6333.45, 7623.2, -1289.75, -16.92, 5622000, 5557000, 65000, 1.17, 248.55, 251.63, -3.08, -1.22, 18000, 0.34, 24, '2015-08-27 00:00:00.0000000', 448.25, 452.75, 438, 440)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-04 00:00:00.0000000', N'AXISBANK', N'Banking', 500, 580.1, 582.3, 578.1, 4.2, 0.73, N'1', 5903968, 24691, 17919, 6772, 37.79, 108547, 80520.11, 28026.89, 34.81, 25833500, 26555000, -721500, -2.7199999999999998, 1509.19, 1542.31, -33.12, -2.15, 191000, 0.91, 23, '2015-08-27 00:00:00.0000000', 578.9, 584.45, 571.65, 580.1)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-04 00:00:00.0000000', N'ICICIBANK', N'Banking', 1000, 314.05, 315.1, 313.65, 1.45, 0.46, N'1', 15270894, 33860, 38235, -4375, -11.44, 183437.89, 194213.27, -10775.38, -5.55, 70708000, 72628000, -1920000, -2.64, 2221.57, 2272.72, -51.15, -2.25, 653000, 1.29, 23, '2015-08-27 00:00:00.0000000', 313.5, 315.25, 307.05, 314.05)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-04 00:00:00.0000000', N'UCOBANK', N'Banking', 4000, 55, 55.35, 54.35, 1, 1.8399999999999999, N'1', 3666641, 1698, 2050, -352, -17.17, 4560, 5662.61, -1102.61, -19.47, 17704000, 18052000, -348000, -1.9300000000000002, 98.07, 98.37, -0.3, -0.3, 236000, 1.51, 23, '2015-08-27 00:00:00.0000000', 54.4, 55.25, 53.45, 55)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-04 00:00:00.0000000', N'BANKNIFTY', N'Index', 25, 18972.6, 19059.4, 18959.45, 99.95, 0.53, N'1', 0, 184066, 96416, 87650, 90.91, 3435720.41, 1595977.42, 1839742.99, 115.27, 6532625, 5635025, 897600, 15.93, 12335.19, 10617.14, 1718.05, 16.18, 83625, 3.95, 23, '2015-08-27 00:00:00.0000000', 18968.25, 19067.35, 18758.9, 18972.6)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-04 00:00:00.0000000', N'NIFTY', N'Index', 25, 8516.9, 8547.55, 8561.7, -14.15, -0.17, N'-1', 296906150, 591394, 216574, 374820, 173.07, 16359035.4, 6618565.72, 9740469.68, 147.17, 125146400, 119021250, 6125150, 5.15, 103688.03, 98519.42, 5168.61, 5.25, 675200, 4.04, 23, '2015-08-27 00:00:00.0000000', 8564.1, 8565.15, 8448.25, 8516.9)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-04 00:00:00.0000000', N'DLF', N'Realty', 2000, 115.05, 113.7, 114.25, -0.55, -0.48, N'-1', 6607088, 7576, 6315, 1261, 19.97, 27204.97, 24106.11, 3098.86, 12.86, 33544000, 33476000, 68000, 0.2, 379.23, 379.2, 0.03, 0.01, 872000, 3.71, 23, '2015-08-27 00:00:00.0000000', 115.2, 117.05, 111.8, 115.05)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-04 00:00:00.0000000', N'UNITECH', N'Realty', 11000, 7.45, 7.55, 7.7, -0.15, -1.95, N'-1', 46186308, 4354, 6531, -2177, -33.33, 4360.93, 7611.54, -3250.61, -42.71, 188353000, 188903000, -550000, -0.29, 145.36, 148.25, -2.89, -1.95, 3124000, 1.8900000000000001, 23, '2015-08-27 00:00:00.0000000', 7.7, 7.75, 7.3, 7.45)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-04 00:00:00.0000000', N'RCOM', N'Telecom', 4000, 70.4, 70.55, 71.1, -0.55, -0.77, N'-1', 6835765, 4873, 4014, 859, 21.4, 20154.73, 16193.54, 3961.19, 24.46, 60964000, 61588000, -624000, -1.01, 433.02, 439.88, -6.86, -1.56, 904000, 1.87, 23, '2015-08-27 00:00:00.0000000', 70.7, 72.05, 69.4, 70.4)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-04 00:00:00.0000000', N'TATACOMM', N'Telecom', 500, 434.8, 437.5, 441.3, -3.8, -0.86, N'-1', 1001189, 4536, 2487, 2049, 82.39, 10751.56, 6333.45, 4418.11, 69.76, 5817000, 5622000, 195000, 3.4699999999999998, 255.07, 248.55, 6.52, 2.62, 23000, 0.42, 23, '2015-08-27 00:00:00.0000000', 440.1, 452.7, 428.1, 434.8)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-05 00:00:00.0000000', N'AXISBANK', N'Banking', 500, 580.4, 581.65, 582.3, -0.65, -0.11, N'-1', 3419273, 14024, 24691, -10667, -43.2, 59249, 108547, -49298, -45.42, 25946500, 25833500, 113000, 0.44, 1514.69, 1509.19, 5.5, 0.36, 195000, 0.93, 22, '2015-08-27 00:00:00.0000000', 582, 589.5, 576.5, 580.4)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-05 00:00:00.0000000', N'ICICIBANK', N'Banking', 1000, 311.35, 312.85, 315.1, -2.25, -0.71, N'-1', 12544057, 19364, 33860, -14496, -42.81, 102798.75, 183437.89, -80639.14, -43.96, 70277000, 70708000, -431000, -0.61, 2197.79, 2221.57, -23.78, -1.07, 690000, 1.3900000000000001, 22, '2015-08-27 00:00:00.0000000', 314.75, 319.8, 309, 311.35)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-05 00:00:00.0000000', N'UCOBANK', N'Banking', 4000, 54.65, 54.85, 55.35, -0.5, -0.9, N'-1', 2864415, 1350, 1698, -348, -20.49, 4110.59, 4560, -449.41, -9.86, 17972000, 17704000, 268000, 1.51, 98.85, 98.07, 0.78, 0.8, 308000, 1.98, 22, '2015-08-27 00:00:00.0000000', 55.45, 55.95, 54.3, 54.65)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-05 00:00:00.0000000', N'BANKNIFTY', N'Index', 25, 18928.55, 19015.55, 19059.4, -43.85, -0.23, N'-1', 0, 100234, 184066, -83832, -45.54, 1658563.46, 3435720.41, -1777156.95, -51.73, 6771275, 6532625, 238650, 3.65, 12779.62, 12335.19, 444.43, 3.6, 89500, 4.25, 22, '2015-08-27 00:00:00.0000000', 19047.3, 19103.7, 18868.65, 18928.55)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-05 00:00:00.0000000', N'NIFTY', N'Index', 25, 8567.95, 8592.65, 8547.55, 45.1, 0.53, N'1', 296906150, 311008, 591394, -280386, -47.41, 10045256.85, 16359035.4, -6313778.55, -38.6, 130219975, 125146400, 5073575, 4.05, 108097.29, 103688.03, 4409.26, 4.25, 752025, 4.32, 22, '2015-08-27 00:00:00.0000000', 8547.45, 8591.85, 8545.85, 8567.95)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-05 00:00:00.0000000', N'DLF', N'Realty', 2000, 122.1, 120.65, 113.7, 6.95, 6.11, N'3', 16047306, 16623, 7576, 9047, 119.42, 78235.63, 27204.97, 51030.66, 187.58, 38154000, 33544000, 4610000, 13.74, 455.32, 379.23, 76.09, 20.06, 894000, 3.57, 22, '2015-08-27 00:00:00.0000000', 116, 126.1, 116, 122.1)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-05 00:00:00.0000000', N'UNITECH', N'Realty', 11000, 7.85, 7.9, 7.55, 0.35, 4.64, N'3', 88163616, 8185, 4354, 3831, 87.99, 8560.54, 4360.93, 4199.61, 96.3, 201630000, 188353000, 13277000, 7.05, 161.51, 145.36, 16.15, 11.11, 3795000, 2.12, 22, '2015-08-27 00:00:00.0000000', 7.45, 8, 7.4, 7.85)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-05 00:00:00.0000000', N'RCOM', N'Telecom', 4000, 72.5, 72.55, 70.55, 2, 2.83, N'2', 8886412, 5882, 4873, 1009, 20.71, 30883.31, 20154.73, 10728.58, 53.23, 61444000, 60964000, 480000, 0.79, 447.15, 433.02, 14.13, 3.26, 936000, 1.9300000000000002, 22, '2015-08-27 00:00:00.0000000', 70.8, 73.95, 70.6, 72.5)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-05 00:00:00.0000000', N'TATACOMM', N'Telecom', 500, 436.9, 438.6, 437.5, 1.1, 0.25, N'1', 406130, 2118, 4536, -2418, -53.31, 4894.32, 10751.56, -5857.24, -54.48, 5816500, 5817000, -500, -0.01, 255.68, 255.07, 0.61, 0.24, 26000, 0.47, 22, '2015-08-27 00:00:00.0000000', 438.9, 443.25, 430.1, 436.9)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-06 00:00:00.0000000', N'AXISBANK', N'Banking', 500, 584.75, 585.35, 581.65, 3.7, 0.64, N'1', 3125993, 13350, 14024, -674, -4.8100000000000005, 54050, 59249, -5199, -8.77, 25750000, 25946500, -196500, -0.76, 1511.04, 1514.69, -3.65, -0.24, 183500, 0.88, 21, '2015-08-27 00:00:00.0000000', 580, 586.5, 578.95, 584.75)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-06 00:00:00.0000000', N'ICICIBANK', N'Banking', 1000, 311.05, 312.35, 312.85, -0.5, -0.16, N'-1', 11100077, 17887, 19364, -1477, -7.63, 92874.93, 102798.75, -9923.82, -9.65, 70049000, 70277000, -228000, -0.32, 2189.63, 2197.79, -8.16, -0.37, 793000, 1.6, 21, '2015-08-27 00:00:00.0000000', 312.75, 312.85, 307.45, 311.05)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-06 00:00:00.0000000', N'UCOBANK', N'Banking', 4000, 55.5, 55.85, 54.85, 1, 1.8199999999999998, N'1', 2698493, 1201, 1350, -149, -11.04, 3097.32, 4110.59, -1013.27, -24.65, 18272000, 17972000, 300000, 1.67, 102.05, 98.85, 3.2, 3.24, 296000, 1.87, 21, '2015-08-27 00:00:00.0000000', 54.9, 55.8, 53.8, 55.5)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-06 00:00:00.0000000', N'BANKNIFTY', N'Index', 25, 19029.35, 19098.95, 19015.55, 83.4, 0.44, N'1', 0, 108537, 100234, 8303, 8.28, 1830224.67, 1658563.46, 171661.21, 10.35, 7099175, 6771275, 327900, 4.84, 13421.52, 12779.62, 641.9, 5.02, 95525, 4.38, 21, '2015-08-27 00:00:00.0000000', 18946.3, 19100.55, 18830.4, 19029.35)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-06 00:00:00.0000000', N'NIFTY', N'Index', 25, 8588.65, 8615, 8592.65, 22.35, 0.26, N'1', 296906150, 309967, 311008, -1041, -0.33, 9977960.04, 10045256.85, -67296.81, -0.67, 135036150, 130219975, 4816175, 3.7, 112227.55, 108097.29, 4130.26, 3.82, 798000, 4.51, 21, '2015-08-27 00:00:00.0000000', 8585.8, 8606.3, 8551.5, 8588.65)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-06 00:00:00.0000000', N'DLF', N'Realty', 2000, 122.45, 121.05, 120.65, 0.4, 0.33, N'1', 9919996, 10350, 16623, -6273, -37.74, 44580.14, 78235.63, -33655.49, -43.02, 39538000, 38154000, 1384000, 3.63, 473.56, 455.32, 18.24, 4.01, 902000, 3.5300000000000002, 21, '2015-08-27 00:00:00.0000000', 121.75, 125.6, 120.1, 122.45)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-06 00:00:00.0000000', N'UNITECH', N'Realty', 11000, 7.85, 7.95, 7.9, 0.05, 0.63, N'1', 72313239, 7398, 8185, -787, -9.62, 7927.08, 8560.54, -633.46, -7.4, 203841000, 201630000, 2211000, 1.1, 164.67, 161.51, 3.16, 1.96, 4389000, 2.46, 21, '2015-08-27 00:00:00.0000000', 7.85, 8.25, 7.55, 7.85)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-06 00:00:00.0000000', N'RCOM', N'Telecom', 4000, 72.5, 72.8, 72.55, 0.25, 0.34, N'1', 4240902, 3073, 5882, -2809, -47.76, 14914.77, 30883.31, -15968.54, -51.71, 62452000, 61444000, 1008000, 1.6400000000000001, 456.01, 447.15, 8.86, 1.98, 1032000, 2.12, 21, '2015-08-27 00:00:00.0000000', 72.65, 72.95, 71.4, 72.5)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-06 00:00:00.0000000', N'TATACOMM', N'Telecom', 500, 438.55, 440.3, 438.6, 1.7, 0.39, N'1', 398691, 2507, 2118, 389, 18.37, 5901.04, 4894.32, 1006.72, 20.57, 5707500, 5816500, -109000, -1.87, 251.8, 255.68, -3.88, -1.52, 28500, 0.53, 21, '2015-08-27 00:00:00.0000000', 436.15, 443.8, 431.55, 438.55)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-07 00:00:00.0000000', N'AXISBANK', N'Banking', 500, 580.3, 581.15, 585.35, -4.2, -0.72, N'-1', 2298504, 9376, 13350, -3974, -29.77, 37948.87, 54050, -16101.13, -29.79, 25608500, 25750000, -141500, -0.55, 1494.13, 1511.04, -16.91, -1.12, 207500, 1.01, 20, '2015-08-27 00:00:00.0000000', 584.9, 584.9, 576, 580.3)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-07 00:00:00.0000000', N'ICICIBANK', N'Banking', 1000, 310.15, 311.35, 312.35, -1, -0.32, N'-1', 5650310, 10969, 17887, -6918, -38.68, 66427.84, 92874.93, -26447.09, -28.48, 71601000, 70049000, 1552000, 2.22, 2233.09, 2189.63, 43.46, 1.98, 812000, 1.6400000000000001, 20, '2015-08-27 00:00:00.0000000', 309.9, 312.55, 308.45, 310.15)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-07 00:00:00.0000000', N'UCOBANK', N'Banking', 4000, 54.55, 54.75, 55.85, -1.1, -1.97, N'-1', 1666629, 919, 1201, -282, -23.48, 2556.98, 3097.32, -540.34, -17.45, 18308000, 18272000, 36000, 0.2, 100.49, 102.05, -1.56, -1.53, 292000, 1.8599999999999999, 20, '2015-08-27 00:00:00.0000000', 55.45, 55.6, 54.2, 54.55)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-07 00:00:00.0000000', N'BANKNIFTY', N'Index', 25, 18893.55, 18979.9, 19098.95, -119.05, -0.62, N'-1', 0, 79654, 108537, -28883, -26.61, 1450316.24, 1830224.67, -379908.43, -20.76, 6857025, 7099175, -242150, -3.41, 12944.46, 13421.52, -477.06, -3.55, 93300, 4.5600000000000005, 20, '2015-08-27 00:00:00.0000000', 18992.8, 19019.65, 18849.15, 18893.55)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-07 00:00:00.0000000', N'NIFTY', N'Index', 25, 8564.6, 8594.1, 8615, -20.9, -0.24, N'-1', 296906150, 232634, 309967, -77333, -24.95, 8039306.17, 9977960.04, -1938653.87, -19.43, 136767350, 135036150, 1731200, 1.28, 113658.88, 112227.55, 1431.33, 1.28, 829800, 4.7, 20, '2015-08-27 00:00:00.0000000', 8580.8, 8595.95, 8552.7, 8564.6)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-07 00:00:00.0000000', N'DLF', N'Realty', 2000, 125.7, 124.25, 121.05, 3.2, 2.64, N'2', 11513533, 12058, 10350, 1708, 16.5, 46220.39, 44580.14, 1640.25, 3.68, 41598000, 39538000, 2060000, 5.21, 506.82, 473.56, 33.26, 7.02, 940000, 3.5, 20, '2015-08-27 00:00:00.0000000', 121.3, 126.6, 120.05, 125.7)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-07 00:00:00.0000000', N'UNITECH', N'Realty', 11000, 7.8, 7.85, 7.95, -0.1, -1.26, N'-1', 49163606, 4409, 7398, -2989, -40.4, 4506.17, 7927.08, -3420.91, -43.15, 206481000, 203841000, 2640000, 1.3, 164.98, 164.67, 0.31, 0.19, 4796000, 2.66, 20, '2015-08-27 00:00:00.0000000', 7.85, 8, 7.65, 7.8)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-07 00:00:00.0000000', N'RCOM', N'Telecom', 4000, 73.3, 73.8, 72.8, 1, 1.37, N'1', 5486114, 5217, 3073, 2144, 69.77, 25198.71, 14914.77, 10283.94, 68.95, 65564000, 62452000, 3112000, 4.98, 483.74, 456.01, 27.73, 6.08, 1116000, 2.23, 20, '2015-08-27 00:00:00.0000000', 72.5, 74.45, 71.15, 73.3)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-07 00:00:00.0000000', N'TATACOMM', N'Telecom', 500, 444.3, 446.3, 440.3, 6, 1.3599999999999999, N'1', 765839, 3270, 2507, 763, 30.43, 7773.47, 5901.04, 1872.43, 31.73, 5956000, 5707500, 248500, 4.35, 266.13, 251.8, 14.33, 5.6899999999999995, 36500, 0.65, 20, '2015-08-27 00:00:00.0000000', 440, 448.65, 439, 444.3)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-10 00:00:00.0000000', N'AXISBANK', N'Banking', 500, 575.9, 577.95, 581.15, -3.2, -0.55, N'-1', 2402572, 12056, 9376, 2680, 28.58, 48954.44, 37948.87, 11005.57, 29, 25904000, 25608500, 295500, 1.15, 1505.12, 1494.13, 10.99, 0.74, 222500, 1.08, 17, '2015-08-27 00:00:00.0000000', 582.75, 584.7, 570.75, 575.9)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-10 00:00:00.0000000', N'ICICIBANK', N'Banking', 1000, 309.6, 310.5, 311.35, -0.85, -0.27, N'-1', 6998388, 13824, 10969, 2855, 26.03, 71116.39, 66427.84, 4688.55, 7.06, 71156000, 71601000, -445000, -0.62, 2215.79, 2233.09, -17.3, -0.77, 828000, 1.6800000000000002, 17, '2015-08-27 00:00:00.0000000', 310, 314, 307.15, 309.6)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-10 00:00:00.0000000', N'UCOBANK', N'Banking', 4000, 52.8, 52.95, 54.75, -1.8, -3.29, N'-2', 2994901, 1672, 919, 753, 81.94, 5251.66, 2556.98, 2694.68, 105.39, 18892000, 18308000, 584000, 3.19, 100.69, 100.49, 0.2, 0.2, 336000, 2.15, 17, '2015-08-27 00:00:00.0000000', 52.4, 53.7, 52.1, 52.8)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-10 00:00:00.0000000', N'BANKNIFTY', N'Index', 25, 18875, 18959.3, 18979.9, -20.6, -0.11, N'-1', 0, 105920, 79654, 26266, 32.98, 1783475.75, 1450316.24, 333159.51, 22.97, 7106150, 6857025, 249125, 3.63, 13417.43, 12944.46, 472.97, 3.65, 109425, 5.03, 17, '2015-08-27 00:00:00.0000000', 18926.1, 19071.35, 18781.3, 18875)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-10 00:00:00.0000000', N'NIFTY', N'Index', 25, 8525.6, 8544.3, 8594.1, -49.8, -0.58, N'-1', 296906150, 386538, 232634, 153904, 66.16, 12509616.52, 8039306.17, 4470310.35, 55.61, 137979475, 136767350, 1212125, 0.89, 114633.34, 113658.88, 974.46, 0.86, 886025, 5.07, 17, '2015-08-27 00:00:00.0000000', 8577, 8621.55, 8497.8, 8525.6)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-10 00:00:00.0000000', N'DLF', N'Realty', 2000, 128.3, 126.45, 124.25, 2.2, 1.77, N'1', 10318987, 13207, 12058, 1149, 9.53, 55686.52, 46220.39, 9466.13, 20.48, 42564000, 41598000, 966000, 2.32, 524.69, 506.82, 17.87, 3.5300000000000002, 924000, 3.4, 17, '2015-08-27 00:00:00.0000000', 125.05, 130.4, 123.6, 128.3)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-10 00:00:00.0000000', N'UNITECH', N'Realty', 11000, 7.95, 8, 7.85, 0.15, 1.9100000000000001, N'1', 60080711, 4878, 4409, 469, 10.64, 5112.33, 4506.17, 606.16, 13.45, 211266000, 206481000, 4785000, 2.32, 171.41, 164.98, 6.43, 3.9, 5016000, 2.73, 17, '2015-08-27 00:00:00.0000000', 7.8, 8.25, 7.75, 7.95)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-10 00:00:00.0000000', N'RCOM', N'Telecom', 4000, 72.15, 72.25, 73.8, -1.55, -2.1, N'-2', 4873284, 3952, 5217, -1265, -24.25, 19999.62, 25198.71, -5199.09, -20.63, 65912000, 65564000, 348000, 0.53, 479.34, 483.74, -4.4, -0.91, 1300000, 2.6, 17, '2015-08-27 00:00:00.0000000', 74, 74.85, 71.6, 72.15)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-10 00:00:00.0000000', N'TATACOMM', N'Telecom', 500, 447, 448.65, 446.3, 2.35, 0.53, N'1', 344740, 1691, 3270, -1579, -48.29, 4057.53, 7773.47, -3715.94, -47.8, 6138000, 5956000, 182000, 3.06, 275.63, 266.13, 9.5, 3.57, 39000, 0.67, 17, '2015-08-27 00:00:00.0000000', 445.4, 449.9, 440.5, 447)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-11 00:00:00.0000000', N'AXISBANK', N'Banking', 500, 571.25, 571.95, 577.95, -6, -1.04, N'-1', 3168648, 17917, 12056, 5861, 48.61, 74349.6, 48954.44, 25395.16, 51.88, 26276000, 25904000, 372000, 1.44, 1513.85, 1505.12, 8.73, 0.58, 263500, 1.26, 16, '2015-08-27 00:00:00.0000000', 577.7, 580.85, 566.35, 571.25)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-11 00:00:00.0000000', N'ICICIBANK', N'Banking', 1000, 302.25, 303.6, 310.5, -6.9, -2.22, N'-2', 9482905, 19837, 13824, 6013, 43.5, 109068.24, 71116.39, 37951.85, 53.37, 72514000, 71156000, 1358000, 1.9100000000000001, 2222.92, 2215.79, 7.13, 0.32, 1010000, 2, 16, '2015-08-27 00:00:00.0000000', 309.9, 309.9, 300.75, 302.25)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-11 00:00:00.0000000', N'UCOBANK', N'Banking', 4000, 51.8, 51.95, 52.95, -1, -1.8900000000000001, N'-1', 2461034, 1739, 1672, 67, 4.01, 4427.22, 5251.66, -824.44, -15.7, 18852000, 18892000, -40000, -0.21, 98.9, 100.69, -1.79, -1.78, 396000, 2.5, 16, '2015-08-27 00:00:00.0000000', 53, 53.3, 51.05, 51.8)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-11 00:00:00.0000000', N'BANKNIFTY', N'Index', 25, 18616.9, 18687.05, 18959.3, -272.25, -1.44, N'-1', 0, 145258, 105920, 39338, 37.14, 2744253.11, 1783475.75, 960777.36, 53.87, 7635275, 7106150, 529125, 7.45, 14362.89, 13417.43, 945.46, 7.05, 125975, 5.29, 16, '2015-08-27 00:00:00.0000000', 18918.55, 18918.55, 18555.5, 18616.9)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-11 00:00:00.0000000', N'NIFTY', N'Index', 25, 8462.35, 8490.8, 8544.3, -53.5, -0.63, N'-1', 296906150, 431892, 386538, 45354, 11.73, 14860197.02, 12509616.52, 2350580.5, 18.79, 138707650, 137979475, 728175, 0.53, 115130.25, 114633.34, 496.91, 0.43, 920100, 5.27, 16, '2015-08-27 00:00:00.0000000', 8548.45, 8556.25, 8441.3, 8462.35)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-11 00:00:00.0000000', N'DLF', N'Realty', 2000, 124.35, 122.8, 126.45, -3.65, -2.89, N'-2', 7569814, 10391, 13207, -2816, -21.32, 42523.64, 55686.52, -13162.88, -23.64, 40682000, 42564000, -1882000, -4.42, 492.18, 524.69, -32.51, -6.2, 902000, 3.56, 16, '2015-08-27 00:00:00.0000000', 128.45, 129.7, 122.2, 124.35)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-11 00:00:00.0000000', N'UNITECH', N'Realty', 11000, 7.7, 7.8, 8, -0.2, -2.5, N'-2', 32471196, 3091, 4878, -1787, -36.63, 3103.67, 5112.33, -2008.66, -39.29, 208648000, 211266000, -2618000, -1.24, 165.69, 171.41, -5.72, -3.34, 5412000, 2.98, 16, '2015-08-27 00:00:00.0000000', 7.95, 7.95, 7.65, 7.7)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-11 00:00:00.0000000', N'RCOM', N'Telecom', 4000, 70.4, 70.5, 72.25, -1.75, -2.42, N'-2', 5059712, 4002, 3952, 50, 1.27, 19137.65, 19999.62, -861.97, -4.31, 67404000, 65912000, 1492000, 2.26, 480.74, 479.34, 1.4, 0.29, 1544000, 3.08, 16, '2015-08-27 00:00:00.0000000', 72.25, 72.85, 69.8, 70.4)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-11 00:00:00.0000000', N'TATACOMM', N'Telecom', 500, 441.25, 443.1, 448.65, -5.55, -1.24, N'-1', 227038, 1350, 1691, -341, -20.17, 3152.08, 4057.53, -905.45, -22.32, 6189000, 6138000, 51000, 0.83, 274.65, 275.63, -0.98, -0.36, 40500, 0.69, 16, '2015-08-27 00:00:00.0000000', 447.45, 452.8, 438.85, 441.25)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-12 00:00:00.0000000', N'AXISBANK', N'Banking', 500, 557.85, 560.4, 571.95, -11.55, -2.02, N'-2', 4787034, 18607, 17917, 690, 3.85, 78717.52, 74349.6, 4367.92, 5.87, 27821500, 26276000, 1545500, 5.88, 1576.26, 1513.85, 62.41, 4.12, 324000, 1.47, 15, '2015-08-27 00:00:00.0000000', 569.4, 569.8, 556, 557.85)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-12 00:00:00.0000000', N'ICICIBANK', N'Banking', 1000, 291.65, 293, 303.6, -10.6, -3.49, N'-2', 9356855, 22025, 19837, 2188, 11.03, 120335.3, 109068.24, 11267.06, 10.33, 75530000, 72514000, 3016000, 4.16, 2259.43, 2222.92, 36.51, 1.6400000000000001, 1395000, 2.64, 15, '2015-08-27 00:00:00.0000000', 300, 300.15, 290.1, 291.65)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-12 00:00:00.0000000', N'UCOBANK', N'Banking', 4000, 51.6, 51.9, 51.95, -0.05, -0.1, N'-1', 2398174, 1284, 1739, -455, -26.16, 3295.98, 4427.22, -1131.24, -25.55, 18160000, 18852000, -692000, -3.67, 95.23, 98.9, -3.67, -3.71, 412000, 2.71, 15, '2015-08-27 00:00:00.0000000', 51.65, 52.45, 50.9, 51.6)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-12 00:00:00.0000000', N'BANKNIFTY', N'Index', 25, 18059.75, 18135.75, 18687.05, -551.3, -2.95, N'-2', 0, 171986, 145258, 26728, 18.4, 3681086.19, 2744253.11, 936833.08, 34.14, 8679600, 7635275, 1044325, 13.68, 16128.69, 14362.89, 1765.8, 12.29, 151200, 5.88, 15, '2015-08-27 00:00:00.0000000', 18515.2, 18515.2, 18034.75, 18059.75)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-12 00:00:00.0000000', N'NIFTY', N'Index', 25, 8349.45, 8365.45, 8490.8, -125.35, -1.48, N'-1', 296906150, 545730, 431892, 113838, 26.36, 18456362.31, 14860197.02, 3596165.29, 24.2, 143913500, 138707650, 5205850, 3.75, 119196.8, 115130.25, 4066.55, 3.5300000000000002, 913625, 5.4, 15, '2015-08-27 00:00:00.0000000', 8445.7, 8446.95, 8337.95, 8349.45)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-12 00:00:00.0000000', N'DLF', N'Realty', 2000, 117.1, 115.65, 122.8, -7.15, -5.82, N'-3', 7258249, 10763, 10391, 372, 3.58, 49246.06, 42523.64, 6722.42, 15.81, 43428000, 40682000, 2746000, 6.75, 503.23, 492.18, 11.05, 2.25, 948000, 3.68, 15, '2015-08-27 00:00:00.0000000', 122.5, 123.65, 115.6, 117.1)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-12 00:00:00.0000000', N'UNITECH', N'Realty', 11000, 7.2, 7.25, 7.8, -0.55, -7.05, N'-3', 44919918, 4397, 3091, 1306, 42.25, 4164.54, 3103.67, 1060.87, 34.18, 206965000, 208648000, -1683000, -0.81, 154.55, 165.69, -11.14, -6.72, 6435000, 3.61, 15, '2015-08-27 00:00:00.0000000', 7.65, 7.65, 7.1, 7.2)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-12 00:00:00.0000000', N'RCOM', N'Telecom', 4000, 66.7, 67, 70.5, -3.5, -4.96, N'-3', 5574800, 4059, 4002, 57, 1.42, 21084.98, 19137.65, 1947.33, 10.18, 67676000, 67404000, 272000, 0.4, 465.04, 480.74, -15.7, -3.27, 1832000, 3.74, 15, '2015-08-27 00:00:00.0000000', 69.7, 70.7, 66.35, 66.7)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-12 00:00:00.0000000', N'TATACOMM', N'Telecom', 500, 417.05, 419.35, 443.1, -23.75, -5.36, N'-3', 734819, 3151, 1350, 1801, 133.41, 7312.06, 3152.08, 4159.98, 131.98, 6341500, 6189000, 152500, 2.46, 267.09, 274.65, -7.5600000000000005, -2.75, 57500, 0.95, 15, '2015-08-27 00:00:00.0000000', 438.65, 441.8, 413.65, 417.05)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-13 00:00:00.0000000', N'AXISBANK', N'Banking', 500, 567.55, 570.9, 560.4, 10.5, 1.87, N'1', 5982710, 17143, 18607, -1464, -7.87, 72891.14, 78717.52, -5826.38, -7.4, 28458500, 27821500, 637000, 2.29, 1635.02, 1576.26, 58.76, 3.73, 353000, 1.5699999999999998, 14, '2015-08-27 00:00:00.0000000', 563.5, 571.45, 560, 567.55)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-13 00:00:00.0000000', N'ICICIBANK', N'Banking', 1000, 291.9, 293.2, 293, 0.2, 0.07, N'1', 12504278, 20165, 22025, -1860, -8.44, 103671.15, 120335.3, -16664.15, -13.85, 77000000, 75530000, 1470000, 1.95, 2302.19, 2259.43, 42.76, 1.8900000000000001, 1579000, 2.93, 14, '2015-08-27 00:00:00.0000000', 295.25, 298.7, 290.85, 291.9)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-13 00:00:00.0000000', N'UCOBANK', N'Banking', 4000, 50.7, 50.95, 51.9, -0.95, -1.83, N'-1', 2060022, 1151, 1284, -133, -10.36, 3033.22, 3295.98, -262.76, -7.97, 18188000, 18160000, 28000, 0.15, 93.92, 95.23, -1.31, -1.38, 496000, 3.23, 14, '2015-08-27 00:00:00.0000000', 52.3, 52.75, 50.3, 50.7)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-13 00:00:00.0000000', N'BANKNIFTY', N'Index', 25, 18175.4, 18243, 18135.75, 107.25, 0.59, N'1', 0, 138103, 171986, -33883, -19.7, 3149049.81, 3681086.19, -532036.38, -14.45, 8825400, 8679600, 145800, 1.6800000000000002, 16422.99, 16128.69, 294.3, 1.8199999999999998, 153775, 6.4, 14, '2015-08-27 00:00:00.0000000', 18211.5, 18359.25, 18080.5, 18175.4)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-13 00:00:00.0000000', N'NIFTY', N'Index', 25, 8355.85, 8381, 8365.45, 15.55, 0.19, N'1', 296906150, 482751, 545730, -62979, -11.54, 17195177.51, 18456362.31, -1261184.8, -6.83, 147612050, 143913500, 3698550, 2.57, 122231.41, 119196.8, 3034.61, 2.55, 951450, 5.72, 14, '2015-08-27 00:00:00.0000000', 8384.45, 8429.5, 8339.75, 8355.85)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-13 00:00:00.0000000', N'DLF', N'Realty', 2000, 114.25, 112.9, 115.65, -2.75, -2.38, N'-2', 8351901, 12115, 10763, 1352, 12.56, 60010.07, 49246.06, 10764.01, 21.86, 43688000, 43428000, 260000, 0.6, 499.18, 503.23, -4.05, -0.8, 960000, 3.71, 14, '2015-08-27 00:00:00.0000000', 118.05, 122, 110.5, 114.25)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-13 00:00:00.0000000', N'UNITECH', N'Realty', 11000, 7, 7, 7.25, -0.25, -3.45, N'-2', 59210241, 5213, 4397, 816, 18.56, 5046.3, 4164.54, 881.76, 21.17, 210892000, 206965000, 3927000, 1.9, 152.94, 154.55, -1.6099999999999999, -1.04, 7821000, 4.42, 14, '2015-08-27 00:00:00.0000000', 7.2, 7.4, 6.9, 7)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-13 00:00:00.0000000', N'RCOM', N'Telecom', 4000, 60.1, 60.4, 67, -6.6, -9.85, N'-3', 31323786, 14705, 4059, 10646, 262.28, 75440.43, 21084.98, 54355.45, 257.79, 78216000, 67676000, 10540000, 15.57, 499.7, 465.04, 34.66, 7.45, 2608000, 5, 14, '2015-08-27 00:00:00.0000000', 68, 69.1, 58.75, 60.1)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-13 00:00:00.0000000', N'TATACOMM', N'Telecom', 500, 419.9, 420.95, 419.35, 1.6, 0.38, N'1', 851632, 2743, 3151, -408, -12.95, 6098.21, 7312.06, -1213.85, -16.6, 6450500, 6341500, 109000, 1.72, 272.6, 267.09, 5.51, 2.06, 117000, 1.9100000000000001, 14, '2015-08-27 00:00:00.0000000', 420.5, 428, 416, 419.9)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-14 00:00:00.0000000', N'AXISBANK', N'Banking', 500, 570, 573.35, 570.9, 2.45, 0.43, N'1', 7528941, 37693, 17143, 20550, 119.87, 160665.86, 72891.14, 87774.72, 120.42, 29120500, 28458500, 662000, 2.33, 1677.34, 1635.02, 42.32, 2.59, 641000, 2.8, 13, '2015-08-27 00:00:00.0000000', 565.15, 574.25, 554.85, 570)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-14 00:00:00.0000000', N'ICICIBANK', N'Banking', 1000, 302.6, 303.7, 293.2, 10.5, 3.58, N'2', 8790774, 22830, 20165, 2665, 13.22, 119266.58, 103671.15, 15595.43, 15.04, 74368000, 77000000, -2632000, -3.42, 2277.46, 2302.19, -24.73, -1.07, 1577000, 3, 13, '2015-08-27 00:00:00.0000000', 294.25, 303.8, 292.05, 302.6)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-14 00:00:00.0000000', N'UCOBANK', N'Banking', 4000, 53.05, 53.3, 50.95, 2.35, 4.61, N'3', 3143603, 2192, 1151, 1041, 90.44, 6260.29, 3033.22, 3227.07, 106.39, 17928000, 18188000, -260000, -1.43, 96.05, 93.92, 2.13, 2.27, 564000, 3.66, 13, '2015-08-27 00:00:00.0000000', 51.3, 53.45, 49.7, 53.05)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-14 00:00:00.0000000', N'BANKNIFTY', N'Index', 25, 18723.6, 18791.15, 18243, 548.15, 3, N'2', 0, 181163, 138103, 43060, 31.18, 4026803.51, 3149049.81, 877753.7, 27.87, 8567075, 8825400, -258325, -2.93, 16047.84, 16422.99, -375.15, -2.2800000000000002, 174825, 7.52, 13, '2015-08-27 00:00:00.0000000', 18275.5, 18766, 18193.1, 18723.6)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-14 00:00:00.0000000', N'NIFTY', N'Index', 25, 8518.55, 8542.7, 8381, 161.7, 1.9300000000000002, N'1', 296906150, 568236, 482751, 85485, 17.71, 19874490.15, 17195177.51, 2679312.64, 15.58, 149534125, 147612050, 1922075, 1.3, 124074.88, 122231.41, 1843.47, 1.51, 1246375, 7.65, 13, '2015-08-27 00:00:00.0000000', 8402.35, 8530.1, 8381.2, 8518.55)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-14 00:00:00.0000000', N'DLF', N'Realty', 2000, 135.25, 133.35, 112.9, 20.45, 18.11, N'3', 27751885, 34533, 12115, 22418, 185.04, 187917.31, 60010.07, 127907.24, 213.14, 60196000, 43688000, 16508000, 37.79, 767.35, 499.18, 268.17, 53.72, 1268000, 3.66, 13, '2015-08-27 00:00:00.0000000', 116, 136.7, 113, 135.25)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-14 00:00:00.0000000', N'UNITECH', N'Realty', 11000, 7.35, 7.4, 7, 0.4, 5.71, N'3', 89779447, 9204, 5213, 3991, 76.56, 9394.89, 5046.3, 4348.59, 86.17, 222827000, 210892000, 11935000, 5.66, 168.94, 152.94, 16, 10.46, 8503000, 4.54, 13, '2015-08-27 00:00:00.0000000', 6.95, 7.55, 6.55, 7.35)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-14 00:00:00.0000000', N'RCOM', N'Telecom', 4000, 60.9, 60.85, 60.4, 0.45, 0.75, N'1', 13394085, 8700, 14705, -6005, -40.84, 44987.12, 75440.43, -30453.31, -40.37, 85332000, 78216000, 7116000, 9.1, 545.12, 499.7, 45.42, 9.09, 3356000, 6.05, 13, '2015-08-27 00:00:00.0000000', 60.8, 62.2, 58.2, 60.9)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-14 00:00:00.0000000', N'TATACOMM', N'Telecom', 500, 423, 425.8, 420.95, 4.85, 1.15, N'1', 333893, 1485, 2743, -1258, -45.86, 3399.04, 6098.21, -2699.17, -44.26, 6590500, 6450500, 140000, 2.17, 281.51, 272.6, 8.91, 3.27, 139500, 2.23, 13, '2015-08-27 00:00:00.0000000', 423.45, 426, 416.15, 423)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-17 00:00:00.0000000', N'AXISBANK', N'Banking', 500, 561.4, 562.95, 573.35, -10.4, -1.81, N'-1', 4466163, 20589, 37693, -17104, -45.38, 86581.51, 160665.86, -74084.35, -46.11, 31423500, 29120500, 2303000, 7.91, 1784.72, 1677.34, 107.38, 6.4, 870500, 3.59, 10, '2015-08-27 00:00:00.0000000', 569.75, 571.75, 560.05, 561.4)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-17 00:00:00.0000000', N'ICICIBANK', N'Banking', 1000, 302.9, 303.35, 303.7, -0.35, -0.12, N'-1', 7573765, 17791, 22830, -5039, -22.07, 86109.07, 119266.58, -33157.51, -27.8, 74539000, 74368000, 171000, 0.23, 2280.72, 2277.46, 3.26, 0.14, 1678000, 3.21, 10, '2015-08-27 00:00:00.0000000', 301.95, 304.7, 296.85, 302.9)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-17 00:00:00.0000000', N'UCOBANK', N'Banking', 4000, 55.85, 56.1, 53.3, 2.8, 5.25, N'3', 4479984, 2622, 2192, 430, 19.62, 6936.9, 6260.29, 676.61, 10.81, 18456000, 17928000, 528000, 2.95, 103.32, 96.05, 7.27, 7.57, 580000, 3.65, 10, '2015-08-27 00:00:00.0000000', 53.8, 56.2, 53.55, 55.85)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-17 00:00:00.0000000', N'BANKNIFTY', N'Index', 25, 18822.05, 18842.25, 18791.15, 51.1, 0.27, N'1', 0, 137954, 181163, -43209, -23.85, 3050362.44, 4026803.51, -976441.07, -24.25, 8819425, 8567075, 252350, 2.95, 16554.66, 16047.84, 506.82, 3.16, 181700, 7.96, 10, '2015-08-27 00:00:00.0000000', 18763.05, 18896.45, 18580.65, 18822.05)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-17 00:00:00.0000000', N'NIFTY', N'Index', 25, 8477.3, 8488.05, 8542.7, -54.65, -0.64, N'-1', 296906150, 480902, 568236, -87334, -15.37, 19292975.83, 19874490.15, -581514.32, -2.93, 149660600, 149534125, 126475, 0.08, 124143.03, 124074.88, 68.15, 0.05, 1404025, 8.83, 10, '2015-08-27 00:00:00.0000000', 8530.5, 8530.6, 8428.05, 8477.3)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-17 00:00:00.0000000', N'DLF', N'Realty', 2000, 129.3, 129.8, 133.35, -3.55, -2.66, N'-2', 14297576, 14546, 34533, -19987, -57.88, 75466.82, 187917.31, -112450.49, -59.84, 58590000, 60196000, -1606000, -2.67, 737.98, 767.35, -29.37, -3.83, 1250000, 3.88, 10, '2015-08-27 00:00:00.0000000', 132.7, 133.8, 127.75, 129.3)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-17 00:00:00.0000000', N'UNITECH', N'Realty', 11000, 7, 7.05, 7.4, -0.35, -4.73, N'-3', 58131146, 5597, 9204, -3607, -39.19, 5302.68, 9394.89, -4092.21, -43.56, 222948000, 222827000, 121000, 0.05, 162.58, 168.94, -6.36, -3.76, 10230000, 5.51, 10, '2015-08-27 00:00:00.0000000', 7.3, 7.35, 6.65, 7)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-17 00:00:00.0000000', N'RCOM', N'Telecom', 4000, 62.25, 62.3, 60.85, 1.45, 2.38, N'2', 11096587, 8572, 8700, -128, -1.47, 47391.8, 44987.12, 2404.68, 5.35, 84932000, 85332000, -400000, -0.47, 550.61, 545.12, 5.49, 1.01, 3548000, 6.4, 10, '2015-08-27 00:00:00.0000000', 60, 63.7, 58.6, 62.25)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-17 00:00:00.0000000', N'TATACOMM', N'Telecom', 500, 415.55, 417.35, 425.8, -8.45, -1.98, N'-1', 523366, 2632, 1485, 1147, 77.24, 6051.07, 3399.04, 2652.03, 78.02, 6726000, 6590500, 135500, 2.06, 281.91, 281.51, 0.4, 0.14, 161500, 2.54, 10, '2015-08-27 00:00:00.0000000', 424.5, 429, 410, 415.55)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-18 00:00:00.0000000', N'AXISBANK', N'Banking', 500, 561.35, 562.6, 562.95, -0.35, -0.06, N'-1', 2952439, 16682, 20589, -3907, -18.98, 76188.63, 86581.51, -10392.88, -12, 31439000, 31423500, 15500, 0.05, 1784.59, 1784.72, -0.13, -0.01, 1063500, 4.41, 9, '2015-08-27 00:00:00.0000000', 567, 567.25, 555.5, 561.35)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-18 00:00:00.0000000', N'ICICIBANK', N'Banking', 1000, 301.1, 301.7, 303.35, -1.65, -0.54, N'-1', 5396784, 16310, 17791, -1481, -8.32, 80215.28, 86109.07, -5893.79, -6.84, 75507000, 74539000, 968000, 1.3, 2301.53, 2280.72, 20.81, 0.91, 2260000, 4.25, 9, '2015-08-27 00:00:00.0000000', 303, 304.2, 297.7, 301.1)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-18 00:00:00.0000000', N'UCOBANK', N'Banking', 4000, 55.45, 55.6, 56.1, -0.5, -0.89, N'-1', 3614549, 2064, 2622, -558, -21.28, 5661.9, 6936.9, -1275, -18.38, 18972000, 18456000, 516000, 2.8, 105.44, 103.32, 2.12, 2.05, 728000, 4.52, 9, '2015-08-27 00:00:00.0000000', 55.8, 57.15, 54.6, 55.45)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-18 00:00:00.0000000', N'BANKNIFTY', N'Index', 25, 18780.85, 18812.55, 18842.25, -29.7, -0.16, N'-1', 0, 140071, 137954, 2117, 1.53, 2962955.84, 3050362.44, -87406.6, -2.87, 8962625, 8819425, 143200, 1.62, 16836.13, 16554.66, 281.47, 1.7, 193850, 8.84, 9, '2015-08-27 00:00:00.0000000', 18862.15, 18874.1, 18595.5, 18780.85)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-18 00:00:00.0000000', N'NIFTY', N'Index', 25, 8466.55, 8481.7, 8488.05, -6.35, -0.07, N'-1', 296906150, 403590, 480902, -77312, -16.08, 18022930.11, 19292975.83, -1270045.72, -6.58, 152483825, 149660600, 2823225, 1.8900000000000001, 126444.4, 124143.03, 2301.37, 1.85, 1557825, 9.85, 9, '2015-08-27 00:00:00.0000000', 8505.85, 8525.75, 8433.6, 8466.55)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-18 00:00:00.0000000', N'DLF', N'Realty', 2000, 128.05, 128.8, 129.8, -1, -0.77, N'-1', 12797745, 15710, 14546, 1164, 8, 78648.53, 75466.82, 3181.71, 4.22, 61858000, 58590000, 3268000, 5.58, 777.45, 737.98, 39.47, 5.35, 1442000, 4.05, 9, '2015-08-27 00:00:00.0000000', 130, 131.7, 124.85, 128.05)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-18 00:00:00.0000000', N'UNITECH', N'Realty', 11000, 7.1, 7.15, 7.05, 0.1, 1.42, N'1', 34121544, 3330, 5597, -2267, -40.5, 3173.88, 5302.68, -2128.8, -40.15, 225137000, 222948000, 2189000, 0.98, 166.24, 162.58, 3.66, 2.25, 11077000, 5.91, 9, '2015-08-27 00:00:00.0000000', 7.1, 7.25, 6.8, 7.1)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-18 00:00:00.0000000', N'RCOM', N'Telecom', 4000, 61.35, 61.4, 62.3, -0.9, -1.44, N'-1', 6690985, 4627, 8572, -3945, -46.02, 21150.33, 47391.8, -26241.47, -55.37, 87332000, 84932000, 2400000, 2.83, 560.72, 550.61, 10.11, 1.8399999999999999, 4120000, 7.21, 9, '2015-08-27 00:00:00.0000000', 62.75, 63.25, 60.65, 61.35)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-18 00:00:00.0000000', N'TATACOMM', N'Telecom', 500, 412.15, 413.95, 417.35, -3.4, -0.81, N'-1', 494916, 3305, 2632, 673, 25.57, 7155.89, 6051.07, 1104.82, 18.26, 6902500, 6726000, 176500, 2.62, 287.05, 281.91, 5.14, 1.8199999999999998, 358500, 5.49, 9, '2015-08-27 00:00:00.0000000', 417, 419.7, 409.75, 412.15)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-19 00:00:00.0000000', N'AXISBANK', N'Banking', 500, 554, 555.5, 562.6, -7.1, -1.26, N'-1', 4135059, 16706, 16682, 24, 0.14, 76052.86, 76188.63, -135.77, -0.18, 32962000, 31439000, 1523000, 4.84, 1852.77, 1784.59, 68.18, 3.82, 1573000, 6.31, 8, '2015-08-27 00:00:00.0000000', 560.9, 561.75, 552.8, 554)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-19 00:00:00.0000000', N'ICICIBANK', N'Banking', 1000, 304.5, 304.75, 301.7, 3.05, 1.01, N'1', 7958428, 16616, 16310, 306, 1.88, 78260.32, 80215.28, -1954.96, -2.44, 75013000, 75507000, -494000, -0.65, 2302.64, 2301.53, 1.11, 0.05, 2701000, 5.1, 8, '2015-08-27 00:00:00.0000000', 301.05, 305.4, 300.5, 304.5)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-19 00:00:00.0000000', N'UCOBANK', N'Banking', 4000, 53.6, 53.7, 55.6, -1.9, -3.42, N'-2', 1976685, 1456, 2064, -608, -29.46, 3833.36, 5661.9, -1828.54, -32.3, 19260000, 18972000, 288000, 1.52, 103.91, 105.44, -1.53, -1.45, 908000, 5.55, 8, '2015-08-27 00:00:00.0000000', 55.5, 55.5, 53.25, 53.6)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-19 00:00:00.0000000', N'BANKNIFTY', N'Index', 25, 18703.25, 18730.9, 18812.55, -81.65, -0.43, N'-1', 0, 97464, 140071, -42607, -30.42, 2277056.16, 2962955.84, -685899.68, -23.15, 9064525, 8962625, 101900, 1.1400000000000001, 17012.36, 16836.13, 176.23, 1.05, 209425, 9.69, 8, '2015-08-27 00:00:00.0000000', 18753.45, 18803.5, 18636.1, 18703.25)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-19 00:00:00.0000000', N'NIFTY', N'Index', 25, 8495.15, 8505.4, 8481.7, 23.7, 0.28, N'1', 296906150, 414815, 403590, 11225, 2.7800000000000002, 17102453.12, 18022930.11, -920476.99, -5.11, 158621175, 152483825, 6137350, 4.02, 131618.21, 126444.4, 5173.81, 4.09, 1884500, 11.56, 8, '2015-08-27 00:00:00.0000000', 8468.05, 8520.45, 8425.95, 8495.15)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-19 00:00:00.0000000', N'DLF', N'Realty', 2000, 126.7, 127.1, 128.8, -1.7, -1.32, N'-1', 11063533, 12342, 15710, -3368, -21.44, 60803.32, 78648.53, -17845.21, -22.69, 62936000, 61858000, 1078000, 1.74, 786.69, 777.45, 9.24, 1.19, 1720000, 4.83, 8, '2015-08-27 00:00:00.0000000', 129.9, 131.9, 126.05, 126.7)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-19 00:00:00.0000000', N'UNITECH', N'Realty', 11000, 7.15, 7.2, 7.15, 0.05, 0.7, N'1', 67739916, 8267, 3330, 4937, 148.26, 7988.64, 3173.88, 4814.76, 151.7, 239800000, 225137000, 14663000, 6.51, 177.86, 166.24, 11.62, 6.99, 22605000, 11.25, 8, '2015-08-27 00:00:00.0000000', 7.1, 7.55, 7, 7.15)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-19 00:00:00.0000000', N'RCOM', N'Telecom', 4000, 61.05, 61.2, 61.4, -0.2, -0.33, N'-1', 5424069, 4375, 4627, -252, -5.45, 18633.76, 21150.33, -2516.57, -11.9, 88596000, 87332000, 1264000, 1.45, 567.21, 560.72, 6.49, 1.16, 4708000, 8.08, 8, '2015-08-27 00:00:00.0000000', 61.5, 62.8, 60.7, 61.05)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-19 00:00:00.0000000', N'TATACOMM', N'Telecom', 500, 413.9, 415.8, 413.95, 1.85, 0.45, N'1', 278981, 2305, 3305, -1000, -30.26, 4976.29, 7155.89, -2179.6, -30.46, 6947500, 6902500, 45000, 0.65, 290.09, 287.05, 3.04, 1.06, 418000, 6.36, 8, '2015-08-27 00:00:00.0000000', 412.4, 418.5, 410.75, 413.9)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-20 00:00:00.0000000', N'AXISBANK', N'Banking', 500, 533.4, 534.45, 555.5, -21.05, -3.79, N'-2', 8909772, 39688, 16706, 22982, 137.57, 172414.1, 76052.86, 96361.24, 126.7, 36997500, 32962000, 4035500, 12.24, 2017, 1852.77, 164.23, 8.86, 4533000, 16.56, 7, '2015-08-27 00:00:00.0000000', 550, 553, 529.5, 533.4)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-20 00:00:00.0000000', N'ICICIBANK', N'Banking', 1000, 298.25, 298.75, 304.75, -6, -1.97, N'-1', 14488138, 31864, 16616, 15248, 91.77, 155430.31, 78260.32, 77169.99, 98.61, 76686000, 75013000, 1673000, 2.23, 2320.03, 2302.64, 17.39, 0.76, 4188000, 7.66, 7, '2015-08-27 00:00:00.0000000', 300.25, 306.75, 295.85, 298.25)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-20 00:00:00.0000000', N'UCOBANK', N'Banking', 4000, 51.05, 51.1, 53.7, -2.6, -4.84, N'-3', 2710907, 1839, 1456, 383, 26.3, 4677.63, 3833.36, 844.27, 22.02, 19128000, 19260000, -132000, -0.69, 99.05, 103.91, -4.86, -4.68, 1108000, 6.84, 7, '2015-08-27 00:00:00.0000000', 53.35, 54.35, 50.85, 51.05)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-20 00:00:00.0000000', N'BANKNIFTY', N'Index', 25, 18283.1, 18309.6, 18730.9, -421.3, -2.25, N'-2', 0, 170608, 97464, 73144, 75.05, 4683401.78, 2277056.16, 2406345.62, 105.68, 10235875, 9064525, 1171350, 12.92, 19118.93, 17012.36, 2106.57, 12.38, 291825, 11.61, 7, '2015-08-27 00:00:00.0000000', 18533.25, 18711.35, 18219.9, 18283.1)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-20 00:00:00.0000000', N'NIFTY', N'Index', 25, 8372.75, 8380.05, 8505.4, -125.35, -1.47, N'-1', 296906150, 642476, 414815, 227661, 54.88, 23739287.35, 17102453.12, 6636834.23, 38.81, 162898725, 158621175, 4277550, 2.7, 134997.03, 131618.21, 3378.82, 2.57, 2393500, 14.04, 7, '2015-08-27 00:00:00.0000000', 8471.05, 8501.35, 8359.75, 8372.75)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-20 00:00:00.0000000', N'DLF', N'Realty', 2000, 120, 120.5, 127.1, -6.6, -5.19, N'-3', 15824669, 19926, 12342, 7584, 61.45, 104971.71, 60803.32, 44168.39, 72.64, 63882000, 62936000, 946000, 1.5, 774.66, 786.69, -12.03, -1.53, 2316000, 6.2, 7, '2015-08-27 00:00:00.0000000', 126.1, 127.45, 115.6, 120)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-20 00:00:00.0000000', N'UNITECH', N'Realty', 11000, 6.85, 6.9, 7.2, -0.3, -4.17, N'-3', 55414067, 6851, 8267, -1416, -17.13, 5759.45, 7988.64, -2229.19, -27.9, 242693000, 239800000, 2893000, 1.21, 174.07, 177.86, -3.79, -2.13, 26983000, 13.31, 7, '2015-08-27 00:00:00.0000000', 7.1, 7.1, 6.65, 6.85)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-20 00:00:00.0000000', N'RCOM', N'Telecom', 4000, 61.25, 61.45, 61.2, 0.25, 0.41, N'1', 7543299, 5612, 4375, 1237, 28.27, 24532.34, 18633.76, 5898.58, 31.66, 86224000, 88596000, -2372000, -2.68, 553.89, 567.21, -13.32, -2.35, 5140000, 9.27, 7, '2015-08-27 00:00:00.0000000', 60.9, 62.55, 60.15, 61.25)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-20 00:00:00.0000000', N'TATACOMM', N'Telecom', 500, 402.7, 403.7, 415.8, -12.1, -2.91, N'-2', 330052, 3142, 2305, 837, 36.31, 6719.54, 4976.29, 1743.25, 35.03, 6889500, 6947500, -58000, -0.83, 279.71, 290.09, -10.38, -3.58, 527000, 8.11, 7, '2015-08-27 00:00:00.0000000', 413, 416.25, 400.5, 402.7)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-21 00:00:00.0000000', N'AXISBANK', N'Banking', 500, 525.3, 526.7, 534.45, -7.75, -1.45, N'-1', 10454764, 34836, 39688, -4852, -12.23, 146278.51, 172414.1, -26135.59, -15.16, 39460500, 36997500, 2463000, 6.66, 2123.25, 2017, 106.25, 5.27, 6879000, 23.31, 6, '2015-08-27 00:00:00.0000000', 527, 528.9, 514.3, 525.3)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-21 00:00:00.0000000', N'ICICIBANK', N'Banking', 1000, 296.5, 296.6, 298.75, -2.15, -0.72, N'-1', 12518007, 32674, 31864, 810, 2.54, 150560.63, 155430.31, -4869.68, -3.13, 79567000, 76686000, 2881000, 3.76, 2393.68, 2320.03, 73.65, 3.17, 7840000, 13.52, 6, '2015-08-27 00:00:00.0000000', 293.75, 297.9, 288.6, 296.5)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-21 00:00:00.0000000', N'UCOBANK', N'Banking', 4000, 51.8, 51.95, 51.1, 0.85, 1.6600000000000001, N'1', 2271390, 1788, 1839, -51, -2.77, 4182.61, 4677.63, -495.02, -10.58, 19472000, 19128000, 344000, 1.8, 102.2, 99.05, 3.15, 3.18, 1528000, 9.24, 6, '2015-08-27 00:00:00.0000000', 50.4, 52, 49.7, 51.8)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-21 00:00:00.0000000', N'BANKNIFTY', N'Index', 25, 18057.2, 18071.6, 18309.6, -238, -1.3, N'-1', 0, 189691, 170608, 19083, 11.19, 5234994.09, 4683401.78, 551592.31, 11.78, 11368775, 10235875, 1132900, 11.07, 21010.46, 19118.93, 1891.53, 9.89, 462075, 16.87, 6, '2015-08-27 00:00:00.0000000', 17978.25, 18118.8, 17842.1, 18057.2)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-21 00:00:00.0000000', N'NIFTY', N'Index', 25, 8299.95, 8306.35, 8380.05, -73.7, -0.88, N'-1', 296906150, 792487, 642476, 150011, 23.35, 30693087.87, 23739287.35, 6953800.52, 29.29, 169758200, 162898725, 6859475, 4.21, 140270.79, 134997.03, 5273.76, 3.91, 3277300, 18.19, 6, '2015-08-27 00:00:00.0000000', 8305.4, 8322.2, 8225.05, 8299.95)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-21 00:00:00.0000000', N'DLF', N'Realty', 2000, 113.95, 114.35, 120.5, -6.15, -5.1, N'-3', 16794240, 20347, 19926, 421, 2.11, 98074.98, 104971.71, -6896.73, -6.57, 71908000, 63882000, 8026000, 12.56, 843.64, 774.66, 68.98, 8.9, 4630000, 10.74, 6, '2015-08-27 00:00:00.0000000', 116.3, 122.25, 111.9, 113.95)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-21 00:00:00.0000000', N'UNITECH', N'Realty', 11000, 6.85, 6.85, 6.9, -0.05, -0.72, N'-1', 39139935, 4135, 6851, -2716, -39.64, 3379.65, 5759.45, -2379.8, -41.32, 252252000, 242693000, 9559000, 3.94, 179.65, 174.07, 5.58, 3.21, 33550000, 15.86, 6, '2015-08-27 00:00:00.0000000', 6.75, 6.9, 6.55, 6.85)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-21 00:00:00.0000000', N'RCOM', N'Telecom', 4000, 60.25, 60.35, 61.45, -1.1, -1.79, N'-1', 6336615, 5338, 5612, -274, -4.88, 22981.86, 24532.34, -1550.48, -6.32, 88800000, 86224000, 2576000, 2.99, 562.99, 553.89, 9.1, 1.6400000000000001, 7164000, 12.32, 6, '2015-08-27 00:00:00.0000000', 60, 61.25, 58.9, 60.25)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-21 00:00:00.0000000', N'TATACOMM', N'Telecom', 500, 418.15, 418.35, 403.7, 14.65, 3.63, N'2', 988976, 5599, 3142, 2457, 78.2, 12408.16, 6719.54, 5688.62, 84.66, 6844000, 6889500, -45500, -0.66, 287.33, 279.71, 7.62, 2.7199999999999998, 677500, 10.56, 6, '2015-08-27 00:00:00.0000000', 409, 419.95, 405.05, 418.15)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-24 00:00:00.0000000', N'AXISBANK', N'Banking', 500, 482.05, 481.95, 526.7, -44.75, -8.5, N'-3', 17627734, 61789, 34836, 26953, 77.37, 219408.62, 146278.51, 73130.11, 49.99, 39164500, 39460500, -296000, -0.75, 1969.08, 2123.25, -154.17, -7.26, 9504500, 32.91, 3, '2015-08-27 00:00:00.0000000', 506.7, 506.7, 475.1, 482.05)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-24 00:00:00.0000000', N'ICICIBANK', N'Banking', 1000, 269.95, 269.25, 296.6, -27.35, -9.22, N'-3', 30284166, 71497, 32674, 38823, 118.82, 286338.8, 150560.63, 135778.17, 90.18, 83889000, 79567000, 4322000, 5.43, 2348.43, 2393.68, -45.25, -1.8900000000000001, 17896000, 29.31, 3, '2015-08-27 00:00:00.0000000', 282.4, 284.85, 267.5, 269.95)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-24 00:00:00.0000000', N'UCOBANK', N'Banking', 4000, 44, 44, 51.95, -7.95, -15.3, N'-3', 4752570, 4723, 1788, 2935, 164.15, 9718.59, 4182.61, 5535.98, 132.36, 20704000, 19472000, 1232000, 6.33, 94.48, 102.2, -7.72, -7.55, 4800000, 27.06, 3, '2015-08-27 00:00:00.0000000', 50, 50, 43, 44)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-24 00:00:00.0000000', N'BANKNIFTY', N'Index', 25, 16811.8, 16760.6, 18071.6, -1311, -7.25, N'-3', 0, 300372, 189691, 110681, 58.35, 5595167.11, 5234994.09, 360173.02, 6.88, 11328400, 11368775, -40375, -0.36, 20387.34, 21010.46, -623.12, -2.9699999999999998, 659525, 24.32, 3, '2015-08-27 00:00:00.0000000', 17446.35, 17446.35, 16740.7, 16811.8)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-24 00:00:00.0000000', N'NIFTY', N'Index', 25, 7809, 7806.35, 8306.35, -500, -6.02, N'-3', 296906150, 1791382, 792487, 998895, 126.05, 40917794.28, 30693087.87, 10224706.41, 33.31, 178991775, 169758200, 9233575, 5.44, 145780.47, 140270.79, 5509.68, 3.93, 8301425, 33.89, 3, '2015-08-27 00:00:00.0000000', 8055.95, 8060.05, 7769.4, 7809)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-24 00:00:00.0000000', N'DLF', N'Realty', 2000, 96.65, 96.2, 114.35, -18.15, -15.87, N'-3', 17825912, 29347, 20347, 9000, 44.23, 126174.06, 98074.98, 28099.08, 28.65, 72232000, 71908000, 324000, 0.45, 762.59, 843.64, -81.05, -9.61, 9446000, 23.44, 3, '2015-08-27 00:00:00.0000000', 105, 107.5, 93.35, 96.65)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-24 00:00:00.0000000', N'UNITECH', N'Realty', 11000, 6, 6, 6.85, -0.85, -12.41, N'-3', 73178597, 11939, 4135, 7804, 188.73, 8881.41, 3379.65, 5501.76, 162.79, 249425000, 252252000, -2827000, -1.12, 160.05, 179.65, -19.6, -10.91, 42625000, 20.48, 3, '2015-08-27 00:00:00.0000000', 6.7, 6.7, 5.9, 6)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-24 00:00:00.0000000', N'RCOM', N'Telecom', 4000, 50.5, 50.45, 60.35, -9.9, -16.4, N'-3', 9982680, 16975, 5338, 11637, 218, 55168.4, 22981.86, 32186.54, 140.05, 85192000, 88800000, -3608000, -4.06, 485.96, 562.99, -77.03, -13.68, 15752000, 29.8, 3, '2015-08-27 00:00:00.0000000', 58.75, 58.75, 49.5, 50.5)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-24 00:00:00.0000000', N'TATACOMM', N'Telecom', 500, 369.15, 367.85, 418.35, -50.5, -12.07, N'-3', 2373217, 10282, 5599, 4683, 83.64, 20118.93, 12408.16, 7710.77, 62.14, 6040500, 6844000, -803500, -11.74, 225.24, 287.33, -62.09, -21.61, 1073000, 19.13, 3, '2015-08-27 00:00:00.0000000', 408.55, 408.55, 356, 369.15)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-25 00:00:00.0000000', N'AXISBANK', N'Banking', 500, 502.95, 504.25, 481.95, 22.3, 4.63, N'3', 14248966, 69244, 61789, 7455, 12.07, 227645.8, 219408.62, 8237.18, 3.75, 38563000, 39164500, -601500, -1.54, 2001.23, 1969.08, 32.15, 1.63, 14953000, 52.58, 2, '2015-08-27 00:00:00.0000000', 489, 506.25, 483.5, 502.95)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-25 00:00:00.0000000', N'ICICIBANK', N'Banking', 1000, 283.5, 283.35, 269.25, 14.1, 5.24, N'3', 24139658, 61292, 71497, -10205, -14.27, 236810.79, 286338.8, -49528.01, -17.3, 80108000, 83889000, -3781000, -4.51, 2324.86, 2348.43, -23.57, -1, 26336000, 45.33, 2, '2015-08-27 00:00:00.0000000', 276.55, 284.4, 267.15, 283.5)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-25 00:00:00.0000000', N'UCOBANK', N'Banking', 4000, 43.95, 43.9, 44, -0.1, -0.23, N'-1', 4950079, 3480, 4723, -1243, -26.32, 6632.02, 9718.59, -3086.57, -31.76, 20676000, 20704000, -28000, -0.14, 94.21, 94.48, -0.27, -0.29, 6920000, 39.3, 2, '2015-08-27 00:00:00.0000000', 45.4, 46.15, 40.85, 43.95)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-25 00:00:00.0000000', N'BANKNIFTY', N'Index', 25, 17192.75, 17203.2, 16760.6, 442.6, 2.64, N'2', 0, 241077, 300372, -59295, -19.74, 4672150.78, 5595167.11, -923016.33, -16.5, 11063275, 11328400, -265125, -2.34, 19936.25, 20387.34, -451.09, -2.21, 691675, 27.97, 2, '2015-08-27 00:00:00.0000000', 17084.15, 17269.15, 16670.55, 17192.75)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-25 00:00:00.0000000', N'NIFTY', N'Index', 25, 7880.7, 7896.2, 7806.35, 89.85, 1.15, N'1', 296906150, 1445327, 1791382, -346055, -19.32, 36060930.44, 40917794.28, -4856863.84, -11.87, 178593100, 178991775, -398675, -0.22, 144900.18, 145780.47, -880.29, -0.6, 12726450, 48.65, 2, '2015-08-27 00:00:00.0000000', 7895.4, 7925.4, 7667.25, 7880.7)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-25 00:00:00.0000000', N'DLF', N'Realty', 2000, 112.1, 112.45, 96.2, 16.25, 16.89, N'3', 31742998, 42630, 29347, 13283, 45.26, 178097.02, 126174.06, 51922.96, 41.15, 67598000, 72232000, -4634000, -6.42, 768.37, 762.59, 5.78, 0.76, 16722000, 46.94, 2, '2015-08-27 00:00:00.0000000', 99.8, 114.1, 97.1, 112.1)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-25 00:00:00.0000000', N'UNITECH', N'Realty', 11000, 5.95, 6, 6, 0, 0, N'0', 121742603, 16871, 11939, 4932, 41.31, 12221.87, 8881.41, 3340.46, 37.61, 254507000, 249425000, 5082000, 2.04, 163.29, 160.05, 3.24, 2.02, 65428000, 30.86, 2, '2015-08-27 00:00:00.0000000', 6.25, 6.3, 5.4, 5.95)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-25 00:00:00.0000000', N'RCOM', N'Telecom', 4000, 50.6, 50.8, 50.45, 0.35, 0.69, N'1', 14070454, 14121, 16975, -2854, -16.81, 41547.21, 55168.4, -13621.19, -24.69, 85732000, 85192000, 540000, 0.63, 487.72, 485.96, 1.76, 0.36, 24416000, 47.11, 2, '2015-08-27 00:00:00.0000000', 51.4, 53.45, 45.5, 50.6)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-25 00:00:00.0000000', N'TATACOMM', N'Telecom', 500, 386.35, 386.25, 367.85, 18.4, 5, N'3', 1811634, 7427, 10282, -2855, -27.77, 13971.64, 20118.93, -6147.29, -30.55, 5688500, 6040500, -352000, -5.83, 221.75, 225.24, -3.49, -1.55, 1350500, 25.73, 2, '2015-08-27 00:00:00.0000000', 376, 391.05, 335.55, 386.35)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-26 00:00:00.0000000', N'AXISBANK', N'Banking', 500, 495.6, 495.9, 504.25, -8.35, -1.6600000000000001, N'-1', 6910566, 48573, 69244, -20671, -29.85, 155320.67, 227645.8, -72325.13, -31.77, 38863000, 38563000, 300000, 0.78, 1989.2, 2001.23, -12.03, -0.6, 19414500, 67.36, 1, '2015-08-27 00:00:00.0000000', 499.5, 501.9, 488.65, 495.6)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-26 00:00:00.0000000', N'ICICIBANK', N'Banking', 1000, 278.05, 278.25, 283.35, -5.1, -1.8, N'-1', 14718073, 46401, 61292, -14891, -24.3, 177799.52, 236810.79, -59011.27, -24.92, 79859000, 80108000, -249000, -0.31, 2288.68, 2324.86, -36.18, -1.56, 32163000, 56.46, 1, '2015-08-27 00:00:00.0000000', 279.95, 282.25, 275.7, 278.05)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-26 00:00:00.0000000', N'UCOBANK', N'Banking', 4000, 43.45, 43.55, 43.9, -0.35, -0.8, N'-1', 3303576, 4454, 3480, 974, 27.99, 8207.61, 6632.02, 1575.59, 23.76, 18676000, 20676000, -2000000, -9.67, 84.9, 94.21, -9.31, -9.88, 10032000, 64.66, 1, '2015-08-27 00:00:00.0000000', 43.9, 44.8, 42.8, 43.45)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-26 00:00:00.0000000', N'BANKNIFTY', N'Index', 25, 16917.65, 16938.75, 17203.2, -264.45, -1.54, N'-1', 0, 212602, 241077, -28475, -11.81, 4447083.84, 4672150.78, -225066.94, -4.82, 11607775, 11063275, 544500, 4.92, 20758.96, 19936.25, 822.71, 4.13, 1197975, 43.85, 1, '2015-08-27 00:00:00.0000000', 17113.1, 17172.2, 16875.5, 16917.65)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-26 00:00:00.0000000', N'NIFTY', N'Index', 25, 7791.85, 7800.7, 7896.2, -95.5, -1.21, N'-1', 296906150, 1210080, 1445327, -235247, -16.28, 32602140.36, 36060930.44, -3458790.08, -9.59, 185662850, 178593100, 7069750, 3.96, 149992.04, 144900.18, 5091.86, 3.51, 17144275, 59.86, 1, '2015-08-27 00:00:00.0000000', 7865.25, 7930.05, 7777.1, 7791.85)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-26 00:00:00.0000000', N'DLF', N'Realty', 2000, 110.6, 110.8, 112.45, -1.65, -1.47, N'-1', 15914583, 25952, 42630, -16678, -39.12, 99658.6, 178097.02, -78438.42, -44.04, 69782000, 67598000, 2184000, 3.23, 788.95, 768.37, 20.58, 2.68, 23476000, 62.15, 1, '2015-08-27 00:00:00.0000000', 111, 114.3, 108.3, 110.6)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-26 00:00:00.0000000', N'UNITECH', N'Realty', 11000, 5.95, 6, 6, 0, 0, N'0', 64258086, 26440, 16871, 9569, 56.72, 17738.18, 12221.87, 5516.31, 45.13, 266816000, 254507000, 12309000, 4.84, 170.91, 163.29, 7.62, 4.67, 109505000, 48.96, 1, '2015-08-27 00:00:00.0000000', 6.1, 6.15, 5.75, 5.95)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-26 00:00:00.0000000', N'RCOM', N'Telecom', 4000, 52.3, 52.35, 50.8, 1.55, 3.05, N'2', 9723498, 13913, 14121, -208, -1.47, 39323.43, 41547.21, -2223.78, -5.35, 87148000, 85732000, 1416000, 1.65, 502.85, 487.72, 15.13, 3.1, 34064000, 66.3, 1, '2015-08-27 00:00:00.0000000', 50.6, 53.95, 48.8, 52.3)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-26 00:00:00.0000000', N'TATACOMM', N'Telecom', 500, 380, 379.85, 386.25, -6.4, -1.6600000000000001, N'-1', 474716, 8740, 7427, 1313, 17.68, 17594.76, 13971.64, 3623.12, 25.93, 6330500, 5688500, 642000, 11.29, 242.85, 221.75, 21.1, 9.52, 2502500, 42.51, 1, '2015-08-27 00:00:00.0000000', 382, 394.8, 376.3, 380)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-27 00:00:00.0000000', N'AXISBANK', N'Banking', 500, 509.25, 512.75, 498.3, 14.45, 2.9, N'2', 11302689, 56891, 48573, 8318, 17.12, 176808.66, 155320.67, 21487.99, 13.83, 28976500, 38863000, -9886500, -25.44, 2155.98, 1989.2, 166.78, 8.38, 25455500, 82.22, 0, '2015-08-27 00:00:00.0000000', 505.7, 512, 496.45, 509.25)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-27 00:00:00.0000000', N'ICICIBANK', N'Banking', 1000, 282.45, 284.55, 279.5, 5.05, 1.81, N'1', 25349886, 70754, 46401, 24353, 52.48, 234231.04, 177799.52, 56431.52, 31.74, 59222000, 79859000, -20637000, -25.84, 2603.05, 2288.68, 314.37, 13.74, 52961000, 79.32, 0, '2015-08-27 00:00:00.0000000', 282.75, 284.5, 280.2, 282.45)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-27 00:00:00.0000000', N'UCOBANK', N'Banking', 4000, 45.1, 45.4, 43.8, 1.6, 3.65, N'2', 2504588, 4273, 4454, -181, -4.06, 8307.06, 8207.61, 99.45, 1.21, 13932000, 18676000, -4744000, -25.4, 84.3, 84.9, -0.6, -0.71, 12896000, 88.47, 0, '2015-08-27 00:00:00.0000000', 44.3, 45.65, 44.15, 45.1)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-27 00:00:00.0000000', N'BANKNIFTY', N'Index', 25, 17214.4, 17338.35, 17009.75, 328.6, 1.9300000000000002, N'1', 0, 245203, 212602, 32601, 15.33, 6281821.06, 4447083.84, 1834737.22, 41.26, 4772100, 11607775, -6835675, -58.89, 21735.38, 20758.96, 976.42, 4.7, 1956150, 67.23, 0, '2015-08-27 00:00:00.0000000', 17175.65, 17249.5, 17061.85, 17214.4)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-27 00:00:00.0000000', N'NIFTY', N'Index', 25, 7948.95, 7991, 7829.2, 161.8, 2.07, N'2', 296906150, 1272665, 1210080, 62585, 5.17, 38491160.88, 32602140.36, 5889020.52, 18.06, 120126550, 185662850, -65536300, -35.3, 156832.83, 149992.04, 6840.79, 4.5600000000000005, 21515425, 66.86, 0, '2015-08-27 00:00:00.0000000', 7921.6, 7963.6, 7862.3, 7948.95)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-27 00:00:00.0000000', N'DLF', N'Realty', 2000, 114.75, 115.4, 111.3, 4.1, 3.68, N'2', 19325858, 30127, 25952, 4175, 16.09, 121399.83, 99658.6, 21741.23, 21.82, 41086000, 69782000, -28696000, -41.12, 876.52, 788.95, 87.57, 11.1, 32778000, 81.21, 0, '2015-08-27 00:00:00.0000000', 115.5, 116.1, 108.4, 114.75)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-27 00:00:00.0000000', N'UNITECH', N'Realty', 11000, 6.2, 6.25, 6.05, 0.2, 3.31, N'2', 66307237, 30938, 26440, 4498, 17.01, 22219.38, 17738.18, 4481.2, 25.26, 190542000, 266816000, -76274000, -28.59, 163.73, 170.91, -7.18, -4.2, 172667000, 87.84, 0, '2015-08-27 00:00:00.0000000', 6.1, 6.4, 6.05, 6.2)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-27 00:00:00.0000000', N'RCOM', N'Telecom', 4000, 54.5, 54.85, 52.35, 2.5, 4.78, N'3', 8020595, 13084, 13913, -829, -5.96, 37327.5, 39323.43, -1995.93, -5.08, 48956000, 87148000, -38192000, -43.82, 528.6, 502.85, 25.75, 5.12, 43048000, 82.87, 0, '2015-08-27 00:00:00.0000000', 53.35, 55.35, 52.3, 54.5)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-27 00:00:00.0000000', N'TATACOMM', N'Telecom', 500, 406.25, 404.65, 379.55, 25.1, 6.61, N'3', 2882570, 13989, 8740, 5249, 60.06, 28609.14, 17594.76, 11014.38, 62.6, 4163000, 6330500, -2167500, -34.24, 279.57, 242.85, 36.72, 15.12, 4041500, 63.51, 0, '2015-08-27 00:00:00.0000000', 384.5, 409.9, 378.8, 406.25)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-28 00:00:00.0000000', N'AXISBANK', N'Banking', 500, 508.15, 511.05, 512.75, -1.7, -0.33, N'-1', 10015309, 31858, 56891, -25033, -44, 132053.24, 176808.66, -44755.42, -25.31, 30313000, 28976500, 1336500, 4.61, 1560.83, 2155.98, -595.15, -27.6, 214500, 0.83, 27, '2015-09-24 00:00:00.0000000', 516, 528.9, 502.25, 508.15)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-28 00:00:00.0000000', N'ICICIBANK', N'Banking', 1000, 283.7, 284.6, 284.55, 0.05, 0.02, N'1', 13059781, 23994, 70754, -46760, -66.09, 110315.66, 234231.04, -123915.38, -52.9, 60216000, 59222000, 994000, 1.6800000000000002, 1725.04, 2603.05, -878.01, -33.73, 530000, 1.02, 27, '2015-09-24 00:00:00.0000000', 285.05, 289.3, 281.65, 283.7)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-28 00:00:00.0000000', N'UCOBANK', N'Banking', 4000, 44.45, 44.6, 45.4, -0.8, -1.76, N'-1', 2438724, 1346, 4273, -2927, -68.5, 2812.99, 8307.06, -5494.07, -66.14, 14136000, 13932000, 204000, 1.46, 63.99, 84.3, -20.31, -24.09, 172000, 1.33, 27, '2015-09-24 00:00:00.0000000', 46, 46.55, 43.85, 44.45)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-28 00:00:00.0000000', N'BANKNIFTY', N'Index', 25, 17211.95, 17273.05, 17338.35, -65.3, -0.38, N'-1', 0, 172413, 245203, -72790, -29.69, 2423392.46, 6281821.06, -3858428.6, -61.42, 5512345, 4772100, 740245, 15.51, 9704.91, 21735.38, -12030.47, -55.35, 46590, 2.32, 27, '2015-09-24 00:00:00.0000000', 17425.3, 17569.8, 17099.8, 17211.95)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-28 00:00:00.0000000', N'NIFTY', N'Index', 25, 8001.95, 8022.7, 7991, 31.7, 0.4, N'1', 296906150, 701124, 1272665, -571541, -44.91, 13210913.17, 38491160.88, -25280247.71, -65.68, 132538000, 120126550, 12411450, 10.33, 106319.32, 156832.83, -50513.51, -32.21, 579500, 2.57, 27, '2015-09-24 00:00:00.0000000', 8053.7, 8091.8, 7961.65, 8001.95)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-28 00:00:00.0000000', N'DLF', N'Realty', 2000, 115.2, 115.7, 115.4, 0.3, 0.26, N'1', 15818307, 14046, 30127, -16081, -53.38, 57558.35, 121399.83, -63841.48, -52.59, 42546000, 41086000, 1460000, 3.55, 493.5, 876.52, -383.02, -43.7, 276000, 0.88, 27, '2015-09-24 00:00:00.0000000', 117.7, 119.5, 111.55, 115.2)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-28 00:00:00.0000000', N'UNITECH', N'Realty', 11000, 6.05, 6.1, 6.25, -0.15, -2.4, N'-2', 46115018, 5179, 30938, -25759, -83.26, 4156.98, 22219.38, -18062.4, -81.29, 188045000, 190542000, -2497000, -1.31, 117.72, 163.73, -46.01, -28.1, 3289000, 1.96, 27, '2015-09-24 00:00:00.0000000', 6.35, 6.45, 5.9, 6.05)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-28 00:00:00.0000000', N'RCOM', N'Telecom', 4000, 57.45, 57.5, 54.85, 2.65, 4.83, N'3', 11174738, 5653, 13084, -7431, -56.79, 23435.46, 37327.5, -13892.04, -37.22, 50344000, 48956000, 1388000, 2.84, 293.28, 528.6, -235.32, -44.52, 500000, 1.24, 27, '2015-09-24 00:00:00.0000000', 55.4, 58.05, 55, 57.45)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-28 00:00:00.0000000', N'TATACOMM', N'Telecom', 500, 393.85, 391.6, 404.65, -13.05, -3.23, N'-2', 396301, 1734, 13989, -12255, -87.6, 3887.85, 28609.14, -24721.29, -86.41, 4272000, 4163000, 109000, 2.62, 167.62, 279.57, -111.95, -40.04, 144500, 3.5, 27, '2015-09-24 00:00:00.0000000', 411.25, 413.7, 391.2, 393.85)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-31 00:00:00.0000000', N'AXISBANK', N'Banking', 500, 507.75, 510.55, 511.05, -0.5, -0.1, N'-1', 6111825, 18325, 31858, -13533, -42.48, 70697.99, 132053.24, -61355.25, -46.46, 31028000, 30313000, 715000, 2.36, 1596.01, 1560.83, 35.18, 2.25, 209000, 0.79, 24, '2015-09-24 00:00:00.0000000', 506.7, 517.9, 502, 507.75)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-31 00:00:00.0000000', N'ICICIBANK', N'Banking', 1000, 277.9, 279.45, 284.6, -5.15, -1.81, N'-1', 13709056, 19320, 23994, -4674, -19.48, 81445.46, 110315.66, -28870.2, -26.17, 64177000, 60216000, 3961000, 6.58, 1811.09, 1725.04, 86.05, 4.99, 674000, 1.24, 24, '2015-09-24 00:00:00.0000000', 282.9, 284.35, 276.35, 277.9)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-31 00:00:00.0000000', N'UCOBANK', N'Banking', 4000, 44.8, 45.05, 44.6, 0.45, 1.01, N'1', 2546994, 1224, 1346, -122, -9.06, 2310.89, 2812.99, -502.1, -17.85, 13724000, 14136000, -412000, -2.91, 62.74, 63.99, -1.25, -1.95, 176000, 1.41, 24, '2015-09-24 00:00:00.0000000', 44.45, 45.65, 43.5, 44.8)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-31 00:00:00.0000000', N'BANKNIFTY', N'Index', 25, 17146.55, 17208.4, 17273.05, -64.65, -0.37, N'-1', 0, 126256, 172413, -46157, -26.77, 1719366.63, 2423392.46, -704025.83, -29.05, 5948835, 5512345, 436490, 7.92, 10436.7, 9704.91, 731.79, 7.54, 56630, 2.83, 24, '2015-09-24 00:00:00.0000000', 17137.25, 17353.3, 17028.9, 17146.55)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-31 00:00:00.0000000', N'NIFTY', N'Index', 25, 7971.3, 8000.05, 8022.7, -22.65, -0.28, N'-1', 296906150, 559407, 701124, -141717, -20.21, 9717002.12, 13210913.17, -3493911.05, -26.45, 139397350, 132538000, 6859350, 5.18, 111576.48, 106319.32, 5257.16, 4.9399999999999995, 766775, 3.35, 24, '2015-09-24 00:00:00.0000000', 8009.25, 8043.6, 7947.95, 7971.3)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-31 00:00:00.0000000', N'DLF', N'Realty', 2000, 110.9, 111.3, 115.7, -4.4, -3.8, N'-2', 11098531, 9777, 14046, -4269, -30.39, 40677.49, 57558.35, -16880.86, -29.33, 45387000, 42546000, 2841000, 6.68, 513.27, 493.5, 19.77, 4.01, 329000, 1.02, 24, '2015-09-24 00:00:00.0000000', 114.1, 117, 109.4, 110.9)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-31 00:00:00.0000000', N'UNITECH', N'Realty', 11000, 6.05, 6.15, 6.1, 0.05, 0.82, N'1', 38568504, 3487, 5179, -1692, -32.67, 2718.37, 4156.98, -1438.61, -34.61, 190432000, 188045000, 2387000, 1.27, 120.34, 117.72, 2.62, 2.23, 3586000, 2.14, 24, '2015-09-24 00:00:00.0000000', 6.1, 6.15, 5.85, 6.05)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-31 00:00:00.0000000', N'RCOM', N'Telecom', 4000, 60.4, 60.1, 57.5, 2.6, 4.52, N'3', 13627505, 4422, 5653, -1231, -21.78, 21260.01, 23435.46, -2175.45, -9.28, 52492000, 50344000, 2148000, 4.27, 317.4, 293.28, 24.12, 8.22, 564000, 1.3900000000000001, 24, '2015-09-24 00:00:00.0000000', 57.9, 60.9, 56.65, 60.4)
INSERT TestDB1001.dbo.Table1004(xdate, symbol, sector, lotsize, price_spot, price_future, price_future_previous, price_future_change, price_future_percent, price_future_sign, volume_spot, volume_future, volume_future_previous, volume_future_change, volume_future_percent, volume_value, volume_value_previous, volume_value_change, volume_value_percent, oi_total, oi_total_previous, oi_total_change, oi_total_percent, oi_value, oi_value_previous, oi_value_change, oi_value_percent, rollover, rollover_percent, daystoexpiry, expirydate, [open], high, low, [close]) VALUES ('2015-08-31 00:00:00.0000000', N'TATACOMM', N'Telecom', 500, 392.5, 389.9, 391.6, -1.7, -0.43, N'-1', 292211, 1445, 1734, -289, -16.67, 3046.87, 3887.85, -840.98, -21.63, 4277500, 4272000, 5500, 0.13, 167.06, 167.62, -0.56, -0.33, 148500, 3.6, 24, '2015-09-24 00:00:00.0000000', 395.25, 399, 389, 392.5)
GO

Open in new window

Avatar of Pawan Kumar
Pawan Kumar
Flag of India image

Hi Happy,

Can you please provide the expected output?

Thank you
In an attempt to determine which row is Slab1, Slab2,...Slab5, I am running the following query and getting the result below it
select [price_spot],  
      CASE price_spot  
         WHEN 7 THEN 1   -- I changed 5 intentionally to 7 to make sure my case code works, see lines 223 and 224
		 WHEN 10 THEN 2
		 WHEN 15 THEN 3
		 WHEN 20 THEN 4
		 WHEN 25 THEN 5  
         ELSE 0  
      END ScoreSlab 
from Table1004 order by [price_spot] desc

Open in new window

price_spot	ScoreSlab
19029.35	           0
18972.6	           0
18928.55	           0
18914.7		   0
18893.55	           0
18875	           0
18822.05	           0
18780.85	           0
18729.85	           0
18723.6		           0
18703.25	           0
18616.9	           0
18440.4	           0
18323.4	           0
18283.1	           0
18282.8	           0
18213.05	           0
18175.4	           0
18059.75	           0
18057.2	           0
17214.4	           0
17211.95	           0
17192.75	           0
17146.55	           0
16917.65	           0
16811.8	           0
8588.65	           0
8567.95	           0
8564.6	           0
8543.05	           0
8532.85	           0
8525.6	           0
8518.55	           0
8516.9	           0
8495.15	           0
8477.3	           0
8466.55	           0
8462.35	           0
8421.8	           0
8375.05	           0
8372.75	           0
8361	           0
8355.85	           0
8349.45	           0
8337	           0
8299.95	           0
8001.95		           0
7971.3		           0
7948.95	           	0
7880.7		           0
7809		           0
7791.85	           	0
584.75		           0
580.4		           0
580.3		           0
580.1		           0
576.7		           0
575.9		           0
573.5		           0
571.25		           0
570		           0
567.55		           0
567.2		           0
565.7		           0
561.4		           0
561.35		           0
561.25		           0
557.85		           0
555.8		           0
554		           0
533.4		           0
525.3		           0
509.25		           0
508.15		           0
507.75		           0
502.95		           0
495.6		           0
482.05		           0
474.35		           0
470.35		           0
452.45		           0
450.45		           0
447		           0
444.3		           0
441.25		           0
440		           0
439.8		           0
438.55		           0
436.9		           0
434.8		           0
423		           0
419.9		           0
418.15		           0
417.05		           0
415.55		           0
413.9		           0
412.15		           0
406.25		           0
402.7		           0
393.85		           0
392.5		           0
386.35		           0
380		           0
369.15		           0
314.05		           0
312.9		           0
311.35		           0
311.05		           0
310.15		           0
309.6		           0
304.5		           0
302.9		           0
302.6		           0
302.4		           0
302.25		           0
301.1		           0
298.25		           0
296.5		           0
291.9		           0
291.65		           0
291.1		           0
291		           0
289.25		           0
285		           0
283.7		           0
283.5		           0
282.45	0
278.05	0
277.9	0
269.95	0
135.25	0
129.3	0
128.3	0
128.05	0
126.7	0
125.7	0
124.35	0
122.45	0
122.1	0
120	0
117.1	0
115.5	0
115.2	0
115.05	0
115.05	0
114.75	0
114.25	0
113.95	0
112.1	0
110.9	0
110.6	0
109.7	0
101.55	0
101.2	0
96.65	0
95.4	0
73.3	0
72.5	0
72.5	0
72.15	0
70.85	0
70.5	0
70.4	0
70.4	0
68.4	0
67.15	0
66.7	0
65.75	0
65.05	0
62.25	0
61.35	0
61.25	0
61.05	0
60.9	0
60.4	0
60.25	0
60.1	0
57.45	0
55.85	0
55.5	0
55.45	0
55	0
54.65	0
54.55	0
54.5	0
54.1	0
53.6	0
53.05	0
52.8	0
52.7	0
52.3	0
51.8	0
51.8	0
51.6	0
51.05	0
51.05	0
50.7	0
50.65	0
50.6	0
50.5	0
50.35	0
48.7	0
45.1	0
44.8	0
44.45	0
44	0
43.95	0
43.45	0
7.95	0
7.85	0
7.85	0
7.8	0
7.7	0
7.7	0
7.6	0
7.45	0
7.4	0
7.35	0
7.2	0
7.15	0
7.1	0
7	1
7	1
6.85	0
6.85	0
6.65	0
6.5	0
6.25	0
6.2	0
6.05	0
6.05	0
6	0
5.95	0
5.95	0

Open in new window


Question: Could you please take a look at
CASE price_spot  
         WHEN 7 THEN 1   -- I changed 5 intentionally to 7 to make sure my case code works, see lines 223 and 224
		 WHEN 10 THEN 2
		 WHEN 15 THEN 3
		 WHEN 20 THEN 4
		 WHEN 25 THEN 5  
         ELSE 0  
      END ScoreSlab 

Open in new window


and give kind of description I could fine tune and be able to determine SlabScore numbers the way you want to?

Mike
Hi Happy,
Your slabs are not correct I think..Multiple slabs can be true for single row, in that case it will always pick the first one.

Please try below-

SELECT *,  
     CASE WHEN price_spot  > 0 AND price_spot <= 5 THEN 2
		  WHEN price_spot  > 5 AND price_spot <= 10 THEN -1
		  WHEN price_spot  > 10 AND price_spot <= 15 THEN 0
		  WHEN price_spot  > 15 AND price_spot <= 20 THEN -1
		  WHEN price_spot  > 25 THEN -2
	  ELSE 0  
      END [price_spot_slabranks] 
FROM TestDB1001.dbo.Table1004 

Open in new window


Hope it helps!
Avatar of Scott Pletcher
Code is below.  

This definitely isn't my area of expertise, but In my own mind, I would have expected the slab/ranking to be by sector.  If somehow that does need done, the code below is easy enough to change to do that.


SELECT
    Scores.*,
    CASE
         WHEN Scores.price_spot >= ScoreSlab1 THEN 2
         WHEN Scores.price_spot >= ScoreSlab2 THEN 1
         WHEN Scores.price_spot >  ScoreSlab4 THEN 0
         WHEN Scores.price_spot >  ScoreSlab5 THEN -1
         ELSE -2
    END AS  price_spot_slabranks
FROM dbo.Table1004 Scores
CROSS JOIN (
    SELECT
        MAX(CASE WHEN price_rank =  5 THEN price_spot END) AS ScoreSlab1,
        MAX(CASE WHEN price_rank = 10 THEN price_spot END) AS ScoreSlab2,
        MAX(CASE WHEN price_rank = 15 THEN price_spot END) AS ScoreSlab3,
        MAX(CASE WHEN price_rank = 20 THEN price_spot END) AS ScoreSlab4,
        MAX(CASE WHEN price_rank = 25 THEN price_spot END) AS ScoreSlab5
    FROM (
        SELECT TOP (25) price_spot, ROW_NUMBER() OVER(ORDER BY price_spot DESC) AS price_rank
        FROM dbo.Table1004
        ORDER BY price_spot DESC
    ) AS derived
    WHERE price_rank % 5 = 0
) AS ScoreSlabs
Avatar of happy 1001
happy 1001

ASKER

Thank you so much for your effort, Experts.

I am sorry, I failed to clarify it earlier. This is a Stock Market Database and every new trading session day, has got one new row for each [SYMBOL]. For the sake of simplicity, you can consider the Symbol, as a PRODUCT or Main Sales Item etc. and all other columns in the table provide more information related to this Symbol only.

Actually most of my questions related to this table were quickly solved by https://www.experts-exchange.com/members/PortletPaul.html
He is very familiar with this table structure and he tends to solve such doubts in a jiffy. That's why I did not bother too much to explain the table structure etc. But still if there are some issues in understanding the requirement, then maybe I will upload a very simple table with very few columns, in a separate thread.

@ScottPletcher, the slab/rank work is supposed to be done by [SYMBOL] column. Can you please provide the updated code, so that I can manually test the results ?

Thank you so much.

PS: @Pawan and @Mike, I am sorry dear experts, you have taken up the [price_spot] column independently. But in real case, we have to ---
define 5 ScoreSlabs, based on column [ price_spot ] ----- FOR EACH SYMBOL
And then based on those 5th higest, 10th highest, nth highest price_spot values, we need to give the respective score values to each symbols data accordingly.
There would be one new row for each SYMBOL, on any new trading session date, given in this table. I am sorry it is my mistake, I should have clarified it beforehand.
ASKER CERTIFIED SOLUTION
Avatar of Scott Pletcher
Scott Pletcher
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
@ScottPeltcher, Thank you so much. Excellent Work done by you. A hard looking scenario, sorted out in an easy manner. Brilliant Work.

Best Regards
@Happy --

Going forward I would request you to provide some sample data and the expected output?  Trust me with understanding your story <20-30 lines> and provide you implementation is really tough. It will also waste experts time on guessing what you need.
Thank you for the suggestion Pawan Bhai. I will keep it in my mind.

Thanks a lot for your effort in helping me out. Much Appreciated.

Best Regards