PREVIEW / stock_5min / 2005-09-27
file: by_date/stock_5min/2005/2005-09-27.parquet size: 2.8 MB rows: 204,546 symbols: 2,084
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-09-27 08:00:00 | AAPL | Stock | 1.9257 | 1.9257 | 1.9257 | 1.9257 | 28000.0 |
| 2005-09-27 08:10:00 | AAPL | Stock | 1.9257 | 1.9321 | 1.9254 | 1.9286 | 124488.0 |
| 2005-09-27 08:15:00 | AAPL | Stock | 1.9321 | 1.9329 | 1.9286 | 1.9321 | 127820.0 |
| 2005-09-27 08:20:00 | AAPL | Stock | 1.9321 | 1.9332 | 1.9321 | 1.9321 | 47600.0 |
| 2005-09-27 08:25:00 | AAPL | Stock | 1.9321 | 1.9339 | 1.9314 | 1.9339 | 140000.0 |
| 2005-09-27 08:35:00 | AAPL | Stock | 1.9296 | 1.9304 | 1.9296 | 1.9304 | 8400.0 |
| 2005-09-27 08:40:00 | AAPL | Stock | 1.9296 | 1.9304 | 1.9296 | 1.9304 | 18200.0 |
| 2005-09-27 08:45:00 | AAPL | Stock | 1.9304 | 1.9304 | 1.9268 | 1.9286 | 137200.0 |
| 2005-09-27 08:50:00 | AAPL | Stock | 1.9289 | 1.9289 | 1.9289 | 1.9289 | 2800.0 |
| 2005-09-27 08:55:00 | AAPL | Stock | 1.9286 | 1.9289 | 1.9286 | 1.9289 | 61600.0 |
| 2005-09-27 09:00:00 | AAPL | Stock | 1.9289 | 1.9289 | 1.9289 | 1.9289 | 140000.0 |
| 2005-09-27 09:05:00 | AAPL | Stock | 1.9289 | 1.9289 | 1.9268 | 1.9268 | 180880.0 |
| 2005-09-27 09:10:00 | AAPL | Stock | 1.9268 | 1.9286 | 1.9268 | 1.9286 | 12600.0 |
| 2005-09-27 09:20:00 | AAPL | Stock | 1.9282 | 1.9282 | 1.9282 | 1.9282 | 5600.0 |
| 2005-09-27 09:25:00 | AAPL | Stock | 1.9264 | 1.9304 | 1.9257 | 1.9257 | 773024.0 |
| 2005-09-27 09:30:00 | AAPL | Stock | 1.9257 | 1.9371 | 1.9257 | 1.9346 | 11774252.0 |
| 2005-09-27 09:35:00 | AAPL | Stock | 1.9339 | 1.9354 | 1.9254 | 1.9271 | 12477052.0 |
| 2005-09-27 09:40:00 | AAPL | Stock | 1.9268 | 1.9282 | 1.9214 | 1.9225 | 12074216.0 |
| 2005-09-27 09:45:00 | AAPL | Stock | 1.9225 | 1.9307 | 1.9193 | 1.9286 | 9088632.0 |
| 2005-09-27 09:50:00 | AAPL | Stock | 1.9286 | 1.9371 | 1.9286 | 1.935 | 8546832.0 |
| 2005-09-27 09:55:00 | AAPL | Stock | 1.935 | 1.935 | 1.9271 | 1.9293 | 6433952.0 |
| 2005-09-27 10:00:00 | AAPL | Stock | 1.9282 | 1.9282 | 1.9221 | 1.9221 | 8046416.0 |
| 2005-09-27 10:05:00 | AAPL | Stock | 1.9221 | 1.925 | 1.9179 | 1.9225 | 9124416.0 |
| 2005-09-27 10:10:00 | AAPL | Stock | 1.9229 | 1.9304 | 1.9225 | 1.9257 | 8060192.0 |
| 2005-09-27 10:15:00 | AAPL | Stock | 1.9254 | 1.93 | 1.9236 | 1.9243 | 4732224.0 |
| 2005-09-27 10:20:00 | AAPL | Stock | 1.9246 | 1.9271 | 1.9196 | 1.9221 | 4828320.0 |
| 2005-09-27 10:25:00 | AAPL | Stock | 1.9218 | 1.9261 | 1.9204 | 1.9232 | 3167808.0 |
| 2005-09-27 10:30:00 | AAPL | Stock | 1.9229 | 1.9268 | 1.9221 | 1.925 | 4311664.0 |
| 2005-09-27 10:35:00 | AAPL | Stock | 1.925 | 1.9264 | 1.9218 | 1.9218 | 3385704.0 |
| 2005-09-27 10:40:00 | AAPL | Stock | 1.9218 | 1.9239 | 1.9204 | 1.9214 | 4543168.0 |
| 2005-09-27 10:45:00 | AAPL | Stock | 1.9221 | 1.9225 | 1.9154 | 1.9179 | 4858812.0 |
| 2005-09-27 10:50:00 | AAPL | Stock | 1.9179 | 1.9193 | 1.9168 | 1.9182 | 3117072.0 |
| 2005-09-27 10:55:00 | AAPL | Stock | 1.9186 | 1.9214 | 1.9179 | 1.9204 | 3573920.0 |
| 2005-09-27 11:00:00 | AAPL | Stock | 1.9207 | 1.9236 | 1.9179 | 1.9229 | 3563644.0 |
| 2005-09-27 11:05:00 | AAPL | Stock | 1.9229 | 1.9261 | 1.9229 | 1.9243 | 4238892.0 |
| 2005-09-27 11:10:00 | AAPL | Stock | 1.9244 | 1.9264 | 1.9214 | 1.9229 | 2963324.0 |
| 2005-09-27 11:15:00 | AAPL | Stock | 1.9236 | 1.9243 | 1.9214 | 1.9239 | 2109828.0 |
| 2005-09-27 11:20:00 | AAPL | Stock | 1.9239 | 1.9254 | 1.9229 | 1.9243 | 2400356.0 |
| 2005-09-27 11:25:00 | AAPL | Stock | 1.9254 | 1.9254 | 1.9225 | 1.9235 | 2386160.0 |
| 2005-09-27 11:30:00 | AAPL | Stock | 1.9232 | 1.9232 | 1.9196 | 1.9207 | 2481892.0 |
| 2005-09-27 11:35:00 | AAPL | Stock | 1.9207 | 1.9224 | 1.9189 | 1.9193 | 1974140.0 |
| 2005-09-27 11:40:00 | AAPL | Stock | 1.9196 | 1.9257 | 1.9196 | 1.9236 | 2678564.0 |
| 2005-09-27 11:45:00 | AAPL | Stock | 1.9236 | 1.9275 | 1.9221 | 1.925 | 3186288.0 |
| 2005-09-27 11:50:00 | AAPL | Stock | 1.9257 | 1.9261 | 1.9236 | 1.9236 | 2298464.0 |
| 2005-09-27 11:55:00 | AAPL | Stock | 1.9236 | 1.9254 | 1.9232 | 1.9246 | 1682212.0 |
| 2005-09-27 12:00:00 | AAPL | Stock | 1.9246 | 1.9279 | 1.9214 | 1.9271 | 3606428.0 |
| 2005-09-27 12:05:00 | AAPL | Stock | 1.9271 | 1.9286 | 1.9239 | 1.9239 | 2778468.0 |
| 2005-09-27 12:10:00 | AAPL | Stock | 1.9239 | 1.9261 | 1.9239 | 1.925 | 1087352.0 |
| 2005-09-27 12:15:00 | AAPL | Stock | 1.9254 | 1.9268 | 1.9243 | 1.9254 | 1658608.0 |
| 2005-09-27 12:20:00 | AAPL | Stock | 1.9254 | 1.9268 | 1.925 | 1.9268 | 1425788.0 |
> showing 50 of 204,546 rows — these rows as CSV