PREVIEW / stock_1min / 2012-05-14
file: by_date/stock_1min/2012/2012-05-14.parquet size: 12.9 MB rows: 969,229 symbols: 2,878
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 |
|---|---|---|---|---|---|---|---|
| 2012-05-14 04:09:00 | AAPL | Stock | 20.1071 | 20.1071 | 20.1071 | 20.1071 | 2800.0 |
| 2012-05-14 04:21:00 | AAPL | Stock | 20.1021 | 20.1021 | 20.1021 | 20.1021 | 2800.0 |
| 2012-05-14 04:24:00 | AAPL | Stock | 20.0893 | 20.0893 | 20.0893 | 20.0893 | 14000.0 |
| 2012-05-14 04:36:00 | AAPL | Stock | 20.1071 | 20.1071 | 20.1071 | 20.1071 | 2800.0 |
| 2012-05-14 06:03:00 | AAPL | Stock | 20.1346 | 20.1346 | 20.1346 | 20.1346 | 8400.0 |
| 2012-05-14 06:19:00 | AAPL | Stock | 20.1196 | 20.1196 | 20.1196 | 20.1196 | 2800.0 |
| 2012-05-14 06:26:00 | AAPL | Stock | 20.1425 | 20.1425 | 20.1425 | 20.1425 | 2800.0 |
| 2012-05-14 06:47:00 | AAPL | Stock | 20.1732 | 20.1732 | 20.1732 | 20.1732 | 2800.0 |
| 2012-05-14 06:55:00 | AAPL | Stock | 20.1607 | 20.1607 | 20.1607 | 20.1607 | 2800.0 |
| 2012-05-14 07:01:00 | AAPL | Stock | 20.1261 | 20.1261 | 20.0989 | 20.0996 | 14000.0 |
| 2012-05-14 07:05:00 | AAPL | Stock | 20.1086 | 20.1086 | 20.1086 | 20.1086 | 2800.0 |
| 2012-05-14 07:07:00 | AAPL | Stock | 20.1093 | 20.1111 | 20.1093 | 20.1093 | 8400.0 |
| 2012-05-14 07:08:00 | AAPL | Stock | 20.1125 | 20.1125 | 20.1093 | 20.1093 | 5600.0 |
| 2012-05-14 07:10:00 | AAPL | Stock | 20.1375 | 20.1418 | 20.1375 | 20.1418 | 8400.0 |
| 2012-05-14 07:11:00 | AAPL | Stock | 20.1518 | 20.1518 | 20.1518 | 20.1518 | 2800.0 |
| 2012-05-14 07:12:00 | AAPL | Stock | 20.1393 | 20.1393 | 20.1129 | 20.1129 | 8400.0 |
| 2012-05-14 07:14:00 | AAPL | Stock | 20.155 | 20.1607 | 20.1532 | 20.1607 | 14000.0 |
| 2012-05-14 07:16:00 | AAPL | Stock | 20.1189 | 20.1189 | 20.1189 | 20.1189 | 2800.0 |
| 2012-05-14 07:21:00 | AAPL | Stock | 20.1411 | 20.1429 | 20.1411 | 20.1429 | 16044.0 |
| 2012-05-14 07:24:00 | AAPL | Stock | 20.1554 | 20.1554 | 20.1554 | 20.1554 | 2800.0 |
| 2012-05-14 07:26:00 | AAPL | Stock | 20.1436 | 20.1446 | 20.1429 | 20.1446 | 11200.0 |
| 2012-05-14 07:29:00 | AAPL | Stock | 20.1496 | 20.1525 | 20.1496 | 20.1496 | 11200.0 |
| 2012-05-14 07:31:00 | AAPL | Stock | 20.1589 | 20.1604 | 20.1532 | 20.1593 | 14000.0 |
| 2012-05-14 07:38:00 | AAPL | Stock | 20.1636 | 20.1636 | 20.1636 | 20.1636 | 2800.0 |
| 2012-05-14 07:40:00 | AAPL | Stock | 20.1639 | 20.1639 | 20.1639 | 20.1639 | 2800.0 |
| 2012-05-14 07:41:00 | AAPL | Stock | 20.1782 | 20.1875 | 20.1782 | 20.1875 | 11200.0 |
| 2012-05-14 07:42:00 | AAPL | Stock | 20.1786 | 20.1786 | 20.1782 | 20.1782 | 25200.0 |
| 2012-05-14 07:45:00 | AAPL | Stock | 20.1607 | 20.1607 | 20.1607 | 20.1607 | 10108.0 |
| 2012-05-14 07:46:00 | AAPL | Stock | 20.1746 | 20.1779 | 20.1746 | 20.1779 | 8400.0 |
| 2012-05-14 07:47:00 | AAPL | Stock | 20.1611 | 20.1611 | 20.1611 | 20.1611 | 2800.0 |
| 2012-05-14 07:59:00 | AAPL | Stock | 20.1571 | 20.1571 | 20.1571 | 20.1571 | 5600.0 |
| 2012-05-14 08:00:00 | AAPL | Stock | 20.1768 | 20.1779 | 20.1268 | 20.1268 | 142128.0 |
| 2012-05-14 08:02:00 | AAPL | Stock | 20.1232 | 20.1232 | 20.1221 | 20.1221 | 8400.0 |
| 2012-05-14 08:05:00 | AAPL | Stock | 20.1225 | 20.1225 | 20.1225 | 20.1225 | 9632.0 |
| 2012-05-14 08:06:00 | AAPL | Stock | 20.1221 | 20.1221 | 20.1189 | 20.1189 | 44240.0 |
| 2012-05-14 08:07:00 | AAPL | Stock | 20.1304 | 20.1304 | 20.1304 | 20.1304 | 2800.0 |
| 2012-05-14 08:08:00 | AAPL | Stock | 20.125 | 20.1311 | 20.1218 | 20.1311 | 20608.0 |
| 2012-05-14 08:09:00 | AAPL | Stock | 20.1318 | 20.1332 | 20.1221 | 20.1221 | 11200.0 |
| 2012-05-14 08:10:00 | AAPL | Stock | 20.1218 | 20.1279 | 20.1218 | 20.1279 | 5600.0 |
| 2012-05-14 08:11:00 | AAPL | Stock | 20.1207 | 20.1207 | 20.1125 | 20.1125 | 69104.0 |
| 2012-05-14 08:12:00 | AAPL | Stock | 20.1161 | 20.1161 | 20.1129 | 20.1132 | 8400.0 |
| 2012-05-14 08:13:00 | AAPL | Stock | 20.1239 | 20.1239 | 20.1239 | 20.1239 | 2800.0 |
| 2012-05-14 08:14:00 | AAPL | Stock | 20.1136 | 20.1246 | 20.1036 | 20.1086 | 162400.0 |
| 2012-05-14 08:15:00 | AAPL | Stock | 20.1064 | 20.1071 | 20.1064 | 20.1071 | 28700.0 |
| 2012-05-14 08:16:00 | AAPL | Stock | 20.1039 | 20.1054 | 20.1039 | 20.1054 | 8400.0 |
| 2012-05-14 08:17:00 | AAPL | Stock | 20.1054 | 20.1054 | 20.0986 | 20.0986 | 30800.0 |
| 2012-05-14 08:18:00 | AAPL | Stock | 20.0986 | 20.1036 | 20.0986 | 20.0986 | 47180.0 |
| 2012-05-14 08:19:00 | AAPL | Stock | 20.0986 | 20.0986 | 20.0982 | 20.0982 | 5600.0 |
| 2012-05-14 08:20:00 | AAPL | Stock | 20.0921 | 20.095 | 20.0893 | 20.095 | 53900.0 |
| 2012-05-14 08:21:00 | AAPL | Stock | 20.0964 | 20.0964 | 20.0896 | 20.0904 | 21588.0 |
> showing 50 of 969,229 rows — these rows as CSV