PREVIEW / stock_5min / 2007-10-15
file: by_date/stock_5min/2007/2007-10-15.parquet size: 4.3 MB rows: 309,932 symbols: 3,137
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-15 05:45:00 | AAPL | Stock | 6.0314 | 6.0314 | 6.0314 | 6.0314 | 24080.0 |
| 2007-10-15 05:50:00 | AAPL | Stock | 6.0429 | 6.0429 | 6.0429 | 6.0429 | 14420.0 |
| 2007-10-15 05:55:00 | AAPL | Stock | 6.0386 | 6.0386 | 6.0386 | 6.0386 | 11200.0 |
| 2007-10-15 06:40:00 | AAPL | Stock | 6.0443 | 6.0446 | 6.0443 | 6.0443 | 42000.0 |
| 2007-10-15 06:55:00 | AAPL | Stock | 6.0314 | 6.0339 | 6.0314 | 6.0339 | 28000.0 |
| 2007-10-15 07:00:00 | AAPL | Stock | 6.0339 | 6.0339 | 6.0229 | 6.0229 | 39564.0 |
| 2007-10-15 07:05:00 | AAPL | Stock | 6.0229 | 6.0229 | 6.0229 | 6.0229 | 5600.0 |
| 2007-10-15 07:10:00 | AAPL | Stock | 6.0168 | 6.0168 | 6.0168 | 6.0168 | 19600.0 |
| 2007-10-15 07:15:00 | AAPL | Stock | 6.025 | 6.025 | 6.025 | 6.025 | 2800.0 |
| 2007-10-15 07:20:00 | AAPL | Stock | 6.0214 | 6.0339 | 6.0214 | 6.0339 | 35280.0 |
| 2007-10-15 07:25:00 | AAPL | Stock | 6.0179 | 6.0179 | 6.0179 | 6.0179 | 2800.0 |
| 2007-10-15 07:30:00 | AAPL | Stock | 6.0179 | 6.0179 | 6.0179 | 6.0179 | 2800.0 |
| 2007-10-15 07:45:00 | AAPL | Stock | 6.0193 | 6.0193 | 6.0057 | 6.0057 | 25200.0 |
| 2007-10-15 07:50:00 | AAPL | Stock | 6.0057 | 6.0057 | 6.0018 | 6.0018 | 47600.0 |
| 2007-10-15 07:55:00 | AAPL | Stock | 6.0054 | 6.0054 | 5.9889 | 5.9896 | 106400.0 |
| 2007-10-15 08:00:00 | AAPL | Stock | 5.9896 | 6.0143 | 5.9896 | 6.0071 | 485548.0 |
| 2007-10-15 08:05:00 | AAPL | Stock | 6.0107 | 6.0125 | 6.0054 | 6.0071 | 230496.0 |
| 2007-10-15 08:10:00 | AAPL | Stock | 6.0107 | 6.0179 | 6.0107 | 6.0161 | 318696.0 |
| 2007-10-15 08:15:00 | AAPL | Stock | 6.0161 | 6.0164 | 6.0107 | 6.0143 | 400848.0 |
| 2007-10-15 08:20:00 | AAPL | Stock | 6.0157 | 6.0189 | 6.0125 | 6.0189 | 366464.0 |
| 2007-10-15 08:25:00 | AAPL | Stock | 6.0196 | 6.0286 | 6.0196 | 6.0232 | 538272.0 |
| 2007-10-15 08:30:00 | AAPL | Stock | 6.0246 | 6.025 | 6.0204 | 6.0225 | 301588.0 |
| 2007-10-15 08:35:00 | AAPL | Stock | 6.0236 | 6.0243 | 6.0196 | 6.0232 | 509936.0 |
| 2007-10-15 08:40:00 | AAPL | Stock | 6.0211 | 6.0236 | 6.0143 | 6.0143 | 421204.0 |
| 2007-10-15 08:45:00 | AAPL | Stock | 6.0143 | 6.0154 | 6.0079 | 6.015 | 539924.0 |
| 2007-10-15 08:50:00 | AAPL | Stock | 6.0139 | 6.0196 | 6.0139 | 6.0193 | 187040.0 |
| 2007-10-15 08:55:00 | AAPL | Stock | 6.0179 | 6.0214 | 5.9743 | 6.0143 | 2022328.0 |
| 2007-10-15 09:00:00 | AAPL | Stock | 6.0143 | 6.0157 | 6.0129 | 6.0129 | 362040.0 |
| 2007-10-15 09:05:00 | AAPL | Stock | 6.0129 | 6.0143 | 6.0075 | 6.01 | 501844.0 |
| 2007-10-15 09:10:00 | AAPL | Stock | 6.01 | 6.01 | 6.0014 | 6.0021 | 986132.0 |
| 2007-10-15 09:15:00 | AAPL | Stock | 6.0025 | 6.0125 | 6.0021 | 6.0089 | 862036.0 |
| 2007-10-15 09:20:00 | AAPL | Stock | 6.0089 | 6.0111 | 5.9975 | 5.9989 | 383880.0 |
| 2007-10-15 09:25:00 | AAPL | Stock | 5.9982 | 6.0068 | 5.9914 | 5.9936 | 749756.0 |
| 2007-10-15 09:30:00 | AAPL | Stock | 5.9975 | 6.0321 | 5.9739 | 6.0267 | 32554676.0 |
| 2007-10-15 09:35:00 | AAPL | Stock | 6.0261 | 6.0446 | 6.0225 | 6.03 | 20128304.0 |
| 2007-10-15 09:40:00 | AAPL | Stock | 6.0304 | 6.0561 | 6.0304 | 6.0357 | 20189736.0 |
| 2007-10-15 09:45:00 | AAPL | Stock | 6.0357 | 6.0371 | 5.9864 | 6.0136 | 25015592.0 |
| 2007-10-15 09:50:00 | AAPL | Stock | 6.0136 | 6.0175 | 6.0 | 6.0093 | 14040180.0 |
| 2007-10-15 09:55:00 | AAPL | Stock | 6.0107 | 6.0271 | 6.0036 | 6.01 | 14221396.0 |
| 2007-10-15 10:00:00 | AAPL | Stock | 6.0089 | 6.0246 | 6.0018 | 6.0193 | 11575060.0 |
| 2007-10-15 10:05:00 | AAPL | Stock | 6.0189 | 6.0461 | 6.0146 | 6.0457 | 17185196.0 |
| 2007-10-15 10:10:00 | AAPL | Stock | 6.0461 | 6.0482 | 6.0355 | 6.0429 | 12720484.0 |
| 2007-10-15 10:15:00 | AAPL | Stock | 6.0429 | 6.0454 | 6.0218 | 6.0282 | 12911612.0 |
| 2007-10-15 10:20:00 | AAPL | Stock | 6.0296 | 6.0407 | 6.0286 | 6.0293 | 12382776.0 |
| 2007-10-15 10:25:00 | AAPL | Stock | 6.0293 | 6.0321 | 6.015 | 6.0186 | 11258828.0 |
| 2007-10-15 10:30:00 | AAPL | Stock | 6.0179 | 6.0241 | 6.0107 | 6.0118 | 9558668.0 |
| 2007-10-15 10:35:00 | AAPL | Stock | 6.0118 | 6.0161 | 5.9946 | 6.0054 | 15684844.0 |
| 2007-10-15 10:40:00 | AAPL | Stock | 6.0054 | 6.0114 | 5.9954 | 5.9968 | 11117540.0 |
| 2007-10-15 10:45:00 | AAPL | Stock | 5.9979 | 6.0157 | 5.995 | 6.0087 | 9497768.0 |
| 2007-10-15 10:50:00 | AAPL | Stock | 6.0086 | 6.0139 | 5.9925 | 5.9936 | 6719328.0 |
> showing 50 of 309,932 rows — these rows as CSV