PREVIEW / stock_1min / 2009-12-10
file: by_date/stock_1min/2009/2009-12-10.parquet size: 12.2 MB rows: 927,760 symbols: 2,783
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-12-10 07:00:00 | AAPL | Stock | 7.0918 | 7.0918 | 7.0918 | 7.0918 | 10892.0 |
| 2009-12-10 07:04:00 | AAPL | Stock | 7.0911 | 7.0911 | 7.0911 | 7.0911 | 2800.0 |
| 2009-12-10 07:05:00 | AAPL | Stock | 7.0918 | 7.0921 | 7.0918 | 7.0921 | 12320.0 |
| 2009-12-10 07:07:00 | AAPL | Stock | 7.0779 | 7.0779 | 7.0779 | 7.0779 | 2800.0 |
| 2009-12-10 07:08:00 | AAPL | Stock | 7.0764 | 7.0764 | 7.0764 | 7.0764 | 3528.0 |
| 2009-12-10 07:11:00 | AAPL | Stock | 7.0768 | 7.0768 | 7.0768 | 7.0768 | 2800.0 |
| 2009-12-10 07:13:00 | AAPL | Stock | 7.0789 | 7.0789 | 7.0789 | 7.0789 | 2800.0 |
| 2009-12-10 07:14:00 | AAPL | Stock | 7.0789 | 7.0789 | 7.0789 | 7.0789 | 2800.0 |
| 2009-12-10 07:17:00 | AAPL | Stock | 7.0804 | 7.0804 | 7.0804 | 7.0804 | 2800.0 |
| 2009-12-10 07:22:00 | AAPL | Stock | 7.0789 | 7.0893 | 7.0789 | 7.0893 | 50400.0 |
| 2009-12-10 07:23:00 | AAPL | Stock | 7.0929 | 7.0929 | 7.0929 | 7.0929 | 14000.0 |
| 2009-12-10 07:24:00 | AAPL | Stock | 7.0929 | 7.0929 | 7.0893 | 7.0893 | 13860.0 |
| 2009-12-10 07:25:00 | AAPL | Stock | 7.0929 | 7.0964 | 7.0929 | 7.0964 | 18060.0 |
| 2009-12-10 07:26:00 | AAPL | Stock | 7.0932 | 7.0964 | 7.0929 | 7.0964 | 22400.0 |
| 2009-12-10 07:29:00 | AAPL | Stock | 7.1 | 7.1 | 7.0964 | 7.0964 | 14000.0 |
| 2009-12-10 07:30:00 | AAPL | Stock | 7.0982 | 7.1029 | 7.0982 | 7.1029 | 53900.0 |
| 2009-12-10 07:31:00 | AAPL | Stock | 7.1071 | 7.1121 | 7.1071 | 7.1121 | 32004.0 |
| 2009-12-10 07:32:00 | AAPL | Stock | 7.1079 | 7.1079 | 7.1079 | 7.1079 | 2800.0 |
| 2009-12-10 07:33:00 | AAPL | Stock | 7.1079 | 7.1079 | 7.1071 | 7.1071 | 28000.0 |
| 2009-12-10 07:34:00 | AAPL | Stock | 7.1079 | 7.1079 | 7.1079 | 7.1079 | 5600.0 |
| 2009-12-10 07:35:00 | AAPL | Stock | 7.1111 | 7.1143 | 7.1111 | 7.1143 | 14000.0 |
| 2009-12-10 07:37:00 | AAPL | Stock | 7.1139 | 7.1179 | 7.1139 | 7.1161 | 71260.0 |
| 2009-12-10 07:38:00 | AAPL | Stock | 7.1161 | 7.1161 | 7.1161 | 7.1161 | 64400.0 |
| 2009-12-10 07:39:00 | AAPL | Stock | 7.1161 | 7.1179 | 7.1161 | 7.1179 | 25200.0 |
| 2009-12-10 07:40:00 | AAPL | Stock | 7.1214 | 7.125 | 7.1182 | 7.1182 | 56000.0 |
| 2009-12-10 07:41:00 | AAPL | Stock | 7.1246 | 7.1246 | 7.1196 | 7.1196 | 5600.0 |
| 2009-12-10 07:42:00 | AAPL | Stock | 7.125 | 7.125 | 7.125 | 7.125 | 2800.0 |
| 2009-12-10 07:43:00 | AAPL | Stock | 7.1275 | 7.1386 | 7.1275 | 7.1386 | 112056.0 |
| 2009-12-10 07:44:00 | AAPL | Stock | 7.1414 | 7.1429 | 7.1321 | 7.1321 | 109200.0 |
| 2009-12-10 07:45:00 | AAPL | Stock | 7.1339 | 7.1379 | 7.1339 | 7.1346 | 36400.0 |
| 2009-12-10 07:46:00 | AAPL | Stock | 7.1343 | 7.1375 | 7.1321 | 7.1321 | 59696.0 |
| 2009-12-10 07:47:00 | AAPL | Stock | 7.1321 | 7.1339 | 7.1321 | 7.1321 | 14000.0 |
| 2009-12-10 07:48:00 | AAPL | Stock | 7.1321 | 7.1329 | 7.1321 | 7.1329 | 28728.0 |
| 2009-12-10 07:49:00 | AAPL | Stock | 7.1286 | 7.1286 | 7.1286 | 7.1286 | 5600.0 |
| 2009-12-10 07:50:00 | AAPL | Stock | 7.1286 | 7.1286 | 7.1264 | 7.1286 | 42000.0 |
| 2009-12-10 07:51:00 | AAPL | Stock | 7.1286 | 7.1286 | 7.1286 | 7.1286 | 8764.0 |
| 2009-12-10 07:52:00 | AAPL | Stock | 7.1332 | 7.1332 | 7.1293 | 7.1293 | 5600.0 |
| 2009-12-10 07:54:00 | AAPL | Stock | 7.1304 | 7.1314 | 7.1268 | 7.1286 | 24472.0 |
| 2009-12-10 07:55:00 | AAPL | Stock | 7.1218 | 7.1221 | 7.1218 | 7.1221 | 8400.0 |
| 2009-12-10 07:56:00 | AAPL | Stock | 7.1221 | 7.1221 | 7.1221 | 7.1221 | 12600.0 |
| 2009-12-10 07:57:00 | AAPL | Stock | 7.1218 | 7.1221 | 7.1179 | 7.1214 | 67200.0 |
| 2009-12-10 07:58:00 | AAPL | Stock | 7.1214 | 7.1214 | 7.1214 | 7.1214 | 11200.0 |
| 2009-12-10 07:59:00 | AAPL | Stock | 7.1189 | 7.1189 | 7.1189 | 7.1189 | 5600.0 |
| 2009-12-10 08:00:00 | AAPL | Stock | 7.1232 | 7.1232 | 7.1107 | 7.115 | 236264.0 |
| 2009-12-10 08:01:00 | AAPL | Stock | 7.1164 | 7.1164 | 7.1071 | 7.1075 | 143780.0 |
| 2009-12-10 08:02:00 | AAPL | Stock | 7.1071 | 7.1107 | 7.1043 | 7.1107 | 184800.0 |
| 2009-12-10 08:03:00 | AAPL | Stock | 7.1139 | 7.1143 | 7.1075 | 7.1075 | 101780.0 |
| 2009-12-10 08:04:00 | AAPL | Stock | 7.1118 | 7.1143 | 7.1114 | 7.1139 | 180600.0 |
| 2009-12-10 08:05:00 | AAPL | Stock | 7.1107 | 7.1143 | 7.1107 | 7.1143 | 28000.0 |
| 2009-12-10 08:06:00 | AAPL | Stock | 7.1118 | 7.1139 | 7.1107 | 7.1139 | 39480.0 |
> showing 50 of 927,760 rows — these rows as CSV