calculate active clients on a date and store it, Sql Server

Language: Layout:

CREATE TABLE ACCESS_30DayMeterForecast
    ([Utility Account] varchar(15), [ServiceStartDate] datetime, [DropDate] datetime, [UtilityID] int)
;
    
INSERT INTO ACCESS_30DayMeterForecast
    ([Utility Account], [ServiceStartDate], [DropDate], [UtilityID])
VALUES
    ('0120094000', '2015-06-11 00:00:00', '2016-03-14', 3),
    ('0780167008', '2011-09-06 00:00:00', '2013-03-07', 3),
    ('0956046021', '2012-08-21 00:00:00', NULL, 3),
    ('1270043010', '2014-08-13 00:00:00', '2015-01-14', 3),
    ('1320087000:001', '2011-05-24 00:00:00', '2012-03-01', 3),
    ('1439133008:001', '2011-09-28 00:00:00', '2012-12-27', 3),
    ('1580086005:001', '2012-07-12 00:00:00', '2013-05-13', 3),
    ('1897006157', '2013-05-23 00:00:00', '2012-09-21', 3),
    ('2100167004', '2011-08-23 00:00:00', '2016-05-20', 3),
    ('2134098009', '2015-07-20 00:00:00', '2016-02-19', 3),
    ('2160108003', '2013-02-06 00:00:00', '2013-03-07', 3),
    ('2390796006:001', '2011-05-03 00:00:00', NULL, 3),
    ('2454501003:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('2560047003:001', '2010-09-01 00:00:00', '2012-08-28', 3),
    ('2560105000', '2010-08-25 00:00:00', '2015-02-20', 3),
    ('2637561009:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('2701039001', '2011-06-03 00:00:00', NULL, 3),
    ('2724082046', '2012-12-04 00:00:00', '2015-06-04', 3),
    ('2960176007', '2013-05-30 00:00:00', '2015-10-29', 3),
    ('2962129006', '2016-08-02 00:00:00', NULL, 3),
    ('2980101006', '2011-09-19 00:00:00', '2012-11-01', 3),
    ('3140173014', '2011-08-19 00:00:00', NULL, 3),
    ('3157958009:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('3160096009', '2014-01-29 00:00:00', NULL, 3),
    ('3160096009:001', '2013-05-30 00:00:00', '2013-12-30', 3),
    ('3180167009:001', '2011-06-02 00:00:00', '2013-03-28', 3),
    ('3298032017:001', '2010-08-27 00:00:00', '2011-12-29', 3),
    ('3300173007', '2012-07-23 00:00:00', NULL, 3),
    ('3371105068:001', '2010-07-20 00:00:00', NULL, 3),
    ('3461449000:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('3487137005:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('3514071001', '2013-12-18 00:00:00', NULL, 3),
    ('3514071001:001', '2010-07-23 00:00:00', '2013-02-19', 3),
    ('3759056000', '2014-10-27 00:00:00', '2016-10-25', 3),
    ('3759056000:001', '2010-07-30 00:00:00', '2014-04-28', 3),
    ('3760096029', '2015-05-29 00:00:00', '2016-03-01', 3),
    ('3760105005:001', '2011-04-29 00:00:00', '2011-07-29', 3),
    ('4018042007', '2011-01-27 00:00:00', '2015-03-25', 3),
    ('4271990002:001', '2012-10-29 00:00:00', '2012-10-29', 3),
    ('4308100007', '2015-07-10 00:00:00', NULL, 3),
    ('4308100007:001', '2013-01-10 00:00:00', '2013-02-08', 3),
    ('4308100007:002', '2013-03-11 00:00:00', '2013-03-11', 3),
    ('4308100007:003', '2013-09-10 00:00:00', '2013-09-10', 3),
    ('4308100007:004', '2013-12-13 00:00:00', '2014-01-31', 3),
    ('4308100007:005', '2014-11-10 00:00:00', NULL, 3),
    ('4332099004', '2015-11-16 00:00:00', NULL, 3),
    ('4332099004:001', '2012-08-15 00:00:00', '2013-06-17', 3),
    ('4332099004:002', '2013-08-15 00:00:00', NULL, 3),
    ('4342955000:001', '2010-08-05 00:00:00', '2012-10-31', 3),
    ('4520138009', '2013-06-07 00:00:00', NULL, 3),
    ('4654990006:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('4754080007', '2013-02-19 00:00:00', '2013-06-24', 3),
    ('4754080007:001', '2012-06-19 00:00:00', '2013-01-18', 3),
    ('4808066019', '2013-12-10 00:00:00', '2013-12-10', 3),
    ('4808066019:001', '2013-05-10 00:00:00', '2013-05-10', 3),
    ('4820173013', '2013-03-28 00:00:00', '2013-09-03', 3),
    ('5057362003:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('51001583087', '2010-02-26 00:00:00', '2011-03-29', 1),
    ('51008763054:001', '2011-08-22 00:00:00', '2011-12-20', 1),
    ('51008763054:002', '2012-10-19 00:00:00', NULL, 1),
    ('51008763054:003', '2013-01-21 00:00:00', '2013-02-20', 1),
    ('51008914012', '2010-04-05 00:00:00', '2012-07-03', 1),
    ('51011947090', '2016-12-09 00:00:00', NULL, 1),
    ('51021833066', '2010-03-26 00:00:00', '2011-06-30', 1),
    ('51040732059', '2015-02-12 00:00:00', '2015-05-13', 1),
    ('51040732059:001', '2012-07-13 00:00:00', '2013-02-12', 1),
    ('51044714061', '2010-02-24 00:00:00', '2010-04-01', 1),
    ('51049704042', '2013-10-17 00:00:00', '2014-05-16', 1),
    ('51054522057', '2013-05-03 00:00:00', '2015-05-04', 1),
    ('51060622099', '2014-06-17 00:00:00', '2016-04-19', 1),
    ('51064583057', '2009-12-29 00:00:00', '2011-04-28', 1),
    ('51079272076', '2010-07-01 00:00:00', '2013-01-31', 1),
    ('51092664051', '2010-10-18 00:00:00', '2012-03-19', 1),
    ('51104142013', '2010-02-25 00:00:00', '2011-06-07', 1),
    ('51112876032', '2013-02-28 00:00:00', '2014-03-17', 1),
    ('51123872046', '2015-08-03 00:00:00', NULL, 1),
    ('51176833051', '2010-11-19 00:00:00', '2011-10-21', 1),
    ('51180863060', '2015-06-19 00:00:00', NULL, 1),
    ('51201284072', '2010-03-03 00:00:00', '2010-06-15', 1),
    ('51287483093', '2010-02-26 00:00:00', '2010-10-27', 1),
    ('51302673009:001', '2010-04-21 00:00:00', '2011-05-17', 1),
    ('51324204098', '2010-03-18 00:00:00', '2010-04-20', 1),
    ('51327614053', '2013-02-19 00:00:00', '2013-11-19', 1),
    ('51327614053:001', '2010-03-19 00:00:00', '2011-04-19', 1),
    ('51338424013', '2010-02-24 00:00:00', '2010-04-01', 1),
    ('51340334085', '2010-04-12 00:00:00', '2016-10-17', 1),
    ('51364322016', '2012-08-01 00:00:00', '2015-04-24', 1),
    ('51369253042', '2010-04-26 00:00:00', '2012-06-01', 1),
    ('51376785044', '2013-11-13 00:00:00', '2013-12-13', 1),
    ('51376785044:001', '2011-11-14 00:00:00', '2012-02-14', 1),
    ('51377223078', '2015-08-05 00:00:00', '2016-01-06', 1),
    ('51377223078:001', '2010-05-05 00:00:00', '2013-04-04', 1),
    ('51379503063', '2012-02-09 00:00:00', '2012-06-11', 1),
    ('51379503063:001', '2009-12-09 00:00:00', '2011-03-10', 1),
    ('51389104076', '2010-02-16 00:00:00', '2011-05-17', 1),
    ('51402672042', '2015-02-10 00:00:00', '2015-04-10', 1),
    ('51402672042:001', '2012-01-11 00:00:00', '2014-10-08', 1),
    ('51419483037', '2010-05-25 00:00:00', '2015-03-25', 1),
    ('51427902085', '2013-01-23 00:00:00', '2014-09-23', 1),
    ('51427902085:001', '2012-02-23 00:00:00', NULL, 1),
    ('51438174039', '2013-02-28 00:00:00', '2015-03-02', 1),
    ('51449833060', '2014-10-20 00:00:00', NULL, 1),
    ('51486724057', '2010-09-10 00:00:00', '2012-09-30', 1),
    ('51490634052', '2010-01-19 00:00:00', '2013-10-10', 1),
    ('51493475032', '2011-08-19 00:00:00', '2012-08-20', 1),
    ('51500914098', '2013-03-04 00:00:00', NULL, 1),
    ('51518162094', '2014-09-11 00:00:00', NULL, 1),
    ('51520323056', '2010-07-06 00:00:00', '2011-08-01', 1),
    ('51530392034', '2012-03-12 00:00:00', NULL, 1),
    ('51530392034:001', '2010-02-09 00:00:00', '2011-09-12', 1),
    ('51546043084', '2010-11-16 00:00:00', '2015-02-19', 1),
    ('51549124089:001', '2010-03-09 00:00:00', '2011-12-07', 1),
    ('51549683084', '2015-06-03 00:00:00', '2016-06-03', 1),
    ('51549683084:001', '2014-01-03 00:00:00', '2015-03-04', 1),
    ('51564342038', '2014-10-21 00:00:00', '2015-12-21', 1),
    ('51564732014', '2014-10-20 00:00:00', NULL, 1),
    ('51584192058', '2010-01-26 00:00:00', '2012-10-24', 1),
    ('51607666005', '2016-12-19 00:00:00', NULL, 1),
    ('51613683069', '2016-05-24 00:00:00', NULL, 1),
    ('51613683069:001', '2012-06-25 00:00:00', '2012-08-24', 1),
    ('51613683069:002', '2012-11-26 00:00:00', '2013-02-25', 1),
    ('51624834024', '2010-07-02 00:00:00', NULL, 1),
    ('51654366020', '2010-06-02 00:00:00', '2015-05-18', 1),
    ('51664522034:001', '2010-08-06 00:00:00', NULL, 1),
    ('51683522023', '2015-10-23 00:00:00', NULL, 1),
    ('51683522023:001', '2012-01-25 00:00:00', '2012-04-25', 1),
    ('51683522023:002', '2013-01-24 00:00:00', '2015-02-25', 1),
    ('51707566048', '2014-06-02 00:00:00', NULL, 1),
    ('51709965057', '2014-11-18 00:00:00', '2015-05-19', 1),
    ('51712305028', '2010-01-28 00:00:00', '2011-03-28', 1),
    ('51712904044', '2010-03-04 00:00:00', '2011-09-09', 1),
    ('51714232055', '2010-03-26 00:00:00', '2011-03-25', 1),
    ('51725552095', '2012-02-08 00:00:00', '2012-03-09', 1),
    ('51725552095:001', '2011-11-07 00:00:00', '2011-12-08', 1),
    ('51749376042', '2012-09-04 00:00:00', '2015-06-03', 1),
    ('51768403032', '2010-01-28 00:00:00', '2014-01-31', 1),
    ('51768534091', '2011-02-08 00:00:00', '2012-01-10', 1),
    ('51779774017', '2013-03-18 00:00:00', '2013-04-18', 1),
    ('51786472043', '2010-08-17 00:00:00', '2011-08-17', 1),
    ('51829722081', '2012-08-29 00:00:00', '2012-09-28', 1),
    ('51829722081:001', '2012-02-29 00:00:00', '2012-03-29', 1),
    ('51833255078', '2013-02-05 00:00:00', '2013-03-06', 1),
    ('51834272072', '2014-04-08 00:00:00', '2015-05-11', 1),
    ('51837793074', '2010-06-25 00:00:00', '2013-08-27', 1),
    ('51837807023', '2015-10-06 00:00:00', '2017-02-08', 1),
    ('51843872003', '2014-10-22 00:00:00', '2015-01-23', 1),
    ('51850513078', '2010-06-15 00:00:00', '2011-12-14', 1),
    ('51853722080', '2015-04-24 00:00:00', NULL, 1),
    ('51871914032', '2010-05-20 00:00:00', '2015-07-22', 1),
    ('51887362093', '2010-03-10 00:00:00', '2011-06-17', 1),
    ('51904133063:001', '2010-04-13 00:00:00', '2010-06-11', 1),
    ('51908104045', '2010-03-11 00:00:00', '2011-10-11', 1),
    ('51950073064', '2010-05-14 00:00:00', '2011-01-14', 1),
    ('51951883032', '2010-05-03 00:00:00', NULL, 1),
    ('51963172044', '2010-02-05 00:00:00', '2011-02-08', 1),
    ('5197059005', '2015-03-24 00:00:00', NULL, 3),
    ('51998503064', '2014-02-05 00:00:00', '2015-02-05', 1),
    ('5222105003:001', '2011-12-05 00:00:00', '2012-01-05', 3),
    ('5313048006', '2013-12-17 00:00:00', '2014-01-31', 3),
    ('5313048006:001', '2011-06-21 00:00:00', '2013-04-17', 3),
    ('5399059016:001', '2011-12-30 00:00:00', '2012-11-19', 3),
    ('5407886001:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('5450114016', '2015-07-14 00:00:00', NULL, 3),
    ('5467554002:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('5540080005', '2010-09-07 00:00:00', '2016-02-08', 3),
    ('5593471003:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('5662866001:001', '2010-08-09 00:00:00', '2012-11-02', 3),
    ('5700074009', '2011-02-15 00:00:00', '2015-04-14', 3),
    ('5720074005', '2011-01-19 00:00:00', '2015-04-16', 3),
    ('5740074001', '2011-02-15 00:00:00', '2015-04-14', 3),
    ('5760074007', '2011-02-15 00:00:00', '2015-04-14', 3),
    ('57632310025', '2010-01-21 00:00:00', '2010-01-21', 1),
    ('6027028044', '2015-01-09 00:00:00', NULL, 3),
    ('6027028044:001', '2013-06-10 00:00:00', '2014-10-09', 3),
    ('6246448006:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('6352824005:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('6379301001:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('6396383007:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('6485546009:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('6487945000:001', '2010-08-03 00:00:00', '2009-11-03', 34),
    ('6573317009:001', '2010-08-03 00:00:00', '2009-11-03', 3),
    ('6595292001:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('6680099009', '2011-06-08 00:00:00', NULL, 3),
    ('6757856005:001', '2010-08-03 00:00:00', '2009-11-03', 3),
    ('6767748001:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('6900088008:001', '2010-08-23 00:00:00', '2010-08-23', 3),
    ('6900088008:002', '2011-03-23 00:00:00', '2011-03-23', 3),
    ('6946920007:001', '2010-08-03 00:00:00', '2009-11-03', 3),
    ('6982438000:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('7021084003:001', '2011-06-03 00:00:00', '2012-11-29', 3),
    ('7028019004:001', '2011-05-13 00:00:00', '2011-05-13', 3),
    ('7080036001:001', '2010-07-29 00:00:00', NULL, 3),
    ('7267313009:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('7293983004', '2010-09-27 00:00:00', '2015-07-23', 3),
    ('7302829006:001', '2010-08-03 00:00:00', NULL, 3),
    ('7357840000:001', '2010-08-03 00:00:00', NULL, 3),
    ('7369402001:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('7410304001:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('7421764004:001', '2012-10-29 00:00:00', NULL, 3),
    ('7488294003:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('7540291000:001', '2011-05-03 00:00:00', '2011-05-03', 3),
    ('7561277000:001', '2010-08-03 00:00:00', NULL, 3),
    ('7657286002:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('7700048001', '2013-04-10 00:00:00', '2013-11-08', 3),
    ('7702839000:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('7761137050', '2012-12-31 00:00:00', '2013-02-28', 3),
    ('7800751005:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('7829376004:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('7900068007:001', '2011-06-02 00:00:00', '2011-08-02', 3),
    ('8060078013', '2014-01-08 00:00:00', NULL, 3),
    ('8060078013:001', '2012-08-02 00:00:00', '2013-05-03', 3),
    ('8189328003:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('8205553008:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('8225135006:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('8260152009:001', '2011-10-17 00:00:00', '2011-10-17', 3),
    ('8275347001', '2012-12-18 00:00:00', '2013-10-18', 3),
    ('8320099007:001', '2011-12-28 00:00:00', '2012-02-23', 3),
    ('8320164009', '2015-02-03 00:00:00', NULL, 3),
    ('8320164009:001', '2010-08-09 00:00:00', '2013-11-04', 3),
    ('8325786005:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('8380152007', '2012-09-13 00:00:00', NULL, 3),
    ('8380152007:001', '2011-07-19 00:00:00', '2011-07-19', 3),
    ('8400106012', '2012-12-28 00:00:00', '2015-08-28', 39),
    ('8517728002:001', '2010-08-03 00:00:00', '2012-10-29', 39),
    ('8557194008:001', '2010-08-03 00:00:00', '2012-10-29', 39),
    ('8599120026:001', '2011-05-31 00:00:00', '2011-12-30', 39),
    ('8705173000:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('8720103004:001', '2010-08-04 00:00:00', '2012-10-01', 3),
    ('8723676004:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('8857864001:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('8888020011', '2014-09-10 00:00:00', NULL, 3),
    ('8895642009:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('8909648002:001', '2010-08-03 00:00:00', NULL, 3),
    ('8937684009:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('8960080020', '2013-05-16 00:00:00', '2016-12-14', 3),
    ('8974024030', '2010-06-23 00:00:00', '2013-09-23', 3),
    ('8991045006', '2011-01-18 00:00:00', '2013-07-19', 3),
    ('9033821009:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('9045138000:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('9109725009:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('9245153001:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('9349739009:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('9391885009:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('9405249004:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('9415029005:001', '2010-07-26 00:00:00', '2011-01-24', 3),
    ('9415029005:002', '2011-01-24 00:00:00', NULL, 3),
    ('9429385007:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('9445239000:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('9497631007:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('9519342001:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('9522152002:001', '2010-08-03 00:00:00', NULL, 3),
    ('9578992005:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('9605977007:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('9617673005:001', '2010-08-03 00:00:00', NULL, 3),
    ('9625289008:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('9627951007:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('9642457000:001', '2010-08-03 00:00:00', NULL, 4),
    ('9693152009:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('9693157004:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('9701153003:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('9719718009:001', '2010-08-03 00:00:00', '2013-04-30', 3),
    ('9738840008:001', '2010-08-03 00:00:00', NULL, 3),
    ('9757935004:001', '2010-08-03 00:00:00', '2012-10-29', 4),
    ('9759178007:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('9814291005:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('9832270004:001', '2010-08-03 00:00:00', NULL, 3),
    ('9837264006:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('9845161005:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('9862592004:001', '2010-08-03 00:00:00', '2012-10-29', 4),
    ('9864237006:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('9867645000:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('9876134001:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('9877635007:001', '2010-08-23 00:00:00', '2012-10-18', 3),
    ('9901184002:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('9909160004:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('9939163004:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('9945170006:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('9973204008:001', '2010-08-03 00:00:00', '2012-10-29', 3),
    ('9993163008:001', '2010-08-03 00:00:00', '2012-10-29', 3)
;

CREATE TABLE SYS_Calendar
    ([Date] datetime, [is_weekday] int
     , [is_holiday] int
     , [is_start_DST] int
     , [is_end_DST] int
     , [is_DST] int
     , [isLastDayOfMonth] int
     , [ActiveClientCount] int not null default 0)
;
    
    
INSERT INTO SYS_Calendar
    ([Date], [is_weekday], [is_holiday], [is_start_DST], [is_end_DST], [is_DST], [isLastDayOfMonth])
VALUES
    ('2015-01-01 00:00:00', 1, 1, 0, 0, 0, 0),
    ('2015-01-02 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-01-03 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-01-04 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-01-05 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-01-06 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-01-07 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-01-08 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-01-09 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-01-10 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-01-11 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-01-12 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-01-13 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-01-14 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-01-15 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-01-16 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-01-17 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-01-18 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-01-19 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-01-20 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-01-21 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-01-22 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-01-23 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-01-24 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-01-25 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-01-26 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-01-27 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-01-28 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-01-29 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-01-30 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-01-31 00:00:00', 0, 0, 0, 0, 0, 1),
    ('2015-02-01 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-02-02 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-02-03 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-02-04 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-02-05 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-02-06 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-02-07 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-02-08 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-02-09 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-02-10 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-02-11 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-02-12 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-02-13 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-02-14 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-02-15 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-02-16 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-02-17 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-02-18 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-02-19 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-02-20 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-02-21 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-02-22 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-02-23 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-02-24 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-02-25 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-02-26 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-02-27 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-02-28 00:00:00', 0, 0, 0, 0, 0, 1),
    ('2015-03-01 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-03-02 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-03-03 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-03-04 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-03-05 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-03-06 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-03-07 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-03-08 00:00:00', 0, 0, 1, 0, 1, 0),
    ('2015-03-09 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-03-10 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-03-11 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-03-12 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-03-13 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-03-14 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-03-15 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-03-16 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-03-17 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-03-18 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-03-19 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-03-20 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-03-21 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-03-22 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-03-23 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-03-24 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-03-25 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-03-26 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-03-27 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-03-28 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-03-29 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-03-30 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-03-31 00:00:00', 1, 0, 0, 0, 1, 1),
    ('2015-04-01 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-04-02 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-04-03 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-04-04 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-04-05 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-04-06 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-04-07 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-04-08 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-04-09 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-04-10 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-04-11 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-04-12 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-04-13 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-04-14 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-04-15 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-04-16 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-04-17 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-04-18 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-04-19 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-04-20 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-04-21 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-04-22 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-04-23 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-04-24 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-04-25 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-04-26 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-04-27 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-04-28 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-04-29 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-04-30 00:00:00', 1, 0, 0, 0, 1, 1),
    ('2015-05-01 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-05-02 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-05-03 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-05-04 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-05-05 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-05-06 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-05-07 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-05-08 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-05-09 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-05-10 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-05-11 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-05-12 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-05-13 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-05-14 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-05-15 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-05-16 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-05-17 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-05-18 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-05-19 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-05-20 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-05-21 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-05-22 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-05-23 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-05-24 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-05-25 00:00:00', 1, 1, 0, 0, 1, 0),
    ('2015-05-26 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-05-27 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-05-28 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-05-29 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-05-30 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-05-31 00:00:00', 0, 0, 0, 0, 1, 1),
    ('2015-06-01 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-06-02 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-06-03 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-06-04 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-06-05 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-06-06 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-06-07 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-06-08 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-06-09 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-06-10 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-06-11 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-06-12 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-06-13 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-06-14 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-06-15 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-06-16 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-06-17 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-06-18 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-06-19 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-06-20 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-06-21 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-06-22 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-06-23 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-06-24 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-06-25 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-06-26 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-06-27 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-06-28 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-06-29 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-06-30 00:00:00', 1, 0, 0, 0, 1, 1),
    ('2015-07-01 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-07-02 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-07-03 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-07-04 00:00:00', 0, 1, 0, 0, 1, 0),
    ('2015-07-05 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-07-06 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-07-07 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-07-08 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-07-09 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-07-10 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-07-11 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-07-12 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-07-13 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-07-14 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-07-15 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-07-16 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-07-17 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-07-18 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-07-19 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-07-20 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-07-21 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-07-22 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-07-23 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-07-24 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-07-25 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-07-26 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-07-27 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-07-28 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-07-29 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-07-30 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-07-31 00:00:00', 1, 0, 0, 0, 1, 1),
    ('2015-08-01 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-08-02 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-08-03 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-08-04 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-08-05 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-08-06 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-08-07 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-08-08 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-08-09 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-08-10 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-08-11 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-08-12 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-08-13 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-08-14 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-08-15 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-08-16 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-08-17 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-08-18 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-08-19 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-08-20 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-08-21 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-08-22 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-08-23 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-08-24 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-08-25 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-08-26 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-08-27 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-08-28 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-08-29 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-08-30 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-08-31 00:00:00', 1, 0, 0, 0, 1, 1),
    ('2015-09-01 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-09-02 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-09-03 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-09-04 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-09-05 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-09-06 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-09-07 00:00:00', 1, 1, 0, 0, 1, 0),
    ('2015-09-08 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-09-09 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-09-10 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-09-11 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-09-12 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-09-13 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-09-14 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-09-15 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-09-16 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-09-17 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-09-18 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-09-19 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-09-20 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-09-21 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-09-22 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-09-23 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-09-24 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-09-25 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-09-26 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-09-27 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-09-28 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-09-29 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-09-30 00:00:00', 1, 0, 0, 0, 1, 1),
    ('2015-10-01 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-10-02 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-10-03 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-10-04 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-10-05 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-10-06 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-10-07 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-10-08 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-10-09 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-10-10 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-10-11 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-10-12 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-10-13 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-10-14 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-10-15 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-10-16 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-10-17 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-10-18 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-10-19 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-10-20 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-10-21 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-10-22 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-10-23 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-10-24 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-10-25 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2015-10-26 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-10-27 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-10-28 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-10-29 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-10-30 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2015-10-31 00:00:00', 0, 0, 0, 0, 1, 1),
    ('2015-11-01 00:00:00', 0, 0, 0, 1, 0, 0),
    ('2015-11-02 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-11-03 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-11-04 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-11-05 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-11-06 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-11-07 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-11-08 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-11-09 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-11-10 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-11-11 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-11-12 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-11-13 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-11-14 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-11-15 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-11-16 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-11-17 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-11-18 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-11-19 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-11-20 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-11-21 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-11-22 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-11-23 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-11-24 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-11-25 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-11-26 00:00:00', 1, 1, 0, 0, 0, 0),
    ('2015-11-27 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-11-28 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-11-29 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-11-30 00:00:00', 1, 0, 0, 0, 0, 1),
    ('2015-12-01 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-12-02 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-12-03 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-12-04 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-12-05 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-12-06 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-12-07 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-12-08 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-12-09 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-12-10 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-12-11 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-12-12 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-12-13 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-12-14 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-12-15 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-12-16 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-12-17 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-12-18 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-12-19 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-12-20 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-12-21 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-12-22 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-12-23 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-12-24 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-12-25 00:00:00', 1, 1, 0, 0, 0, 0),
    ('2015-12-26 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-12-27 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2015-12-28 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-12-29 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-12-30 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2015-12-31 00:00:00', 1, 0, 0, 0, 0, 1),
    ('2016-01-01 00:00:00', 1, 1, 0, 0, 0, 0),
    ('2016-01-02 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-01-03 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-01-04 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-01-05 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-01-06 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-01-07 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-01-08 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-01-09 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-01-10 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-01-11 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-01-12 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-01-13 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-01-14 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-01-15 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-01-16 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-01-17 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-01-18 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-01-19 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-01-20 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-01-21 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-01-22 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-01-23 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-01-24 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-01-25 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-01-26 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-01-27 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-01-28 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-01-29 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-01-30 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-01-31 00:00:00', 0, 0, 0, 0, 0, 1),
    ('2016-02-01 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-02-02 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-02-03 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-02-04 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-02-05 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-02-06 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-02-07 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-02-08 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-02-09 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-02-10 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-02-11 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-02-12 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-02-13 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-02-14 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-02-15 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-02-16 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-02-17 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-02-18 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-02-19 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-02-20 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-02-21 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-02-22 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-02-23 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-02-24 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-02-25 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-02-26 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-02-27 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-02-28 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-02-29 00:00:00', 1, 0, 0, 0, 0, 1),
    ('2016-03-01 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-03-02 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-03-03 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-03-04 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-03-05 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-03-06 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-03-07 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-03-08 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-03-09 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-03-10 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-03-11 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-03-12 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-03-13 00:00:00', 0, 0, 1, 0, 1, 0),
    ('2016-03-14 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-03-15 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-03-16 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-03-17 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-03-18 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-03-19 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-03-20 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-03-21 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-03-22 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-03-23 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-03-24 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-03-25 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-03-26 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-03-27 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-03-28 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-03-29 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-03-30 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-03-31 00:00:00', 1, 0, 0, 0, 1, 1),
    ('2016-04-01 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-04-02 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-04-03 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-04-04 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-04-05 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-04-06 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-04-07 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-04-08 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-04-09 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-04-10 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-04-11 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-04-12 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-04-13 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-04-14 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-04-15 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-04-16 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-04-17 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-04-18 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-04-19 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-04-20 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-04-21 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-04-22 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-04-23 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-04-24 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-04-25 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-04-26 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-04-27 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-04-28 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-04-29 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-04-30 00:00:00', 0, 0, 0, 0, 1, 1),
    ('2016-05-01 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-05-02 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-05-03 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-05-04 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-05-05 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-05-06 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-05-07 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-05-08 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-05-09 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-05-10 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-05-11 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-05-12 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-05-13 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-05-14 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-05-15 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-05-16 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-05-17 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-05-18 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-05-19 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-05-20 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-05-21 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-05-22 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-05-23 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-05-24 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-05-25 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-05-26 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-05-27 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-05-28 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-05-29 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-05-30 00:00:00', 1, 1, 0, 0, 1, 0),
    ('2016-05-31 00:00:00', 1, 0, 0, 0, 1, 1),
    ('2016-06-01 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-06-02 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-06-03 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-06-04 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-06-05 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-06-06 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-06-07 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-06-08 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-06-09 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-06-10 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-06-11 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-06-12 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-06-13 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-06-14 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-06-15 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-06-16 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-06-17 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-06-18 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-06-19 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-06-20 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-06-21 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-06-22 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-06-23 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-06-24 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-06-25 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-06-26 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-06-27 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-06-28 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-06-29 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-06-30 00:00:00', 1, 0, 0, 0, 1, 1),
    ('2016-07-01 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-07-02 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-07-03 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-07-04 00:00:00', 1, 1, 0, 0, 1, 0),
    ('2016-07-05 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-07-06 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-07-07 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-07-08 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-07-09 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-07-10 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-07-11 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-07-12 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-07-13 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-07-14 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-07-15 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-07-16 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-07-17 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-07-18 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-07-19 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-07-20 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-07-21 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-07-22 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-07-23 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-07-24 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-07-25 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-07-26 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-07-27 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-07-28 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-07-29 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-07-30 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-07-31 00:00:00', 0, 0, 0, 0, 1, 1),
    ('2016-08-01 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-08-02 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-08-03 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-08-04 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-08-05 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-08-06 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-08-07 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-08-08 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-08-09 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-08-10 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-08-11 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-08-12 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-08-13 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-08-14 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-08-15 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-08-16 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-08-17 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-08-18 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-08-19 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-08-20 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-08-21 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-08-22 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-08-23 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-08-24 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-08-25 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-08-26 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-08-27 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-08-28 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-08-29 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-08-30 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-08-31 00:00:00', 1, 0, 0, 0, 1, 1),
    ('2016-09-01 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-09-02 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-09-03 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-09-04 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-09-05 00:00:00', 1, 1, 0, 0, 1, 0),
    ('2016-09-06 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-09-07 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-09-08 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-09-09 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-09-10 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-09-11 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-09-12 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-09-13 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-09-14 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-09-15 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-09-16 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-09-17 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-09-18 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-09-19 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-09-20 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-09-21 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-09-22 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-09-23 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-09-24 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-09-25 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-09-26 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-09-27 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-09-28 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-09-29 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-09-30 00:00:00', 1, 0, 0, 0, 1, 1),
    ('2016-10-01 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-10-02 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-10-03 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-10-04 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-10-05 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-10-06 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-10-07 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-10-08 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-10-09 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-10-10 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-10-11 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-10-12 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-10-13 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-10-14 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-10-15 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-10-16 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-10-17 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-10-18 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-10-19 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-10-20 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-10-21 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-10-22 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-10-23 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-10-24 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-10-25 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-10-26 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-10-27 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-10-28 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-10-29 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-10-30 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-10-31 00:00:00', 1, 0, 0, 0, 1, 1),
    ('2016-11-01 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-11-02 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-11-03 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-11-04 00:00:00', 1, 0, 0, 0, 1, 0),
    ('2016-11-05 00:00:00', 0, 0, 0, 0, 1, 0),
    ('2016-11-06 00:00:00', 0, 0, 0, 1, 0, 0),
    ('2016-11-07 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-11-08 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-11-09 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-11-10 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-11-11 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-11-12 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-11-13 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-11-14 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-11-15 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-11-16 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-11-17 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-11-18 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-11-19 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-11-20 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-11-21 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-11-22 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-11-23 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-11-24 00:00:00', 1, 1, 0, 0, 0, 0),
    ('2016-11-25 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-11-26 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-11-27 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-11-28 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-11-29 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-11-30 00:00:00', 1, 0, 0, 0, 0, 1),
    ('2016-12-01 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-12-02 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-12-03 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-12-04 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-12-05 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-12-06 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-12-07 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-12-08 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-12-09 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-12-10 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-12-11 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-12-12 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-12-13 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-12-14 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-12-15 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-12-16 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-12-17 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-12-18 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-12-19 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-12-20 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-12-21 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-12-22 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-12-23 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-12-24 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-12-25 00:00:00', 0, 0, 0, 0, 0, 0),
    ('2016-12-26 00:00:00', 1, 1, 0, 0, 0, 0),
    ('2016-12-27 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-12-28 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-12-29 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-12-30 00:00:00', 1, 0, 0, 0, 0, 0),
    ('2016-12-31 00:00:00', 0, 0, 0, 0, 0, 1)
;

declare @start_date datetime = '20150101'
declare @end_date   datetime = '20151231'

UPDATE c
SET c.ActiveClientCount = d.n
FROM sys_calendar AS c
INNER JOIN (
      SELECT
            sc.[Date]
          , COUNT(*) n
      FROM ACCESS_30DayMeterForecast AS a
      INNER JOIN sys_calendar AS sc ON sc.[date] between @start_date and @end_date
                                   AND sc.[Date] BETWEEN a.ServiceStartDate AND ISNULL(a.DropDate, @end_date)
      GROUP BY sc.[Date]
      ) d 
      ON c.[date] = d.[date]
;
set @start_date  = '20160101'
set @end_date    = '20161231'

select
*
from sys_calendar

View schema
Execution time: 0,75 sec, rows selected: 735, rows affected: 1741, absolute service time: 1,31 sec