PREVIEW / stock_1min / 2013-08-06
file: by_date/stock_1min/2013/2013-08-06.parquet size: 13.8 MB rows: 1,003,993 symbols: 2,844
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-08-06 04:00:00 | AAPL | Stock | 16.7739 | 16.7768 | 16.7739 | 16.7768 | 11200.0 |
| 2013-08-06 05:33:00 | AAPL | Stock | 16.7257 | 16.7321 | 16.7257 | 16.7321 | 5600.0 |
| 2013-08-06 05:36:00 | AAPL | Stock | 16.7321 | 16.7321 | 16.7321 | 16.7321 | 2800.0 |
| 2013-08-06 06:02:00 | AAPL | Stock | 16.7679 | 16.7679 | 16.7679 | 16.7679 | 6748.0 |
| 2013-08-06 06:05:00 | AAPL | Stock | 16.7768 | 16.7768 | 16.7768 | 16.7768 | 2800.0 |
| 2013-08-06 06:12:00 | AAPL | Stock | 16.7679 | 16.7679 | 16.7679 | 16.7679 | 2800.0 |
| 2013-08-06 06:20:00 | AAPL | Stock | 16.7589 | 16.7589 | 16.7589 | 16.7589 | 12320.0 |
| 2013-08-06 06:26:00 | AAPL | Stock | 16.75 | 16.75 | 16.75 | 16.75 | 2800.0 |
| 2013-08-06 06:27:00 | AAPL | Stock | 16.75 | 16.75 | 16.75 | 16.75 | 12880.0 |
| 2013-08-06 06:28:00 | AAPL | Stock | 16.7446 | 16.7446 | 16.7446 | 16.7446 | 5600.0 |
| 2013-08-06 06:31:00 | AAPL | Stock | 16.7214 | 16.7214 | 16.7214 | 16.7214 | 4200.0 |
| 2013-08-06 06:52:00 | AAPL | Stock | 16.7196 | 16.7196 | 16.7086 | 16.7086 | 37800.0 |
| 2013-08-06 06:53:00 | AAPL | Stock | 16.7018 | 16.7018 | 16.7018 | 16.7018 | 5516.0 |
| 2013-08-06 06:54:00 | AAPL | Stock | 16.6971 | 16.6971 | 16.6964 | 16.6964 | 14000.0 |
| 2013-08-06 07:01:00 | AAPL | Stock | 16.7139 | 16.7139 | 16.7139 | 16.7139 | 2800.0 |
| 2013-08-06 07:08:00 | AAPL | Stock | 16.6964 | 16.6964 | 16.6964 | 16.6964 | 2800.0 |
| 2013-08-06 07:09:00 | AAPL | Stock | 16.7146 | 16.7146 | 16.7146 | 16.7146 | 2800.0 |
| 2013-08-06 07:14:00 | AAPL | Stock | 16.7214 | 16.7214 | 16.7214 | 16.7214 | 2800.0 |
| 2013-08-06 07:16:00 | AAPL | Stock | 16.7268 | 16.7314 | 16.7268 | 16.7268 | 11480.0 |
| 2013-08-06 07:18:00 | AAPL | Stock | 16.7407 | 16.7429 | 16.7321 | 16.7321 | 16800.0 |
| 2013-08-06 07:25:00 | AAPL | Stock | 16.7404 | 16.7404 | 16.7404 | 16.7404 | 2800.0 |
| 2013-08-06 07:31:00 | AAPL | Stock | 16.7357 | 16.7357 | 16.7357 | 16.7357 | 2800.0 |
| 2013-08-06 07:47:00 | AAPL | Stock | 16.725 | 16.725 | 16.725 | 16.725 | 2800.0 |
| 2013-08-06 07:49:00 | AAPL | Stock | 16.725 | 16.725 | 16.725 | 16.725 | 5600.0 |
| 2013-08-06 07:51:00 | AAPL | Stock | 16.725 | 16.725 | 16.7214 | 16.7214 | 5600.0 |
| 2013-08-06 07:55:00 | AAPL | Stock | 16.7143 | 16.7143 | 16.7143 | 16.7143 | 5292.0 |
| 2013-08-06 08:00:00 | AAPL | Stock | 16.705 | 16.7407 | 16.705 | 16.7154 | 76636.0 |
| 2013-08-06 08:01:00 | AAPL | Stock | 16.7143 | 16.7321 | 16.7143 | 16.7321 | 9744.0 |
| 2013-08-06 08:03:00 | AAPL | Stock | 16.7179 | 16.725 | 16.7179 | 16.725 | 8400.0 |
| 2013-08-06 08:04:00 | AAPL | Stock | 16.7193 | 16.7193 | 16.7193 | 16.7193 | 2800.0 |
| 2013-08-06 08:06:00 | AAPL | Stock | 16.725 | 16.725 | 16.725 | 16.725 | 15344.0 |
| 2013-08-06 08:07:00 | AAPL | Stock | 16.7196 | 16.7196 | 16.7143 | 16.7143 | 34300.0 |
| 2013-08-06 08:08:00 | AAPL | Stock | 16.7143 | 16.7143 | 16.7143 | 16.7143 | 5600.0 |
| 2013-08-06 08:09:00 | AAPL | Stock | 16.7071 | 16.7161 | 16.7071 | 16.7161 | 8400.0 |
| 2013-08-06 08:10:00 | AAPL | Stock | 16.7143 | 16.7143 | 16.7143 | 16.7143 | 2800.0 |
| 2013-08-06 08:11:00 | AAPL | Stock | 16.7139 | 16.7139 | 16.7139 | 16.7139 | 2800.0 |
| 2013-08-06 08:12:00 | AAPL | Stock | 16.7139 | 16.7139 | 16.7139 | 16.7139 | 14280.0 |
| 2013-08-06 08:15:00 | AAPL | Stock | 16.7214 | 16.7214 | 16.7214 | 16.7214 | 4200.0 |
| 2013-08-06 08:16:00 | AAPL | Stock | 16.7214 | 16.7282 | 16.7214 | 16.7282 | 5600.0 |
| 2013-08-06 08:17:00 | AAPL | Stock | 16.7214 | 16.7214 | 16.7214 | 16.7214 | 2800.0 |
| 2013-08-06 08:20:00 | AAPL | Stock | 16.7214 | 16.7214 | 16.7214 | 16.7214 | 3304.0 |
| 2013-08-06 08:22:00 | AAPL | Stock | 16.7179 | 16.7179 | 16.7179 | 16.7179 | 2800.0 |
| 2013-08-06 08:23:00 | AAPL | Stock | 16.7286 | 16.7286 | 16.7257 | 16.7257 | 17864.0 |
| 2013-08-06 08:24:00 | AAPL | Stock | 16.7189 | 16.7189 | 16.7182 | 16.7182 | 5600.0 |
| 2013-08-06 08:25:00 | AAPL | Stock | 16.7214 | 16.7286 | 16.7214 | 16.7257 | 31080.0 |
| 2013-08-06 08:29:00 | AAPL | Stock | 16.7286 | 16.7286 | 16.7286 | 16.7286 | 2800.0 |
| 2013-08-06 08:30:00 | AAPL | Stock | 16.725 | 16.7286 | 16.725 | 16.7286 | 8260.0 |
| 2013-08-06 08:31:00 | AAPL | Stock | 16.7286 | 16.7286 | 16.725 | 16.7286 | 37324.0 |
| 2013-08-06 08:32:00 | AAPL | Stock | 16.725 | 16.7268 | 16.725 | 16.7257 | 10500.0 |
| 2013-08-06 08:33:00 | AAPL | Stock | 16.7271 | 16.7329 | 16.7254 | 16.7329 | 16800.0 |
> showing 50 of 1,003,993 rows — these rows as CSV