PREVIEW / stock_5min / 2006-10-27
file: by_date/stock_5min/2006/2006-10-27.parquet size: 3.2 MB rows: 228,158 symbols: 2,395
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-10-27 08:00:00 | AAPL | Stock | 2.9286 | 2.9354 | 2.9211 | 2.9246 | 41020.0 |
| 2006-10-27 08:05:00 | AAPL | Stock | 2.9204 | 2.9221 | 2.9196 | 2.9221 | 60060.0 |
| 2006-10-27 08:10:00 | AAPL | Stock | 2.9282 | 2.9286 | 2.9282 | 2.9282 | 98000.0 |
| 2006-10-27 08:15:00 | AAPL | Stock | 2.9221 | 2.9221 | 2.9214 | 2.9214 | 107800.0 |
| 2006-10-27 08:20:00 | AAPL | Stock | 2.9214 | 2.9214 | 2.9214 | 2.9214 | 16800.0 |
| 2006-10-27 08:25:00 | AAPL | Stock | 2.9271 | 2.9271 | 2.9271 | 2.9271 | 11200.0 |
| 2006-10-27 08:30:00 | AAPL | Stock | 2.9271 | 2.9271 | 2.9214 | 2.9214 | 107240.0 |
| 2006-10-27 08:35:00 | AAPL | Stock | 2.9214 | 2.9257 | 2.9214 | 2.9257 | 94360.0 |
| 2006-10-27 08:45:00 | AAPL | Stock | 2.9279 | 2.9282 | 2.9236 | 2.9236 | 23072.0 |
| 2006-10-27 08:50:00 | AAPL | Stock | 2.9232 | 2.9271 | 2.9232 | 2.9271 | 51800.0 |
| 2006-10-27 08:55:00 | AAPL | Stock | 2.9214 | 2.925 | 2.9214 | 2.925 | 39200.0 |
| 2006-10-27 09:00:00 | AAPL | Stock | 2.925 | 2.925 | 2.9218 | 2.9221 | 71596.0 |
| 2006-10-27 09:05:00 | AAPL | Stock | 2.9214 | 2.925 | 2.9214 | 2.925 | 10080.0 |
| 2006-10-27 09:10:00 | AAPL | Stock | 2.9243 | 2.925 | 2.9218 | 2.9218 | 57960.0 |
| 2006-10-27 09:20:00 | AAPL | Stock | 2.9218 | 2.9218 | 2.9218 | 2.9218 | 28000.0 |
| 2006-10-27 09:25:00 | AAPL | Stock | 2.9218 | 2.9282 | 2.9193 | 2.9204 | 419552.0 |
| 2006-10-27 09:30:00 | AAPL | Stock | 2.9196 | 2.9429 | 2.9182 | 2.9425 | 17955448.0 |
| 2006-10-27 09:35:00 | AAPL | Stock | 2.9421 | 2.9429 | 2.9286 | 2.9357 | 13671364.0 |
| 2006-10-27 09:40:00 | AAPL | Stock | 2.9361 | 2.9379 | 2.9275 | 2.9297 | 8250508.0 |
| 2006-10-27 09:45:00 | AAPL | Stock | 2.93 | 2.9336 | 2.9279 | 2.9336 | 6798008.0 |
| 2006-10-27 09:50:00 | AAPL | Stock | 2.9339 | 2.9339 | 2.9282 | 2.93 | 6502524.0 |
| 2006-10-27 09:55:00 | AAPL | Stock | 2.93 | 2.9405 | 2.9296 | 2.9339 | 7456988.0 |
| 2006-10-27 10:00:00 | AAPL | Stock | 2.9325 | 2.9375 | 2.9304 | 2.9311 | 6318004.0 |
| 2006-10-27 10:05:00 | AAPL | Stock | 2.9311 | 2.9336 | 2.9279 | 2.9329 | 9002868.0 |
| 2006-10-27 10:10:00 | AAPL | Stock | 2.9332 | 2.9395 | 2.9296 | 2.9371 | 7778988.0 |
| 2006-10-27 10:15:00 | AAPL | Stock | 2.9368 | 2.9389 | 2.9357 | 2.9386 | 5682096.0 |
| 2006-10-27 10:20:00 | AAPL | Stock | 2.9386 | 2.9386 | 2.9339 | 2.9354 | 5338088.0 |
| 2006-10-27 10:25:00 | AAPL | Stock | 2.9354 | 2.9379 | 2.9346 | 2.9357 | 2778580.0 |
| 2006-10-27 10:30:00 | AAPL | Stock | 2.9361 | 2.9386 | 2.9325 | 2.9382 | 5419036.0 |
| 2006-10-27 10:35:00 | AAPL | Stock | 2.9382 | 2.9411 | 2.9361 | 2.9379 | 4023068.0 |
| 2006-10-27 10:40:00 | AAPL | Stock | 2.9375 | 2.9404 | 2.9361 | 2.9375 | 4933460.0 |
| 2006-10-27 10:45:00 | AAPL | Stock | 2.9375 | 2.94 | 2.9371 | 2.9379 | 3911600.0 |
| 2006-10-27 10:50:00 | AAPL | Stock | 2.9382 | 2.9411 | 2.9368 | 2.9404 | 3149384.0 |
| 2006-10-27 10:55:00 | AAPL | Stock | 2.9407 | 2.9446 | 2.9382 | 2.9411 | 6723808.0 |
| 2006-10-27 11:00:00 | AAPL | Stock | 2.9414 | 2.9432 | 2.9382 | 2.9393 | 5317844.0 |
| 2006-10-27 11:05:00 | AAPL | Stock | 2.9393 | 2.9418 | 2.9389 | 2.94 | 3649576.0 |
| 2006-10-27 11:10:00 | AAPL | Stock | 2.94 | 2.9436 | 2.9382 | 2.9425 | 5834948.0 |
| 2006-10-27 11:15:00 | AAPL | Stock | 2.9422 | 2.9439 | 2.9407 | 2.9411 | 3978912.0 |
| 2006-10-27 11:20:00 | AAPL | Stock | 2.9414 | 2.9432 | 2.9361 | 2.9393 | 7011956.0 |
| 2006-10-27 11:25:00 | AAPL | Stock | 2.9393 | 2.9411 | 2.9389 | 2.9411 | 3409812.0 |
| 2006-10-27 11:30:00 | AAPL | Stock | 2.9408 | 2.9409 | 2.9379 | 2.9396 | 1983184.0 |
| 2006-10-27 11:35:00 | AAPL | Stock | 2.9389 | 2.9411 | 2.9389 | 2.9396 | 2398116.0 |
| 2006-10-27 11:40:00 | AAPL | Stock | 2.9393 | 2.9418 | 2.9382 | 2.9382 | 3873408.0 |
| 2006-10-27 11:45:00 | AAPL | Stock | 2.9382 | 2.9386 | 2.9307 | 2.9321 | 8094324.0 |
| 2006-10-27 11:50:00 | AAPL | Stock | 2.9321 | 2.9346 | 2.9318 | 2.9332 | 3865148.0 |
| 2006-10-27 11:55:00 | AAPL | Stock | 2.9334 | 2.9357 | 2.9307 | 2.9343 | 2158436.0 |
| 2006-10-27 12:00:00 | AAPL | Stock | 2.9346 | 2.935 | 2.9314 | 2.9314 | 1864408.0 |
| 2006-10-27 12:05:00 | AAPL | Stock | 2.9314 | 2.9321 | 2.93 | 2.9319 | 3319960.0 |
| 2006-10-27 12:10:00 | AAPL | Stock | 2.9318 | 2.9364 | 2.9307 | 2.9364 | 6913228.0 |
| 2006-10-27 12:15:00 | AAPL | Stock | 2.9364 | 2.9368 | 2.9336 | 2.9357 | 2605260.0 |
> showing 50 of 228,158 rows — these rows as CSV