PREVIEW / stock_1min / 2010-02-25
file: by_date/stock_1min/2010/2010-02-25.parquet size: 12.5 MB rows: 948,327 symbols: 2,795
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 |
|---|---|---|---|---|---|---|---|
| 2010-02-25 04:28:00 | AAPL | Stock | 7.1254 | 7.1254 | 7.1254 | 7.1254 | 2800.0 |
| 2010-02-25 04:57:00 | AAPL | Stock | 7.1361 | 7.1361 | 7.1361 | 7.1361 | 2800.0 |
| 2010-02-25 06:42:00 | AAPL | Stock | 7.1339 | 7.1339 | 7.1339 | 7.1339 | 2800.0 |
| 2010-02-25 06:44:00 | AAPL | Stock | 7.1339 | 7.1339 | 7.1339 | 7.1339 | 2800.0 |
| 2010-02-25 07:07:00 | AAPL | Stock | 7.1346 | 7.1346 | 7.1346 | 7.1346 | 14000.0 |
| 2010-02-25 07:20:00 | AAPL | Stock | 7.1364 | 7.1364 | 7.1364 | 7.1364 | 7840.0 |
| 2010-02-25 07:22:00 | AAPL | Stock | 7.1329 | 7.1329 | 7.1329 | 7.1329 | 2800.0 |
| 2010-02-25 07:35:00 | AAPL | Stock | 7.1271 | 7.1271 | 7.1271 | 7.1271 | 6160.0 |
| 2010-02-25 07:37:00 | AAPL | Stock | 7.1286 | 7.1286 | 7.1286 | 7.1286 | 2800.0 |
| 2010-02-25 07:39:00 | AAPL | Stock | 7.1286 | 7.1286 | 7.1271 | 7.1271 | 8400.0 |
| 2010-02-25 07:43:00 | AAPL | Stock | 7.1275 | 7.1275 | 7.1254 | 7.1254 | 9968.0 |
| 2010-02-25 07:54:00 | AAPL | Stock | 7.1246 | 7.1246 | 7.1246 | 7.1246 | 2800.0 |
| 2010-02-25 07:57:00 | AAPL | Stock | 7.125 | 7.125 | 7.125 | 7.125 | 2800.0 |
| 2010-02-25 07:58:00 | AAPL | Stock | 7.125 | 7.125 | 7.125 | 7.125 | 2800.0 |
| 2010-02-25 08:00:00 | AAPL | Stock | 7.125 | 7.125 | 7.1182 | 7.125 | 81844.0 |
| 2010-02-25 08:01:00 | AAPL | Stock | 7.125 | 7.125 | 7.125 | 7.125 | 47600.0 |
| 2010-02-25 08:02:00 | AAPL | Stock | 7.125 | 7.1254 | 7.1218 | 7.1254 | 14000.0 |
| 2010-02-25 08:04:00 | AAPL | Stock | 7.1304 | 7.1304 | 7.1257 | 7.1257 | 9800.0 |
| 2010-02-25 08:05:00 | AAPL | Stock | 7.1261 | 7.1261 | 7.125 | 7.125 | 22680.0 |
| 2010-02-25 08:06:00 | AAPL | Stock | 7.125 | 7.1257 | 7.125 | 7.1257 | 22260.0 |
| 2010-02-25 08:09:00 | AAPL | Stock | 7.1257 | 7.1257 | 7.1257 | 7.1257 | 3640.0 |
| 2010-02-25 08:10:00 | AAPL | Stock | 7.1268 | 7.1268 | 7.1257 | 7.1257 | 16800.0 |
| 2010-02-25 08:11:00 | AAPL | Stock | 7.1321 | 7.1336 | 7.1321 | 7.1336 | 23800.0 |
| 2010-02-25 08:12:00 | AAPL | Stock | 7.1339 | 7.1339 | 7.1286 | 7.13 | 11200.0 |
| 2010-02-25 08:13:00 | AAPL | Stock | 7.1357 | 7.1361 | 7.1357 | 7.1361 | 14000.0 |
| 2010-02-25 08:14:00 | AAPL | Stock | 7.13 | 7.1304 | 7.13 | 7.13 | 8400.0 |
| 2010-02-25 08:16:00 | AAPL | Stock | 7.135 | 7.1364 | 7.135 | 7.1364 | 25340.0 |
| 2010-02-25 08:17:00 | AAPL | Stock | 7.1336 | 7.1336 | 7.1332 | 7.1332 | 5600.0 |
| 2010-02-25 08:19:00 | AAPL | Stock | 7.1304 | 7.1304 | 7.13 | 7.1304 | 8400.0 |
| 2010-02-25 08:20:00 | AAPL | Stock | 7.1296 | 7.1296 | 7.1286 | 7.1286 | 13440.0 |
| 2010-02-25 08:21:00 | AAPL | Stock | 7.1286 | 7.1286 | 7.1286 | 7.1286 | 11200.0 |
| 2010-02-25 08:22:00 | AAPL | Stock | 7.1286 | 7.1289 | 7.1257 | 7.1257 | 102200.0 |
| 2010-02-25 08:23:00 | AAPL | Stock | 7.1271 | 7.1271 | 7.1271 | 7.1271 | 5656.0 |
| 2010-02-25 08:24:00 | AAPL | Stock | 7.1286 | 7.1286 | 7.1282 | 7.1286 | 16800.0 |
| 2010-02-25 08:25:00 | AAPL | Stock | 7.1282 | 7.1307 | 7.1282 | 7.1293 | 21000.0 |
| 2010-02-25 08:26:00 | AAPL | Stock | 7.1286 | 7.1314 | 7.125 | 7.125 | 232960.0 |
| 2010-02-25 08:27:00 | AAPL | Stock | 7.125 | 7.125 | 7.1218 | 7.125 | 64400.0 |
| 2010-02-25 08:28:00 | AAPL | Stock | 7.125 | 7.1314 | 7.125 | 7.1261 | 60760.0 |
| 2010-02-25 08:29:00 | AAPL | Stock | 7.1261 | 7.1296 | 7.1261 | 7.1296 | 18200.0 |
| 2010-02-25 08:30:00 | AAPL | Stock | 7.1271 | 7.1307 | 7.1179 | 7.1179 | 357672.0 |
| 2010-02-25 08:31:00 | AAPL | Stock | 7.1196 | 7.1196 | 7.1089 | 7.1089 | 48636.0 |
| 2010-02-25 08:32:00 | AAPL | Stock | 7.1107 | 7.1107 | 7.1107 | 7.1107 | 29736.0 |
| 2010-02-25 08:33:00 | AAPL | Stock | 7.1182 | 7.1182 | 7.1071 | 7.1157 | 84392.0 |
| 2010-02-25 08:34:00 | AAPL | Stock | 7.1096 | 7.1096 | 7.1096 | 7.1096 | 14000.0 |
| 2010-02-25 08:35:00 | AAPL | Stock | 7.1107 | 7.1143 | 7.1107 | 7.1143 | 19600.0 |
| 2010-02-25 08:36:00 | AAPL | Stock | 7.1111 | 7.1111 | 7.1039 | 7.1039 | 107324.0 |
| 2010-02-25 08:37:00 | AAPL | Stock | 7.1075 | 7.1121 | 7.1075 | 7.1111 | 52500.0 |
| 2010-02-25 08:38:00 | AAPL | Stock | 7.1075 | 7.1093 | 7.1071 | 7.1093 | 33600.0 |
| 2010-02-25 08:39:00 | AAPL | Stock | 7.1093 | 7.1107 | 7.1071 | 7.1071 | 57400.0 |
| 2010-02-25 08:40:00 | AAPL | Stock | 7.1064 | 7.1064 | 7.1029 | 7.1036 | 81200.0 |
> showing 50 of 948,327 rows — these rows as CSV