PREVIEW / stock_1min / 2013-06-07
file: by_date/stock_1min/2013/2013-06-07.parquet size: 13.2 MB rows: 967,643 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 |
|---|---|---|---|---|---|---|---|
| 2013-06-07 04:22:00 | AAPL | Stock | 15.675 | 15.675 | 15.675 | 15.675 | 8400.0 |
| 2013-06-07 05:02:00 | AAPL | Stock | 15.6514 | 15.6514 | 15.6514 | 15.6514 | 12012.0 |
| 2013-06-07 05:10:00 | AAPL | Stock | 15.6429 | 15.6429 | 15.6429 | 15.6429 | 5600.0 |
| 2013-06-07 05:46:00 | AAPL | Stock | 15.6429 | 15.6429 | 15.6429 | 15.6429 | 11200.0 |
| 2013-06-07 05:57:00 | AAPL | Stock | 15.6429 | 15.6429 | 15.6429 | 15.6429 | 3080.0 |
| 2013-06-07 06:16:00 | AAPL | Stock | 15.6518 | 15.6518 | 15.6518 | 15.6518 | 9800.0 |
| 2013-06-07 07:06:00 | AAPL | Stock | 15.6607 | 15.6607 | 15.6607 | 15.6607 | 5600.0 |
| 2013-06-07 07:09:00 | AAPL | Stock | 15.6675 | 15.6718 | 15.6625 | 15.6625 | 25200.0 |
| 2013-06-07 07:10:00 | AAPL | Stock | 15.6718 | 15.6786 | 15.6718 | 15.6786 | 5600.0 |
| 2013-06-07 07:14:00 | AAPL | Stock | 15.6696 | 15.6696 | 15.6696 | 15.6696 | 2800.0 |
| 2013-06-07 07:18:00 | AAPL | Stock | 15.6607 | 15.6607 | 15.6607 | 15.6607 | 8400.0 |
| 2013-06-07 07:20:00 | AAPL | Stock | 15.6429 | 15.6429 | 15.6429 | 15.6429 | 2800.0 |
| 2013-06-07 07:22:00 | AAPL | Stock | 15.6529 | 15.6529 | 15.6529 | 15.6529 | 2800.0 |
| 2013-06-07 07:23:00 | AAPL | Stock | 15.6436 | 15.6436 | 15.6436 | 15.6436 | 2800.0 |
| 2013-06-07 07:24:00 | AAPL | Stock | 15.6429 | 15.6429 | 15.6429 | 15.6429 | 2800.0 |
| 2013-06-07 07:26:00 | AAPL | Stock | 15.6518 | 15.6518 | 15.6518 | 15.6518 | 2800.0 |
| 2013-06-07 07:28:00 | AAPL | Stock | 15.65 | 15.65 | 15.65 | 15.65 | 2800.0 |
| 2013-06-07 07:38:00 | AAPL | Stock | 15.6429 | 15.6429 | 15.6429 | 15.6429 | 9520.0 |
| 2013-06-07 07:39:00 | AAPL | Stock | 15.6361 | 15.6425 | 15.6357 | 15.6357 | 17472.0 |
| 2013-06-07 07:42:00 | AAPL | Stock | 15.6371 | 15.6371 | 15.6357 | 15.6357 | 11200.0 |
| 2013-06-07 07:47:00 | AAPL | Stock | 15.6339 | 15.6339 | 15.6339 | 15.6339 | 8204.0 |
| 2013-06-07 07:48:00 | AAPL | Stock | 15.6314 | 15.6368 | 15.6304 | 15.6343 | 42000.0 |
| 2013-06-07 07:49:00 | AAPL | Stock | 15.635 | 15.635 | 15.5914 | 15.6071 | 70924.0 |
| 2013-06-07 07:50:00 | AAPL | Stock | 15.6118 | 15.6118 | 15.6118 | 15.6118 | 2800.0 |
| 2013-06-07 07:53:00 | AAPL | Stock | 15.6071 | 15.6071 | 15.6071 | 15.6071 | 2800.0 |
| 2013-06-07 07:55:00 | AAPL | Stock | 15.6071 | 15.6082 | 15.6071 | 15.6071 | 8400.0 |
| 2013-06-07 07:56:00 | AAPL | Stock | 15.6071 | 15.6086 | 15.6071 | 15.6079 | 19600.0 |
| 2013-06-07 07:58:00 | AAPL | Stock | 15.6089 | 15.6089 | 15.6071 | 15.6071 | 14000.0 |
| 2013-06-07 08:00:00 | AAPL | Stock | 15.6239 | 15.6682 | 15.6086 | 15.6221 | 143892.0 |
| 2013-06-07 08:01:00 | AAPL | Stock | 15.6332 | 15.6332 | 15.6318 | 15.6321 | 24500.0 |
| 2013-06-07 08:02:00 | AAPL | Stock | 15.6214 | 15.6429 | 15.6107 | 15.6207 | 61880.0 |
| 2013-06-07 08:03:00 | AAPL | Stock | 15.6161 | 15.6161 | 15.6154 | 15.6161 | 14700.0 |
| 2013-06-07 08:04:00 | AAPL | Stock | 15.6214 | 15.6243 | 15.6214 | 15.6243 | 8400.0 |
| 2013-06-07 08:07:00 | AAPL | Stock | 15.6189 | 15.6246 | 15.6189 | 15.6246 | 26320.0 |
| 2013-06-07 08:09:00 | AAPL | Stock | 15.6175 | 15.6175 | 15.6089 | 15.6096 | 49700.0 |
| 2013-06-07 08:11:00 | AAPL | Stock | 15.6146 | 15.6146 | 15.6146 | 15.6146 | 8400.0 |
| 2013-06-07 08:12:00 | AAPL | Stock | 15.615 | 15.6161 | 15.6136 | 15.6136 | 10416.0 |
| 2013-06-07 08:13:00 | AAPL | Stock | 15.6161 | 15.6161 | 15.6161 | 15.6161 | 6496.0 |
| 2013-06-07 08:14:00 | AAPL | Stock | 15.6161 | 15.6318 | 15.6157 | 15.6168 | 25200.0 |
| 2013-06-07 08:15:00 | AAPL | Stock | 15.6179 | 15.6179 | 15.5893 | 15.5893 | 61488.0 |
| 2013-06-07 08:16:00 | AAPL | Stock | 15.5954 | 15.5954 | 15.5929 | 15.5929 | 14616.0 |
| 2013-06-07 08:17:00 | AAPL | Stock | 15.6054 | 15.6054 | 15.5936 | 15.5936 | 5600.0 |
| 2013-06-07 08:18:00 | AAPL | Stock | 15.605 | 15.605 | 15.605 | 15.605 | 2800.0 |
| 2013-06-07 08:19:00 | AAPL | Stock | 15.6071 | 15.6071 | 15.6071 | 15.6071 | 22708.0 |
| 2013-06-07 08:20:00 | AAPL | Stock | 15.6071 | 15.6071 | 15.5954 | 15.5954 | 31780.0 |
| 2013-06-07 08:23:00 | AAPL | Stock | 15.6079 | 15.6179 | 15.6032 | 15.6179 | 16800.0 |
| 2013-06-07 08:24:00 | AAPL | Stock | 15.605 | 15.6071 | 15.605 | 15.6064 | 8400.0 |
| 2013-06-07 08:26:00 | AAPL | Stock | 15.6057 | 15.6143 | 15.6032 | 15.6032 | 61600.0 |
| 2013-06-07 08:27:00 | AAPL | Stock | 15.6071 | 15.6171 | 15.6071 | 15.6171 | 16800.0 |
| 2013-06-07 08:28:00 | AAPL | Stock | 15.6182 | 15.6182 | 15.6143 | 15.6143 | 41748.0 |
> showing 50 of 967,643 rows — these rows as CSV