PREVIEW / stock_5min / 2007-10-08
file: by_date/stock_5min/2007/2007-10-08.parquet size: 4.0 MB rows: 296,530 symbols: 3,102
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-10-08 05:40:00 | AAPL | Stock | 5.8014 | 5.8014 | 5.8014 | 5.8014 | 11200.0 |
| 2007-10-08 05:45:00 | AAPL | Stock | 5.7875 | 5.7875 | 5.7875 | 5.7875 | 70000.0 |
| 2007-10-08 07:00:00 | AAPL | Stock | 5.7796 | 5.7946 | 5.7782 | 5.7946 | 61600.0 |
| 2007-10-08 07:05:00 | AAPL | Stock | 5.7986 | 5.7986 | 5.7936 | 5.7986 | 28000.0 |
| 2007-10-08 07:10:00 | AAPL | Stock | 5.7929 | 5.7929 | 5.7929 | 5.7929 | 2800.0 |
| 2007-10-08 07:15:00 | AAPL | Stock | 5.8214 | 5.8214 | 5.7986 | 5.8207 | 39200.0 |
| 2007-10-08 07:20:00 | AAPL | Stock | 5.7982 | 5.7982 | 5.7982 | 5.7982 | 11200.0 |
| 2007-10-08 07:30:00 | AAPL | Stock | 5.7982 | 5.7982 | 5.7982 | 5.7982 | 2800.0 |
| 2007-10-08 07:40:00 | AAPL | Stock | 5.8079 | 5.8079 | 5.8057 | 5.8061 | 42000.0 |
| 2007-10-08 07:45:00 | AAPL | Stock | 5.8061 | 5.8114 | 5.8036 | 5.8036 | 44800.0 |
| 2007-10-08 07:50:00 | AAPL | Stock | 5.8036 | 5.8036 | 5.8036 | 5.8036 | 25200.0 |
| 2007-10-08 07:55:00 | AAPL | Stock | 5.8036 | 5.8071 | 5.8036 | 5.8036 | 16800.0 |
| 2007-10-08 08:00:00 | AAPL | Stock | 5.8 | 5.8418 | 5.7982 | 5.8418 | 1745996.0 |
| 2007-10-08 08:05:00 | AAPL | Stock | 5.8446 | 5.8454 | 5.8286 | 5.8336 | 709436.0 |
| 2007-10-08 08:10:00 | AAPL | Stock | 5.8339 | 5.8518 | 5.8304 | 5.8482 | 613172.0 |
| 2007-10-08 08:15:00 | AAPL | Stock | 5.8482 | 5.8486 | 5.8446 | 5.8464 | 414456.0 |
| 2007-10-08 08:20:00 | AAPL | Stock | 5.8432 | 5.8479 | 5.8396 | 5.8446 | 385420.0 |
| 2007-10-08 08:25:00 | AAPL | Stock | 5.845 | 5.8493 | 5.8425 | 5.8446 | 443884.0 |
| 2007-10-08 08:30:00 | AAPL | Stock | 5.8446 | 5.8464 | 5.8429 | 5.8432 | 381080.0 |
| 2007-10-08 08:35:00 | AAPL | Stock | 5.8436 | 5.8446 | 5.8357 | 5.8364 | 506212.0 |
| 2007-10-08 08:40:00 | AAPL | Stock | 5.8375 | 5.8429 | 5.8357 | 5.8411 | 296548.0 |
| 2007-10-08 08:45:00 | AAPL | Stock | 5.8411 | 5.8439 | 5.7661 | 5.8439 | 239932.0 |
| 2007-10-08 08:50:00 | AAPL | Stock | 5.8457 | 5.8468 | 5.8421 | 5.8421 | 564956.0 |
| 2007-10-08 08:55:00 | AAPL | Stock | 5.8414 | 5.8421 | 5.8304 | 5.8325 | 699020.0 |
| 2007-10-08 09:00:00 | AAPL | Stock | 5.8314 | 5.8321 | 5.8221 | 5.8286 | 452592.0 |
| 2007-10-08 09:05:00 | AAPL | Stock | 5.8286 | 5.8311 | 5.8268 | 5.8275 | 134680.0 |
| 2007-10-08 09:10:00 | AAPL | Stock | 5.8275 | 5.8286 | 5.8204 | 5.8214 | 572712.0 |
| 2007-10-08 09:15:00 | AAPL | Stock | 5.8189 | 5.8211 | 5.8161 | 5.8161 | 257572.0 |
| 2007-10-08 09:20:00 | AAPL | Stock | 5.8161 | 5.8196 | 5.8146 | 5.8154 | 276500.0 |
| 2007-10-08 09:25:00 | AAPL | Stock | 5.8154 | 5.8393 | 5.8143 | 5.8389 | 3937416.0 |
| 2007-10-08 09:30:00 | AAPL | Stock | 5.84 | 5.8504 | 5.8204 | 5.8339 | 37162692.0 |
| 2007-10-08 09:35:00 | AAPL | Stock | 5.835 | 5.8725 | 5.8307 | 5.8393 | 43080604.0 |
| 2007-10-08 09:40:00 | AAPL | Stock | 5.8393 | 5.8729 | 5.8336 | 5.8714 | 17514308.0 |
| 2007-10-08 09:45:00 | AAPL | Stock | 5.8711 | 5.8929 | 5.8686 | 5.8793 | 34884192.0 |
| 2007-10-08 09:50:00 | AAPL | Stock | 5.8793 | 5.8846 | 5.8514 | 5.8604 | 28114604.0 |
| 2007-10-08 09:55:00 | AAPL | Stock | 5.8604 | 5.875 | 5.8596 | 5.868 | 15195348.0 |
| 2007-10-08 10:00:00 | AAPL | Stock | 5.8704 | 5.8786 | 5.8671 | 5.8771 | 11427640.0 |
| 2007-10-08 10:05:00 | AAPL | Stock | 5.8771 | 5.8857 | 5.875 | 5.875 | 15406748.0 |
| 2007-10-08 10:10:00 | AAPL | Stock | 5.875 | 5.8757 | 5.8618 | 5.8639 | 11822972.0 |
| 2007-10-08 10:15:00 | AAPL | Stock | 5.8643 | 5.8718 | 5.8604 | 5.865 | 10034836.0 |
| 2007-10-08 10:20:00 | AAPL | Stock | 5.865 | 5.8818 | 5.8625 | 5.8775 | 11132016.0 |
| 2007-10-08 10:25:00 | AAPL | Stock | 5.8775 | 5.8807 | 5.8643 | 5.8657 | 9599072.0 |
| 2007-10-08 10:30:00 | AAPL | Stock | 5.8657 | 5.8839 | 5.8632 | 5.8779 | 9535120.0 |
| 2007-10-08 10:35:00 | AAPL | Stock | 5.8779 | 5.8793 | 5.8675 | 5.8686 | 8229620.0 |
| 2007-10-08 10:40:00 | AAPL | Stock | 5.8682 | 5.87 | 5.8654 | 5.8682 | 6707820.0 |
| 2007-10-08 10:45:00 | AAPL | Stock | 5.8679 | 5.8771 | 5.8643 | 5.8739 | 6804448.0 |
| 2007-10-08 10:50:00 | AAPL | Stock | 5.8739 | 5.8743 | 5.865 | 5.8654 | 7175672.0 |
| 2007-10-08 10:55:00 | AAPL | Stock | 5.8654 | 5.8693 | 5.8536 | 5.8549 | 12576088.0 |
| 2007-10-08 11:00:00 | AAPL | Stock | 5.8557 | 5.865 | 5.8518 | 5.8611 | 10497704.0 |
| 2007-10-08 11:05:00 | AAPL | Stock | 5.8614 | 5.8632 | 5.85 | 5.8554 | 9319716.0 |
> showing 50 of 296,530 rows — these rows as CSV