PREVIEW / stock_5min / 2011-05-16
file: by_date/stock_5min/2011/2011-05-16.parquet size: 4.9 MB rows: 335,217 symbols: 3,559
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-05-16 05:45:00 | AAPL | Stock | 12.1082 | 12.1082 | 12.1082 | 12.1082 | 2800.0 |
| 2011-05-16 06:05:00 | AAPL | Stock | 12.085 | 12.085 | 12.08 | 12.0807 | 14000.0 |
| 2011-05-16 07:00:00 | AAPL | Stock | 12.0929 | 12.0929 | 12.0857 | 12.0929 | 13720.0 |
| 2011-05-16 07:05:00 | AAPL | Stock | 12.0982 | 12.1243 | 12.0982 | 12.1229 | 39200.0 |
| 2011-05-16 07:10:00 | AAPL | Stock | 12.1161 | 12.1207 | 12.1161 | 12.1207 | 28000.0 |
| 2011-05-16 07:15:00 | AAPL | Stock | 12.1179 | 12.1179 | 12.1125 | 12.1125 | 5600.0 |
| 2011-05-16 07:20:00 | AAPL | Stock | 12.1107 | 12.1211 | 12.1071 | 12.1179 | 53200.0 |
| 2011-05-16 07:25:00 | AAPL | Stock | 12.125 | 12.1307 | 12.125 | 12.125 | 42000.0 |
| 2011-05-16 07:30:00 | AAPL | Stock | 12.1164 | 12.1164 | 12.1075 | 12.1075 | 22400.0 |
| 2011-05-16 07:35:00 | AAPL | Stock | 12.1246 | 12.1268 | 12.1246 | 12.1268 | 41272.0 |
| 2011-05-16 07:40:00 | AAPL | Stock | 12.1271 | 12.1271 | 12.1271 | 12.1271 | 2800.0 |
| 2011-05-16 07:45:00 | AAPL | Stock | 12.1286 | 12.1343 | 12.125 | 12.1286 | 36400.0 |
| 2011-05-16 07:50:00 | AAPL | Stock | 12.1218 | 12.1218 | 12.1111 | 12.1111 | 8400.0 |
| 2011-05-16 07:55:00 | AAPL | Stock | 12.1221 | 12.1304 | 12.1214 | 12.1214 | 72744.0 |
| 2011-05-16 08:00:00 | AAPL | Stock | 12.125 | 12.1429 | 12.1125 | 12.1357 | 177716.0 |
| 2011-05-16 08:05:00 | AAPL | Stock | 12.125 | 12.1254 | 12.1179 | 12.1179 | 81144.0 |
| 2011-05-16 08:10:00 | AAPL | Stock | 12.1318 | 12.1429 | 12.1214 | 12.1429 | 205380.0 |
| 2011-05-16 08:15:00 | AAPL | Stock | 12.1429 | 12.15 | 12.1429 | 12.15 | 81564.0 |
| 2011-05-16 08:20:00 | AAPL | Stock | 12.1432 | 12.1525 | 12.1432 | 12.15 | 42000.0 |
| 2011-05-16 08:25:00 | AAPL | Stock | 12.1429 | 12.1429 | 12.1321 | 12.1321 | 37548.0 |
| 2011-05-16 08:30:00 | AAPL | Stock | 12.13 | 12.1407 | 12.1254 | 12.1407 | 39200.0 |
| 2011-05-16 08:35:00 | AAPL | Stock | 12.1329 | 12.1332 | 12.1286 | 12.1332 | 32816.0 |
| 2011-05-16 08:40:00 | AAPL | Stock | 12.1339 | 12.1339 | 12.1196 | 12.1196 | 129192.0 |
| 2011-05-16 08:45:00 | AAPL | Stock | 12.1182 | 12.125 | 12.1036 | 12.1071 | 228060.0 |
| 2011-05-16 08:50:00 | AAPL | Stock | 12.1071 | 12.1607 | 12.0946 | 12.0993 | 218232.0 |
| 2011-05-16 08:55:00 | AAPL | Stock | 12.0982 | 12.1054 | 12.0982 | 12.1054 | 59136.0 |
| 2011-05-16 09:00:00 | AAPL | Stock | 12.105 | 12.1143 | 12.105 | 12.1079 | 243040.0 |
| 2011-05-16 09:05:00 | AAPL | Stock | 12.1157 | 12.1339 | 12.1139 | 12.1339 | 164920.0 |
| 2011-05-16 09:10:00 | AAPL | Stock | 12.1339 | 12.1339 | 12.1179 | 12.1221 | 56336.0 |
| 2011-05-16 09:15:00 | AAPL | Stock | 12.1214 | 12.1279 | 12.1189 | 12.1243 | 127568.0 |
| 2011-05-16 09:20:00 | AAPL | Stock | 12.1232 | 12.1354 | 12.1232 | 12.1282 | 44800.0 |
| 2011-05-16 09:25:00 | AAPL | Stock | 12.1254 | 12.1254 | 12.1139 | 12.1146 | 335776.0 |
| 2011-05-16 09:30:00 | AAPL | Stock | 12.1143 | 12.1225 | 12.0625 | 12.0668 | 19408172.0 |
| 2011-05-16 09:35:00 | AAPL | Stock | 12.0679 | 12.1486 | 12.0625 | 12.1386 | 19452216.0 |
| 2011-05-16 09:40:00 | AAPL | Stock | 12.1414 | 12.1479 | 12.1257 | 12.1343 | 13527780.0 |
| 2011-05-16 09:45:00 | AAPL | Stock | 12.1337 | 12.1864 | 12.1314 | 12.1468 | 12128508.0 |
| 2011-05-16 09:50:00 | AAPL | Stock | 12.1471 | 12.1546 | 12.1314 | 12.1371 | 7250852.0 |
| 2011-05-16 09:55:00 | AAPL | Stock | 12.1375 | 12.1396 | 12.105 | 12.1229 | 6357820.0 |
| 2011-05-16 10:00:00 | AAPL | Stock | 12.1229 | 12.1475 | 12.1096 | 12.1314 | 5249860.0 |
| 2011-05-16 10:05:00 | AAPL | Stock | 12.1296 | 12.1496 | 12.1286 | 12.1389 | 5012336.0 |
| 2011-05-16 10:10:00 | AAPL | Stock | 12.1386 | 12.1489 | 12.1179 | 12.1182 | 3573808.0 |
| 2011-05-16 10:15:00 | AAPL | Stock | 12.1182 | 12.1221 | 12.0964 | 12.1011 | 5628532.0 |
| 2011-05-16 10:20:00 | AAPL | Stock | 12.1025 | 12.1096 | 12.0786 | 12.0811 | 5598264.0 |
| 2011-05-16 10:25:00 | AAPL | Stock | 12.0814 | 12.105 | 12.0811 | 12.09 | 4059776.0 |
| 2011-05-16 10:30:00 | AAPL | Stock | 12.0893 | 12.0979 | 12.0829 | 12.0854 | 2419732.0 |
| 2011-05-16 10:35:00 | AAPL | Stock | 12.0854 | 12.1018 | 12.085 | 12.0954 | 3572128.0 |
| 2011-05-16 10:40:00 | AAPL | Stock | 12.0965 | 12.1159 | 12.0875 | 12.1128 | 3113964.0 |
| 2011-05-16 10:45:00 | AAPL | Stock | 12.1158 | 12.1227 | 12.1036 | 12.1071 | 3762388.0 |
| 2011-05-16 10:50:00 | AAPL | Stock | 12.1054 | 12.1207 | 12.1054 | 12.1093 | 1923964.0 |
| 2011-05-16 10:55:00 | AAPL | Stock | 12.1075 | 12.11 | 12.0911 | 12.0996 | 2679096.0 |
> showing 50 of 335,217 rows — these rows as CSV