PREVIEW / stock_1min / 2014-01-06
file: by_date/stock_1min/2014/2014-01-06.parquet size: 14.8 MB rows: 1,070,911 symbols: 2,860
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-01-06 04:09:00 | AAPL | Stock | 19.3504 | 19.3504 | 19.3504 | 19.3504 | 2800.0 |
| 2014-01-06 04:10:00 | AAPL | Stock | 19.3443 | 19.3443 | 19.3439 | 19.3439 | 5600.0 |
| 2014-01-06 04:11:00 | AAPL | Stock | 19.3418 | 19.3418 | 19.3418 | 19.3418 | 5600.0 |
| 2014-01-06 04:12:00 | AAPL | Stock | 19.32 | 19.32 | 19.32 | 19.32 | 2800.0 |
| 2014-01-06 04:22:00 | AAPL | Stock | 19.32 | 19.32 | 19.32 | 19.32 | 3668.0 |
| 2014-01-06 04:28:00 | AAPL | Stock | 19.3175 | 19.3175 | 19.3175 | 19.3175 | 8400.0 |
| 2014-01-06 04:35:00 | AAPL | Stock | 19.3186 | 19.3186 | 19.3161 | 19.3186 | 8400.0 |
| 2014-01-06 04:37:00 | AAPL | Stock | 19.32 | 19.32 | 19.32 | 19.32 | 8400.0 |
| 2014-01-06 04:46:00 | AAPL | Stock | 19.3161 | 19.3161 | 19.3161 | 19.3161 | 2800.0 |
| 2014-01-06 04:51:00 | AAPL | Stock | 19.3171 | 19.3171 | 19.3171 | 19.3171 | 2800.0 |
| 2014-01-06 04:57:00 | AAPL | Stock | 19.3171 | 19.3171 | 19.3171 | 19.3171 | 2800.0 |
| 2014-01-06 05:01:00 | AAPL | Stock | 19.3182 | 19.3182 | 19.3179 | 19.3179 | 5600.0 |
| 2014-01-06 05:03:00 | AAPL | Stock | 19.3214 | 19.3214 | 19.3214 | 19.3214 | 11676.0 |
| 2014-01-06 05:24:00 | AAPL | Stock | 19.3214 | 19.3214 | 19.3214 | 19.3214 | 2800.0 |
| 2014-01-06 05:33:00 | AAPL | Stock | 19.3125 | 19.3125 | 19.3125 | 19.3125 | 2800.0 |
| 2014-01-06 05:38:00 | AAPL | Stock | 19.3036 | 19.3036 | 19.3036 | 19.3036 | 2800.0 |
| 2014-01-06 05:52:00 | AAPL | Stock | 19.3214 | 19.3214 | 19.3214 | 19.3214 | 2828.0 |
| 2014-01-06 05:55:00 | AAPL | Stock | 19.3161 | 19.3161 | 19.3161 | 19.3161 | 2800.0 |
| 2014-01-06 05:58:00 | AAPL | Stock | 19.3032 | 19.3032 | 19.3 | 19.3 | 11564.0 |
| 2014-01-06 05:59:00 | AAPL | Stock | 19.2932 | 19.2932 | 19.2679 | 19.2679 | 35000.0 |
| 2014-01-06 06:00:00 | AAPL | Stock | 19.2511 | 19.2611 | 19.2511 | 19.2611 | 7000.0 |
| 2014-01-06 06:01:00 | AAPL | Stock | 19.2321 | 19.2321 | 19.2161 | 19.2161 | 14000.0 |
| 2014-01-06 06:02:00 | AAPL | Stock | 19.2143 | 19.2161 | 19.2143 | 19.2161 | 12992.0 |
| 2014-01-06 06:03:00 | AAPL | Stock | 19.1996 | 19.1996 | 19.1964 | 19.1964 | 8400.0 |
| 2014-01-06 06:04:00 | AAPL | Stock | 19.1804 | 19.1804 | 19.1607 | 19.1607 | 14000.0 |
| 2014-01-06 06:05:00 | AAPL | Stock | 19.16 | 19.16 | 19.1554 | 19.1554 | 11200.0 |
| 2014-01-06 06:06:00 | AAPL | Stock | 19.1536 | 19.1536 | 19.13 | 19.13 | 10780.0 |
| 2014-01-06 06:07:00 | AAPL | Stock | 19.125 | 19.1336 | 19.125 | 19.1336 | 11200.0 |
| 2014-01-06 06:08:00 | AAPL | Stock | 19.1114 | 19.1114 | 19.1114 | 19.1114 | 2800.0 |
| 2014-01-06 06:09:00 | AAPL | Stock | 19.1161 | 19.1161 | 19.1089 | 19.1161 | 16520.0 |
| 2014-01-06 06:10:00 | AAPL | Stock | 19.1089 | 19.1089 | 19.1079 | 19.1079 | 18200.0 |
| 2014-01-06 06:11:00 | AAPL | Stock | 19.0929 | 19.0982 | 19.0929 | 19.0929 | 22400.0 |
| 2014-01-06 06:12:00 | AAPL | Stock | 19.0929 | 19.0929 | 19.0929 | 19.0929 | 14000.0 |
| 2014-01-06 06:13:00 | AAPL | Stock | 19.0804 | 19.0804 | 19.0754 | 19.0804 | 8400.0 |
| 2014-01-06 06:14:00 | AAPL | Stock | 19.0804 | 19.0893 | 19.0804 | 19.0893 | 13440.0 |
| 2014-01-06 06:15:00 | AAPL | Stock | 19.0732 | 19.0732 | 19.0714 | 19.0714 | 5600.0 |
| 2014-01-06 06:18:00 | AAPL | Stock | 19.0536 | 19.0607 | 19.0536 | 19.0607 | 19264.0 |
| 2014-01-06 06:19:00 | AAPL | Stock | 19.0643 | 19.0821 | 19.0643 | 19.0821 | 95312.0 |
| 2014-01-06 06:20:00 | AAPL | Stock | 19.0821 | 19.0982 | 19.0821 | 19.0982 | 18480.0 |
| 2014-01-06 06:21:00 | AAPL | Stock | 19.0982 | 19.1071 | 19.0982 | 19.1071 | 8764.0 |
| 2014-01-06 06:22:00 | AAPL | Stock | 19.125 | 19.125 | 19.1243 | 19.1243 | 5600.0 |
| 2014-01-06 06:23:00 | AAPL | Stock | 19.125 | 19.1429 | 19.1246 | 19.1429 | 49252.0 |
| 2014-01-06 06:24:00 | AAPL | Stock | 19.1429 | 19.1429 | 19.1329 | 19.1329 | 24948.0 |
| 2014-01-06 06:32:00 | AAPL | Stock | 19.1361 | 19.1361 | 19.1361 | 19.1361 | 6244.0 |
| 2014-01-06 06:36:00 | AAPL | Stock | 19.1179 | 19.1179 | 19.1036 | 19.1036 | 36456.0 |
| 2014-01-06 06:40:00 | AAPL | Stock | 19.1014 | 19.1032 | 19.1014 | 19.1032 | 5600.0 |
| 2014-01-06 06:43:00 | AAPL | Stock | 19.1071 | 19.1071 | 19.1071 | 19.1071 | 8400.0 |
| 2014-01-06 06:44:00 | AAPL | Stock | 19.1071 | 19.1071 | 19.1071 | 19.1071 | 2800.0 |
| 2014-01-06 06:46:00 | AAPL | Stock | 19.1036 | 19.1036 | 19.1036 | 19.1036 | 3080.0 |
| 2014-01-06 06:47:00 | AAPL | Stock | 19.0975 | 19.1075 | 19.0971 | 19.1071 | 19600.0 |
> showing 50 of 1,070,911 rows — these rows as CSV