PREVIEW / stock_1min / 2007-10-18
file: by_date/stock_1min/2007/2007-10-18.parquet size: 11.6 MB rows: 941,437 symbols: 2,555
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 |
|---|---|---|---|---|---|---|---|
| 2007-10-18 06:56:00 | AAPL | Stock | 6.1539 | 6.1539 | 6.1539 | 6.1539 | 8400.0 |
| 2007-10-18 07:02:00 | AAPL | Stock | 6.1661 | 6.1661 | 6.1661 | 6.1661 | 19600.0 |
| 2007-10-18 07:04:00 | AAPL | Stock | 6.1661 | 6.1661 | 6.1661 | 6.1661 | 8400.0 |
| 2007-10-18 07:06:00 | AAPL | Stock | 6.1875 | 6.1875 | 6.1875 | 6.1875 | 5600.0 |
| 2007-10-18 07:11:00 | AAPL | Stock | 6.1775 | 6.1775 | 6.1536 | 6.1536 | 40600.0 |
| 2007-10-18 07:18:00 | AAPL | Stock | 6.145 | 6.145 | 6.145 | 6.145 | 5600.0 |
| 2007-10-18 07:28:00 | AAPL | Stock | 6.145 | 6.145 | 6.145 | 6.145 | 2800.0 |
| 2007-10-18 07:29:00 | AAPL | Stock | 6.1296 | 6.1296 | 6.1254 | 6.1254 | 28000.0 |
| 2007-10-18 07:30:00 | AAPL | Stock | 6.1296 | 6.1296 | 6.1254 | 6.1254 | 28000.0 |
| 2007-10-18 07:53:00 | AAPL | Stock | 6.1336 | 6.1336 | 6.1336 | 6.1336 | 7700.0 |
| 2007-10-18 07:55:00 | AAPL | Stock | 6.1232 | 6.1232 | 6.1232 | 6.1232 | 14000.0 |
| 2007-10-18 07:57:00 | AAPL | Stock | 6.1232 | 6.1232 | 6.1232 | 6.1232 | 2800.0 |
| 2007-10-18 08:00:00 | AAPL | Stock | 6.1304 | 6.1339 | 6.1268 | 6.1286 | 115808.0 |
| 2007-10-18 08:01:00 | AAPL | Stock | 6.1304 | 6.1304 | 6.1275 | 6.1275 | 21840.0 |
| 2007-10-18 08:02:00 | AAPL | Stock | 6.125 | 6.125 | 6.1161 | 6.1161 | 220136.0 |
| 2007-10-18 08:03:00 | AAPL | Stock | 6.1179 | 6.1179 | 6.1107 | 6.1143 | 90188.0 |
| 2007-10-18 08:04:00 | AAPL | Stock | 6.1179 | 6.1214 | 6.1125 | 6.115 | 80248.0 |
| 2007-10-18 08:05:00 | AAPL | Stock | 6.1146 | 6.1246 | 6.1146 | 6.1239 | 124040.0 |
| 2007-10-18 08:06:00 | AAPL | Stock | 6.1218 | 6.1239 | 6.1196 | 6.1196 | 75600.0 |
| 2007-10-18 08:07:00 | AAPL | Stock | 6.1236 | 6.1239 | 6.1179 | 6.1179 | 116200.0 |
| 2007-10-18 08:08:00 | AAPL | Stock | 6.1179 | 6.1229 | 6.1161 | 6.1164 | 54236.0 |
| 2007-10-18 08:09:00 | AAPL | Stock | 6.1214 | 6.1214 | 6.1214 | 6.1214 | 3500.0 |
| 2007-10-18 08:10:00 | AAPL | Stock | 6.1214 | 6.1214 | 6.1161 | 6.1161 | 61460.0 |
| 2007-10-18 08:11:00 | AAPL | Stock | 6.1161 | 6.1186 | 6.1143 | 6.1143 | 47740.0 |
| 2007-10-18 08:12:00 | AAPL | Stock | 6.1143 | 6.1143 | 6.1143 | 6.1143 | 4060.0 |
| 2007-10-18 08:13:00 | AAPL | Stock | 6.1143 | 6.1161 | 6.1104 | 6.1161 | 65940.0 |
| 2007-10-18 08:14:00 | AAPL | Stock | 6.1118 | 6.1118 | 6.1039 | 6.1071 | 170240.0 |
| 2007-10-18 08:15:00 | AAPL | Stock | 6.0989 | 6.1057 | 6.0982 | 6.1 | 33600.0 |
| 2007-10-18 08:16:00 | AAPL | Stock | 6.0975 | 6.1036 | 6.0957 | 6.0986 | 51800.0 |
| 2007-10-18 08:17:00 | AAPL | Stock | 6.1 | 6.1054 | 6.1 | 6.1036 | 8400.0 |
| 2007-10-18 08:18:00 | AAPL | Stock | 6.1107 | 6.1107 | 6.1071 | 6.1071 | 39900.0 |
| 2007-10-18 08:19:00 | AAPL | Stock | 6.1107 | 6.1107 | 6.1107 | 6.1107 | 22400.0 |
| 2007-10-18 08:20:00 | AAPL | Stock | 6.1107 | 6.1107 | 6.1107 | 6.1107 | 3780.0 |
| 2007-10-18 08:21:00 | AAPL | Stock | 6.1107 | 6.1143 | 6.1107 | 6.1143 | 32508.0 |
| 2007-10-18 08:22:00 | AAPL | Stock | 6.1161 | 6.1161 | 6.1161 | 6.1161 | 20300.0 |
| 2007-10-18 08:23:00 | AAPL | Stock | 6.1161 | 6.1161 | 6.1161 | 6.1161 | 14000.0 |
| 2007-10-18 08:24:00 | AAPL | Stock | 6.1161 | 6.1175 | 6.1143 | 6.1175 | 27300.0 |
| 2007-10-18 08:25:00 | AAPL | Stock | 6.1179 | 6.1179 | 6.1179 | 6.1179 | 22008.0 |
| 2007-10-18 08:27:00 | AAPL | Stock | 6.1186 | 6.1186 | 6.1143 | 6.1143 | 12600.0 |
| 2007-10-18 08:28:00 | AAPL | Stock | 6.1143 | 6.1207 | 6.1143 | 6.1207 | 23436.0 |
| 2007-10-18 08:29:00 | AAPL | Stock | 6.1129 | 6.1129 | 6.1129 | 6.1129 | 2800.0 |
| 2007-10-18 08:30:00 | AAPL | Stock | 6.1146 | 6.1146 | 6.1146 | 6.1146 | 8400.0 |
| 2007-10-18 08:31:00 | AAPL | Stock | 6.1196 | 6.1196 | 6.1107 | 6.1107 | 43680.0 |
| 2007-10-18 08:32:00 | AAPL | Stock | 6.1143 | 6.1143 | 6.1107 | 6.1107 | 78400.0 |
| 2007-10-18 08:33:00 | AAPL | Stock | 6.1075 | 6.1075 | 6.1032 | 6.1071 | 81200.0 |
| 2007-10-18 08:34:00 | AAPL | Stock | 6.1071 | 6.1071 | 6.1036 | 6.1071 | 48300.0 |
| 2007-10-18 08:35:00 | AAPL | Stock | 6.1071 | 6.1071 | 6.1071 | 6.1071 | 12740.0 |
| 2007-10-18 08:36:00 | AAPL | Stock | 6.1071 | 6.1071 | 6.1036 | 6.1036 | 85260.0 |
| 2007-10-18 08:37:00 | AAPL | Stock | 6.1071 | 6.1107 | 6.1071 | 6.1107 | 33600.0 |
| 2007-10-18 08:38:00 | AAPL | Stock | 6.1071 | 6.1136 | 6.1068 | 6.1075 | 93380.0 |
> showing 50 of 941,437 rows — these rows as CSV