PREVIEW / stock_1min / 2006-11-16
file: by_date/stock_1min/2006/2006-11-16.parquet size: 9.0 MB rows: 729,715 symbols: 1,986
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 |
|---|---|---|---|---|---|---|---|
| 2006-11-16 04:28:00 | AAPL | Stock | 3.0214 | 3.0214 | 3.0214 | 3.0214 | 2800.0 |
| 2006-11-16 07:10:00 | AAPL | Stock | 3.0189 | 3.0189 | 3.0179 | 3.0179 | 17192.0 |
| 2006-11-16 07:14:00 | AAPL | Stock | 3.0214 | 3.0214 | 3.0214 | 3.0214 | 5600.0 |
| 2006-11-16 07:16:00 | AAPL | Stock | 3.0286 | 3.0286 | 3.0286 | 3.0286 | 2800.0 |
| 2006-11-16 07:22:00 | AAPL | Stock | 3.0282 | 3.0282 | 3.0282 | 3.0282 | 14000.0 |
| 2006-11-16 07:29:00 | AAPL | Stock | 3.0279 | 3.0279 | 3.0279 | 3.0279 | 24920.0 |
| 2006-11-16 07:30:00 | AAPL | Stock | 3.0286 | 3.0286 | 3.0286 | 3.0286 | 5600.0 |
| 2006-11-16 07:31:00 | AAPL | Stock | 3.0286 | 3.035 | 3.0286 | 3.035 | 8400.0 |
| 2006-11-16 07:33:00 | AAPL | Stock | 3.035 | 3.035 | 3.035 | 3.035 | 8400.0 |
| 2006-11-16 07:44:00 | AAPL | Stock | 3.0254 | 3.0254 | 3.0254 | 3.0254 | 5600.0 |
| 2006-11-16 07:49:00 | AAPL | Stock | 3.0246 | 3.0246 | 3.0246 | 3.0246 | 2800.0 |
| 2006-11-16 07:50:00 | AAPL | Stock | 3.0214 | 3.0214 | 3.0214 | 3.0214 | 14000.0 |
| 2006-11-16 07:51:00 | AAPL | Stock | 3.0204 | 3.0232 | 3.0204 | 3.0232 | 8400.0 |
| 2006-11-16 07:52:00 | AAPL | Stock | 3.0232 | 3.025 | 3.0232 | 3.025 | 27720.0 |
| 2006-11-16 07:58:00 | AAPL | Stock | 3.0221 | 3.0221 | 3.0221 | 3.0221 | 36400.0 |
| 2006-11-16 07:59:00 | AAPL | Stock | 3.0214 | 3.0214 | 3.0214 | 3.0214 | 70000.0 |
| 2006-11-16 08:00:00 | AAPL | Stock | 3.0214 | 3.025 | 3.0196 | 3.0214 | 565180.0 |
| 2006-11-16 08:01:00 | AAPL | Stock | 3.0204 | 3.0214 | 3.0204 | 3.0214 | 56000.0 |
| 2006-11-16 08:02:00 | AAPL | Stock | 3.0196 | 3.0214 | 3.0189 | 3.0189 | 156800.0 |
| 2006-11-16 08:03:00 | AAPL | Stock | 3.0189 | 3.025 | 3.0179 | 3.0214 | 292964.0 |
| 2006-11-16 08:04:00 | AAPL | Stock | 3.0257 | 3.0257 | 3.0257 | 3.0257 | 2800.0 |
| 2006-11-16 08:05:00 | AAPL | Stock | 3.0268 | 3.0271 | 3.0268 | 3.0271 | 70000.0 |
| 2006-11-16 08:06:00 | AAPL | Stock | 3.0268 | 3.0268 | 3.0246 | 3.0246 | 16800.0 |
| 2006-11-16 08:07:00 | AAPL | Stock | 3.0246 | 3.0279 | 3.0246 | 3.0279 | 25200.0 |
| 2006-11-16 08:08:00 | AAPL | Stock | 3.0271 | 3.0271 | 3.0271 | 3.0271 | 30800.0 |
| 2006-11-16 08:09:00 | AAPL | Stock | 3.0271 | 3.0279 | 3.0271 | 3.0271 | 65100.0 |
| 2006-11-16 08:10:00 | AAPL | Stock | 3.0239 | 3.0239 | 3.0204 | 3.0204 | 212436.0 |
| 2006-11-16 08:11:00 | AAPL | Stock | 3.0204 | 3.0204 | 3.0204 | 3.0204 | 64484.0 |
| 2006-11-16 08:14:00 | AAPL | Stock | 3.0243 | 3.0243 | 3.0243 | 3.0243 | 2800.0 |
| 2006-11-16 08:15:00 | AAPL | Stock | 3.0243 | 3.0243 | 3.0243 | 3.0243 | 11200.0 |
| 2006-11-16 08:16:00 | AAPL | Stock | 3.0243 | 3.0243 | 3.0243 | 3.0243 | 31500.0 |
| 2006-11-16 08:17:00 | AAPL | Stock | 3.0243 | 3.0243 | 3.0243 | 3.0243 | 6244.0 |
| 2006-11-16 08:19:00 | AAPL | Stock | 3.0232 | 3.025 | 3.0232 | 3.025 | 34524.0 |
| 2006-11-16 08:20:00 | AAPL | Stock | 3.0264 | 3.0264 | 3.0264 | 3.0264 | 9100.0 |
| 2006-11-16 08:21:00 | AAPL | Stock | 3.0264 | 3.0264 | 3.0264 | 3.0264 | 4900.0 |
| 2006-11-16 08:22:00 | AAPL | Stock | 3.0264 | 3.0264 | 3.0264 | 3.0264 | 14000.0 |
| 2006-11-16 08:24:00 | AAPL | Stock | 3.0257 | 3.0275 | 3.025 | 3.0268 | 188300.0 |
| 2006-11-16 08:25:00 | AAPL | Stock | 3.0268 | 3.0268 | 3.0268 | 3.0268 | 80500.0 |
| 2006-11-16 08:27:00 | AAPL | Stock | 3.025 | 3.025 | 3.025 | 3.025 | 37520.0 |
| 2006-11-16 08:28:00 | AAPL | Stock | 3.0268 | 3.0268 | 3.0268 | 3.0268 | 36400.0 |
| 2006-11-16 08:29:00 | AAPL | Stock | 3.0268 | 3.0268 | 3.0239 | 3.0239 | 50400.0 |
| 2006-11-16 08:30:00 | AAPL | Stock | 3.025 | 3.0304 | 3.025 | 3.0304 | 356748.0 |
| 2006-11-16 08:31:00 | AAPL | Stock | 3.0304 | 3.0336 | 3.0246 | 3.0336 | 572712.0 |
| 2006-11-16 08:32:00 | AAPL | Stock | 3.0336 | 3.0336 | 3.0286 | 3.0332 | 447440.0 |
| 2006-11-16 08:33:00 | AAPL | Stock | 3.0332 | 3.0332 | 3.0321 | 3.0325 | 170800.0 |
| 2006-11-16 08:34:00 | AAPL | Stock | 3.0304 | 3.0304 | 3.0304 | 3.0304 | 9800.0 |
| 2006-11-16 08:35:00 | AAPL | Stock | 3.0304 | 3.0321 | 3.0304 | 3.0321 | 21000.0 |
| 2006-11-16 08:36:00 | AAPL | Stock | 3.03 | 3.0321 | 3.0286 | 3.0321 | 35000.0 |
| 2006-11-16 08:37:00 | AAPL | Stock | 3.0304 | 3.0321 | 3.0304 | 3.0314 | 71400.0 |
| 2006-11-16 08:38:00 | AAPL | Stock | 3.0321 | 3.0336 | 3.0321 | 3.0336 | 313320.0 |
> showing 50 of 729,715 rows — these rows as CSV