PREVIEW / stock_1min / 2012-11-21
file: by_date/stock_1min/2012/2012-11-21.parquet size: 11.6 MB rows: 870,113 symbols: 2,791
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-11-21 04:12:00 | AAPL | Stock | 20.125 | 20.125 | 20.125 | 20.125 | 5600.0 |
| 2012-11-21 04:13:00 | AAPL | Stock | 20.125 | 20.1393 | 20.125 | 20.1393 | 17920.0 |
| 2012-11-21 04:14:00 | AAPL | Stock | 20.1393 | 20.1393 | 20.1393 | 20.1393 | 2800.0 |
| 2012-11-21 04:16:00 | AAPL | Stock | 20.1607 | 20.1607 | 20.1607 | 20.1607 | 2800.0 |
| 2012-11-21 04:23:00 | AAPL | Stock | 20.1429 | 20.1429 | 20.1429 | 20.1429 | 2800.0 |
| 2012-11-21 04:25:00 | AAPL | Stock | 20.1429 | 20.1429 | 20.1429 | 20.1429 | 2800.0 |
| 2012-11-21 04:47:00 | AAPL | Stock | 20.125 | 20.125 | 20.125 | 20.125 | 2800.0 |
| 2012-11-21 05:09:00 | AAPL | Stock | 20.1071 | 20.1071 | 20.1071 | 20.1071 | 2800.0 |
| 2012-11-21 05:12:00 | AAPL | Stock | 20.1071 | 20.1071 | 20.1071 | 20.1071 | 2800.0 |
| 2012-11-21 05:16:00 | AAPL | Stock | 20.0982 | 20.0982 | 20.0982 | 20.0982 | 8400.0 |
| 2012-11-21 05:23:00 | AAPL | Stock | 20.0929 | 20.0929 | 20.0929 | 20.0929 | 8400.0 |
| 2012-11-21 05:27:00 | AAPL | Stock | 20.0893 | 20.0893 | 20.0893 | 20.0893 | 2800.0 |
| 2012-11-21 05:30:00 | AAPL | Stock | 20.0982 | 20.1071 | 20.0982 | 20.1071 | 11200.0 |
| 2012-11-21 05:47:00 | AAPL | Stock | 20.0982 | 20.0982 | 20.0982 | 20.0982 | 8400.0 |
| 2012-11-21 05:58:00 | AAPL | Stock | 20.0893 | 20.0893 | 20.0893 | 20.0893 | 14000.0 |
| 2012-11-21 05:59:00 | AAPL | Stock | 20.0896 | 20.0896 | 20.0896 | 20.0896 | 14000.0 |
| 2012-11-21 06:01:00 | AAPL | Stock | 20.1071 | 20.1071 | 20.1071 | 20.1071 | 2800.0 |
| 2012-11-21 06:04:00 | AAPL | Stock | 20.1071 | 20.1071 | 20.1071 | 20.1071 | 5600.0 |
| 2012-11-21 06:05:00 | AAPL | Stock | 20.1071 | 20.1071 | 20.1071 | 20.1071 | 19320.0 |
| 2012-11-21 06:06:00 | AAPL | Stock | 20.1071 | 20.1071 | 20.1071 | 20.1071 | 5600.0 |
| 2012-11-21 06:31:00 | AAPL | Stock | 20.1339 | 20.1339 | 20.1339 | 20.1339 | 28000.0 |
| 2012-11-21 06:39:00 | AAPL | Stock | 20.125 | 20.125 | 20.125 | 20.125 | 5600.0 |
| 2012-11-21 06:52:00 | AAPL | Stock | 20.1425 | 20.1425 | 20.1425 | 20.1425 | 2800.0 |
| 2012-11-21 07:00:00 | AAPL | Stock | 20.1318 | 20.1318 | 20.1318 | 20.1318 | 2800.0 |
| 2012-11-21 07:01:00 | AAPL | Stock | 20.1132 | 20.1132 | 20.1129 | 20.1132 | 28000.0 |
| 2012-11-21 07:02:00 | AAPL | Stock | 20.125 | 20.125 | 20.125 | 20.125 | 2800.0 |
| 2012-11-21 07:03:00 | AAPL | Stock | 20.1257 | 20.1257 | 20.125 | 20.125 | 16800.0 |
| 2012-11-21 07:05:00 | AAPL | Stock | 20.1089 | 20.1096 | 20.1086 | 20.1089 | 13440.0 |
| 2012-11-21 07:06:00 | AAPL | Stock | 20.1096 | 20.1096 | 20.1082 | 20.1082 | 5600.0 |
| 2012-11-21 07:08:00 | AAPL | Stock | 20.1071 | 20.1143 | 20.1 | 20.1143 | 27748.0 |
| 2012-11-21 07:12:00 | AAPL | Stock | 20.1068 | 20.1071 | 20.1068 | 20.1071 | 24696.0 |
| 2012-11-21 07:22:00 | AAPL | Stock | 20.1014 | 20.1014 | 20.0982 | 20.0982 | 8400.0 |
| 2012-11-21 07:25:00 | AAPL | Stock | 20.1032 | 20.1071 | 20.1032 | 20.1071 | 16800.0 |
| 2012-11-21 07:27:00 | AAPL | Stock | 20.1075 | 20.1161 | 20.1071 | 20.1161 | 23856.0 |
| 2012-11-21 07:29:00 | AAPL | Stock | 20.1214 | 20.1214 | 20.1214 | 20.1214 | 2800.0 |
| 2012-11-21 07:31:00 | AAPL | Stock | 20.1164 | 20.1164 | 20.1164 | 20.1164 | 2800.0 |
| 2012-11-21 07:32:00 | AAPL | Stock | 20.1161 | 20.1161 | 20.1107 | 20.1107 | 16800.0 |
| 2012-11-21 07:33:00 | AAPL | Stock | 20.1196 | 20.1214 | 20.1075 | 20.1075 | 38780.0 |
| 2012-11-21 07:34:00 | AAPL | Stock | 20.1075 | 20.1075 | 20.1075 | 20.1075 | 2800.0 |
| 2012-11-21 07:35:00 | AAPL | Stock | 20.1075 | 20.1079 | 20.1075 | 20.1079 | 8400.0 |
| 2012-11-21 07:41:00 | AAPL | Stock | 20.1211 | 20.1211 | 20.1211 | 20.1211 | 2800.0 |
| 2012-11-21 07:42:00 | AAPL | Stock | 20.1129 | 20.1129 | 20.1111 | 20.1111 | 11508.0 |
| 2012-11-21 07:44:00 | AAPL | Stock | 20.1196 | 20.1196 | 20.1196 | 20.1196 | 8400.0 |
| 2012-11-21 07:48:00 | AAPL | Stock | 20.1136 | 20.1136 | 20.1018 | 20.1018 | 44800.0 |
| 2012-11-21 07:55:00 | AAPL | Stock | 20.0946 | 20.0946 | 20.0893 | 20.0893 | 47852.0 |
| 2012-11-21 07:56:00 | AAPL | Stock | 20.0893 | 20.0893 | 20.0893 | 20.0893 | 2800.0 |
| 2012-11-21 07:57:00 | AAPL | Stock | 20.0857 | 20.0857 | 20.0768 | 20.0768 | 58800.0 |
| 2012-11-21 07:58:00 | AAPL | Stock | 20.0889 | 20.0889 | 20.0889 | 20.0889 | 5600.0 |
| 2012-11-21 07:59:00 | AAPL | Stock | 20.0775 | 20.0775 | 20.0718 | 20.0718 | 29400.0 |
| 2012-11-21 08:00:00 | AAPL | Stock | 20.0714 | 20.1071 | 20.0646 | 20.0711 | 178836.0 |
> showing 50 of 870,113 rows — these rows as CSV