Analytics - Dynamically sized windows

View All Scripts Login to Run Script

Script Name Analytics - Dynamically sized windows
Description SQL from the KISS (Keep It Simply SQL) Analytic video series by Developer Advocate Connor McDonald. This script is using a PL/SQL function to create dynamic window range. Run this script standalone, or take it as part of the complete Analytics class at https://tinyurl.com/devgym-classes
Area SQL General / Analytics
Contributor Connor Mcdonald (Oracle)
Created Wednesday March 02, 2016

Statement 1

select time_id,
       sum(amount_sold) sold_per_day
from   sh.sales
group by time_Id
order by 1

 
TIME_ID SOLD_PER_DAY
01-JAN-98 15406.48
02-JAN-98 19333.41
03-JAN-98 34392.76
04-JAN-98 32013.28
05-JAN-98 128209.37
06-JAN-98 4148.08
07-JAN-98 52989.75
08-JAN-98 22838.89
09-JAN-98 20505.11
10-JAN-98 184725.56
11-JAN-98 24447.6
12-JAN-98 18892.83
13-JAN-98 47167.5
14-JAN-98 61861.84
15-JAN-98 32219.21
16-JAN-98 66683.08
17-JAN-98 163200.92
18-JAN-98 48634.88
19-JAN-98 41098.56
20-JAN-98 165815.62
21-JAN-98 176753.72
22-JAN-98 35093.09
23-JAN-98 98600.5
24-JAN-98 69804.93
25-JAN-98 292245.55
26-JAN-98 52385.12
27-JAN-98 32567.51
28-JAN-98 65685.36
29-JAN-98 26461.46
30-JAN-98 211146.38
31-JAN-98 32092.14
01-FEB-98 24595.76
02-FEB-98 53343.42
03-FEB-98 81648.3
04-FEB-98 45890.55
05-FEB-98 207727.11
06-FEB-98 3936.26
07-FEB-98 57914.9
08-FEB-98 33786.91
09-FEB-98 27514.69
10-FEB-98 108853.69
11-FEB-98 14624.57
12-FEB-98 24099.49
13-FEB-98 58244.25
14-FEB-98 162758.41
15-FEB-98 59415.79
16-FEB-98 198969.66
17-FEB-98 168979.26
18-FEB-98 12390.93
19-FEB-98 33967.25
20-FEB-98 124016.14
21-FEB-98 226841.41
22-FEB-98 22374.97
23-FEB-98 78615.39
24-FEB-98 30027.93
25-FEB-98 366505.29
26-FEB-98 86852.88
27-FEB-98 23164.1
28-FEB-98 35631.56
01-MAR-98 17796.02
02-MAR-98 26108.66
03-MAR-98 32316.28
04-MAR-98 38153.63
05-MAR-98 148067.97
06-MAR-98 5472.51
07-MAR-98 65727.77
08-MAR-98 15761.82
09-MAR-98 21343.79
10-MAR-98 151571.01
11-MAR-98 26477.13
12-MAR-98 23446.55
13-MAR-98 34174.27
14-MAR-98 69668.94
15-MAR-98 30391.13
16-MAR-98 90300.2
17-MAR-98 107757.04
18-MAR-98 30605.34
19-MAR-98 35268.09
20-MAR-98 147000.97
21-MAR-98 129238.75
22-MAR-98 23121.43
23-MAR-98 121614.45
24-MAR-98 31120.9
25-MAR-98 75027.62
26-MAR-98 46987.02
27-MAR-98 94301.63
28-MAR-98 27978.07
29-MAR-98 9457.33
30-MAR-98 60110.16
31-MAR-98 94206.16
01-APR-98 16019.06
02-APR-98 31975.5
03-APR-98 44358.5
04-APR-98 49451.01
05-APR-98 238830.45
06-APR-98 15194.77
07-APR-98 37554.93
08-APR-98 21686.61
09-APR-98 28038.99
10-APR-98 119375.76
11-APR-98 19600.29
12-APR-98 9289.91
13-APR-98 36465.31
14-APR-98 59980.09
15-APR-98 17476.48
16-APR-98 129667.53
17-APR-98 135307.55
18-APR-98 18777.02
19-APR-98 17864.05
20-APR-98 181846.37
21-APR-98 102053.24
22-APR-98 36387.77
23-APR-98 129465.52
24-APR-98 14632.89
25-APR-98 21677.3
26-APR-98 213986.56
27-APR-98 86039.97
28-APR-98 26093.72
29-APR-98 17584.96
30-APR-98 99296.19
01-MAY-98 11996.05
02-MAY-98 25852.07
03-MAY-98 27383.99
04-MAY-98 29042.55
05-MAY-98 161547.57
06-MAY-98 3955.39
07-MAY-98 65427.09
08-MAY-98 13080.32
09-MAY-98 20185.82
10-MAY-98 154229.8
11-MAY-98 22814.47
12-MAY-98 18203.89
13-MAY-98 35072.87
14-MAY-98 78333.47
15-MAY-98 29469.62
16-MAY-98 95654.01
17-MAY-98 108922.2
18-MAY-98 29570.11
19-MAY-98 23742.88
20-MAY-98 157036.6
21-MAY-98 132652.85
22-MAY-98 15297.72
23-MAY-98 105449.52
24-MAY-98 28240.57
25-MAY-98 71027.41
26-MAY-98 44584.99
27-MAY-98 106440.66
28-MAY-98 29699.19
29-MAY-98 10633.88
30-MAY-98 40809.3
31-MAY-98 51930.37
01-JUN-98 16687.92
02-JUN-98 28520.68
03-JUN-98 47312.38
04-JUN-98 47990.55
05-JUN-98 245971.38
06-JUN-98 14928.16
07-JUN-98 32751.36
08-JUN-98 32863.62
09-JUN-98 26387.2
10-JUN-98 112761.67
11-JUN-98 20816.48
12-JUN-98 8913.29
13-JUN-98 34682.77
14-JUN-98 56467.55
15-JUN-98 19376.1
16-JUN-98 124266.15
17-JUN-98 112243.99
18-JUN-98 16566.25
19-JUN-98 16697.41
20-JUN-98 164508.06
21-JUN-98 108089.95
22-JUN-98 38127.32
23-JUN-98 124522.14
24-JUN-98 10356.98
25-JUN-98 21799.93
26-JUN-98 205025.12
27-JUN-98 86132.91
28-JUN-98 32755.92
29-JUN-98 21131.38
30-JUN-98 41073.99
01-JUL-98 16722.24
02-JUL-98 34402.58
03-JUL-98 41614.25
04-JUL-98 32302.64
05-JUL-98 109625.32
06-JUL-98 2050.98
07-JUL-98 72474.7
08-JUL-98 31333.1
09-JUL-98 15242.39
10-JUL-98 172897.55
11-JUL-98 25265.2
12-JUL-98 15488.19
13-JUL-98 67616.26
14-JUL-98 65248.62
15-JUL-98 22828.89
16-JUL-98 72605.66
17-JUL-98 133646.55
18-JUL-98 63859.53
19-JUL-98 45111.67
20-JUL-98 169575.97
21-JUL-98 154040.77
22-JUL-98 15586.98
23-JUL-98 61475.16
24-JUL-98 58360.5
25-JUL-98 87427.99
26-JUL-98 44588.81
27-JUL-98 99494.1
28-JUL-98 73843.05
29-JUL-98 16518.56
30-JUL-98 100465.5
31-JUL-98 10568.57
01-AUG-98 7378.6
02-AUG-98 28467.75
03-AUG-98 60644.16
04-AUG-98 38839.76
05-AUG-98 97468.27
06-AUG-98 2550.92
07-AUG-98 65835.15
08-AUG-98 30587.71
09-AUG-98 18717.01
10-AUG-98 167948.64
11-AUG-98 29675.18
12-AUG-98 18000.8
13-AUG-98 66180.64
14-AUG-98 71579.48
15-AUG-98 27761.62
16-AUG-98 81713.1
17-AUG-98 151449
18-AUG-98 67214.96
19-AUG-98 47766.87
20-AUG-98 178556.8
21-AUG-98 189687.29
22-AUG-98 17046.28
23-AUG-98 82011.3
24-AUG-98 57304.96
25-AUG-98 87527.76
26-AUG-98 39705.91
27-AUG-98 94653.59
28-AUG-98 71791.27
29-AUG-98 11399.89
30-AUG-98 23569.52
31-AUG-98 39498.44
01-SEP-98 30335.44
02-SEP-98 42840.94
03-SEP-98 51799.39
04-SEP-98 38879.52
05-SEP-98 163244.05
06-SEP-98 19680.52
07-SEP-98 63049.41
08-SEP-98 19085.89
09-SEP-98 32424.89
10-SEP-98 133727.28
11-SEP-98 27008.09
12-SEP-98 38135.09
13-SEP-98 34387.77
14-SEP-98 105767.88
15-SEP-98 35398.53
16-SEP-98 141615.73
17-SEP-98 115628.16
18-SEP-98 18378.8
19-SEP-98 63590.63
20-SEP-98 251239.08
21-SEP-98 176540.13
22-SEP-98 41064.17
23-SEP-98 155061.31
24-SEP-98 14315.2
25-SEP-98 24728.33
26-SEP-98 142644.86
27-SEP-98 97702.66
28-SEP-98 44797.17
29-SEP-98 28117.97
30-SEP-98 15819.3
01-OCT-98 6994.47
02-OCT-98 29935.27
03-OCT-98 60108.63
04-OCT-98 41288.51
05-OCT-98 87672.03
06-OCT-98 3853.13
07-OCT-98 44565.42
08-OCT-98 25579.69
09-OCT-98 18299.91
10-OCT-98 179364.17
11-OCT-98 28157.8
12-OCT-98 22242.74
13-OCT-98 57482.43
14-OCT-98 110980.4
15-OCT-98 30011.12
16-OCT-98 81223.52
17-OCT-98 158634.21
18-OCT-98 77556.88
19-OCT-98 84685.55
20-OCT-98 190446.42
21-OCT-98 227484.22
22-OCT-98 20438.98
23-OCT-98 70924.8
24-OCT-98 68274.02
25-OCT-98 106291.3
26-OCT-98 45886.96
27-OCT-98 114987.98
28-OCT-98 98790.92
29-OCT-98 13676.79
30-OCT-98 25631.93
31-OCT-98 104994.33
01-NOV-98 21189.3
02-NOV-98 19511.81
03-NOV-98 70979.61
04-NOV-98 29820.69
05-NOV-98 137086.15
06-NOV-98 19063.47
07-NOV-98 42697.78
08-NOV-98 16685.21
09-NOV-98 23884.48
10-NOV-98 136865.53
11-NOV-98 18541.17
12-NOV-98 23310.4
13-NOV-98 25723.61
14-NOV-98 66890.2
15-NOV-98 25648.75
16-NOV-98 116166.54
17-NOV-98 102586.2
18-NOV-98 11690.94
19-NOV-98 50633.85
20-NOV-98 239815.78
21-NOV-98 182480.44
22-NOV-98 34956.74
23-NOV-98 117530.49
24-NOV-98 8187.54
25-NOV-98 24268.16
26-NOV-98 152560.55
27-NOV-98 101498.51
28-NOV-98 43358.89
29-NOV-98 29772.93
30-NOV-98 66258.5
01-DEC-98 5554.06
02-DEC-98 23818.74
03-DEC-98 24020.26
04-DEC-98 34443.7
05-DEC-98 65767.16
06-DEC-98 3205.63
07-DEC-98 49670.66
08-DEC-98 14988.63
09-DEC-98 9087.65
10-DEC-98 113359.8
11-DEC-98 18273.26
12-DEC-98 14191.45
13-DEC-98 43063.37
14-DEC-98 31900.61
15-DEC-98 22264.54
16-DEC-98 54722.71
17-DEC-98 90229.66
18-DEC-98 38034.76
19-DEC-98 43915.31
20-DEC-98 113349.22
21-DEC-98 146521.97
22-DEC-98 105209.19
23-DEC-98 40602.61
24-DEC-98 99660.24
25-DEC-98 78910.94
26-DEC-98 39077.32
27-DEC-98 65161.69
28-DEC-98 101412.74
29-DEC-98 65673.06
30-DEC-98 78103.41
31-DEC-98 107090.61
01-JAN-99 5561.92
02-JAN-99 11555.55
03-JAN-99 12867.65
04-JAN-99 18612.62
05-JAN-99 9025.09
06-JAN-99 5613.88
07-JAN-99 65427.47
08-JAN-99 22668.1
09-JAN-99 14095.63
10-JAN-99 246413.63
11-JAN-99 16415.93
12-JAN-99 21642.11
13-JAN-99 64963.31
14-JAN-99 74365.9
15-JAN-99 25210.92
16-JAN-99 76674.23
17-JAN-99 96432.69
18-JAN-99 58412.32
19-JAN-99 23993.01
20-JAN-99 221249.58
21-JAN-99 178747.55
22-JAN-99 23427.36
23-JAN-99 81688.35
24-JAN-99 47177.33
25-JAN-99 103324.91
26-JAN-99 28883.46
27-JAN-99 42223.31
28-JAN-99 53755.79
29-JAN-99 36530.11
30-JAN-99 327679.41
31-JAN-99 62800.64
01-FEB-99 11406.48
02-FEB-99 29445.26
03-FEB-99 60835.79
04-FEB-99 40568.09
05-FEB-99 52595.59
06-FEB-99 2571.4
07-FEB-99 74136.72
08-FEB-99 54040.11
09-FEB-99 20106.83
10-FEB-99 151636.98
11-FEB-99 12209.69
12-FEB-99 29910.76
13-FEB-99 83550.9
14-FEB-99 56629.88
15-FEB-99 69100.8
16-FEB-99 73484.65
17-FEB-99 194978.52
18-FEB-99 31588.15
19-FEB-99 37544.07
20-FEB-99 115009
21-FEB-99 369570.6
22-FEB-99 61214.83
23-FEB-99 60202.25
24-FEB-99 46915.17
25-FEB-99 386915.94
26-FEB-99 90033.32
27-FEB-99 75611.54
28-FEB-99 65815.94
01-MAR-99 13240.75
02-MAR-99 23578.16
03-MAR-99 27169.57
04-MAR-99 23654.12
05-MAR-99 5281.25
06-MAR-99 2874.08
07-MAR-99 75559
08-MAR-99 27957.98
09-MAR-99 15859.52
10-MAR-99 222850.93
11-MAR-99 17077.05
12-MAR-99 19747.32
13-MAR-99 58590.15
14-MAR-99 48516.14
15-MAR-99 21497.12
16-MAR-99 58495.89
17-MAR-99 72178.42
18-MAR-99 58413.32
19-MAR-99 37072.85
20-MAR-99 222413.23
21-MAR-99 194940.69
22-MAR-99 10485.48
23-MAR-99 71618.27
24-MAR-99 48301.9
25-MAR-99 95578.78
26-MAR-99 33908.92
27-MAR-99 29125.15
28-MAR-99 38039.13
29-MAR-99 7162.89
30-MAR-99 43684.47
31-MAR-99 33805.66
01-APR-99 24194.85
02-APR-99 9356.59
03-APR-99 56352.45
04-APR-99 21200.21
05-APR-99 9064.19
06-APR-99 31983.24
07-APR-99 53829.85
08-APR-99 18721.62
09-APR-99 21024.14
10-APR-99 132606.69
11-APR-99 15883.59
12-APR-99 21327.77
13-APR-99 19269.39
14-APR-99 60201.42
15-APR-99 24568.58
16-APR-99 69256.71
17-APR-99 93196.08
18-APR-99 9008.28
19-APR-99 42759.96
20-APR-99 224570.2
21-APR-99 186362.51
22-APR-99 43552.11
23-APR-99 126699.38
24-APR-99 9688.38
25-APR-99 21490.32
26-APR-99 125789.72
27-APR-99 45066.63
28-APR-99 15029.64
29-APR-99 26208.18
30-APR-99 15009.98
01-MAY-99 4785.3
02-MAY-99 18319.68
03-MAY-99 50737.48
04-MAY-99 31525.39
05-MAY-99 5321.9
06-MAY-99 11059.09
07-MAY-99 64452.89
08-MAY-99 22126.25
09-MAY-99 8677.48
10-MAY-99 209791.47
11-MAY-99 11786.65
12-MAY-99 15849.78
13-MAY-99 64957.05
14-MAY-99 35245.3
15-MAY-99 25002.5
16-MAY-99 42451.13
17-MAY-99 87040.78
18-MAY-99 54570.96
19-MAY-99 33050.36
20-MAY-99 228963.95
21-MAY-99 211703.08
22-MAY-99 19877.78
23-MAY-99 104138.02
24-MAY-99 46742.77
25-MAY-99 110702.08
26-MAY-99 59677.64
27-MAY-99 24816.43
28-MAY-99 36080.19
29-MAY-99 8642.97
30-MAY-99 24465.89
31-MAY-99 39165.63
01-JUN-99 31875.38
02-JUN-99 11332.39
03-JUN-99 65197.12
04-JUN-99 22285.45
05-JUN-99 10643.37
06-JUN-99 30839.84
07-JUN-99 53227.65
08-JUN-99 19560.22
09-JUN-99 20747.35
10-JUN-99 132615.42
11-JUN-99 13211.19
12-JUN-99 22878.84
13-JUN-99 19912.69
14-JUN-99 58389.89
15-JUN-99 25081.07
16-JUN-99 66225.04
17-JUN-99 103570.44
18-JUN-99 10389.35
19-JUN-99 43821.64
20-JUN-99 240523.05
21-JUN-99 175228.87
22-JUN-99 40467.02
23-JUN-99 131129.24
24-JUN-99 10431.02
25-JUN-99 23483.59
26-JUN-99 147841.46
27-JUN-99 45057.4
28-JUN-99 18639.04
29-JUN-99 30354.16
30-JUN-99 15511.91
01-JUL-99 11954.62
02-JUL-99 25848.35
03-JUL-99 40664.45
04-JUL-99 40640.36
05-JUL-99 6798.59
06-JUL-99 2155.22
07-JUL-99 61526.81
08-JUL-99 29799
09-JUL-99 6884.41
10-JUL-99 202219.14
11-JUL-99 12090.17
12-JUL-99 15287.29
13-JUL-99 65093
14-JUL-99 31156.74
15-JUL-99 36613.27
16-JUL-99 49162.27
17-JUL-99 160673.23
18-JUL-99 67408.2
19-JUL-99 38364.25
20-JUL-99 234654.27
21-JUL-99 218569.03
22-JUL-99 8958.39
23-JUL-99 91307.04
24-JUL-99 74559.78
25-JUL-99 135625.12
26-JUL-99 23610.95
27-JUL-99 28448.49
28-JUL-99 58826.99
29-JUL-99 9826.26
30-JUL-99 95023.25
31-JUL-99 7466.63
01-AUG-99 2188.48
02-AUG-99 22361.25
03-AUG-99 44792.54
04-AUG-99 36427
05-AUG-99 7097.89
06-AUG-99 2215.83
07-AUG-99 73878.31
08-AUG-99 28790.46
09-AUG-99 6409.85
10-AUG-99 202129.97
11-AUG-99 11828.11
12-AUG-99 13431.62
13-AUG-99 62420.29
14-AUG-99 35127.23
15-AUG-99 39878.15
16-AUG-99 44479.16
17-AUG-99 208360.44
18-AUG-99 67127.84
19-AUG-99 44307.79
20-AUG-99 233215.06
21-AUG-99 220564.07
22-AUG-99 9362.67
23-AUG-99 84048.62
24-AUG-99 77037.48
25-AUG-99 135939.5
26-AUG-99 24766.22
27-AUG-99 30955.84
28-AUG-99 67467.12
29-AUG-99 10488.79
30-AUG-99 16652.98
31-AUG-99 41166.05
01-SEP-99 37013.06
02-SEP-99 15732.47
03-SEP-99 99474.59
04-SEP-99 36753.75
05-SEP-99 2156.41
06-SEP-99 37102.3
07-SEP-99 71657.56
08-SEP-99 17641.37
09-SEP-99 31010.56
10-SEP-99 132190.43
11-SEP-99 12443.24
12-SEP-99 53395.13
13-SEP-99 19645.61
14-SEP-99 62783.46
15-SEP-99 22270.86
16-SEP-99 85863.31
17-SEP-99 263394.9
18-SEP-99 8605.05
19-SEP-99 101150.75
20-SEP-99 231909.58
21-SEP-99 186672.09
22-SEP-99 44119.39
23-SEP-99 193860.5
24-SEP-99 9303.66
25-SEP-99 24253.13
26-SEP-99 100876.02
27-SEP-99 59002.14
28-SEP-99 11582.68
29-SEP-99 41930.17
30-SEP-99 17123.8
01-OCT-99 3798.27
02-OCT-99 24714.9
03-OCT-99 21639.76
04-OCT-99 34789.1
05-OCT-99 4871.28
06-OCT-99 1793.04
07-OCT-99 57372.09
08-OCT-99 29076.45
09-OCT-99 8760.5
10-OCT-99 204908.54
11-OCT-99 12536.82
12-OCT-99 14435.74
13-OCT-99 64299.64
14-OCT-99 31143.32
15-OCT-99 32818.38
16-OCT-99 41234.43
17-OCT-99 153722.44
18-OCT-99 69420.05
19-OCT-99 22592.73
20-OCT-99 229176.83
21-OCT-99 209768.26
22-OCT-99 7480.42
23-OCT-99 76169.94
24-OCT-99 67758.46
25-OCT-99 112696.78
26-OCT-99 17846.39
27-OCT-99 32902.45
28-OCT-99 70296
29-OCT-99 7512.1
30-OCT-99 16122.44
31-OCT-99 40957.93
01-NOV-99 35645.32
02-NOV-99 17223.27
03-NOV-99 52267.03
04-NOV-99 25933.32
05-NOV-99 3018.9
06-NOV-99 29376.77
07-NOV-99 63950.63
08-NOV-99 20265.21
09-NOV-99 31415.26
10-NOV-99 149099.62
11-NOV-99 12735.85
12-NOV-99 39109.16
13-NOV-99 17771.77
14-NOV-99 55611.03
15-NOV-99 16270.6
16-NOV-99 86880.08
17-NOV-99 183625.95
18-NOV-99 10584.65
19-NOV-99 70357.58
20-NOV-99 235751.62
21-NOV-99 155517.08
22-NOV-99 35884.77
23-NOV-99 141212.07
24-NOV-99 7125.35
25-NOV-99 22265.45
26-NOV-99 73513.69
27-NOV-99 59088.55
28-NOV-99 14232.9
29-NOV-99 35583.6
30-NOV-99 17815.1
01-DEC-99 9808.18
02-DEC-99 20775.34
03-DEC-99 36231.88
04-DEC-99 39904.65
05-DEC-99 3016.52
06-DEC-99 7465.56
07-DEC-99 85450.9
08-DEC-99 38390.35
09-DEC-99 10528.23
10-DEC-99 119814.46
11-DEC-99 22323.75
12-DEC-99 7523.37
13-DEC-99 48755.17
14-DEC-99 47992.05
15-DEC-99 32448.35
16-DEC-99 75475.92
17-DEC-99 143068.51
18-DEC-99 142340.97
19-DEC-99 22958.59
20-DEC-99 134336.84
21-DEC-99 79015.02
22-DEC-99 94264.28
23-DEC-99 82745.96
24-DEC-99 102956.68
25-DEC-99 63107.46
26-DEC-99 95122.51
27-DEC-99 65870.25
28-DEC-99 113910.65
29-DEC-99 10251.59
30-DEC-99 106554.35
31-DEC-99 69522.67
01-JAN-00 1773.74
02-JAN-00 24778.16
03-JAN-00 40605.5
04-JAN-00 29957.97
05-JAN-00 4760.24
06-JAN-00 1704.16
07-JAN-00 69144.65
08-JAN-00 27957.61
09-JAN-00 9960.59
10-JAN-00 220599.08
11-JAN-00 16820.83
12-JAN-00 13195.88
13-JAN-00 60949.6
14-JAN-00 53145.6
15-JAN-00 28261.64
16-JAN-00 60894.15
17-JAN-00 167538.28
18-JAN-00 69038.61
19-JAN-00 20716.12
20-JAN-00 102289.9
21-JAN-00 259372.14
22-JAN-00 8606.74
23-JAN-00 57443.62
24-JAN-00 71150.16
25-JAN-00 131778.09
26-JAN-00 16155.67
27-JAN-00 37082.65
28-JAN-00 64243.2
29-JAN-00 16349.16
30-JAN-00 283619.77
31-JAN-00 36484.95
01-FEB-00 1701.24
02-FEB-00 20900.39
03-FEB-00 82138.61
04-FEB-00 36111.9
05-FEB-00 29261.97
06-FEB-00 1720.36
07-FEB-00 65053.81
08-FEB-00 37011.88
09-FEB-00 18810.94
10-FEB-00 94830.26
11-FEB-00 32514.72
12-FEB-00 25536.97
13-FEB-00 50632.89
14-FEB-00 153395.96
15-FEB-00 84902.14
16-FEB-00 107117.18
17-FEB-00 153610
18-FEB-00 54990.71
19-FEB-00 24682.3
20-FEB-00 3238.67
21-FEB-00 382824.56
22-FEB-00 9736.54
23-FEB-00 16107.65
24-FEB-00 44229.54
25-FEB-00 435720.53
26-FEB-00 62720.41
27-FEB-00 36468.61
28-FEB-00 16408.75
29-FEB-00 36239.48
01-MAR-00 26101.89
02-MAR-00 12125.25
03-MAR-00 44662.97
04-MAR-00 28002.07
05-MAR-00 1805.94
06-MAR-00 22105.44
07-MAR-00 63949.8
08-MAR-00 19235.6
09-MAR-00 24750.87
10-MAR-00 143936.04
11-MAR-00 15954.1
12-MAR-00 21665.98
13-MAR-00 23872.87
14-MAR-00 111036.07
15-MAR-00 14244.83
16-MAR-00 129737.78
17-MAR-00 94163.69
18-MAR-00 13588.38
19-MAR-00 45478.21
20-MAR-00 39819.78
21-MAR-00 203715.82
22-MAR-00 29603.61
23-MAR-00 198581.39
24-MAR-00 8716.58
25-MAR-00 16306.31
26-MAR-00 103487.81
27-MAR-00 54646.73
28-MAR-00 16403.03
29-MAR-00 4955.46
30-MAR-00 262276.84
31-MAR-00 64960.92
01-APR-00 5962.47
02-APR-00 53492.48
03-APR-00 68204.2
04-APR-00 1877.85
05-APR-00 24634.26
06-APR-00 25491.59
07-APR-00 37856.88
08-APR-00 49557
09-APR-00 11005.69
10-APR-00 183491.43
11-APR-00 32108.45
12-APR-00 9339.1
13-APR-00 66279.67
14-APR-00 32642.47
15-APR-00 30194.39
16-APR-00 182577.9
17-APR-00 107814.99
18-APR-00 60453.53
19-APR-00 15130.07
20-APR-00 34840.49
21-APR-00 75338.96
22-APR-00 53871.88
23-APR-00 66519.39
24-APR-00 9124.91
25-APR-00 125674.76
26-APR-00 180836.17
27-APR-00 6028.1
28-APR-00 53485.53
29-APR-00 5014.53
30-APR-00 156660.98
01-MAY-00 28556.09
02-MAY-00 8935.4
03-MAY-00 51639.67
04-MAY-00 28651.38
05-MAY-00 1955.98
06-MAY-00 21900.86
07-MAY-00 67746.73
08-MAY-00 24881.99
09-MAY-00 24734.88
10-MAY-00 173366.31
11-MAY-00 14818.1
12-MAY-00 22545.49
13-MAY-00 20775.67
14-MAY-00 63494.5
15-MAY-00 14161.45
16-MAY-00 75787.4
17-MAY-00 104881.34
18-MAY-00 13275.25
19-MAY-00 48365.07
20-MAY-00 27747.02
21-MAY-00 234479.72
22-MAY-00 29586.15
23-MAY-00 229827.73
24-MAY-00 8495.77
25-MAY-00 17220.64
26-MAY-00 88209.1
27-MAY-00 55569.05
28-MAY-00 20439.04
29-MAY-00 5373.35
30-MAY-00 274743.1
31-MAY-00 72328.62
01-JUN-00 6358.42
02-JUN-00 50656.15
03-JUN-00 61987.97
04-JUN-00 1821.39
05-JUN-00 26125.67
06-JUN-00 25796.06
07-JUN-00 39606.48
08-JUN-00 49028.36
09-JUN-00 11628.85
10-JUN-00 181161.27
11-JUN-00 33186.69
12-JUN-00 9125.7
13-JUN-00 68664.27
14-JUN-00 38157.56
15-JUN-00 30228.03
16-JUN-00 151484
17-JUN-00 97348.98
18-JUN-00 63149.54
19-JUN-00 14679.23
20-JUN-00 29528.53
21-JUN-00 84932.46
22-JUN-00 56253.22
23-JUN-00 68871.35
24-JUN-00 9472.67
25-JUN-00 125513.41
26-JUN-00 175629.86
27-JUN-00 6362.82
28-JUN-00 47308.13
29-JUN-00 5126.75
30-JUN-00 162534.13
01-JUL-00 25165.44
02-JUL-00 47380.23
03-JUL-00 38238.91
04-JUL-00 26070.37
05-JUL-00 1803.66
06-JUL-00 28204.52
07-JUL-00 91769.36
08-JUL-00 34529.59
09-JUL-00 23061.25
10-JUL-00 203478.86
11-JUL-00 11387.38
12-JUL-00 29498.91
13-JUL-00 76167.46
14-JUL-00 26500.7
15-JUL-00 13887.08
16-JUL-00 62066.39
17-JUL-00 231154.67
18-JUL-00 8118.9
19-JUL-00 61471.38
20-JUL-00 71580.71
21-JUL-00 228469.99
22-JUL-00 27363.61
23-JUL-00 198709.37
24-JUL-00 6039.35
25-JUL-00 25939.43
26-JUL-00 56114.5
27-JUL-00 53715.08
28-JUL-00 101468.15
29-JUL-00 26853.32
30-JUL-00 58751.29
31-JUL-00 1802.96
01-AUG-00 27953.34
02-AUG-00 42954.6
03-AUG-00 27473.75
04-AUG-00 27931.37
05-AUG-00 3586.41
06-AUG-00 20847.51
07-AUG-00 102914.02
08-AUG-00 36223.25
09-AUG-00 27272.53
10-AUG-00 210117.12
11-AUG-00 12337.17
12-AUG-00 28191.67
13-AUG-00 65381.23
14-AUG-00 30342.62
15-AUG-00 14500.31
16-AUG-00 71837.74
17-AUG-00 163443.19
18-AUG-00 10751.5
19-AUG-00 57128.74
20-AUG-00 79931.09
21-AUG-00 212340.09
22-AUG-00 31557.23
23-AUG-00 220431.14
24-AUG-00 6810.28
25-AUG-00 33948.9
26-AUG-00 71625.73
27-AUG-00 54350.37
28-AUG-00 91471.68
29-AUG-00 11918.82
30-AUG-00 256338.72
31-AUG-00 60343.67
01-SEP-00 12473.51
02-SEP-00 32097.26
03-SEP-00 56777.89
04-SEP-00 2360.25
05-SEP-00 24134.13
06-SEP-00 27225.41
07-SEP-00 82244.4
08-SEP-00 63682.67
09-SEP-00 27594.49
10-SEP-00 206911.48
11-SEP-00 29846.55
12-SEP-00 52402.39
13-SEP-00 48003.23
14-SEP-00 105674.71
15-SEP-00 35909.05
16-SEP-00 170342.61
17-SEP-00 192536.09
18-SEP-00 56366.62
19-SEP-00 81719.79
20-SEP-00 43893.15
21-SEP-00 76775.44
22-SEP-00 62806.96
23-SEP-00 160084.8
24-SEP-00 15848.21
25-SEP-00 116165.93
26-SEP-00 133581.59

