PREVIEW / stock_1min / 2011-06-16
file: by_date/stock_1min/2011/2011-06-16.parquet size: 13.7 MB rows: 1,033,172 symbols: 2,870
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-06-16 04:25:00 | AAPL | Stock | 11.6886 | 11.6886 | 11.6886 | 11.6886 | 2800.0 |
| 2011-06-16 05:49:00 | AAPL | Stock | 11.6518 | 11.6518 | 11.6518 | 11.6518 | 8400.0 |
| 2011-06-16 06:09:00 | AAPL | Stock | 11.6421 | 11.6421 | 11.6421 | 11.6421 | 2800.0 |
| 2011-06-16 06:30:00 | AAPL | Stock | 11.6179 | 11.6179 | 11.6146 | 11.6146 | 5600.0 |
| 2011-06-16 06:59:00 | AAPL | Stock | 11.6271 | 11.6271 | 11.6271 | 11.6271 | 2800.0 |
| 2011-06-16 07:00:00 | AAPL | Stock | 11.6271 | 11.6571 | 11.6271 | 11.6571 | 8400.0 |
| 2011-06-16 07:10:00 | AAPL | Stock | 11.635 | 11.635 | 11.6339 | 11.6339 | 8400.0 |
| 2011-06-16 07:11:00 | AAPL | Stock | 11.6557 | 11.6557 | 11.6557 | 11.6557 | 39200.0 |
| 2011-06-16 07:13:00 | AAPL | Stock | 11.6554 | 11.6554 | 11.6554 | 11.6554 | 2800.0 |
| 2011-06-16 07:14:00 | AAPL | Stock | 11.6507 | 11.6507 | 11.6507 | 11.6507 | 5600.0 |
| 2011-06-16 07:16:00 | AAPL | Stock | 11.6607 | 11.6607 | 11.6607 | 11.6607 | 5600.0 |
| 2011-06-16 07:19:00 | AAPL | Stock | 11.6514 | 11.6514 | 11.6493 | 11.6493 | 5600.0 |
| 2011-06-16 07:23:00 | AAPL | Stock | 11.6429 | 11.6429 | 11.6429 | 11.6429 | 2800.0 |
| 2011-06-16 07:32:00 | AAPL | Stock | 11.6364 | 11.6364 | 11.6364 | 11.6364 | 2800.0 |
| 2011-06-16 07:33:00 | AAPL | Stock | 11.6371 | 11.6371 | 11.6371 | 11.6371 | 2800.0 |
| 2011-06-16 07:37:00 | AAPL | Stock | 11.65 | 11.65 | 11.65 | 11.65 | 2800.0 |
| 2011-06-16 07:42:00 | AAPL | Stock | 11.6557 | 11.6561 | 11.6361 | 11.6361 | 8400.0 |
| 2011-06-16 07:43:00 | AAPL | Stock | 11.6432 | 11.6432 | 11.6432 | 11.6432 | 2800.0 |
| 2011-06-16 07:56:00 | AAPL | Stock | 11.6429 | 11.6429 | 11.6429 | 11.6429 | 2800.0 |
| 2011-06-16 07:57:00 | AAPL | Stock | 11.6361 | 11.6361 | 11.6339 | 11.6339 | 30800.0 |
| 2011-06-16 08:00:00 | AAPL | Stock | 11.6389 | 11.6389 | 11.6318 | 11.6321 | 30800.0 |
| 2011-06-16 08:01:00 | AAPL | Stock | 11.635 | 11.635 | 11.6271 | 11.6271 | 5600.0 |
| 2011-06-16 08:02:00 | AAPL | Stock | 11.6257 | 11.6364 | 11.625 | 11.625 | 46844.0 |
| 2011-06-16 08:04:00 | AAPL | Stock | 11.6375 | 11.6393 | 11.6357 | 11.6393 | 23800.0 |
| 2011-06-16 08:06:00 | AAPL | Stock | 11.6357 | 11.6357 | 11.6289 | 11.6289 | 35364.0 |
| 2011-06-16 08:07:00 | AAPL | Stock | 11.6286 | 11.6286 | 11.6286 | 11.6286 | 6048.0 |
| 2011-06-16 08:08:00 | AAPL | Stock | 11.6257 | 11.6286 | 11.6257 | 11.6286 | 5992.0 |
| 2011-06-16 08:09:00 | AAPL | Stock | 11.6257 | 11.6257 | 11.6257 | 11.6257 | 2800.0 |
| 2011-06-16 08:10:00 | AAPL | Stock | 11.6286 | 11.6393 | 11.6286 | 11.6361 | 38360.0 |
| 2011-06-16 08:11:00 | AAPL | Stock | 11.6361 | 11.6361 | 11.6361 | 11.6361 | 8176.0 |
| 2011-06-16 08:12:00 | AAPL | Stock | 11.6393 | 11.6411 | 11.6393 | 11.6411 | 22680.0 |
| 2011-06-16 08:13:00 | AAPL | Stock | 11.6429 | 11.6429 | 11.6429 | 11.6429 | 4760.0 |
| 2011-06-16 08:14:00 | AAPL | Stock | 11.6357 | 11.6357 | 11.6357 | 11.6357 | 2800.0 |
| 2011-06-16 08:20:00 | AAPL | Stock | 11.6321 | 11.6321 | 11.6321 | 11.6321 | 8400.0 |
| 2011-06-16 08:21:00 | AAPL | Stock | 11.625 | 11.6257 | 11.625 | 11.625 | 46620.0 |
| 2011-06-16 08:22:00 | AAPL | Stock | 11.6196 | 11.6254 | 11.6179 | 11.6254 | 22400.0 |
| 2011-06-16 08:24:00 | AAPL | Stock | 11.6257 | 11.6289 | 11.6257 | 11.6289 | 21700.0 |
| 2011-06-16 08:25:00 | AAPL | Stock | 11.6257 | 11.6257 | 11.6257 | 11.6257 | 6720.0 |
| 2011-06-16 08:26:00 | AAPL | Stock | 11.625 | 11.6304 | 11.625 | 11.6304 | 5600.0 |
| 2011-06-16 08:27:00 | AAPL | Stock | 11.6268 | 11.6268 | 11.625 | 11.625 | 26600.0 |
| 2011-06-16 08:29:00 | AAPL | Stock | 11.6268 | 11.6268 | 11.625 | 11.625 | 22400.0 |
| 2011-06-16 08:30:00 | AAPL | Stock | 11.6304 | 11.6696 | 11.6304 | 11.6696 | 227640.0 |
| 2011-06-16 08:31:00 | AAPL | Stock | 11.6607 | 11.6696 | 11.6539 | 11.6696 | 88760.0 |
| 2011-06-16 08:32:00 | AAPL | Stock | 11.6704 | 11.6786 | 11.6675 | 11.6696 | 118384.0 |
| 2011-06-16 08:33:00 | AAPL | Stock | 11.6696 | 11.6789 | 11.6696 | 11.6786 | 93800.0 |
| 2011-06-16 08:34:00 | AAPL | Stock | 11.6786 | 11.6786 | 11.6675 | 11.6675 | 66388.0 |
| 2011-06-16 08:35:00 | AAPL | Stock | 11.6675 | 11.6707 | 11.6675 | 11.6696 | 29400.0 |
| 2011-06-16 08:36:00 | AAPL | Stock | 11.6779 | 11.6786 | 11.6768 | 11.6782 | 22400.0 |
| 2011-06-16 08:37:00 | AAPL | Stock | 11.6786 | 11.6786 | 11.6732 | 11.6739 | 20160.0 |
| 2011-06-16 08:38:00 | AAPL | Stock | 11.6718 | 11.6718 | 11.67 | 11.67 | 13860.0 |
> showing 50 of 1,033,172 rows — these rows as CSV