SSRS daywise calculation for current week

• ashok.sql-972589

  SSC Rookie

  Points: 45

  More actions

  June 24, 2017 at 7:50 pm

  #343347

  Created a report with 3 column groups . 1. Day wise 2. Weekwise 3. Month wise for the selected date.
  1.Let's assume am running the report for 4th week of March(Mar24th based on parameter selected value). my day wise calculations should reflect the current week data. right now its displaying for the 1st week of the month(March first week). I tried to add the filter condition in daywise column group with dateadd -7 validation.It does not work. Any help much appreciated..

  Ex:         Sun Mon  Tue Wed Thu Fri Sat week1 week2 week3 week4 week5 month
  Data          1   222   33   44    55   66 77   1233  1222      1224  1225      0        2133

• sgmunson

  SSC Guru

  Points: 110639

  More actions

  June 26, 2017 at 1:05 pm

  #1948233

  ashok.sql-972589 - Saturday, June 24, 2017 7:50 PM

  Created a report with 3 column groups . 1. Day wise 2. Weekwise 3. Month wise for the selected date.
  1.Let's assume am running the report for 4th week of March(Mar24th based on parameter selected value). my day wise calculations should reflect the current week data. right now its displaying for the 1st week of the month(March first week). I tried to add the filter condition in daywise column group with dateadd -7 validation.It does not work. Any help much appreciated..

  Ex:         Sun Mon  Tue Wed Thu Fri Sat week1 week2 week3 week4 week5 month
  Data          1   222   33   44    55   66 77   1233  1222      1224  1225      0        2133

  We don't have anywhere near enough information to have any idea what you are actually doing in that report, or it's datasources or datasets.   What we can't see, we can't very well help with.

  Steve (aka sgmunson) 🙂 🙂 🙂
  Rent Servers for Income (picks and shovels strategy)

• ashok.sql-972589

  SSC Rookie

  Points: 45

  More actions

  June 26, 2017 at 1:30 pm

  #1948242

  sgmunson - Monday, June 26, 2017 1:05 PM

  ashok.sql-972589 - Saturday, June 24, 2017 7:50 PM

  Created a report with 3 column groups . 1. Day wise 2. Weekwise 3. Month wise for the selected date.
  1.Let's assume am running the report for 4th week of March(Mar24th based on parameter selected value). my day wise calculations should reflect the current week data. right now its displaying for the 1st week of the month(March first week). I tried to add the filter condition in daywise column group with dateadd -7 validation.It does not work. Any help much appreciated..

  Ex:         Sun Mon  Tue Wed Thu Fri Sat week1 week2 week3 week4 week5 month
  Data          1   222   33   44    55   66 77   1233  1222      1224  1225      0        2133

  We don't have anywhere near enough information to have any idea what you are actually doing in that report, or it's datasources or datasets.   What we can't see, we can't very well help with.

  Thanks for your reply. I created Dataset with oracle database connection. From the dataset am retrieving the Aggregated  Sales Amount. In RDL created the three different Column groups to form the data for daywise, weeklywise and Month by using the Sales Amount. PFA sample. Thanks for your help..

• Thom A

  SSC Guru

  Points: 99126

  More actions

  June 27, 2017 at 4:10 am

  #1948318

  I'm still not 100% sure on what it is your attempting to achieve here, so I'm going to explain my understanding, and if it's correct, bingo! ^_^

  You have data, which you want to aggregate (let's say sales). You'll be supplying a date, you want to return the number of sales for that week so far, then sales by week for the month so far, and then finally the number of sales for the month. If I understand correctly, Something like this might meet your goals.:
  --Create sample table
CREATE TABLE #Sale (SaleID int IDENTITY(1,1), --Because i just wanted some kind of Identity
       SaleDate date,
       SaleValue decimal(12,2));