Rows 1 - 1000. More rows exist.

TIME_ID	SOLD_PER_DAY
01-JAN-98	15406.48
02-JAN-98	19333.41
03-JAN-98	34392.76
04-JAN-98	32013.28
05-JAN-98	128209.37
06-JAN-98	4148.08
07-JAN-98	52989.75
08-JAN-98	22838.89
09-JAN-98	20505.11
10-JAN-98	184725.56
11-JAN-98	24447.6
12-JAN-98	18892.83
13-JAN-98	47167.5
14-JAN-98	61861.84
15-JAN-98	32219.21
16-JAN-98	66683.08
17-JAN-98	163200.92
18-JAN-98	48634.88
19-JAN-98	41098.56
20-JAN-98	165815.62
21-JAN-98	176753.72
22-JAN-98	35093.09
23-JAN-98	98600.5
24-JAN-98	69804.93
25-JAN-98	292245.55
26-JAN-98	52385.12
27-JAN-98	32567.51
28-JAN-98	65685.36
29-JAN-98	26461.46
30-JAN-98	211146.38
31-JAN-98	32092.14
01-FEB-98	24595.76
02-FEB-98	53343.42
03-FEB-98	81648.3
04-FEB-98	45890.55
05-FEB-98	207727.11
06-FEB-98	3936.26
07-FEB-98	57914.9
08-FEB-98	33786.91
09-FEB-98	27514.69
10-FEB-98	108853.69
11-FEB-98	14624.57
12-FEB-98	24099.49
13-FEB-98	58244.25
14-FEB-98	162758.41
15-FEB-98	59415.79
16-FEB-98	198969.66
17-FEB-98	168979.26
18-FEB-98	12390.93
19-FEB-98	33967.25
20-FEB-98	124016.14
21-FEB-98	226841.41
22-FEB-98	22374.97
23-FEB-98	78615.39
24-FEB-98	30027.93
25-FEB-98	366505.29
26-FEB-98	86852.88
27-FEB-98	23164.1
28-FEB-98	35631.56
01-MAR-98	17796.02
02-MAR-98	26108.66
03-MAR-98	32316.28
04-MAR-98	38153.63
05-MAR-98	148067.97
06-MAR-98	5472.51
07-MAR-98	65727.77
08-MAR-98	15761.82
09-MAR-98	21343.79
10-MAR-98	151571.01
11-MAR-98	26477.13
12-MAR-98	23446.55
13-MAR-98	34174.27
14-MAR-98	69668.94
15-MAR-98	30391.13
16-MAR-98	90300.2
17-MAR-98	107757.04
18-MAR-98	30605.34
19-MAR-98	35268.09
20-MAR-98	147000.97
21-MAR-98	129238.75
22-MAR-98	23121.43
23-MAR-98	121614.45
24-MAR-98	31120.9
25-MAR-98	75027.62
26-MAR-98	46987.02
27-MAR-98	94301.63
28-MAR-98	27978.07
29-MAR-98	9457.33
30-MAR-98	60110.16
31-MAR-98	94206.16
01-APR-98	16019.06
02-APR-98	31975.5
03-APR-98	44358.5
04-APR-98	49451.01
05-APR-98	238830.45
06-APR-98	15194.77
07-APR-98	37554.93
08-APR-98	21686.61
09-APR-98	28038.99
10-APR-98	119375.76
11-APR-98	19600.29
12-APR-98	9289.91
13-APR-98	36465.31
14-APR-98	59980.09
15-APR-98	17476.48
16-APR-98	129667.53
17-APR-98	135307.55
18-APR-98	18777.02
19-APR-98	17864.05
20-APR-98	181846.37
21-APR-98	102053.24
22-APR-98	36387.77
23-APR-98	129465.52
24-APR-98	14632.89
25-APR-98	21677.3
26-APR-98	213986.56
27-APR-98	86039.97
28-APR-98	26093.72
29-APR-98	17584.96
30-APR-98	99296.19
01-MAY-98	11996.05
02-MAY-98	25852.07
03-MAY-98	27383.99
04-MAY-98	29042.55
05-MAY-98	161547.57
06-MAY-98	3955.39
07-MAY-98	65427.09
08-MAY-98	13080.32
09-MAY-98	20185.82
10-MAY-98	154229.8
11-MAY-98	22814.47
12-MAY-98	18203.89
13-MAY-98	35072.87
14-MAY-98	78333.47
15-MAY-98	29469.62
16-MAY-98	95654.01
17-MAY-98	108922.2
18-MAY-98	29570.11
19-MAY-98	23742.88
20-MAY-98	157036.6
21-MAY-98	132652.85
22-MAY-98	15297.72
23-MAY-98	105449.52
24-MAY-98	28240.57
25-MAY-98	71027.41
26-MAY-98	44584.99
27-MAY-98	106440.66
28-MAY-98	29699.19
29-MAY-98	10633.88
30-MAY-98	40809.3
31-MAY-98	51930.37
01-JUN-98	16687.92
02-JUN-98	28520.68
03-JUN-98	47312.38
04-JUN-98	47990.55
05-JUN-98	245971.38
06-JUN-98	14928.16
07-JUN-98	32751.36
08-JUN-98	32863.62
09-JUN-98	26387.2
10-JUN-98	112761.67
11-JUN-98	20816.48
12-JUN-98	8913.29
13-JUN-98	34682.77
14-JUN-98	56467.55
15-JUN-98	19376.1
16-JUN-98	124266.15
17-JUN-98	112243.99
18-JUN-98	16566.25
19-JUN-98	16697.41
20-JUN-98	164508.06
21-JUN-98	108089.95
22-JUN-98	38127.32
23-JUN-98	124522.14
24-JUN-98	10356.98
25-JUN-98	21799.93
26-JUN-98	205025.12
27-JUN-98	86132.91
28-JUN-98	32755.92
29-JUN-98	21131.38
30-JUN-98	41073.99
01-JUL-98	16722.24
02-JUL-98	34402.58
03-JUL-98	41614.25
04-JUL-98	32302.64
05-JUL-98	109625.32
06-JUL-98	2050.98
07-JUL-98	72474.7
08-JUL-98	31333.1
09-JUL-98	15242.39
10-JUL-98	172897.55
11-JUL-98	25265.2
12-JUL-98	15488.19
13-JUL-98	67616.26
14-JUL-98	65248.62
15-JUL-98	22828.89
16-JUL-98	72605.66
17-JUL-98	133646.55
18-JUL-98	63859.53
19-JUL-98	45111.67
20-JUL-98	169575.97
21-JUL-98	154040.77
22-JUL-98	15586.98
23-JUL-98	61475.16
24-JUL-98	58360.5
25-JUL-98	87427.99
26-JUL-98	44588.81
27-JUL-98	99494.1
28-JUL-98	73843.05
29-JUL-98	16518.56
30-JUL-98	100465.5
31-JUL-98	10568.57
01-AUG-98	7378.6
02-AUG-98	28467.75
03-AUG-98	60644.16
04-AUG-98	38839.76
05-AUG-98	97468.27
06-AUG-98	2550.92
07-AUG-98	65835.15
08-AUG-98	30587.71
09-AUG-98	18717.01
10-AUG-98	167948.64
11-AUG-98	29675.18
12-AUG-98	18000.8
13-AUG-98	66180.64
14-AUG-98	71579.48
15-AUG-98	27761.62
16-AUG-98	81713.1
17-AUG-98	151449
18-AUG-98	67214.96
19-AUG-98	47766.87
20-AUG-98	178556.8
21-AUG-98	189687.29
22-AUG-98	17046.28
23-AUG-98	82011.3
24-AUG-98	57304.96
25-AUG-98	87527.76
26-AUG-98	39705.91
27-AUG-98	94653.59
28-AUG-98	71791.27
29-AUG-98	11399.89
30-AUG-98	23569.52
31-AUG-98	39498.44
01-SEP-98	30335.44
02-SEP-98	42840.94
03-SEP-98	51799.39
04-SEP-98	38879.52
05-SEP-98	163244.05
06-SEP-98	19680.52
07-SEP-98	63049.41
08-SEP-98	19085.89
09-SEP-98	32424.89
10-SEP-98	133727.28
11-SEP-98	27008.09
12-SEP-98	38135.09
13-SEP-98	34387.77
14-SEP-98	105767.88
15-SEP-98	35398.53
16-SEP-98	141615.73
17-SEP-98	115628.16
18-SEP-98	18378.8
19-SEP-98	63590.63
20-SEP-98	251239.08
21-SEP-98	176540.13
22-SEP-98	41064.17
23-SEP-98	155061.31
24-SEP-98	14315.2
25-SEP-98	24728.33
26-SEP-98	142644.86
27-SEP-98	97702.66
28-SEP-98	44797.17
29-SEP-98	28117.97
30-SEP-98	15819.3
01-OCT-98	6994.47
02-OCT-98	29935.27
03-OCT-98	60108.63
04-OCT-98	41288.51
05-OCT-98	87672.03
06-OCT-98	3853.13
07-OCT-98	44565.42
08-OCT-98	25579.69
09-OCT-98	18299.91
10-OCT-98	179364.17
11-OCT-98	28157.8
12-OCT-98	22242.74
13-OCT-98	57482.43
14-OCT-98	110980.4
15-OCT-98	30011.12
16-OCT-98	81223.52
17-OCT-98	158634.21
18-OCT-98	77556.88
19-OCT-98	84685.55
20-OCT-98	190446.42
21-OCT-98	227484.22
22-OCT-98	20438.98
23-OCT-98	70924.8
24-OCT-98	68274.02
25-OCT-98	106291.3
26-OCT-98	45886.96
27-OCT-98	114987.98
28-OCT-98	98790.92
29-OCT-98	13676.79
30-OCT-98	25631.93
31-OCT-98	104994.33
01-NOV-98	21189.3
02-NOV-98	19511.81
03-NOV-98	70979.61
04-NOV-98	29820.69
05-NOV-98	137086.15
06-NOV-98	19063.47
07-NOV-98	42697.78
08-NOV-98	16685.21
09-NOV-98	23884.48
10-NOV-98	136865.53
11-NOV-98	18541.17
12-NOV-98	23310.4
13-NOV-98	25723.61
14-NOV-98	66890.2
15-NOV-98	25648.75
16-NOV-98	116166.54
17-NOV-98	102586.2
18-NOV-98	11690.94
19-NOV-98	50633.85
20-NOV-98	239815.78
21-NOV-98	182480.44
22-NOV-98	34956.74
23-NOV-98	117530.49
24-NOV-98	8187.54
25-NOV-98	24268.16
26-NOV-98	152560.55
27-NOV-98	101498.51
28-NOV-98	43358.89
29-NOV-98	29772.93
30-NOV-98	66258.5
01-DEC-98	5554.06
02-DEC-98	23818.74
03-DEC-98	24020.26
04-DEC-98	34443.7
05-DEC-98	65767.16
06-DEC-98	3205.63
07-DEC-98	49670.66
08-DEC-98	14988.63
09-DEC-98	9087.65
10-DEC-98	113359.8
11-DEC-98	18273.26
12-DEC-98	14191.45
13-DEC-98	43063.37
14-DEC-98	31900.61
15-DEC-98	22264.54
16-DEC-98	54722.71
17-DEC-98	90229.66
18-DEC-98	38034.76
19-DEC-98	43915.31
20-DEC-98	113349.22
21-DEC-98	146521.97
22-DEC-98	105209.19
23-DEC-98	40602.61
24-DEC-98	99660.24
25-DEC-98	78910.94
26-DEC-98	39077.32
27-DEC-98	65161.69
28-DEC-98	101412.74
29-DEC-98	65673.06
30-DEC-98	78103.41
31-DEC-98	107090.61
01-JAN-99	5561.92
02-JAN-99	11555.55
03-JAN-99	12867.65
04-JAN-99	18612.62
05-JAN-99	9025.09
06-JAN-99	5613.88
07-JAN-99	65427.47
08-JAN-99	22668.1
09-JAN-99	14095.63
10-JAN-99	246413.63
11-JAN-99	16415.93
12-JAN-99	21642.11
13-JAN-99	64963.31
14-JAN-99	74365.9
15-JAN-99	25210.92
16-JAN-99	76674.23
17-JAN-99	96432.69
18-JAN-99	58412.32
19-JAN-99	23993.01
20-JAN-99	221249.58
21-JAN-99	178747.55
22-JAN-99	23427.36
23-JAN-99	81688.35
24-JAN-99	47177.33
25-JAN-99	103324.91
26-JAN-99	28883.46
27-JAN-99	42223.31
28-JAN-99	53755.79
29-JAN-99	36530.11
30-JAN-99	327679.41
31-JAN-99	62800.64
01-FEB-99	11406.48
02-FEB-99	29445.26
03-FEB-99	60835.79
04-FEB-99	40568.09
05-FEB-99	52595.59
06-FEB-99	2571.4
07-FEB-99	74136.72
08-FEB-99	54040.11
09-FEB-99	20106.83
10-FEB-99	151636.98
11-FEB-99	12209.69
12-FEB-99	29910.76
13-FEB-99	83550.9
14-FEB-99	56629.88
15-FEB-99	69100.8
16-FEB-99	73484.65
17-FEB-99	194978.52
18-FEB-99	31588.15
19-FEB-99	37544.07
20-FEB-99	115009
21-FEB-99	369570.6
22-FEB-99	61214.83
23-FEB-99	60202.25
24-FEB-99	46915.17
25-FEB-99	386915.94
26-FEB-99	90033.32
27-FEB-99	75611.54
28-FEB-99	65815.94
01-MAR-99	13240.75
02-MAR-99	23578.16
03-MAR-99	27169.57
04-MAR-99	23654.12
05-MAR-99	5281.25
06-MAR-99	2874.08
07-MAR-99	75559
08-MAR-99	27957.98
09-MAR-99	15859.52
10-MAR-99	222850.93
11-MAR-99	17077.05
12-MAR-99	19747.32
13-MAR-99	58590.15
14-MAR-99	48516.14
15-MAR-99	21497.12
16-MAR-99	58495.89
17-MAR-99	72178.42
18-MAR-99	58413.32
19-MAR-99	37072.85
20-MAR-99	222413.23
21-MAR-99	194940.69
22-MAR-99	10485.48
23-MAR-99	71618.27
24-MAR-99	48301.9
25-MAR-99	95578.78
26-MAR-99	33908.92
27-MAR-99	29125.15
28-MAR-99	38039.13
29-MAR-99	7162.89
30-MAR-99	43684.47
31-MAR-99	33805.66
01-APR-99	24194.85
02-APR-99	9356.59
03-APR-99	56352.45
04-APR-99	21200.21
05-APR-99	9064.19
06-APR-99	31983.24
07-APR-99	53829.85
08-APR-99	18721.62
09-APR-99	21024.14
10-APR-99	132606.69
11-APR-99	15883.59
12-APR-99	21327.77
13-APR-99	19269.39
14-APR-99	60201.42
15-APR-99	24568.58
16-APR-99	69256.71
17-APR-99	93196.08
18-APR-99	9008.28
19-APR-99	42759.96
20-APR-99	224570.2
21-APR-99	186362.51
22-APR-99	43552.11
23-APR-99	126699.38
24-APR-99	9688.38
25-APR-99	21490.32
26-APR-99	125789.72
27-APR-99	45066.63
28-APR-99	15029.64
29-APR-99	26208.18
30-APR-99	15009.98
01-MAY-99	4785.3
02-MAY-99	18319.68
03-MAY-99	50737.48
04-MAY-99	31525.39
05-MAY-99	5321.9
06-MAY-99	11059.09
07-MAY-99	64452.89
08-MAY-99	22126.25
09-MAY-99	8677.48
10-MAY-99	209791.47
11-MAY-99	11786.65
12-MAY-99	15849.78
13-MAY-99	64957.05
14-MAY-99	35245.3
15-MAY-99	25002.5

