PREVIEW / stock_1min / 2014-06-04
file: by_date/stock_1min/2014/2014-06-04.parquet size: 14.1 MB rows: 1,041,519 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 |
|---|---|---|---|---|---|---|---|
| 2014-06-04 04:10:00 | AAPL | Stock | 22.8143 | 22.8143 | 22.8143 | 22.8143 | 2800.0 |
| 2014-06-04 04:45:00 | AAPL | Stock | 22.8289 | 22.8289 | 22.8286 | 22.8286 | 5600.0 |
| 2014-06-04 04:46:00 | AAPL | Stock | 22.8214 | 22.8221 | 22.8161 | 22.8221 | 11200.0 |
| 2014-06-04 04:50:00 | AAPL | Stock | 22.8243 | 22.8246 | 22.8243 | 22.8246 | 5600.0 |
| 2014-06-04 04:53:00 | AAPL | Stock | 22.8236 | 22.8236 | 22.8236 | 22.8236 | 14504.0 |
| 2014-06-04 05:03:00 | AAPL | Stock | 22.8036 | 22.8036 | 22.8036 | 22.8036 | 2800.0 |
| 2014-06-04 05:04:00 | AAPL | Stock | 22.7964 | 22.7964 | 22.7964 | 22.7964 | 2800.0 |
| 2014-06-04 05:07:00 | AAPL | Stock | 22.7861 | 22.7861 | 22.7861 | 22.7861 | 2800.0 |
| 2014-06-04 05:17:00 | AAPL | Stock | 22.7721 | 22.7721 | 22.7721 | 22.7721 | 2800.0 |
| 2014-06-04 05:25:00 | AAPL | Stock | 22.78 | 22.7854 | 22.7714 | 22.7854 | 11200.0 |
| 2014-06-04 05:33:00 | AAPL | Stock | 22.7625 | 22.7625 | 22.7625 | 22.7625 | 2800.0 |
| 2014-06-04 05:34:00 | AAPL | Stock | 22.7643 | 22.7643 | 22.7643 | 22.7643 | 2800.0 |
| 2014-06-04 06:08:00 | AAPL | Stock | 22.7643 | 22.7643 | 22.7643 | 22.7643 | 8008.0 |
| 2014-06-04 06:10:00 | AAPL | Stock | 22.7732 | 22.7732 | 22.7732 | 22.7732 | 2800.0 |
| 2014-06-04 06:32:00 | AAPL | Stock | 22.7854 | 22.7857 | 22.7854 | 22.7857 | 6440.0 |
| 2014-06-04 06:42:00 | AAPL | Stock | 22.7768 | 22.7768 | 22.7768 | 22.7768 | 2800.0 |
| 2014-06-04 06:47:00 | AAPL | Stock | 22.7739 | 22.7739 | 22.7739 | 22.7739 | 5600.0 |
| 2014-06-04 07:00:00 | AAPL | Stock | 22.8036 | 22.8036 | 22.8036 | 22.8036 | 2800.0 |
| 2014-06-04 07:01:00 | AAPL | Stock | 22.8075 | 22.8075 | 22.8036 | 22.8036 | 8400.0 |
| 2014-06-04 07:02:00 | AAPL | Stock | 22.7864 | 22.7864 | 22.7861 | 22.7861 | 11200.0 |
| 2014-06-04 07:03:00 | AAPL | Stock | 22.795 | 22.795 | 22.795 | 22.795 | 2800.0 |
| 2014-06-04 07:08:00 | AAPL | Stock | 22.7911 | 22.7911 | 22.7907 | 22.7907 | 5600.0 |
| 2014-06-04 07:09:00 | AAPL | Stock | 22.7882 | 22.7882 | 22.7857 | 22.7857 | 12320.0 |
| 2014-06-04 07:13:00 | AAPL | Stock | 22.8068 | 22.8068 | 22.8068 | 22.8068 | 2800.0 |
| 2014-06-04 07:16:00 | AAPL | Stock | 22.8125 | 22.8125 | 22.8125 | 22.8125 | 14000.0 |
| 2014-06-04 07:17:00 | AAPL | Stock | 22.8139 | 22.8196 | 22.8125 | 22.8125 | 30800.0 |
| 2014-06-04 07:18:00 | AAPL | Stock | 22.805 | 22.805 | 22.8036 | 22.8036 | 11200.0 |
| 2014-06-04 07:19:00 | AAPL | Stock | 22.7982 | 22.7982 | 22.7982 | 22.7982 | 2800.0 |
| 2014-06-04 07:20:00 | AAPL | Stock | 22.7979 | 22.7979 | 22.7979 | 22.7979 | 5600.0 |
| 2014-06-04 07:21:00 | AAPL | Stock | 22.79 | 22.79 | 22.7757 | 22.7757 | 39676.0 |
| 2014-06-04 07:22:00 | AAPL | Stock | 22.7854 | 22.7854 | 22.7854 | 22.7854 | 5600.0 |
| 2014-06-04 07:24:00 | AAPL | Stock | 22.7854 | 22.7854 | 22.7854 | 22.7854 | 2800.0 |
| 2014-06-04 07:28:00 | AAPL | Stock | 22.7846 | 22.7846 | 22.7846 | 22.7846 | 2800.0 |
| 2014-06-04 07:29:00 | AAPL | Stock | 22.7857 | 22.7857 | 22.7857 | 22.7857 | 14000.0 |
| 2014-06-04 07:30:00 | AAPL | Stock | 22.7857 | 22.7857 | 22.7857 | 22.7857 | 5600.0 |
| 2014-06-04 07:34:00 | AAPL | Stock | 22.7921 | 22.7921 | 22.7921 | 22.7921 | 2800.0 |
| 2014-06-04 07:36:00 | AAPL | Stock | 22.7875 | 22.7875 | 22.7846 | 22.7846 | 5600.0 |
| 2014-06-04 07:45:00 | AAPL | Stock | 22.7832 | 22.7832 | 22.7832 | 22.7832 | 2800.0 |
| 2014-06-04 07:47:00 | AAPL | Stock | 22.7786 | 22.7786 | 22.7696 | 22.7696 | 8400.0 |
| 2014-06-04 07:49:00 | AAPL | Stock | 22.7779 | 22.7779 | 22.7779 | 22.7779 | 2800.0 |
| 2014-06-04 07:51:00 | AAPL | Stock | 22.775 | 22.775 | 22.775 | 22.775 | 2800.0 |
| 2014-06-04 07:53:00 | AAPL | Stock | 22.7693 | 22.77 | 22.7682 | 22.77 | 14000.0 |
| 2014-06-04 07:56:00 | AAPL | Stock | 22.7546 | 22.7546 | 22.7418 | 22.7532 | 33768.0 |
| 2014-06-04 07:57:00 | AAPL | Stock | 22.7532 | 22.7532 | 22.7532 | 22.7532 | 2800.0 |
| 2014-06-04 07:58:00 | AAPL | Stock | 22.7464 | 22.7536 | 22.7464 | 22.7536 | 16800.0 |
| 2014-06-04 08:00:00 | AAPL | Stock | 22.7657 | 22.8196 | 22.7536 | 22.7839 | 113288.0 |
| 2014-06-04 08:01:00 | AAPL | Stock | 22.7586 | 22.7586 | 22.7571 | 22.7571 | 12992.0 |
| 2014-06-04 08:02:00 | AAPL | Stock | 22.7571 | 22.7571 | 22.7536 | 22.7536 | 15008.0 |
| 2014-06-04 08:03:00 | AAPL | Stock | 22.7571 | 22.7643 | 22.7571 | 22.7643 | 58800.0 |
| 2014-06-04 08:04:00 | AAPL | Stock | 22.7664 | 22.7679 | 22.7664 | 22.7679 | 56588.0 |
> showing 50 of 1,041,519 rows — these rows as CSV