PREVIEW / stock_5min / 2008-11-04
file: by_date/stock_5min/2008/2008-11-04.parquet size: 4.5 MB rows: 320,727 symbols: 3,316
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 |
|---|---|---|---|---|---|---|---|
| 2008-11-04 05:10:00 | AAPL | Stock | 3.8904 | 3.8904 | 3.8904 | 3.8904 | 8400.0 |
| 2008-11-04 06:05:00 | AAPL | Stock | 3.8786 | 3.8786 | 3.8786 | 3.8786 | 2800.0 |
| 2008-11-04 06:55:00 | AAPL | Stock | 3.9239 | 3.9239 | 3.9239 | 3.9239 | 14000.0 |
| 2008-11-04 07:00:00 | AAPL | Stock | 3.9239 | 3.9243 | 3.9143 | 3.9214 | 50568.0 |
| 2008-11-04 07:05:00 | AAPL | Stock | 3.9214 | 3.9261 | 3.9207 | 3.9207 | 29372.0 |
| 2008-11-04 07:15:00 | AAPL | Stock | 3.9175 | 3.9175 | 3.9107 | 3.9107 | 16520.0 |
| 2008-11-04 07:20:00 | AAPL | Stock | 3.9071 | 3.9121 | 3.9071 | 3.9121 | 6272.0 |
| 2008-11-04 07:25:00 | AAPL | Stock | 3.9175 | 3.9232 | 3.9175 | 3.9232 | 34580.0 |
| 2008-11-04 07:30:00 | AAPL | Stock | 3.9268 | 3.9268 | 3.9161 | 3.9161 | 80220.0 |
| 2008-11-04 07:35:00 | AAPL | Stock | 3.9111 | 3.9111 | 3.9107 | 3.9107 | 256424.0 |
| 2008-11-04 07:40:00 | AAPL | Stock | 3.9107 | 3.925 | 3.9071 | 3.9107 | 192640.0 |
| 2008-11-04 07:45:00 | AAPL | Stock | 3.9071 | 3.9071 | 3.9 | 3.9 | 91000.0 |
| 2008-11-04 07:50:00 | AAPL | Stock | 3.8946 | 3.8946 | 3.8929 | 3.8929 | 141484.0 |
| 2008-11-04 07:55:00 | AAPL | Stock | 3.8911 | 3.9018 | 3.8911 | 3.8911 | 63000.0 |
| 2008-11-04 08:00:00 | AAPL | Stock | 3.8918 | 3.8964 | 3.8807 | 3.8807 | 746312.0 |
| 2008-11-04 08:05:00 | AAPL | Stock | 3.8804 | 3.8839 | 3.8696 | 3.8714 | 696444.0 |
| 2008-11-04 08:10:00 | AAPL | Stock | 3.8736 | 3.8839 | 3.8736 | 3.8821 | 275520.0 |
| 2008-11-04 08:15:00 | AAPL | Stock | 3.8793 | 3.8807 | 3.875 | 3.8804 | 178472.0 |
| 2008-11-04 08:20:00 | AAPL | Stock | 3.8782 | 3.8821 | 3.8782 | 3.8811 | 317800.0 |
| 2008-11-04 08:25:00 | AAPL | Stock | 3.8814 | 3.8904 | 3.8814 | 3.8875 | 309652.0 |
| 2008-11-04 08:30:00 | AAPL | Stock | 3.8889 | 3.8904 | 3.8825 | 3.8839 | 233128.0 |
| 2008-11-04 08:35:00 | AAPL | Stock | 3.8839 | 3.8861 | 3.8839 | 3.8846 | 162372.0 |
| 2008-11-04 08:40:00 | AAPL | Stock | 3.8861 | 3.8943 | 3.8861 | 3.8943 | 612192.0 |
| 2008-11-04 08:45:00 | AAPL | Stock | 3.8946 | 3.9029 | 3.8939 | 3.8993 | 313936.0 |
| 2008-11-04 08:50:00 | AAPL | Stock | 3.8986 | 3.9011 | 3.8964 | 3.8964 | 351260.0 |
| 2008-11-04 08:55:00 | AAPL | Stock | 3.8964 | 3.9018 | 3.8932 | 3.8982 | 605640.0 |
| 2008-11-04 09:00:00 | AAPL | Stock | 3.8989 | 3.9111 | 3.8982 | 3.9071 | 412720.0 |
| 2008-11-04 09:05:00 | AAPL | Stock | 3.9075 | 3.9107 | 3.9014 | 3.9018 | 595000.0 |
| 2008-11-04 09:10:00 | AAPL | Stock | 3.9029 | 3.9036 | 3.8929 | 3.9018 | 886592.0 |
| 2008-11-04 09:15:00 | AAPL | Stock | 3.9036 | 3.9036 | 3.8936 | 3.8961 | 326200.0 |
| 2008-11-04 09:20:00 | AAPL | Stock | 3.8946 | 3.9036 | 3.8936 | 3.9018 | 475020.0 |
| 2008-11-04 09:25:00 | AAPL | Stock | 3.9021 | 3.9279 | 3.9 | 3.9279 | 1964536.0 |
| 2008-11-04 09:30:00 | AAPL | Stock | 3.9279 | 3.9282 | 3.8786 | 3.8939 | 33451208.0 |
| 2008-11-04 09:35:00 | AAPL | Stock | 3.8939 | 3.9021 | 3.8571 | 3.8636 | 29290016.0 |
| 2008-11-04 09:40:00 | AAPL | Stock | 3.8643 | 3.8754 | 3.8471 | 3.8589 | 27602540.0 |
| 2008-11-04 09:45:00 | AAPL | Stock | 3.8593 | 3.8604 | 3.8314 | 3.8529 | 27800136.0 |
| 2008-11-04 09:50:00 | AAPL | Stock | 3.8529 | 3.8535 | 3.8214 | 3.8293 | 26019028.0 |
| 2008-11-04 09:55:00 | AAPL | Stock | 3.8296 | 3.8386 | 3.8096 | 3.8321 | 23937592.0 |
| 2008-11-04 10:00:00 | AAPL | Stock | 3.8321 | 3.8568 | 3.8204 | 3.8543 | 16647960.0 |
| 2008-11-04 10:05:00 | AAPL | Stock | 3.8543 | 3.8571 | 3.8329 | 3.8429 | 15382332.0 |
| 2008-11-04 10:10:00 | AAPL | Stock | 3.8436 | 3.8561 | 3.8382 | 3.8457 | 13256628.0 |
| 2008-11-04 10:15:00 | AAPL | Stock | 3.8461 | 3.8561 | 3.8421 | 3.8537 | 13011572.0 |
| 2008-11-04 10:20:00 | AAPL | Stock | 3.853 | 3.8729 | 3.8529 | 3.8586 | 20279560.0 |
| 2008-11-04 10:25:00 | AAPL | Stock | 3.8589 | 3.8639 | 3.8489 | 3.8639 | 14510300.0 |
| 2008-11-04 10:30:00 | AAPL | Stock | 3.8632 | 3.8782 | 3.8571 | 3.8664 | 17575824.0 |
| 2008-11-04 10:35:00 | AAPL | Stock | 3.8661 | 3.8814 | 3.8661 | 3.8754 | 18753196.0 |
| 2008-11-04 10:40:00 | AAPL | Stock | 3.8754 | 3.8768 | 3.8554 | 3.8596 | 18328884.0 |
| 2008-11-04 10:45:00 | AAPL | Stock | 3.8596 | 3.8668 | 3.8575 | 3.8624 | 14967204.0 |
| 2008-11-04 10:50:00 | AAPL | Stock | 3.8611 | 3.8664 | 3.8432 | 3.8575 | 22849400.0 |
| 2008-11-04 10:55:00 | AAPL | Stock | 3.8569 | 3.8579 | 3.8432 | 3.8536 | 16556876.0 |
> showing 50 of 320,727 rows — these rows as CSV