PREVIEW / stock_5min / 2007-10-29
file: by_date/stock_5min/2007/2007-10-29.parquet size: 4.3 MB rows: 311,748 symbols: 3,172
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 |
|---|---|---|---|---|---|---|---|
| 2007-10-29 06:35:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6607 | 6.6607 | 5908.0 |
| 2007-10-29 06:50:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6607 | 6.6607 | 2800.0 |
| 2007-10-29 07:00:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6554 | 6.6554 | 8400.0 |
| 2007-10-29 07:05:00 | AAPL | Stock | 6.6554 | 6.6561 | 6.6554 | 6.6561 | 25200.0 |
| 2007-10-29 07:10:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.66 | 6.6607 | 37184.0 |
| 2007-10-29 07:15:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6571 | 6.6571 | 42000.0 |
| 2007-10-29 07:20:00 | AAPL | Stock | 6.6511 | 6.6511 | 6.65 | 6.65 | 11200.0 |
| 2007-10-29 07:25:00 | AAPL | Stock | 6.6511 | 6.6511 | 6.6114 | 6.6114 | 14000.0 |
| 2007-10-29 07:30:00 | AAPL | Stock | 6.6496 | 6.6496 | 6.6429 | 6.6429 | 17640.0 |
| 2007-10-29 07:35:00 | AAPL | Stock | 6.6429 | 6.6429 | 6.6429 | 6.6429 | 2800.0 |
| 2007-10-29 07:45:00 | AAPL | Stock | 6.6493 | 6.6504 | 6.6493 | 6.6493 | 46480.0 |
| 2007-10-29 07:50:00 | AAPL | Stock | 6.6436 | 6.6518 | 6.6436 | 6.6493 | 70756.0 |
| 2007-10-29 07:55:00 | AAPL | Stock | 6.6436 | 6.6554 | 6.6429 | 6.6554 | 144340.0 |
| 2007-10-29 08:00:00 | AAPL | Stock | 6.6475 | 6.6518 | 6.6321 | 6.6393 | 672728.0 |
| 2007-10-29 08:05:00 | AAPL | Stock | 6.6393 | 6.6411 | 6.6143 | 6.6182 | 369852.0 |
| 2007-10-29 08:10:00 | AAPL | Stock | 6.6246 | 6.63 | 6.6196 | 6.625 | 193928.0 |
| 2007-10-29 08:15:00 | AAPL | Stock | 6.625 | 6.6321 | 6.625 | 6.6321 | 70672.0 |
| 2007-10-29 08:20:00 | AAPL | Stock | 6.6321 | 6.6321 | 6.6179 | 6.6214 | 257516.0 |
| 2007-10-29 08:25:00 | AAPL | Stock | 6.6211 | 6.6214 | 6.6107 | 6.6107 | 491428.0 |
| 2007-10-29 08:30:00 | AAPL | Stock | 6.6125 | 6.6143 | 6.6014 | 6.6129 | 618884.0 |
| 2007-10-29 08:35:00 | AAPL | Stock | 6.6075 | 6.6143 | 6.6004 | 6.6018 | 273504.0 |
| 2007-10-29 08:40:00 | AAPL | Stock | 6.6004 | 6.6143 | 6.5982 | 6.6143 | 307608.0 |
| 2007-10-29 08:45:00 | AAPL | Stock | 6.6161 | 6.6161 | 6.6071 | 6.6071 | 335524.0 |
| 2007-10-29 08:50:00 | AAPL | Stock | 6.6071 | 6.61 | 6.6 | 6.6032 | 243376.0 |
| 2007-10-29 08:55:00 | AAPL | Stock | 6.6057 | 6.6161 | 6.6057 | 6.6068 | 364336.0 |
| 2007-10-29 09:00:00 | AAPL | Stock | 6.6068 | 6.6107 | 6.6064 | 6.6068 | 141708.0 |
| 2007-10-29 09:05:00 | AAPL | Stock | 6.6068 | 6.6121 | 6.6036 | 6.6121 | 208572.0 |
| 2007-10-29 09:10:00 | AAPL | Stock | 6.6114 | 6.6254 | 6.6114 | 6.6214 | 613312.0 |
| 2007-10-29 09:15:00 | AAPL | Stock | 6.6214 | 6.6268 | 6.6214 | 6.6232 | 322728.0 |
| 2007-10-29 09:20:00 | AAPL | Stock | 6.6264 | 6.6271 | 6.6232 | 6.625 | 154280.0 |
| 2007-10-29 09:25:00 | AAPL | Stock | 6.6214 | 6.6389 | 6.6214 | 6.625 | 909076.0 |
| 2007-10-29 09:30:00 | AAPL | Stock | 6.6232 | 6.6511 | 6.6207 | 6.6393 | 25414284.0 |
| 2007-10-29 09:35:00 | AAPL | Stock | 6.6393 | 6.6596 | 6.6393 | 6.6462 | 16652972.0 |
| 2007-10-29 09:40:00 | AAPL | Stock | 6.6471 | 6.6639 | 6.6457 | 6.6503 | 14252616.0 |
| 2007-10-29 09:45:00 | AAPL | Stock | 6.6507 | 6.6564 | 6.6343 | 6.6359 | 12947088.0 |
| 2007-10-29 09:50:00 | AAPL | Stock | 6.6357 | 6.6439 | 6.6343 | 6.6371 | 11729928.0 |
| 2007-10-29 09:55:00 | AAPL | Stock | 6.6375 | 6.6393 | 6.6107 | 6.6286 | 15975876.0 |
| 2007-10-29 10:00:00 | AAPL | Stock | 6.6275 | 6.6286 | 6.6146 | 6.6264 | 15143100.0 |
| 2007-10-29 10:05:00 | AAPL | Stock | 6.6264 | 6.6396 | 6.6254 | 6.6361 | 9980684.0 |
| 2007-10-29 10:10:00 | AAPL | Stock | 6.6361 | 6.6389 | 6.6279 | 6.6289 | 5488084.0 |
| 2007-10-29 10:15:00 | AAPL | Stock | 6.6293 | 6.6311 | 6.6 | 6.6093 | 14922348.0 |
| 2007-10-29 10:20:00 | AAPL | Stock | 6.6093 | 6.6286 | 6.6071 | 6.6268 | 11073356.0 |
| 2007-10-29 10:25:00 | AAPL | Stock | 6.6271 | 6.6329 | 6.6139 | 6.6186 | 9284884.0 |
| 2007-10-29 10:30:00 | AAPL | Stock | 6.6186 | 6.6214 | 6.6057 | 6.6193 | 16525432.0 |
| 2007-10-29 10:35:00 | AAPL | Stock | 6.6193 | 6.63 | 6.6146 | 6.6205 | 8341704.0 |
| 2007-10-29 10:40:00 | AAPL | Stock | 6.6218 | 6.6289 | 6.6211 | 6.6271 | 5594232.0 |
| 2007-10-29 10:45:00 | AAPL | Stock | 6.6268 | 6.6286 | 6.6193 | 6.62 | 5850964.0 |
| 2007-10-29 10:50:00 | AAPL | Stock | 6.6204 | 6.625 | 6.6111 | 6.6168 | 6114836.0 |
| 2007-10-29 10:55:00 | AAPL | Stock | 6.6171 | 6.6264 | 6.6161 | 6.6229 | 3640476.0 |
| 2007-10-29 11:00:00 | AAPL | Stock | 6.6218 | 6.6232 | 6.6157 | 6.6211 | 3856916.0 |
> showing 50 of 311,748 rows — these rows as CSV