PREVIEW / stock_1min / 2007-11-21
file: by_date/stock_1min/2007/2007-11-21.parquet size: 12.1 MB rows: 987,282 symbols: 2,603
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 |
|---|---|---|---|---|---|---|---|
| 2007-11-21 05:16:00 | AAPL | Stock | 5.95 | 5.95 | 5.95 | 5.95 | 11928.0 |
| 2007-11-21 06:02:00 | AAPL | Stock | 5.9314 | 5.9314 | 5.9314 | 5.9314 | 6328.0 |
| 2007-11-21 07:00:00 | AAPL | Stock | 5.9493 | 5.9643 | 5.9493 | 5.9507 | 28000.0 |
| 2007-11-21 07:01:00 | AAPL | Stock | 5.9589 | 5.9589 | 5.9589 | 5.9589 | 7560.0 |
| 2007-11-21 07:02:00 | AAPL | Stock | 5.9589 | 5.9689 | 5.9589 | 5.9689 | 14784.0 |
| 2007-11-21 07:03:00 | AAPL | Stock | 5.9771 | 5.9771 | 5.9771 | 5.9771 | 2800.0 |
| 2007-11-21 07:04:00 | AAPL | Stock | 5.9657 | 5.9675 | 5.9657 | 5.9657 | 14000.0 |
| 2007-11-21 07:11:00 | AAPL | Stock | 5.9643 | 5.9643 | 5.9643 | 5.9643 | 26600.0 |
| 2007-11-21 07:19:00 | AAPL | Stock | 5.965 | 5.965 | 5.965 | 5.965 | 5600.0 |
| 2007-11-21 07:21:00 | AAPL | Stock | 5.9643 | 5.9643 | 5.9643 | 5.9643 | 56000.0 |
| 2007-11-21 07:27:00 | AAPL | Stock | 5.9375 | 5.9375 | 5.9286 | 5.9286 | 64400.0 |
| 2007-11-21 07:28:00 | AAPL | Stock | 5.9261 | 5.9261 | 5.9261 | 5.9261 | 2800.0 |
| 2007-11-21 07:29:00 | AAPL | Stock | 5.9196 | 5.925 | 5.9071 | 5.9071 | 16800.0 |
| 2007-11-21 07:34:00 | AAPL | Stock | 5.9286 | 5.9286 | 5.9286 | 5.9286 | 17304.0 |
| 2007-11-21 07:35:00 | AAPL | Stock | 5.9286 | 5.9286 | 5.9286 | 5.9286 | 2800.0 |
| 2007-11-21 07:37:00 | AAPL | Stock | 5.9393 | 5.9393 | 5.9286 | 5.9286 | 25200.0 |
| 2007-11-21 07:39:00 | AAPL | Stock | 5.9464 | 5.9464 | 5.9304 | 5.935 | 46200.0 |
| 2007-11-21 07:40:00 | AAPL | Stock | 5.9307 | 5.9307 | 5.9296 | 5.9296 | 11200.0 |
| 2007-11-21 07:44:00 | AAPL | Stock | 5.9375 | 5.9375 | 5.9375 | 5.9375 | 2800.0 |
| 2007-11-21 07:45:00 | AAPL | Stock | 5.9507 | 5.9507 | 5.9464 | 5.9464 | 25620.0 |
| 2007-11-21 07:48:00 | AAPL | Stock | 5.95 | 5.9714 | 5.95 | 5.9714 | 91000.0 |
| 2007-11-21 07:49:00 | AAPL | Stock | 5.9464 | 5.9464 | 5.9464 | 5.9464 | 26600.0 |
| 2007-11-21 07:52:00 | AAPL | Stock | 5.9607 | 5.9607 | 5.9607 | 5.9607 | 28000.0 |
| 2007-11-21 07:55:00 | AAPL | Stock | 5.9582 | 5.9582 | 5.95 | 5.95 | 42000.0 |
| 2007-11-21 07:56:00 | AAPL | Stock | 5.9568 | 5.9575 | 5.9568 | 5.9575 | 33600.0 |
| 2007-11-21 07:57:00 | AAPL | Stock | 5.9575 | 5.9575 | 5.9575 | 5.9575 | 22400.0 |
| 2007-11-21 07:58:00 | AAPL | Stock | 5.9471 | 5.9471 | 5.9471 | 5.9471 | 11200.0 |
| 2007-11-21 07:59:00 | AAPL | Stock | 5.9432 | 5.9432 | 5.9432 | 5.9432 | 2800.0 |
| 2007-11-21 08:00:00 | AAPL | Stock | 5.9446 | 5.9643 | 5.9182 | 5.9454 | 616952.0 |
| 2007-11-21 08:01:00 | AAPL | Stock | 5.9339 | 5.9375 | 5.9314 | 5.9375 | 47264.0 |
| 2007-11-21 08:02:00 | AAPL | Stock | 5.9375 | 5.9375 | 5.9314 | 5.9375 | 78400.0 |
| 2007-11-21 08:03:00 | AAPL | Stock | 5.9429 | 5.9464 | 5.9364 | 5.9464 | 100800.0 |
| 2007-11-21 08:04:00 | AAPL | Stock | 5.9464 | 5.9536 | 5.9393 | 5.9532 | 100044.0 |
| 2007-11-21 08:05:00 | AAPL | Stock | 5.95 | 5.9504 | 5.9464 | 5.95 | 41440.0 |
| 2007-11-21 08:06:00 | AAPL | Stock | 5.95 | 5.9536 | 5.9482 | 5.9511 | 143108.0 |
| 2007-11-21 08:07:00 | AAPL | Stock | 5.9464 | 5.9493 | 5.9464 | 5.9464 | 47460.0 |
| 2007-11-21 08:08:00 | AAPL | Stock | 5.9468 | 5.9471 | 5.9414 | 5.9414 | 160440.0 |
| 2007-11-21 08:09:00 | AAPL | Stock | 5.9414 | 5.9421 | 5.9325 | 5.9393 | 170800.0 |
| 2007-11-21 08:10:00 | AAPL | Stock | 5.9393 | 5.9464 | 5.9393 | 5.9393 | 49476.0 |
| 2007-11-21 08:11:00 | AAPL | Stock | 5.9429 | 5.9429 | 5.9286 | 5.9286 | 197484.0 |
| 2007-11-21 08:12:00 | AAPL | Stock | 5.9321 | 5.9393 | 5.9321 | 5.9379 | 82600.0 |
| 2007-11-21 08:13:00 | AAPL | Stock | 5.9393 | 5.9393 | 5.9318 | 5.9321 | 78736.0 |
| 2007-11-21 08:14:00 | AAPL | Stock | 5.9339 | 5.9357 | 5.9325 | 5.9325 | 43260.0 |
| 2007-11-21 08:15:00 | AAPL | Stock | 5.9339 | 5.9361 | 5.9339 | 5.9361 | 18088.0 |
| 2007-11-21 08:16:00 | AAPL | Stock | 5.9368 | 5.9393 | 5.9354 | 5.9393 | 14000.0 |
| 2007-11-21 08:17:00 | AAPL | Stock | 5.9371 | 5.9411 | 5.9371 | 5.9411 | 28000.0 |
| 2007-11-21 08:18:00 | AAPL | Stock | 5.9414 | 5.9414 | 5.93 | 5.93 | 347060.0 |
| 2007-11-21 08:19:00 | AAPL | Stock | 5.9307 | 5.9307 | 5.9282 | 5.9286 | 134960.0 |
| 2007-11-21 08:20:00 | AAPL | Stock | 5.9286 | 5.9286 | 5.9254 | 5.9254 | 18200.0 |
| 2007-11-21 08:21:00 | AAPL | Stock | 5.9254 | 5.9254 | 5.9254 | 5.9254 | 5600.0 |
> showing 50 of 987,282 rows — these rows as CSV