PREVIEW / stock_5min / 2008-05-07
file: by_date/stock_5min/2008/2008-05-07.parquet size: 4.5 MB rows: 318,263 symbols: 3,288
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 |
|---|---|---|---|---|---|---|---|
| 2008-05-07 06:20:00 | AAPL | Stock | 6.6539 | 6.6539 | 6.6539 | 6.6539 | 2800.0 |
| 2008-05-07 07:00:00 | AAPL | Stock | 6.66 | 6.6629 | 6.66 | 6.6625 | 25200.0 |
| 2008-05-07 07:10:00 | AAPL | Stock | 6.6429 | 6.6571 | 6.6429 | 6.6571 | 23800.0 |
| 2008-05-07 07:15:00 | AAPL | Stock | 6.6518 | 6.6518 | 6.6518 | 6.6518 | 2800.0 |
| 2008-05-07 07:20:00 | AAPL | Stock | 6.6357 | 6.6357 | 6.6357 | 6.6357 | 8400.0 |
| 2008-05-07 07:25:00 | AAPL | Stock | 6.6321 | 6.6357 | 6.6321 | 6.6357 | 5600.0 |
| 2008-05-07 07:30:00 | AAPL | Stock | 6.6357 | 6.6357 | 6.6357 | 6.6357 | 5600.0 |
| 2008-05-07 07:35:00 | AAPL | Stock | 6.6232 | 6.6336 | 6.6214 | 6.6336 | 29568.0 |
| 2008-05-07 07:40:00 | AAPL | Stock | 6.6171 | 6.6193 | 6.6168 | 6.6189 | 27300.0 |
| 2008-05-07 07:45:00 | AAPL | Stock | 6.6207 | 6.6207 | 6.6207 | 6.6207 | 2800.0 |
| 2008-05-07 07:50:00 | AAPL | Stock | 6.6264 | 6.6268 | 6.6225 | 6.6225 | 66500.0 |
| 2008-05-07 07:55:00 | AAPL | Stock | 6.6229 | 6.6229 | 6.6225 | 6.6225 | 11900.0 |
| 2008-05-07 08:00:00 | AAPL | Stock | 6.6254 | 6.6357 | 6.6254 | 6.6346 | 372064.0 |
| 2008-05-07 08:05:00 | AAPL | Stock | 6.64 | 6.6496 | 6.6321 | 6.6332 | 427756.0 |
| 2008-05-07 08:10:00 | AAPL | Stock | 6.6332 | 6.6375 | 6.6332 | 6.6375 | 75600.0 |
| 2008-05-07 08:15:00 | AAPL | Stock | 6.6418 | 6.6439 | 6.6375 | 6.6375 | 144816.0 |
| 2008-05-07 08:20:00 | AAPL | Stock | 6.635 | 6.6375 | 6.6318 | 6.6361 | 380016.0 |
| 2008-05-07 08:25:00 | AAPL | Stock | 6.6357 | 6.6357 | 6.6254 | 6.6304 | 358988.0 |
| 2008-05-07 08:30:00 | AAPL | Stock | 6.6314 | 6.6475 | 6.6314 | 6.6357 | 738080.0 |
| 2008-05-07 08:35:00 | AAPL | Stock | 6.6364 | 6.6436 | 6.6364 | 6.6436 | 194600.0 |
| 2008-05-07 08:40:00 | AAPL | Stock | 6.6436 | 6.655 | 6.6436 | 6.65 | 285600.0 |
| 2008-05-07 08:45:00 | AAPL | Stock | 6.6518 | 6.6625 | 6.6518 | 6.6618 | 387632.0 |
| 2008-05-07 08:50:00 | AAPL | Stock | 6.66 | 6.6611 | 6.6518 | 6.6518 | 196672.0 |
| 2008-05-07 08:55:00 | AAPL | Stock | 6.655 | 6.6571 | 6.6429 | 6.6429 | 403088.0 |
| 2008-05-07 09:00:00 | AAPL | Stock | 6.6461 | 6.6514 | 6.6429 | 6.6457 | 371700.0 |
| 2008-05-07 09:05:00 | AAPL | Stock | 6.6454 | 6.6496 | 6.6454 | 6.6468 | 256200.0 |
| 2008-05-07 09:10:00 | AAPL | Stock | 6.6464 | 6.6518 | 6.6429 | 6.6493 | 347704.0 |
| 2008-05-07 09:15:00 | AAPL | Stock | 6.6493 | 6.6664 | 6.6482 | 6.6575 | 557732.0 |
| 2008-05-07 09:20:00 | AAPL | Stock | 6.6575 | 6.6589 | 6.6518 | 6.6518 | 447748.0 |
| 2008-05-07 09:25:00 | AAPL | Stock | 6.6521 | 6.6543 | 6.6321 | 6.6471 | 319676.0 |
| 2008-05-07 09:30:00 | AAPL | Stock | 6.645 | 6.6579 | 6.6125 | 6.6296 | 24464048.0 |
| 2008-05-07 09:35:00 | AAPL | Stock | 6.6304 | 6.6361 | 6.6093 | 6.6304 | 23240112.0 |
| 2008-05-07 09:40:00 | AAPL | Stock | 6.6304 | 6.6304 | 6.5989 | 6.6168 | 23421524.0 |
| 2008-05-07 09:45:00 | AAPL | Stock | 6.6175 | 6.6464 | 6.6143 | 6.6425 | 18196164.0 |
| 2008-05-07 09:50:00 | AAPL | Stock | 6.6416 | 6.65 | 6.6343 | 6.6371 | 17543624.0 |
| 2008-05-07 09:55:00 | AAPL | Stock | 6.6357 | 6.6411 | 6.625 | 6.6339 | 12181400.0 |
| 2008-05-07 10:00:00 | AAPL | Stock | 6.6343 | 6.6461 | 6.6196 | 6.6257 | 16211524.0 |
| 2008-05-07 10:05:00 | AAPL | Stock | 6.6256 | 6.65 | 6.6221 | 6.645 | 15166816.0 |
| 2008-05-07 10:10:00 | AAPL | Stock | 6.6475 | 6.6714 | 6.6429 | 6.6654 | 21896980.0 |
| 2008-05-07 10:15:00 | AAPL | Stock | 6.6661 | 6.6818 | 6.6586 | 6.6718 | 19472572.0 |
| 2008-05-07 10:20:00 | AAPL | Stock | 6.6714 | 6.6757 | 6.6579 | 6.675 | 12705112.0 |
| 2008-05-07 10:25:00 | AAPL | Stock | 6.675 | 6.6879 | 6.6739 | 6.6779 | 17146864.0 |
| 2008-05-07 10:30:00 | AAPL | Stock | 6.6775 | 6.6879 | 6.675 | 6.6761 | 13165236.0 |
| 2008-05-07 10:35:00 | AAPL | Stock | 6.6761 | 6.6875 | 6.6714 | 6.6864 | 10919132.0 |
| 2008-05-07 10:40:00 | AAPL | Stock | 6.6864 | 6.7029 | 6.6847 | 6.7018 | 17402308.0 |
| 2008-05-07 10:45:00 | AAPL | Stock | 6.7018 | 6.7036 | 6.6879 | 6.6961 | 11861724.0 |
| 2008-05-07 10:50:00 | AAPL | Stock | 6.6961 | 6.7054 | 6.6889 | 6.7039 | 15297212.0 |
| 2008-05-07 10:55:00 | AAPL | Stock | 6.7037 | 6.7071 | 6.6786 | 6.685 | 13819764.0 |
| 2008-05-07 11:00:00 | AAPL | Stock | 6.6854 | 6.6896 | 6.6757 | 6.6846 | 10874332.0 |
| 2008-05-07 11:05:00 | AAPL | Stock | 6.6854 | 6.7107 | 6.6804 | 6.7079 | 18545604.0 |
> showing 50 of 318,263 rows — these rows as CSV