PREVIEW / stock_5min / 2011-09-16
file: by_date/stock_5min/2011/2011-09-16.parquet size: 4.8 MB rows: 323,278 symbols: 3,542
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 | 22400.0 |
| 2011-09-16 04:05: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:25:00 | AAPL | Stock | 14.0479 | 14.0479 | 14.0446 | 14.0479 | 8400.0 |
| 2011-09-16 05:35:00 | AAPL | Stock | 14.0714 | 14.0732 | 14.0714 | 14.0732 | 16800.0 |
| 2011-09-16 05:50:00 | AAPL | Stock | 14.1157 | 14.1157 | 14.1057 | 14.1057 | 5600.0 |
| 2011-09-16 05:55:00 | AAPL | Stock | 14.1061 | 14.1061 | 14.1061 | 14.1061 | 2800.0 |
| 2011-09-16 06:00:00 | AAPL | Stock | 14.1161 | 14.1161 | 14.1161 | 14.1161 | 2800.0 |
| 2011-09-16 06:10:00 | AAPL | Stock | 14.1225 | 14.1429 | 14.1225 | 14.1429 | 11200.0 |
| 2011-09-16 06:15:00 | AAPL | Stock | 14.1271 | 14.1271 | 14.1271 | 14.1271 | 2800.0 |
| 2011-09-16 06:30:00 | AAPL | Stock | 14.1039 | 14.1039 | 14.1004 | 14.1004 | 5600.0 |
| 2011-09-16 07:00:00 | AAPL | Stock | 14.1143 | 14.1429 | 14.1143 | 14.125 | 75628.0 |
| 2011-09-16 07:05:00 | AAPL | Stock | 14.1143 | 14.1143 | 14.0982 | 14.1071 | 26600.0 |
| 2011-09-16 07:10:00 | AAPL | Stock | 14.1161 | 14.1179 | 14.1161 | 14.1179 | 14000.0 |
| 2011-09-16 07:15:00 | AAPL | Stock | 14.1307 | 14.1307 | 14.11 | 14.11 | 26320.0 |
| 2011-09-16 07:20:00 | AAPL | Stock | 14.1079 | 14.1161 | 14.1079 | 14.1161 | 36400.0 |
| 2011-09-16 07:25:00 | AAPL | Stock | 14.1161 | 14.1161 | 14.1114 | 14.1114 | 8400.0 |
| 2011-09-16 07:30:00 | AAPL | Stock | 14.1161 | 14.1161 | 14.1161 | 14.1161 | 7252.0 |
| 2011-09-16 07:35:00 | AAPL | Stock | 14.1161 | 14.1193 | 14.0886 | 14.0886 | 187824.0 |
| 2011-09-16 07:40:00 | AAPL | Stock | 14.0839 | 14.0975 | 14.0839 | 14.0954 | 77280.0 |
| 2011-09-16 07:45:00 | AAPL | Stock | 14.0982 | 14.1071 | 14.0964 | 14.1064 | 106456.0 |
| 2011-09-16 07:50:00 | AAPL | Stock | 14.1075 | 14.1236 | 14.1071 | 14.1104 | 79240.0 |
| 2011-09-16 07:55:00 | AAPL | Stock | 14.1071 | 14.1161 | 14.1018 | 14.1161 | 19600.0 |
| 2011-09-16 08:00:00 | AAPL | Stock | 14.1125 | 14.1414 | 14.1075 | 14.125 | 228368.0 |
| 2011-09-16 08:05:00 | AAPL | Stock | 14.1257 | 14.1257 | 14.1036 | 14.1036 | 160020.0 |
| 2011-09-16 08:10:00 | AAPL | Stock | 14.1071 | 14.1071 | 14.0929 | 14.1 | 262696.0 |
| 2011-09-16 08:15:00 | AAPL | Stock | 14.1036 | 14.1121 | 14.0943 | 14.1036 | 250992.0 |
| 2011-09-16 08:20:00 | AAPL | Stock | 14.1036 | 14.1054 | 14.0864 | 14.0982 | 361452.0 |
| 2011-09-16 08:25:00 | AAPL | Stock | 14.0896 | 14.1071 | 14.0857 | 14.0932 | 189224.0 |
| 2011-09-16 08:30:00 | AAPL | Stock | 14.1025 | 14.1054 | 14.0964 | 14.1 | 89040.0 |
| 2011-09-16 08:35:00 | AAPL | Stock | 14.1046 | 14.1232 | 14.1046 | 14.1175 | 389032.0 |
| 2011-09-16 08:40:00 | AAPL | Stock | 14.1175 | 14.125 | 14.1118 | 14.1214 | 230020.0 |
| 2011-09-16 08:45:00 | AAPL | Stock | 14.1214 | 14.1214 | 14.1071 | 14.1093 | 278096.0 |
| 2011-09-16 08:50:00 | AAPL | Stock | 14.1075 | 14.1161 | 14.1071 | 14.1161 | 251356.0 |
| 2011-09-16 08:55:00 | AAPL | Stock | 14.1161 | 14.1314 | 14.1161 | 14.1196 | 265580.0 |
| 2011-09-16 09:00:00 | AAPL | Stock | 14.1196 | 14.125 | 14.1161 | 14.1161 | 128548.0 |
| 2011-09-16 09:05:00 | AAPL | Stock | 14.1175 | 14.1261 | 14.1146 | 14.1221 | 126980.0 |
| 2011-09-16 09:10:00 | AAPL | Stock | 14.12 | 14.1314 | 14.105 | 14.1275 | 997136.0 |
| 2011-09-16 09:15:00 | AAPL | Stock | 14.1271 | 14.1386 | 14.1207 | 14.1311 | 475300.0 |
| 2011-09-16 09:20:00 | AAPL | Stock | 14.1339 | 14.1504 | 14.1329 | 14.1429 | 539168.0 |
| 2011-09-16 09:25:00 | AAPL | Stock | 14.15 | 14.1632 | 14.1264 | 14.1329 | 1517796.0 |
| 2011-09-16 09:30:00 | AAPL | Stock | 14.1325 | 14.1861 | 14.1082 | 14.1682 | 86195676.0 |
| 2011-09-16 09:35:00 | AAPL | Stock | 14.1725 | 14.1786 | 14.15 | 14.155 | 12700576.0 |
| 2011-09-16 09:40:00 | AAPL | Stock | 14.1546 | 14.1736 | 14.1411 | 14.1607 | 8723568.0 |
| 2011-09-16 09:45:00 | AAPL | Stock | 14.1607 | 14.2029 | 14.1579 | 14.2011 | 13613040.0 |
| 2011-09-16 09:50:00 | AAPL | Stock | 14.2004 | 14.2429 | 14.1989 | 14.24 | 19245940.0 |
| 2011-09-16 09:55:00 | AAPL | Stock | 14.2396 | 14.2725 | 14.2232 | 14.2582 | 19721968.0 |
| 2011-09-16 10:00:00 | AAPL | Stock | 14.2579 | 14.2664 | 14.2189 | 14.225 | 17349836.0 |
| 2011-09-16 10:05:00 | AAPL | Stock | 14.2256 | 14.2464 | 14.215 | 14.2444 | 8510740.0 |
> showing 50 of 323,278 rows — these rows as CSV