PREVIEW / stock_5min / 2005-08-23
file: by_date/stock_5min/2005/2005-08-23.parquet size: 2.7 MB rows: 199,056 symbols: 2,067
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 |
|---|---|---|---|---|---|---|---|
| 2005-08-23 08:00:00 | AAPL | Stock | 1.6425 | 1.6425 | 1.6425 | 1.6425 | 2800.0 |
| 2005-08-23 08:05:00 | AAPL | Stock | 1.6414 | 1.6496 | 1.6414 | 1.6418 | 31108.0 |
| 2005-08-23 08:20:00 | AAPL | Stock | 1.6418 | 1.6418 | 1.6418 | 1.6418 | 2800.0 |
| 2005-08-23 08:40:00 | AAPL | Stock | 1.6414 | 1.6418 | 1.6414 | 1.6418 | 20300.0 |
| 2005-08-23 08:45:00 | AAPL | Stock | 1.6418 | 1.6418 | 1.6418 | 1.6418 | 14000.0 |
| 2005-08-23 08:50:00 | AAPL | Stock | 1.6418 | 1.6429 | 1.6418 | 1.6421 | 45948.0 |
| 2005-08-23 08:55:00 | AAPL | Stock | 1.6421 | 1.6421 | 1.6421 | 1.6421 | 14000.0 |
| 2005-08-23 09:00:00 | AAPL | Stock | 1.6421 | 1.6421 | 1.6311 | 1.6393 | 47600.0 |
| 2005-08-23 09:05:00 | AAPL | Stock | 1.64 | 1.64 | 1.64 | 1.64 | 9800.0 |
| 2005-08-23 09:10:00 | AAPL | Stock | 1.64 | 1.64 | 1.64 | 1.64 | 18396.0 |
| 2005-08-23 09:15:00 | AAPL | Stock | 1.64 | 1.6404 | 1.6382 | 1.6382 | 1573600.0 |
| 2005-08-23 09:25:00 | AAPL | Stock | 1.6393 | 1.6411 | 1.6382 | 1.6382 | 78232.0 |
| 2005-08-23 09:30:00 | AAPL | Stock | 1.6375 | 1.6464 | 1.6364 | 1.645 | 9529632.0 |
| 2005-08-23 09:35:00 | AAPL | Stock | 1.645 | 1.6461 | 1.6357 | 1.6375 | 8475740.0 |
| 2005-08-23 09:40:00 | AAPL | Stock | 1.6371 | 1.6389 | 1.6336 | 1.6379 | 9220820.0 |
| 2005-08-23 09:45:00 | AAPL | Stock | 1.6375 | 1.6389 | 1.6339 | 1.6364 | 4352012.0 |
| 2005-08-23 09:50:00 | AAPL | Stock | 1.6368 | 1.64 | 1.6343 | 1.6396 | 4240320.0 |
| 2005-08-23 09:55:00 | AAPL | Stock | 1.6396 | 1.6407 | 1.6307 | 1.6357 | 6576808.0 |
| 2005-08-23 10:00:00 | AAPL | Stock | 1.6357 | 1.6361 | 1.6332 | 1.6339 | 4671828.0 |
| 2005-08-23 10:05:00 | AAPL | Stock | 1.6339 | 1.635 | 1.6307 | 1.6336 | 4452420.0 |
| 2005-08-23 10:10:00 | AAPL | Stock | 1.6336 | 1.6368 | 1.6307 | 1.6368 | 2645384.0 |
| 2005-08-23 10:15:00 | AAPL | Stock | 1.6361 | 1.6421 | 1.6357 | 1.6411 | 4852400.0 |
| 2005-08-23 10:20:00 | AAPL | Stock | 1.6407 | 1.6429 | 1.6371 | 1.6425 | 4092396.0 |
| 2005-08-23 10:25:00 | AAPL | Stock | 1.6425 | 1.6436 | 1.6407 | 1.6425 | 4670904.0 |
| 2005-08-23 10:30:00 | AAPL | Stock | 1.6429 | 1.6429 | 1.6396 | 1.6421 | 3021172.0 |
| 2005-08-23 10:35:00 | AAPL | Stock | 1.6421 | 1.6429 | 1.6382 | 1.6382 | 2336236.0 |
| 2005-08-23 10:40:00 | AAPL | Stock | 1.6379 | 1.6386 | 1.6361 | 1.6371 | 4074756.0 |
| 2005-08-23 10:45:00 | AAPL | Stock | 1.6375 | 1.6389 | 1.6371 | 1.6386 | 1618176.0 |
| 2005-08-23 10:50:00 | AAPL | Stock | 1.6386 | 1.6386 | 1.6339 | 1.6343 | 3095596.0 |
| 2005-08-23 10:55:00 | AAPL | Stock | 1.635 | 1.6354 | 1.6314 | 1.6354 | 3480624.0 |
| 2005-08-23 11:00:00 | AAPL | Stock | 1.6354 | 1.6354 | 1.6346 | 1.6346 | 2789108.0 |
| 2005-08-23 11:05:00 | AAPL | Stock | 1.6346 | 1.6346 | 1.63 | 1.6304 | 5524092.0 |
| 2005-08-23 11:10:00 | AAPL | Stock | 1.6307 | 1.6332 | 1.6282 | 1.6321 | 5910828.0 |
| 2005-08-23 11:15:00 | AAPL | Stock | 1.6321 | 1.6336 | 1.6321 | 1.6325 | 1407280.0 |
| 2005-08-23 11:20:00 | AAPL | Stock | 1.6329 | 1.6332 | 1.6271 | 1.6311 | 6014484.0 |
| 2005-08-23 11:25:00 | AAPL | Stock | 1.6311 | 1.6314 | 1.6293 | 1.6299 | 1987412.0 |
| 2005-08-23 11:30:00 | AAPL | Stock | 1.6296 | 1.6311 | 1.6286 | 1.6293 | 3392116.0 |
| 2005-08-23 11:35:00 | AAPL | Stock | 1.6289 | 1.6296 | 1.6271 | 1.6286 | 2751308.0 |
| 2005-08-23 11:40:00 | AAPL | Stock | 1.6289 | 1.6293 | 1.6275 | 1.6275 | 2268056.0 |
| 2005-08-23 11:45:00 | AAPL | Stock | 1.6286 | 1.6286 | 1.6232 | 1.6243 | 4720352.0 |
| 2005-08-23 11:50:00 | AAPL | Stock | 1.6246 | 1.6271 | 1.6235 | 1.6257 | 2952404.0 |
| 2005-08-23 11:55:00 | AAPL | Stock | 1.6261 | 1.6261 | 1.6214 | 1.6214 | 2743272.0 |
| 2005-08-23 12:00:00 | AAPL | Stock | 1.6218 | 1.6225 | 1.6186 | 1.6204 | 6485780.0 |
| 2005-08-23 12:05:00 | AAPL | Stock | 1.6207 | 1.6236 | 1.6204 | 1.6236 | 2895592.0 |
| 2005-08-23 12:10:00 | AAPL | Stock | 1.6236 | 1.63 | 1.6236 | 1.6279 | 8701196.0 |
| 2005-08-23 12:15:00 | AAPL | Stock | 1.6279 | 1.6286 | 1.6268 | 1.6275 | 2326576.0 |
| 2005-08-23 12:20:00 | AAPL | Stock | 1.6275 | 1.6307 | 1.6275 | 1.63 | 2800924.0 |
| 2005-08-23 12:25:00 | AAPL | Stock | 1.63 | 1.63 | 1.6282 | 1.6282 | 1898372.0 |
| 2005-08-23 12:30:00 | AAPL | Stock | 1.6282 | 1.6357 | 1.6279 | 1.6289 | 4977028.0 |
| 2005-08-23 12:35:00 | AAPL | Stock | 1.6289 | 1.6357 | 1.6279 | 1.6279 | 2392488.0 |
> showing 50 of 199,056 rows — these rows as CSV