PREVIEW / stock_5min / 2006-09-08
file: by_date/stock_5min/2006/2006-09-08.parquet size: 3.0 MB rows: 218,939 symbols: 2,336
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-09-08 04:00:00 | AAPL | Stock | 2.6018 | 2.6018 | 2.6018 | 2.6018 | 2800.0 |
| 2006-09-08 04:45:00 | AAPL | Stock | 2.6071 | 2.6071 | 2.6071 | 2.6071 | 2800.0 |
| 2006-09-08 06:20:00 | AAPL | Stock | 2.6125 | 2.6143 | 2.6089 | 2.6089 | 22680.0 |
| 2006-09-08 06:35:00 | AAPL | Stock | 2.6143 | 2.6175 | 2.6143 | 2.6175 | 154000.0 |
| 2006-09-08 07:05:00 | AAPL | Stock | 2.6246 | 2.625 | 2.6246 | 2.6246 | 153860.0 |
| 2006-09-08 07:25:00 | AAPL | Stock | 2.6211 | 2.6211 | 2.6179 | 2.6179 | 42000.0 |
| 2006-09-08 07:30:00 | AAPL | Stock | 2.62 | 2.62 | 2.62 | 2.62 | 2800.0 |
| 2006-09-08 07:40:00 | AAPL | Stock | 2.6179 | 2.6179 | 2.6179 | 2.6179 | 42000.0 |
| 2006-09-08 07:45:00 | AAPL | Stock | 2.6179 | 2.625 | 2.6179 | 2.625 | 42000.0 |
| 2006-09-08 07:50:00 | AAPL | Stock | 2.6179 | 2.6179 | 2.6168 | 2.6168 | 33600.0 |
| 2006-09-08 08:00:00 | AAPL | Stock | 2.6211 | 2.625 | 2.6161 | 2.6218 | 1161020.0 |
| 2006-09-08 08:05:00 | AAPL | Stock | 2.6218 | 2.6279 | 2.6196 | 2.625 | 556724.0 |
| 2006-09-08 08:10:00 | AAPL | Stock | 2.6264 | 2.6304 | 2.6264 | 2.6289 | 700420.0 |
| 2006-09-08 08:15:00 | AAPL | Stock | 2.6311 | 2.6318 | 2.6268 | 2.6286 | 760060.0 |
| 2006-09-08 08:20:00 | AAPL | Stock | 2.6286 | 2.6318 | 2.6286 | 2.6286 | 369936.0 |
| 2006-09-08 08:25:00 | AAPL | Stock | 2.6279 | 2.6286 | 2.6243 | 2.6243 | 287700.0 |
| 2006-09-08 08:30:00 | AAPL | Stock | 2.6232 | 2.625 | 2.6214 | 2.6225 | 418600.0 |
| 2006-09-08 08:35:00 | AAPL | Stock | 2.6232 | 2.625 | 2.6232 | 2.625 | 78008.0 |
| 2006-09-08 08:40:00 | AAPL | Stock | 2.6257 | 2.63 | 2.6254 | 2.6282 | 544600.0 |
| 2006-09-08 08:45:00 | AAPL | Stock | 2.6279 | 2.6279 | 2.6214 | 2.625 | 588308.0 |
| 2006-09-08 08:50:00 | AAPL | Stock | 2.6225 | 2.6268 | 2.6182 | 2.6268 | 712992.0 |
| 2006-09-08 08:55:00 | AAPL | Stock | 2.6275 | 2.6286 | 2.6232 | 2.6232 | 308000.0 |
| 2006-09-08 09:00:00 | AAPL | Stock | 2.625 | 2.6271 | 2.6246 | 2.6268 | 321636.0 |
| 2006-09-08 09:05:00 | AAPL | Stock | 2.6268 | 2.6286 | 2.6254 | 2.6268 | 374808.0 |
| 2006-09-08 09:10:00 | AAPL | Stock | 2.6264 | 2.6293 | 2.625 | 2.6279 | 1098664.0 |
| 2006-09-08 09:15:00 | AAPL | Stock | 2.6268 | 2.6279 | 2.6254 | 2.6254 | 172480.0 |
| 2006-09-08 09:20:00 | AAPL | Stock | 2.625 | 2.625 | 2.6196 | 2.6211 | 718340.0 |
| 2006-09-08 09:25:00 | AAPL | Stock | 2.6193 | 2.6218 | 2.6161 | 2.6186 | 2987628.0 |
| 2006-09-08 09:30:00 | AAPL | Stock | 2.6204 | 2.6239 | 2.61 | 2.6186 | 38815420.0 |
| 2006-09-08 09:35:00 | AAPL | Stock | 2.6186 | 2.6186 | 2.6025 | 2.6036 | 36071420.0 |
| 2006-09-08 09:40:00 | AAPL | Stock | 2.6036 | 2.6171 | 2.6025 | 2.6089 | 35686056.0 |
| 2006-09-08 09:45:00 | AAPL | Stock | 2.6089 | 2.6275 | 2.6086 | 2.6164 | 26554640.0 |
| 2006-09-08 09:50:00 | AAPL | Stock | 2.6161 | 2.6179 | 2.6004 | 2.6014 | 25460204.0 |
| 2006-09-08 09:55:00 | AAPL | Stock | 2.6011 | 2.6061 | 2.5911 | 2.5986 | 37487240.0 |
| 2006-09-08 10:00:00 | AAPL | Stock | 2.5986 | 2.6036 | 2.595 | 2.6014 | 16629732.0 |
| 2006-09-08 10:05:00 | AAPL | Stock | 2.6014 | 2.6025 | 2.5904 | 2.5907 | 21117684.0 |
| 2006-09-08 10:10:00 | AAPL | Stock | 2.5911 | 2.5961 | 2.5829 | 2.5854 | 32324180.0 |
| 2006-09-08 10:15:00 | AAPL | Stock | 2.5854 | 2.5914 | 2.5796 | 2.58 | 25271960.0 |
| 2006-09-08 10:20:00 | AAPL | Stock | 2.58 | 2.5882 | 2.5764 | 2.5879 | 21386876.0 |
| 2006-09-08 10:25:00 | AAPL | Stock | 2.588 | 2.5957 | 2.5846 | 2.5957 | 18095364.0 |
| 2006-09-08 10:30:00 | AAPL | Stock | 2.5954 | 2.5971 | 2.5864 | 2.5889 | 13936300.0 |
| 2006-09-08 10:35:00 | AAPL | Stock | 2.5893 | 2.5904 | 2.5821 | 2.5864 | 11396868.0 |
| 2006-09-08 10:40:00 | AAPL | Stock | 2.5864 | 2.5921 | 2.5832 | 2.59 | 8494528.0 |
| 2006-09-08 10:45:00 | AAPL | Stock | 2.59 | 2.5943 | 2.5868 | 2.5918 | 8700944.0 |
| 2006-09-08 10:50:00 | AAPL | Stock | 2.5921 | 2.5979 | 2.5893 | 2.5943 | 11760756.0 |
| 2006-09-08 10:55:00 | AAPL | Stock | 2.5943 | 2.6014 | 2.5936 | 2.6007 | 10385172.0 |
| 2006-09-08 11:00:00 | AAPL | Stock | 2.6007 | 2.6014 | 2.5929 | 2.5939 | 12527816.0 |
| 2006-09-08 11:05:00 | AAPL | Stock | 2.5939 | 2.5975 | 2.5929 | 2.5961 | 6430312.0 |
| 2006-09-08 11:10:00 | AAPL | Stock | 2.5961 | 2.6014 | 2.5961 | 2.5979 | 11706604.0 |
| 2006-09-08 11:15:00 | AAPL | Stock | 2.5979 | 2.5989 | 2.5914 | 2.5921 | 10169796.0 |
> showing 50 of 218,939 rows — these rows as CSV