PREVIEW / stock_5min / 2007-10-25
file: by_date/stock_5min/2007/2007-10-25.parquet size: 4.3 MB rows: 311,198 symbols: 3,167
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-25 04:05:00 | AAPL | Stock | 6.6429 | 6.6429 | 6.6429 | 6.6429 | 14000.0 |
| 2007-10-25 04:10:00 | AAPL | Stock | 6.6496 | 6.6496 | 6.6496 | 6.6496 | 11200.0 |
| 2007-10-25 04:15:00 | AAPL | Stock | 6.6393 | 6.6393 | 6.6393 | 6.6393 | 8400.0 |
| 2007-10-25 04:25:00 | AAPL | Stock | 6.6604 | 6.6607 | 6.6604 | 6.6607 | 8400.0 |
| 2007-10-25 04:35:00 | AAPL | Stock | 6.6518 | 6.6518 | 6.6518 | 6.6518 | 5600.0 |
| 2007-10-25 05:30:00 | AAPL | Stock | 6.66 | 6.6607 | 6.66 | 6.6607 | 22400.0 |
| 2007-10-25 05:35:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6607 | 6.6607 | 5600.0 |
| 2007-10-25 05:55:00 | AAPL | Stock | 6.6746 | 6.675 | 6.6746 | 6.675 | 61600.0 |
| 2007-10-25 06:00:00 | AAPL | Stock | 6.6786 | 6.6786 | 6.6786 | 6.6786 | 8400.0 |
| 2007-10-25 06:05:00 | AAPL | Stock | 6.6964 | 6.7143 | 6.6964 | 6.7143 | 47600.0 |
| 2007-10-25 06:25:00 | AAPL | Stock | 6.7204 | 6.7204 | 6.7204 | 6.7204 | 14000.0 |
| 2007-10-25 06:30:00 | AAPL | Stock | 6.7321 | 6.7321 | 6.7321 | 6.7321 | 19880.0 |
| 2007-10-25 06:35:00 | AAPL | Stock | 6.7179 | 6.7179 | 6.7179 | 6.7179 | 8400.0 |
| 2007-10-25 06:40:00 | AAPL | Stock | 6.7186 | 6.7225 | 6.715 | 6.7225 | 30800.0 |
| 2007-10-25 06:45:00 | AAPL | Stock | 6.7229 | 6.7229 | 6.7229 | 6.7229 | 18760.0 |
| 2007-10-25 06:50:00 | AAPL | Stock | 6.7229 | 6.7229 | 6.7229 | 6.7229 | 2800.0 |
| 2007-10-25 07:00:00 | AAPL | Stock | 6.7229 | 6.7371 | 6.7229 | 6.7321 | 35000.0 |
| 2007-10-25 07:05:00 | AAPL | Stock | 6.7286 | 6.7321 | 6.7182 | 6.7321 | 108220.0 |
| 2007-10-25 07:10:00 | AAPL | Stock | 6.7321 | 6.7375 | 6.7196 | 6.7321 | 204400.0 |
| 2007-10-25 07:15:00 | AAPL | Stock | 6.7375 | 6.7375 | 6.7286 | 6.7375 | 30800.0 |
| 2007-10-25 07:20:00 | AAPL | Stock | 6.7286 | 6.7414 | 6.7286 | 6.7411 | 162260.0 |
| 2007-10-25 07:25:00 | AAPL | Stock | 6.7321 | 6.75 | 6.7321 | 6.75 | 99400.0 |
| 2007-10-25 07:30:00 | AAPL | Stock | 6.75 | 6.7561 | 6.75 | 6.7561 | 335832.0 |
| 2007-10-25 07:35:00 | AAPL | Stock | 6.7654 | 6.7675 | 6.7554 | 6.7554 | 76384.0 |
| 2007-10-25 07:40:00 | AAPL | Stock | 6.7561 | 6.7571 | 6.7536 | 6.7571 | 82600.0 |
| 2007-10-25 07:45:00 | AAPL | Stock | 6.7571 | 6.7571 | 6.7439 | 6.75 | 974400.0 |
| 2007-10-25 07:50:00 | AAPL | Stock | 6.7582 | 6.7582 | 6.7468 | 6.7479 | 542752.0 |
| 2007-10-25 07:55:00 | AAPL | Stock | 6.7479 | 6.75 | 6.7479 | 6.75 | 538748.0 |
| 2007-10-25 08:00:00 | AAPL | Stock | 6.7432 | 6.7564 | 6.7096 | 6.7136 | 4547116.0 |
| 2007-10-25 08:05:00 | AAPL | Stock | 6.7136 | 6.7136 | 6.6793 | 6.6911 | 2510144.0 |
| 2007-10-25 08:10:00 | AAPL | Stock | 6.6911 | 6.6964 | 6.6743 | 6.6786 | 2025128.0 |
| 2007-10-25 08:15:00 | AAPL | Stock | 6.6786 | 6.6811 | 6.6732 | 6.675 | 1563548.0 |
| 2007-10-25 08:20:00 | AAPL | Stock | 6.6768 | 6.695 | 6.6768 | 6.6839 | 1852200.0 |
| 2007-10-25 08:25:00 | AAPL | Stock | 6.6818 | 6.6818 | 6.6693 | 6.6732 | 1287048.0 |
| 2007-10-25 08:30:00 | AAPL | Stock | 6.6714 | 6.6843 | 6.67 | 6.6793 | 910728.0 |
| 2007-10-25 08:35:00 | AAPL | Stock | 6.6789 | 6.6925 | 6.6754 | 6.6771 | 2926700.0 |
| 2007-10-25 08:40:00 | AAPL | Stock | 6.6771 | 6.6821 | 6.6764 | 6.6811 | 4009684.0 |
| 2007-10-25 08:45:00 | AAPL | Stock | 6.6811 | 6.6821 | 6.6736 | 6.6764 | 842576.0 |
| 2007-10-25 08:50:00 | AAPL | Stock | 6.6757 | 6.6804 | 6.6757 | 6.6786 | 596148.0 |
| 2007-10-25 08:55:00 | AAPL | Stock | 6.6786 | 6.6786 | 6.6729 | 6.6757 | 836080.0 |
| 2007-10-25 09:00:00 | AAPL | Stock | 6.6732 | 6.6746 | 6.6493 | 6.6496 | 2288944.0 |
| 2007-10-25 09:05:00 | AAPL | Stock | 6.6496 | 6.67 | 6.6236 | 6.6336 | 2201864.0 |
| 2007-10-25 09:10:00 | AAPL | Stock | 6.6321 | 6.6393 | 6.6068 | 6.6346 | 1527428.0 |
| 2007-10-25 09:15:00 | AAPL | Stock | 6.6361 | 6.6429 | 6.6254 | 6.6268 | 1199128.0 |
| 2007-10-25 09:20:00 | AAPL | Stock | 6.6261 | 6.6399 | 6.6 | 6.6125 | 2033612.0 |
| 2007-10-25 09:25:00 | AAPL | Stock | 6.6186 | 6.6221 | 6.5896 | 6.6046 | 3677940.0 |
| 2007-10-25 09:30:00 | AAPL | Stock | 6.6025 | 6.6214 | 6.5821 | 6.5825 | 47837832.0 |
| 2007-10-25 09:35:00 | AAPL | Stock | 6.5821 | 6.5896 | 6.5589 | 6.5668 | 27593300.0 |
| 2007-10-25 09:40:00 | AAPL | Stock | 6.5661 | 6.5993 | 6.5618 | 6.5943 | 22045828.0 |
| 2007-10-25 09:45:00 | AAPL | Stock | 6.5939 | 6.5979 | 6.5654 | 6.5757 | 15519196.0 |
> showing 50 of 311,198 rows — these rows as CSV