PREVIEW / stock_1min / 2014-02-26
file: by_date/stock_1min/2014/2014-02-26.parquet size: 14.8 MB rows: 1,071,084 symbols: 2,865
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 |
|---|---|---|---|---|---|---|---|
| 2014-02-26 04:00:00 | AAPL | Stock | 18.6429 | 18.6429 | 18.6429 | 18.6429 | 2800.0 |
| 2014-02-26 04:11:00 | AAPL | Stock | 18.6079 | 18.6079 | 18.6079 | 18.6079 | 2800.0 |
| 2014-02-26 04:12:00 | AAPL | Stock | 18.5768 | 18.5768 | 18.575 | 18.575 | 5600.0 |
| 2014-02-26 04:15:00 | AAPL | Stock | 18.5532 | 18.5532 | 18.5532 | 18.5532 | 2800.0 |
| 2014-02-26 04:26:00 | AAPL | Stock | 18.5714 | 18.5714 | 18.5714 | 18.5714 | 2800.0 |
| 2014-02-26 04:30:00 | AAPL | Stock | 18.5714 | 18.5714 | 18.5714 | 18.5714 | 2800.0 |
| 2014-02-26 04:31:00 | AAPL | Stock | 18.5611 | 18.5611 | 18.5611 | 18.5611 | 2800.0 |
| 2014-02-26 04:33:00 | AAPL | Stock | 18.555 | 18.555 | 18.555 | 18.555 | 2800.0 |
| 2014-02-26 04:37:00 | AAPL | Stock | 18.5636 | 18.5636 | 18.5629 | 18.5629 | 5600.0 |
| 2014-02-26 04:39:00 | AAPL | Stock | 18.555 | 18.555 | 18.555 | 18.555 | 8400.0 |
| 2014-02-26 04:42:00 | AAPL | Stock | 18.5532 | 18.5532 | 18.5418 | 18.5418 | 14000.0 |
| 2014-02-26 04:43:00 | AAPL | Stock | 18.5418 | 18.5418 | 18.5418 | 18.5418 | 11200.0 |
| 2014-02-26 04:54:00 | AAPL | Stock | 18.5346 | 18.5346 | 18.5346 | 18.5346 | 2800.0 |
| 2014-02-26 04:59:00 | AAPL | Stock | 18.5214 | 18.525 | 18.5214 | 18.525 | 58464.0 |
| 2014-02-26 05:14:00 | AAPL | Stock | 18.5357 | 18.5357 | 18.5357 | 18.5357 | 2800.0 |
| 2014-02-26 05:33:00 | AAPL | Stock | 18.5429 | 18.5429 | 18.5429 | 18.5429 | 2800.0 |
| 2014-02-26 05:42:00 | AAPL | Stock | 18.5857 | 18.5857 | 18.5857 | 18.5857 | 5600.0 |
| 2014-02-26 05:50:00 | AAPL | Stock | 18.5868 | 18.5868 | 18.5821 | 18.5821 | 28000.0 |
| 2014-02-26 06:08:00 | AAPL | Stock | 18.5714 | 18.5714 | 18.5671 | 18.5671 | 11200.0 |
| 2014-02-26 06:30:00 | AAPL | Stock | 18.5768 | 18.5768 | 18.5768 | 18.5768 | 2800.0 |
| 2014-02-26 06:53:00 | AAPL | Stock | 18.5996 | 18.6071 | 18.5996 | 18.6071 | 30380.0 |
| 2014-02-26 06:58:00 | AAPL | Stock | 18.6071 | 18.6071 | 18.6071 | 18.6071 | 3864.0 |
| 2014-02-26 07:01:00 | AAPL | Stock | 18.6071 | 18.6143 | 18.6071 | 18.6143 | 14000.0 |
| 2014-02-26 07:02:00 | AAPL | Stock | 18.6079 | 18.6079 | 18.6071 | 18.6071 | 8736.0 |
| 2014-02-26 07:10:00 | AAPL | Stock | 18.6161 | 18.6221 | 18.6161 | 18.6221 | 5600.0 |
| 2014-02-26 07:16:00 | AAPL | Stock | 18.6221 | 18.6279 | 18.6221 | 18.6279 | 8400.0 |
| 2014-02-26 07:23:00 | AAPL | Stock | 18.6407 | 18.6429 | 18.6407 | 18.6429 | 63224.0 |
| 2014-02-26 07:24:00 | AAPL | Stock | 18.6429 | 18.6429 | 18.6429 | 18.6429 | 37884.0 |
| 2014-02-26 07:29:00 | AAPL | Stock | 18.6429 | 18.6429 | 18.6379 | 18.6379 | 8400.0 |
| 2014-02-26 07:33:00 | AAPL | Stock | 18.6171 | 18.6171 | 18.6164 | 18.6164 | 28700.0 |
| 2014-02-26 07:39:00 | AAPL | Stock | 18.6232 | 18.6236 | 18.6232 | 18.6236 | 9100.0 |
| 2014-02-26 07:42:00 | AAPL | Stock | 18.6332 | 18.6332 | 18.6332 | 18.6332 | 2800.0 |
| 2014-02-26 07:43:00 | AAPL | Stock | 18.6339 | 18.6339 | 18.6339 | 18.6339 | 2800.0 |
| 2014-02-26 07:45:00 | AAPL | Stock | 18.625 | 18.625 | 18.625 | 18.625 | 4200.0 |
| 2014-02-26 07:46:00 | AAPL | Stock | 18.6275 | 18.6275 | 18.6275 | 18.6275 | 4200.0 |
| 2014-02-26 07:52:00 | AAPL | Stock | 18.6332 | 18.6489 | 18.6332 | 18.6489 | 75600.0 |
| 2014-02-26 07:54:00 | AAPL | Stock | 18.6607 | 18.6607 | 18.6607 | 18.6607 | 36400.0 |
| 2014-02-26 07:56:00 | AAPL | Stock | 18.6607 | 18.6607 | 18.6607 | 18.6607 | 2800.0 |
| 2014-02-26 07:58:00 | AAPL | Stock | 18.6539 | 18.6539 | 18.6471 | 18.6471 | 11200.0 |
| 2014-02-26 07:59:00 | AAPL | Stock | 18.66 | 18.66 | 18.66 | 18.66 | 2800.0 |
| 2014-02-26 08:00:00 | AAPL | Stock | 18.62 | 18.6614 | 18.62 | 18.6614 | 14000.0 |
| 2014-02-26 08:01:00 | AAPL | Stock | 18.6607 | 18.6607 | 18.6607 | 18.6607 | 8400.0 |
| 2014-02-26 08:02:00 | AAPL | Stock | 18.6729 | 18.6729 | 18.6721 | 18.6721 | 8400.0 |
| 2014-02-26 08:08:00 | AAPL | Stock | 18.6607 | 18.6746 | 18.6607 | 18.6746 | 19600.0 |
| 2014-02-26 08:09:00 | AAPL | Stock | 18.6711 | 18.6786 | 18.6711 | 18.6786 | 75628.0 |
| 2014-02-26 08:10:00 | AAPL | Stock | 18.6786 | 18.6961 | 18.6786 | 18.6946 | 27188.0 |
| 2014-02-26 08:12:00 | AAPL | Stock | 18.6896 | 18.6896 | 18.6786 | 18.6786 | 55300.0 |
| 2014-02-26 08:13:00 | AAPL | Stock | 18.6961 | 18.6961 | 18.6857 | 18.6857 | 5600.0 |
| 2014-02-26 08:14:00 | AAPL | Stock | 18.6811 | 18.6811 | 18.6811 | 18.6811 | 5600.0 |
| 2014-02-26 08:15:00 | AAPL | Stock | 18.6907 | 18.6986 | 18.69 | 18.6986 | 53480.0 |
> showing 50 of 1,071,084 rows — these rows as CSV