GO
--Create sample data. there is done quite a lot, as we need a month of data, however, I have been lazy and not put times on the dates.
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 103.42);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 377.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 652.33);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 452.93);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 797.21);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 56.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 260.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 758.69);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 6244.49);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 514.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 976.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 112.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 3918.38);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 247.82);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 4559.18);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 20.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 575.68);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 689.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 2823.56);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 112.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 247.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 431.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 529.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 417.19);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 56.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 3439.30);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 100.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 452.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 709.74);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 973.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 497.49);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 685.51);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 436.50);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 381.62);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 140.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 2021.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 286.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 476.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 628.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 182.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 209.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 256.91);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 333.21);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 425.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 235.56);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 505.41);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 549.86);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 597.74);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 1643.45);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 404.78);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 440.99);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 655.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 311.99);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 406.30);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 524.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 312.10);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 156.86);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 882.99);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 80.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 505.48);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 294.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 810.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 68.95);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 408.34);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 693.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 435.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 2310.39);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 280.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 337.45);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 538.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 123.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 1166.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 236.88);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 435.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 677.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 154.22);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 1301.89);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 590.04);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 1873.03);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 457.30);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 120.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 145.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 247.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 1335.03);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 80.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 285.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170627', 808.75);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 213.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 125.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 285.48);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 513.55);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 425.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 191.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 611.18);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 100.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 577.74);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 197.81);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 2491.86);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 288.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 241.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 566.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 620.86);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 651.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 404.78);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 374.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 68.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 431.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 389.50);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 2540.99);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 140.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 151.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 373.87);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 387.98);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 355.86);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 568.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 366.63);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 6682.25);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 196.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 1420.26);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 1199.84);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 140.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 312.56);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 125.29);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 438.55);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 61.69);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 677.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 2252.77);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 816.82);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 791.34);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 550.69);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 192.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 358.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 460.95);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 2321.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 520.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 198.91);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 8150.81);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 505.57);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 2926.31);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 915.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 218.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 472.99);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 589.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 497.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 369.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 482.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 155.62);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 547.30);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 730.04);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 3041.15);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 1182.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 408.01);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 623.90);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 457.45);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 335.70);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 1052.98);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 366.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 181.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 80.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 526.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 807.18);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 825.05);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 229.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 994.06);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 809.38);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 281.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 940.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 487.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170626', 172.70);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 766.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 153.16);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 312.10);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 560.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 100.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 1726.03);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 638.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 392.68);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 415.15);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 435.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 213.02);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 80.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 739.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 237.66);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 627.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 373.87);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 452.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 277.05);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 467.98);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 476.51);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 468.82);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 254.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 399.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 159.38);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 140.63);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 461.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 231.75);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 141.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 263.81);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 95.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 285.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 144.08);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 947.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 770.39);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 2708.79);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 566.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 397.01);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 705.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 3815.25);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 564.75);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 500.71);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 253.68);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 137.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 1590.45);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 393.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 56.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 374.38);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 558.19);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 538.81);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 610.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 1108.68);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 354.89);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 536.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 3316.39);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 125.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 104.83);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 604.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 130.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 196.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 163.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 425.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 516.81);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 596.56);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 888.46);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 891.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 1875.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 930.10);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 161.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 683.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 532.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 542.73);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 236.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 639.39);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 3683.81);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 124.49);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 137.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 20.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 263.86);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 211.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 1322.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170625', 100.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 406.45);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 869.87);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 47.31);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 335.22);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 399.81);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 1718.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 476.77);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 927.02);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 649.49);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 56.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 1059.50);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 728.88);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 1531.91);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 514.19);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 357.18);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 328.48);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 216.46);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 381.65);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 195.70);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 754.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 302.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 91.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 105.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 462.16);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 347.29);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 460.45);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 118.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 490.88);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 333.47);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 189.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 1614.69);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 305.73);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 1523.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 118.97);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 751.41);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 1145.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 447.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 760.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 481.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 1122.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 4001.30);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 239.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 594.45);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 299.63);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 1346.13);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 1139.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 91.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 571.31);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 224.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 1104.10);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 2353.18);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 550.59);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 474.46);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 647.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 2422.45);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 2750.66);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 609.99);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 452.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 969.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 125.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 1033.87);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 630.71);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 997.74);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 494.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 419.15);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 570.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 264.88);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 599.98);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 4139.89);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 512.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 3105.55);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 760.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 459.87);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 1335.19);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 3613.86);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 57607.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 1501.16);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 401.75);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 280.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 200.48);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 1515.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 294.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 851.31);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 140.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 3133.07);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 358.81);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 235.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 352.93);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 322.91);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 221.49);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 651.95);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 184.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 397.04);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 177.11);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 68.95);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 200.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 336.47);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 1320.48);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170624', 91.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 618.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 569.97);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 560.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 494.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 1070.83);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 842.56);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 229.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 394.84);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 90.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 1763.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 228.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 531.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 428.75);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 4980.48);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 141.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 4908.69);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 655.09);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 308.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 634.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 299.48);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 756.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 363.47);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 435.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 241.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 1977.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 286.97);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 53.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 1012.70);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 404.02);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 317.17);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 1285.50);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 529.18);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 378.01);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 230.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 656.82);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 365.18);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 172.70);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 1065.39);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 410.93);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 707.95);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 81.91);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 70.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 609.10);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 144.39);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 345.26);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 946.90);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 4377.08);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 460.45);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 20.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 502.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 521.93);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 573.03);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 287.26);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 112.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 991.55);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 319.98);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 4881.89);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 1164.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 449.11);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 181.89);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 9301.51);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 428.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 658.22);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 120.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 501.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 360.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 91.93);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 270.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 2215.38);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 118.48);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 91.73);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 209.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 625.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 441.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 413.04);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 270.48);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 694.74);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 401.17);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 404.02);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 258.66);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 4445.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 222.16);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 1629.15);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 140.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 20.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 2088.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 3900.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 369.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 766.29);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 346.27);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 502.77);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 293.85);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170623', 261.42);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 268.21);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 196.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 698.88);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 413.17);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 193.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 20.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 593.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 297.06);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 145.15);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 981.23);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 56.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 641.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 702.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 259.75);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 786.46);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 268.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 641.61);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 1779.93);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 344.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 320.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 482.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 2593.58);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 436.56);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 3146.63);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 1461.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 543.87);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 662.70);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 412.89);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 252.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 2047.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 648.30);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 228.31);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 308.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 621.71);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 636.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 439.51);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 197.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 473.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 153.22);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 639.99);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 109.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 425.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 330.61);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 1247.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 227.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 425.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 1431.93);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 720.66);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 316.62);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 395.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 88.70);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 367.07);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 481.25);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 3870.50);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 403.09);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 445.68);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 319.87);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 178.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 457.62);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 755.22);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 298.22);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 294.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 313.82);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 331.34);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 1095.58);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 140.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 670.13);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 848.51);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 100.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 8.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170622', 408.85);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 482.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 360.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 470.74);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 350.71);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 528.65);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 639.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 349.33);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 425.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 423.26);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 1135.46);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 399.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 632.69);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 120.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 369.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 303.22);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 294.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 229.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 631.34);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 1720.43);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 299.83);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 560.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 194.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 642.88);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 528.29);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 179.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 224.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 445.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 5598.26);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 463.08);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 253.68);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 4123.55);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 56.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 399.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 1302.87);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 696.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 144.51);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 12255.90);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 346.30);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 164.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 1007.33);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 499.31);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 109.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 415.16);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 1201.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 732.79);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 418.22);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 392.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 717.06);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 272.27);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 608.98);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 7876.38);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 431.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 694.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 229.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 425.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 675.48);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 125.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 504.11);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 486.65);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 207.93);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 1570.78);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 671.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 125.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 628.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 723.22);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 244.62);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 38140.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 1170.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 2727.88);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 713.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 548.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 323.09);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 768.67);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 554.51);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 420.57);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 3557.33);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 378.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 241.25);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 551.13);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 128.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 132.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 112.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 452.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 137.09);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 411.77);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 482.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 488.43);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 596.01);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170621', 418.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 392.68);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 285.39);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 176.74);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 348.89);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 185.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 393.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 100.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 280.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 482.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 614.99);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 474.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 831.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 1099.95);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 358.81);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 1994.90);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 440.26);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 663.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 739.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 20.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 452.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 627.31);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 342.23);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 427.70);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 492.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 871.10);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 674.35);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 145.15);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 452.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 257.85);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 5196.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 163.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 482.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 338.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 140.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 360.53);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 635.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 1007.37);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 2028.33);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 853.35);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 463.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 112.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 427.55);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 1668.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 614.15);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 98.78);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 997.06);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 1520.71);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 309.99);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 459.87);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 659.97);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 3752.49);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 554.29);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 473.09);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 100.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 546.91);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 147.78);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 562.02);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 565.06);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 194.88);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 336.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 470.90);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 3150.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 1145.30);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 396.89);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 452.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 509.97);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 490.11);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 520.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 417.97);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 445.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 446.03);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 1201.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 465.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 161.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 417.97);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 247.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 284.85);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 568.11);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 1206.27);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 280.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 638.03);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 428.75);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 795.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 3874.43);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 500.55);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 673.29);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 562.02);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 399.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 280.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 458.17);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 452.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 1622.69);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 2308.11);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 260.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 285.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 551.26);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 819.53);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 839.79);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 1040.86);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 599.87);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 196.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 361.26);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 131.41);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 224.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 308.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 62.25);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 230.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 623.84);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 415.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 197.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 395.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 381.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 127.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 517.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 541.97);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 549.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 1056.38);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 192.86);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170620', 694.74);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 452.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 353.02);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 137.89);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 294.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 888.62);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 247.82);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 239.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 168.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 522.84);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 423.88);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 56.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 5530.25);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 609.10);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 752.74);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 762.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 161.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 259.39);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 933.74);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 793.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 480.81);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 461.48);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 796.95);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 647.16);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 477.46);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 113.48);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 164.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 405.09);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 958.19);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 146.16);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 514.09);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 697.05);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 622.18);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 551.05);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 217.90);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 767.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 288.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 457.04);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 256.69);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 125.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 112.91);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 759.58);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 777.75);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 991.39);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 308.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 308.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 154.56);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 327.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 90.09);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 380.81);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 381.65);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 234.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 20.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 346.42);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 1091.89);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 400.11);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 697.23);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 634.03);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 212.69);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 288.78);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 939.59);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 56.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 207.93);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 1797.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 616.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 193.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 339.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 382.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 121.74);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 120.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 408.81);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 744.15);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 382.45);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 404.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 1984.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 1870.82);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 100.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 229.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 534.35);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 989.74);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 681.91);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 3963.39);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 288.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 225.25);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 369.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 1307.13);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 861.04);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 1044.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 80.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 280.06);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 247.30);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 2236.45);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 686.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 343.30);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 219.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 269.53);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 415.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 885.27);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170619', 376.10);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 204.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 456.61);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 827.08);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 913.47);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 364.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 1289.75);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 474.77);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 562.02);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 619.02);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 722.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 373.39);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 315.48);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 566.83);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 1108.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 291.03);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 134.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 137.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 1829.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 398.37);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 494.93);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 1135.57);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 229.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 95.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 924.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 283.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 210.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 508.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 695.74);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 87.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 445.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 277.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 294.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 257.43);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 2433.17);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 364.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 351.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 1263.18);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 610.06);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 120.66);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 634.03);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 944.38);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 145.15);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 189.84);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 755.67);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 352.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 452.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 2573.42);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 778.74);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 624.62);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 624.29);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 450.87);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 2859.23);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 635.49);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 431.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 516.99);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 391.18);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 319.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 234.81);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 377.45);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 1961.30);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 344.25);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 395.56);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 218.33);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 457.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 332.15);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 256.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 512.62);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 552.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170618', 5125.71);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 860.21);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 634.03);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 320.23);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 621.82);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 488.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 594.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 436.68);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 260.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 411.58);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 786.67);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 474.88);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 196.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 553.39);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 784.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 2236.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 670.34);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 250.66);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 451.87);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 569.21);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 1124.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 215.48);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 496.05);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 184.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 938.85);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 3015.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 176.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 57.58);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 329.86);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 253.68);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 1944.31);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 327.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 321.55);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 376.95);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 1260.90);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 467.48);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 294.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 387.98);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 229.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 508.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 640.67);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 88.70);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 1840.33);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 5737.99);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 202.15);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 1945.57);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 381.04);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 182.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 198.91);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 141.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 299.71);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 1740.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 446.34);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 1798.13);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 656.43);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 1400.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 171.55);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 1734.06);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 314.81);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 8.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 562.61);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 459.98);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 501.55);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 1615.49);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 152.95);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 435.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 470.90);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 576.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 1685.71);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 400.04);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 1411.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 352.50);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 361.29);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 652.42);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 864.10);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 170.69);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 355.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 1375.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 339.06);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 7994.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 519.34);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 485.62);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 656.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 1532.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 239.34);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 567.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 133.84);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 1176.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 369.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 184.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 508.86);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 3347.81);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 615.10);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 894.02);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 538.55);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 386.43);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 20.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 507.35);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170617', 709.86);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 715.68);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 509.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 377.10);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 20.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 20.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 463.15);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 161.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 204.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 489.41);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 343.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 256.91);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 294.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 98.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 4655.49);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 1176.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 333.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 287.39);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 404.78);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 826.67);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 109.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 416.85);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 420.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 409.55);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 137.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 633.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 656.15);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 716.13);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 916.05);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 1955.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 763.88);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 411.42);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 302.98);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 436.39);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 4821.38);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 366.41);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 20.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 666.84);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 551.86);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 369.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 140.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 1755.27);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 247.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 515.31);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 616.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 234.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 313.85);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 80.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 217.58);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 184.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 241.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 4636.48);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 1569.53);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 1186.46);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 193.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 1009.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 416.01);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 965.79);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 172.31);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 47.81);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 305.61);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 413.04);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 265.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 450.70);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 280.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 839.03);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 7250.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 480.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 2240.49);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 510.86);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 369.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 468.17);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 597.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 640.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 935.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 631.25);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 227.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 297.07);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 333.21);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 369.21);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 1053.25);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 456.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 294.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 480.98);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 225.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 377.21);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 604.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 407.63);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 1368.65);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 440.75);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 3693.57);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 914.78);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 553.21);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 181.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 494.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 229.15);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 583.27);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 258.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 961.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 431.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 378.01);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 1636.58);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 419.71);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 445.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 700.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 4702.57);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170616', 329.97);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 168.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 1055.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 56.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 114.91);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 445.58);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 76.61);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 514.98);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 510.27);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 1092.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 635.15);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 104.83);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 308.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 140.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 411.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 285.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 294.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 476.77);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 250.66);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 738.53);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 689.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 6938.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 513.07);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 109.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 520.99);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 352.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 20.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 297.25);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 747.02);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 155.61);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 613.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 457.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 385.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 6618.35);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 425.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 536.97);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 442.84);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 1014.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 5430.79);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 694.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 572.10);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 2866.57);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 745.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 1540.81);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 690.48);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 2701.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 425.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 1353.91);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 551.45);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 433.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 129.58);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 90.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 138.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 903.56);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 896.42);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 757.23);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 399.85);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 1640.31);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 452.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 262.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 428.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 238.57);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 91.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 323.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 437.81);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 2260.41);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 394.65);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 969.58);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 452.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 463.23);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 745.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 271.78);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 322.74);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 385.70);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 102.50);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 80.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 728.45);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 602.74);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 137.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 72.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 772.13);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 810.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 152.95);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 912.02);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 181.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 359.42);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 201.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 452.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 616.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 189.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 399.95);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 227.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 1040.50);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 1198.99);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 398.37);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 20.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 451.56);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 537.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 592.11);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 860.82);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 604.58);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 1321.71);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 591.55);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 140.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 687.70);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 501.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 629.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 1212.48);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 294.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 1176.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 95.10);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 213.70);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 369.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 1071.18);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 56.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 617.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 398.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170615', 608.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 322.26);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 662.68);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 436.68);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 574.15);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 412.89);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 654.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 193.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 291.35);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 508.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 510.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 647.47);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 767.37);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 957.57);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 2323.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 916.07);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 1698.04);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 405.25);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 440.75);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 528.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 915.26);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 443.07);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 710.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 617.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 1701.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 530.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 147.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 291.41);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 497.68);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 380.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 137.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 249.31);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 1092.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 954.46);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 4058.49);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 256.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 469.95);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 352.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 168.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 127.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 124.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 349.22);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 813.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 458.39);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 86.45);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 3213.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 474.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 1256.19);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 193.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 4635.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 56.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 196.90);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 146.16);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 1312.75);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 1788.82);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 2789.01);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 573.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 308.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 689.70);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 1019.87);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 537.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 623.26);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 40.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 535.21);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 94.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 137.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 435.55);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 294.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 308.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 215.26);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 80.08);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 433.25);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 98.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 767.31);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 476.29);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 240.90);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 714.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 133.06);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 394.23);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 454.10);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 185.61);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 658.45);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 80.08);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 1023.46);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 1082.37);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 360.04);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 753.04);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 1155.84);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 329.86);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 1215.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 387.63);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 452.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 1379.06);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170614', 259.84);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 534.43);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 395.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 294.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 11.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 590.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 87.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 404.07);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 269.81);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 154.56);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 40.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 112.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 617.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 130.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 175.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 325.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 377.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 433.25);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 181.66);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 2591.59);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 134.06);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 1308.38);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 107.79);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 137.98);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 367.74);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 539.50);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 758.55);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 1032.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 452.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 420.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 468.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 299.48);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 585.49);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 213.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 151.53);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 803.26);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 1123.46);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 758.26);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 564.88);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 1146.09);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 335.63);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 16129.89);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 14772.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 2290.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 204.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 4695.77);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 438.61);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 431.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 597.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 681.74);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 117.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 565.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 482.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 1801.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 175.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 294.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 2909.21);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 361.29);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 969.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 376.39);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 374.38);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 3940.91);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 756.15);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 1024.04);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 635.43);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 229.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 425.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 685.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 592.98);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 509.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 511.84);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 452.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 157.25);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 302.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 241.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 285.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 152.88);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 56.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 1929.70);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 152.95);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 202.29);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 20.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 424.78);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 2673.99);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 661.55);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 303.33);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 271.01);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 386.43);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 601.55);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 309.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 591.95);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 368.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 435.46);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 98.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 411.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 244.16);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 1212.48);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 1625.59);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 135.88);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 244.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 644.06);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 678.05);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 2839.29);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 1152.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 362.95);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170613', 82.99);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 580.75);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 124.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 316.11);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 175.83);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 168.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 825.29);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 297.06);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 491.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 1759.68);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 411.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 230.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 20.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 182.63);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 591.95);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 724.08);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 789.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 806.68);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 137.73);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 408.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 785.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 269.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 352.93);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 1610.67);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 914.30);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 682.86);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 1065.70);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 229.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 239.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 145.15);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 361.29);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 164.08);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 515.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 172.37);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 1115.18);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 1076.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 3126.48);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 285.39);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 761.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 452.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 464.42);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 411.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 549.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 297.06);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 122.30);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 515.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 204.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 116.37);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 56.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 482.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 313.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 646.26);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 2135.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 919.51);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 147.17);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 137.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 137.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 1700.07);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 452.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 20.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 623.23);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 577.58);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 60.48);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 499.16);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 594.26);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 2691.15);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 413.04);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 137.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 299.48);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 511.73);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 697.42);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 277.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 989.23);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 56.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 125.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 411.58);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 161.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 328.78);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 145.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 1049.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 1834.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 161.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 461.33);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 163.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 450.11);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 1687.68);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 2799.27);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 3128.65);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 148.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 431.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 527.18);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170612', 685.46);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 691.04);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 572.88);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 529.51);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 978.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 427.48);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 2328.69);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 254.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 483.39);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 442.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 164.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 218.06);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 667.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 3887.86);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 652.42);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 605.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 482.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 727.15);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 56.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 342.62);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 777.06);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 413.04);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 651.78);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 352.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 2927.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 293.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 119.84);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 526.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 377.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 586.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 462.16);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 657.10);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 524.26);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 280.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 302.98);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 641.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 630.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 356.83);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 148.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 160.88);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 519.57);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 503.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 76.61);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 197.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 634.78);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 851.98);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 1328.06);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 277.97);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 167.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 647.81);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 1002.51);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 241.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 144.48);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 591.11);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 2861.26);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 446.35);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 160.16);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 2152.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 234.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 4405.68);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 706.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 197.57);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 2241.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 622.38);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 617.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 300.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 552.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 772.37);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 225.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 431.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 561.79);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 366.04);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 131.01);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 531.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 155.13);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 832.98);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 498.06);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 125.45);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 2434.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 2642.29);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 489.90);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 141.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 425.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 453.70);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 203.91);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 397.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170611', 187.75);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 691.49);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 482.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 2555.97);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 443.07);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 406.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 137.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 213.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 161.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 627.31);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 597.47);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 1787.18);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 379.34);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 255.01);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 363.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 4480.78);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 72.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 466.15);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 512.90);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 647.33);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 1619.33);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 569.07);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 145.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 812.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 721.84);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 244.62);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 145.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 141.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 378.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 1167.62);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 273.49);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 858.37);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 144.08);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 595.06);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 1080.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 418.30);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 282.71);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 124.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 406.79);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 222.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 2331.84);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 423.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 563.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 20.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 296.13);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 2820.10);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 190.30);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 91.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 65.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 161.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 1267.66);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 151.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 476.83);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 87.05);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 308.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 77.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 663.26);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 3700.63);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 406.91);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 443.07);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 154.56);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 141.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 763.57);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 629.56);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 1864.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 264.88);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 582.18);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 302.22);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 441.17);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 60.05);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 92.74);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 1589.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 120.66);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 827.90);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 592.70);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 584.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 1794.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 495.73);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 366.68);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 416.85);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 204.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 651.66);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 758.26);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 114.91);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 272.70);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 1022.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 391.18);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 617.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 431.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 716.41);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170610', 814.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 639.18);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 689.58);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 482.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 849.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 1122.30);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 765.18);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 914.42);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 229.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 771.34);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 411.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 361.29);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 671.55);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 272.70);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 572.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 72.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 125.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 646.46);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 227.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 1092.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 2536.59);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 308.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 79.83);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 234.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 603.46);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 446.03);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 469.27);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 627.39);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 415.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 346.71);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 359.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 2666.67);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 409.03);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 411.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 1064.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 385.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 217.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 463.33);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 72.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 1191.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 4615.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 952.45);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 602.34);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 463.71);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 278.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 462.16);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 411.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 162.03);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 408.34);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 146.69);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 777.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 404.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 266.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 496.05);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 262.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 391.71);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 248.67);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 482.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 375.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 616.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 652.42);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 85.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 588.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 823.98);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 438.69);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 449.11);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 653.13);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 687.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 207.50);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 1341.82);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 401.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 226.27);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 3547.45);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 239.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 1263.82);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 1761.51);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 1314.63);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 90.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 161.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 851.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 179.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 414.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 601.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 497.45);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 828.82);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 163.30);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170609', 341.05);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 359.42);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 145.15);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 225.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 184.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 730.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 229.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 361.69);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 125.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 193.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 671.55);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 1025.81);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 1853.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 148.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 308.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 2165.42);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 283.51);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 177.41);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 782.02);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 1205.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 229.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 229.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 264.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 614.77);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 350.83);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 543.87);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 91.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 431.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 440.75);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 392.68);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 56.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 433.25);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 450.35);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 8533.65);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 80.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 288.67);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 423.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 239.62);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 321.33);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 1006.04);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 264.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 227.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 481.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 137.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 4315.26);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 612.71);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 674.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 2264.46);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 161.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 610.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 20.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 416.81);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 382.86);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 317.15);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 719.04);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 1092.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 652.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 778.38);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 494.09);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 65.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 404.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 684.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 582.22);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 425.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 290.30);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 232.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 392.68);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 3273.51);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 1084.67);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 480.81);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 468.50);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 528.82);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 622.61);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 184.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 799.04);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 480.59);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 359.69);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 235.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 491.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170608', 409.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 1709.43);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 182.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 406.79);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 168.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 2260.90);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 446.15);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 513.07);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 520.97);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 251.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 3226.73);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 382.04);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 2231.11);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 696.75);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 20.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 412.19);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 992.66);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 168.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 196.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 452.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 780.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 227.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 303.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 1042.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 27.22);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 411.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 2511.23);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 556.11);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 225.25);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 936.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 408.55);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 469.17);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 1113.78);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 1930.09);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 124.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 646.84);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 56.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 397.61);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 554.51);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 325.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 141.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 498.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 297.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 680.53);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 832.98);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 108.86);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 244.16);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 129.02);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 512.06);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 240.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 105.56);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 924.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 719.82);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 3391.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 2532.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 526.25);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 1219.46);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 224.73);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 73.71);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 588.25);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 622.88);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 308.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 513.07);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 2794.81);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 81.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 184.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 308.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 115.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 212.50);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 100.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 701.34);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 720.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 255.48);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 369.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 140.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 1285.74);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 459.42);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 2226.62);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 77.82);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 374.38);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 632.56);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 20.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 1116.21);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170607', 158.33);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 342.84);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 2054.46);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 957.58);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 56.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 191.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 572.01);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 403.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 98.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 431.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 80.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 261.42);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 452.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 641.42);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 752.51);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 255.98);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 698.88);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 533.01);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 647.81);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 288.58);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 404.78);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 137.89);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 431.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 291.41);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 770.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 506.09);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 215.04);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 1197.73);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 593.82);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 452.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 1219.46);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 326.01);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 687.70);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 458.21);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 1445.15);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 208.49);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 107.25);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 437.21);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 361.29);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 580.82);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 141.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 85.18);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 415.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 328.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 150.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 309.75);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 529.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 371.65);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 161.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 280.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 147.43);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 113.34);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 431.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 415.16);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 3120.02);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 92.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 81.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 431.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 728.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 229.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 528.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 381.62);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 769.78);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 628.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 330.13);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 60.69);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 352.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 510.27);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 1188.07);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 56.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 634.39);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 100.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 1980.25);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 501.65);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 952.39);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 124.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 478.53);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 268.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 185.15);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 797.66);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 80.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 561.34);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 523.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 479.74);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 625.97);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 621.71);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 684.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 220.26);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 547.23);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 333.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 582.75);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 489.33);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 400.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 5638.08);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 307.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 406.56);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 294.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 456.57);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 728.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 381.65);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 470.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 179.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 244.62);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 189.50);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 125.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 229.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 493.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 671.47);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170606', 7671.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 702.35);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 741.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 307.97);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 308.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 492.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 273.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 1886.19);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 351.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 68.95);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 175.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 294.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 161.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 615.78);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 569.79);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 576.69);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 689.70);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 218.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 837.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 891.18);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 3272.46);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 351.56);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 224.06);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 388.97);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 211.01);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 72.58);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 114.91);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 434.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 460.45);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 192.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 425.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 658.63);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 636.48);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 577.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 240.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 442.89);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 814.83);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 880.77);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 294.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 181.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 137.89);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 308.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 411.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 206.84);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 247.50);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 163.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 870.68);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 415.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 486.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 652.42);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 535.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 595.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 598.99);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 175.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 65.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 857.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 201.88);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 487.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 161.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 294.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 583.63);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 371.65);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 589.29);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 1911.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 650.38);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 294.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 445.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 154.71);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 365.58);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 632.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 124.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 229.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 434.67);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 637.78);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 1005.45);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 495.09);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 468.04);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 783.46);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 435.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 144.08);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 100.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 399.88);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 3706.38);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 112.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 125.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170605', 348.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 598.98);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 476.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 562.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 229.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 1597.25);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 2961.02);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 1052.15);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 369.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 369.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 369.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 474.99);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 779.62);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 2013.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 2356.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 80.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 112.04);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 177.18);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 514.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 224.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 2823.95);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 230.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 273.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 449.11);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 2543.46);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 1532.61);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 480.81);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 20.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 20.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 479.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 665.83);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 352.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 4448.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 284.45);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 137.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 512.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 6899.05);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 314.10);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 373.87);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 391.18);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 550.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 590.91);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 377.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 411.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 2894.23);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 560.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 861.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 348.13);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 288.38);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 419.75);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 228.31);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 541.18);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 1618.18);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 80.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 322.26);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 247.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 3669.69);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 474.77);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 56.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 2374.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 3253.37);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 726.88);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 595.84);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 120.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 603.48);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 161.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 807.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 208.23);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 513.07);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 600.63);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 188.23);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 543.31);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 482.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 805.15);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170604', 5718.73);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 1788.19);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 475.37);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 259.69);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 2475.89);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 609.10);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 1067.04);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 684.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 372.70);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 1129.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 213.92);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 473.22);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 3442.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 297.06);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 499.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 803.88);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 689.38);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 291.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 337.45);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 797.49);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 506.11);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 394.74);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 196.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 526.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 112.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 381.65);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 185.07);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 247.82);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 145.15);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 400.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 154.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 605.49);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 391.18);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 446.43);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 7147.35);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 394.23);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 227.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 703.04);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 392.68);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 416.85);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 392.68);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 112.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 755.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 400.85);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 828.91);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 203.84);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 706.37);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 168.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 411.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 378.84);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 394.23);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 6248.17);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 320.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 294.45);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 462.16);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 394.74);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 473.88);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 1137.83);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 226.71);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 625.78);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 315.84);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 5974.41);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 558.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 294.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 124.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 850.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 877.74);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 452.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 264.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 429.63);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 480.81);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 497.84);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 86.18);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 388.45);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 608.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 6288.56);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 586.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 795.27);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 374.91);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 395.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 700.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 729.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 227.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 72.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 433.25);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 375.50);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 417.97);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 305.75);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 824.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 800.84);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 96.82);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 293.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170603', 612.68);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 543.87);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 3473.13);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 621.71);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 113.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 344.49);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 333.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 406.79);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 329.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 199.02);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 530.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 134.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 1463.31);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 201.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 94.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 474.30);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 244.16);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 615.43);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 81.91);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 426.47);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 366.84);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 171.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 152.21);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 178.23);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 178.22);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 633.27);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 478.63);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 68.95);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 566.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 621.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 196.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 431.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 521.70);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 3866.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 459.67);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 496.83);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 397.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 112.84);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 696.30);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 6423.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 473.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 68.95);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 509.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 604.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 485.41);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 296.89);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 398.73);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 407.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 270.48);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 168.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 225.25);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 88.70);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 433.53);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 648.89);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 385.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 585.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 244.16);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 3822.78);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 399.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 719.26);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 461.43);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 260.23);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 335.87);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 294.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 112.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 555.18);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 1012.46);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 1239.82);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 431.42);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 1201.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 203.95);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 388.11);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 842.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 56.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 596.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 586.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 1595.01);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 391.18);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 68.95);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 294.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 134.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 403.11);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 174.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 242.58);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 250.23);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 551.37);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 395.45);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 988.62);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 498.65);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 448.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 473.76);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 918.61);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 244.62);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 1536.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 475.33);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 141.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 187.75);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 644.78);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 571.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 98.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 384.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 506.31);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170602', 3094.01);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 352.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 460.45);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 1275.75);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 503.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 80.08);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 766.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 127.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 924.87);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 561.79);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 480.59);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 394.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 397.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 388.45);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 406.63);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 737.34);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 1349.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 427.06);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 4054.21);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 449.11);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 20.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 478.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 507.79);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 1099.84);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 631.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 116.93);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 393.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 3588.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 105.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 2151.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 714.56);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 1589.74);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 365.98);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 765.08);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 398.37);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 463.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 463.55);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 369.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 257.91);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 688.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 258.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 1244.99);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 516.09);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 460.45);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 560.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 876.51);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 11497.13);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 400.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 20.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 292.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 889.73);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 536.63);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 299.23);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 2321.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 6049.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 145.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 164.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 2854.81);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 110.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 476.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 734.16);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 168.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 134.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 817.77);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 395.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 103.42);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 280.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 196.08);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 2966.70);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 401.17);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 294.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 80.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 395.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 86.18);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 411.19);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 249.31);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 573.90);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 886.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 56.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 262.94);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 2396.08);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 828.82);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 431.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 6486.39);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 687.50);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 326.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 2493.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 703.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 405.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 966.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 550.70);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 2164.55);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 759.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 428.75);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 107.74);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 340.48);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 257.43);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 454.50);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 510.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 667.52);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 6387.25);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 169.18);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 1096.85);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 125.44);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 3719.68);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 529.65);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 188.83);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 3787.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 1140.54);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 476.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 411.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 56.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 1467.85);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 1533.57);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 657.10);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 1722.67);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 264.32);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 3574.87);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 8821.41);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 3400.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 541.84);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 524.50);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 495.99);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 1143.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 636.53);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 710.02);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 1465.42);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 521.64);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 617.68);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 234.07);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 374.40);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 234.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 231.02);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 3065.35);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 764.82);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 9937.27);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 17950.47);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 512.96);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 144.02);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 288.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 690.42);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 213.71);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 374.88);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 1666.28);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 481.38);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 597.80);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 168.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 243.07);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 1503.57);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 603.68);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 332.26);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 447.22);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 336.19);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 20.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 449.12);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 288.60);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 385.19);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 4752.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 2633.20);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 1747.39);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 816.61);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 258.66);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 690.14);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 369.36);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 161.72);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 55.00);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 525.39);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 1185.24);
INSERT INTO #Sale (SaleDate, SaleValue) VALUES ('20170601', 749.06);
GO
--Check our data.
SELECT *
FROM #Sale;
GO
--Create a KPI CTE. There is probably a better way, but it is what i went for in the end.
--You will have to forgive the text allignement. I am not fixing it... SSC completely ruins any text allignments I write in SSMS. /sigh
WITH DateKPIs AS (
  SELECT CAST(DD.Date as datetime2(0)) AS KPIStart,
    LEAD(CAST(DD.Date as datetime2(0)),1,GETDATE()) OVER (ORDER BY DD.Date) AS KPIEnd, --I have assumed you are on 2012 or later, otherwise you'll need to do a little more work here, as you LEAD was introduced in SQL 2012.
    DD.[Day Name] AS KPIName,
    'Day' AS KPI
  FROM DimDate DD --This is a calendar table I have already. You can read about there here: http://www.sqlservercentral.com/articles/calendar/145206/
  WHERE DD.Date BETWEEN DATEADD(DAY,-@@DATEFIRST,DATEADD(WEEK, DATEDIFF(WEEK, 0, GETDATE()),0)) AND GETDATE()

    UNION ALL

    SELECT DD.Date AS KPIStart,
    LEAD(DD.Date,1,GETDATE()) OVER (ORDER BY DD.Date) AS KPIEnd,--I have assumed you are on 2012 or later, otherwise you will need to do a little more work here, as you LEAD was introduced in SQL 2012.
    'Week' + CAST(ROW_NUMBER() OVER (ORDER BY DD.Date ASC) AS char(1)) AS KPIName,
    'Week' AS KPI
   FROM DimDate DD
   WHERE DD.[Day Name] = 'Sunday'
    AND DD.Date >= (SELECT TOP 1 sq.Date
         FROM DimDate sq
         WHERE sq.Date >= DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()),0)
          AND sq.[Day Name] = 'Sunday'
         ORDER BY sq.Date ASC) --This gives the first Sunday on the month
    AND DD.Date <= GETDATE()
 
  UNION ALL

    SELECT DD.Date AS KPIStart,
    GETDATE() AS KPIEnd,
    'Month' AS KPIName,
    'Month' AS KPI
   FROM DimDate DD
   WHERE DD.Date = DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()),0)
       )
