PREVIEW / stock_5min / 2005-12-23
file: by_date/stock_5min/2005/2005-12-23.parquet size: 2.7 MB rows: 196,875 symbols: 2,154
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-12-23 04:45:00 | AAPL | Stock | 2.6518 | 2.6518 | 2.6518 | 2.6518 | 16800.0 |
| 2005-12-23 08:00:00 | AAPL | Stock | 2.6411 | 2.6482 | 2.6411 | 2.6464 | 178864.0 |
| 2005-12-23 08:05:00 | AAPL | Stock | 2.6421 | 2.6421 | 2.6421 | 2.6421 | 14000.0 |
| 2005-12-23 08:10:00 | AAPL | Stock | 2.6421 | 2.6464 | 2.6421 | 2.6464 | 153916.0 |
| 2005-12-23 08:15:00 | AAPL | Stock | 2.6429 | 2.6464 | 2.6429 | 2.6464 | 25200.0 |
| 2005-12-23 08:20:00 | AAPL | Stock | 2.6464 | 2.6482 | 2.6464 | 2.6464 | 109060.0 |
| 2005-12-23 08:25:00 | AAPL | Stock | 2.6464 | 2.6482 | 2.6464 | 2.6464 | 207200.0 |
| 2005-12-23 08:30:00 | AAPL | Stock | 2.6429 | 2.6436 | 2.6429 | 2.6436 | 56000.0 |
| 2005-12-23 08:35:00 | AAPL | Stock | 2.6446 | 2.6464 | 2.6446 | 2.6464 | 26600.0 |
| 2005-12-23 08:40:00 | AAPL | Stock | 2.6429 | 2.6446 | 2.6429 | 2.6446 | 8400.0 |
| 2005-12-23 08:50:00 | AAPL | Stock | 2.6414 | 2.6414 | 2.64 | 2.64 | 28000.0 |
| 2005-12-23 08:55:00 | AAPL | Stock | 2.6396 | 2.64 | 2.6393 | 2.6396 | 40124.0 |
| 2005-12-23 09:00:00 | AAPL | Stock | 2.6396 | 2.6396 | 2.6396 | 2.6396 | 10416.0 |
| 2005-12-23 09:05:00 | AAPL | Stock | 2.64 | 2.6404 | 2.6393 | 2.6393 | 39200.0 |
| 2005-12-23 09:10:00 | AAPL | Stock | 2.6404 | 2.6454 | 2.64 | 2.6454 | 31640.0 |
| 2005-12-23 09:15:00 | AAPL | Stock | 2.645 | 2.6464 | 2.645 | 2.6464 | 28000.0 |
| 2005-12-23 09:25:00 | AAPL | Stock | 2.6479 | 2.6504 | 2.6443 | 2.65 | 305984.0 |
| 2005-12-23 09:30:00 | AAPL | Stock | 2.6489 | 2.6521 | 2.6446 | 2.6467 | 10639888.0 |
| 2005-12-23 09:35:00 | AAPL | Stock | 2.6468 | 2.6468 | 2.6389 | 2.6429 | 7166628.0 |
| 2005-12-23 09:40:00 | AAPL | Stock | 2.6425 | 2.6443 | 2.6364 | 2.6379 | 5175128.0 |
| 2005-12-23 09:45:00 | AAPL | Stock | 2.6379 | 2.6418 | 2.6325 | 2.6414 | 7413364.0 |
| 2005-12-23 09:50:00 | AAPL | Stock | 2.6414 | 2.6454 | 2.6393 | 2.6425 | 5887616.0 |
| 2005-12-23 09:55:00 | AAPL | Stock | 2.6425 | 2.6489 | 2.6421 | 2.6443 | 5147800.0 |
| 2005-12-23 10:00:00 | AAPL | Stock | 2.6446 | 2.6446 | 2.64 | 2.6407 | 3024196.0 |
| 2005-12-23 10:05:00 | AAPL | Stock | 2.6404 | 2.6421 | 2.6375 | 2.6407 | 4478180.0 |
| 2005-12-23 10:10:00 | AAPL | Stock | 2.6404 | 2.6418 | 2.6393 | 2.64 | 1958964.0 |
| 2005-12-23 10:15:00 | AAPL | Stock | 2.6404 | 2.6418 | 2.6371 | 2.6379 | 3379264.0 |
| 2005-12-23 10:20:00 | AAPL | Stock | 2.6378 | 2.6393 | 2.6361 | 2.6382 | 4713940.0 |
| 2005-12-23 10:25:00 | AAPL | Stock | 2.6382 | 2.6386 | 2.6339 | 2.6354 | 4516092.0 |
| 2005-12-23 10:30:00 | AAPL | Stock | 2.635 | 2.635 | 2.6271 | 2.6318 | 9633428.0 |
| 2005-12-23 10:35:00 | AAPL | Stock | 2.6304 | 2.635 | 2.6261 | 2.6275 | 6271580.0 |
| 2005-12-23 10:40:00 | AAPL | Stock | 2.6275 | 2.6286 | 2.625 | 2.6261 | 7044604.0 |
| 2005-12-23 10:45:00 | AAPL | Stock | 2.6261 | 2.6296 | 2.6257 | 2.6289 | 4163572.0 |
| 2005-12-23 10:50:00 | AAPL | Stock | 2.6293 | 2.6311 | 2.6262 | 2.6282 | 3969420.0 |
| 2005-12-23 10:55:00 | AAPL | Stock | 2.6282 | 2.6321 | 2.6282 | 2.6293 | 2941064.0 |
| 2005-12-23 11:00:00 | AAPL | Stock | 2.6293 | 2.6311 | 2.6286 | 2.6296 | 2387868.0 |
| 2005-12-23 11:05:00 | AAPL | Stock | 2.6296 | 2.6296 | 2.6257 | 2.6257 | 3434816.0 |
| 2005-12-23 11:10:00 | AAPL | Stock | 2.6257 | 2.6293 | 2.6257 | 2.6285 | 2488808.0 |
| 2005-12-23 11:15:00 | AAPL | Stock | 2.6282 | 2.6286 | 2.6261 | 2.6271 | 2335340.0 |
| 2005-12-23 11:20:00 | AAPL | Stock | 2.6271 | 2.6304 | 2.6261 | 2.63 | 1942052.0 |
| 2005-12-23 11:25:00 | AAPL | Stock | 2.63 | 2.6314 | 2.6289 | 2.63 | 1642564.0 |
| 2005-12-23 11:30:00 | AAPL | Stock | 2.6297 | 2.6304 | 2.6282 | 2.6293 | 1296204.0 |
| 2005-12-23 11:35:00 | AAPL | Stock | 2.6293 | 2.6307 | 2.6286 | 2.6293 | 3127124.0 |
| 2005-12-23 11:40:00 | AAPL | Stock | 2.6289 | 2.6289 | 2.6261 | 2.6264 | 1954876.0 |
| 2005-12-23 11:45:00 | AAPL | Stock | 2.6264 | 2.6264 | 2.6243 | 2.6243 | 3854340.0 |
| 2005-12-23 11:50:00 | AAPL | Stock | 2.6243 | 2.63 | 2.6211 | 2.6214 | 7391860.0 |
| 2005-12-23 11:55:00 | AAPL | Stock | 2.6211 | 2.6257 | 2.6186 | 2.6239 | 4388804.0 |
| 2005-12-23 12:00:00 | AAPL | Stock | 2.6246 | 2.6264 | 2.6232 | 2.6232 | 2166220.0 |
| 2005-12-23 12:05:00 | AAPL | Stock | 2.6232 | 2.6282 | 2.6232 | 2.6279 | 2457784.0 |
| 2005-12-23 12:10:00 | AAPL | Stock | 2.6279 | 2.6282 | 2.6232 | 2.625 | 1902544.0 |
> showing 50 of 196,875 rows — these rows as CSV