PREVIEW / stock_5min / 2006-01-19
file: by_date/stock_5min/2006/2006-01-19.parquet size: 3.0 MB rows: 216,089 symbols: 2,175
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-01-19 05:50:00 | AAPL | Stock | 2.85 | 2.85 | 2.85 | 2.85 | 2800.0 |
| 2006-01-19 06:10:00 | AAPL | Stock | 2.8518 | 2.8518 | 2.8518 | 2.8518 | 11200.0 |
| 2006-01-19 07:00:00 | AAPL | Stock | 2.8482 | 2.875 | 2.8482 | 2.8571 | 184800.0 |
| 2006-01-19 07:05:00 | AAPL | Stock | 2.8686 | 2.8686 | 2.8686 | 2.8686 | 5600.0 |
| 2006-01-19 07:10:00 | AAPL | Stock | 2.8686 | 2.8686 | 2.8571 | 2.8571 | 78400.0 |
| 2006-01-19 07:15:00 | AAPL | Stock | 2.8532 | 2.8604 | 2.8532 | 2.8571 | 105420.0 |
| 2006-01-19 07:25:00 | AAPL | Stock | 2.8571 | 2.8607 | 2.8561 | 2.8604 | 109200.0 |
| 2006-01-19 07:30:00 | AAPL | Stock | 2.8575 | 2.8643 | 2.8575 | 2.8614 | 63980.0 |
| 2006-01-19 07:35:00 | AAPL | Stock | 2.8625 | 2.8714 | 2.8625 | 2.8714 | 211820.0 |
| 2006-01-19 07:40:00 | AAPL | Stock | 2.8746 | 2.8818 | 2.8696 | 2.8818 | 44800.0 |
| 2006-01-19 07:45:00 | AAPL | Stock | 2.8768 | 2.8918 | 2.8714 | 2.8821 | 425180.0 |
| 2006-01-19 07:50:00 | AAPL | Stock | 2.8821 | 2.8839 | 2.8786 | 2.8839 | 87920.0 |
| 2006-01-19 07:55:00 | AAPL | Stock | 2.8807 | 2.8839 | 2.8779 | 2.8779 | 453320.0 |
| 2006-01-19 08:00:00 | AAPL | Stock | 2.8757 | 2.8875 | 2.8527 | 2.8875 | 8608684.0 |
| 2006-01-19 08:05:00 | AAPL | Stock | 2.8875 | 2.8936 | 2.8843 | 2.8879 | 4275460.0 |
| 2006-01-19 08:10:00 | AAPL | Stock | 2.8886 | 2.8893 | 2.8836 | 2.8886 | 6389180.0 |
| 2006-01-19 08:15:00 | AAPL | Stock | 2.8886 | 2.9036 | 2.8882 | 2.9036 | 6742204.0 |
| 2006-01-19 08:20:00 | AAPL | Stock | 2.9036 | 2.9089 | 2.8961 | 2.9036 | 4831148.0 |
| 2006-01-19 08:25:00 | AAPL | Stock | 2.9032 | 2.9179 | 2.9025 | 2.9179 | 2580200.0 |
| 2006-01-19 08:30:00 | AAPL | Stock | 2.9186 | 2.9232 | 2.9089 | 2.9129 | 5200300.0 |
| 2006-01-19 08:35:00 | AAPL | Stock | 2.9125 | 2.9461 | 2.9025 | 2.9157 | 3516268.0 |
| 2006-01-19 08:40:00 | AAPL | Stock | 2.9157 | 2.9232 | 2.9125 | 2.9214 | 2656836.0 |
| 2006-01-19 08:45:00 | AAPL | Stock | 2.9207 | 2.95 | 2.9207 | 2.9382 | 9570036.0 |
| 2006-01-19 08:50:00 | AAPL | Stock | 2.9386 | 2.945 | 2.9186 | 2.92 | 5011244.0 |
| 2006-01-19 08:55:00 | AAPL | Stock | 2.9204 | 2.9225 | 2.9157 | 2.9214 | 4489212.0 |
| 2006-01-19 09:00:00 | AAPL | Stock | 2.9211 | 2.9214 | 2.9107 | 2.9179 | 3965892.0 |
| 2006-01-19 09:05:00 | AAPL | Stock | 2.9179 | 2.9214 | 2.9164 | 2.9175 | 4632292.0 |
| 2006-01-19 09:10:00 | AAPL | Stock | 2.9179 | 2.9186 | 2.9104 | 2.915 | 2817360.0 |
| 2006-01-19 09:15:00 | AAPL | Stock | 2.9161 | 2.9161 | 2.9096 | 2.9129 | 1401036.0 |
| 2006-01-19 09:20:00 | AAPL | Stock | 2.9132 | 2.9189 | 2.9082 | 2.915 | 2133348.0 |
| 2006-01-19 09:25:00 | AAPL | Stock | 2.9189 | 2.9189 | 2.9007 | 2.9014 | 6045984.0 |
| 2006-01-19 09:30:00 | AAPL | Stock | 2.9018 | 2.9079 | 2.8643 | 2.8929 | 93645944.0 |
| 2006-01-19 09:35:00 | AAPL | Stock | 2.8932 | 2.9096 | 2.8861 | 2.8929 | 53569404.0 |
| 2006-01-19 09:40:00 | AAPL | Stock | 2.8929 | 2.8954 | 2.8736 | 2.8771 | 43220380.0 |
| 2006-01-19 09:45:00 | AAPL | Stock | 2.8771 | 2.8861 | 2.8671 | 2.8821 | 44813132.0 |
| 2006-01-19 09:50:00 | AAPL | Stock | 2.8829 | 2.8871 | 2.8718 | 2.8782 | 29717576.0 |
| 2006-01-19 09:55:00 | AAPL | Stock | 2.8786 | 2.8989 | 2.8782 | 2.8964 | 37365664.0 |
| 2006-01-19 10:00:00 | AAPL | Stock | 2.8961 | 2.9061 | 2.8914 | 2.9025 | 33391736.0 |
| 2006-01-19 10:05:00 | AAPL | Stock | 2.9025 | 2.9164 | 2.9025 | 2.9082 | 49285376.0 |
| 2006-01-19 10:10:00 | AAPL | Stock | 2.9079 | 2.9107 | 2.8982 | 2.8996 | 30719108.0 |
| 2006-01-19 10:15:00 | AAPL | Stock | 2.8996 | 2.9107 | 2.8993 | 2.9089 | 20490652.0 |
| 2006-01-19 10:20:00 | AAPL | Stock | 2.9089 | 2.9093 | 2.8939 | 2.8939 | 20487684.0 |
| 2006-01-19 10:25:00 | AAPL | Stock | 2.8939 | 2.8939 | 2.8768 | 2.8825 | 32159372.0 |
| 2006-01-19 10:30:00 | AAPL | Stock | 2.8825 | 2.8839 | 2.8711 | 2.8771 | 27205332.0 |
| 2006-01-19 10:35:00 | AAPL | Stock | 2.8771 | 2.8929 | 2.8746 | 2.8804 | 46836664.0 |
| 2006-01-19 10:40:00 | AAPL | Stock | 2.8804 | 2.8821 | 2.87 | 2.8761 | 24982104.0 |
| 2006-01-19 10:45:00 | AAPL | Stock | 2.8757 | 2.8757 | 2.8543 | 2.8596 | 48698524.0 |
| 2006-01-19 10:50:00 | AAPL | Stock | 2.8596 | 2.86 | 2.8404 | 2.8414 | 52016468.0 |
| 2006-01-19 10:55:00 | AAPL | Stock | 2.8414 | 2.8782 | 2.84 | 2.8554 | 37122960.0 |
| 2006-01-19 11:00:00 | AAPL | Stock | 2.8554 | 2.8561 | 2.8446 | 2.8486 | 19064920.0 |
> showing 50 of 216,089 rows — these rows as CSV