--And now use said CTE to get your data back.
SELECT DK.KPI, DK.KPIName,
   DK.KPIStart, DK.KPIEnd,
   COUNT(S.SaleID) AS Sales,
   SUM(S.SaleValue) AS SalesValue
FROM DateKPIs DK
  LEFT JOIN #Sale S ON DK.KPIStart <= S.SaleDate AND DK.KPIEnd > S.SaleDate
GROUP BY DK.KPI, DK.KPIName,
   DK.KPIStart, DK.KPIEnd
ORDER BY CASE DK.KPI WHEN 'Day' THEN 1 WHEN 'Week' THEN 2 ELSE 3 END ASC,
   DK.KPIStart ASC;
GO

  DROP TABLE #Sale;
GO

  Does that help at all? Note that I have used GETDATE() in my queries, rather than a date parameter, but if this is what you are after, you'll have an easy time parametrising it. I've also assumed that for weeks you only want weeks from the first Sunday of the month, rather than an overlap into the previous.

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk

• sgmunson

  SSC Guru

  Points: 110639

  More actions

  June 30, 2017 at 7:50 am

  #1948936

  Okay, did a little work getting the table data in place on my machine, and here's what I came up with in terms of a query that accumulates the data.   I had to decide where to draw the weekly lines, and decided to go with Sunday through Saturday.   By merely using date logic in a CTE to define what all the date ranges are, I can run my query in less than 1 second.   Take a look and let me know if this helps in any way:
  DECLARE @REPORT_DATE AS date = '2017-06-24';
