PREVIEW / stock_5min / 2009-09-29
file: by_date/stock_5min/2009/2009-09-29.parquet size: 4.6 MB rows: 318,788 symbols: 3,413
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 |
|---|---|---|---|---|---|---|---|
| 2009-09-29 07:35:00 | AAPL | Stock | 6.6568 | 6.6643 | 6.6568 | 6.6643 | 32340.0 |
| 2009-09-29 07:45:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6571 | 6.6571 | 24780.0 |
| 2009-09-29 07:50:00 | AAPL | Stock | 6.6568 | 6.6568 | 6.6568 | 6.6568 | 2800.0 |
| 2009-09-29 07:55:00 | AAPL | Stock | 6.6446 | 6.6482 | 6.6446 | 6.6482 | 16800.0 |
| 2009-09-29 08:00:00 | AAPL | Stock | 6.6482 | 6.6575 | 6.6482 | 6.6486 | 105392.0 |
| 2009-09-29 08:05:00 | AAPL | Stock | 6.65 | 6.6507 | 6.65 | 6.6507 | 15400.0 |
| 2009-09-29 08:15:00 | AAPL | Stock | 6.655 | 6.6557 | 6.6514 | 6.655 | 41720.0 |
| 2009-09-29 08:20:00 | AAPL | Stock | 6.655 | 6.6618 | 6.655 | 6.6618 | 56840.0 |
| 2009-09-29 08:25:00 | AAPL | Stock | 6.6643 | 6.6643 | 6.6571 | 6.6571 | 48300.0 |
| 2009-09-29 08:30:00 | AAPL | Stock | 6.6571 | 6.6579 | 6.6571 | 6.6571 | 14000.0 |
| 2009-09-29 08:35:00 | AAPL | Stock | 6.6554 | 6.6554 | 6.6514 | 6.6514 | 27384.0 |
| 2009-09-29 08:40:00 | AAPL | Stock | 6.6504 | 6.6525 | 6.6482 | 6.6518 | 120400.0 |
| 2009-09-29 08:45:00 | AAPL | Stock | 6.6518 | 6.6568 | 6.6518 | 6.6554 | 115360.0 |
| 2009-09-29 08:50:00 | AAPL | Stock | 6.6521 | 6.6536 | 6.6486 | 6.6486 | 65520.0 |
| 2009-09-29 08:55:00 | AAPL | Stock | 6.6482 | 6.6504 | 6.6461 | 6.6461 | 97048.0 |
| 2009-09-29 09:00:00 | AAPL | Stock | 6.6504 | 6.6571 | 6.6504 | 6.6554 | 185640.0 |
| 2009-09-29 09:05:00 | AAPL | Stock | 6.6554 | 6.6679 | 6.6554 | 6.6679 | 431648.0 |
| 2009-09-29 09:10:00 | AAPL | Stock | 6.6657 | 6.6661 | 6.6607 | 6.6643 | 285600.0 |
| 2009-09-29 09:15:00 | AAPL | Stock | 6.6636 | 6.6643 | 6.6571 | 6.6571 | 252112.0 |
| 2009-09-29 09:20:00 | AAPL | Stock | 6.6607 | 6.6625 | 6.6564 | 6.6571 | 460432.0 |
| 2009-09-29 09:25:00 | AAPL | Stock | 6.6571 | 6.6739 | 6.6493 | 6.6739 | 651336.0 |
| 2009-09-29 09:30:00 | AAPL | Stock | 6.6689 | 6.6696 | 6.6411 | 6.6514 | 11443628.0 |
| 2009-09-29 09:35:00 | AAPL | Stock | 6.6518 | 6.6875 | 6.6489 | 6.6725 | 11768400.0 |
| 2009-09-29 09:40:00 | AAPL | Stock | 6.6727 | 6.6929 | 6.6725 | 6.6821 | 12415200.0 |
| 2009-09-29 09:45:00 | AAPL | Stock | 6.6821 | 6.6868 | 6.654 | 6.6543 | 8805552.0 |
| 2009-09-29 09:50:00 | AAPL | Stock | 6.6544 | 6.6649 | 6.6411 | 6.6411 | 10232712.0 |
| 2009-09-29 09:55:00 | AAPL | Stock | 6.6414 | 6.6714 | 6.6407 | 6.6593 | 10456264.0 |
| 2009-09-29 10:00:00 | AAPL | Stock | 6.6561 | 6.6593 | 6.6125 | 6.6391 | 18143384.0 |
| 2009-09-29 10:05:00 | AAPL | Stock | 6.6389 | 6.6554 | 6.6339 | 6.6468 | 9914464.0 |
| 2009-09-29 10:10:00 | AAPL | Stock | 6.6466 | 6.6511 | 6.635 | 6.6393 | 8919176.0 |
| 2009-09-29 10:15:00 | AAPL | Stock | 6.6393 | 6.6432 | 6.6261 | 6.6321 | 5584432.0 |
| 2009-09-29 10:20:00 | AAPL | Stock | 6.6314 | 6.6368 | 6.6196 | 6.6246 | 5121480.0 |
| 2009-09-29 10:25:00 | AAPL | Stock | 6.6239 | 6.6311 | 6.6232 | 6.6299 | 4177684.0 |
| 2009-09-29 10:30:00 | AAPL | Stock | 6.63 | 6.6389 | 6.6218 | 6.6246 | 4895912.0 |
| 2009-09-29 10:35:00 | AAPL | Stock | 6.6246 | 6.6268 | 6.6136 | 6.6247 | 6795656.0 |
| 2009-09-29 10:40:00 | AAPL | Stock | 6.6246 | 6.6354 | 6.6193 | 6.6193 | 3710812.0 |
| 2009-09-29 10:45:00 | AAPL | Stock | 6.6195 | 6.6236 | 6.6139 | 6.6179 | 5362112.0 |
| 2009-09-29 10:50:00 | AAPL | Stock | 6.6176 | 6.6181 | 6.6007 | 6.6064 | 7901124.0 |
| 2009-09-29 10:55:00 | AAPL | Stock | 6.6061 | 6.6089 | 6.5893 | 6.5921 | 6392624.0 |
| 2009-09-29 11:00:00 | AAPL | Stock | 6.5907 | 6.5939 | 6.5825 | 6.5875 | 8087464.0 |
| 2009-09-29 11:05:00 | AAPL | Stock | 6.588 | 6.5946 | 6.5857 | 6.5911 | 3345384.0 |
| 2009-09-29 11:10:00 | AAPL | Stock | 6.5914 | 6.5971 | 6.5861 | 6.5893 | 2828140.0 |
| 2009-09-29 11:15:00 | AAPL | Stock | 6.5893 | 6.5982 | 6.5893 | 6.5968 | 3121104.0 |
| 2009-09-29 11:20:00 | AAPL | Stock | 6.5975 | 6.5996 | 6.5904 | 6.5993 | 2920568.0 |
| 2009-09-29 11:25:00 | AAPL | Stock | 6.5993 | 6.6146 | 6.5971 | 6.6146 | 5109076.0 |
| 2009-09-29 11:30:00 | AAPL | Stock | 6.6139 | 6.6161 | 6.6054 | 6.6129 | 3809176.0 |
| 2009-09-29 11:35:00 | AAPL | Stock | 6.6125 | 6.6136 | 6.6054 | 6.6089 | 2243164.0 |
| 2009-09-29 11:40:00 | AAPL | Stock | 6.608 | 6.6093 | 6.6018 | 6.6082 | 2295188.0 |
| 2009-09-29 11:45:00 | AAPL | Stock | 6.6082 | 6.6082 | 6.5929 | 6.5961 | 3930192.0 |
| 2009-09-29 11:50:00 | AAPL | Stock | 6.5971 | 6.6029 | 6.5921 | 6.6029 | 2139116.0 |
> showing 50 of 318,788 rows — these rows as CSV