PREVIEW / stock_30min / 2006-12-04
file: by_date/stock_30min/2006/2006-12-04.parquet size: 993 KB rows: 53,348 symbols: 2,473
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2006-12-04 06:00:00 | AAPL | Stock | 3.2718 | 3.2718 | 3.2646 | 3.2646 | 22400.0 |
| 2006-12-04 07:30:00 | AAPL | Stock | 3.2607 | 3.2725 | 3.2607 | 3.2725 | 15400.0 |
| 2006-12-04 08:00:00 | AAPL | Stock | 3.2643 | 3.2846 | 3.2611 | 3.2814 | 2427124.0 |
| 2006-12-04 08:30:00 | AAPL | Stock | 3.2814 | 3.2818 | 3.2614 | 3.2782 | 1110424.0 |
| 2006-12-04 09:00:00 | AAPL | Stock | 3.2786 | 3.2821 | 3.2693 | 3.2814 | 1333556.0 |
| 2006-12-04 09:30:00 | AAPL | Stock | 3.2814 | 3.2829 | 3.2411 | 3.25 | 113749328.0 |
| 2006-12-04 10:00:00 | AAPL | Stock | 3.25 | 3.2739 | 3.2393 | 3.24 | 86440844.0 |
| 2006-12-04 10:30:00 | AAPL | Stock | 3.2396 | 3.2518 | 3.2321 | 3.2478 | 70943908.0 |
| 2006-12-04 11:00:00 | AAPL | Stock | 3.2479 | 3.2639 | 3.2432 | 3.2554 | 58924908.0 |
| 2006-12-04 11:30:00 | AAPL | Stock | 3.2554 | 3.2557 | 3.2446 | 3.25 | 24612140.0 |
| 2006-12-04 12:00:00 | AAPL | Stock | 3.2496 | 3.2557 | 3.2411 | 3.2429 | 30058812.0 |
| 2006-12-04 12:30:00 | AAPL | Stock | 3.2425 | 3.2507 | 3.2411 | 3.2486 | 19636904.0 |
| 2006-12-04 13:00:00 | AAPL | Stock | 3.2485 | 3.2593 | 3.2454 | 3.2497 | 29827896.0 |
| 2006-12-04 13:30:00 | AAPL | Stock | 3.25 | 3.2757 | 3.2496 | 3.27 | 52301284.0 |
| 2006-12-04 14:00:00 | AAPL | Stock | 3.27 | 3.2732 | 3.2607 | 3.2654 | 31927560.0 |
| 2006-12-04 14:30:00 | AAPL | Stock | 3.2654 | 3.28 | 3.2643 | 3.2779 | 40864236.0 |
| 2006-12-04 15:00:00 | AAPL | Stock | 3.2775 | 3.2875 | 3.2689 | 3.2696 | 58173024.0 |
| 2006-12-04 15:30:00 | AAPL | Stock | 3.2696 | 3.275 | 3.2511 | 3.2543 | 79612540.0 |
| 2006-12-04 16:00:00 | AAPL | Stock | 3.2532 | 3.2587 | 3.2507 | 3.255 | 1038940.0 |
| 2006-12-04 16:30:00 | AAPL | Stock | 3.2539 | 3.2712 | 3.2536 | 3.2536 | 393960.0 |
| 2006-12-04 17:00:00 | AAPL | Stock | 3.2536 | 3.2546 | 3.2529 | 3.2529 | 178136.0 |
| 2006-12-04 17:30:00 | AAPL | Stock | 3.2525 | 3.2539 | 3.2525 | 3.2532 | 111580.0 |
| 2006-12-04 18:00:00 | AAPL | Stock | 3.2543 | 3.2543 | 3.2518 | 3.2536 | 133728.0 |
| 2006-12-04 18:30:00 | AAPL | Stock | 3.2539 | 3.2543 | 3.2518 | 3.2529 | 134960.0 |
| 2006-12-04 19:00:00 | AAPL | Stock | 3.2529 | 3.2529 | 3.2507 | 3.2507 | 223916.0 |
| 2006-12-04 19:30:00 | AAPL | Stock | 3.2514 | 3.2536 | 3.2511 | 3.2536 | 67928.0 |
| 2006-12-04 08:00:00 | MSFT | Stock | 29.18 | 29.18 | 29.1 | 29.13 | 6079.0 |
| 2006-12-04 08:30:00 | MSFT | Stock | 29.12 | 29.13 | 29.1 | 29.1 | 33907.0 |
| 2006-12-04 09:00:00 | MSFT | Stock | 29.12 | 29.23 | 29.11 | 29.23 | 182361.0 |
| 2006-12-04 09:30:00 | MSFT | Stock | 29.23 | 29.37 | 29.17 | 29.28 | 6399196.0 |
| 2006-12-04 10:00:00 | MSFT | Stock | 29.28 | 29.44 | 29.26 | 29.381 | 6960856.0 |
| 2006-12-04 10:30:00 | MSFT | Stock | 29.39 | 29.43 | 29.32 | 29.37 | 4421149.0 |
| 2006-12-04 11:00:00 | MSFT | Stock | 29.37 | 29.44 | 29.34 | 29.35 | 4378380.0 |
| 2006-12-04 11:30:00 | MSFT | Stock | 29.348 | 29.39 | 29.33 | 29.35 | 1443064.0 |
| 2006-12-04 12:00:00 | MSFT | Stock | 29.353 | 29.39 | 29.34 | 29.35 | 1522660.0 |
| 2006-12-04 12:30:00 | MSFT | Stock | 29.36 | 29.39 | 29.34 | 29.39 | 1422135.0 |
| 2006-12-04 13:00:00 | MSFT | Stock | 29.39 | 29.4 | 29.33 | 29.333 | 2371358.0 |
| 2006-12-04 13:30:00 | MSFT | Stock | 29.33 | 29.41 | 29.33 | 29.33 | 3464968.0 |
| 2006-12-04 14:00:00 | MSFT | Stock | 29.33 | 29.46 | 29.33 | 29.46 | 2913336.0 |
| 2006-12-04 14:30:00 | MSFT | Stock | 29.46 | 29.51 | 29.35 | 29.5 | 6016973.0 |
| 2006-12-04 15:00:00 | MSFT | Stock | 29.51 | 29.52 | 29.37 | 29.4 | 4791499.0 |
| 2006-12-04 15:30:00 | MSFT | Stock | 29.39 | 29.4 | 29.31 | 29.33 | 5851773.0 |
| 2006-12-04 16:00:00 | MSFT | Stock | 29.33 | 29.33 | 29.27 | 29.29 | 105124.0 |
| 2006-12-04 16:30:00 | MSFT | Stock | 29.399 | 29.399 | 29.29 | 29.29 | 3800.0 |
| 2006-12-04 17:00:00 | MSFT | Stock | 29.3 | 29.32 | 29.3 | 29.32 | 5200.0 |
| 2006-12-04 17:30:00 | MSFT | Stock | 29.3 | 29.3 | 29.3 | 29.3 | 460.0 |
| 2006-12-04 18:00:00 | MSFT | Stock | 29.33 | 29.33 | 29.33 | 29.33 | 2313.0 |
| 2006-12-04 18:30:00 | MSFT | Stock | 29.33 | 29.33 | 29.33 | 29.33 | 9469.0 |
| 2006-12-04 19:00:00 | MSFT | Stock | 29.33 | 29.33 | 29.33 | 29.33 | 100.0 |
| 2006-12-04 19:30:00 | MSFT | Stock | 29.32 | 29.32 | 29.3 | 29.3 | 2998.0 |
> showing 50 of 53,348 rows — these rows as CSV