PREVIEW / stock_1min / 2009-10-21
file: by_date/stock_1min/2009/2009-10-21.parquet size: 12.8 MB rows: 959,873 symbols: 2,761
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 |
|---|---|---|---|---|---|---|---|
| 2009-10-21 04:15:00 | AAPL | Stock | 7.1607 | 7.1607 | 7.1607 | 7.1607 | 2800.0 |
| 2009-10-21 04:27:00 | AAPL | Stock | 7.1343 | 7.1343 | 7.1343 | 7.1343 | 2800.0 |
| 2009-10-21 05:51:00 | AAPL | Stock | 7.1107 | 7.1107 | 7.1107 | 7.1107 | 8400.0 |
| 2009-10-21 06:39:00 | AAPL | Stock | 7.1082 | 7.1082 | 7.1082 | 7.1082 | 2800.0 |
| 2009-10-21 07:01:00 | AAPL | Stock | 7.1086 | 7.1179 | 7.1082 | 7.1179 | 22400.0 |
| 2009-10-21 07:12:00 | AAPL | Stock | 7.1179 | 7.1179 | 7.1179 | 7.1179 | 14000.0 |
| 2009-10-21 07:22:00 | AAPL | Stock | 7.1146 | 7.1146 | 7.1125 | 7.1125 | 28000.0 |
| 2009-10-21 07:23:00 | AAPL | Stock | 7.1107 | 7.1107 | 7.1107 | 7.1107 | 11200.0 |
| 2009-10-21 07:25:00 | AAPL | Stock | 7.1225 | 7.1225 | 7.1225 | 7.1225 | 11200.0 |
| 2009-10-21 07:26:00 | AAPL | Stock | 7.1107 | 7.1125 | 7.1107 | 7.1125 | 8400.0 |
| 2009-10-21 07:33:00 | AAPL | Stock | 7.1107 | 7.1114 | 7.1107 | 7.1107 | 22064.0 |
| 2009-10-21 07:34:00 | AAPL | Stock | 7.1107 | 7.1107 | 7.1107 | 7.1107 | 5600.0 |
| 2009-10-21 07:36:00 | AAPL | Stock | 7.1071 | 7.1071 | 7.1071 | 7.1071 | 11620.0 |
| 2009-10-21 07:37:00 | AAPL | Stock | 7.1071 | 7.1071 | 7.1071 | 7.1071 | 3220.0 |
| 2009-10-21 07:41:00 | AAPL | Stock | 7.1107 | 7.1107 | 7.1071 | 7.1071 | 44800.0 |
| 2009-10-21 07:42:00 | AAPL | Stock | 7.1043 | 7.1043 | 7.1036 | 7.1036 | 11200.0 |
| 2009-10-21 07:44:00 | AAPL | Stock | 7.1125 | 7.1125 | 7.1125 | 7.1125 | 2800.0 |
| 2009-10-21 07:45:00 | AAPL | Stock | 7.1071 | 7.1071 | 7.1036 | 7.1036 | 11200.0 |
| 2009-10-21 07:48:00 | AAPL | Stock | 7.1036 | 7.1036 | 7.1036 | 7.1036 | 4116.0 |
| 2009-10-21 07:56:00 | AAPL | Stock | 7.1039 | 7.1039 | 7.1036 | 7.1036 | 15400.0 |
| 2009-10-21 07:57:00 | AAPL | Stock | 7.1071 | 7.1071 | 7.1071 | 7.1071 | 14000.0 |
| 2009-10-21 07:58:00 | AAPL | Stock | 7.1071 | 7.1071 | 7.1071 | 7.1071 | 3472.0 |
| 2009-10-21 07:59:00 | AAPL | Stock | 7.1107 | 7.1189 | 7.1071 | 7.1189 | 31948.0 |
| 2009-10-21 08:00:00 | AAPL | Stock | 7.1164 | 7.125 | 7.1114 | 7.1236 | 142212.0 |
| 2009-10-21 08:01:00 | AAPL | Stock | 7.1179 | 7.1232 | 7.1111 | 7.1211 | 67340.0 |
| 2009-10-21 08:02:00 | AAPL | Stock | 7.1204 | 7.1232 | 7.1182 | 7.1232 | 50736.0 |
| 2009-10-21 08:03:00 | AAPL | Stock | 7.1232 | 7.1232 | 7.1232 | 7.1232 | 13356.0 |
| 2009-10-21 08:04:00 | AAPL | Stock | 7.1214 | 7.1214 | 7.1186 | 7.1186 | 9520.0 |
| 2009-10-21 08:05:00 | AAPL | Stock | 7.1186 | 7.1196 | 7.1161 | 7.1161 | 218960.0 |
| 2009-10-21 08:06:00 | AAPL | Stock | 7.1143 | 7.1143 | 7.1139 | 7.1139 | 22400.0 |
| 2009-10-21 08:07:00 | AAPL | Stock | 7.1161 | 7.1161 | 7.1071 | 7.1107 | 54012.0 |
| 2009-10-21 08:11:00 | AAPL | Stock | 7.1109 | 7.1109 | 7.1109 | 7.1109 | 2800.0 |
| 2009-10-21 08:12:00 | AAPL | Stock | 7.1118 | 7.1209 | 7.1114 | 7.1207 | 36204.0 |
| 2009-10-21 08:13:00 | AAPL | Stock | 7.1211 | 7.1232 | 7.1189 | 7.1232 | 48020.0 |
| 2009-10-21 08:14:00 | AAPL | Stock | 7.1214 | 7.1239 | 7.1211 | 7.1236 | 84000.0 |
| 2009-10-21 08:15:00 | AAPL | Stock | 7.1236 | 7.125 | 7.1214 | 7.1239 | 64400.0 |
| 2009-10-21 08:16:00 | AAPL | Stock | 7.1196 | 7.1196 | 7.1196 | 7.1196 | 2800.0 |
| 2009-10-21 08:17:00 | AAPL | Stock | 7.1196 | 7.1229 | 7.1186 | 7.1207 | 22400.0 |
| 2009-10-21 08:18:00 | AAPL | Stock | 7.1193 | 7.1193 | 7.1193 | 7.1193 | 2800.0 |
| 2009-10-21 08:19:00 | AAPL | Stock | 7.1207 | 7.1236 | 7.1196 | 7.1214 | 22400.0 |
| 2009-10-21 08:20:00 | AAPL | Stock | 7.1186 | 7.1186 | 7.1186 | 7.1186 | 8400.0 |
| 2009-10-21 08:21:00 | AAPL | Stock | 7.1214 | 7.1214 | 7.1214 | 7.1214 | 14000.0 |
| 2009-10-21 08:22:00 | AAPL | Stock | 7.1214 | 7.1214 | 7.1186 | 7.1186 | 67508.0 |
| 2009-10-21 08:23:00 | AAPL | Stock | 7.1179 | 7.1214 | 7.1179 | 7.1211 | 26880.0 |
| 2009-10-21 08:24:00 | AAPL | Stock | 7.1214 | 7.1214 | 7.1214 | 7.1214 | 12460.0 |
| 2009-10-21 08:25:00 | AAPL | Stock | 7.1214 | 7.1214 | 7.1214 | 7.1214 | 14000.0 |
| 2009-10-21 08:26:00 | AAPL | Stock | 7.1214 | 7.1214 | 7.1214 | 7.1214 | 10276.0 |
| 2009-10-21 08:27:00 | AAPL | Stock | 7.1211 | 7.1214 | 7.1211 | 7.1214 | 16800.0 |
| 2009-10-21 08:29:00 | AAPL | Stock | 7.1214 | 7.1232 | 7.1214 | 7.1232 | 51296.0 |
| 2009-10-21 08:30:00 | AAPL | Stock | 7.1236 | 7.1239 | 7.1204 | 7.1204 | 58128.0 |
> showing 50 of 959,873 rows — these rows as CSV