PREVIEW / stock_5min / 2005-12-07
file: by_date/stock_5min/2005/2005-12-07.parquet size: 2.9 MB rows: 211,370 symbols: 2,107
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-07 07:55:00 | AAPL | Stock | 2.6404 | 2.6518 | 2.6404 | 2.6518 | 46200.0 |
| 2005-12-07 08:00:00 | AAPL | Stock | 2.6518 | 2.6575 | 2.645 | 2.6571 | 453348.0 |
| 2005-12-07 08:05:00 | AAPL | Stock | 2.6571 | 2.6586 | 2.65 | 2.6557 | 694848.0 |
| 2005-12-07 08:10:00 | AAPL | Stock | 2.6571 | 2.66 | 2.6571 | 2.6571 | 230832.0 |
| 2005-12-07 08:15:00 | AAPL | Stock | 2.6554 | 2.6571 | 2.6536 | 2.6568 | 87220.0 |
| 2005-12-07 08:20:00 | AAPL | Stock | 2.6568 | 2.6568 | 2.6554 | 2.6557 | 225400.0 |
| 2005-12-07 08:25:00 | AAPL | Stock | 2.6554 | 2.6554 | 2.6482 | 2.6518 | 358988.0 |
| 2005-12-07 08:30:00 | AAPL | Stock | 2.65 | 2.6504 | 2.6436 | 2.6443 | 1448104.0 |
| 2005-12-07 08:35:00 | AAPL | Stock | 2.6418 | 2.6471 | 2.6318 | 2.6414 | 894544.0 |
| 2005-12-07 08:40:00 | AAPL | Stock | 2.6418 | 2.6425 | 2.6386 | 2.6393 | 300216.0 |
| 2005-12-07 08:45:00 | AAPL | Stock | 2.6393 | 2.6393 | 2.6307 | 2.6318 | 1144500.0 |
| 2005-12-07 08:50:00 | AAPL | Stock | 2.6318 | 2.6364 | 2.6307 | 2.6361 | 481936.0 |
| 2005-12-07 08:55:00 | AAPL | Stock | 2.6357 | 2.6411 | 2.6357 | 2.6411 | 103600.0 |
| 2005-12-07 09:00:00 | AAPL | Stock | 2.6411 | 2.6457 | 2.64 | 2.6443 | 785400.0 |
| 2005-12-07 09:05:00 | AAPL | Stock | 2.6443 | 2.6443 | 2.6404 | 2.6404 | 138432.0 |
| 2005-12-07 09:10:00 | AAPL | Stock | 2.6407 | 2.6418 | 2.6389 | 2.6389 | 189560.0 |
| 2005-12-07 09:15:00 | AAPL | Stock | 2.6382 | 2.6382 | 2.6379 | 2.6382 | 16800.0 |
| 2005-12-07 09:20:00 | AAPL | Stock | 2.6386 | 2.6436 | 2.6386 | 2.6429 | 254296.0 |
| 2005-12-07 09:25:00 | AAPL | Stock | 2.6407 | 2.6518 | 2.64 | 2.6511 | 1696156.0 |
| 2005-12-07 09:30:00 | AAPL | Stock | 2.6511 | 2.6514 | 2.6282 | 2.6386 | 27859524.0 |
| 2005-12-07 09:35:00 | AAPL | Stock | 2.6386 | 2.6496 | 2.6314 | 2.6468 | 18132212.0 |
| 2005-12-07 09:40:00 | AAPL | Stock | 2.6464 | 2.6536 | 2.6364 | 2.6386 | 20805064.0 |
| 2005-12-07 09:45:00 | AAPL | Stock | 2.6386 | 2.6479 | 2.6364 | 2.6457 | 13683124.0 |
| 2005-12-07 09:50:00 | AAPL | Stock | 2.6457 | 2.6493 | 2.6439 | 2.6471 | 11145316.0 |
| 2005-12-07 09:55:00 | AAPL | Stock | 2.6471 | 2.6593 | 2.6461 | 2.6571 | 16767968.0 |
| 2005-12-07 10:00:00 | AAPL | Stock | 2.6571 | 2.6582 | 2.6511 | 2.6575 | 12287268.0 |
| 2005-12-07 10:05:00 | AAPL | Stock | 2.6571 | 2.6586 | 2.6486 | 2.6529 | 11921700.0 |
| 2005-12-07 10:10:00 | AAPL | Stock | 2.6529 | 2.6532 | 2.6411 | 2.6443 | 13562388.0 |
| 2005-12-07 10:15:00 | AAPL | Stock | 2.6446 | 2.645 | 2.6339 | 2.6382 | 19081580.0 |
| 2005-12-07 10:20:00 | AAPL | Stock | 2.6379 | 2.6393 | 2.6339 | 2.6361 | 14014112.0 |
| 2005-12-07 10:25:00 | AAPL | Stock | 2.6357 | 2.6375 | 2.6318 | 2.6343 | 14869092.0 |
| 2005-12-07 10:30:00 | AAPL | Stock | 2.6343 | 2.6418 | 2.6325 | 2.6336 | 15140888.0 |
| 2005-12-07 10:35:00 | AAPL | Stock | 2.6336 | 2.6418 | 2.6332 | 2.6379 | 9275196.0 |
| 2005-12-07 10:40:00 | AAPL | Stock | 2.6379 | 2.6418 | 2.6378 | 2.6393 | 6339200.0 |
| 2005-12-07 10:45:00 | AAPL | Stock | 2.6393 | 2.6396 | 2.6261 | 2.6304 | 17826844.0 |
| 2005-12-07 10:50:00 | AAPL | Stock | 2.6304 | 2.6392 | 2.6161 | 2.6196 | 20926472.0 |
| 2005-12-07 10:55:00 | AAPL | Stock | 2.6196 | 2.6254 | 2.6136 | 2.6136 | 15973832.0 |
| 2005-12-07 11:00:00 | AAPL | Stock | 2.6136 | 2.6207 | 2.6121 | 2.6157 | 14217000.0 |
| 2005-12-07 11:05:00 | AAPL | Stock | 2.6157 | 2.6429 | 2.6114 | 2.6204 | 14609196.0 |
| 2005-12-07 11:10:00 | AAPL | Stock | 2.6207 | 2.6229 | 2.6143 | 2.6193 | 9471616.0 |
| 2005-12-07 11:15:00 | AAPL | Stock | 2.6193 | 2.6211 | 2.6168 | 2.6186 | 5741120.0 |
| 2005-12-07 11:20:00 | AAPL | Stock | 2.6182 | 2.6268 | 2.6179 | 2.6254 | 8236984.0 |
| 2005-12-07 11:25:00 | AAPL | Stock | 2.6257 | 2.6257 | 2.6182 | 2.6204 | 6129844.0 |
| 2005-12-07 11:30:00 | AAPL | Stock | 2.6204 | 2.6264 | 2.6182 | 2.6243 | 7299404.0 |
| 2005-12-07 11:35:00 | AAPL | Stock | 2.625 | 2.63 | 2.6243 | 2.6293 | 7655788.0 |
| 2005-12-07 11:40:00 | AAPL | Stock | 2.6296 | 2.6304 | 2.6257 | 2.6282 | 6913312.0 |
| 2005-12-07 11:45:00 | AAPL | Stock | 2.6282 | 2.6286 | 2.6239 | 2.6257 | 4431812.0 |
| 2005-12-07 11:50:00 | AAPL | Stock | 2.6254 | 2.6304 | 2.625 | 2.6279 | 4916492.0 |
| 2005-12-07 11:55:00 | AAPL | Stock | 2.6282 | 2.6304 | 2.6186 | 2.6193 | 6172376.0 |
| 2005-12-07 12:00:00 | AAPL | Stock | 2.6189 | 2.6243 | 2.6186 | 2.6239 | 3894016.0 |
> showing 50 of 211,370 rows — these rows as CSV