PREVIEW / stock_5min / 2010-12-28
file: by_date/stock_5min/2010/2010-12-28.parquet size: 4.6 MB rows: 317,729 symbols: 3,525
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-28 04:25:00 | AAPL | Stock | 11.6686 | 11.6686 | 11.6686 | 11.6686 | 2800.0 |
| 2010-12-28 06:35:00 | AAPL | Stock | 11.6964 | 11.6982 | 11.6929 | 11.6929 | 22400.0 |
| 2010-12-28 06:50:00 | AAPL | Stock | 11.6704 | 11.6704 | 11.67 | 11.67 | 5600.0 |
| 2010-12-28 07:05:00 | AAPL | Stock | 11.6579 | 11.6579 | 11.6579 | 11.6579 | 5600.0 |
| 2010-12-28 07:15:00 | AAPL | Stock | 11.6775 | 11.6779 | 11.6775 | 11.6779 | 28000.0 |
| 2010-12-28 07:20:00 | AAPL | Stock | 11.6575 | 11.6575 | 11.6571 | 11.6571 | 5600.0 |
| 2010-12-28 07:25:00 | AAPL | Stock | 11.6782 | 11.6782 | 11.6782 | 11.6782 | 2800.0 |
| 2010-12-28 07:30:00 | AAPL | Stock | 11.6746 | 11.6757 | 11.6746 | 11.6757 | 28000.0 |
| 2010-12-28 07:35:00 | AAPL | Stock | 11.6661 | 11.6661 | 11.6639 | 11.6639 | 22400.0 |
| 2010-12-28 07:40:00 | AAPL | Stock | 11.6607 | 11.6607 | 11.6539 | 11.6539 | 5600.0 |
| 2010-12-28 07:50:00 | AAPL | Stock | 11.6546 | 11.6546 | 11.6546 | 11.6546 | 42000.0 |
| 2010-12-28 07:55:00 | AAPL | Stock | 11.6604 | 11.6604 | 11.6511 | 11.6511 | 11200.0 |
| 2010-12-28 08:00:00 | AAPL | Stock | 11.65 | 11.6539 | 11.6189 | 11.6393 | 476896.0 |
| 2010-12-28 08:05:00 | AAPL | Stock | 11.6321 | 11.6361 | 11.6286 | 11.6289 | 229460.0 |
| 2010-12-28 08:10:00 | AAPL | Stock | 11.6339 | 11.6421 | 11.6321 | 11.6411 | 85316.0 |
| 2010-12-28 08:15:00 | AAPL | Stock | 11.6425 | 11.6425 | 11.6371 | 11.6371 | 59360.0 |
| 2010-12-28 08:20:00 | AAPL | Stock | 11.6357 | 11.6357 | 11.6314 | 11.6339 | 44800.0 |
| 2010-12-28 08:25:00 | AAPL | Stock | 11.6354 | 11.6354 | 11.6304 | 11.6304 | 14000.0 |
| 2010-12-28 08:30:00 | AAPL | Stock | 11.6357 | 11.6375 | 11.6311 | 11.6339 | 76720.0 |
| 2010-12-28 08:35:00 | AAPL | Stock | 11.6339 | 11.6461 | 11.6339 | 11.6461 | 148036.0 |
| 2010-12-28 08:40:00 | AAPL | Stock | 11.6439 | 11.6461 | 11.64 | 11.6429 | 241080.0 |
| 2010-12-28 08:45:00 | AAPL | Stock | 11.6411 | 11.6457 | 11.6411 | 11.6429 | 108780.0 |
| 2010-12-28 08:50:00 | AAPL | Stock | 11.6421 | 11.6454 | 11.6414 | 11.645 | 60200.0 |
| 2010-12-28 08:55:00 | AAPL | Stock | 11.6446 | 11.6464 | 11.6421 | 11.6436 | 148624.0 |
| 2010-12-28 09:00:00 | AAPL | Stock | 11.6432 | 11.6432 | 11.6414 | 11.6418 | 161644.0 |
| 2010-12-28 09:05:00 | AAPL | Stock | 11.6429 | 11.6525 | 11.6429 | 11.6525 | 339976.0 |
| 2010-12-28 09:10:00 | AAPL | Stock | 11.6532 | 11.6571 | 11.6518 | 11.6554 | 156996.0 |
| 2010-12-28 09:15:00 | AAPL | Stock | 11.6564 | 11.6564 | 11.65 | 11.6561 | 91700.0 |
| 2010-12-28 09:20:00 | AAPL | Stock | 11.6561 | 11.6571 | 11.6536 | 11.6564 | 66920.0 |
| 2010-12-28 09:25:00 | AAPL | Stock | 11.6536 | 11.6571 | 11.6357 | 11.6414 | 330708.0 |
| 2010-12-28 09:30:00 | AAPL | Stock | 11.6396 | 11.6664 | 11.6364 | 11.6519 | 11131512.0 |
| 2010-12-28 09:35:00 | AAPL | Stock | 11.6521 | 11.6525 | 11.6118 | 11.6146 | 7757120.0 |
| 2010-12-28 09:40:00 | AAPL | Stock | 11.6154 | 11.6446 | 11.6136 | 11.6331 | 6292776.0 |
| 2010-12-28 09:45:00 | AAPL | Stock | 11.6339 | 11.6464 | 11.6326 | 11.6459 | 4297216.0 |
| 2010-12-28 09:50:00 | AAPL | Stock | 11.6461 | 11.6496 | 11.6421 | 11.6421 | 4781812.0 |
| 2010-12-28 09:55:00 | AAPL | Stock | 11.6421 | 11.6454 | 11.6354 | 11.6371 | 4347364.0 |
| 2010-12-28 10:00:00 | AAPL | Stock | 11.6371 | 11.6482 | 11.625 | 11.6371 | 5579644.0 |
| 2010-12-28 10:05:00 | AAPL | Stock | 11.6357 | 11.6411 | 11.62 | 11.6239 | 6362888.0 |
| 2010-12-28 10:10:00 | AAPL | Stock | 11.6257 | 11.6264 | 11.6093 | 11.6186 | 4277392.0 |
| 2010-12-28 10:15:00 | AAPL | Stock | 11.6186 | 11.6268 | 11.6146 | 11.6261 | 2765868.0 |
| 2010-12-28 10:20:00 | AAPL | Stock | 11.6271 | 11.6339 | 11.6232 | 11.6329 | 2547384.0 |
| 2010-12-28 10:25:00 | AAPL | Stock | 11.6339 | 11.6371 | 11.6257 | 11.6364 | 1991388.0 |
| 2010-12-28 10:30:00 | AAPL | Stock | 11.6364 | 11.6414 | 11.6296 | 11.63 | 2578744.0 |
| 2010-12-28 10:35:00 | AAPL | Stock | 11.6304 | 11.6371 | 11.6279 | 11.6357 | 1346632.0 |
| 2010-12-28 10:40:00 | AAPL | Stock | 11.6371 | 11.6389 | 11.6304 | 11.635 | 2577512.0 |
| 2010-12-28 10:45:00 | AAPL | Stock | 11.6353 | 11.6404 | 11.6336 | 11.635 | 1728244.0 |
| 2010-12-28 10:50:00 | AAPL | Stock | 11.6364 | 11.6404 | 11.6354 | 11.6387 | 1516760.0 |
| 2010-12-28 10:55:00 | AAPL | Stock | 11.6387 | 11.6394 | 11.6336 | 11.6354 | 1587152.0 |
| 2010-12-28 11:00:00 | AAPL | Stock | 11.6346 | 11.6486 | 11.6329 | 11.6411 | 3324664.0 |
| 2010-12-28 11:05:00 | AAPL | Stock | 11.6407 | 11.6471 | 11.6382 | 11.6468 | 3226048.0 |
> showing 50 of 317,729 rows — these rows as CSV