PREVIEW / stock_5min / 2007-11-02
file: by_date/stock_5min/2007/2007-11-02.parquet size: 4.4 MB rows: 317,170 symbols: 3,163
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 |
|---|---|---|---|---|---|---|---|
| 2007-11-02 05:30:00 | AAPL | Stock | 6.6918 | 6.6918 | 6.6918 | 6.6918 | 11200.0 |
| 2007-11-02 05:45:00 | AAPL | Stock | 6.6918 | 6.6918 | 6.6918 | 6.6918 | 23800.0 |
| 2007-11-02 06:00:00 | AAPL | Stock | 6.6982 | 6.6982 | 6.6982 | 6.6982 | 2800.0 |
| 2007-11-02 06:15:00 | AAPL | Stock | 6.6982 | 6.6982 | 6.6982 | 6.6982 | 4200.0 |
| 2007-11-02 07:05:00 | AAPL | Stock | 6.6911 | 6.6911 | 6.6911 | 6.6911 | 5600.0 |
| 2007-11-02 07:15:00 | AAPL | Stock | 6.6875 | 6.6875 | 6.6836 | 6.6836 | 36400.0 |
| 2007-11-02 07:20:00 | AAPL | Stock | 6.6836 | 6.6836 | 6.6836 | 6.6836 | 109200.0 |
| 2007-11-02 07:30:00 | AAPL | Stock | 6.6857 | 6.6857 | 6.6825 | 6.6825 | 75600.0 |
| 2007-11-02 07:35:00 | AAPL | Stock | 6.6754 | 6.6754 | 6.6754 | 6.6754 | 5600.0 |
| 2007-11-02 07:45:00 | AAPL | Stock | 6.6889 | 6.6893 | 6.6889 | 6.6893 | 54600.0 |
| 2007-11-02 07:50:00 | AAPL | Stock | 6.6911 | 6.6911 | 6.6911 | 6.6911 | 11200.0 |
| 2007-11-02 08:00:00 | AAPL | Stock | 6.6943 | 6.7036 | 6.6932 | 6.7036 | 242032.0 |
| 2007-11-02 08:05:00 | AAPL | Stock | 6.7039 | 6.7136 | 6.7036 | 6.7071 | 262192.0 |
| 2007-11-02 08:10:00 | AAPL | Stock | 6.7118 | 6.7229 | 6.6964 | 6.7071 | 327348.0 |
| 2007-11-02 08:15:00 | AAPL | Stock | 6.7096 | 6.7143 | 6.6975 | 6.7064 | 122724.0 |
| 2007-11-02 08:20:00 | AAPL | Stock | 6.7054 | 6.7121 | 6.7054 | 6.71 | 258076.0 |
| 2007-11-02 08:25:00 | AAPL | Stock | 6.7107 | 6.7125 | 6.7071 | 6.7089 | 162764.0 |
| 2007-11-02 08:30:00 | AAPL | Stock | 6.7089 | 6.7857 | 6.7054 | 6.7679 | 4407424.0 |
| 2007-11-02 08:35:00 | AAPL | Stock | 6.7679 | 6.7679 | 6.7586 | 6.7636 | 688996.0 |
| 2007-11-02 08:40:00 | AAPL | Stock | 6.7621 | 6.7696 | 6.7536 | 6.7554 | 939960.0 |
| 2007-11-02 08:45:00 | AAPL | Stock | 6.7571 | 6.7593 | 6.7425 | 6.7525 | 517552.0 |
| 2007-11-02 08:50:00 | AAPL | Stock | 6.7536 | 6.7564 | 6.7518 | 6.7543 | 225652.0 |
| 2007-11-02 08:55:00 | AAPL | Stock | 6.7543 | 6.7589 | 6.7532 | 6.7536 | 662144.0 |
| 2007-11-02 09:00:00 | AAPL | Stock | 6.755 | 6.7586 | 6.7539 | 6.7579 | 432544.0 |
| 2007-11-02 09:05:00 | AAPL | Stock | 6.7571 | 6.7586 | 6.7529 | 6.7529 | 755496.0 |
| 2007-11-02 09:10:00 | AAPL | Stock | 6.7532 | 6.7536 | 6.7357 | 6.7396 | 690256.0 |
| 2007-11-02 09:15:00 | AAPL | Stock | 6.7379 | 6.7407 | 6.7354 | 6.7357 | 215040.0 |
| 2007-11-02 09:20:00 | AAPL | Stock | 6.7357 | 6.7439 | 6.7357 | 6.7439 | 153608.0 |
| 2007-11-02 09:25:00 | AAPL | Stock | 6.7429 | 6.7589 | 6.7429 | 6.7575 | 890596.0 |
| 2007-11-02 09:30:00 | AAPL | Stock | 6.7571 | 6.7643 | 6.7414 | 6.7446 | 25280892.0 |
| 2007-11-02 09:35:00 | AAPL | Stock | 6.7439 | 6.7536 | 6.7143 | 6.7379 | 29504076.0 |
| 2007-11-02 09:40:00 | AAPL | Stock | 6.7379 | 6.7657 | 6.735 | 6.7604 | 18096120.0 |
| 2007-11-02 09:45:00 | AAPL | Stock | 6.7604 | 6.7604 | 6.7186 | 6.7189 | 14925232.0 |
| 2007-11-02 09:50:00 | AAPL | Stock | 6.7186 | 6.7321 | 6.6657 | 6.6657 | 22589532.0 |
| 2007-11-02 09:55:00 | AAPL | Stock | 6.6661 | 6.6786 | 6.6089 | 6.6511 | 42388052.0 |
| 2007-11-02 10:00:00 | AAPL | Stock | 6.6496 | 6.6643 | 6.6143 | 6.64 | 21284228.0 |
| 2007-11-02 10:05:00 | AAPL | Stock | 6.6404 | 6.6582 | 6.6107 | 6.6507 | 20089272.0 |
| 2007-11-02 10:10:00 | AAPL | Stock | 6.6493 | 6.6693 | 6.6279 | 6.6546 | 17788036.0 |
| 2007-11-02 10:15:00 | AAPL | Stock | 6.6554 | 6.663 | 6.6239 | 6.6254 | 10153836.0 |
| 2007-11-02 10:20:00 | AAPL | Stock | 6.6254 | 6.6429 | 6.6139 | 6.6354 | 13532064.0 |
| 2007-11-02 10:25:00 | AAPL | Stock | 6.6357 | 6.6429 | 6.6261 | 6.6289 | 11279436.0 |
| 2007-11-02 10:30:00 | AAPL | Stock | 6.6289 | 6.6604 | 6.6246 | 6.6585 | 20851768.0 |
| 2007-11-02 10:35:00 | AAPL | Stock | 6.6589 | 6.6604 | 6.6346 | 6.6482 | 12098660.0 |
| 2007-11-02 10:40:00 | AAPL | Stock | 6.6471 | 6.6511 | 6.6268 | 6.6375 | 11807908.0 |
| 2007-11-02 10:45:00 | AAPL | Stock | 6.6391 | 6.6514 | 6.6264 | 6.6343 | 9538424.0 |
| 2007-11-02 10:50:00 | AAPL | Stock | 6.635 | 6.6489 | 6.6339 | 6.6339 | 10149384.0 |
| 2007-11-02 10:55:00 | AAPL | Stock | 6.6339 | 6.6507 | 6.6339 | 6.6404 | 12534032.0 |
| 2007-11-02 11:00:00 | AAPL | Stock | 6.64 | 6.6475 | 6.6332 | 6.6386 | 11866568.0 |
| 2007-11-02 11:05:00 | AAPL | Stock | 6.6386 | 6.6429 | 6.6179 | 6.6232 | 15103508.0 |
| 2007-11-02 11:10:00 | AAPL | Stock | 6.6232 | 6.6371 | 6.6204 | 6.6264 | 7700588.0 |
> showing 50 of 317,170 rows — these rows as CSV