Statement 2

create or replace
function LAST_CLOSE(p_close_date date)
return number is
begin
  return
    case to_char(p_close_date,'DY')
     when 'SUN' then 2
     when 'MON' then 3
     else 1
    end;
end;

Statement processed.

Statement 3

select
  time_id,
  to_char(time_id,'DY') close_day,
  sum(sold_per_day) 
    over ( 
      order by time_id 
      range between LAST_CLOSE(time_id) preceding and 0 following) as close_off
from ( 
  select time_id,
         sum(amount_sold) sold_per_day
  from   sh.sales
  group by time_Id
  )

 
TIME_ID CLOSE_DAY CLOSE_OFF
01-JAN-98 THU 15406.48
02-JAN-98 FRI 34739.89
03-JAN-98 SAT 53726.17
04-JAN-98 SUN 85739.45
05-JAN-98 MON 213948.82
06-JAN-98 TUE 132357.45
07-JAN-98 WED 57137.83
08-JAN-98 THU 75828.64
09-JAN-98 FRI 43344
10-JAN-98 SAT 205230.67
11-JAN-98 SUN 229678.27
12-JAN-98 MON 248571.1
13-JAN-98 TUE 66060.33
14-JAN-98 WED 109029.34
15-JAN-98 THU 94081.05
16-JAN-98 FRI 98902.29
17-JAN-98 SAT 229884
18-JAN-98 SUN 278518.88
19-JAN-98 MON 319617.44
20-JAN-98 TUE 206914.18
21-JAN-98 WED 342569.34
22-JAN-98 THU 211846.81
23-JAN-98 FRI 133693.59
24-JAN-98 SAT 168405.43
25-JAN-98 SUN 460650.98
26-JAN-98 MON 513036.1
27-JAN-98 TUE 84952.63
28-JAN-98 WED 98252.87
29-JAN-98 THU 92146.82
30-JAN-98 FRI 237607.84
31-JAN-98 SAT 243238.52
01-FEB-98 SUN 267834.28
02-FEB-98 MON 321177.7
03-FEB-98 TUE 134991.72
04-FEB-98 WED 127538.85
05-FEB-98 THU 253617.66
06-FEB-98 FRI 211663.37
07-FEB-98 SAT 61851.16
08-FEB-98 SUN 95638.07
09-FEB-98 MON 123152.76
10-FEB-98 TUE 136368.38
11-FEB-98 WED 123478.26
12-FEB-98 THU 38724.06
13-FEB-98 FRI 82343.74
14-FEB-98 SAT 221002.66
15-FEB-98 SUN 280418.45
16-FEB-98 MON 479388.11
17-FEB-98 TUE 367948.92
18-FEB-98 WED 181370.19
19-FEB-98 THU 46358.18
20-FEB-98 FRI 157983.39
21-FEB-98 SAT 350857.55
22-FEB-98 SUN 373232.52
23-FEB-98 MON 451847.91
24-FEB-98 TUE 108643.32
25-FEB-98 WED 396533.22
26-FEB-98 THU 453358.17
27-FEB-98 FRI 110016.98
28-FEB-98 SAT 58795.66
01-MAR-98 SUN 76591.68
02-MAR-98 MON 102700.34
03-MAR-98 TUE 58424.94
04-MAR-98 WED 70469.91
05-MAR-98 THU 186221.6
06-MAR-98 FRI 153540.48
07-MAR-98 SAT 71200.28
08-MAR-98 SUN 86962.1
09-MAR-98 MON 108305.89
10-MAR-98 TUE 172914.8
11-MAR-98 WED 178048.14
12-MAR-98 THU 49923.68
13-MAR-98 FRI 57620.82
14-MAR-98 SAT 103843.21
15-MAR-98 SUN 134234.34
16-MAR-98 MON 224534.54
17-MAR-98 TUE 198057.24
18-MAR-98 WED 138362.38
19-MAR-98 THU 65873.43
20-MAR-98 FRI 182269.06
21-MAR-98 SAT 276239.72
22-MAR-98 SUN 299361.15
23-MAR-98 MON 420975.6
24-MAR-98 TUE 152735.35
25-MAR-98 WED 106148.52
26-MAR-98 THU 122014.64
27-MAR-98 FRI 141288.65
28-MAR-98 SAT 122279.7
29-MAR-98 SUN 131737.03
30-MAR-98 MON 191847.19
31-MAR-98 TUE 154316.32
01-APR-98 WED 110225.22
02-APR-98 THU 47994.56
03-APR-98 FRI 76334
04-APR-98 SAT 93809.51
05-APR-98 SUN 332639.96
06-APR-98 MON 347834.73
07-APR-98 TUE 52749.7
08-APR-98 WED 59241.54
09-APR-98 THU 49725.6
10-APR-98 FRI 147414.75
11-APR-98 SAT 138976.05
12-APR-98 SUN 148265.96
13-APR-98 MON 184731.27
14-APR-98 TUE 96445.4
15-APR-98 WED 77456.57
16-APR-98 THU 147144.01
17-APR-98 FRI 264975.08
18-APR-98 SAT 154084.57
19-APR-98 SUN 171948.62
20-APR-98 MON 353794.99
21-APR-98 TUE 283899.61
22-APR-98 WED 138441.01
23-APR-98 THU 165853.29
24-APR-98 FRI 144098.41
25-APR-98 SAT 36310.19
26-APR-98 SUN 250296.75
27-APR-98 MON 336336.72
28-APR-98 TUE 112133.69
29-APR-98 WED 43678.68
30-APR-98 THU 116881.15
01-MAY-98 FRI 111292.24
02-MAY-98 SAT 37848.12
03-MAY-98 SUN 65232.11
04-MAY-98 MON 94274.66
05-MAY-98 TUE 190590.12
06-MAY-98 WED 165502.96
07-MAY-98 THU 69382.48
08-MAY-98 FRI 78507.41
09-MAY-98 SAT 33266.14
10-MAY-98 SUN 187495.94
11-MAY-98 MON 210310.41
12-MAY-98 TUE 41018.36
13-MAY-98 WED 53276.76
14-MAY-98 THU 113406.34
15-MAY-98 FRI 107803.09
16-MAY-98 SAT 125123.63
17-MAY-98 SUN 234045.83
18-MAY-98 MON 263615.94
19-MAY-98 TUE 53312.99
20-MAY-98 WED 180779.48
21-MAY-98 THU 289689.45
22-MAY-98 FRI 147950.57
23-MAY-98 SAT 120747.24
24-MAY-98 SUN 148987.81
25-MAY-98 MON 220015.22
26-MAY-98 TUE 115612.4
27-MAY-98 WED 151025.65
28-MAY-98 THU 136139.85
29-MAY-98 FRI 40333.07
30-MAY-98 SAT 51443.18
31-MAY-98 SUN 103373.55
01-JUN-98 MON 120061.47
02-JUN-98 TUE 45208.6
03-JUN-98 WED 75833.06
04-JUN-98 THU 95302.93
05-JUN-98 FRI 293961.93
06-JUN-98 SAT 260899.54
07-JUN-98 SUN 293650.9
08-JUN-98 MON 326514.52
09-JUN-98 TUE 59250.82
10-JUN-98 WED 139148.87
11-JUN-98 THU 133578.15
12-JUN-98 FRI 29729.77
13-JUN-98 SAT 43596.06
14-JUN-98 SUN 100063.61
15-JUN-98 MON 119439.71
16-JUN-98 TUE 143642.25
17-JUN-98 WED 236510.14
18-JUN-98 THU 128810.24
19-JUN-98 FRI 33263.66
20-JUN-98 SAT 181205.47
21-JUN-98 SUN 289295.42
22-JUN-98 MON 327422.74
23-JUN-98 TUE 162649.46
24-JUN-98 WED 134879.12
25-JUN-98 THU 32156.91
26-JUN-98 FRI 226825.05
27-JUN-98 SAT 291158.03
28-JUN-98 SUN 323913.95
29-JUN-98 MON 345045.33
30-JUN-98 TUE 62205.37
01-JUL-98 WED 57796.23
02-JUL-98 THU 51124.82
03-JUL-98 FRI 76016.83
04-JUL-98 SAT 73916.89
05-JUL-98 SUN 183542.21
06-JUL-98 MON 185593.19
07-JUL-98 TUE 74525.68
08-JUL-98 WED 103807.8
09-JUL-98 THU 46575.49
10-JUL-98 FRI 188139.94
11-JUL-98 SAT 198162.75
12-JUL-98 SUN 213650.94
13-JUL-98 MON 281267.2
14-JUL-98 TUE 132864.88
15-JUL-98 WED 88077.51
16-JUL-98 THU 95434.55
17-JUL-98 FRI 206252.21
18-JUL-98 SAT 197506.08
19-JUL-98 SUN 242617.75
20-JUL-98 MON 412193.72
21-JUL-98 TUE 323616.74
22-JUL-98 WED 169627.75
23-JUL-98 THU 77062.14
24-JUL-98 FRI 119835.66
25-JUL-98 SAT 145788.49
26-JUL-98 SUN 190377.3
27-JUL-98 MON 289871.4
28-JUL-98 TUE 173337.15
29-JUL-98 WED 90361.61
30-JUL-98 THU 116984.06
31-JUL-98 FRI 111034.07
01-AUG-98 SAT 17947.17
02-AUG-98 SUN 46414.92
03-AUG-98 MON 107059.08
04-AUG-98 TUE 99483.92
05-AUG-98 WED 136308.03
06-AUG-98 THU 100019.19
07-AUG-98 FRI 68386.07
08-AUG-98 SAT 96422.86
09-AUG-98 SUN 115139.87
10-AUG-98 MON 283088.51
11-AUG-98 TUE 197623.82
12-AUG-98 WED 47675.98
13-AUG-98 THU 84181.44
14-AUG-98 FRI 137760.12
15-AUG-98 SAT 99341.1
16-AUG-98 SUN 181054.2
17-AUG-98 MON 332503.2
18-AUG-98 TUE 218663.96
19-AUG-98 WED 114981.83
20-AUG-98 THU 226323.67
21-AUG-98 FRI 368244.09
22-AUG-98 SAT 206733.57
23-AUG-98 SUN 288744.87
24-AUG-98 MON 346049.83
25-AUG-98 TUE 144832.72
26-AUG-98 WED 127233.67
27-AUG-98 THU 134359.5
28-AUG-98 FRI 166444.86
29-AUG-98 SAT 83191.16
30-AUG-98 SUN 106760.68
31-AUG-98 MON 146259.12
01-SEP-98 TUE 69833.88
02-SEP-98 WED 73176.38
03-SEP-98 THU 94640.33
04-SEP-98 FRI 90678.91
05-SEP-98 SAT 202123.57
06-SEP-98 SUN 221804.09
07-SEP-98 MON 284853.5
08-SEP-98 TUE 82135.3
09-SEP-98 WED 51510.78
10-SEP-98 THU 166152.17
11-SEP-98 FRI 160735.37
12-SEP-98 SAT 65143.18
13-SEP-98 SUN 99530.95
14-SEP-98 MON 205298.83
15-SEP-98 TUE 141166.41
16-SEP-98 WED 177014.26
17-SEP-98 THU 257243.89
18-SEP-98 FRI 134006.96
19-SEP-98 SAT 81969.43
20-SEP-98 SUN 333208.51
21-SEP-98 MON 509748.64
22-SEP-98 TUE 217604.3
23-SEP-98 WED 196125.48
24-SEP-98 THU 169376.51
25-SEP-98 FRI 39043.53
26-SEP-98 SAT 167373.19
27-SEP-98 SUN 265075.85
28-SEP-98 MON 309873.02
29-SEP-98 TUE 72915.14
30-SEP-98 WED 43937.27
01-OCT-98 THU 22813.77
02-OCT-98 FRI 36929.74
03-OCT-98 SAT 90043.9
04-OCT-98 SUN 131332.41
05-OCT-98 MON 219004.44
06-OCT-98 TUE 91525.16
07-OCT-98 WED 48418.55
08-OCT-98 THU 70145.11
09-OCT-98 FRI 43879.6
10-OCT-98 SAT 197664.08
11-OCT-98 SUN 225821.88
12-OCT-98 MON 248064.62
13-OCT-98 TUE 79725.17
14-OCT-98 WED 168462.83
15-OCT-98 THU 140991.52
16-OCT-98 FRI 111234.64
17-OCT-98 SAT 239857.73
18-OCT-98 SUN 317414.61
19-OCT-98 MON 402100.16
20-OCT-98 TUE 275131.97
21-OCT-98 WED 417930.64
22-OCT-98 THU 247923.2
23-OCT-98 FRI 91363.78
24-OCT-98 SAT 139198.82
25-OCT-98 SUN 245490.12
26-OCT-98 MON 291377.08
27-OCT-98 TUE 160874.94
28-OCT-98 WED 213778.9
29-OCT-98 THU 112467.71
30-OCT-98 FRI 39308.72
31-OCT-98 SAT 130626.26
01-NOV-98 SUN 151815.56
02-NOV-98 MON 171327.37
03-NOV-98 TUE 90491.42
04-NOV-98 WED 100800.3
05-NOV-98 THU 166906.84
06-NOV-98 FRI 156149.62
07-NOV-98 SAT 61761.25
08-NOV-98 SUN 78446.46
09-NOV-98 MON 102330.94
10-NOV-98 TUE 160750.01
11-NOV-98 WED 155406.7
12-NOV-98 THU 41851.57
13-NOV-98 FRI 49034.01
14-NOV-98 SAT 92613.81
15-NOV-98 SUN 118262.56
16-NOV-98 MON 234429.1
17-NOV-98 TUE 218752.74
18-NOV-98 WED 114277.14
19-NOV-98 THU 62324.79
20-NOV-98 FRI 290449.63
21-NOV-98 SAT 422296.22
22-NOV-98 SUN 457252.96
23-NOV-98 MON 574783.45
24-NOV-98 TUE 125718.03
25-NOV-98 WED 32455.7
26-NOV-98 THU 176828.71
27-NOV-98 FRI 254059.06
28-NOV-98 SAT 144857.4
29-NOV-98 SUN 174630.33
30-NOV-98 MON 240888.83
01-DEC-98 TUE 71812.56
02-DEC-98 WED 29372.8
03-DEC-98 THU 47839
04-DEC-98 FRI 58463.96
05-DEC-98 SAT 100210.86
06-DEC-98 SUN 103416.49
07-DEC-98 MON 153087.15
08-DEC-98 TUE 64659.29
09-DEC-98 WED 24076.28
10-DEC-98 THU 122447.45
11-DEC-98 FRI 131633.06
12-DEC-98 SAT 32464.71
13-DEC-98 SUN 75528.08
14-DEC-98 MON 107428.69
15-DEC-98 TUE 54165.15
16-DEC-98 WED 76987.25
17-DEC-98 THU 144952.37
18-DEC-98 FRI 128264.42
19-DEC-98 SAT 81950.07
20-DEC-98 SUN 195299.29
21-DEC-98 MON 341821.26
22-DEC-98 TUE 251731.16
23-DEC-98 WED 145811.8
24-DEC-98 THU 140262.85
25-DEC-98 FRI 178571.18
26-DEC-98 SAT 117988.26
27-DEC-98 SUN 183149.95
28-DEC-98 MON 284562.69
29-DEC-98 TUE 167085.8
30-DEC-98 WED 143776.47
31-DEC-98 THU 185194.02
01-JAN-99 FRI 112652.53
02-JAN-99 SAT 17117.47
03-JAN-99 SUN 29985.12
04-JAN-99 MON 48597.74
05-JAN-99 TUE 27637.71
06-JAN-99 WED 14638.97
07-JAN-99 THU 71041.35
08-JAN-99 FRI 88095.57
09-JAN-99 SAT 36763.73
10-JAN-99 SUN 283177.36
11-JAN-99 MON 299593.29
12-JAN-99 TUE 38058.04
13-JAN-99 WED 86605.42
14-JAN-99 THU 139329.21
15-JAN-99 FRI 99576.82
16-JAN-99 SAT 101885.15
17-JAN-99 SUN 198317.84
18-JAN-99 MON 256730.16
19-JAN-99 TUE 82405.33
20-JAN-99 WED 245242.59
21-JAN-99 THU 399997.13
22-JAN-99 FRI 202174.91
23-JAN-99 SAT 105115.71
24-JAN-99 SUN 152293.04
25-JAN-99 MON 255617.95
26-JAN-99 TUE 132208.37
27-JAN-99 WED 71106.77
28-JAN-99 THU 95979.1
29-JAN-99 FRI 90285.9
30-JAN-99 SAT 364209.52
31-JAN-99 SUN 427010.16
01-FEB-99 MON 438416.64
02-FEB-99 TUE 40851.74
03-FEB-99 WED 90281.05
04-FEB-99 THU 101403.88
05-FEB-99 FRI 93163.68
06-FEB-99 SAT 55166.99
07-FEB-99 SUN 129303.71
08-FEB-99 MON 183343.82
09-FEB-99 TUE 74146.94
10-FEB-99 WED 171743.81
11-FEB-99 THU 163846.67
12-FEB-99 FRI 42120.45
13-FEB-99 SAT 113461.66
14-FEB-99 SUN 170091.54
15-FEB-99 MON 239192.34
16-FEB-99 TUE 142585.45
17-FEB-99 WED 268463.17
18-FEB-99 THU 226566.67
19-FEB-99 FRI 69132.22
20-FEB-99 SAT 152553.07
21-FEB-99 SUN 522123.67
22-FEB-99 MON 583338.5
23-FEB-99 TUE 121417.08
24-FEB-99 WED 107117.42
25-FEB-99 THU 433831.11
26-FEB-99 FRI 476949.26
27-FEB-99 SAT 165644.86
28-FEB-99 SUN 231460.8
01-MAR-99 MON 244701.55
02-MAR-99 TUE 36818.91
03-MAR-99 WED 50747.73
04-MAR-99 THU 50823.69
05-MAR-99 FRI 28935.37
06-MAR-99 SAT 8155.33
07-MAR-99 SUN 83714.33
08-MAR-99 MON 111672.31
09-MAR-99 TUE 43817.5
10-MAR-99 WED 238710.45
11-MAR-99 THU 239927.98
12-MAR-99 FRI 36824.37
13-MAR-99 SAT 78337.47
14-MAR-99 SUN 126853.61
15-MAR-99 MON 148350.73
16-MAR-99 TUE 79993.01
17-MAR-99 WED 130674.31
18-MAR-99 THU 130591.74
19-MAR-99 FRI 95486.17
20-MAR-99 SAT 259486.08
21-MAR-99 SUN 454426.77
22-MAR-99 MON 464912.25
23-MAR-99 TUE 82103.75
24-MAR-99 WED 119920.17
25-MAR-99 THU 143880.68
26-MAR-99 FRI 129487.7
27-MAR-99 SAT 63034.07
28-MAR-99 SUN 101073.2
29-MAR-99 MON 108236.09
30-MAR-99 TUE 50847.36
31-MAR-99 WED 77490.13
01-APR-99 THU 58000.51
02-APR-99 FRI 33551.44
03-APR-99 SAT 65709.04
04-APR-99 SUN 86909.25
05-APR-99 MON 95973.44
06-APR-99 TUE 41047.43
07-APR-99 WED 85813.09
08-APR-99 THU 72551.47
09-APR-99 FRI 39745.76
10-APR-99 SAT 153630.83
11-APR-99 SUN 169514.42
12-APR-99 MON 190842.19
13-APR-99 TUE 40597.16
14-APR-99 WED 79470.81
15-APR-99 THU 84770
16-APR-99 FRI 93825.29
17-APR-99 SAT 162452.79
18-APR-99 SUN 171461.07
19-APR-99 MON 214221.03
20-APR-99 TUE 267330.16
21-APR-99 WED 410932.71
22-APR-99 THU 229914.62
23-APR-99 FRI 170251.49
24-APR-99 SAT 136387.76
25-APR-99 SUN 157878.08
26-APR-99 MON 283667.8
27-APR-99 TUE 170856.35
28-APR-99 WED 60096.27
29-APR-99 THU 41237.82
30-APR-99 FRI 41218.16
01-MAY-99 SAT 19795.28
02-MAY-99 SUN 38114.96
03-MAY-99 MON 88852.44
04-MAY-99 TUE 82262.87
05-MAY-99 WED 36847.29
06-MAY-99 THU 16380.99
07-MAY-99 FRI 75511.98
08-MAY-99 SAT 86579.14
09-MAY-99 SUN 95256.62
10-MAY-99 MON 305048.09
11-MAY-99 TUE 221578.12
12-MAY-99 WED 27636.43
13-MAY-99 THU 80806.83
14-MAY-99 FRI 100202.35
15-MAY-99 SAT 60247.8
16-MAY-99 SUN 102698.93
17-MAY-99 MON 189739.71
18-MAY-99 TUE 141611.74
19-MAY-99 WED 87621.32
20-MAY-99 THU 262014.31
21-MAY-99 FRI 440667.03
22-MAY-99 SAT 231580.86
23-MAY-99 SUN 335718.88
24-MAY-99 MON 382461.65
25-MAY-99 TUE 157444.85
26-MAY-99 WED 170379.72
27-MAY-99 THU 84494.07
28-MAY-99 FRI 60896.62
29-MAY-99 SAT 44723.16
30-MAY-99 SUN 69189.05
31-MAY-99 MON 108354.68
01-JUN-99 TUE 71041.01
02-JUN-99 WED 43207.77
03-JUN-99 THU 76529.51
04-JUN-99 FRI 87482.57
05-JUN-99 SAT 32928.82
06-JUN-99 SUN 63768.66
07-JUN-99 MON 116996.31
08-JUN-99 TUE 72787.87
09-JUN-99 WED 40307.57
10-JUN-99 THU 153362.77
11-JUN-99 FRI 145826.61
12-JUN-99 SAT 36090.03
13-JUN-99 SUN 56002.72
14-JUN-99 MON 114392.61
15-JUN-99 TUE 83470.96
16-JUN-99 WED 91306.11
17-JUN-99 THU 169795.48
18-JUN-99 FRI 113959.79
19-JUN-99 SAT 54210.99
20-JUN-99 SUN 294734.04
21-JUN-99 MON 469962.91
22-JUN-99 TUE 215695.89
23-JUN-99 WED 171596.26
24-JUN-99 THU 141560.26
25-JUN-99 FRI 33914.61
26-JUN-99 SAT 171325.05
27-JUN-99 SUN 216382.45
28-JUN-99 MON 235021.49
29-JUN-99 TUE 48993.2
30-JUN-99 WED 45866.07
01-JUL-99 THU 27466.53
02-JUL-99 FRI 37802.97
03-JUL-99 SAT 66512.8
04-JUL-99 SUN 107153.16
05-JUL-99 MON 113951.75
06-JUL-99 TUE 8953.81
07-JUL-99 WED 63682.03
08-JUL-99 THU 91325.81
09-JUL-99 FRI 36683.41
10-JUL-99 SAT 209103.55
11-JUL-99 SUN 221193.72
12-JUL-99 MON 236481.01
13-JUL-99 TUE 80380.29
14-JUL-99 WED 96249.74
15-JUL-99 THU 67770.01
16-JUL-99 FRI 85775.54
17-JUL-99 SAT 209835.5
18-JUL-99 SUN 277243.7
19-JUL-99 MON 315607.95
20-JUL-99 TUE 273018.52
21-JUL-99 WED 453223.3
22-JUL-99 THU 227527.42
23-JUL-99 FRI 100265.43
24-JUL-99 SAT 165866.82
25-JUL-99 SUN 301491.94
26-JUL-99 MON 325102.89
27-JUL-99 TUE 52059.44
28-JUL-99 WED 87275.48
29-JUL-99 THU 68653.25
30-JUL-99 FRI 104849.51
31-JUL-99 SAT 102489.88
01-AUG-99 SUN 104678.36
02-AUG-99 MON 127039.61
03-AUG-99 TUE 67153.79
04-AUG-99 WED 81219.54
05-AUG-99 THU 43524.89
06-AUG-99 FRI 9313.72
07-AUG-99 SAT 76094.14
08-AUG-99 SUN 104884.6
09-AUG-99 MON 111294.45
10-AUG-99 TUE 208539.82
11-AUG-99 WED 213958.08
12-AUG-99 THU 25259.73
13-AUG-99 FRI 75851.91
14-AUG-99 SAT 97547.52
15-AUG-99 SUN 137425.67
16-AUG-99 MON 181904.83
17-AUG-99 TUE 252839.6
18-AUG-99 WED 275488.28
19-AUG-99 THU 111435.63
20-AUG-99 FRI 277522.85
21-AUG-99 SAT 453779.13
22-AUG-99 SUN 463141.8
23-AUG-99 MON 547190.42
24-AUG-99 TUE 161086.1
25-AUG-99 WED 212976.98
26-AUG-99 THU 160705.72
27-AUG-99 FRI 55722.06
28-AUG-99 SAT 98422.96
29-AUG-99 SUN 108911.75
30-AUG-99 MON 125564.73
31-AUG-99 TUE 57819.03
01-SEP-99 WED 78179.11
02-SEP-99 THU 52745.53
03-SEP-99 FRI 115207.06
04-SEP-99 SAT 136228.34
05-SEP-99 SUN 138384.75
06-SEP-99 MON 175487.05
07-SEP-99 TUE 108759.86
08-SEP-99 WED 89298.93
09-SEP-99 THU 48651.93
10-SEP-99 FRI 163200.99
11-SEP-99 SAT 144633.67
12-SEP-99 SUN 198028.8
13-SEP-99 MON 217674.41
14-SEP-99 TUE 82429.07
15-SEP-99 WED 85054.32
16-SEP-99 THU 108134.17
17-SEP-99 FRI 349258.21
18-SEP-99 SAT 271999.95
19-SEP-99 SUN 373150.7
20-SEP-99 MON 605060.28
21-SEP-99 TUE 418581.67
22-SEP-99 WED 230791.48
23-SEP-99 THU 237979.89
24-SEP-99 FRI 203164.16
25-SEP-99 SAT 33556.79
26-SEP-99 SUN 134432.81
27-SEP-99 MON 193434.95
28-SEP-99 TUE 70584.82
29-SEP-99 WED 53512.85
30-SEP-99 THU 59053.97
01-OCT-99 FRI 20922.07
02-OCT-99 SAT 28513.17
03-OCT-99 SUN 50152.93
04-OCT-99 MON 84942.03
05-OCT-99 TUE 39660.38
06-OCT-99 WED 6664.32
07-OCT-99 THU 59165.13
08-OCT-99 FRI 86448.54
09-OCT-99 SAT 37836.95
10-OCT-99 SUN 242745.49
11-OCT-99 MON 255282.31
12-OCT-99 TUE 26972.56
13-OCT-99 WED 78735.38
14-OCT-99 THU 95442.96
15-OCT-99 FRI 63961.7
16-OCT-99 SAT 74052.81
17-OCT-99 SUN 227775.25
18-OCT-99 MON 297195.3
19-OCT-99 TUE 92012.78
20-OCT-99 WED 251769.56
21-OCT-99 THU 438945.09
22-OCT-99 FRI 217248.68
23-OCT-99 SAT 83650.36
24-OCT-99 SUN 151408.82
25-OCT-99 MON 264105.6
26-OCT-99 TUE 130543.17
27-OCT-99 WED 50748.84
28-OCT-99 THU 103198.45
29-OCT-99 FRI 77808.1
30-OCT-99 SAT 23634.54
31-OCT-99 SUN 64592.47
01-NOV-99 MON 100237.79
02-NOV-99 TUE 52868.59
03-NOV-99 WED 69490.3
04-NOV-99 THU 78200.35
05-NOV-99 FRI 28952.22
06-NOV-99 SAT 32395.67
07-NOV-99 SUN 96346.3
08-NOV-99 MON 116611.51
09-NOV-99 TUE 51680.47
10-NOV-99 WED 180514.88
11-NOV-99 THU 161835.47
12-NOV-99 FRI 51845.01
13-NOV-99 SAT 56880.93
14-NOV-99 SUN 112491.96
15-NOV-99 MON 128762.56
16-NOV-99 TUE 103150.68
17-NOV-99 WED 270506.03
18-NOV-99 THU 194210.6
19-NOV-99 FRI 80942.23
20-NOV-99 SAT 306109.2
21-NOV-99 SUN 461626.28
22-NOV-99 MON 497511.05
23-NOV-99 TUE 177096.84
24-NOV-99 WED 148337.42
25-NOV-99 THU 29390.8
26-NOV-99 FRI 95779.14
27-NOV-99 SAT 132602.24
28-NOV-99 SUN 146835.14
29-NOV-99 MON 182418.74
30-NOV-99 TUE 53398.7
01-DEC-99 WED 27623.28
02-DEC-99 THU 30583.52
03-DEC-99 FRI 57007.22
04-DEC-99 SAT 76136.53
05-DEC-99 SUN 79153.05
06-DEC-99 MON 86618.61
07-DEC-99 TUE 92916.46
08-DEC-99 WED 123841.25
09-DEC-99 THU 48918.58
10-DEC-99 FRI 130342.69
11-DEC-99 SAT 142138.21
12-DEC-99 SUN 149661.58
13-DEC-99 MON 198416.75
14-DEC-99 TUE 96747.22
15-DEC-99 WED 80440.4
16-DEC-99 THU 107924.27
17-DEC-99 FRI 218544.43
18-DEC-99 SAT 285409.48
19-DEC-99 SUN 308368.07
20-DEC-99 MON 442704.91
21-DEC-99 TUE 213351.86
22-DEC-99 WED 173279.3
23-DEC-99 THU 177010.24
24-DEC-99 FRI 185702.64
25-DEC-99 SAT 166064.14
26-DEC-99 SUN 261186.65
27-DEC-99 MON 327056.9
28-DEC-99 TUE 179780.9
29-DEC-99 WED 124162.24
30-DEC-99 THU 116805.94
31-DEC-99 FRI 176077.02
01-JAN-00 SAT 71296.41
02-JAN-00 SUN 96074.57
03-JAN-00 MON 136680.07
04-JAN-00 TUE 70563.47
05-JAN-00 WED 34718.21
06-JAN-00 THU 6464.4
07-JAN-00 FRI 70848.81
08-JAN-00 SAT 97102.26
09-JAN-00 SUN 107062.85
10-JAN-00 MON 327661.93
11-JAN-00 TUE 237419.91
12-JAN-00 WED 30016.71
13-JAN-00 THU 74145.48
14-JAN-00 FRI 114095.2
15-JAN-00 SAT 81407.24
16-JAN-00 SUN 142301.39
17-JAN-00 MON 309839.67
18-JAN-00 TUE 236576.89
19-JAN-00 WED 89754.73
20-JAN-00 THU 123006.02
21-JAN-00 FRI 361662.04
22-JAN-00 SAT 267978.88
23-JAN-00 SUN 325422.5
24-JAN-00 MON 396572.66
25-JAN-00 TUE 202928.25
26-JAN-00 WED 147933.76
27-JAN-00 THU 53238.32
28-JAN-00 FRI 101325.85
29-JAN-00 SAT 80592.36
30-JAN-00 SUN 364212.13
31-JAN-00 MON 400697.08
01-FEB-00 TUE 38186.19
02-FEB-00 WED 22601.63
03-FEB-00 THU 103039
04-FEB-00 FRI 118250.51
05-FEB-00 SAT 65373.87
06-FEB-00 SUN 67094.23
07-FEB-00 MON 132148.04
08-FEB-00 TUE 102065.69
09-FEB-00 WED 55822.82
10-FEB-00 THU 113641.2
11-FEB-00 FRI 127344.98
12-FEB-00 SAT 58051.69
13-FEB-00 SUN 108684.58
14-FEB-00 MON 262080.54
15-FEB-00 TUE 238298.1
16-FEB-00 WED 192019.32
17-FEB-00 THU 260727.18
18-FEB-00 FRI 208600.71
19-FEB-00 SAT 79673.01
20-FEB-00 SUN 82911.68
21-FEB-00 MON 465736.24
22-FEB-00 TUE 392561.1
23-FEB-00 WED 25844.19
24-FEB-00 THU 60337.19
25-FEB-00 FRI 479950.07
26-FEB-00 SAT 498440.94
27-FEB-00 SUN 534909.55
28-FEB-00 MON 551318.3
29-FEB-00 TUE 52648.23
01-MAR-00 WED 62341.37
02-MAR-00 THU 38227.14
03-MAR-00 FRI 56788.22
04-MAR-00 SAT 72665.04
05-MAR-00 SUN 74470.98
06-MAR-00 MON 96576.42
07-MAR-00 TUE 86055.24
08-MAR-00 WED 83185.4
09-MAR-00 THU 43986.47
10-MAR-00 FRI 168686.91
11-MAR-00 SAT 159890.14
12-MAR-00 SUN 181556.12
13-MAR-00 MON 205428.99
14-MAR-00 TUE 134908.94
15-MAR-00 WED 125280.9
16-MAR-00 THU 143982.61
17-MAR-00 FRI 223901.47
18-MAR-00 SAT 107752.07
19-MAR-00 SUN 153230.28
20-MAR-00 MON 193050.06
21-MAR-00 TUE 243535.6
22-MAR-00 WED 233319.43
23-MAR-00 THU 228185
24-MAR-00 FRI 207297.97
25-MAR-00 SAT 25022.89
26-MAR-00 SUN 128510.7
27-MAR-00 MON 183157.43
28-MAR-00 TUE 71049.76
29-MAR-00 WED 21358.49
30-MAR-00 THU 267232.3
31-MAR-00 FRI 327237.76
01-APR-00 SAT 70923.39
02-APR-00 SUN 124415.87
03-APR-00 MON 192620.07
04-APR-00 TUE 70082.05
05-APR-00 WED 26512.11
06-APR-00 THU 50125.85
07-APR-00 FRI 63348.47
08-APR-00 SAT 87413.88
09-APR-00 SUN 98419.57
10-APR-00 MON 281911
11-APR-00 TUE 215599.88
12-APR-00 WED 41447.55
13-APR-00 THU 75618.77
14-APR-00 FRI 98922.14
15-APR-00 SAT 62836.86
16-APR-00 SUN 245414.76
17-APR-00 MON 353229.75
18-APR-00 TUE 168268.52
19-APR-00 WED 75583.6
20-APR-00 THU 49970.56
21-APR-00 FRI 110179.45
22-APR-00 SAT 129210.84
23-APR-00 SUN 195730.23
24-APR-00 MON 204855.14
25-APR-00 TUE 134799.67
26-APR-00 WED 306510.93
27-APR-00 THU 186864.27
28-APR-00 FRI 59513.63
29-APR-00 SAT 58500.06
30-APR-00 SUN 215161.04
01-MAY-00 MON 243717.13
02-MAY-00 TUE 37491.49
03-MAY-00 WED 60575.07
04-MAY-00 THU 80291.05
05-MAY-00 FRI 30607.36
06-MAY-00 SAT 23856.84
07-MAY-00 SUN 91603.57
08-MAY-00 MON 116485.56
09-MAY-00 TUE 49616.87
10-MAY-00 WED 198101.19
11-MAY-00 THU 188184.41
12-MAY-00 FRI 37363.59
13-MAY-00 SAT 43321.16
14-MAY-00 SUN 106815.66
15-MAY-00 MON 120977.11
16-MAY-00 TUE 89948.85
17-MAY-00 WED 180668.74
18-MAY-00 THU 118156.59
19-MAY-00 FRI 61640.32
20-MAY-00 SAT 76112.09
21-MAY-00 SUN 310591.81
22-MAY-00 MON 340177.96
23-MAY-00 TUE 259413.88
24-MAY-00 WED 238323.5
25-MAY-00 THU 25716.41
26-MAY-00 FRI 105429.74
27-MAY-00 SAT 143778.15
28-MAY-00 SUN 164217.19
29-MAY-00 MON 169590.54
30-MAY-00 TUE 280116.45
31-MAY-00 WED 347071.72
01-JUN-00 THU 78687.04
02-JUN-00 FRI 57014.57
03-JUN-00 SAT 112644.12
04-JUN-00 SUN 114465.51
05-JUN-00 MON 140591.18
06-JUN-00 TUE 51921.73
07-JUN-00 WED 65402.54
08-JUN-00 THU 88634.84
09-JUN-00 FRI 60657.21
10-JUN-00 SAT 192790.12
11-JUN-00 SUN 225976.81
12-JUN-00 MON 235102.51
13-JUN-00 TUE 77789.97
14-JUN-00 WED 106821.83
15-JUN-00 THU 68385.59
16-JUN-00 FRI 181712.03
17-JUN-00 SAT 248832.98
18-JUN-00 SUN 311982.52
19-JUN-00 MON 326661.75
20-JUN-00 TUE 44207.76
21-JUN-00 WED 114460.99
22-JUN-00 THU 141185.68
23-JUN-00 FRI 125124.57
24-JUN-00 SAT 78344.02
25-JUN-00 SUN 203857.43
26-JUN-00 MON 379487.29
27-JUN-00 TUE 181992.68
28-JUN-00 WED 53670.95
29-JUN-00 THU 52434.88
30-JUN-00 FRI 167660.88
01-JUL-00 SAT 187699.57
02-JUL-00 SUN 235079.8
03-JUL-00 MON 273318.71
04-JUL-00 TUE 64309.28
05-JUL-00 WED 27874.03
06-JUL-00 THU 30008.18
07-JUL-00 FRI 119973.88
08-JUL-00 SAT 126298.95
09-JUL-00 SUN 149360.2
10-JUL-00 MON 352839.06
11-JUL-00 TUE 214866.24
12-JUL-00 WED 40886.29
13-JUL-00 THU 105666.37
14-JUL-00 FRI 102668.16
15-JUL-00 SAT 40387.78
16-JUL-00 SUN 102454.17
17-JUL-00 MON 333608.84
18-JUL-00 TUE 239273.57
19-JUL-00 WED 69590.28
20-JUL-00 THU 133052.09
21-JUL-00 FRI 300050.7
22-JUL-00 SAT 255833.6
23-JUL-00 SUN 454542.97
24-JUL-00 MON 460582.32
25-JUL-00 TUE 31978.78
26-JUL-00 WED 82053.93
27-JUL-00 THU 109829.58
28-JUL-00 FRI 155183.23
29-JUL-00 SAT 128321.47
30-JUL-00 SUN 187072.76
31-JUL-00 MON 188875.72
01-AUG-00 TUE 29756.3
02-AUG-00 WED 70907.94
03-AUG-00 THU 70428.35
04-AUG-00 FRI 55405.12
05-AUG-00 SAT 31517.78
06-AUG-00 SUN 52365.29
07-AUG-00 MON 155279.31
08-AUG-00 TUE 139137.27
09-AUG-00 WED 63495.78
10-AUG-00 THU 237389.65
11-AUG-00 FRI 222454.29
12-AUG-00 SAT 40528.84
13-AUG-00 SUN 105910.07
14-AUG-00 MON 136252.69
15-AUG-00 TUE 44842.93
16-AUG-00 WED 86338.05
17-AUG-00 THU 235280.93
18-AUG-00 FRI 174194.69
19-AUG-00 SAT 67880.24
20-AUG-00 SUN 147811.33
21-AUG-00 MON 360151.42
22-AUG-00 TUE 243897.32
23-AUG-00 WED 251988.37
24-AUG-00 THU 227241.42
25-AUG-00 FRI 40759.18
26-AUG-00 SAT 105574.63
27-AUG-00 SUN 159925
28-AUG-00 MON 251396.68
29-AUG-00 TUE 103390.5
30-AUG-00 WED 268257.54
31-AUG-00 THU 316682.39
01-SEP-00 FRI 72817.18
02-SEP-00 SAT 44570.77
03-SEP-00 SUN 101348.66
04-SEP-00 MON 103708.91
05-SEP-00 TUE 26494.38
06-SEP-00 WED 51359.54
07-SEP-00 THU 109469.81
08-SEP-00 FRI 145927.07
09-SEP-00 SAT 91277.16
10-SEP-00 SUN 298188.64
11-SEP-00 MON 328035.19
12-SEP-00 TUE 82248.94
13-SEP-00 WED 100405.62
14-SEP-00 THU 153677.94
15-SEP-00 FRI 141583.76
16-SEP-00 SAT 206251.66
17-SEP-00 SUN 398787.75
18-SEP-00 MON 455154.37
19-SEP-00 TUE 138086.41
20-SEP-00 WED 125612.94
21-SEP-00 THU 120668.59
22-SEP-00 FRI 139582.4
23-SEP-00 SAT 222891.76
24-SEP-00 SUN 238739.97
25-SEP-00 MON 354905.9
26-SEP-00 TUE 249747.52

