| ==== |
| ---- QUERY: PERF_AGG-Q1 |
| -- Simple aggregations across a few different data types |
| SELECT count(*), min(l_linenumber), max(l_quantity), round(sum(l_tax), 2) |
| FROM lineitem |
| ---- RESULTS |
| 6001215,1,50.00,240129.67 |
| ---- TYPES |
| BIGINT, INT, DECIMAL, DECIMAL |
| ==== |
| ---- QUERY: PERF_AGG-Q2 |
| -- Group by l_shipmode - 7 groups |
| SELECT l_shipmode, count(*) |
| FROM lineitem |
| GROUP BY l_shipmode |
| ---- RESULTS |
| 'RAIL',856484 |
| 'AIR',858104 |
| 'MAIL',857401 |
| 'REG AIR',856868 |
| 'SHIP',858036 |
| 'FOB',857324 |
| 'TRUCK',856998 |
| ---- TYPES |
| STRING, BIGINT |
| ==== |
| ---- QUERY: PERF_AGG-Q3 |
| -- Group by l_receiptdate ~ 2500 groups |
| SELECT l_receiptdate, count(*) |
| FROM lineitem |
| GROUP BY l_receiptdate |
| ---- RESULTS |
| '1995-01-21',2508 |
| '1997-08-29',2537 |
| '1997-10-14',2556 |
| '1996-12-28',2566 |
| '1992-09-12',2537 |
| '1997-12-07',2518 |
| '1996-08-06',2509 |
| '1994-04-15',2471 |
| '1998-06-14',2517 |
| '1995-06-29',2466 |
| '1998-04-07',2449 |
| '1994-06-06',2487 |
| '1994-11-12',2500 |
| '1992-03-20',1304 |
| '1993-04-07',2546 |
| '1997-05-13',2455 |
| '1992-04-28',2140 |
| '1993-06-14',2461 |
| '1992-01-11',27 |
| '1994-11-30',2529 |
| '1998-11-22',557 |
| '1995-09-22',2518 |
| '1992-03-02',921 |
| '1996-02-16',2464 |
| '1997-05-31',2599 |
| '1993-04-25',2467 |
| '1992-06-19',2394 |
| '1997-07-22',2460 |
| '1993-11-22',2523 |
| '1995-01-03',2475 |
| '1997-12-25',2588 |
| '1996-08-24',2534 |
| '1996-10-19',2506 |
| '1995-03-10',2471 |
| '1992-09-30',2519 |
| '1994-06-24',2517 |
| '1995-04-18',2463 |
| '1998-04-25',2502 |
| '1997-08-01',2423 |
| '1995-01-09',2490 |
| '1993-11-28',2484 |
| '1993-09-15',2583 |
| '1996-10-13',2514 |
| '1992-11-07',2460 |
| '1994-01-26',2519 |
| '1998-03-27',2370 |
| '1995-06-01',2508 |
| '1995-04-12',2582 |
| '1994-09-07',2439 |
| '1993-03-27',2444 |
| '1998-11-28',419 |
| '1992-03-08',1044 |
| '1998-09-15',1966 |
| '1995-11-15',2512 |
| '1995-09-28',2586 |
| '1996-07-07',2534 |
| '1992-06-13',2526 |
| '1997-07-28',2447 |
| '1996-05-14',2420 |
| '1997-02-11',2597 |
| '1994-11-18',2494 |
| '1994-09-25',2507 |
| '1993-03-05',2489 |
| '1993-01-16',2496 |
| '1997-05-19',2475 |
| '1996-07-25',2483 |
| '1992-04-22',2019 |
| '1994-03-17',2510 |
| '1998-01-16',2524 |
| '1996-12-22',2482 |
| '1997-08-23',2439 |
| '1998-03-05',2463 |
| '1992-11-25',2446 |
| '1992-09-18',2474 |
| '1994-01-04',2514 |
| '1996-10-31',2410 |
| '1995-06-23',2489 |
| '1995-04-30',2595 |
| '1996-05-26',2479 |
| '1997-05-09',2447 |
| '1992-06-21',2425 |
| '1998-09-27',1740 |
| '1995-11-27',2406 |
| '1993-01-06',2443 |
| '1992-01-29',261 |
| '1993-03-15',2559 |
| '1994-11-08',2445 |
| '1997-02-01',2531 |
| '1995-04-20',2569 |
| '1996-10-21',2464 |
| '1995-03-28',2494 |
| '1992-09-08',2470 |
| '1994-01-14',2582 |
| '1998-03-15',2423 |
| '1998-01-06',2553 |
| '1993-09-27',2512 |
| '1994-03-07',2486 |
| '1995-04-02',2484 |
| '1995-06-11',2523 |
| '1992-11-17',2450 |
| '1996-10-03',2484 |
| '1994-03-25',2520 |
| '1998-01-24',2526 |
| '1993-09-05',2439 |
| '1995-01-19',2551 |
| '1996-12-10',2508 |
| '1997-08-11',2521 |
| '1992-04-10',1733 |
| '1996-05-04',2541 |
| '1992-06-03',2456 |
| '1996-07-17',2444 |
| '1992-03-18',1249 |
| '1993-01-24',2381 |
| '1998-09-05',2217 |
| '1995-11-05',2478 |
| '1997-02-23',2515 |
| '1994-09-17',2501 |
| '1993-06-26',2478 |
| '1992-06-09',2477 |
| '1997-05-21',2539 |
| '1996-02-06',2463 |
| '1992-03-12',1149 |
| '1994-11-20',2436 |
| '1995-04-08',2544 |
| '1994-04-27',2488 |
| '1998-06-26',2503 |
| '1992-09-20',2423 |
| '1996-10-09',2431 |
| '1995-01-13',2474 |
| '1997-10-26',2463 |
| '1994-06-16',2442 |
| '1998-04-17',2506 |
| '1994-04-05',2422 |
| '1998-06-04',2492 |
| '1996-08-16',2477 |
| '1997-12-17',2490 |
| '1995-03-22',2497 |
| '1992-09-02',2482 |
| '1997-10-04',2521 |
| '1993-11-10',2612 |
| '1995-01-31',2557 |
| '1997-07-10',2449 |
| '1993-06-04',2430 |
| '1997-05-03',2490 |
| '1993-04-17',2482 |
| '1998-11-10',798 |
| '1992-03-30',1553 |
| '1995-09-10',2545 |
| '1996-02-24',2500 |
| '1992-01-23',150 |
| '1994-11-02',2469 |
| '1993-11-12',2508 |
| '1997-10-06',2568 |
| '1995-03-20',2552 |
| '1996-10-29',2536 |
| '1997-12-15',2504 |
| '1996-08-14',2603 |
| '1994-04-07',2484 |
| '1998-06-06',2525 |
| '1995-04-28',2473 |
| '1994-06-14',2474 |
| '1998-04-15',2591 |
| '1997-02-09',2487 |
| '1992-01-21',129 |
| '1996-02-26',2499 |
| '1998-11-12',762 |
| '1995-09-12',2536 |
| '1993-04-15',2452 |
| '1992-06-29',2513 |
| '1997-05-01',2447 |
| '1993-06-06',2449 |
| '1997-07-12',2495 |
| '1994-11-22',2535 |
| '1998-11-30',349 |
| '1995-09-30',2594 |
| '1992-03-10',1120 |
| '1996-02-04',2534 |
| '1997-05-23',2415 |
| '1997-07-30',2518 |
| '1993-06-24',2455 |
| '1992-04-18',1918 |
| '1997-10-24',2476 |
| '1996-12-18',2634 |
| '1997-08-19',2512 |
| '1993-11-30',2368 |
| '1995-01-11',2424 |
| '1992-09-22',2443 |
| '1995-03-02',2523 |
| '1994-04-25',2452 |
| '1995-06-19',2421 |
| '1998-06-24',2485 |
| '1997-08-13',2470 |
| '1996-12-12',2480 |
| '1993-09-07',2521 |
| '1994-03-27',2524 |
| '1998-01-26',2532 |
| '1996-10-01',2388 |
| '1995-03-08',2473 |
| '1992-09-28',2501 |
| '1992-11-15',2527 |
| '1995-06-13',2460 |
| '1992-01-09',20 |
| '1994-09-15',2465 |
| '1994-11-28',2390 |
| '1997-02-21',2531 |
| '1993-01-26',2541 |
| '1998-09-07',2137 |
| '1995-11-07',2475 |
| '1996-07-15',2485 |
| '1997-05-29',2501 |
| '1992-06-01',2541 |
| '1996-05-06',2445 |
| '1992-04-12',1740 |
| '1997-02-03',2484 |
| '1993-03-17',2543 |
| '1998-11-18',642 |
| '1998-09-25',1702 |
| '1995-11-25',2513 |
| '1995-09-18',2479 |
| '1993-01-04',2643 |
| '1992-06-23',2408 |
| '1992-04-30',2200 |
| '1996-05-24',2546 |
| '1997-07-18',2550 |
| '1993-11-18',2508 |
| '1998-01-04',2500 |
| '1994-03-05',2523 |
| '1993-09-25',2429 |
| '1996-12-30',2522 |
| '1997-08-31',2496 |
| '1994-01-16',2456 |
| '1998-03-17',2476 |
| '1996-10-23',2523 |
| '1995-04-22',2513 |
| '1997-07-08',2503 |
| '1992-04-20',1998 |
| '1996-07-27',2463 |
| '1998-11-08',782 |
| '1992-03-28',1507 |
| '1995-09-08',2500 |
| '1993-01-14',2434 |
| '1994-09-27',2475 |
| '1993-03-07',2482 |
| '1997-02-13',2366 |
| '1995-06-21',2504 |
| '1992-11-27',2474 |
| '1994-01-06',2463 |
| '1998-03-07',2470 |
| '1996-12-20',2535 |
| '1997-08-21',2533 |
| '1998-01-14',2470 |
| '1995-01-29',2506 |
| '1993-11-08',2484 |
| '1994-03-15',2447 |
| '1995-04-10',2503 |
| '1995-06-03',2488 |
| '1998-03-25',2541 |
| '1994-01-24',2512 |
| '1995-03-18',2600 |
| '1992-11-05',2510 |
| '1996-10-11',2600 |
| '1993-09-17',2470 |
| '1996-12-02',2486 |
| '1997-08-03',2414 |
| '1992-04-02',1605 |
| '1996-05-16',2450 |
| '1992-06-11',2443 |
| '1996-07-05',2475 |
| '1998-09-17',1962 |
| '1995-11-17',2458 |
| '1992-01-19',95 |
| '1993-03-25',2443 |
| '1994-09-05',2570 |
| '1992-04-08',1772 |
| '1997-07-20',2442 |
| '1993-04-27',2576 |
| '1996-02-14',2443 |
| '1998-11-20',558 |
| '1995-09-20',2463 |
| '1992-01-13',43 |
| '1998-04-27',2491 |
| '1994-06-26',2528 |
| '1995-06-09',2522 |
| '1995-03-12',2438 |
| '1997-12-27',2468 |
| '1996-08-26',2463 |
| '1995-01-01',2437 |
| '1993-11-20',2568 |
| '1997-08-09',2528 |
| '1996-12-08',2558 |
| '1998-04-05',2518 |
| '1994-06-04',2528 |
| '1994-04-17',2511 |
| '1998-06-16',2607 |
| '1996-08-04',2437 |
| '1997-12-05',2401 |
| '1995-03-30',2560 |
| '1992-09-10',2435 |
| '1997-10-16',2558 |
| '1993-11-02',2544 |
| '1995-01-23',2537 |
| '1997-07-02',2478 |
| '1993-06-16',2397 |
| '1997-05-11',2440 |
| '1993-04-05',2517 |
| '1992-03-22',1391 |
| '1995-09-02',2463 |
| '1998-11-02',875 |
| '1992-01-31',303 |
| '1994-11-10',2473 |
| '1997-02-19',2442 |
| '1996-11-22',2433 |
| '1998-02-16',2453 |
| '1997-09-30',2378 |
| '1992-12-25',2527 |
| '1994-02-04',2524 |
| '1993-10-19',2499 |
| '1993-08-24',2547 |
| '1995-05-23',2586 |
| '1995-07-30',2563 |
| '1995-08-19',2597 |
| '1998-10-19',1270 |
| '1995-10-24',2504 |
| '1994-12-18',2473 |
| '1998-08-24',2365 |
| '1997-01-11',2380 |
| '1993-02-16',2434 |
| '1997-03-02',2512 |
| '1997-06-19',2490 |
| '1996-04-25',2592 |
| '1992-05-31',2487 |
| '1992-07-22',2534 |
| '1998-08-06',2439 |
| '1995-10-06',2595 |
| '1997-03-20',2489 |
| '1998-12-28',7 |
| '1994-08-14',2441 |
| '1995-12-15',2549 |
| '1994-10-29',2420 |
| '1992-05-13',2314 |
| '1996-04-07',2519 |
| '1996-06-14',2487 |
| '1997-04-28',2469 |
| '1995-02-09',2455 |
| '1992-08-29',2515 |
| '1993-12-28',2428 |
| '1992-10-14',2477 |
| '1994-02-26',2422 |
| '1992-12-07',2481 |
| '1993-08-06',2465 |
| '1997-09-12',2568 |
| '1995-05-01',2562 |
| '1995-07-12',2470 |
| '1992-08-23',2529 |
| '1993-12-22',2597 |
| '1995-02-03',2473 |
| '1993-10-31',2565 |
| '1997-09-18',2476 |
| '1997-11-25',2538 |
| '1998-07-25',2509 |
| '1995-07-18',2538 |
| '1994-05-24',2450 |
| '1996-03-05',2511 |
| '1992-02-11',503 |
| '1998-10-31',1028 |
| '1994-12-30',2559 |
| '1995-08-31',2537 |
| '1996-01-16',2401 |
| '1998-12-22',51 |
| '1994-10-23',2425 |
| '1993-07-25',2510 |
| '1992-05-19',2417 |
| '1997-04-22',2444 |
| '1995-08-13',2588 |
| '1994-12-12',2485 |
| '1998-10-13',1349 |
| '1996-03-27',2465 |
| '1994-10-01',2529 |
| '1997-03-08',2515 |
| '1997-06-13',2452 |
| '1993-07-07',2417 |
| '1993-05-14',2511 |
| '1992-07-28',2493 |
| '1996-09-15',2497 |
| '1996-11-28',2520 |
| '1995-02-21',2472 |
| '1992-08-01',2575 |
| '1997-11-07',2541 |
| '1993-10-13',2573 |
| '1995-05-29',2468 |
| '1994-07-15',2547 |
| '1998-05-14',2425 |
| '1998-07-07',2526 |
| '1994-05-06',2446 |
| '1993-05-04',2474 |
| '1997-04-10',2418 |
| '1993-07-17',2420 |
| '1997-06-03',2464 |
| '1997-03-18',2543 |
| '1996-01-24',2469 |
| '1998-12-10',142 |
| '1994-10-11',2527 |
| '1994-12-02',2493 |
| '1992-02-23',770 |
| '1995-08-03',2499 |
| '1998-10-03',1557 |
| '1994-05-16',2457 |
| '1998-07-17',2464 |
| '1998-05-04',2510 |
| '1994-07-05',2481 |
| '1993-10-03',2475 |
| '1997-11-17',2454 |
| '1992-08-11',2340 |
| '1993-12-10',2582 |
| '1996-09-05',2514 |
| '1995-07-08',2568 |
| '1994-07-27',2600 |
| '1998-05-26',2512 |
| '1997-09-08',2518 |
| '1993-10-21',2412 |
| '1996-09-27',2523 |
| '1995-02-13',2500 |
| '1993-05-26',2465 |
| '1997-06-21',2539 |
| '1992-05-09',2334 |
| '1996-01-06',2379 |
| '1992-02-01',322 |
| '1995-08-21',2547 |
| '1998-10-21',1123 |
| '1994-12-20',2483 |
| '1996-03-15',2433 |
| '1997-01-29',2498 |
| '1996-06-04',2446 |
| '1992-07-10',2617 |
| '1996-04-17',2535 |
| '1992-05-03',2178 |
| '1993-02-24',2583 |
| '1994-08-04',2479 |
| '1995-12-05',2558 |
| '1997-03-30',2506 |
| '1995-10-16',2549 |
| '1998-08-16',2463 |
| '1997-01-23',2532 |
| '1995-07-02',2533 |
| '1995-05-11',2553 |
| '1997-09-02',2601 |
| '1992-12-17',2387 |
| '1993-08-16',2527 |
| '1996-11-10',2517 |
| '1995-02-19',2467 |
| '1992-10-04',2454 |
| '1998-02-24',2558 |
| '1995-07-20',2462 |
| '1993-10-09',2559 |
| '1994-02-14',2470 |
| '1997-09-20',2423 |
| '1998-02-06',2411 |
| '1992-10-26',2499 |
| '1996-06-26',2477 |
| '1992-05-21',2346 |
| '1997-06-09',2464 |
| '1997-03-12',2533 |
| '1993-02-06',2439 |
| '1995-12-27',2433 |
| '1994-08-26',2433 |
| '1997-01-01',2638 |
| '1995-08-09',2539 |
| '1998-10-09',1453 |
| '1994-12-08',2543 |
| '1992-02-29',882 |
| '1996-11-30',2532 |
| '1992-08-19',2441 |
| '1998-02-04',2497 |
| '1992-10-24',2540 |
| '1993-12-18',2510 |
| '1997-09-22',2434 |
| '1994-02-16',2445 |
| '1995-05-31',2541 |
| '1995-07-22',2441 |
| '1997-01-03',2490 |
| '1998-12-18',84 |
| '1994-08-24',2531 |
| '1995-12-25',2510 |
| '1994-10-19',2430 |
| '1993-02-04',2467 |
| '1997-03-10',2512 |
| '1992-05-23',2453 |
| '1996-06-24',2464 |
| '1997-04-18',2560 |
| '1992-07-30',2381 |
| '1997-01-21',2578 |
| '1992-02-09',476 |
| '1995-10-14',2561 |
| '1994-12-28',2494 |
| '1998-10-29',1055 |
| '1998-08-14',2482 |
| '1995-08-29',2469 |
| '1994-08-06',2437 |
| '1993-02-26',2457 |
| '1995-12-07',2511 |
| '1992-05-01',2131 |
| '1996-04-15',2514 |
| '1997-06-29',2554 |
| '1992-07-12',2496 |
| '1996-06-06',2490 |
| '1992-10-06',2483 |
| '1998-02-26',2508 |
| '1996-11-12',2487 |
| '1993-08-14',2537 |
| '1992-12-15',2391 |
| '1993-10-29',2418 |
| '1995-05-13',2546 |
| '1992-08-31',2526 |
| '1995-02-11',2509 |
| '1993-12-30',2490 |
| '1996-11-18',2545 |
| '1996-09-25',2574 |
| '1993-10-23',2561 |
| '1995-05-19',2433 |
| '1998-05-24',2515 |
| '1994-07-25',2445 |
| '1996-03-17',2370 |
| '1992-02-03',354 |
| '1998-10-23',1143 |
| '1995-08-23',2400 |
| '1994-12-22',2421 |
| '1996-01-04',2476 |
| '1998-12-30',3 |
| '1994-10-31',2542 |
| '1997-06-23',2529 |
| '1993-05-24',2487 |
| '1992-07-18',2470 |
| '1997-04-30',2473 |
| '1998-10-01',1587 |
| '1992-02-21',706 |
| '1995-08-01',2421 |
| '1997-01-09',2569 |
| '1998-12-12',136 |
| '1994-10-13',2467 |
| '1996-01-26',2483 |
| '1997-06-01',2468 |
| '1992-05-29',2395 |
| '1993-07-15',2537 |
| '1997-04-12',2521 |
| '1993-05-06',2614 |
| '1996-09-07',2484 |
| '1993-12-12',2442 |
| '1992-08-13',2503 |
| '1997-09-28',2477 |
| '1997-11-15',2521 |
| '1993-10-01',2505 |
| '1998-05-06',2539 |
| '1994-07-07',2509 |
| '1994-05-14',2473 |
| '1998-07-15',2375 |
| '1995-07-28',2585 |
| '1993-05-16',2417 |
| '1997-04-02',2497 |
| '1993-07-05',2492 |
| '1997-06-11',2555 |
| '1998-12-02',334 |
| '1994-10-03',2564 |
| '1996-03-25',2565 |
| '1997-01-19',2484 |
| '1998-10-11',1395 |
| '1995-08-11',2389 |
| '1994-12-10',2546 |
| '1994-05-04',2516 |
| '1998-07-05',2517 |
| '1998-05-16',2533 |
| '1994-07-17',2458 |
| '1993-10-11',2494 |
| '1997-11-05',2502 |
| '1995-02-23',2560 |
| '1993-12-02',2509 |
| '1992-08-03',2528 |
| '1996-09-17',2496 |
| '1994-05-26',2496 |
| '1998-07-27',2504 |
| '1995-05-09',2498 |
| '1997-11-27',2492 |
| '1996-11-08',2465 |
| '1995-02-01',2442 |
| '1993-12-20',2521 |
| '1992-08-21',2501 |
| '1997-04-20',2480 |
| '1992-07-08',2463 |
| '1993-07-27',2555 |
| '1998-12-20',49 |
| '1994-10-21',2551 |
| '1996-01-14',2507 |
| '1997-03-28',2501 |
| '1992-02-13',628 |
| '1996-03-07',2487 |
| '1996-06-16',2467 |
| '1992-07-02',2480 |
| '1996-04-05',2562 |
| '1992-05-11',2265 |
| '1994-08-16',2522 |
| '1995-12-17',2578 |
| '1997-03-22',2423 |
| '1992-02-19',699 |
| '1995-10-04',2571 |
| '1998-08-04',2482 |
| '1997-01-31',2462 |
| '1995-07-10',2519 |
| '1995-05-03',2589 |
| '1997-09-10',2560 |
| '1993-08-04',2500 |
| '1994-02-24',2542 |
| '1992-12-05',2439 |
| '1996-11-02',2526 |
| '1992-10-16',2394 |
| '1995-05-21',2521 |
| '1993-08-26',2438 |
| '1994-02-06',2493 |
| '1992-12-27',2484 |
| '1992-08-09',2490 |
| '1993-12-08',2543 |
| '1998-02-14',2499 |
| '1996-11-20',2626 |
| '1992-07-20',2385 |
| '1997-04-08',2519 |
| '1996-04-27',2480 |
| '1998-12-08',217 |
| '1994-10-09',2419 |
| '1993-02-14',2480 |
| '1997-01-13',2496 |
| '1998-08-26',2360 |
| '1995-10-26',2511 |
| '1993-08-25',2576 |
| '1994-02-05',2369 |
| '1993-10-18',2476 |
| '1992-12-24',2422 |
| '1998-02-17',2483 |
| '1996-11-23',2513 |
| '1995-07-31',2499 |
| '1995-05-22',2543 |
| '1997-03-03',2421 |
| '1993-02-17',2490 |
| '1997-01-10',2533 |
| '1998-10-18',1261 |
| '1998-08-25',2386 |
| '1995-08-18',2530 |
| '1995-10-25',2494 |
| '1994-12-19',2413 |
| '1992-07-23',2486 |
| '1992-05-30',2483 |
| '1996-04-24',2417 |
| '1997-06-18',2412 |
| '1998-12-29',2 |
| '1994-08-15',2413 |
| '1995-12-14',2487 |
| '1994-10-28',2513 |
| '1997-03-21',2492 |
| '1995-10-07',2527 |
| '1998-08-07',2462 |
| '1996-06-15',2463 |
| '1997-04-29',2434 |
| '1992-07-01',2507 |
| '1996-04-06',2442 |
| '1992-05-12',2344 |
| '1997-09-13',2520 |
| '1992-12-06',2463 |
| '1993-08-07',2403 |
| '1994-02-27',2489 |
| '1996-11-01',2577 |
| '1995-02-08',2488 |
| '1993-12-29',2455 |
| '1992-08-28',2475 |
| '1992-10-15',2400 |
| '1995-07-13',2481 |
| '1997-09-19',2458 |
| '1997-11-24',2462 |
| '1993-10-30',2420 |
| '1995-02-02',2514 |
| '1992-08-22',2454 |
| '1993-12-23',2452 |
| '1998-07-24',2455 |
| '1995-07-19',2479 |
| '1994-05-25',2466 |
| '1998-12-23',20 |
| '1994-10-22',2511 |
| '1996-01-17',2560 |
| '1992-02-10',501 |
| '1995-08-30',2446 |
| '1994-12-31',2517 |
| '1998-10-30',973 |
| '1996-03-04',2494 |
| '1997-04-23',2599 |
| '1997-06-30',2520 |
| '1992-05-18',2394 |
| '1993-07-24',2511 |
| '1997-03-09',2470 |
| '1998-12-01',347 |
| '1996-03-26',2537 |
| '1998-10-12',1335 |
| '1994-12-13',2404 |
| '1995-08-12',2445 |
| '1992-07-29',2504 |
| '1993-05-15',2546 |
| '1997-04-01',2495 |
| '1993-07-06',2353 |
| '1997-06-12',2533 |
| '1993-10-12',2536 |
| '1997-11-06',2450 |
| '1993-12-01',2583 |
| '1995-02-20',2547 |
| '1996-09-14',2504 |
| '1996-11-29',2564 |
| '1994-05-07',2594 |
| '1998-07-06',2401 |
| '1998-05-15',2479 |
| '1995-05-28',2460 |
| '1994-07-14',2463 |
| '1997-06-02',2457 |
| '1993-07-16',2581 |
| '1997-04-11',2541 |
| '1993-05-05',2497 |
| '1992-02-22',776 |
| '1998-10-02',1555 |
| '1994-12-03',2645 |
| '1995-08-02',2407 |
| '1998-12-11',164 |
| '1994-10-10',2447 |
| '1996-01-25',2465 |
| '1997-03-19',2601 |
| '1994-07-04',2478 |
| '1998-05-05',2489 |
| '1998-07-16',2494 |
| '1994-05-17',2589 |
| '1996-09-04',2452 |
| '1992-08-10',2472 |
| '1993-12-11',2444 |
| '1997-11-16',2499 |
| '1993-10-02',2503 |
| '1998-05-27',2553 |
| '1994-07-26',2515 |
| '1995-07-09',2537 |
| '1995-02-12',2476 |
| '1996-09-26',2578 |
| '1993-10-20',2546 |
| '1997-09-09',2427 |
| '1992-05-08',2318 |
| '1997-06-20',2493 |
| '1993-05-27',2438 |
| '1997-01-28',2484 |
| '1996-03-14',2458 |
| '1998-10-20',1166 |
| '1995-08-20',2475 |
| '1994-12-21',2427 |
| '1996-01-07',2439 |
| '1992-05-02',2184 |
| '1996-04-16',2488 |
| '1992-07-11',2592 |
| '1996-06-05',2468 |
| '1997-01-22',2528 |
| '1998-08-17',2462 |
| '1995-10-17',2440 |
| '1997-03-31',2399 |
| '1993-02-25',2605 |
| '1995-12-04',2494 |
| '1994-08-05',2499 |
| '1995-05-10',2615 |
| '1995-07-03',2515 |
| '1998-02-25',2516 |
| '1995-02-18',2526 |
| '1992-10-05',2470 |
| '1996-11-11',2527 |
| '1993-08-17',2522 |
| '1992-12-16',2457 |
| '1997-09-03',2481 |
| '1995-07-21',2452 |
| '1998-02-07',2539 |
| '1992-10-27',2587 |
| '1997-09-21',2533 |
| '1994-02-15',2396 |
| '1993-10-08',2473 |
| '1997-06-08',2548 |
| '1992-05-20',2488 |
| '1996-06-27',2472 |
| '1992-02-28',891 |
| '1998-10-08',1504 |
| '1994-12-09',2449 |
| '1995-08-08',2533 |
| '1994-08-27',2534 |
| '1995-12-26',2443 |
| '1993-02-07',2425 |
| '1997-03-13',2578 |
| '1994-02-17',2487 |
| '1997-09-23',2474 |
| '1992-08-18',2412 |
| '1993-12-19',2511 |
| '1998-02-05',2470 |
| '1992-10-25',2480 |
| '1995-07-23',2471 |
| '1995-05-30',2490 |
| '1997-03-11',2483 |
| '1998-12-19',62 |
| '1994-10-18',2494 |
| '1993-02-05',2521 |
| '1995-12-24',2429 |
| '1994-08-25',2460 |
| '1997-01-02',2510 |
| '1992-07-31',2513 |
| '1996-06-25',2405 |
| '1997-04-19',2397 |
| '1992-05-22',2456 |
| '1995-12-06',2453 |
| '1994-08-07',2423 |
| '1993-02-27',2416 |
| '1998-08-15',2492 |
| '1998-10-28',1086 |
| '1995-08-28',2399 |
| '1994-12-29',2531 |
| '1995-10-15',2526 |
| '1992-02-08',468 |
| '1997-01-20',2467 |
| '1996-06-07',2518 |
| '1992-07-13',2404 |
| '1996-04-14',2496 |
| '1997-06-28',2583 |
| '1997-09-01',2537 |
| '1993-08-15',2422 |
| '1992-12-14',2531 |
| '1993-10-28',2554 |
| '1996-11-13',2433 |
| '1998-02-27',2488 |
| '1992-10-07',2418 |
| '1995-07-01',2459 |
| '1995-05-12',2424 |
| '1993-10-22',2437 |
| '1996-09-24',2560 |
| '1996-11-19',2468 |
| '1992-08-30',2516 |
| '1993-12-31',2424 |
| '1995-02-10',2580 |
| '1998-05-25',2521 |
| '1994-07-24',2420 |
| '1995-05-18',2535 |
| '1998-12-31',1 |
| '1994-10-30',2446 |
| '1996-01-05',2489 |
| '1992-02-02',345 |
| '1998-10-22',1140 |
| '1995-08-22',2442 |
| '1994-12-23',2528 |
| '1996-03-16',2587 |
| '1992-07-19',2468 |
| '1993-05-25',2529 |
| '1997-06-22',2443 |
| '1996-01-27',2514 |
| '1998-12-13',123 |
| '1994-10-12',2608 |
| '1997-01-08',2581 |
| '1992-02-20',755 |
| '1994-12-01',2501 |
| '1993-05-07',2433 |
| '1997-04-13',2511 |
| '1993-07-14',2516 |
| '1992-05-28',2427 |
| '1997-09-29',2535 |
| '1997-11-14',2370 |
| '1993-12-13',2478 |
| '1992-08-12',2506 |
| '1996-09-06',2522 |
| '1995-07-29',2456 |
| '1994-05-15',2578 |
| '1998-07-14',2586 |
| '1994-07-06',2486 |
| '1998-05-07',2481 |
| '1997-06-10',2463 |
| '1993-07-04',2515 |
| '1997-04-03',2508 |
| '1993-05-17',2479 |
| '1995-08-10',2579 |
| '1994-12-11',2459 |
| '1998-10-10',1424 |
| '1997-01-18',2485 |
| '1996-03-24',2515 |
| '1998-12-03',291 |
| '1994-10-02',2484 |
| '1994-07-16',2460 |
| '1998-05-17',2543 |
| '1998-07-04',2391 |
| '1994-05-05',2446 |
| '1996-09-16',2512 |
| '1995-02-22',2532 |
| '1992-08-02',2372 |
| '1993-12-03',2501 |
| '1997-11-04',2474 |
| '1993-10-10',2470 |
| '1995-05-08',2620 |
| '1998-07-26',2651 |
| '1994-05-27',2486 |
| '1992-08-20',2447 |
| '1993-12-21',2542 |
| '1996-11-09',2512 |
| '1997-11-26',2468 |
| '1993-07-26',2489 |
| '1992-07-09',2464 |
| '1997-04-21',2474 |
| '1996-03-06',2455 |
| '1992-02-12',541 |
| '1997-03-29',2484 |
| '1996-01-15',2492 |
| '1998-12-21',46 |
| '1994-10-20',2480 |
| '1992-05-10',2389 |
| '1996-04-04',2488 |
| '1992-07-03',2533 |
| '1996-06-17',2488 |
| '1997-01-30',2469 |
| '1992-02-18',679 |
| '1998-08-05',2575 |
| '1995-10-05',2474 |
| '1997-03-23',2422 |
| '1994-08-17',2522 |
| '1995-12-16',2544 |
| '1995-05-02',2441 |
| '1995-07-11',2433 |
| '1992-10-17',2490 |
| '1996-11-03',2525 |
| '1993-08-05',2619 |
| '1994-02-25',2514 |
| '1992-12-04',2492 |
| '1997-09-11',2513 |
| '1995-05-20',2483 |
| '1996-11-21',2436 |
| '1998-02-15',2390 |
| '1993-12-09',2520 |
| '1995-02-28',2446 |
| '1992-08-08',2413 |
| '1993-08-27',2418 |
| '1994-02-07',2460 |
| '1992-12-26',2461 |
| '1996-04-26',2429 |
| '1997-04-09',2513 |
| '1992-07-21',2396 |
| '1995-10-27',2582 |
| '1998-08-27',2335 |
| '1997-01-12',2458 |
| '1998-12-09',185 |
| '1993-02-15',2441 |
| '1994-10-08',2515 |
| '1997-03-01',2498 |
| '1996-08-07',2472 |
| '1997-12-06',2514 |
| '1992-09-13',2486 |
| '1997-08-28',2558 |
| '1997-10-15',2500 |
| '1996-12-29',2477 |
| '1995-01-20',2513 |
| '1993-11-01',2509 |
| '1998-04-06',2586 |
| '1994-06-07',2503 |
| '1998-06-15',2485 |
| '1995-06-28',2486 |
| '1994-04-14',2542 |
| '1995-09-01',2478 |
| '1998-11-01',954 |
| '1992-03-21',1345 |
| '1994-11-13',2494 |
| '1997-07-01',2462 |
| '1992-04-29',2057 |
| '1993-06-15',2538 |
| '1997-05-12',2428 |
| '1993-04-06',2514 |
| '1996-02-17',2444 |
| '1998-11-23',513 |
| '1992-03-03',926 |
| '1995-09-23',2495 |
| '1992-01-10',37 |
| '1997-07-23',2581 |
| '1992-06-18',2526 |
| '1993-04-24',2581 |
| '1997-05-30',2559 |
| '1995-03-11',2583 |
| '1997-12-24',2504 |
| '1996-10-18',2562 |
| '1996-08-25',2518 |
| '1993-11-23',2440 |
| '1995-01-02',2433 |
| '1995-04-19',2569 |
| '1998-04-24',2456 |
| '1994-06-25',2590 |
| '1998-03-26',2501 |
| '1994-01-27',2558 |
| '1992-11-06',2451 |
| '1996-10-12',2506 |
| '1995-01-08',2497 |
| '1993-09-14',2495 |
| '1993-11-29',2433 |
| '1996-12-01',2604 |
| '1995-04-13',2486 |
| '1998-11-29',380 |
| '1995-09-29',2486 |
| '1998-09-14',1860 |
| '1992-03-09',1081 |
| '1995-11-14',2429 |
| '1994-09-06',2464 |
| '1993-03-26',2487 |
| '1992-04-01',1590 |
| '1996-05-15',2503 |
| '1997-07-29',2505 |
| '1992-06-12',2514 |
| '1996-07-06',2513 |
| '1993-01-17',2491 |
| '1994-09-24',2412 |
| '1993-03-04',2622 |
| '1994-11-19',2491 |
| '1997-02-10',2435 |
| '1992-04-23',1994 |
| '1996-07-24',2498 |
| '1997-05-18',2567 |
| '1992-06-30',2507 |
| '1996-10-30',2507 |
| '1998-03-04',2458 |
| '1992-11-24',2498 |
| '1994-01-05',2507 |
| '1992-09-19',2478 |
| '1997-08-22',2541 |
| '1996-12-23',2484 |
| '1994-03-16',2508 |
| '1998-01-17',2561 |
| '1995-06-22',2482 |
| '1992-06-20',2436 |
| '1997-05-08',2545 |
| '1996-05-27',2536 |
| '1992-01-28',236 |
| '1993-03-14',2522 |
| '1994-11-09',2495 |
| '1998-09-26',1741 |
| '1995-11-26',2491 |
| '1993-01-07',2472 |
| '1995-04-21',2591 |
| '1993-09-26',2441 |
| '1998-01-07',2535 |
| '1994-03-06',2529 |
| '1992-09-09',2435 |
| '1995-03-29',2609 |
| '1998-03-14',2475 |
| '1994-01-15',2520 |
| '1996-10-20',2554 |
| '1995-06-10',2623 |
| '1995-04-03',2581 |
| '1996-12-11',2544 |
| '1997-08-10',2555 |
| '1993-09-04',2353 |
| '1998-01-25',2476 |
| '1994-03-24',2448 |
| '1995-01-18',2480 |
| '1996-10-02',2481 |
| '1992-11-16',2427 |
| '1996-07-16',2495 |
| '1992-06-02',2462 |
| '1996-05-05',2478 |
| '1992-04-11',1761 |
| '1994-09-16',2488 |
| '1997-02-22',2512 |
| '1992-03-19',1248 |
| '1998-09-04',2119 |
| '1995-11-04',2477 |
| '1993-01-25',2446 |
| '1997-05-20',2510 |
| '1992-06-08',2594 |
| '1993-06-27',2487 |
| '1994-11-21',2464 |
| '1997-02-28',2382 |
| '1992-03-13',1154 |
| '1996-02-07',2458 |
| '1998-06-27',2471 |
| '1994-04-26',2486 |
| '1995-04-09',2422 |
| '1997-10-27',2550 |
| '1995-01-12',2469 |
| '1996-10-08',2561 |
| '1995-03-01',2382 |
| '1992-09-21',2422 |
| '1994-04-04',2566 |
| '1998-06-05',2422 |
| '1994-06-17',2454 |
| '1998-04-16',2547 |
| '1995-01-30',2490 |
| '1993-11-11',2569 |
| '1997-10-05',2533 |
| '1995-03-23',2447 |
| '1992-09-03',2563 |
| '1996-08-17',2449 |
| '1997-12-16',2503 |
| '1993-04-16',2411 |
| '1997-05-02',2429 |
| '1993-06-05',2407 |
| '1997-07-11',2457 |
| '1992-01-22',129 |
| '1994-11-03',2390 |
| '1996-02-25',2417 |
| '1998-11-11',699 |
| '1992-03-31',1626 |
| '1995-09-11',2465 |
| '1997-12-14',2486 |
| '1996-08-15',2491 |
| '1996-10-28',2614 |
| '1995-03-21',2542 |
| '1992-09-01',2419 |
| '1997-10-07',2454 |
| '1993-11-13',2471 |
| '1995-04-29',2555 |
| '1994-06-15',2464 |
| '1998-04-14',2548 |
| '1998-06-07',2486 |
| '1994-04-06',2475 |
| '1998-11-13',717 |
| '1995-09-13',2535 |
| '1996-02-27',2368 |
| '1992-01-20',132 |
| '1994-11-01',2503 |
| '1997-02-08',2489 |
| '1997-07-13',2458 |
| '1993-06-07',2366 |
| '1992-06-28',2384 |
| '1993-04-14',2504 |
| '1996-02-05',2475 |
| '1992-03-11',1116 |
| '1994-11-23',2457 |
| '1992-04-19',1816 |
| '1993-06-25',2599 |
| '1997-07-31',2618 |
| '1997-05-22',2453 |
| '1992-09-23',2480 |
| '1995-03-03',2372 |
| '1995-01-10',2528 |
| '1996-12-19',2481 |
| '1997-10-25',2455 |
| '1997-08-18',2614 |
| '1995-06-18',2465 |
| '1994-04-24',2517 |
| '1998-06-25',2519 |
| '1992-09-29',2441 |
| '1992-11-14',2506 |
| '1995-03-09',2567 |
| '1998-01-27',2626 |
| '1993-09-06',2589 |
| '1994-03-26',2493 |
| '1996-12-13',2449 |
| '1997-08-12',2528 |
| '1995-04-01',2496 |
| '1995-06-12',2481 |
| '1998-09-06',2105 |
| '1993-01-27',2440 |
| '1995-11-06',2546 |
| '1997-02-20',2543 |
| '1992-01-08',18 |
| '1994-09-14',2583 |
| '1994-11-29',2445 |
| '1992-04-13',1838 |
| '1996-05-07',2482 |
| '1996-07-14',2485 |
| '1997-05-28',2443 |
| '1995-09-19',2476 |
| '1998-09-24',1724 |
| '1998-11-19',577 |
| '1995-11-24',2558 |
| '1993-01-05',2466 |
| '1993-03-16',2497 |
| '1997-02-02',2578 |
| '1996-05-25',2461 |
| '1997-07-19',2420 |
| '1992-06-22',2384 |
| '1996-10-22',2538 |
| '1994-01-17',2378 |
| '1998-03-16',2416 |
| '1997-08-30',2464 |
| '1996-12-31',2535 |
| '1993-11-19',2562 |
| '1994-03-04',2443 |
| '1998-01-05',2498 |
| '1993-09-24',2526 |
| '1995-04-23',2496 |
| '1995-06-30',2473 |
| '1996-07-26',2441 |
| '1992-04-21',1964 |
| '1997-07-09',2614 |
| '1997-02-12',2486 |
| '1993-03-06',2475 |
| '1994-09-26',2466 |
| '1998-11-09',801 |
| '1992-03-29',1470 |
| '1993-01-15',2437 |
| '1995-09-09',2587 |
| '1995-06-20',2575 |
| '1995-01-28',2437 |
| '1998-01-15',2467 |
| '1994-03-14',2465 |
| '1993-11-09',2557 |
| '1996-12-21',2605 |
| '1997-08-20',2518 |
| '1998-03-06',2418 |
| '1992-11-26',2462 |
| '1994-01-07',2445 |
| '1995-06-02',2598 |
| '1995-04-11',2528 |
| '1997-08-02',2420 |
| '1996-12-03',2489 |
| '1993-09-16',2395 |
| '1996-10-10',2530 |
| '1992-11-04',2479 |
| '1998-03-24',2478 |
| '1995-03-19',2464 |
| '1994-01-25',2442 |
| '1996-07-04',2511 |
| '1992-06-10',2414 |
| '1996-05-17',2447 |
| '1992-04-03',1603 |
| '1992-01-18',87 |
| '1993-03-24',2458 |
| '1994-09-04',2465 |
| '1998-09-16',1932 |
| '1995-11-16',2508 |
| '1993-04-26',2428 |
| '1997-07-21',2498 |
| '1992-04-09',1748 |
| '1992-01-12',25 |
| '1998-11-21',554 |
| '1995-09-21',2531 |
| '1992-03-01',926 |
| '1996-02-15',2453 |
| '1995-06-08',2484 |
| '1998-04-26',2461 |
| '1994-06-27',2518 |
| '1997-08-08',2661 |
| '1996-12-09',2544 |
| '1993-11-21',2455 |
| '1996-08-27',2428 |
| '1997-12-26',2409 |
| '1995-03-13',2486 |
| '1994-04-16',2497 |
| '1998-06-17',2513 |
| '1994-06-05',2520 |
| '1998-04-04',2507 |
| '1995-01-22',2501 |
| '1993-11-03',2481 |
| '1997-10-17',2422 |
| '1992-09-11',2401 |
| '1995-03-31',2525 |
| '1997-12-04',2421 |
| '1996-08-05',2467 |
| '1993-04-04',2471 |
| '1997-05-10',2477 |
| '1993-06-17',2426 |
| '1997-07-03',2390 |
| '1997-02-18',2529 |
| '1992-01-30',260 |
| '1994-11-11',2436 |
| '1992-03-23',1364 |
| '1998-11-03',900 |
| '1995-09-03',2495 |
| '1998-04-20',2437 |
| '1994-06-21',2511 |
| '1993-11-27',2514 |
| '1995-01-06',2509 |
| '1997-12-20',2458 |
| '1996-08-21',2502 |
| '1995-03-15',2452 |
| '1998-03-28',2464 |
| '1992-11-08',2511 |
| '1994-01-29',2438 |
| '1996-07-08',2463 |
| '1993-04-20',2554 |
| '1997-07-27',2431 |
| '1992-01-14',48 |
| '1993-03-28',2522 |
| '1994-09-08',2546 |
| '1992-03-07',1043 |
| '1995-09-27',2524 |
| '1998-11-27',442 |
| '1996-02-13',2509 |
| '1993-04-02',2561 |
| '1997-05-16',2546 |
| '1993-06-11',2425 |
| '1997-07-05',2566 |
| '1994-11-17',2483 |
| '1995-09-05',2542 |
| '1998-11-05',916 |
| '1993-01-19',2448 |
| '1992-03-25',1418 |
| '1994-04-10',2505 |
| '1998-06-11',2510 |
| '1998-04-02',2520 |
| '1994-06-03',2552 |
| '1993-11-05',2470 |
| '1994-03-18',2527 |
| '1995-01-24',2452 |
| '1998-01-19',2535 |
| '1997-10-11',2496 |
| '1992-09-17',2604 |
| '1997-12-02',2449 |
| '1996-08-03',2399 |
| '1995-06-26',2486 |
| '1994-06-09',2452 |
| '1998-04-08',2496 |
| '1998-01-13',2450 |
| '1994-03-12',2547 |
| '1996-12-27',2503 |
| '1997-08-26',2543 |
| '1992-11-20',2397 |
| '1994-01-01',2508 |
| '1996-08-09',2475 |
| '1997-12-08',2549 |
| '1993-04-08',2473 |
| '1996-07-20',2521 |
| '1992-04-27',2021 |
| '1997-02-14',2486 |
| '1994-09-20',2554 |
| '1993-01-13',2480 |
| '1996-07-02',2542 |
| '1992-06-16',2469 |
| '1996-05-11',2470 |
| '1992-04-05',1696 |
| '1994-09-02',2425 |
| '1993-03-22',2531 |
| '1993-01-31',2510 |
| '1995-11-10',2570 |
| '1998-09-10',2012 |
| '1996-02-19',2507 |
| '1995-06-04',2544 |
| '1995-04-17',2472 |
| '1996-12-05',2534 |
| '1997-08-04',2516 |
| '1993-09-10',2458 |
| '1994-03-30',2537 |
| '1998-01-31',2584 |
| '1996-10-16',2538 |
| '1994-01-23',2316 |
| '1992-11-02',2448 |
| '1998-03-22',2451 |
| '1996-02-09',2506 |
| '1993-01-21',2554 |
| '1997-02-26',2593 |
| '1994-09-12',2503 |
| '1992-04-15',1864 |
| '1993-06-29',2568 |
| '1996-05-01',2512 |
| '1992-06-06',2527 |
| '1996-07-12',2577 |
| '1992-11-12',2420 |
| '1996-10-06',2626 |
| '1994-03-20',2527 |
| '1998-01-21',2586 |
| '1996-12-15',2545 |
| '1997-08-14',2476 |
| '1997-10-29',2527 |
| '1995-04-07',2559 |
| '1994-04-28',2525 |
| '1998-06-29',2469 |
| '1995-06-14',2462 |
| '1996-08-19',2486 |
| '1996-10-24',2432 |
| '1997-12-18',2582 |
| '1994-01-11',2499 |
| '1998-03-10',2406 |
| '1992-11-30',2436 |
| '1994-03-02',2488 |
| '1993-09-22',2554 |
| '1998-01-03',2456 |
| '1998-04-18',2521 |
| '1995-04-25',2569 |
| '1994-06-19',2497 |
| '1998-09-22',1867 |
| '1995-11-22',2518 |
| '1993-01-03',2474 |
| '1994-09-30',2546 |
| '1993-03-10',2505 |
| '1997-02-04',2579 |
| '1996-05-23',2481 |
| '1996-07-30',2520 |
| '1993-04-18',2448 |
| '1992-06-24',2457 |
| '1995-09-15',2624 |
| '1993-01-09',2524 |
| '1998-09-28',1646 |
| '1995-11-28',2485 |
| '1998-11-15',675 |
| '1996-02-21',2511 |
| '1994-11-07',2579 |
| '1992-01-26',203 |
| '1996-05-29',2549 |
| '1997-07-15',2486 |
| '1993-06-01',2453 |
| '1997-05-06',2460 |
| '1993-04-12',2399 |
| '1996-08-13',2449 |
| '1997-12-12',2477 |
| '1995-03-27',2495 |
| '1992-09-07',2431 |
| '1997-10-01',2463 |
| '1994-03-08',2483 |
| '1998-01-09',2529 |
| '1993-11-15',2462 |
| '1993-09-28',2528 |
| '1998-04-12',2473 |
| '1994-06-13',2518 |
| '1998-06-01',2486 |
| '1995-03-05',2490 |
| '1992-11-18',2552 |
| '1992-09-25',2406 |
| '1996-08-31',2467 |
| '1997-12-30',2501 |
| '1995-01-16',2526 |
| '1997-10-23',2479 |
| '1998-04-30',2544 |
| '1998-06-23',2466 |
| '1994-04-22',2479 |
| '1996-02-03',2461 |
| '1992-03-17',1161 |
| '1994-11-25',2490 |
| '1994-09-18',2454 |
| '1992-01-04',1 |
| '1993-06-23',2468 |
| '1993-04-30',2561 |
| '1997-05-24',2474 |
| '1996-07-18',2482 |
| '1994-04-20',2511 |
| '1998-06-21',2462 |
| '1997-10-21',2474 |
| '1998-01-29',2509 |
| '1994-03-28',2563 |
| '1993-09-08',2456 |
| '1995-01-14',2366 |
| '1992-09-27',2440 |
| '1995-03-07',2500 |
| '1997-05-26',2610 |
| '1996-05-09',2495 |
| '1993-06-21',2404 |
| '1994-11-27',2443 |
| '1992-01-06',5 |
| '1995-11-08',2508 |
| '1993-01-29',2412 |
| '1992-03-15',1228 |
| '1998-09-08',2142 |
| '1996-02-01',2570 |
| '1993-04-10',2565 |
| '1997-05-04',2442 |
| '1993-06-03',2541 |
| '1997-07-17',2430 |
| '1993-03-18',2490 |
| '1994-11-05',2483 |
| '1992-01-24',171 |
| '1996-02-23',2458 |
| '1995-09-17',2511 |
| '1998-11-17',622 |
| '1994-04-02',2513 |
| '1998-06-03',2546 |
| '1994-06-11',2486 |
| '1998-04-10',2506 |
| '1993-11-17',2505 |
| '1997-10-03',2384 |
| '1992-09-05',2502 |
| '1994-01-19',2384 |
| '1998-03-18',2438 |
| '1995-03-25',2469 |
| '1996-08-11',2578 |
| '1997-12-10',2495 |
| '1998-06-09',2560 |
| '1994-04-08',2368 |
| '1995-04-27',2497 |
| '1998-01-01',2525 |
| '1993-09-20',2452 |
| '1997-10-09',2440 |
| '1994-01-13',2509 |
| '1998-03-12',2462 |
| '1996-10-26',2584 |
| '1992-06-26',2418 |
| '1993-06-09',2464 |
| '1996-05-21',2447 |
| '1997-02-06',2563 |
| '1993-03-12',2427 |
| '1996-02-29',2450 |
| '1993-01-01',2422 |
| '1995-11-20',2548 |
| '1998-09-20',1866 |
| '1996-07-10',2490 |
| '1992-06-04',2481 |
| '1996-05-03',2440 |
| '1992-04-17',1913 |
| '1994-09-10',2484 |
| '1993-03-30',2432 |
| '1997-02-24',2481 |
| '1998-09-02',2160 |
| '1995-11-02',2555 |
| '1993-01-23',2608 |
| '1995-06-16',2548 |
| '1995-04-05',2520 |
| '1996-12-17',2468 |
| '1997-08-16',2498 |
| '1994-03-22',2532 |
| '1998-01-23',2449 |
| '1993-09-02',2517 |
| '1996-10-04',2513 |
| '1994-01-31',2464 |
| '1992-11-10',2541 |
| '1998-03-30',2531 |
| '1998-09-12',2075 |
| '1995-11-12',2505 |
| '1993-03-20',2597 |
| '1992-04-07',1663 |
| '1996-05-13',2518 |
| '1992-06-14',2423 |
| '1993-04-28',2555 |
| '1994-01-21',2487 |
| '1998-03-20',2506 |
| '1996-08-29',2485 |
| '1997-12-28',2349 |
| '1996-10-14',2472 |
| '1993-09-12',2510 |
| '1997-08-06',2550 |
| '1996-12-07',2376 |
| '1998-04-28',2511 |
| '1994-06-29',2486 |
| '1995-04-15',2538 |
| '1995-06-06',2446 |
| '1998-03-02',2474 |
| '1992-11-22',2435 |
| '1994-01-03',2520 |
| '1996-12-25',2579 |
| '1997-08-24',2523 |
| '1997-10-19',2453 |
| '1998-01-11',2516 |
| '1994-03-10',2460 |
| '1993-09-30',2562 |
| '1995-06-24',2547 |
| '1994-04-18',2484 |
| '1998-06-19',2479 |
| '1998-09-30',1588 |
| '1993-01-11',2382 |
| '1995-11-30',2581 |
| '1994-09-22',2477 |
| '1993-03-02',2585 |
| '1997-02-16',2438 |
| '1996-05-31',2481 |
| '1993-06-19',2384 |
| '1992-04-25',1997 |
| '1996-07-22',2489 |
| '1998-11-07',802 |
| '1995-09-07',2477 |
| '1992-03-27',1467 |
| '1993-03-08',2484 |
| '1994-11-15',2525 |
| '1994-09-28',2535 |
| '1997-07-07',2488 |
| '1993-06-13',2422 |
| '1996-07-28',2590 |
| '1997-05-14',2435 |
| '1996-08-01',2476 |
| '1998-03-08',2506 |
| '1994-01-09',2446 |
| '1992-11-28',2470 |
| '1992-09-15',2500 |
| '1997-10-13',2489 |
| '1995-01-26',2550 |
| '1993-11-07',2479 |
| '1994-06-01',2521 |
| '1998-06-13',2502 |
| '1994-04-12',2439 |
| '1995-03-17',2514 |
| '1996-08-23',2454 |
| '1997-12-22',2389 |
| '1995-01-04',2452 |
| '1993-09-18',2488 |
| '1993-11-25',2493 |
| '1997-10-31',2573 |
| '1994-06-23',2480 |
| '1998-04-22',2471 |
| '1994-04-30',2572 |
| '1996-02-11',2574 |
| '1995-09-25',2522 |
| '1998-11-25',457 |
| '1995-11-18',2493 |
| '1998-09-18',1844 |
| '1992-03-05',999 |
| '1992-01-16',65 |
| '1996-05-19',2495 |
| '1997-07-25',2586 |
| '1993-04-22',2458 |
| '1995-05-04',2475 |
| '1995-07-17',2567 |
| '1992-10-11',2430 |
| '1996-11-05',2467 |
| '1992-12-02',2508 |
| '1994-02-23',2506 |
| '1993-08-03',2484 |
| '1997-09-17',2536 |
| '1992-05-16',2404 |
| '1996-04-02',2459 |
| '1992-07-05',2447 |
| '1996-06-11',2579 |
| '1995-10-03',2550 |
| '1998-08-03',2405 |
| '1997-03-25',2510 |
| '1996-01-19',2432 |
| '1994-08-11',2492 |
| '1995-12-10',2542 |
| '1996-04-20',2507 |
| '1993-07-08',2480 |
| '1992-07-27',2479 |
| '1998-08-21',2393 |
| '1995-10-21',2497 |
| '1997-01-14',2481 |
| '1996-03-28',2529 |
| '1993-02-13',2466 |
| '1997-03-07',2507 |
| '1995-05-26',2536 |
| '1994-05-09',2493 |
| '1998-07-08',2479 |
| '1996-11-27',2592 |
| '1998-02-13',2534 |
| '1997-11-08',2554 |
| '1992-12-20',2491 |
| '1994-02-01',2457 |
| '1993-08-21',2479 |
| '1994-07-10',2487 |
| '1998-05-11',2554 |
| '1998-07-02',2427 |
| '1994-05-03',2549 |
| '1996-09-10',2391 |
| '1992-08-04',2388 |
| '1993-12-05',2526 |
| '1995-02-24',2588 |
| '1998-02-19',2416 |
| '1997-11-02',2493 |
| '1993-10-16',2499 |
| '1997-06-16',2539 |
| '1993-07-02',2462 |
| '1997-04-05',2531 |
| '1993-05-11',2496 |
| '1998-10-16',1287 |
| '1995-08-16',2535 |
| '1994-12-17',2490 |
| '1996-03-22',2435 |
| '1994-10-04',2521 |
| '1993-02-19',2384 |
| '1998-12-05',251 |
| '1996-01-31',2526 |
| '1993-07-20',2458 |
| '1996-04-08',2391 |
| '1997-04-27',2581 |
| '1998-08-09',2554 |
| '1995-10-09',2517 |
| '1992-02-14',581 |
| '1996-01-13',2517 |
| '1994-10-26',2483 |
| '1998-12-27',11 |
| '1998-07-20',2437 |
| '1994-05-21',2454 |
| '1995-02-06',2527 |
| '1992-08-26',2451 |
| '1993-12-27',2584 |
| '1992-12-08',2556 |
| '1993-08-09',2526 |
| '1997-11-20',2522 |
| '1996-01-03',2505 |
| '1995-10-19',2513 |
| '1994-12-25',2489 |
| '1998-08-19',2442 |
| '1998-10-24',1157 |
| '1995-08-24',2560 |
| '1992-02-04',373 |
| '1996-03-10',2478 |
| '1993-05-23',2609 |
| '1997-06-24',2565 |
| '1996-04-18',2474 |
| '1993-07-30',2503 |
| '1997-11-30',2498 |
| '1993-08-19',2513 |
| '1992-12-18',2533 |
| '1993-10-24',2473 |
| '1996-09-22',2558 |
| '1995-02-16',2485 |
| '1994-05-31',2498 |
| '1998-07-30',2534 |
| '1998-05-23',2551 |
| '1994-07-22',2521 |
| '1993-10-06',2494 |
| '1997-11-12',2476 |
| '1998-02-09',2516 |
| '1992-08-14',2525 |
| '1992-10-29',2558 |
| '1993-12-15',2546 |
| '1998-07-12',2548 |
| '1994-05-13',2551 |
| '1998-05-01',2500 |
| '1996-01-21',2486 |
| '1993-02-09',2459 |
| '1994-08-29',2533 |
| '1995-12-28',2502 |
| '1994-10-14',2444 |
| '1998-12-15',106 |
| '1995-08-06',2432 |
| '1994-12-07',2561 |
| '1998-10-06',1495 |
| '1992-02-26',829 |
| '1993-05-01',2455 |
| '1997-04-15',2591 |
| '1996-06-29',2606 |
| '1993-07-12',2409 |
| '1997-06-06',2485 |
| '1997-03-17',2457 |
| '1995-12-22',2487 |
| '1993-02-03',2533 |
| '1994-08-23',2595 |
| '1997-01-04',2549 |
| '1998-08-31',2291 |
| '1995-10-31',2554 |
| '1996-06-23',2510 |
| '1992-05-24',2482 |
| '1993-07-18',2533 |
| '1996-04-30',2485 |
| '1992-12-30',2451 |
| '1994-02-11',2525 |
| '1993-08-31',2450 |
| '1997-11-18',2438 |
| '1997-09-25',2507 |
| '1998-02-03',2511 |
| '1992-10-23',2463 |
| '1994-05-19',2531 |
| '1998-07-18',2482 |
| '1995-07-25',2428 |
| '1997-09-07',2537 |
| '1992-12-12',2434 |
| '1993-08-13',2446 |
| '1996-11-15',2580 |
| '1996-09-28',2500 |
| '1992-10-01',2447 |
| '1998-02-21',2546 |
| '1995-07-07',2509 |
| '1998-05-29',2490 |
| '1994-07-28',2454 |
| '1995-05-14',2592 |
| '1993-02-21',2504 |
| '1994-08-01',2387 |
| '1996-01-09',2467 |
| '1998-08-13',2432 |
| '1995-10-13',2533 |
| '1997-01-26',2439 |
| '1996-06-01',2498 |
| '1992-07-15',2460 |
| '1993-05-29',2476 |
| '1996-04-12',2527 |
| '1992-05-06',2229 |
| '1995-05-16',2444 |
| '1995-07-05',2498 |
| '1998-02-23',2492 |
| '1992-10-03',2475 |
| '1996-11-17',2553 |
| '1993-08-11',2538 |
| '1992-12-10',2373 |
| '1997-09-05',2522 |
| '1992-05-04',2252 |
| '1996-04-10',2549 |
| '1992-07-17',2510 |
| '1996-06-03',2509 |
| '1997-01-24',2563 |
| '1996-03-18',2513 |
| '1998-08-11',2470 |
| '1995-10-11',2537 |
| '1993-02-23',2519 |
| '1995-12-02',2545 |
| '1994-08-03',2529 |
| '1992-05-26',2465 |
| '1996-06-21',2389 |
| '1993-05-09',2484 |
| '1997-01-06',2519 |
| '1995-12-20',2498 |
| '1994-08-21',2461 |
| '1993-02-01',2503 |
| '1996-01-29',2536 |
| '1997-03-15',2568 |
| '1998-05-09',2488 |
| '1994-07-08',2488 |
| '1995-07-27',2442 |
| '1996-09-08',2486 |
| '1998-02-01',2602 |
| '1992-10-21',2554 |
| '1997-09-27',2518 |
| '1994-02-13',2474 |
| '1994-07-02',2477 |
| '1998-05-03',2603 |
| '1998-07-10',2511 |
| '1994-05-11',2454 |
| '1996-09-02',2507 |
| '1992-08-16',2521 |
| '1993-12-17',2455 |
| '1997-11-10',2478 |
| '1993-10-04',2470 |
| '1994-02-19',2539 |
| '1997-06-04',2489 |
| '1993-07-10',2512 |
| '1997-04-17',2414 |
| '1993-05-03',2467 |
| '1995-08-04',2430 |
| '1994-12-05',2524 |
| '1992-02-24',795 |
| '1998-10-04',1541 |
| '1996-03-30',2474 |
| '1994-10-16',2434 |
| '1998-12-17',81 |
| '1996-01-23',2455 |
| '1997-06-26',2497 |
| '1993-05-21',2505 |
| '1996-06-09',2507 |
| '1996-03-12',2512 |
| '1992-02-06',439 |
| '1998-10-26',1073 |
| '1994-12-27',2500 |
| '1995-08-26',2495 |
| '1996-01-01',2489 |
| '1994-08-09',2561 |
| '1995-12-08',2489 |
| '1998-05-21',2513 |
| '1994-07-20',2509 |
| '1992-10-09',2502 |
| '1995-02-14',2467 |
| '1996-09-20',2529 |
| '1993-10-26',2533 |
| '1998-12-25',17 |
| '1994-10-24',2571 |
| '1995-12-18',2457 |
| '1994-08-19',2534 |
| '1996-01-11',2471 |
| '1992-02-16',631 |
| '1996-03-02',2443 |
| '1997-04-25',2472 |
| '1996-06-19',2378 |
| '1993-05-31',2434 |
| '1993-07-22',2463 |
| '1997-11-22',2463 |
| '1996-09-30',2465 |
| '1995-02-04',2399 |
| '1993-12-25',2564 |
| '1992-08-24',2453 |
| '1992-10-19',2530 |
| '1994-05-23',2541 |
| '1998-07-22',2469 |
| '1994-07-30',2513 |
| '1998-05-31',2508 |
| '1993-10-14',2529 |
| '1994-02-09',2577 |
| '1992-12-28',2464 |
| '1993-08-29',2491 |
| '1992-08-06',2504 |
| '1993-12-07',2516 |
| '1995-02-26',2496 |
| '1996-09-12',2522 |
| '1994-05-01',2526 |
| '1998-05-13',2457 |
| '1994-07-12',2503 |
| '1994-10-06',2501 |
| '1998-12-07',228 |
| '1996-03-20',2441 |
| '1995-10-29',2481 |
| '1995-08-14',2474 |
| '1994-12-15',2501 |
| '1998-08-29',2234 |
| '1998-10-14',1348 |
| '1993-05-13',2475 |
| '1997-04-07',2387 |
| '1997-06-14',2466 |
| '1996-04-28',2476 |
| '1997-03-05',2503 |
| '1994-08-31',2503 |
| '1993-02-11',2467 |
| '1995-12-30',2448 |
| '1997-01-16',2474 |
| '1995-10-23',2566 |
| '1998-08-23',2368 |
| '1993-05-19',2426 |
| '1992-07-25',2455 |
| '1996-04-22',2425 |
| '1994-02-03',2462 |
| '1993-08-23',2492 |
| '1992-12-22',2476 |
| '1998-02-11',2527 |
| '1992-10-31',2491 |
| '1996-09-18',2473 |
| '1996-11-25',2461 |
| '1994-07-18',2476 |
| '1995-05-24',2455 |
| '1998-05-19',2589 |
| '1997-11-28',2434 |
| '1997-09-15',2419 |
| '1993-08-01',2391 |
| '1994-02-21',2497 |
| '1996-11-07',2446 |
| '1992-10-13',2462 |
| '1998-07-28',2426 |
| '1994-05-29',2438 |
| '1995-07-15',2574 |
| '1995-05-06',2495 |
| '1994-08-13',2451 |
| '1995-12-12',2476 |
| '1997-03-27',2471 |
| '1998-08-01',2561 |
| '1995-10-01',2519 |
| '1996-03-08',2416 |
| '1996-06-13',2606 |
| '1992-07-07',2558 |
| '1993-07-28',2441 |
| '1992-05-14',2394 |
| '1995-07-16',2534 |
| '1995-05-05',2502 |
| '1997-09-16',2469 |
| '1994-02-22',2451 |
| '1993-08-02',2497 |
| '1992-12-03',2517 |
| '1996-11-04',2559 |
| '1992-10-10',2538 |
| '1996-06-10',2525 |
| '1992-07-04',2516 |
| '1996-04-03',2456 |
| '1992-05-17',2370 |
| '1995-12-11',2533 |
| '1994-08-10',2530 |
| '1997-03-24',2467 |
| '1996-01-18',2524 |
| '1995-10-02',2492 |
| '1998-08-02',2451 |
| '1992-07-26',2499 |
| '1993-07-09',2525 |
| '1996-04-21',2464 |
| '1997-03-06',2553 |
| '1993-02-12',2456 |
| '1997-01-15',2537 |
| '1996-03-29',2465 |
| '1998-08-20',2310 |
| '1995-10-20',2599 |
| '1994-05-08',2571 |
| '1998-07-09',2501 |
| '1995-05-27',2468 |
| '1993-08-20',2554 |
| '1992-12-21',2385 |
| '1997-11-09',2471 |
| '1998-02-12',2495 |
| '1996-11-26',2466 |
| '1994-05-02',2459 |
| '1998-07-03',2400 |
| '1998-05-10',2441 |
| '1994-07-11',2501 |
| '1993-10-17',2478 |
| '1997-11-03',2459 |
| '1995-02-25',2441 |
| '1993-12-04',2448 |
| '1998-02-18',2452 |
| '1992-08-05',2469 |
| '1996-09-11',2511 |
| '1993-05-10',2495 |
| '1997-04-04',2484 |
| '1993-07-03',2514 |
| '1997-06-17',2497 |
| '1996-01-30',2490 |
| '1993-02-18',2535 |
| '1994-10-05',2477 |
| '1998-12-04',262 |
| '1996-03-23',2585 |
| '1995-08-17',2418 |
| '1994-12-16',2551 |
| '1998-10-17',1269 |
| '1997-04-26',2512 |
| '1996-04-09',2421 |
| '1993-07-21',2505 |
| '1994-10-27',2508 |
| '1998-12-26',22 |
| '1996-01-12',2521 |
| '1998-08-08',2515 |
| '1995-10-08',2694 |
| '1992-02-15',625 |
| '1996-03-01',2452 |
| '1994-05-20',2574 |
| '1998-07-21',2454 |
| '1997-11-21',2439 |
| '1994-02-28',2517 |
| '1992-12-09',2449 |
| '1993-08-08',2404 |
| '1992-08-27',2467 |
| '1993-12-26',2449 |
| '1995-02-07',2513 |
| '1996-03-11',2472 |
| '1994-12-24',2506 |
| '1998-10-25',1109 |
| '1995-10-18',2616 |
| '1995-08-25',2518 |
| '1998-08-18',2414 |
| '1992-02-05',413 |
| '1996-01-02',2426 |
| '1993-07-31',2463 |
| '1997-06-25',2497 |
| '1996-04-19',2501 |
| '1993-05-22',2470 |
| '1995-02-17',2502 |
| '1996-09-23',2534 |
| '1992-12-19',2451 |
| '1993-08-18',2557 |
| '1993-10-25',2449 |
| '1998-05-22',2504 |
| '1994-07-23',2407 |
| '1994-05-30',2449 |
| '1998-07-31',2497 |
| '1996-09-01',2526 |
| '1998-02-08',2519 |
| '1992-08-15',2506 |
| '1992-10-28',2494 |
| '1993-12-14',2555 |
| '1997-11-13',2504 |
| '1993-10-07',2569 |
| '1994-07-01',2420 |
| '1994-05-12',2519 |
| '1998-07-13',2569 |
| '1998-10-07',1432 |
| '1995-08-07',2492 |
| '1994-12-06',2488 |
| '1992-02-27',832 |
| '1993-02-08',2567 |
| '1994-08-28',2484 |
| '1995-12-29',2557 |
| '1994-10-15',2495 |
| '1998-12-14',114 |
| '1996-01-20',2477 |
| '1997-06-07',2472 |
| '1993-07-13',2527 |
| '1996-06-28',2401 |
| '1997-04-14',2494 |
| '1998-08-30',2259 |
| '1995-10-30',2470 |
| '1997-01-05',2549 |
| '1993-02-02',2488 |
| '1994-08-22',2444 |
| '1995-12-23',2471 |
| '1997-03-16',2509 |
| '1992-05-25',2500 |
| '1993-07-19',2454 |
| '1996-06-22',2511 |
| '1998-02-02',2491 |
| '1992-10-22',2523 |
| '1997-11-19',2534 |
| '1997-09-24',2570 |
| '1992-12-31',2550 |
| '1994-02-10',2413 |
| '1993-08-30',2455 |
| '1998-07-19',2534 |
| '1994-05-18',2610 |
| '1995-07-24',2551 |
| '1998-02-20',2508 |
| '1996-11-14',2534 |
| '1996-09-29',2391 |
| '1992-12-13',2436 |
| '1993-08-12',2519 |
| '1997-09-06',2594 |
| '1998-05-28',2571 |
| '1994-07-29',2541 |
| '1995-05-15',2555 |
| '1995-07-06',2466 |
| '1997-01-27',2456 |
| '1995-10-12',2551 |
| '1998-08-12',2535 |
| '1996-01-08',2518 |
| '1993-02-20',2474 |
| '1995-12-01',2470 |
| '1992-05-07',2266 |
| '1996-04-13',2400 |
| '1992-07-14',2520 |
| '1993-05-28',2568 |
| '1995-07-04',2476 |
| '1995-05-17',2516 |
| '1997-09-04',2493 |
| '1992-12-11',2523 |
| '1993-08-10',2534 |
| '1996-11-16',2504 |
| '1992-10-02',2469 |
| '1998-02-22',2549 |
| '1996-06-02',2534 |
| '1992-07-16',2523 |
| '1996-04-11',2481 |
| '1992-05-05',2202 |
| '1993-02-22',2483 |
| '1994-08-02',2469 |
| '1995-12-03',2496 |
| '1998-08-10',2575 |
| '1995-10-10',2528 |
| '1997-01-25',2538 |
| '1996-03-19',2554 |
| '1993-05-08',2428 |
| '1996-06-20',2463 |
| '1992-05-27',2556 |
| '1997-03-14',2559 |
| '1996-01-28',2452 |
| '1995-12-21',2539 |
| '1994-08-20',2457 |
| '1997-01-07',2543 |
| '1995-07-26',2619 |
| '1998-05-08',2482 |
| '1994-07-09',2467 |
| '1994-02-12',2513 |
| '1997-09-26',2576 |
| '1992-10-20',2619 |
| '1996-09-09',2408 |
| '1998-07-11',2478 |
| '1994-05-10',2573 |
| '1994-07-03',2489 |
| '1998-05-02',2494 |
| '1993-10-05',2440 |
| '1994-02-18',2561 |
| '1997-11-11',2364 |
| '1993-12-16',2465 |
| '1992-08-17',2486 |
| '1996-09-03',2523 |
| '1993-05-02',2453 |
| '1997-04-16',2491 |
| '1993-07-11',2435 |
| '1997-06-05',2660 |
| '1996-01-22',2487 |
| '1994-10-17',2489 |
| '1998-12-16',88 |
| '1996-03-31',2492 |
| '1994-12-04',2452 |
| '1992-02-25',771 |
| '1995-08-05',2564 |
| '1998-10-05',1540 |
| '1996-06-08',2433 |
| '1993-05-20',2429 |
| '1997-06-27',2389 |
| '1994-08-08',2364 |
| '1993-02-28',2443 |
| '1995-12-09',2532 |
| '1994-12-26',2399 |
| '1995-08-27',2488 |
| '1998-10-27',1086 |
| '1992-02-07',448 |
| '1996-03-13',2472 |
| '1998-05-20',2512 |
| '1994-07-21',2553 |
| '1993-10-27',2438 |
| '1996-09-21',2584 |
| '1995-02-15',2489 |
| '1998-02-28',2418 |
| '1992-10-08',2484 |
| '1996-03-03',2498 |
| '1992-02-17',600 |
| '1996-01-10',2532 |
| '1994-10-25',2451 |
| '1995-12-19',2428 |
| '1994-08-18',2420 |
| '1998-12-24',21 |
| '1993-07-23',2477 |
| '1993-05-30',2501 |
| '1996-06-18',2522 |
| '1997-04-24',2511 |
| '1992-08-25',2580 |
| '1993-12-24',2418 |
| '1995-02-05',2457 |
| '1992-10-18',2450 |
| '1997-11-23',2507 |
| '1998-05-30',2456 |
| '1994-07-31',2441 |
| '1998-07-23',2573 |
| '1994-05-22',2497 |
| '1996-09-13',2452 |
| '1993-12-06',2408 |
| '1992-08-07',2451 |
| '1995-02-27',2535 |
| '1997-11-01',2540 |
| '1994-02-08',2417 |
| '1992-12-29',2442 |
| '1993-08-28',2500 |
| '1993-10-15',2481 |
| '1998-05-12',2550 |
| '1994-07-13',2517 |
| '1998-07-01',2448 |
| '1998-08-28',2241 |
| '1994-12-14',2496 |
| '1998-10-15',1282 |
| '1995-10-28',2443 |
| '1995-08-15',2545 |
| '1996-03-21',2572 |
| '1994-10-07',2584 |
| '1998-12-06',239 |
| '1997-06-15',2517 |
| '1996-04-29',2419 |
| '1993-07-01',2478 |
| '1997-04-06',2479 |
| '1993-05-12',2402 |
| '1998-08-22',2360 |
| '1995-10-22',2511 |
| '1997-01-17',2443 |
| '1994-08-30',2442 |
| '1995-12-31',2393 |
| '1993-02-10',2492 |
| '1997-03-04',2604 |
| '1996-04-23',2568 |
| '1996-06-30',2490 |
| '1993-05-18',2518 |
| '1992-07-24',2416 |
| '1996-09-19',2539 |
| '1996-11-24',2554 |
| '1998-02-10',2474 |
| '1992-10-30',2523 |
| '1993-08-22',2507 |
| '1994-02-02',2511 |
| '1992-12-23',2470 |
| '1998-05-18',2520 |
| '1994-07-19',2568 |
| '1995-05-25',2533 |
| '1992-10-12',2514 |
| '1996-11-06',2488 |
| '1994-02-20',2452 |
| '1992-12-01',2480 |
| '1997-11-29',2518 |
| '1997-09-14',2520 |
| '1995-05-07',2518 |
| '1994-05-28',2423 |
| '1998-07-29',2479 |
| '1995-07-14',2423 |
| '1996-03-09',2447 |
| '1997-03-26',2522 |
| '1994-08-12',2517 |
| '1995-12-13',2545 |
| '1992-05-15',2367 |
| '1993-07-29',2488 |
| '1996-04-01',2493 |
| '1992-07-06',2438 |
| '1996-06-12',2488 |
| '1994-06-20',2580 |
| '1998-04-21',2494 |
| '1998-03-29',2451 |
| '1994-01-28',2504 |
| '1995-03-14',2444 |
| '1992-11-09',2452 |
| '1997-12-21',2433 |
| '1996-08-20',2454 |
| '1995-01-07',2418 |
| '1993-11-26',2472 |
| '1997-07-26',2503 |
| '1993-04-21',2581 |
| '1996-07-09',2558 |
| '1996-02-12',2511 |
| '1998-11-26',441 |
| '1995-09-26',2436 |
| '1992-03-06',1030 |
| '1994-09-09',2458 |
| '1993-03-29',2489 |
| '1992-01-15',59 |
| '1997-07-04',2520 |
| '1993-06-10',2441 |
| '1997-05-17',2454 |
| '1993-04-03',2511 |
| '1995-09-04',2479 |
| '1993-01-18',2504 |
| '1998-11-04',912 |
| '1992-03-24',1386 |
| '1994-11-16',2562 |
| '1994-06-02',2414 |
| '1998-04-03',2457 |
| '1994-04-11',2494 |
| '1998-06-10',2515 |
| '1997-12-03',2437 |
| '1996-08-02',2510 |
| '1992-09-16',2457 |
| '1997-10-10',2499 |
| '1998-01-18',2585 |
| '1994-03-19',2441 |
| '1995-01-25',2488 |
| '1993-11-04',2528 |
| '1994-06-08',2478 |
| '1998-04-09',2490 |
| '1995-06-27',2521 |
| '1996-08-08',2493 |
| '1997-12-09',2520 |
| '1992-11-21',2497 |
| '1998-03-01',2492 |
| '1997-08-27',2503 |
| '1996-12-26',2472 |
| '1998-01-12',2495 |
| '1994-03-13',2432 |
| '1992-04-26',2134 |
| '1996-07-21',2477 |
| '1993-04-09',2523 |
| '1993-01-12',2445 |
| '1994-09-21',2589 |
| '1993-03-01',2478 |
| '1997-02-15',2516 |
| '1992-04-04',1733 |
| '1996-05-10',2458 |
| '1992-06-17',2490 |
| '1996-07-03',2510 |
| '1996-02-18',2489 |
| '1993-01-30',2435 |
| '1995-11-11',2518 |
| '1998-09-11',1947 |
| '1993-03-23',2463 |
| '1994-09-03',2559 |
| '1995-04-16',2535 |
| '1995-06-05',2483 |
| '1992-11-03',2431 |
| '1994-01-22',2514 |
| '1998-03-23',2461 |
| '1996-10-17',2433 |
| '1994-03-31',2543 |
| '1998-01-30',2440 |
| '1993-09-11',2439 |
| '1997-08-05',2580 |
| '1996-12-04',2558 |
| '1994-09-13',2476 |
| '1997-02-27',2506 |
| '1995-11-01',2428 |
| '1993-01-20',2481 |
| '1998-09-01',2221 |
| '1996-02-08',2496 |
| '1996-07-13',2578 |
| '1992-06-07',2486 |
| '1992-04-14',1797 |
| '1993-06-28',2410 |
| '1997-10-28',2430 |
| '1997-08-15',2513 |
| '1996-12-14',2435 |
| '1993-09-01',2537 |
| '1998-01-20',2427 |
| '1994-03-21',2490 |
| '1996-10-07',2534 |
| '1992-11-13',2430 |
| '1995-06-15',2534 |
| '1998-06-28',2466 |
| '1994-04-29',2469 |
| '1995-04-06',2529 |
| '1998-01-02',2443 |
| '1993-09-23',2500 |
| '1994-03-03',2534 |
| '1998-03-11',2579 |
| '1994-01-10',2532 |
| '1996-08-18',2535 |
| '1996-10-25',2452 |
| '1997-12-19',2544 |
| '1995-04-24',2622 |
| '1998-04-19',2480 |
| '1994-06-18',2554 |
| '1997-02-05',2481 |
| '1993-03-11',2495 |
| '1993-01-02',2469 |
| '1995-11-23',2523 |
| '1998-09-23',1805 |
| '1992-06-25',2467 |
| '1993-04-19',2411 |
| '1996-07-31',2421 |
| '1996-05-22',2452 |
| '1994-11-06',2506 |
| '1992-01-27',243 |
| '1996-02-20',2523 |
| '1993-01-08',2543 |
| '1998-11-14',709 |
| '1995-09-14',2502 |
| '1995-11-29',2506 |
| '1998-09-29',1610 |
| '1993-04-13',2460 |
| '1997-05-07',2521 |
| '1996-05-28',2477 |
| '1997-07-14',2493 |
| '1993-09-29',2478 |
| '1993-11-14',2474 |
| '1998-01-08',2508 |
| '1994-03-09',2516 |
| '1995-03-26',2462 |
| '1992-09-06',2571 |
| '1997-12-13',2458 |
| '1996-08-12',2506 |
| '1994-04-01',2441 |
| '1994-06-12',2499 |
| '1998-04-13',2502 |
| '1997-10-22',2514 |
| '1995-01-17',2376 |
| '1997-12-31',2468 |
| '1996-08-30',2482 |
| '1992-11-19',2525 |
| '1992-09-24',2382 |
| '1995-03-04',2509 |
| '1998-06-22',2552 |
| '1994-04-23',2523 |
| '1994-06-30',2558 |
| '1994-09-19',2438 |
| '1994-11-24',2481 |
| '1992-01-05',7 |
| '1992-03-16',1197 |
| '1996-02-02',2493 |
| '1996-07-19',2529 |
| '1997-05-25',2507 |
| '1993-06-22',2500 |
| '1994-04-21',2518 |
| '1998-06-20',2571 |
| '1995-03-06',2474 |
| '1992-09-26',2400 |
| '1998-01-28',2457 |
| '1994-03-29',2553 |
| '1995-01-15',2531 |
| '1993-09-09',2382 |
| '1997-10-20',2488 |
| '1993-06-20',2455 |
| '1996-05-08',2504 |
| '1997-05-27',2548 |
| '1995-11-09',2455 |
| '1992-03-14',1203 |
| '1998-09-09',2060 |
| '1993-01-28',2475 |
| '1994-11-26',2433 |
| '1992-01-07',10 |
| '1997-07-16',2553 |
| '1993-06-02',2431 |
| '1997-05-05',2588 |
| '1993-04-11',2491 |
| '1995-09-16',2565 |
| '1998-11-16',644 |
| '1996-02-22',2507 |
| '1993-03-19',2463 |
| '1992-01-25',179 |
| '1994-11-04',2548 |
| '1998-04-11',2544 |
| '1994-06-10',2501 |
| '1998-06-02',2497 |
| '1994-04-03',2515 |
| '1996-08-10',2468 |
| '1997-12-11',2503 |
| '1995-03-24',2518 |
| '1998-03-19',2482 |
| '1994-01-18',2551 |
| '1992-09-04',2440 |
| '1997-10-02',2475 |
| '1993-11-16',2572 |
| '1995-04-26',2526 |
| '1994-04-09',2474 |
| '1998-06-08',2484 |
| '1996-10-27',2556 |
| '1998-03-13',2444 |
| '1994-01-12',2484 |
| '1997-10-08',2433 |
| '1993-09-21',2590 |
| '1994-03-01',2505 |
| '1996-05-20',2460 |
| '1993-06-08',2361 |
| '1992-06-27',2500 |
| '1998-09-21',1761 |
| '1995-11-21',2574 |
| '1996-02-28',2388 |
| '1993-03-13',2432 |
| '1997-02-07',2544 |
| '1992-04-16',1941 |
| '1996-05-02',2528 |
| '1992-06-05',2480 |
| '1996-07-11',2462 |
| '1995-11-03',2481 |
| '1993-01-22',2421 |
| '1998-09-03',2122 |
| '1997-02-25',2526 |
| '1993-03-31',2425 |
| '1994-09-11',2567 |
| '1995-04-04',2509 |
| '1995-06-17',2566 |
| '1994-01-30',2379 |
| '1992-11-11',2590 |
| '1998-03-31',2466 |
| '1996-10-05',2545 |
| '1993-09-03',2559 |
| '1994-03-23',2601 |
| '1998-01-22',2511 |
| '1996-12-16',2561 |
| '1997-08-17',2419 |
| '1994-09-01',2539 |
| '1993-03-21',2513 |
| '1998-09-13',1932 |
| '1995-11-13',2465 |
| '1996-07-01',2521 |
| '1992-06-15',2447 |
| '1993-04-29',2563 |
| '1996-05-12',2505 |
| '1992-04-06',1681 |
| '1997-08-07',2488 |
| '1996-12-06',2473 |
| '1993-09-13',2458 |
| '1996-08-28',2434 |
| '1997-12-29',2430 |
| '1996-10-15',2514 |
| '1998-03-21',2617 |
| '1992-11-01',2565 |
| '1994-01-20',2478 |
| '1995-06-07',2573 |
| '1998-04-29',2471 |
| '1995-04-14',2530 |
| '1994-06-28',2547 |
| '1994-03-11',2501 |
| '1998-01-10',2433 |
| '1997-10-18',2515 |
| '1996-12-24',2489 |
| '1997-08-25',2565 |
| '1992-11-23',2513 |
| '1998-03-03',2400 |
| '1994-01-02',2531 |
| '1994-04-19',2526 |
| '1998-06-18',2458 |
| '1995-06-25',2602 |
| '1997-02-17',2466 |
| '1993-03-03',2493 |
| '1994-09-23',2538 |
| '1993-01-10',2555 |
| '1996-07-23',2472 |
| '1993-06-18',2554 |
| '1992-04-24',2077 |
| '1996-05-30',2423 |
| '1993-03-09',2519 |
| '1994-11-14',2400 |
| '1994-09-29',2526 |
| '1998-11-06',869 |
| '1995-09-06',2435 |
| '1992-03-26',1377 |
| '1993-04-01',2490 |
| '1997-05-15',2564 |
| '1996-07-29',2464 |
| '1993-06-12',2578 |
| '1997-07-06',2561 |
| '1995-01-27',2540 |
| '1993-11-06',2548 |
| '1997-10-12',2469 |
| '1992-09-14',2439 |
| '1992-11-29',2447 |
| '1994-01-08',2465 |
| '1998-03-09',2605 |
| '1997-12-01',2420 |
| '1994-04-13',2541 |
| '1998-06-12',2367 |
| '1998-04-01',2472 |
| '1997-10-30',2489 |
| '1993-11-24',2532 |
| '1995-01-05',2573 |
| '1993-09-19',2429 |
| '1997-12-23',2584 |
| '1996-08-22',2490 |
| '1995-03-16',2534 |
| '1998-06-30',2429 |
| '1998-04-23',2528 |
| '1994-06-22',2459 |
| '1992-01-17',75 |
| '1995-09-24',2505 |
| '1995-11-19',2598 |
| '1992-03-04',983 |
| '1998-09-19',1891 |
| '1998-11-24',492 |
| '1996-02-10',2474 |
| '1993-04-23',2603 |
| '1997-07-24',2387 |
| '1996-05-18',2533 |
| '1993-06-30',2398 |
| ---- TYPES |
| STRING, BIGINT |
| ==== |
| ---- QUERY: PERF_AGG-Q4 |
| -- This is interesting for looking at partitioned aggregation. |
| -- Ideally, we would like to have a column with more distinct values |
| -- but there are intermittent slow downs. l_suppkey is good enough |
| -- for now. |
| SELECT l_suppkey, count(*) as cnt |
| FROM lineitem |
| GROUP BY l_suppkey |
| ORDER BY l_suppkey, cnt |
| LIMIT 10 |
| ---- RESULTS |
| 1,625 |
| 2,557 |
| 3,587 |
| 4,586 |
| 5,601 |
| 6,562 |
| 7,601 |
| 8,578 |
| 9,547 |
| 10,602 |
| ---- TYPES |
| BIGINT, BIGINT |
| ==== |
| ---- QUERY: PERF_AGG-Q5 |
| -- This is a perf regression test for IMPALA-288. The goal of the query is to |
| -- be very selective - the filter will select only 2 rows from lineitem |
| -- across all scale factors. |
| select min(l_comment), count(*) from lineitem |
| where |
| l_shipmode = 'AIR' and l_linenumber = 3 and |
| l_orderkey > 1075680 and l_orderkey < 1075685 |
| ---- TYPES |
| STRING,BIGINT |
| ---- RESULTS |
| 'ffily even deposits. pending packages aff',2 |
| ==== |
| ---- QUERY: PERF_AGG-Q6 |
| -- The planner should recognize that only c1 and c2 are being materialized from |
| -- the inline-view. This will provide a significant performance improvement on |
| -- Parquet format tables. |
| SELECT v1.c1, v1.c2 |
| FROM (SELECT |
| sum(l_orderkey) as c1, |
| sum(l_partkey) as c2, |
| sum(l_suppkey) as c3, |
| sum(l_linenumber) as c4, |
| sum(l_quantity) as c5, |
| sum(l_extendedprice) as c6, |
| sum(l_discount) as c7, |
| sum(l_tax) as c8 FROM lineitem |
| ) v1 |
| ---- LABELS |
| C1, C2 |
| ---- RESULTS |
| 18005322964949,600229457837 |
| ---- TYPES |
| BIGINT, BIGINT |
| ==== |
| ---- QUERY: PERF_AGG-Q7 |
| -- Similar to PERF_AGG-Q6, but with a more complicated query that contains a |
| -- WITH clause and an inline-view. |
| WITH v2 as (SELECT v1.c1, v1.c2 |
| FROM (SELECT |
| sum(l_orderkey) as c1, |
| sum(l_partkey) as c2, |
| sum(l_suppkey) as c3, |
| sum(l_linenumber) as c4, |
| sum(l_quantity) as c5, |
| sum(l_extendedprice) as c6, |
| sum(l_discount) as c7, |
| sum(l_tax) as c8 FROM lineitem |
| ) v1) |
| SELECT c1, c2 from v2; |
| ---- LABELS |
| C1, C2 |
| ---- RESULTS |
| 18005322964949,600229457837 |
| ---- TYPES |
| BIGINT, BIGINT |
| ==== |
| ---- QUERY: PERF_AGG-Q8 |
| -- Query with multiple DISTINCT classes. |
| SELECT |
| count(distinct l_orderkey) agg1, |
| count(distinct l_partkey) agg2, |
| count(l_comment) agg3 |
| FROM |
| lineitem |
| ---- LABELS |
| AGG1,AGG2,AGG3 |
| ---- RESULTS |
| 1500000,200000,6001215 |
| ---- TYPES |
| BIGINT,BIGINT,BIGINT |
| ==== |
| ---- QUERY: PERF_AGG-Q9 |
| -- Query with multiple DISTINCT classes and outer group by. |
| SELECT |
| count(distinct l_orderkey) agg1, |
| count(distinct l_partkey) agg2, |
| count(l_comment) agg3 |
| FROM |
| lineitem |
| GROUP BY l_shipmode |
| ---- LABELS |
| AGG1,AGG2,AGG3 |
| ---- RESULTS |
| 651562,197327,857324 |
| 651000,197338,856484 |
| 650624,197228,856998 |
| 652393,197228,858104 |
| 651159,197241,856868 |
| 651548,197267,857401 |
| 651953,197337,858036 |
| ----TYPES |
| BIGINT,BIGINT,BIGINT |
| ==== |