PREVIEW / stock_1min / 2009-06-08
file: by_date/stock_1min/2009/2009-06-08.parquet size: 12.3 MB rows: 945,363 symbols: 2,722
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-06-08 04:15:00 | AAPL | Stock | 5.1429 | 5.1429 | 5.1429 | 5.1429 | 19600.0 |
| 2009-06-08 05:09:00 | AAPL | Stock | 5.1114 | 5.1114 | 5.1114 | 5.1114 | 28000.0 |
| 2009-06-08 06:50:00 | AAPL | Stock | 5.1368 | 5.1368 | 5.1368 | 5.1368 | 2800.0 |
| 2009-06-08 06:59:00 | AAPL | Stock | 5.1368 | 5.1368 | 5.1368 | 5.1368 | 5600.0 |
| 2009-06-08 07:01:00 | AAPL | Stock | 5.1311 | 5.1311 | 5.1268 | 5.1286 | 44800.0 |
| 2009-06-08 07:05:00 | AAPL | Stock | 5.1286 | 5.1286 | 5.1211 | 5.1211 | 20552.0 |
| 2009-06-08 07:06:00 | AAPL | Stock | 5.1164 | 5.1164 | 5.1164 | 5.1164 | 9128.0 |
| 2009-06-08 07:09:00 | AAPL | Stock | 5.1168 | 5.1168 | 5.1164 | 5.1164 | 7672.0 |
| 2009-06-08 07:10:00 | AAPL | Stock | 5.1161 | 5.1161 | 5.1118 | 5.1118 | 10808.0 |
| 2009-06-08 07:11:00 | AAPL | Stock | 5.1161 | 5.1161 | 5.1118 | 5.1125 | 19600.0 |
| 2009-06-08 07:12:00 | AAPL | Stock | 5.1118 | 5.1136 | 5.1118 | 5.1125 | 14728.0 |
| 2009-06-08 07:13:00 | AAPL | Stock | 5.1121 | 5.1121 | 5.1121 | 5.1121 | 5600.0 |
| 2009-06-08 07:14:00 | AAPL | Stock | 5.1121 | 5.1121 | 5.1121 | 5.1121 | 5600.0 |
| 2009-06-08 07:15:00 | AAPL | Stock | 5.1121 | 5.1125 | 5.1121 | 5.1125 | 53200.0 |
| 2009-06-08 07:18:00 | AAPL | Stock | 5.1125 | 5.1179 | 5.1121 | 5.1121 | 14000.0 |
| 2009-06-08 07:22:00 | AAPL | Stock | 5.1214 | 5.1214 | 5.1214 | 5.1214 | 28000.0 |
| 2009-06-08 07:27:00 | AAPL | Stock | 5.1186 | 5.1186 | 5.1186 | 5.1186 | 7924.0 |
| 2009-06-08 07:28:00 | AAPL | Stock | 5.1182 | 5.1182 | 5.1182 | 5.1182 | 5600.0 |
| 2009-06-08 07:31:00 | AAPL | Stock | 5.1182 | 5.1182 | 5.1154 | 5.1154 | 42000.0 |
| 2009-06-08 07:32:00 | AAPL | Stock | 5.1139 | 5.1139 | 5.1139 | 5.1139 | 2800.0 |
| 2009-06-08 07:34:00 | AAPL | Stock | 5.1161 | 5.1161 | 5.1161 | 5.1161 | 2800.0 |
| 2009-06-08 07:35:00 | AAPL | Stock | 5.1179 | 5.1179 | 5.1179 | 5.1179 | 6524.0 |
| 2009-06-08 07:36:00 | AAPL | Stock | 5.1179 | 5.1179 | 5.1179 | 5.1179 | 11200.0 |
| 2009-06-08 07:38:00 | AAPL | Stock | 5.1279 | 5.1279 | 5.1243 | 5.1243 | 14000.0 |
| 2009-06-08 07:56:00 | AAPL | Stock | 5.1268 | 5.1268 | 5.1268 | 5.1268 | 5600.0 |
| 2009-06-08 07:58:00 | AAPL | Stock | 5.1271 | 5.1271 | 5.1271 | 5.1271 | 2800.0 |
| 2009-06-08 08:00:00 | AAPL | Stock | 5.125 | 5.1368 | 5.1182 | 5.1182 | 88592.0 |
| 2009-06-08 08:01:00 | AAPL | Stock | 5.1161 | 5.1196 | 5.1161 | 5.1179 | 19600.0 |
| 2009-06-08 08:02:00 | AAPL | Stock | 5.1179 | 5.1214 | 5.1168 | 5.1214 | 27020.0 |
| 2009-06-08 08:03:00 | AAPL | Stock | 5.1207 | 5.1207 | 5.1207 | 5.1207 | 2800.0 |
| 2009-06-08 08:04:00 | AAPL | Stock | 5.1214 | 5.1232 | 5.1214 | 5.1232 | 5600.0 |
| 2009-06-08 08:05:00 | AAPL | Stock | 5.1218 | 5.1236 | 5.1186 | 5.1186 | 53200.0 |
| 2009-06-08 08:06:00 | AAPL | Stock | 5.1214 | 5.1214 | 5.1214 | 5.1214 | 2800.0 |
| 2009-06-08 08:07:00 | AAPL | Stock | 5.1214 | 5.125 | 5.1179 | 5.1232 | 24500.0 |
| 2009-06-08 08:09:00 | AAPL | Stock | 5.1264 | 5.1268 | 5.1264 | 5.1268 | 11200.0 |
| 2009-06-08 08:10:00 | AAPL | Stock | 5.1268 | 5.1268 | 5.125 | 5.125 | 38500.0 |
| 2009-06-08 08:12:00 | AAPL | Stock | 5.1236 | 5.1236 | 5.1236 | 5.1236 | 2800.0 |
| 2009-06-08 08:13:00 | AAPL | Stock | 5.12 | 5.125 | 5.12 | 5.125 | 25200.0 |
| 2009-06-08 08:15:00 | AAPL | Stock | 5.1214 | 5.1214 | 5.1214 | 5.1214 | 10500.0 |
| 2009-06-08 08:16:00 | AAPL | Stock | 5.1214 | 5.1229 | 5.1179 | 5.1229 | 123200.0 |
| 2009-06-08 08:17:00 | AAPL | Stock | 5.1168 | 5.1168 | 5.1071 | 5.1071 | 123200.0 |
| 2009-06-08 08:19:00 | AAPL | Stock | 5.1079 | 5.1082 | 5.1071 | 5.1071 | 44800.0 |
| 2009-06-08 08:20:00 | AAPL | Stock | 5.1071 | 5.1071 | 5.1071 | 5.1071 | 16800.0 |
| 2009-06-08 08:21:00 | AAPL | Stock | 5.1036 | 5.1071 | 5.1021 | 5.1071 | 166404.0 |
| 2009-06-08 08:23:00 | AAPL | Stock | 5.1071 | 5.1071 | 5.1071 | 5.1071 | 33600.0 |
| 2009-06-08 08:24:00 | AAPL | Stock | 5.1075 | 5.1075 | 5.1043 | 5.1061 | 75208.0 |
| 2009-06-08 08:25:00 | AAPL | Stock | 5.1061 | 5.1061 | 5.1057 | 5.1057 | 24220.0 |
| 2009-06-08 08:26:00 | AAPL | Stock | 5.105 | 5.1061 | 5.105 | 5.1057 | 8400.0 |
| 2009-06-08 08:27:00 | AAPL | Stock | 5.1054 | 5.1096 | 5.1039 | 5.1064 | 79100.0 |
| 2009-06-08 08:28:00 | AAPL | Stock | 5.1064 | 5.1064 | 5.1057 | 5.1057 | 11200.0 |
> showing 50 of 945,363 rows — these rows as CSV