PREVIEW / stock_5min / 2005-10-05
file: by_date/stock_5min/2005/2005-10-05.parquet size: 2.9 MB rows: 210,355 symbols: 2,083
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-05 08:00:00 | AAPL | Stock | 1.9411 | 1.9696 | 1.9357 | 1.9368 | 403396.0 |
| 2005-10-05 08:05:00 | AAPL | Stock | 1.9368 | 1.9379 | 1.9339 | 1.935 | 89600.0 |
| 2005-10-05 08:10:00 | AAPL | Stock | 1.9393 | 1.9393 | 1.9375 | 1.9375 | 61600.0 |
| 2005-10-05 08:15:00 | AAPL | Stock | 1.9375 | 1.9525 | 1.9375 | 1.9457 | 442960.0 |
| 2005-10-05 08:20:00 | AAPL | Stock | 1.9496 | 1.95 | 1.9446 | 1.9446 | 403340.0 |
| 2005-10-05 08:25:00 | AAPL | Stock | 1.9457 | 1.9479 | 1.9443 | 1.9443 | 378196.0 |
| 2005-10-05 08:30:00 | AAPL | Stock | 1.9464 | 1.9475 | 1.9446 | 1.9475 | 360080.0 |
| 2005-10-05 08:35:00 | AAPL | Stock | 1.9464 | 1.9482 | 1.9464 | 1.9464 | 621376.0 |
| 2005-10-05 08:40:00 | AAPL | Stock | 1.9464 | 1.9464 | 1.9429 | 1.9429 | 268800.0 |
| 2005-10-05 08:45:00 | AAPL | Stock | 1.9429 | 1.9461 | 1.9429 | 1.9429 | 98840.0 |
| 2005-10-05 08:50:00 | AAPL | Stock | 1.9429 | 1.9429 | 1.9429 | 1.9429 | 78960.0 |
| 2005-10-05 08:55:00 | AAPL | Stock | 1.9429 | 1.9429 | 1.9411 | 1.9429 | 78400.0 |
| 2005-10-05 09:00:00 | AAPL | Stock | 1.9429 | 1.9429 | 1.9429 | 1.9429 | 65800.0 |
| 2005-10-05 09:05:00 | AAPL | Stock | 1.9429 | 1.9446 | 1.9414 | 1.9446 | 131600.0 |
| 2005-10-05 09:10:00 | AAPL | Stock | 1.9439 | 1.9443 | 1.9421 | 1.9429 | 238000.0 |
| 2005-10-05 09:15:00 | AAPL | Stock | 1.9429 | 1.9429 | 1.9411 | 1.9414 | 89600.0 |
| 2005-10-05 09:20:00 | AAPL | Stock | 1.9393 | 1.9393 | 1.9325 | 1.9357 | 738920.0 |
| 2005-10-05 09:25:00 | AAPL | Stock | 1.9304 | 1.9404 | 1.9289 | 1.9404 | 685580.0 |
| 2005-10-05 09:30:00 | AAPL | Stock | 1.9404 | 1.9414 | 1.9264 | 1.9279 | 14795984.0 |
| 2005-10-05 09:35:00 | AAPL | Stock | 1.9279 | 1.9346 | 1.9279 | 1.9318 | 11508084.0 |
| 2005-10-05 09:40:00 | AAPL | Stock | 1.932 | 1.9361 | 1.9243 | 1.9286 | 13546232.0 |
| 2005-10-05 09:45:00 | AAPL | Stock | 1.9261 | 1.9275 | 1.9204 | 1.9246 | 9702028.0 |
| 2005-10-05 09:50:00 | AAPL | Stock | 1.9243 | 1.9318 | 1.9229 | 1.9311 | 8925112.0 |
| 2005-10-05 09:55:00 | AAPL | Stock | 1.9314 | 1.9314 | 1.9236 | 1.9275 | 6353676.0 |
| 2005-10-05 10:00:00 | AAPL | Stock | 1.9275 | 1.9286 | 1.9229 | 1.9261 | 8119888.0 |
| 2005-10-05 10:05:00 | AAPL | Stock | 1.9264 | 1.9275 | 1.9054 | 1.9111 | 18917892.0 |
| 2005-10-05 10:10:00 | AAPL | Stock | 1.9111 | 1.9136 | 1.9039 | 1.9096 | 12473860.0 |
| 2005-10-05 10:15:00 | AAPL | Stock | 1.9096 | 1.9207 | 1.9096 | 1.9186 | 9863476.0 |
| 2005-10-05 10:20:00 | AAPL | Stock | 1.9186 | 1.92 | 1.9129 | 1.9193 | 6425076.0 |
| 2005-10-05 10:25:00 | AAPL | Stock | 1.9193 | 1.9221 | 1.9175 | 1.9196 | 7528276.0 |
| 2005-10-05 10:30:00 | AAPL | Stock | 1.9193 | 1.9225 | 1.9161 | 1.9171 | 9893464.0 |
| 2005-10-05 10:35:00 | AAPL | Stock | 1.9164 | 1.925 | 1.9164 | 1.9229 | 7544544.0 |
| 2005-10-05 10:40:00 | AAPL | Stock | 1.9225 | 1.9271 | 1.9221 | 1.9246 | 6724872.0 |
| 2005-10-05 10:45:00 | AAPL | Stock | 1.9247 | 1.925 | 1.9193 | 1.9193 | 5183920.0 |
| 2005-10-05 10:50:00 | AAPL | Stock | 1.9193 | 1.9236 | 1.9189 | 1.9236 | 3967572.0 |
| 2005-10-05 10:55:00 | AAPL | Stock | 1.9236 | 1.9257 | 1.9221 | 1.9257 | 5690104.0 |
| 2005-10-05 11:00:00 | AAPL | Stock | 1.9254 | 1.9318 | 1.9243 | 1.9261 | 10216864.0 |
| 2005-10-05 11:05:00 | AAPL | Stock | 1.9257 | 1.9293 | 1.925 | 1.9282 | 5723060.0 |
| 2005-10-05 11:10:00 | AAPL | Stock | 1.9286 | 1.9296 | 1.9261 | 1.9279 | 3839808.0 |
| 2005-10-05 11:15:00 | AAPL | Stock | 1.9279 | 1.9318 | 1.9275 | 1.9307 | 6514200.0 |
| 2005-10-05 11:20:00 | AAPL | Stock | 1.9307 | 1.9311 | 1.9246 | 1.9268 | 6215440.0 |
| 2005-10-05 11:25:00 | AAPL | Stock | 1.9271 | 1.9271 | 1.9161 | 1.9179 | 9469096.0 |
| 2005-10-05 11:30:00 | AAPL | Stock | 1.9179 | 1.9211 | 1.9146 | 1.9189 | 7686756.0 |
| 2005-10-05 11:35:00 | AAPL | Stock | 1.9189 | 1.9229 | 1.9161 | 1.9229 | 4875052.0 |
| 2005-10-05 11:40:00 | AAPL | Stock | 1.9225 | 1.9229 | 1.9193 | 1.9193 | 7872676.0 |
| 2005-10-05 11:45:00 | AAPL | Stock | 1.9193 | 1.9196 | 1.9125 | 1.9129 | 8527176.0 |
| 2005-10-05 11:50:00 | AAPL | Stock | 1.9129 | 1.9132 | 1.9057 | 1.9082 | 9300956.0 |
| 2005-10-05 11:55:00 | AAPL | Stock | 1.9075 | 1.9125 | 1.9075 | 1.9104 | 5638304.0 |
| 2005-10-05 12:00:00 | AAPL | Stock | 1.9104 | 1.9114 | 1.9046 | 1.9075 | 7757512.0 |
| 2005-10-05 12:05:00 | AAPL | Stock | 1.9071 | 1.91 | 1.9061 | 1.9068 | 4672136.0 |
> showing 50 of 210,355 rows — these rows as CSV