PREVIEW / stock_1min / 2004-10-29
file: by_date/stock_1min/2004/2004-10-29.parquet size: 6.2 MB rows: 511,690 symbols: 1,529
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 |
|---|---|---|---|---|---|---|---|
| 2004-10-29 08:00:00 | AAPL | Stock | 0.9286 | 0.9286 | 0.9259 | 0.9259 | 11200.0 |
| 2004-10-29 08:01:00 | AAPL | Stock | 0.9311 | 0.9311 | 0.9254 | 0.9304 | 68544.0 |
| 2004-10-29 08:07:00 | AAPL | Stock | 0.9286 | 0.9286 | 0.9286 | 0.9286 | 5600.0 |
| 2004-10-29 08:10:00 | AAPL | Stock | 0.9286 | 0.9286 | 0.9286 | 0.9286 | 50400.0 |
| 2004-10-29 08:18:00 | AAPL | Stock | 0.9275 | 0.9275 | 0.9275 | 0.9275 | 11200.0 |
| 2004-10-29 08:25:00 | AAPL | Stock | 0.9284 | 0.9284 | 0.9284 | 0.9284 | 5600.0 |
| 2004-10-29 08:27:00 | AAPL | Stock | 0.9277 | 0.9284 | 0.9275 | 0.9275 | 57960.0 |
| 2004-10-29 08:28:00 | AAPL | Stock | 0.9286 | 0.9286 | 0.9284 | 0.9286 | 144928.0 |
| 2004-10-29 08:30:00 | AAPL | Stock | 0.9286 | 0.9286 | 0.9286 | 0.9286 | 135072.0 |
| 2004-10-29 08:31:00 | AAPL | Stock | 0.9268 | 0.927 | 0.9268 | 0.927 | 67200.0 |
| 2004-10-29 08:39:00 | AAPL | Stock | 0.927 | 0.927 | 0.927 | 0.927 | 5600.0 |
| 2004-10-29 08:40:00 | AAPL | Stock | 0.9286 | 0.9286 | 0.9286 | 0.9286 | 11200.0 |
| 2004-10-29 08:44:00 | AAPL | Stock | 0.927 | 0.927 | 0.927 | 0.927 | 26880.0 |
| 2004-10-29 08:47:00 | AAPL | Stock | 0.9286 | 0.9286 | 0.9286 | 0.9286 | 28000.0 |
| 2004-10-29 08:53:00 | AAPL | Stock | 0.9288 | 0.9288 | 0.9277 | 0.9277 | 28000.0 |
| 2004-10-29 08:56:00 | AAPL | Stock | 0.9286 | 0.9286 | 0.9286 | 0.9286 | 28000.0 |
| 2004-10-29 08:58:00 | AAPL | Stock | 0.9293 | 0.9293 | 0.9293 | 0.9293 | 5600.0 |
| 2004-10-29 08:59:00 | AAPL | Stock | 0.9284 | 0.9284 | 0.9284 | 0.9284 | 5600.0 |
| 2004-10-29 09:03:00 | AAPL | Stock | 0.9282 | 0.9293 | 0.9277 | 0.9293 | 28000.0 |
| 2004-10-29 09:06:00 | AAPL | Stock | 0.9288 | 0.9296 | 0.9277 | 0.9277 | 89600.0 |
| 2004-10-29 09:07:00 | AAPL | Stock | 0.9277 | 0.9284 | 0.9277 | 0.9284 | 67200.0 |
| 2004-10-29 09:12:00 | AAPL | Stock | 0.9284 | 0.9284 | 0.9284 | 0.9284 | 56000.0 |
| 2004-10-29 09:14:00 | AAPL | Stock | 0.9277 | 0.9277 | 0.9277 | 0.9277 | 50400.0 |
| 2004-10-29 09:25:00 | AAPL | Stock | 0.9295 | 0.9295 | 0.9284 | 0.9284 | 39200.0 |
| 2004-10-29 09:27:00 | AAPL | Stock | 0.9282 | 0.9282 | 0.9282 | 0.9282 | 16800.0 |
| 2004-10-29 09:28:00 | AAPL | Stock | 0.9279 | 0.9279 | 0.9268 | 0.9268 | 28000.0 |
| 2004-10-29 09:29:00 | AAPL | Stock | 0.9268 | 0.9286 | 0.9268 | 0.9284 | 1085056.0 |
| 2004-10-29 09:30:00 | AAPL | Stock | 0.9279 | 0.9284 | 0.925 | 0.9266 | 9324336.0 |
| 2004-10-29 09:31:00 | AAPL | Stock | 0.9266 | 0.9284 | 0.925 | 0.9284 | 3988432.0 |
| 2004-10-29 09:32:00 | AAPL | Stock | 0.9284 | 0.9305 | 0.9263 | 0.9266 | 6199256.0 |
| 2004-10-29 09:33:00 | AAPL | Stock | 0.9266 | 0.9291 | 0.925 | 0.9286 | 3558296.0 |
| 2004-10-29 09:34:00 | AAPL | Stock | 0.9284 | 0.932 | 0.9284 | 0.9316 | 4134536.0 |
| 2004-10-29 09:35:00 | AAPL | Stock | 0.9313 | 0.932 | 0.9302 | 0.9311 | 2209984.0 |
| 2004-10-29 09:36:00 | AAPL | Stock | 0.9304 | 0.9318 | 0.9304 | 0.9305 | 3170944.0 |
| 2004-10-29 09:37:00 | AAPL | Stock | 0.9304 | 0.9318 | 0.9303 | 0.9318 | 3175088.0 |
| 2004-10-29 09:38:00 | AAPL | Stock | 0.9318 | 0.9375 | 0.9313 | 0.9364 | 8802528.0 |
| 2004-10-29 09:39:00 | AAPL | Stock | 0.9363 | 0.937 | 0.9348 | 0.9363 | 4542496.0 |
| 2004-10-29 09:40:00 | AAPL | Stock | 0.9364 | 0.94 | 0.9352 | 0.9396 | 5662440.0 |
| 2004-10-29 09:41:00 | AAPL | Stock | 0.9395 | 0.9409 | 0.9386 | 0.9395 | 5667480.0 |
| 2004-10-29 09:42:00 | AAPL | Stock | 0.9395 | 0.9418 | 0.9391 | 0.9413 | 5378856.0 |
| 2004-10-29 09:43:00 | AAPL | Stock | 0.9414 | 0.9427 | 0.9405 | 0.9427 | 7518616.0 |
| 2004-10-29 09:44:00 | AAPL | Stock | 0.9425 | 0.9446 | 0.9423 | 0.9434 | 5082728.0 |
| 2004-10-29 09:45:00 | AAPL | Stock | 0.9432 | 0.9438 | 0.9413 | 0.9425 | 4565400.0 |
| 2004-10-29 09:46:00 | AAPL | Stock | 0.9425 | 0.9459 | 0.9423 | 0.9457 | 3902528.0 |
| 2004-10-29 09:47:00 | AAPL | Stock | 0.9455 | 0.9482 | 0.9454 | 0.9468 | 13019832.0 |
| 2004-10-29 09:48:00 | AAPL | Stock | 0.9464 | 0.9477 | 0.9441 | 0.9448 | 5219424.0 |
| 2004-10-29 09:49:00 | AAPL | Stock | 0.9446 | 0.9459 | 0.9441 | 0.9455 | 3607632.0 |
| 2004-10-29 09:50:00 | AAPL | Stock | 0.9455 | 0.9459 | 0.9427 | 0.9432 | 4969608.0 |
| 2004-10-29 09:51:00 | AAPL | Stock | 0.9436 | 0.9446 | 0.9434 | 0.9441 | 2626176.0 |
| 2004-10-29 09:52:00 | AAPL | Stock | 0.9441 | 0.9443 | 0.9418 | 0.9427 | 3080504.0 |
> showing 50 of 511,690 rows — these rows as CSV