PREVIEW / stock_1min / 2011-09-16
file: by_date/stock_1min/2011/2011-09-16.parquet size: 13.0 MB rows: 975,793 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 |
|---|---|---|---|---|---|---|---|
| 2011-09-16 04:00:00 | AAPL | Stock | 14.0604 | 14.0604 | 14.0318 | 14.0318 | 19600.0 |
| 2011-09-16 04:01:00 | AAPL | Stock | 14.0318 | 14.0318 | 14.0318 | 14.0318 | 2800.0 |
| 2011-09-16 04:07:00 | AAPL | Stock | 14.0129 | 14.0129 | 14.0129 | 14.0129 | 14000.0 |
| 2011-09-16 04:45:00 | AAPL | Stock | 14.0311 | 14.0311 | 14.0311 | 14.0311 | 2800.0 |
| 2011-09-16 04:50:00 | AAPL | Stock | 14.035 | 14.035 | 14.035 | 14.035 | 2800.0 |
| 2011-09-16 05:27:00 | AAPL | Stock | 14.0479 | 14.0479 | 14.0479 | 14.0479 | 2800.0 |
| 2011-09-16 05:28:00 | AAPL | Stock | 14.0446 | 14.0479 | 14.0446 | 14.0479 | 5600.0 |
| 2011-09-16 05:37:00 | AAPL | Stock | 14.0714 | 14.0714 | 14.0714 | 14.0714 | 14000.0 |
| 2011-09-16 05:39:00 | AAPL | Stock | 14.0732 | 14.0732 | 14.0732 | 14.0732 | 2800.0 |
| 2011-09-16 05:52:00 | AAPL | Stock | 14.1157 | 14.1157 | 14.1157 | 14.1157 | 2800.0 |
| 2011-09-16 05:53:00 | AAPL | Stock | 14.1057 | 14.1057 | 14.1057 | 14.1057 | 2800.0 |
| 2011-09-16 05:57:00 | AAPL | Stock | 14.1061 | 14.1061 | 14.1061 | 14.1061 | 2800.0 |
| 2011-09-16 06:03:00 | AAPL | Stock | 14.1161 | 14.1161 | 14.1161 | 14.1161 | 2800.0 |
| 2011-09-16 06:11:00 | AAPL | Stock | 14.1225 | 14.1429 | 14.1225 | 14.1429 | 8400.0 |
| 2011-09-16 06:12:00 | AAPL | Stock | 14.1429 | 14.1429 | 14.1429 | 14.1429 | 2800.0 |
| 2011-09-16 06:16:00 | AAPL | Stock | 14.1271 | 14.1271 | 14.1271 | 14.1271 | 2800.0 |
| 2011-09-16 06:32:00 | AAPL | Stock | 14.1039 | 14.1039 | 14.1039 | 14.1039 | 2800.0 |
| 2011-09-16 06:33:00 | AAPL | Stock | 14.1004 | 14.1004 | 14.1004 | 14.1004 | 2800.0 |
| 2011-09-16 07:00:00 | AAPL | Stock | 14.1143 | 14.1379 | 14.1143 | 14.1254 | 30800.0 |
| 2011-09-16 07:01:00 | AAPL | Stock | 14.1282 | 14.1429 | 14.1282 | 14.1329 | 14000.0 |
| 2011-09-16 07:02:00 | AAPL | Stock | 14.1329 | 14.1329 | 14.125 | 14.1329 | 11228.0 |
| 2011-09-16 07:03:00 | AAPL | Stock | 14.1329 | 14.1329 | 14.125 | 14.125 | 16800.0 |
| 2011-09-16 07:04:00 | AAPL | Stock | 14.125 | 14.125 | 14.125 | 14.125 | 2800.0 |
| 2011-09-16 07:06:00 | AAPL | Stock | 14.1143 | 14.1143 | 14.1029 | 14.1029 | 15400.0 |
| 2011-09-16 07:08:00 | AAPL | Stock | 14.0982 | 14.0982 | 14.0982 | 14.0982 | 2800.0 |
| 2011-09-16 07:09:00 | AAPL | Stock | 14.1086 | 14.1086 | 14.1071 | 14.1071 | 8400.0 |
| 2011-09-16 07:13:00 | AAPL | Stock | 14.1161 | 14.1161 | 14.1161 | 14.1161 | 5600.0 |
| 2011-09-16 07:14:00 | AAPL | Stock | 14.1179 | 14.1179 | 14.1179 | 14.1179 | 8400.0 |
| 2011-09-16 07:17:00 | AAPL | Stock | 14.1307 | 14.1307 | 14.1179 | 14.1179 | 17920.0 |
| 2011-09-16 07:18:00 | AAPL | Stock | 14.1107 | 14.1107 | 14.1107 | 14.1107 | 2800.0 |
| 2011-09-16 07:19:00 | AAPL | Stock | 14.11 | 14.11 | 14.11 | 14.11 | 5600.0 |
| 2011-09-16 07:20:00 | AAPL | Stock | 14.1079 | 14.1096 | 14.1079 | 14.1096 | 22400.0 |
| 2011-09-16 07:21:00 | AAPL | Stock | 14.1125 | 14.1125 | 14.1125 | 14.1125 | 2800.0 |
| 2011-09-16 07:23:00 | AAPL | Stock | 14.1161 | 14.1161 | 14.1146 | 14.115 | 8400.0 |
| 2011-09-16 07:24:00 | AAPL | Stock | 14.1161 | 14.1161 | 14.1161 | 14.1161 | 2800.0 |
| 2011-09-16 07:27:00 | AAPL | Stock | 14.1161 | 14.1161 | 14.1161 | 14.1161 | 5600.0 |
| 2011-09-16 07:28:00 | AAPL | Stock | 14.1114 | 14.1114 | 14.1114 | 14.1114 | 2800.0 |
| 2011-09-16 07:33:00 | AAPL | Stock | 14.1161 | 14.1161 | 14.1161 | 14.1161 | 7252.0 |
| 2011-09-16 07:35:00 | AAPL | Stock | 14.1161 | 14.1161 | 14.1161 | 14.1161 | 5600.0 |
| 2011-09-16 07:36:00 | AAPL | Stock | 14.1193 | 14.1193 | 14.1029 | 14.1029 | 48664.0 |
| 2011-09-16 07:37:00 | AAPL | Stock | 14.1096 | 14.1096 | 14.1036 | 14.1071 | 8400.0 |
| 2011-09-16 07:38:00 | AAPL | Stock | 14.1 | 14.1 | 14.0964 | 14.0989 | 75600.0 |
| 2011-09-16 07:39:00 | AAPL | Stock | 14.0925 | 14.0979 | 14.0886 | 14.0886 | 49560.0 |
| 2011-09-16 07:40:00 | AAPL | Stock | 14.0839 | 14.0975 | 14.0839 | 14.0975 | 60480.0 |
| 2011-09-16 07:41:00 | AAPL | Stock | 14.0929 | 14.0929 | 14.0929 | 14.0929 | 5600.0 |
| 2011-09-16 07:43:00 | AAPL | Stock | 14.0929 | 14.0929 | 14.0929 | 14.0929 | 5600.0 |
| 2011-09-16 07:44:00 | AAPL | Stock | 14.0957 | 14.0957 | 14.0954 | 14.0954 | 5600.0 |
| 2011-09-16 07:45:00 | AAPL | Stock | 14.0982 | 14.0982 | 14.0982 | 14.0982 | 2800.0 |
| 2011-09-16 07:46:00 | AAPL | Stock | 14.1018 | 14.1018 | 14.1018 | 14.1018 | 2800.0 |
| 2011-09-16 07:47:00 | AAPL | Stock | 14.1018 | 14.1018 | 14.0964 | 14.0986 | 11200.0 |
> showing 50 of 975,793 rows — these rows as CSV