PREVIEW / stock_5min / 2006-11-08
file: by_date/stock_5min/2006/2006-11-08.parquet size: 3.3 MB rows: 239,103 symbols: 2,420
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-11-08 07:05:00 | AAPL | Stock | 2.8764 | 2.8764 | 2.8754 | 2.8754 | 5600.0 |
| 2006-11-08 07:20:00 | AAPL | Stock | 2.8682 | 2.8682 | 2.8682 | 2.8682 | 2800.0 |
| 2006-11-08 07:30:00 | AAPL | Stock | 2.8675 | 2.8675 | 2.8668 | 2.8668 | 11200.0 |
| 2006-11-08 07:55:00 | AAPL | Stock | 2.8614 | 2.8614 | 2.8586 | 2.8586 | 16800.0 |
| 2006-11-08 08:00:00 | AAPL | Stock | 2.8675 | 2.8714 | 2.86 | 2.8614 | 187600.0 |
| 2006-11-08 08:05:00 | AAPL | Stock | 2.8629 | 2.8629 | 2.8589 | 2.8629 | 107380.0 |
| 2006-11-08 08:10:00 | AAPL | Stock | 2.8629 | 2.8643 | 2.8625 | 2.8643 | 61432.0 |
| 2006-11-08 08:20:00 | AAPL | Stock | 2.8636 | 2.8636 | 2.8636 | 2.8636 | 2800.0 |
| 2006-11-08 08:25:00 | AAPL | Stock | 2.8625 | 2.8625 | 2.8625 | 2.8625 | 92960.0 |
| 2006-11-08 08:30:00 | AAPL | Stock | 2.8636 | 2.8636 | 2.8625 | 2.8636 | 28700.0 |
| 2006-11-08 08:35:00 | AAPL | Stock | 2.8625 | 2.8639 | 2.8614 | 2.8614 | 121240.0 |
| 2006-11-08 08:40:00 | AAPL | Stock | 2.8614 | 2.8636 | 2.8561 | 2.8571 | 303520.0 |
| 2006-11-08 08:45:00 | AAPL | Stock | 2.8571 | 2.8589 | 2.8564 | 2.8589 | 157360.0 |
| 2006-11-08 08:50:00 | AAPL | Stock | 2.8589 | 2.8607 | 2.8571 | 2.8571 | 30548.0 |
| 2006-11-08 08:55:00 | AAPL | Stock | 2.8571 | 2.8571 | 2.8543 | 2.855 | 172704.0 |
| 2006-11-08 09:00:00 | AAPL | Stock | 2.855 | 2.8557 | 2.8543 | 2.8546 | 157612.0 |
| 2006-11-08 09:05:00 | AAPL | Stock | 2.8543 | 2.8543 | 2.8507 | 2.8529 | 369264.0 |
| 2006-11-08 09:10:00 | AAPL | Stock | 2.8529 | 2.8625 | 2.8514 | 2.8514 | 309764.0 |
| 2006-11-08 09:20:00 | AAPL | Stock | 2.8536 | 2.8536 | 2.8536 | 2.8536 | 19600.0 |
| 2006-11-08 09:25:00 | AAPL | Stock | 2.8568 | 2.8596 | 2.8568 | 2.8582 | 174440.0 |
| 2006-11-08 09:30:00 | AAPL | Stock | 2.8579 | 2.8636 | 2.8532 | 2.8607 | 14829332.0 |
| 2006-11-08 09:35:00 | AAPL | Stock | 2.8607 | 2.8661 | 2.8557 | 2.8629 | 11944604.0 |
| 2006-11-08 09:40:00 | AAPL | Stock | 2.8629 | 2.875 | 2.8614 | 2.8736 | 14306544.0 |
| 2006-11-08 09:45:00 | AAPL | Stock | 2.8736 | 2.8739 | 2.8689 | 2.8711 | 6959624.0 |
| 2006-11-08 09:50:00 | AAPL | Stock | 2.8711 | 2.8746 | 2.8693 | 2.8743 | 12459776.0 |
| 2006-11-08 09:55:00 | AAPL | Stock | 2.8739 | 2.8864 | 2.8732 | 2.8818 | 13243384.0 |
| 2006-11-08 10:00:00 | AAPL | Stock | 2.8818 | 2.8918 | 2.8804 | 2.8911 | 13204184.0 |
| 2006-11-08 10:05:00 | AAPL | Stock | 2.8918 | 2.8996 | 2.8864 | 2.8929 | 21463540.0 |
| 2006-11-08 10:10:00 | AAPL | Stock | 2.8932 | 2.8946 | 2.8836 | 2.8896 | 11830392.0 |
| 2006-11-08 10:15:00 | AAPL | Stock | 2.8896 | 2.8929 | 2.8807 | 2.891 | 8755880.0 |
| 2006-11-08 10:20:00 | AAPL | Stock | 2.8911 | 2.8971 | 2.8904 | 2.8922 | 6803216.0 |
| 2006-11-08 10:25:00 | AAPL | Stock | 2.8925 | 2.8929 | 2.8868 | 2.8886 | 5142508.0 |
| 2006-11-08 10:30:00 | AAPL | Stock | 2.8893 | 2.8893 | 2.8832 | 2.8868 | 6734840.0 |
| 2006-11-08 10:35:00 | AAPL | Stock | 2.8868 | 2.8943 | 2.8839 | 2.8943 | 7648228.0 |
| 2006-11-08 10:40:00 | AAPL | Stock | 2.8936 | 2.8957 | 2.8896 | 2.8918 | 5662104.0 |
| 2006-11-08 10:45:00 | AAPL | Stock | 2.8918 | 2.8989 | 2.8911 | 2.8989 | 8895628.0 |
| 2006-11-08 10:50:00 | AAPL | Stock | 2.8986 | 2.9014 | 2.8968 | 2.8989 | 7498176.0 |
| 2006-11-08 10:55:00 | AAPL | Stock | 2.8989 | 2.9029 | 2.8964 | 2.8979 | 8932000.0 |
| 2006-11-08 11:00:00 | AAPL | Stock | 2.8975 | 2.8996 | 2.8946 | 2.8961 | 4263308.0 |
| 2006-11-08 11:05:00 | AAPL | Stock | 2.8961 | 2.8986 | 2.8918 | 2.8954 | 5245632.0 |
| 2006-11-08 11:10:00 | AAPL | Stock | 2.8957 | 2.8964 | 2.8871 | 2.8876 | 8420132.0 |
| 2006-11-08 11:15:00 | AAPL | Stock | 2.8886 | 2.8911 | 2.8875 | 2.8889 | 2728936.0 |
| 2006-11-08 11:20:00 | AAPL | Stock | 2.8891 | 2.8925 | 2.8886 | 2.891 | 3144204.0 |
| 2006-11-08 11:25:00 | AAPL | Stock | 2.8907 | 2.8939 | 2.8893 | 2.8936 | 1709904.0 |
| 2006-11-08 11:30:00 | AAPL | Stock | 2.8929 | 2.8932 | 2.8875 | 2.8875 | 3141768.0 |
| 2006-11-08 11:35:00 | AAPL | Stock | 2.8879 | 2.8896 | 2.8875 | 2.8896 | 1744960.0 |
| 2006-11-08 11:40:00 | AAPL | Stock | 2.8896 | 2.89 | 2.8864 | 2.8879 | 1811992.0 |
| 2006-11-08 11:45:00 | AAPL | Stock | 2.8879 | 2.8879 | 2.8796 | 2.8804 | 5306644.0 |
| 2006-11-08 11:50:00 | AAPL | Stock | 2.8807 | 2.8879 | 2.8793 | 2.8864 | 5294996.0 |
| 2006-11-08 11:55:00 | AAPL | Stock | 2.8861 | 2.8911 | 2.8854 | 2.8882 | 4872588.0 |
> showing 50 of 239,103 rows — these rows as CSV