PREVIEW / stock_5min / 2008-02-06
file: by_date/stock_5min/2008/2008-02-06.parquet size: 4.4 MB rows: 317,855 symbols: 3,253
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-02-06 05:30:00 | AAPL | Stock | 4.6357 | 4.6357 | 4.6357 | 4.6357 | 8400.0 |
| 2008-02-06 05:40:00 | AAPL | Stock | 4.6357 | 4.6357 | 4.6357 | 4.6357 | 2800.0 |
| 2008-02-06 06:05:00 | AAPL | Stock | 4.6396 | 4.6396 | 4.6396 | 4.6396 | 19600.0 |
| 2008-02-06 06:50:00 | AAPL | Stock | 4.6429 | 4.6429 | 4.6429 | 4.6429 | 8400.0 |
| 2008-02-06 07:20:00 | AAPL | Stock | 4.6518 | 4.6771 | 4.6518 | 4.6771 | 105000.0 |
| 2008-02-06 07:25:00 | AAPL | Stock | 4.6696 | 4.6696 | 4.6643 | 4.6643 | 107100.0 |
| 2008-02-06 07:30:00 | AAPL | Stock | 4.6696 | 4.6721 | 4.6643 | 4.6643 | 36400.0 |
| 2008-02-06 07:35:00 | AAPL | Stock | 4.6725 | 4.6786 | 4.6725 | 4.6764 | 55440.0 |
| 2008-02-06 07:40:00 | AAPL | Stock | 4.6621 | 4.6621 | 4.6614 | 4.6614 | 18452.0 |
| 2008-02-06 07:45:00 | AAPL | Stock | 4.6621 | 4.6621 | 4.6621 | 4.6621 | 14000.0 |
| 2008-02-06 07:55:00 | AAPL | Stock | 4.6725 | 4.6743 | 4.6725 | 4.6743 | 16800.0 |
| 2008-02-06 08:00:00 | AAPL | Stock | 4.665 | 4.6729 | 4.6582 | 4.6643 | 471828.0 |
| 2008-02-06 08:05:00 | AAPL | Stock | 4.6571 | 4.6607 | 4.6504 | 4.6504 | 179060.0 |
| 2008-02-06 08:10:00 | AAPL | Stock | 4.6464 | 4.6514 | 4.6432 | 4.6461 | 350980.0 |
| 2008-02-06 08:15:00 | AAPL | Stock | 4.6482 | 4.65 | 4.6446 | 4.6446 | 64820.0 |
| 2008-02-06 08:20:00 | AAPL | Stock | 4.6496 | 4.65 | 4.6396 | 4.6429 | 302932.0 |
| 2008-02-06 08:25:00 | AAPL | Stock | 4.6393 | 4.6471 | 4.6339 | 4.6425 | 306208.0 |
| 2008-02-06 08:30:00 | AAPL | Stock | 4.6482 | 4.6586 | 4.6471 | 4.6586 | 440216.0 |
| 2008-02-06 08:35:00 | AAPL | Stock | 4.6571 | 4.665 | 4.6554 | 4.665 | 166768.0 |
| 2008-02-06 08:40:00 | AAPL | Stock | 4.665 | 4.665 | 4.6543 | 4.6543 | 358176.0 |
| 2008-02-06 08:45:00 | AAPL | Stock | 4.6518 | 4.6557 | 4.6486 | 4.6554 | 264432.0 |
| 2008-02-06 08:50:00 | AAPL | Stock | 4.6536 | 4.6536 | 4.645 | 4.6496 | 134960.0 |
| 2008-02-06 08:55:00 | AAPL | Stock | 4.65 | 4.6554 | 4.6496 | 4.6536 | 120680.0 |
| 2008-02-06 09:00:00 | AAPL | Stock | 4.655 | 4.6625 | 4.6539 | 4.6607 | 170800.0 |
| 2008-02-06 09:05:00 | AAPL | Stock | 4.6607 | 4.6679 | 4.6607 | 4.6639 | 237384.0 |
| 2008-02-06 09:10:00 | AAPL | Stock | 4.6639 | 4.6654 | 4.6539 | 4.6589 | 224000.0 |
| 2008-02-06 09:15:00 | AAPL | Stock | 4.6589 | 4.6632 | 4.6575 | 4.6575 | 137200.0 |
| 2008-02-06 09:20:00 | AAPL | Stock | 4.6579 | 4.6646 | 4.6579 | 4.6636 | 90720.0 |
| 2008-02-06 09:25:00 | AAPL | Stock | 4.6636 | 4.6757 | 4.6625 | 4.6757 | 1113196.0 |
| 2008-02-06 09:30:00 | AAPL | Stock | 4.6757 | 4.6896 | 4.6575 | 4.6611 | 25160884.0 |
| 2008-02-06 09:35:00 | AAPL | Stock | 4.6618 | 4.6821 | 4.6578 | 4.6693 | 20891724.0 |
| 2008-02-06 09:40:00 | AAPL | Stock | 4.6689 | 4.6768 | 4.6429 | 4.655 | 22692096.0 |
| 2008-02-06 09:45:00 | AAPL | Stock | 4.6554 | 4.6675 | 4.6454 | 4.6502 | 16959488.0 |
| 2008-02-06 09:50:00 | AAPL | Stock | 4.6507 | 4.6607 | 4.6368 | 4.6539 | 18829636.0 |
| 2008-02-06 09:55:00 | AAPL | Stock | 4.6546 | 4.6786 | 4.6429 | 4.6768 | 22167348.0 |
| 2008-02-06 10:00:00 | AAPL | Stock | 4.6765 | 4.7089 | 4.6746 | 4.7029 | 30799916.0 |
| 2008-02-06 10:05:00 | AAPL | Stock | 4.7032 | 4.7086 | 4.6914 | 4.7018 | 22005508.0 |
| 2008-02-06 10:10:00 | AAPL | Stock | 4.7025 | 4.7114 | 4.6854 | 4.69 | 20442408.0 |
| 2008-02-06 10:15:00 | AAPL | Stock | 4.69 | 4.6971 | 4.6675 | 4.6711 | 15308608.0 |
| 2008-02-06 10:20:00 | AAPL | Stock | 4.6714 | 4.68 | 4.6432 | 4.6436 | 15142848.0 |
| 2008-02-06 10:25:00 | AAPL | Stock | 4.6436 | 4.6471 | 4.6264 | 4.6357 | 26148864.0 |
| 2008-02-06 10:30:00 | AAPL | Stock | 4.6354 | 4.6446 | 4.6064 | 4.6289 | 26190052.0 |
| 2008-02-06 10:35:00 | AAPL | Stock | 4.6261 | 4.6464 | 4.6218 | 4.6406 | 17324832.0 |
| 2008-02-06 10:40:00 | AAPL | Stock | 4.6402 | 4.6571 | 4.6357 | 4.6529 | 16940784.0 |
| 2008-02-06 10:45:00 | AAPL | Stock | 4.6529 | 4.654 | 4.6339 | 4.6382 | 12313140.0 |
| 2008-02-06 10:50:00 | AAPL | Stock | 4.6382 | 4.6396 | 4.6171 | 4.6204 | 16490012.0 |
| 2008-02-06 10:55:00 | AAPL | Stock | 4.6204 | 4.6357 | 4.5918 | 4.6111 | 23420040.0 |
| 2008-02-06 11:00:00 | AAPL | Stock | 4.6111 | 4.6304 | 4.6 | 4.6239 | 25023208.0 |
| 2008-02-06 11:05:00 | AAPL | Stock | 4.6243 | 4.6346 | 4.6111 | 4.6136 | 17027304.0 |
| 2008-02-06 11:10:00 | AAPL | Stock | 4.6143 | 4.6282 | 4.6071 | 4.6239 | 10176180.0 |
> showing 50 of 317,855 rows — these rows as CSV