PREVIEW / stock_1min / 2011-07-08
file: by_date/stock_1min/2011/2011-07-08.parquet size: 12.9 MB rows: 972,313 symbols: 2,859
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 |
|---|---|---|---|---|---|---|---|
| 2011-07-08 04:02:00 | AAPL | Stock | 12.7696 | 12.7696 | 12.7696 | 12.7696 | 2800.0 |
| 2011-07-08 05:03:00 | AAPL | Stock | 12.785 | 12.785 | 12.785 | 12.785 | 2800.0 |
| 2011-07-08 05:08:00 | AAPL | Stock | 12.7868 | 12.7893 | 12.7868 | 12.7893 | 5600.0 |
| 2011-07-08 05:32:00 | AAPL | Stock | 12.7654 | 12.7654 | 12.7654 | 12.7654 | 2800.0 |
| 2011-07-08 05:54:00 | AAPL | Stock | 12.7654 | 12.7654 | 12.7654 | 12.7654 | 2800.0 |
| 2011-07-08 06:14:00 | AAPL | Stock | 12.7493 | 12.7493 | 12.7493 | 12.7493 | 2800.0 |
| 2011-07-08 06:50:00 | AAPL | Stock | 12.7829 | 12.7829 | 12.7829 | 12.7829 | 2800.0 |
| 2011-07-08 07:02:00 | AAPL | Stock | 12.7846 | 12.785 | 12.7846 | 12.7846 | 14000.0 |
| 2011-07-08 07:05:00 | AAPL | Stock | 12.7896 | 12.8068 | 12.7879 | 12.8068 | 28000.0 |
| 2011-07-08 07:07:00 | AAPL | Stock | 12.8032 | 12.8036 | 12.8032 | 12.8036 | 8400.0 |
| 2011-07-08 07:12:00 | AAPL | Stock | 12.7857 | 12.7857 | 12.7857 | 12.7857 | 5600.0 |
| 2011-07-08 07:14:00 | AAPL | Stock | 12.7857 | 12.8032 | 12.7857 | 12.8032 | 11200.0 |
| 2011-07-08 07:17:00 | AAPL | Stock | 12.7946 | 12.7946 | 12.7925 | 12.7925 | 22904.0 |
| 2011-07-08 07:18:00 | AAPL | Stock | 12.7893 | 12.7925 | 12.7893 | 12.7925 | 5600.0 |
| 2011-07-08 07:20:00 | AAPL | Stock | 12.7893 | 12.7893 | 12.7893 | 12.7893 | 2800.0 |
| 2011-07-08 07:23:00 | AAPL | Stock | 12.7893 | 12.7893 | 12.7893 | 12.7893 | 11200.0 |
| 2011-07-08 07:30:00 | AAPL | Stock | 12.7754 | 12.7768 | 12.775 | 12.7768 | 35000.0 |
| 2011-07-08 07:35:00 | AAPL | Stock | 12.775 | 12.775 | 12.775 | 12.775 | 7140.0 |
| 2011-07-08 07:38:00 | AAPL | Stock | 12.7857 | 12.7857 | 12.7857 | 12.7857 | 2800.0 |
| 2011-07-08 07:42:00 | AAPL | Stock | 12.7879 | 12.7879 | 12.7879 | 12.7879 | 2800.0 |
| 2011-07-08 07:43:00 | AAPL | Stock | 12.7886 | 12.7904 | 12.7886 | 12.7904 | 12600.0 |
| 2011-07-08 07:46:00 | AAPL | Stock | 12.8 | 12.8 | 12.8 | 12.8 | 2800.0 |
| 2011-07-08 07:51:00 | AAPL | Stock | 12.8036 | 12.8036 | 12.8036 | 12.8036 | 11200.0 |
| 2011-07-08 07:52:00 | AAPL | Stock | 12.8 | 12.8 | 12.8 | 12.8 | 14000.0 |
| 2011-07-08 07:53:00 | AAPL | Stock | 12.8107 | 12.8107 | 12.8107 | 12.8107 | 2800.0 |
| 2011-07-08 07:54:00 | AAPL | Stock | 12.8107 | 12.8107 | 12.8107 | 12.8107 | 11200.0 |
| 2011-07-08 07:55:00 | AAPL | Stock | 12.8057 | 12.8057 | 12.8057 | 12.8057 | 2800.0 |
| 2011-07-08 07:56:00 | AAPL | Stock | 12.8036 | 12.8036 | 12.7904 | 12.7904 | 56000.0 |
| 2011-07-08 07:58:00 | AAPL | Stock | 12.8036 | 12.8036 | 12.7986 | 12.7986 | 8400.0 |
| 2011-07-08 08:00:00 | AAPL | Stock | 12.7914 | 12.8021 | 12.7893 | 12.7964 | 27356.0 |
| 2011-07-08 08:01:00 | AAPL | Stock | 12.8032 | 12.8032 | 12.7964 | 12.7964 | 35504.0 |
| 2011-07-08 08:02:00 | AAPL | Stock | 12.8029 | 12.8036 | 12.8029 | 12.8036 | 19600.0 |
| 2011-07-08 08:03:00 | AAPL | Stock | 12.8036 | 12.8046 | 12.8036 | 12.8046 | 5600.0 |
| 2011-07-08 08:04:00 | AAPL | Stock | 12.8054 | 12.8054 | 12.8 | 12.8 | 16520.0 |
| 2011-07-08 08:05:00 | AAPL | Stock | 12.8068 | 12.8068 | 12.7964 | 12.7964 | 68628.0 |
| 2011-07-08 08:06:00 | AAPL | Stock | 12.8014 | 12.8036 | 12.8014 | 12.8036 | 30800.0 |
| 2011-07-08 08:07:00 | AAPL | Stock | 12.8036 | 12.8079 | 12.8036 | 12.8054 | 55720.0 |
| 2011-07-08 08:08:00 | AAPL | Stock | 12.8079 | 12.8107 | 12.8079 | 12.8107 | 43232.0 |
| 2011-07-08 08:09:00 | AAPL | Stock | 12.8125 | 12.8125 | 12.8107 | 12.8107 | 16800.0 |
| 2011-07-08 08:10:00 | AAPL | Stock | 12.8143 | 12.8179 | 12.8143 | 12.8179 | 35280.0 |
| 2011-07-08 08:11:00 | AAPL | Stock | 12.8143 | 12.8214 | 12.8143 | 12.8143 | 48580.0 |
| 2011-07-08 08:12:00 | AAPL | Stock | 12.8143 | 12.815 | 12.8143 | 12.8143 | 65520.0 |
| 2011-07-08 08:13:00 | AAPL | Stock | 12.8143 | 12.8161 | 12.8139 | 12.8143 | 43400.0 |
| 2011-07-08 08:14:00 | AAPL | Stock | 12.8146 | 12.8146 | 12.8146 | 12.8146 | 28000.0 |
| 2011-07-08 08:15:00 | AAPL | Stock | 12.8143 | 12.8143 | 12.8143 | 12.8143 | 28000.0 |
| 2011-07-08 08:16:00 | AAPL | Stock | 12.8129 | 12.8204 | 12.8129 | 12.8204 | 32900.0 |
| 2011-07-08 08:18:00 | AAPL | Stock | 12.8154 | 12.8154 | 12.8143 | 12.8143 | 13104.0 |
| 2011-07-08 08:19:00 | AAPL | Stock | 12.82 | 12.82 | 12.82 | 12.82 | 5600.0 |
| 2011-07-08 08:20:00 | AAPL | Stock | 12.8143 | 12.82 | 12.8143 | 12.8143 | 31500.0 |
| 2011-07-08 08:21:00 | AAPL | Stock | 12.8107 | 12.8143 | 12.8107 | 12.8107 | 27300.0 |
> showing 50 of 972,313 rows — these rows as CSV