PREVIEW / stock_1min / 2011-07-06
file: by_date/stock_1min/2011/2011-07-06.parquet size: 13.1 MB rows: 1,002,617 symbols: 2,856
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 |
|---|---|---|---|---|---|---|---|
| 2011-07-06 04:21:00 | AAPL | Stock | 12.4129 | 12.4129 | 12.4129 | 12.4129 | 2800.0 |
| 2011-07-06 05:09:00 | AAPL | Stock | 12.4325 | 12.4325 | 12.4325 | 12.4325 | 2800.0 |
| 2011-07-06 05:24:00 | AAPL | Stock | 12.4089 | 12.4089 | 12.4089 | 12.4089 | 2800.0 |
| 2011-07-06 05:25:00 | AAPL | Stock | 12.4089 | 12.4089 | 12.4089 | 12.4089 | 2800.0 |
| 2011-07-06 06:12:00 | AAPL | Stock | 12.4375 | 12.4375 | 12.4375 | 12.4375 | 2800.0 |
| 2011-07-06 06:37:00 | AAPL | Stock | 12.4218 | 12.4218 | 12.4214 | 12.4214 | 5600.0 |
| 2011-07-06 06:38:00 | AAPL | Stock | 12.4214 | 12.4214 | 12.4214 | 12.4214 | 6300.0 |
| 2011-07-06 06:47:00 | AAPL | Stock | 12.4239 | 12.4239 | 12.4239 | 12.4239 | 2800.0 |
| 2011-07-06 06:53:00 | AAPL | Stock | 12.4214 | 12.4214 | 12.4214 | 12.4214 | 2800.0 |
| 2011-07-06 06:54:00 | AAPL | Stock | 12.4393 | 12.4432 | 12.4393 | 12.4432 | 11200.0 |
| 2011-07-06 07:01:00 | AAPL | Stock | 12.4639 | 12.4925 | 12.4639 | 12.4925 | 19600.0 |
| 2011-07-06 07:03:00 | AAPL | Stock | 12.4682 | 12.4682 | 12.4679 | 12.4679 | 5600.0 |
| 2011-07-06 07:04:00 | AAPL | Stock | 12.475 | 12.4889 | 12.475 | 12.4889 | 5600.0 |
| 2011-07-06 07:07:00 | AAPL | Stock | 12.4511 | 12.4511 | 12.4507 | 12.4507 | 14000.0 |
| 2011-07-06 07:08:00 | AAPL | Stock | 12.45 | 12.45 | 12.45 | 12.45 | 8400.0 |
| 2011-07-06 07:09:00 | AAPL | Stock | 12.45 | 12.45 | 12.45 | 12.45 | 2800.0 |
| 2011-07-06 07:14:00 | AAPL | Stock | 12.4436 | 12.4436 | 12.4436 | 12.4436 | 5600.0 |
| 2011-07-06 07:17:00 | AAPL | Stock | 12.4432 | 12.4432 | 12.4432 | 12.4432 | 2800.0 |
| 2011-07-06 07:19:00 | AAPL | Stock | 12.4357 | 12.4357 | 12.4357 | 12.4357 | 27440.0 |
| 2011-07-06 07:25:00 | AAPL | Stock | 12.4464 | 12.4464 | 12.4464 | 12.4464 | 11200.0 |
| 2011-07-06 07:27:00 | AAPL | Stock | 12.4536 | 12.4536 | 12.4536 | 12.4536 | 11200.0 |
| 2011-07-06 07:29:00 | AAPL | Stock | 12.4607 | 12.4607 | 12.4607 | 12.4607 | 2800.0 |
| 2011-07-06 07:32:00 | AAPL | Stock | 12.4536 | 12.4536 | 12.4536 | 12.4536 | 19600.0 |
| 2011-07-06 07:38:00 | AAPL | Stock | 12.4536 | 12.4536 | 12.4536 | 12.4536 | 2800.0 |
| 2011-07-06 07:39:00 | AAPL | Stock | 12.4404 | 12.4404 | 12.4404 | 12.4404 | 8400.0 |
| 2011-07-06 07:40:00 | AAPL | Stock | 12.4393 | 12.4393 | 12.4393 | 12.4393 | 14000.0 |
| 2011-07-06 07:52:00 | AAPL | Stock | 12.4386 | 12.4386 | 12.4386 | 12.4386 | 2800.0 |
| 2011-07-06 07:54:00 | AAPL | Stock | 12.4339 | 12.4339 | 12.4321 | 12.4339 | 23660.0 |
| 2011-07-06 07:56:00 | AAPL | Stock | 12.4346 | 12.4346 | 12.4346 | 12.4346 | 5600.0 |
| 2011-07-06 08:00:00 | AAPL | Stock | 12.4446 | 12.45 | 12.4361 | 12.4429 | 37156.0 |
| 2011-07-06 08:01:00 | AAPL | Stock | 12.4532 | 12.4536 | 12.4532 | 12.4536 | 6524.0 |
| 2011-07-06 08:02:00 | AAPL | Stock | 12.4529 | 12.4536 | 12.4496 | 12.4496 | 15400.0 |
| 2011-07-06 08:03:00 | AAPL | Stock | 12.4464 | 12.4529 | 12.4464 | 12.4529 | 9800.0 |
| 2011-07-06 08:04:00 | AAPL | Stock | 12.4482 | 12.45 | 12.4482 | 12.45 | 50400.0 |
| 2011-07-06 08:07:00 | AAPL | Stock | 12.4464 | 12.4464 | 12.4464 | 12.4464 | 2800.0 |
| 2011-07-06 08:08:00 | AAPL | Stock | 12.4443 | 12.4443 | 12.4429 | 12.4429 | 56000.0 |
| 2011-07-06 08:09:00 | AAPL | Stock | 12.4393 | 12.4393 | 12.4339 | 12.4339 | 96460.0 |
| 2011-07-06 08:10:00 | AAPL | Stock | 12.4389 | 12.4389 | 12.4389 | 12.4389 | 2800.0 |
| 2011-07-06 08:12:00 | AAPL | Stock | 12.4325 | 12.4325 | 12.4325 | 12.4325 | 2940.0 |
| 2011-07-06 08:14:00 | AAPL | Stock | 12.4329 | 12.4357 | 12.4329 | 12.4357 | 11200.0 |
| 2011-07-06 08:15:00 | AAPL | Stock | 12.4357 | 12.4357 | 12.4357 | 12.4357 | 12040.0 |
| 2011-07-06 08:16:00 | AAPL | Stock | 12.4361 | 12.4361 | 12.4361 | 12.4361 | 5600.0 |
| 2011-07-06 08:17:00 | AAPL | Stock | 12.4361 | 12.4361 | 12.4357 | 12.4357 | 8400.0 |
| 2011-07-06 08:19:00 | AAPL | Stock | 12.4375 | 12.4375 | 12.4375 | 12.4375 | 7840.0 |
| 2011-07-06 08:20:00 | AAPL | Stock | 12.4364 | 12.4364 | 12.4364 | 12.4364 | 8400.0 |
| 2011-07-06 08:21:00 | AAPL | Stock | 12.4364 | 12.4364 | 12.4364 | 12.4364 | 2800.0 |
| 2011-07-06 08:23:00 | AAPL | Stock | 12.4375 | 12.4375 | 12.4321 | 12.4321 | 30912.0 |
| 2011-07-06 08:26:00 | AAPL | Stock | 12.4339 | 12.4339 | 12.4336 | 12.4336 | 5600.0 |
| 2011-07-06 08:27:00 | AAPL | Stock | 12.4354 | 12.4357 | 12.4354 | 12.4357 | 10724.0 |
| 2011-07-06 08:29:00 | AAPL | Stock | 12.4371 | 12.4371 | 12.4368 | 12.4368 | 5600.0 |
> showing 50 of 1,002,617 rows — these rows as CSV