DECLARE @MIN_DATE AS date, @MAX_DATE AS date, @DATE_DIFF AS int;

  SELECT @MIN_DATE = MIN(S.SaleDate), @MAX_DATE = MAX(S.SaleDate),
    @DATE_DIFF = DATEDIFF(day, MIN(S.SaleDate), MAX(S.SaleDate)) + 1
FROM dbo.Sale AS S;

  WITH DATE_RANGE AS (

      SELECT
        CONVERT(date, X.TODAY) AS TODAY,
        CONVERT(date, STUFF(X.TODAY, 9, 2, '01')) AS FIRST_DAY_OF_MONTH,
        DATEADD(day, 1 - DATEPART(weekday, CONVERT(date, X.TODAY)), CONVERT(date, X.TODAY)) AS SUNDAY,
        DATEADD(day, 2 - DATEPART(weekday, CONVERT(date, X.TODAY)), CONVERT(date, X.TODAY)) AS MONDAY,
        DATEADD(day, 3 - DATEPART(weekday, CONVERT(date, X.TODAY)), CONVERT(date, X.TODAY)) AS TUESDAY,
        DATEADD(day, 4 - DATEPART(weekday, CONVERT(date, X.TODAY)), CONVERT(date, X.TODAY)) AS WEDNESDAY,
        DATEADD(day, 5 - DATEPART(weekday, CONVERT(date, X.TODAY)), CONVERT(date, X.TODAY)) AS THURSDAY,
        DATEADD(day, 6 - DATEPART(weekday, CONVERT(date, X.TODAY)), CONVERT(date, X.TODAY)) AS FRIDAY,
        DATEADD(day, 7 - DATEPART(weekday, CONVERT(date, X.TODAY)), CONVERT(date, X.TODAY)) AS SATURDAY,
        CONVERT(date, STUFF(X.TODAY, 9, 2, '01')) AS WEEK1_START,
        DATEADD(day, 7 - DATEPART(weekday, CONVERT(date, STUFF(X.TODAY, 9, 2, '01'))), CONVERT(date, STUFF(X.TODAY, 9, 2, '01'))) AS WEEK1_END,
        DATEADD(day, 1, DATEADD(day, 7 - DATEPART(weekday, CONVERT(date, STUFF(X.TODAY, 9, 2, '01'))), CONVERT(date, STUFF(X.TODAY, 9, 2, '01')))) AS WEEK2_START,
        DATEADD(day, 7, DATEADD(day, 7 - DATEPART(weekday, CONVERT(date, STUFF(X.TODAY, 9, 2, '01'))), CONVERT(date, STUFF(X.TODAY, 9, 2, '01')))) AS WEEK2_END,
        DATEADD(day, 8, DATEADD(day, 7 - DATEPART(weekday, CONVERT(date, STUFF(X.TODAY, 9, 2, '01'))), CONVERT(date, STUFF(X.TODAY, 9, 2, '01')))) AS WEEK3_START,
        DATEADD(day, 14, DATEADD(day, 7 - DATEPART(weekday, CONVERT(date, STUFF(X.TODAY, 9, 2, '01'))), CONVERT(date, STUFF(X.TODAY, 9, 2, '01')))) AS WEEK3_END,
        DATEADD(day, 15, DATEADD(day, 7 - DATEPART(weekday, CONVERT(date, STUFF(X.TODAY, 9, 2, '01'))), CONVERT(date, STUFF(X.TODAY, 9, 2, '01')))) AS WEEK4_START,
        DATEADD(day, 21, DATEADD(day, 7 - DATEPART(weekday, CONVERT(date, STUFF(X.TODAY, 9, 2, '01'))), CONVERT(date, STUFF(X.TODAY, 9, 2, '01')))) AS WEEK4_END,
        CASE
            WHEN DATEADD(day, 21, DATEADD(day, 7 - DATEPART(weekday, CONVERT(date, STUFF(X.TODAY, 9, 2, '01'))), CONVERT(date, STUFF(X.TODAY, 9, 2, '01')))) >=
                 DATEADD(day, -1, DATEADD(month, 1, CONVERT(date, STUFF(X.TODAY, 9, 2, '01')))) THEN CAST(NULL AS date)
            ELSE DATEADD(day, 22, DATEADD(day, 7 - DATEPART(weekday, CONVERT(date, STUFF(X.TODAY, 9, 2, '01'))), CONVERT(date, STUFF(X.TODAY, 9, 2, '01'))))
        END AS WEEK5_START,
        CASE
            WHEN DATEADD(day, 28, DATEADD(day, 7 - DATEPART(weekday, CONVERT(date, STUFF(X.TODAY, 9, 2, '01'))), CONVERT(date, STUFF(X.TODAY, 9, 2, '01')))) >=
                 DATEADD(day, -1, DATEADD(month, 1, CONVERT(date, STUFF(X.TODAY, 9, 2, '01'))))
                 THEN DATEADD(day, -1, DATEADD(month, 1, CONVERT(date, STUFF(X.TODAY, 9, 2, '01'))))
            ELSE DATEADD(day, 28, DATEADD(day, 7 - DATEPART(weekday, CONVERT(date, STUFF(X.TODAY, 9, 2, '01'))), CONVERT(date, STUFF(X.TODAY, 9, 2, '01'))))
        END AS WEEK5_END,
        CASE
            WHEN DATEADD(day, 29, DATEADD(day, 7 - DATEPART(weekday, CONVERT(date, STUFF(X.TODAY, 9, 2, '01'))), CONVERT(date, STUFF(X.TODAY, 9, 2, '01')))) >
                 DATEADD(day, -1, DATEADD(month, 1, CONVERT(date, STUFF(X.TODAY, 9, 2, '01'))))
                 THEN CAST(NULL AS date)
            WHEN DATEADD(day, 29, DATEADD(day, 7 - DATEPART(weekday, CONVERT(date, STUFF(X.TODAY, 9, 2, '01'))), CONVERT(date, STUFF(X.TODAY, 9, 2, '01')))) =
                 DATEADD(day, -1, DATEADD(month, 1, CONVERT(date, STUFF(X.TODAY, 9, 2, '01'))))
                 THEN DATEADD(day, -1, DATEADD(month, 1, CONVERT(date, STUFF(X.TODAY, 9, 2, '01'))))
            ELSE DATEADD(day, 29, DATEADD(day, 7 - DATEPART(weekday, CONVERT(date, STUFF(X.TODAY, 9, 2, '01'))), CONVERT(date, STUFF(X.TODAY, 9, 2, '01'))))
        END AS WEEK6_START,
        CASE
            WHEN DATEADD(day, 29, DATEADD(day, 7 - DATEPART(weekday, CONVERT(date, STUFF(X.TODAY, 9, 2, '01'))), CONVERT(date, STUFF(X.TODAY, 9, 2, '01')))) >
                 DATEADD(day, -1, DATEADD(month, 1, CONVERT(date, STUFF(X.TODAY, 9, 2, '01'))))
                 THEN CAST(NULL AS date)
            ELSE DATEADD(day, -1, DATEADD(month, 1, CONVERT(date, STUFF(X.TODAY, 9, 2, '01'))))
        END AS WEEK6_END,
        DATEADD(day, -1, DATEADD(month, 1, CONVERT(date, STUFF(X.TODAY, 9, 2, '01')))) AS END_OF_MONTH
    FROM (
            VALUES (LEFT(CONVERT(char(19), @REPORT_DATE, 120), 10))
        ) AS X(TODAY)
),
    E1 AS (

          SELECT 0 AS N UNION ALL SELECT 0 UNION ALL SELECT 0 UNION ALL SELECT 0 UNION ALL
        SELECT 0 UNION ALL SELECT 0 UNION ALL SELECT 0 UNION ALL
        SELECT 0 UNION ALL SELECT 0 UNION ALL SELECT 0
),
    NUMBERS AS (

          SELECT TOP (@DATE_DIFF) CAST(DATEADD(day, ROW_NUMBER() OVER(ORDER BY (SELECT NULL)) - 1, @MIN_DATE) AS date) AS THE_DATE
        FROM E1 AS A, E1 AS B, E1 AS C, E1 AS D
)
SELECT @REPORT_DATE AS REPORT_DATE,
    SUM(CASE WHEN S.SaleDate = DR.SUNDAY THEN S.SaleValue ELSE 0. END) AS SUNDAY,
    SUM(CASE WHEN S.SaleDate = DR.MONDAY THEN S.SaleValue ELSE 0. END) AS MONDAY,
    SUM(CASE WHEN S.SaleDate = DR.TUESDAY THEN S.SaleValue ELSE 0. END) AS TUESDAY,
    SUM(CASE WHEN S.SaleDate = DR.WEDNESDAY THEN S.SaleValue ELSE 0. END) AS WEDNESDAY,
    SUM(CASE WHEN S.SaleDate = DR.THURSDAY THEN S.SaleValue ELSE 0. END) AS THURSDAY,
    SUM(CASE WHEN S.SaleDate = DR.FRIDAY THEN S.SaleValue ELSE 0. END) AS FRIDAY,
    SUM(CASE WHEN S.SaleDate = DR.SATURDAY THEN S.SaleValue ELSE 0. END) AS SATURDAY,
    SUM(CASE WHEN S.SaleDate BETWEEN DR.WEEK1_START AND DR.WEEK1_END THEN S.SaleValue ELSE 0. END) AS WEEK_1,
    SUM(CASE WHEN S.SaleDate BETWEEN DR.WEEK2_START AND DR.WEEK2_END THEN S.SaleValue ELSE 0. END) AS WEEK_2,
    SUM(CASE WHEN S.SaleDate BETWEEN DR.WEEK3_START AND DR.WEEK3_END THEN S.SaleValue ELSE 0. END) AS WEEK_3,
    SUM(CASE WHEN S.SaleDate BETWEEN DR.WEEK4_START AND DR.WEEK4_END THEN S.SaleValue ELSE 0. END) AS WEEK_4,
    SUM(CASE WHEN S.SaleDate BETWEEN ISNULL(DR.WEEK5_START, '1899-12-31') AND ISNULL(DR.WEEK5_END, '1899-12-31')
             THEN S.SaleValue ELSE 0. END) AS WEEK_5,
    SUM(CASE WHEN S.SaleDate BETWEEN ISNULL(DR.WEEK6_START, '1899-12-31') AND ISNULL(DR.WEEK6_END, '1899-12-31')
             THEN S.SaleValue ELSE 0. END) AS WEEK_6,
    SUM(CASE WHEN S.SaleDate BETWEEN DR.FIRST_DAY_OF_MONTH AND DR.END_OF_MONTH THEN S.SaleValue ELSE 0. END) AS [MONTH]
FROM dbo.Sale AS S
    INNER JOIN NUMBERS AS N
        ON S.SaleDate = N.THE_DATE
    CROSS APPLY DATE_RANGE AS DR
WHERE S.SaleDate BETWEEN DR.FIRST_DAY_OF_MONTH AND DR.END_OF_MONTH;

  Steve (aka sgmunson) 🙂 🙂 🙂
  Rent Servers for Income (picks and shovels strategy)