PREVIEW / stock_5min / 2005-10-03
file: by_date/stock_5min/2005/2005-10-03.parquet size: 2.8 MB rows: 207,532 symbols: 2,094
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-03 07:20:00 | AAPL | Stock | 1.9089 | 1.9089 | 1.9089 | 1.9089 | 5600.0 |
| 2005-10-03 07:30:00 | AAPL | Stock | 1.9161 | 1.9161 | 1.9161 | 1.9161 | 8400.0 |
| 2005-10-03 07:40:00 | AAPL | Stock | 1.9171 | 1.9171 | 1.9171 | 1.9171 | 14000.0 |
| 2005-10-03 07:45:00 | AAPL | Stock | 1.9214 | 1.9214 | 1.9214 | 1.9214 | 28000.0 |
| 2005-10-03 08:00:00 | AAPL | Stock | 1.9268 | 1.9321 | 1.9146 | 1.9286 | 741692.0 |
| 2005-10-03 08:05:00 | AAPL | Stock | 1.9286 | 1.9321 | 1.9229 | 1.9286 | 123900.0 |
| 2005-10-03 08:10:00 | AAPL | Stock | 1.9286 | 1.9339 | 1.9286 | 1.9339 | 217700.0 |
| 2005-10-03 08:15:00 | AAPL | Stock | 1.9339 | 1.9339 | 1.9304 | 1.9304 | 70000.0 |
| 2005-10-03 08:20:00 | AAPL | Stock | 1.9321 | 1.9321 | 1.9296 | 1.9321 | 124880.0 |
| 2005-10-03 08:25:00 | AAPL | Stock | 1.9321 | 1.9321 | 1.9286 | 1.9286 | 114240.0 |
| 2005-10-03 08:30:00 | AAPL | Stock | 1.9261 | 1.9286 | 1.9261 | 1.9286 | 87500.0 |
| 2005-10-03 08:35:00 | AAPL | Stock | 1.9146 | 1.9232 | 1.9146 | 1.9218 | 171052.0 |
| 2005-10-03 08:40:00 | AAPL | Stock | 1.9271 | 1.9286 | 1.9268 | 1.9268 | 80640.0 |
| 2005-10-03 08:45:00 | AAPL | Stock | 1.9286 | 1.9321 | 1.9275 | 1.9279 | 90440.0 |
| 2005-10-03 08:50:00 | AAPL | Stock | 1.93 | 1.93 | 1.9268 | 1.9286 | 71680.0 |
| 2005-10-03 08:55:00 | AAPL | Stock | 1.9268 | 1.9296 | 1.9268 | 1.9286 | 25200.0 |
| 2005-10-03 09:00:00 | AAPL | Stock | 1.9304 | 1.9321 | 1.9289 | 1.9293 | 129808.0 |
| 2005-10-03 09:05:00 | AAPL | Stock | 1.9296 | 1.9296 | 1.9286 | 1.9293 | 76608.0 |
| 2005-10-03 09:10:00 | AAPL | Stock | 1.9293 | 1.9321 | 1.9293 | 1.9321 | 282240.0 |
| 2005-10-03 09:15:00 | AAPL | Stock | 1.9321 | 1.9321 | 1.9293 | 1.9293 | 142520.0 |
| 2005-10-03 09:20:00 | AAPL | Stock | 1.93 | 1.9368 | 1.93 | 1.9368 | 519400.0 |
| 2005-10-03 09:25:00 | AAPL | Stock | 1.9314 | 1.9361 | 1.9261 | 1.9339 | 1130920.0 |
| 2005-10-03 09:30:00 | AAPL | Stock | 1.9343 | 1.94 | 1.9279 | 1.9375 | 27194216.0 |
| 2005-10-03 09:35:00 | AAPL | Stock | 1.9375 | 1.9389 | 1.9289 | 1.9357 | 18950568.0 |
| 2005-10-03 09:40:00 | AAPL | Stock | 1.9357 | 1.9361 | 1.9311 | 1.9357 | 12437292.0 |
| 2005-10-03 09:45:00 | AAPL | Stock | 1.9361 | 1.9393 | 1.9329 | 1.9386 | 15367716.0 |
| 2005-10-03 09:50:00 | AAPL | Stock | 1.9382 | 1.9389 | 1.9311 | 1.9325 | 9424380.0 |
| 2005-10-03 09:55:00 | AAPL | Stock | 1.9321 | 1.935 | 1.9282 | 1.9336 | 8232756.0 |
| 2005-10-03 10:00:00 | AAPL | Stock | 1.9339 | 1.9368 | 1.9311 | 1.9311 | 8996960.0 |
| 2005-10-03 10:05:00 | AAPL | Stock | 1.9311 | 1.9314 | 1.92 | 1.9286 | 16797424.0 |
| 2005-10-03 10:10:00 | AAPL | Stock | 1.9289 | 1.9314 | 1.925 | 1.9293 | 7083944.0 |
| 2005-10-03 10:15:00 | AAPL | Stock | 1.9293 | 1.93 | 1.9221 | 1.9246 | 6564684.0 |
| 2005-10-03 10:20:00 | AAPL | Stock | 1.9246 | 1.93 | 1.9246 | 1.9279 | 7061348.0 |
| 2005-10-03 10:25:00 | AAPL | Stock | 1.9279 | 1.9304 | 1.925 | 1.9282 | 6154484.0 |
| 2005-10-03 10:30:00 | AAPL | Stock | 1.9282 | 1.9289 | 1.9243 | 1.9243 | 10629864.0 |
| 2005-10-03 10:35:00 | AAPL | Stock | 1.9243 | 1.925 | 1.9232 | 1.925 | 6167168.0 |
| 2005-10-03 10:40:00 | AAPL | Stock | 1.9246 | 1.9264 | 1.9196 | 1.9207 | 7571536.0 |
| 2005-10-03 10:45:00 | AAPL | Stock | 1.9207 | 1.9264 | 1.9171 | 1.925 | 8274504.0 |
| 2005-10-03 10:50:00 | AAPL | Stock | 1.925 | 1.93 | 1.9236 | 1.9282 | 7761880.0 |
| 2005-10-03 10:55:00 | AAPL | Stock | 1.9282 | 1.9318 | 1.9257 | 1.9279 | 7397768.0 |
| 2005-10-03 11:00:00 | AAPL | Stock | 1.9279 | 1.9286 | 1.9257 | 1.9279 | 3537856.0 |
| 2005-10-03 11:05:00 | AAPL | Stock | 1.9279 | 1.9293 | 1.9265 | 1.9282 | 6088292.0 |
| 2005-10-03 11:10:00 | AAPL | Stock | 1.9286 | 1.9304 | 1.9271 | 1.9304 | 6649048.0 |
| 2005-10-03 11:15:00 | AAPL | Stock | 1.9304 | 1.9343 | 1.9257 | 1.9321 | 11151784.0 |
| 2005-10-03 11:20:00 | AAPL | Stock | 1.9318 | 1.9332 | 1.9304 | 1.9307 | 4997748.0 |
| 2005-10-03 11:25:00 | AAPL | Stock | 1.9307 | 1.9336 | 1.93 | 1.9328 | 4827004.0 |
| 2005-10-03 11:30:00 | AAPL | Stock | 1.9325 | 1.9339 | 1.9296 | 1.9336 | 4614540.0 |
| 2005-10-03 11:35:00 | AAPL | Stock | 1.9336 | 1.9343 | 1.9314 | 1.9336 | 3960124.0 |
| 2005-10-03 11:40:00 | AAPL | Stock | 1.9336 | 1.9336 | 1.9304 | 1.9304 | 3325980.0 |
| 2005-10-03 11:45:00 | AAPL | Stock | 1.9311 | 1.9318 | 1.9296 | 1.9304 | 2759652.0 |
> showing 50 of 207,532 rows — these rows as CSV