PREVIEW / stock_5min / 2006-07-13
file: by_date/stock_5min/2006/2006-07-13.parquet size: 3.1 MB rows: 228,385 symbols: 2,313
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-07-13 07:00:00 | AAPL | Stock | 1.8821 | 1.8821 | 1.8821 | 1.8821 | 2800.0 |
| 2006-07-13 07:15:00 | AAPL | Stock | 1.8818 | 1.8818 | 1.8818 | 1.8818 | 2800.0 |
| 2006-07-13 07:45:00 | AAPL | Stock | 1.8821 | 1.8821 | 1.8821 | 1.8821 | 28000.0 |
| 2006-07-13 07:55:00 | AAPL | Stock | 1.8696 | 1.8696 | 1.8696 | 1.8696 | 25200.0 |
| 2006-07-13 08:00:00 | AAPL | Stock | 1.8696 | 1.8786 | 1.8686 | 1.8721 | 330176.0 |
| 2006-07-13 08:05:00 | AAPL | Stock | 1.875 | 1.875 | 1.87 | 1.87 | 230020.0 |
| 2006-07-13 08:10:00 | AAPL | Stock | 1.87 | 1.8786 | 1.8696 | 1.8786 | 334992.0 |
| 2006-07-13 08:15:00 | AAPL | Stock | 1.8786 | 1.8786 | 1.8721 | 1.8775 | 186200.0 |
| 2006-07-13 08:20:00 | AAPL | Stock | 1.875 | 1.8768 | 1.8732 | 1.8761 | 145824.0 |
| 2006-07-13 08:25:00 | AAPL | Stock | 1.8761 | 1.8771 | 1.8686 | 1.8696 | 670404.0 |
| 2006-07-13 08:30:00 | AAPL | Stock | 1.8696 | 1.8711 | 1.8689 | 1.87 | 213080.0 |
| 2006-07-13 08:35:00 | AAPL | Stock | 1.87 | 1.8707 | 1.8689 | 1.8696 | 126000.0 |
| 2006-07-13 08:40:00 | AAPL | Stock | 1.8693 | 1.8693 | 1.8671 | 1.8689 | 659988.0 |
| 2006-07-13 08:45:00 | AAPL | Stock | 1.8686 | 1.8686 | 1.8671 | 1.8679 | 288092.0 |
| 2006-07-13 08:50:00 | AAPL | Stock | 1.8679 | 1.8746 | 1.8679 | 1.8736 | 254800.0 |
| 2006-07-13 08:55:00 | AAPL | Stock | 1.8743 | 1.8782 | 1.8729 | 1.8729 | 186200.0 |
| 2006-07-13 09:00:00 | AAPL | Stock | 1.8732 | 1.8743 | 1.8686 | 1.8714 | 181300.0 |
| 2006-07-13 09:05:00 | AAPL | Stock | 1.8721 | 1.8721 | 1.8661 | 1.8671 | 731472.0 |
| 2006-07-13 09:10:00 | AAPL | Stock | 1.8664 | 1.8668 | 1.865 | 1.8661 | 446964.0 |
| 2006-07-13 09:15:00 | AAPL | Stock | 1.8661 | 1.8661 | 1.8625 | 1.8625 | 282016.0 |
| 2006-07-13 09:20:00 | AAPL | Stock | 1.8621 | 1.8661 | 1.8621 | 1.8636 | 559216.0 |
| 2006-07-13 09:25:00 | AAPL | Stock | 1.8671 | 1.8686 | 1.8582 | 1.86 | 1958012.0 |
| 2006-07-13 09:30:00 | AAPL | Stock | 1.8582 | 1.8614 | 1.8421 | 1.8611 | 58308040.0 |
| 2006-07-13 09:35:00 | AAPL | Stock | 1.8611 | 1.8668 | 1.8557 | 1.8575 | 32202940.0 |
| 2006-07-13 09:40:00 | AAPL | Stock | 1.8571 | 1.8711 | 1.8571 | 1.8618 | 23193268.0 |
| 2006-07-13 09:45:00 | AAPL | Stock | 1.8618 | 1.8671 | 1.8521 | 1.8611 | 19926004.0 |
| 2006-07-13 09:50:00 | AAPL | Stock | 1.8611 | 1.8707 | 1.8561 | 1.8571 | 20376636.0 |
| 2006-07-13 09:55:00 | AAPL | Stock | 1.8575 | 1.8607 | 1.8482 | 1.8525 | 23583728.0 |
| 2006-07-13 10:00:00 | AAPL | Stock | 1.8525 | 1.8586 | 1.8396 | 1.8425 | 29093988.0 |
| 2006-07-13 10:05:00 | AAPL | Stock | 1.8425 | 1.8471 | 1.8361 | 1.8421 | 42482132.0 |
| 2006-07-13 10:10:00 | AAPL | Stock | 1.8418 | 1.8518 | 1.8414 | 1.8507 | 25563384.0 |
| 2006-07-13 10:15:00 | AAPL | Stock | 1.8504 | 1.8586 | 1.8479 | 1.8586 | 22028020.0 |
| 2006-07-13 10:20:00 | AAPL | Stock | 1.8589 | 1.8625 | 1.8514 | 1.8589 | 21821800.0 |
| 2006-07-13 10:25:00 | AAPL | Stock | 1.8589 | 1.8704 | 1.8532 | 1.8682 | 18793096.0 |
| 2006-07-13 10:30:00 | AAPL | Stock | 1.8679 | 1.8846 | 1.8679 | 1.8768 | 34677552.0 |
| 2006-07-13 10:35:00 | AAPL | Stock | 1.8768 | 1.8911 | 1.875 | 1.8868 | 28271320.0 |
| 2006-07-13 10:40:00 | AAPL | Stock | 1.8868 | 1.8914 | 1.8836 | 1.8854 | 25342296.0 |
| 2006-07-13 10:45:00 | AAPL | Stock | 1.8854 | 1.8896 | 1.8768 | 1.8886 | 21572992.0 |
| 2006-07-13 10:50:00 | AAPL | Stock | 1.8886 | 1.8993 | 1.8843 | 1.8864 | 26451516.0 |
| 2006-07-13 10:55:00 | AAPL | Stock | 1.8861 | 1.8889 | 1.8818 | 1.8829 | 15341508.0 |
| 2006-07-13 11:00:00 | AAPL | Stock | 1.8825 | 1.883 | 1.8721 | 1.88 | 27581092.0 |
| 2006-07-13 11:05:00 | AAPL | Stock | 1.88 | 1.8829 | 1.8729 | 1.8746 | 11711252.0 |
| 2006-07-13 11:10:00 | AAPL | Stock | 1.8732 | 1.8764 | 1.87 | 1.8739 | 12596108.0 |
| 2006-07-13 11:15:00 | AAPL | Stock | 1.8736 | 1.885 | 1.8736 | 1.8786 | 12754896.0 |
| 2006-07-13 11:20:00 | AAPL | Stock | 1.8786 | 1.8875 | 1.8786 | 1.885 | 10011260.0 |
| 2006-07-13 11:25:00 | AAPL | Stock | 1.8843 | 1.8896 | 1.8807 | 1.8886 | 9672544.0 |
| 2006-07-13 11:30:00 | AAPL | Stock | 1.8886 | 1.8925 | 1.8839 | 1.8904 | 13979056.0 |
| 2006-07-13 11:35:00 | AAPL | Stock | 1.89 | 1.905 | 1.8889 | 1.8986 | 24760624.0 |
| 2006-07-13 11:40:00 | AAPL | Stock | 1.8982 | 1.905 | 1.8982 | 1.9036 | 12615680.0 |
| 2006-07-13 11:45:00 | AAPL | Stock | 1.9036 | 1.9064 | 1.8907 | 1.8961 | 15385776.0 |
> showing 50 of 228,385 rows — these rows as CSV