PREVIEW / stock_5min / 2006-06-29
file: by_date/stock_5min/2006/2006-06-29.parquet size: 3.2 MB rows: 232,970 symbols: 2,285
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 |
|---|---|---|---|---|---|---|---|
| 2006-06-29 08:00:00 | AAPL | Stock | 2.0082 | 2.0089 | 2.0082 | 2.0089 | 46004.0 |
| 2006-06-29 08:05:00 | AAPL | Stock | 2.0086 | 2.0086 | 2.0054 | 2.0054 | 72800.0 |
| 2006-06-29 08:10:00 | AAPL | Stock | 2.0057 | 2.0057 | 2.0054 | 2.0054 | 50400.0 |
| 2006-06-29 08:15:00 | AAPL | Stock | 2.0057 | 2.0071 | 2.005 | 2.0071 | 120400.0 |
| 2006-06-29 08:20:00 | AAPL | Stock | 2.0082 | 2.0082 | 2.0082 | 2.0082 | 14000.0 |
| 2006-06-29 08:25:00 | AAPL | Stock | 2.0082 | 2.0082 | 2.0079 | 2.0082 | 54600.0 |
| 2006-06-29 08:30:00 | AAPL | Stock | 2.0086 | 2.0086 | 2.0082 | 2.0082 | 44660.0 |
| 2006-06-29 08:35:00 | AAPL | Stock | 2.0082 | 2.0089 | 2.0082 | 2.0089 | 64904.0 |
| 2006-06-29 08:40:00 | AAPL | Stock | 2.01 | 2.0107 | 2.0082 | 2.01 | 72800.0 |
| 2006-06-29 08:45:00 | AAPL | Stock | 2.0093 | 2.0093 | 2.0075 | 2.0075 | 120400.0 |
| 2006-06-29 08:50:00 | AAPL | Stock | 2.0075 | 2.01 | 2.0036 | 2.0071 | 108920.0 |
| 2006-06-29 08:55:00 | AAPL | Stock | 2.0086 | 2.0129 | 2.0079 | 2.0129 | 276416.0 |
| 2006-06-29 09:00:00 | AAPL | Stock | 2.0129 | 2.0364 | 2.0111 | 2.0357 | 2163392.0 |
| 2006-06-29 09:05:00 | AAPL | Stock | 2.0357 | 2.0371 | 2.0293 | 2.0321 | 781172.0 |
| 2006-06-29 09:10:00 | AAPL | Stock | 2.0321 | 2.0357 | 2.0318 | 2.0321 | 619360.0 |
| 2006-06-29 09:15:00 | AAPL | Stock | 2.0321 | 2.0336 | 2.0304 | 2.0304 | 204820.0 |
| 2006-06-29 09:20:00 | AAPL | Stock | 2.0321 | 2.0339 | 2.0286 | 2.0286 | 907620.0 |
| 2006-06-29 09:25:00 | AAPL | Stock | 2.0268 | 2.0318 | 2.0225 | 2.0296 | 1079820.0 |
| 2006-06-29 09:30:00 | AAPL | Stock | 2.0271 | 2.03 | 2.0143 | 2.0168 | 23375940.0 |
| 2006-06-29 09:35:00 | AAPL | Stock | 2.0168 | 2.0243 | 2.0139 | 2.0236 | 13634852.0 |
| 2006-06-29 09:40:00 | AAPL | Stock | 2.0236 | 2.025 | 2.0168 | 2.0232 | 11061568.0 |
| 2006-06-29 09:45:00 | AAPL | Stock | 2.0232 | 2.025 | 2.0171 | 2.0207 | 9763208.0 |
| 2006-06-29 09:50:00 | AAPL | Stock | 2.0204 | 2.0211 | 2.0171 | 2.0196 | 6810496.0 |
| 2006-06-29 09:55:00 | AAPL | Stock | 2.02 | 2.0214 | 2.0161 | 2.02 | 9772056.0 |
| 2006-06-29 10:00:00 | AAPL | Stock | 2.0204 | 2.0236 | 2.0189 | 2.0221 | 7836836.0 |
| 2006-06-29 10:05:00 | AAPL | Stock | 2.0221 | 2.03 | 2.0221 | 2.0229 | 13342756.0 |
| 2006-06-29 10:10:00 | AAPL | Stock | 2.0229 | 2.0264 | 2.0204 | 2.0211 | 7346500.0 |
| 2006-06-29 10:15:00 | AAPL | Stock | 2.0204 | 2.0229 | 2.0186 | 2.0189 | 6435156.0 |
| 2006-06-29 10:20:00 | AAPL | Stock | 2.0189 | 2.0246 | 2.0186 | 2.0243 | 5246108.0 |
| 2006-06-29 10:25:00 | AAPL | Stock | 2.0243 | 2.0246 | 2.0211 | 2.0232 | 3754016.0 |
| 2006-06-29 10:30:00 | AAPL | Stock | 2.0236 | 2.0296 | 2.0236 | 2.0246 | 9926168.0 |
| 2006-06-29 10:35:00 | AAPL | Stock | 2.0246 | 2.0275 | 2.0229 | 2.0268 | 5458684.0 |
| 2006-06-29 10:40:00 | AAPL | Stock | 2.0264 | 2.0271 | 2.0225 | 2.0236 | 4546052.0 |
| 2006-06-29 10:45:00 | AAPL | Stock | 2.0232 | 2.0321 | 2.0232 | 2.0307 | 8779960.0 |
| 2006-06-29 10:50:00 | AAPL | Stock | 2.0304 | 2.0343 | 2.0296 | 2.0318 | 6968780.0 |
| 2006-06-29 10:55:00 | AAPL | Stock | 2.0318 | 2.0318 | 2.0279 | 2.03 | 7334516.0 |
| 2006-06-29 11:00:00 | AAPL | Stock | 2.03 | 2.0346 | 2.0296 | 2.0325 | 5688004.0 |
| 2006-06-29 11:05:00 | AAPL | Stock | 2.0329 | 2.0357 | 2.0308 | 2.0336 | 6783924.0 |
| 2006-06-29 11:10:00 | AAPL | Stock | 2.0336 | 2.0361 | 2.0321 | 2.0332 | 11340644.0 |
| 2006-06-29 11:15:00 | AAPL | Stock | 2.0329 | 2.0375 | 2.0329 | 2.0346 | 9509780.0 |
| 2006-06-29 11:20:00 | AAPL | Stock | 2.0346 | 2.0379 | 2.0339 | 2.0375 | 6912360.0 |
| 2006-06-29 11:25:00 | AAPL | Stock | 2.0375 | 2.0375 | 2.0329 | 2.0371 | 7099680.0 |
| 2006-06-29 11:30:00 | AAPL | Stock | 2.0368 | 2.0414 | 2.0368 | 2.0407 | 11343024.0 |
| 2006-06-29 11:35:00 | AAPL | Stock | 2.04 | 2.04 | 2.0354 | 2.0368 | 6646192.0 |
| 2006-06-29 11:40:00 | AAPL | Stock | 2.0368 | 2.0379 | 2.035 | 2.0357 | 5083960.0 |
| 2006-06-29 11:45:00 | AAPL | Stock | 2.036 | 2.04 | 2.0357 | 2.04 | 4223016.0 |
| 2006-06-29 11:50:00 | AAPL | Stock | 2.04 | 2.0432 | 2.0371 | 2.0371 | 7273728.0 |
| 2006-06-29 11:55:00 | AAPL | Stock | 2.0371 | 2.0404 | 2.0361 | 2.0386 | 3506272.0 |
| 2006-06-29 12:00:00 | AAPL | Stock | 2.0386 | 2.0389 | 2.0311 | 2.0321 | 6079780.0 |
| 2006-06-29 12:05:00 | AAPL | Stock | 2.0321 | 2.0354 | 2.0304 | 2.0325 | 4953172.0 |
> showing 50 of 232,970 rows — these rows as CSV