PREVIEW / stock_1min / 2012-07-09
file: by_date/stock_1min/2012/2012-07-09.parquet size: 12.0 MB rows: 898,677 symbols: 2,809
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 |
|---|---|---|---|---|---|---|---|
| 2012-07-09 04:00:00 | AAPL | Stock | 21.7321 | 21.7321 | 21.7321 | 21.7321 | 2800.0 |
| 2012-07-09 04:11:00 | AAPL | Stock | 21.6071 | 21.6071 | 21.6071 | 21.6071 | 2800.0 |
| 2012-07-09 04:19:00 | AAPL | Stock | 21.6071 | 21.6071 | 21.6071 | 21.6071 | 2800.0 |
| 2012-07-09 05:26:00 | AAPL | Stock | 21.5539 | 21.5539 | 21.5539 | 21.5539 | 25200.0 |
| 2012-07-09 05:27:00 | AAPL | Stock | 21.5539 | 21.5539 | 21.5539 | 21.5539 | 8400.0 |
| 2012-07-09 05:28:00 | AAPL | Stock | 21.5539 | 21.5539 | 21.5536 | 21.5539 | 40600.0 |
| 2012-07-09 05:29:00 | AAPL | Stock | 21.5893 | 21.5893 | 21.5893 | 21.5893 | 2800.0 |
| 2012-07-09 06:30:00 | AAPL | Stock | 21.6321 | 21.6321 | 21.6321 | 21.6321 | 2800.0 |
| 2012-07-09 06:39:00 | AAPL | Stock | 21.6429 | 21.6429 | 21.6429 | 21.6429 | 2800.0 |
| 2012-07-09 06:48:00 | AAPL | Stock | 21.6321 | 21.6321 | 21.6321 | 21.6321 | 2800.0 |
| 2012-07-09 06:53:00 | AAPL | Stock | 21.6393 | 21.6393 | 21.6393 | 21.6393 | 2800.0 |
| 2012-07-09 06:56:00 | AAPL | Stock | 21.6379 | 21.6379 | 21.6379 | 21.6379 | 2800.0 |
| 2012-07-09 06:58:00 | AAPL | Stock | 21.635 | 21.635 | 21.635 | 21.635 | 2800.0 |
| 2012-07-09 07:00:00 | AAPL | Stock | 21.6354 | 21.6354 | 21.6354 | 21.6354 | 5600.0 |
| 2012-07-09 07:02:00 | AAPL | Stock | 21.635 | 21.6429 | 21.635 | 21.6429 | 11200.0 |
| 2012-07-09 07:04:00 | AAPL | Stock | 21.6514 | 21.6518 | 21.6514 | 21.6518 | 5600.0 |
| 2012-07-09 07:05:00 | AAPL | Stock | 21.655 | 21.655 | 21.655 | 21.655 | 2800.0 |
| 2012-07-09 07:06:00 | AAPL | Stock | 21.6532 | 21.6532 | 21.6532 | 21.6532 | 2800.0 |
| 2012-07-09 07:07:00 | AAPL | Stock | 21.6529 | 21.6529 | 21.6446 | 21.6446 | 8400.0 |
| 2012-07-09 07:10:00 | AAPL | Stock | 21.65 | 21.65 | 21.6464 | 21.6464 | 5880.0 |
| 2012-07-09 07:14:00 | AAPL | Stock | 21.6414 | 21.6414 | 21.6354 | 21.6354 | 14364.0 |
| 2012-07-09 07:19:00 | AAPL | Stock | 21.6386 | 21.6425 | 21.6386 | 21.6425 | 16940.0 |
| 2012-07-09 07:21:00 | AAPL | Stock | 21.6361 | 21.6361 | 21.6361 | 21.6361 | 2800.0 |
| 2012-07-09 07:22:00 | AAPL | Stock | 21.6364 | 21.6364 | 21.6364 | 21.6364 | 4200.0 |
| 2012-07-09 07:24:00 | AAPL | Stock | 21.6361 | 21.6361 | 21.6361 | 21.6361 | 3360.0 |
| 2012-07-09 07:33:00 | AAPL | Stock | 21.6429 | 21.6429 | 21.6429 | 21.6429 | 2800.0 |
| 2012-07-09 07:36:00 | AAPL | Stock | 21.6396 | 21.6396 | 21.6393 | 21.6393 | 5600.0 |
| 2012-07-09 07:37:00 | AAPL | Stock | 21.6429 | 21.6429 | 21.6429 | 21.6429 | 2800.0 |
| 2012-07-09 07:38:00 | AAPL | Stock | 21.6429 | 21.6429 | 21.6429 | 21.6429 | 2800.0 |
| 2012-07-09 07:43:00 | AAPL | Stock | 21.6518 | 21.6518 | 21.6518 | 21.6518 | 2800.0 |
| 2012-07-09 07:52:00 | AAPL | Stock | 21.6454 | 21.6454 | 21.6321 | 21.6321 | 53200.0 |
| 2012-07-09 07:53:00 | AAPL | Stock | 21.6214 | 21.6214 | 21.6214 | 21.6214 | 14000.0 |
| 2012-07-09 07:55:00 | AAPL | Stock | 21.6232 | 21.6232 | 21.6214 | 21.6214 | 13720.0 |
| 2012-07-09 07:58:00 | AAPL | Stock | 21.6389 | 21.6389 | 21.6389 | 21.6389 | 3920.0 |
| 2012-07-09 08:00:00 | AAPL | Stock | 21.6568 | 21.6571 | 21.6214 | 21.6214 | 116900.0 |
| 2012-07-09 08:01:00 | AAPL | Stock | 21.6071 | 21.6093 | 21.6071 | 21.6093 | 15120.0 |
| 2012-07-09 08:02:00 | AAPL | Stock | 21.625 | 21.625 | 21.6214 | 21.625 | 42000.0 |
| 2012-07-09 08:04:00 | AAPL | Stock | 21.6125 | 21.6125 | 21.6121 | 21.6121 | 8400.0 |
| 2012-07-09 08:05:00 | AAPL | Stock | 21.6093 | 21.6093 | 21.6 | 21.6071 | 30184.0 |
| 2012-07-09 08:06:00 | AAPL | Stock | 21.6071 | 21.6161 | 21.6071 | 21.6161 | 30520.0 |
| 2012-07-09 08:07:00 | AAPL | Stock | 21.6189 | 21.6207 | 21.6143 | 21.6143 | 29316.0 |
| 2012-07-09 08:08:00 | AAPL | Stock | 21.6196 | 21.6482 | 21.6196 | 21.6411 | 85736.0 |
| 2012-07-09 08:09:00 | AAPL | Stock | 21.6307 | 21.6518 | 21.6307 | 21.6429 | 95032.0 |
| 2012-07-09 08:10:00 | AAPL | Stock | 21.6475 | 21.6571 | 21.6071 | 21.625 | 60956.0 |
| 2012-07-09 08:11:00 | AAPL | Stock | 21.6582 | 21.6582 | 21.6582 | 21.6582 | 2800.0 |
| 2012-07-09 08:12:00 | AAPL | Stock | 21.645 | 21.645 | 21.645 | 21.645 | 8400.0 |
| 2012-07-09 08:15:00 | AAPL | Stock | 21.65 | 21.65 | 21.65 | 21.65 | 2800.0 |
| 2012-07-09 08:16:00 | AAPL | Stock | 21.655 | 21.6739 | 21.655 | 21.6739 | 28000.0 |
| 2012-07-09 08:18:00 | AAPL | Stock | 21.6704 | 21.6743 | 21.6704 | 21.6743 | 5600.0 |
| 2012-07-09 08:19:00 | AAPL | Stock | 21.6718 | 21.6746 | 21.6696 | 21.6696 | 53228.0 |
> showing 50 of 898,677 rows — these rows as CSV