Rows 1 - 1000. More rows exist.

TIME_ID	CLOSE_DAY	CLOSE_OFF
01-JAN-98	THU	15406.48
02-JAN-98	FRI	34739.89
03-JAN-98	SAT	53726.17
04-JAN-98	SUN	85739.45
05-JAN-98	MON	213948.82
06-JAN-98	TUE	132357.45
07-JAN-98	WED	57137.83
08-JAN-98	THU	75828.64
09-JAN-98	FRI	43344
10-JAN-98	SAT	205230.67
11-JAN-98	SUN	229678.27
12-JAN-98	MON	248571.1
13-JAN-98	TUE	66060.33
14-JAN-98	WED	109029.34
15-JAN-98	THU	94081.05
16-JAN-98	FRI	98902.29
17-JAN-98	SAT	229884
18-JAN-98	SUN	278518.88
19-JAN-98	MON	319617.44
20-JAN-98	TUE	206914.18
21-JAN-98	WED	342569.34
22-JAN-98	THU	211846.81
23-JAN-98	FRI	133693.59
24-JAN-98	SAT	168405.43
25-JAN-98	SUN	460650.98
26-JAN-98	MON	513036.1
27-JAN-98	TUE	84952.63
28-JAN-98	WED	98252.87
29-JAN-98	THU	92146.82
30-JAN-98	FRI	237607.84
31-JAN-98	SAT	243238.52
01-FEB-98	SUN	267834.28
02-FEB-98	MON	321177.7
03-FEB-98	TUE	134991.72
04-FEB-98	WED	127538.85
05-FEB-98	THU	253617.66
06-FEB-98	FRI	211663.37
07-FEB-98	SAT	61851.16
08-FEB-98	SUN	95638.07
09-FEB-98	MON	123152.76
10-FEB-98	TUE	136368.38
11-FEB-98	WED	123478.26
12-FEB-98	THU	38724.06
13-FEB-98	FRI	82343.74
14-FEB-98	SAT	221002.66
15-FEB-98	SUN	280418.45
16-FEB-98	MON	479388.11
17-FEB-98	TUE	367948.92
18-FEB-98	WED	181370.19
19-FEB-98	THU	46358.18
20-FEB-98	FRI	157983.39
21-FEB-98	SAT	350857.55
22-FEB-98	SUN	373232.52
23-FEB-98	MON	451847.91
24-FEB-98	TUE	108643.32
25-FEB-98	WED	396533.22
26-FEB-98	THU	453358.17
27-FEB-98	FRI	110016.98
28-FEB-98	SAT	58795.66
01-MAR-98	SUN	76591.68
02-MAR-98	MON	102700.34
03-MAR-98	TUE	58424.94
04-MAR-98	WED	70469.91
05-MAR-98	THU	186221.6
06-MAR-98	FRI	153540.48
07-MAR-98	SAT	71200.28
08-MAR-98	SUN	86962.1
09-MAR-98	MON	108305.89
10-MAR-98	TUE	172914.8
11-MAR-98	WED	178048.14
12-MAR-98	THU	49923.68
13-MAR-98	FRI	57620.82
14-MAR-98	SAT	103843.21
15-MAR-98	SUN	134234.34
16-MAR-98	MON	224534.54
17-MAR-98	TUE	198057.24
18-MAR-98	WED	138362.38
19-MAR-98	THU	65873.43
20-MAR-98	FRI	182269.06
21-MAR-98	SAT	276239.72
22-MAR-98	SUN	299361.15
23-MAR-98	MON	420975.6
24-MAR-98	TUE	152735.35
25-MAR-98	WED	106148.52
26-MAR-98	THU	122014.64
27-MAR-98	FRI	141288.65
28-MAR-98	SAT	122279.7
29-MAR-98	SUN	131737.03
30-MAR-98	MON	191847.19
31-MAR-98	TUE	154316.32
01-APR-98	WED	110225.22
02-APR-98	THU	47994.56
03-APR-98	FRI	76334
04-APR-98	SAT	93809.51
05-APR-98	SUN	332639.96
06-APR-98	MON	347834.73
07-APR-98	TUE	52749.7
08-APR-98	WED	59241.54
09-APR-98	THU	49725.6
10-APR-98	FRI	147414.75
11-APR-98	SAT	138976.05
12-APR-98	SUN	148265.96
13-APR-98	MON	184731.27
14-APR-98	TUE	96445.4
15-APR-98	WED	77456.57
16-APR-98	THU	147144.01
17-APR-98	FRI	264975.08
18-APR-98	SAT	154084.57
19-APR-98	SUN	171948.62
20-APR-98	MON	353794.99
21-APR-98	TUE	283899.61
22-APR-98	WED	138441.01
23-APR-98	THU	165853.29
24-APR-98	FRI	144098.41
25-APR-98	SAT	36310.19
26-APR-98	SUN	250296.75
27-APR-98	MON	336336.72
28-APR-98	TUE	112133.69
29-APR-98	WED	43678.68
30-APR-98	THU	116881.15
01-MAY-98	FRI	111292.24
02-MAY-98	SAT	37848.12
03-MAY-98	SUN	65232.11
04-MAY-98	MON	94274.66
05-MAY-98	TUE	190590.12
06-MAY-98	WED	165502.96
07-MAY-98	THU	69382.48
08-MAY-98	FRI	78507.41
09-MAY-98	SAT	33266.14
10-MAY-98	SUN	187495.94
11-MAY-98	MON	210310.41
12-MAY-98	TUE	41018.36
13-MAY-98	WED	53276.76
14-MAY-98	THU	113406.34
15-MAY-98	FRI	107803.09
16-MAY-98	SAT	125123.63
17-MAY-98	SUN	234045.83
18-MAY-98	MON	263615.94
19-MAY-98	TUE	53312.99
20-MAY-98	WED	180779.48
21-MAY-98	THU	289689.45
22-MAY-98	FRI	147950.57
23-MAY-98	SAT	120747.24
24-MAY-98	SUN	148987.81
25-MAY-98	MON	220015.22
26-MAY-98	TUE	115612.4
27-MAY-98	WED	151025.65
28-MAY-98	THU	136139.85
29-MAY-98	FRI	40333.07
30-MAY-98	SAT	51443.18
31-MAY-98	SUN	103373.55
01-JUN-98	MON	120061.47
02-JUN-98	TUE	45208.6
03-JUN-98	WED	75833.06
04-JUN-98	THU	95302.93
05-JUN-98	FRI	293961.93
06-JUN-98	SAT	260899.54
07-JUN-98	SUN	293650.9
08-JUN-98	MON	326514.52
09-JUN-98	TUE	59250.82
10-JUN-98	WED	139148.87
11-JUN-98	THU	133578.15
12-JUN-98	FRI	29729.77
13-JUN-98	SAT	43596.06
14-JUN-98	SUN	100063.61
15-JUN-98	MON	119439.71
16-JUN-98	TUE	143642.25
17-JUN-98	WED	236510.14
18-JUN-98	THU	128810.24
19-JUN-98	FRI	33263.66
20-JUN-98	SAT	181205.47
21-JUN-98	SUN	289295.42
22-JUN-98	MON	327422.74
23-JUN-98	TUE	162649.46
24-JUN-98	WED	134879.12
25-JUN-98	THU	32156.91
26-JUN-98	FRI	226825.05
27-JUN-98	SAT	291158.03
28-JUN-98	SUN	323913.95
29-JUN-98	MON	345045.33
30-JUN-98	TUE	62205.37
01-JUL-98	WED	57796.23
02-JUL-98	THU	51124.82
03-JUL-98	FRI	76016.83
04-JUL-98	SAT	73916.89
05-JUL-98	SUN	183542.21
06-JUL-98	MON	185593.19
07-JUL-98	TUE	74525.68
08-JUL-98	WED	103807.8
09-JUL-98	THU	46575.49
10-JUL-98	FRI	188139.94
11-JUL-98	SAT	198162.75
12-JUL-98	SUN	213650.94
13-JUL-98	MON	281267.2
14-JUL-98	TUE	132864.88
15-JUL-98	WED	88077.51
16-JUL-98	THU	95434.55
17-JUL-98	FRI	206252.21
18-JUL-98	SAT	197506.08
19-JUL-98	SUN	242617.75
20-JUL-98	MON	412193.72
21-JUL-98	TUE	323616.74
22-JUL-98	WED	169627.75
23-JUL-98	THU	77062.14
24-JUL-98	FRI	119835.66
25-JUL-98	SAT	145788.49
26-JUL-98	SUN	190377.3
27-JUL-98	MON	289871.4
28-JUL-98	TUE	173337.15
29-JUL-98	WED	90361.61
30-JUL-98	THU	116984.06
31-JUL-98	FRI	111034.07
01-AUG-98	SAT	17947.17
02-AUG-98	SUN	46414.92
03-AUG-98	MON	107059.08
04-AUG-98	TUE	99483.92
05-AUG-98	WED	136308.03
06-AUG-98	THU	100019.19
07-AUG-98	FRI	68386.07
08-AUG-98	SAT	96422.86
09-AUG-98	SUN	115139.87
10-AUG-98	MON	283088.51
11-AUG-98	TUE	197623.82
12-AUG-98	WED	47675.98
13-AUG-98	THU	84181.44
14-AUG-98	FRI	137760.12
15-AUG-98	SAT	99341.1
16-AUG-98	SUN	181054.2
17-AUG-98	MON	332503.2
18-AUG-98	TUE	218663.96
19-AUG-98	WED	114981.83
20-AUG-98	THU	226323.67
21-AUG-98	FRI	368244.09
22-AUG-98	SAT	206733.57
23-AUG-98	SUN	288744.87
24-AUG-98	MON	346049.83
25-AUG-98	TUE	144832.72
26-AUG-98	WED	127233.67
27-AUG-98	THU	134359.5
28-AUG-98	FRI	166444.86
29-AUG-98	SAT	83191.16
30-AUG-98	SUN	106760.68
31-AUG-98	MON	146259.12
01-SEP-98	TUE	69833.88
02-SEP-98	WED	73176.38
03-SEP-98	THU	94640.33
04-SEP-98	FRI	90678.91
05-SEP-98	SAT	202123.57
06-SEP-98	SUN	221804.09
07-SEP-98	MON	284853.5
08-SEP-98	TUE	82135.3
09-SEP-98	WED	51510.78
10-SEP-98	THU	166152.17
11-SEP-98	FRI	160735.37
12-SEP-98	SAT	65143.18
13-SEP-98	SUN	99530.95
14-SEP-98	MON	205298.83
15-SEP-98	TUE	141166.41
16-SEP-98	WED	177014.26
17-SEP-98	THU	257243.89
18-SEP-98	FRI	134006.96
19-SEP-98	SAT	81969.43
20-SEP-98	SUN	333208.51
21-SEP-98	MON	509748.64
22-SEP-98	TUE	217604.3
23-SEP-98	WED	196125.48
24-SEP-98	THU	169376.51
25-SEP-98	FRI	39043.53
26-SEP-98	SAT	167373.19
27-SEP-98	SUN	265075.85
28-SEP-98	MON	309873.02
29-SEP-98	TUE	72915.14
30-SEP-98	WED	43937.27
01-OCT-98	THU	22813.77
02-OCT-98	FRI	36929.74
03-OCT-98	SAT	90043.9
04-OCT-98	SUN	131332.41
05-OCT-98	MON	219004.44
06-OCT-98	TUE	91525.16
07-OCT-98	WED	48418.55
08-OCT-98	THU	70145.11
09-OCT-98	FRI	43879.6
10-OCT-98	SAT	197664.08
11-OCT-98	SUN	225821.88
12-OCT-98	MON	248064.62
13-OCT-98	TUE	79725.17
14-OCT-98	WED	168462.83
15-OCT-98	THU	140991.52
16-OCT-98	FRI	111234.64
17-OCT-98	SAT	239857.73
18-OCT-98	SUN	317414.61
19-OCT-98	MON	402100.16
20-OCT-98	TUE	275131.97
21-OCT-98	WED	417930.64
22-OCT-98	THU	247923.2
23-OCT-98	FRI	91363.78
24-OCT-98	SAT	139198.82
25-OCT-98	SUN	245490.12
26-OCT-98	MON	291377.08
27-OCT-98	TUE	160874.94
28-OCT-98	WED	213778.9
29-OCT-98	THU	112467.71
30-OCT-98	FRI	39308.72
31-OCT-98	SAT	130626.26
01-NOV-98	SUN	151815.56
02-NOV-98	MON	171327.37
03-NOV-98	TUE	90491.42
04-NOV-98	WED	100800.3
05-NOV-98	THU	166906.84
06-NOV-98	FRI	156149.62
07-NOV-98	SAT	61761.25
08-NOV-98	SUN	78446.46
09-NOV-98	MON	102330.94
10-NOV-98	TUE	160750.01
11-NOV-98	WED	155406.7
12-NOV-98	THU	41851.57
13-NOV-98	FRI	49034.01
14-NOV-98	SAT	92613.81
15-NOV-98	SUN	118262.56
16-NOV-98	MON	234429.1
17-NOV-98	TUE	218752.74
18-NOV-98	WED	114277.14
19-NOV-98	THU	62324.79
20-NOV-98	FRI	290449.63
21-NOV-98	SAT	422296.22
22-NOV-98	SUN	457252.96
23-NOV-98	MON	574783.45
24-NOV-98	TUE	125718.03
25-NOV-98	WED	32455.7
26-NOV-98	THU	176828.71
27-NOV-98	FRI	254059.06
28-NOV-98	SAT	144857.4
29-NOV-98	SUN	174630.33
30-NOV-98	MON	240888.83
01-DEC-98	TUE	71812.56
02-DEC-98	WED	29372.8
03-DEC-98	THU	47839
04-DEC-98	FRI	58463.96
05-DEC-98	SAT	100210.86
06-DEC-98	SUN	103416.49
07-DEC-98	MON	153087.15
08-DEC-98	TUE	64659.29
09-DEC-98	WED	24076.28
10-DEC-98	THU	122447.45
11-DEC-98	FRI	131633.06
12-DEC-98	SAT	32464.71
13-DEC-98	SUN	75528.08
14-DEC-98	MON	107428.69
15-DEC-98	TUE	54165.15
16-DEC-98	WED	76987.25
17-DEC-98	THU	144952.37
18-DEC-98	FRI	128264.42
19-DEC-98	SAT	81950.07
20-DEC-98	SUN	195299.29
21-DEC-98	MON	341821.26
22-DEC-98	TUE	251731.16
23-DEC-98	WED	145811.8
24-DEC-98	THU	140262.85
25-DEC-98	FRI	178571.18
26-DEC-98	SAT	117988.26
27-DEC-98	SUN	183149.95
28-DEC-98	MON	284562.69
29-DEC-98	TUE	167085.8
30-DEC-98	WED	143776.47
31-DEC-98	THU	185194.02
01-JAN-99	FRI	112652.53
02-JAN-99	SAT	17117.47
03-JAN-99	SUN	29985.12
04-JAN-99	MON	48597.74
05-JAN-99	TUE	27637.71
06-JAN-99	WED	14638.97
07-JAN-99	THU	71041.35
08-JAN-99	FRI	88095.57
09-JAN-99	SAT	36763.73
10-JAN-99	SUN	283177.36
11-JAN-99	MON	299593.29
12-JAN-99	TUE	38058.04
13-JAN-99	WED	86605.42
14-JAN-99	THU	139329.21
15-JAN-99	FRI	99576.82
16-JAN-99	SAT	101885.15
17-JAN-99	SUN	198317.84
18-JAN-99	MON	256730.16
19-JAN-99	TUE	82405.33
20-JAN-99	WED	245242.59
21-JAN-99	THU	399997.13
22-JAN-99	FRI	202174.91
23-JAN-99	SAT	105115.71
24-JAN-99	SUN	152293.04
25-JAN-99	MON	255617.95
26-JAN-99	TUE	132208.37
27-JAN-99	WED	71106.77
28-JAN-99	THU	95979.1
29-JAN-99	FRI	90285.9
30-JAN-99	SAT	364209.52
31-JAN-99	SUN	427010.16
01-FEB-99	MON	438416.64
02-FEB-99	TUE	40851.74
03-FEB-99	WED	90281.05
04-FEB-99	THU	101403.88
05-FEB-99	FRI	93163.68
06-FEB-99	SAT	55166.99
07-FEB-99	SUN	129303.71
08-FEB-99	MON	183343.82
09-FEB-99	TUE	74146.94
10-FEB-99	WED	171743.81
11-FEB-99	THU	163846.67
12-FEB-99	FRI	42120.45
13-FEB-99	SAT	113461.66
14-FEB-99	SUN	170091.54
15-FEB-99	MON	239192.34
16-FEB-99	TUE	142585.45
17-FEB-99	WED	268463.17
18-FEB-99	THU	226566.67
19-FEB-99	FRI	69132.22
20-FEB-99	SAT	152553.07
21-FEB-99	SUN	522123.67
22-FEB-99	MON	583338.5
23-FEB-99	TUE	121417.08
24-FEB-99	WED	107117.42
25-FEB-99	THU	433831.11
26-FEB-99	FRI	476949.26
27-FEB-99	SAT	165644.86
28-FEB-99	SUN	231460.8
01-MAR-99	MON	244701.55
02-MAR-99	TUE	36818.91
03-MAR-99	WED	50747.73
04-MAR-99	THU	50823.69
05-MAR-99	FRI	28935.37
06-MAR-99	SAT	8155.33
07-MAR-99	SUN	83714.33
08-MAR-99	MON	111672.31
09-MAR-99	TUE	43817.5
10-MAR-99	WED	238710.45
11-MAR-99	THU	239927.98
12-MAR-99	FRI	36824.37
13-MAR-99	SAT	78337.47
14-MAR-99	SUN	126853.61
15-MAR-99	MON	148350.73
16-MAR-99	TUE	79993.01
17-MAR-99	WED	130674.31
18-MAR-99	THU	130591.74
19-MAR-99	FRI	95486.17
20-MAR-99	SAT	259486.08
21-MAR-99	SUN	454426.77
22-MAR-99	MON	464912.25
23-MAR-99	TUE	82103.75
24-MAR-99	WED	119920.17
25-MAR-99	THU	143880.68
26-MAR-99	FRI	129487.7
27-MAR-99	SAT	63034.07
28-MAR-99	SUN	101073.2
29-MAR-99	MON	108236.09
30-MAR-99	TUE	50847.36
31-MAR-99	WED	77490.13
01-APR-99	THU	58000.51
02-APR-99	FRI	33551.44
03-APR-99	SAT	65709.04
04-APR-99	SUN	86909.25
05-APR-99	MON	95973.44
06-APR-99	TUE	41047.43
07-APR-99	WED	85813.09
08-APR-99	THU	72551.47
09-APR-99	FRI	39745.76
10-APR-99	SAT	153630.83
11-APR-99	SUN	169514.42
12-APR-99	MON	190842.19
13-APR-99	TUE	40597.16
14-APR-99	WED	79470.81
15-APR-99	THU	84770
16-APR-99	FRI	93825.29
17-APR-99	SAT	162452.79
18-APR-99	SUN	171461.07
19-APR-99	MON	214221.03
20-APR-99	TUE	267330.16
21-APR-99	WED	410932.71
22-APR-99	THU	229914.62
23-APR-99	FRI	170251.49
24-APR-99	SAT	136387.76
25-APR-99	SUN	157878.08
26-APR-99	MON	283667.8
27-APR-99	TUE	170856.35
28-APR-99	WED	60096.27
29-APR-99	THU	41237.82
30-APR-99	FRI	41218.16
01-MAY-99	SAT	19795.28
02-MAY-99	SUN	38114.96
03-MAY-99	MON	88852.44
04-MAY-99	TUE	82262.87
05-MAY-99	WED	36847.29
06-MAY-99	THU	16380.99
07-MAY-99	FRI	75511.98
08-MAY-99	SAT	86579.14
09-MAY-99	SUN	95256.62
10-MAY-99	MON	305048.09
11-MAY-99	TUE	221578.12
12-MAY-99	WED	27636.43
13-MAY-99	THU	80806.83
14-MAY-99	FRI	100202.35
15-MAY-99	SAT	60247.8

Additional Information

Database on OTN SQL and PL/SQL Discussion forums
Oracle Database
Download Oracle Database