PREVIEW / stock_1min / 2007-12-14
file: by_date/stock_1min/2007/2007-12-14.parquet size: 12.1 MB rows: 979,544 symbols: 2,643
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-12-14 06:10:00 | AAPL | Stock | 6.8643 | 6.8643 | 6.8643 | 6.8643 | 2800.0 |
| 2007-12-14 06:19:00 | AAPL | Stock | 6.8361 | 6.8361 | 6.8361 | 6.8361 | 5600.0 |
| 2007-12-14 06:44:00 | AAPL | Stock | 6.8371 | 6.8371 | 6.8371 | 6.8371 | 14000.0 |
| 2007-12-14 06:47:00 | AAPL | Stock | 6.8368 | 6.8368 | 6.8368 | 6.8368 | 2800.0 |
| 2007-12-14 06:49:00 | AAPL | Stock | 6.8368 | 6.8368 | 6.8368 | 6.8368 | 5600.0 |
| 2007-12-14 06:50:00 | AAPL | Stock | 6.8368 | 6.8368 | 6.8368 | 6.8368 | 5600.0 |
| 2007-12-14 06:54:00 | AAPL | Stock | 6.8368 | 6.8368 | 6.8368 | 6.8368 | 2800.0 |
| 2007-12-14 06:55:00 | AAPL | Stock | 6.8368 | 6.8475 | 6.8368 | 6.8475 | 19600.0 |
| 2007-12-14 06:57:00 | AAPL | Stock | 6.8368 | 6.8368 | 6.8368 | 6.8368 | 8400.0 |
| 2007-12-14 07:01:00 | AAPL | Stock | 6.8368 | 6.8368 | 6.8368 | 6.8368 | 2800.0 |
| 2007-12-14 07:02:00 | AAPL | Stock | 6.8368 | 6.8368 | 6.8368 | 6.8368 | 5600.0 |
| 2007-12-14 07:16:00 | AAPL | Stock | 6.8214 | 6.8214 | 6.8214 | 6.8214 | 8400.0 |
| 2007-12-14 07:26:00 | AAPL | Stock | 6.8304 | 6.8304 | 6.8304 | 6.8304 | 2800.0 |
| 2007-12-14 07:29:00 | AAPL | Stock | 6.8229 | 6.8229 | 6.8229 | 6.8229 | 5600.0 |
| 2007-12-14 07:39:00 | AAPL | Stock | 6.8304 | 6.8304 | 6.8304 | 6.8304 | 2800.0 |
| 2007-12-14 07:42:00 | AAPL | Stock | 6.8364 | 6.8371 | 6.8364 | 6.8371 | 16800.0 |
| 2007-12-14 07:43:00 | AAPL | Stock | 6.8371 | 6.8371 | 6.8371 | 6.8371 | 2800.0 |
| 2007-12-14 07:44:00 | AAPL | Stock | 6.8482 | 6.8482 | 6.8482 | 6.8482 | 11200.0 |
| 2007-12-14 07:47:00 | AAPL | Stock | 6.8371 | 6.8371 | 6.8371 | 6.8371 | 5600.0 |
| 2007-12-14 07:49:00 | AAPL | Stock | 6.8464 | 6.8464 | 6.8464 | 6.8464 | 11200.0 |
| 2007-12-14 07:58:00 | AAPL | Stock | 6.8321 | 6.8389 | 6.8321 | 6.8371 | 61600.0 |
| 2007-12-14 08:00:00 | AAPL | Stock | 6.8446 | 6.8554 | 6.8375 | 6.8418 | 45388.0 |
| 2007-12-14 08:01:00 | AAPL | Stock | 6.8393 | 6.8393 | 6.8311 | 6.8343 | 197484.0 |
| 2007-12-14 08:03:00 | AAPL | Stock | 6.8364 | 6.8364 | 6.8357 | 6.8357 | 5600.0 |
| 2007-12-14 08:04:00 | AAPL | Stock | 6.8321 | 6.835 | 6.8318 | 6.8318 | 33600.0 |
| 2007-12-14 08:05:00 | AAPL | Stock | 6.8318 | 6.8321 | 6.8318 | 6.8321 | 9240.0 |
| 2007-12-14 08:06:00 | AAPL | Stock | 6.8318 | 6.8318 | 6.8232 | 6.8232 | 147000.0 |
| 2007-12-14 08:07:00 | AAPL | Stock | 6.8236 | 6.8275 | 6.8236 | 6.8275 | 8400.0 |
| 2007-12-14 08:08:00 | AAPL | Stock | 6.8243 | 6.8271 | 6.8236 | 6.8236 | 50960.0 |
| 2007-12-14 08:09:00 | AAPL | Stock | 6.8236 | 6.8275 | 6.8236 | 6.8275 | 50400.0 |
| 2007-12-14 08:10:00 | AAPL | Stock | 6.8275 | 6.8286 | 6.8254 | 6.8254 | 36400.0 |
| 2007-12-14 08:11:00 | AAPL | Stock | 6.8261 | 6.8261 | 6.8254 | 6.8254 | 5600.0 |
| 2007-12-14 08:12:00 | AAPL | Stock | 6.8286 | 6.8321 | 6.8286 | 6.8321 | 9576.0 |
| 2007-12-14 08:13:00 | AAPL | Stock | 6.8329 | 6.8343 | 6.8329 | 6.8336 | 47320.0 |
| 2007-12-14 08:16:00 | AAPL | Stock | 6.8357 | 6.8357 | 6.8357 | 6.8357 | 2800.0 |
| 2007-12-14 08:18:00 | AAPL | Stock | 6.8336 | 6.8336 | 6.8321 | 6.8321 | 21000.0 |
| 2007-12-14 08:19:00 | AAPL | Stock | 6.8304 | 6.8304 | 6.8304 | 6.8304 | 8344.0 |
| 2007-12-14 08:20:00 | AAPL | Stock | 6.8318 | 6.8318 | 6.8318 | 6.8318 | 2800.0 |
| 2007-12-14 08:21:00 | AAPL | Stock | 6.8329 | 6.8411 | 6.8329 | 6.8411 | 120400.0 |
| 2007-12-14 08:22:00 | AAPL | Stock | 6.8446 | 6.8446 | 6.8432 | 6.8432 | 8400.0 |
| 2007-12-14 08:23:00 | AAPL | Stock | 6.8446 | 6.85 | 6.8436 | 6.85 | 47600.0 |
| 2007-12-14 08:24:00 | AAPL | Stock | 6.8486 | 6.8486 | 6.8482 | 6.8486 | 14000.0 |
| 2007-12-14 08:25:00 | AAPL | Stock | 6.8457 | 6.8457 | 6.8404 | 6.8404 | 92400.0 |
| 2007-12-14 08:26:00 | AAPL | Stock | 6.8439 | 6.8482 | 6.84 | 6.84 | 59024.0 |
| 2007-12-14 08:27:00 | AAPL | Stock | 6.8393 | 6.8393 | 6.8286 | 6.8304 | 107940.0 |
| 2007-12-14 08:28:00 | AAPL | Stock | 6.8364 | 6.8389 | 6.8307 | 6.8321 | 36400.0 |
| 2007-12-14 08:29:00 | AAPL | Stock | 6.8304 | 6.8321 | 6.8268 | 6.8318 | 77140.0 |
| 2007-12-14 08:30:00 | AAPL | Stock | 6.8296 | 6.8296 | 6.8054 | 6.8054 | 582820.0 |
| 2007-12-14 08:31:00 | AAPL | Stock | 6.8054 | 6.8125 | 6.7946 | 6.7993 | 183568.0 |
| 2007-12-14 08:32:00 | AAPL | Stock | 6.7964 | 6.8214 | 6.7964 | 6.81 | 132580.0 |
> showing 50 of 979,544 rows — these rows as CSV