PREVIEW / stock_5min / 2007-11-23
file: by_date/stock_5min/2007/2007-11-23.parquet size: 2.5 MB rows: 171,653 symbols: 3,064
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-11-23 05:35:00 | AAPL | Stock | 6.0764 | 6.0764 | 6.0764 | 6.0764 | 2800.0 |
| 2007-11-23 06:00:00 | AAPL | Stock | 6.09 | 6.1054 | 6.09 | 6.1054 | 26600.0 |
| 2007-11-23 06:10:00 | AAPL | Stock | 6.1061 | 6.1429 | 6.1061 | 6.1429 | 56000.0 |
| 2007-11-23 06:20:00 | AAPL | Stock | 6.1429 | 6.1429 | 6.1429 | 6.1429 | 8232.0 |
| 2007-11-23 06:25:00 | AAPL | Stock | 6.1429 | 6.1429 | 6.1429 | 6.1429 | 19768.0 |
| 2007-11-23 06:35:00 | AAPL | Stock | 6.1375 | 6.1375 | 6.1075 | 6.1075 | 11200.0 |
| 2007-11-23 06:45:00 | AAPL | Stock | 6.1371 | 6.1371 | 6.1371 | 6.1371 | 5600.0 |
| 2007-11-23 06:55:00 | AAPL | Stock | 6.1339 | 6.1375 | 6.1339 | 6.1375 | 16632.0 |
| 2007-11-23 07:00:00 | AAPL | Stock | 6.1639 | 6.1639 | 6.1371 | 6.1371 | 19600.0 |
| 2007-11-23 07:05:00 | AAPL | Stock | 6.1371 | 6.1371 | 6.125 | 6.125 | 61600.0 |
| 2007-11-23 07:15:00 | AAPL | Stock | 6.1357 | 6.1429 | 6.1357 | 6.1429 | 30772.0 |
| 2007-11-23 07:20:00 | AAPL | Stock | 6.125 | 6.125 | 6.1007 | 6.1007 | 36400.0 |
| 2007-11-23 07:25:00 | AAPL | Stock | 6.1239 | 6.1239 | 6.1218 | 6.1221 | 30800.0 |
| 2007-11-23 07:30:00 | AAPL | Stock | 6.1221 | 6.1221 | 6.1011 | 6.1011 | 36400.0 |
| 2007-11-23 07:35:00 | AAPL | Stock | 6.1011 | 6.1071 | 6.0989 | 6.0989 | 41720.0 |
| 2007-11-23 07:45:00 | AAPL | Stock | 6.1071 | 6.1071 | 6.1036 | 6.1036 | 16800.0 |
| 2007-11-23 07:50:00 | AAPL | Stock | 6.1036 | 6.1036 | 6.1 | 6.1036 | 29120.0 |
| 2007-11-23 07:55:00 | AAPL | Stock | 6.1036 | 6.1129 | 6.0957 | 6.1071 | 302680.0 |
| 2007-11-23 08:00:00 | AAPL | Stock | 6.1136 | 6.1221 | 6.1029 | 6.1125 | 1409660.0 |
| 2007-11-23 08:05:00 | AAPL | Stock | 6.1161 | 6.1271 | 6.115 | 6.1204 | 1115408.0 |
| 2007-11-23 08:10:00 | AAPL | Stock | 6.1193 | 6.1193 | 6.1089 | 6.1161 | 342972.0 |
| 2007-11-23 08:15:00 | AAPL | Stock | 6.1161 | 6.1232 | 6.1129 | 6.1232 | 431340.0 |
| 2007-11-23 08:20:00 | AAPL | Stock | 6.1214 | 6.1389 | 6.1211 | 6.1389 | 600740.0 |
| 2007-11-23 08:25:00 | AAPL | Stock | 6.1339 | 6.1429 | 6.1289 | 6.1407 | 679812.0 |
| 2007-11-23 08:30:00 | AAPL | Stock | 6.1386 | 6.1486 | 6.1386 | 6.1457 | 942676.0 |
| 2007-11-23 08:35:00 | AAPL | Stock | 6.1436 | 6.1518 | 6.1357 | 6.1357 | 1154188.0 |
| 2007-11-23 08:40:00 | AAPL | Stock | 6.1354 | 6.1425 | 6.1321 | 6.1421 | 314272.0 |
| 2007-11-23 08:45:00 | AAPL | Stock | 6.1407 | 6.1407 | 6.1304 | 6.1375 | 328804.0 |
| 2007-11-23 08:50:00 | AAPL | Stock | 6.1357 | 6.1371 | 6.1243 | 6.1261 | 774256.0 |
| 2007-11-23 08:55:00 | AAPL | Stock | 6.1286 | 6.1336 | 6.0164 | 6.1218 | 23109744.0 |
| 2007-11-23 09:00:00 | AAPL | Stock | 6.1225 | 6.1364 | 6.1182 | 6.1304 | 600040.0 |
| 2007-11-23 09:05:00 | AAPL | Stock | 6.1304 | 6.1375 | 6.1286 | 6.1286 | 447972.0 |
| 2007-11-23 09:10:00 | AAPL | Stock | 6.1289 | 6.1339 | 6.1168 | 6.125 | 896672.0 |
| 2007-11-23 09:15:00 | AAPL | Stock | 6.1204 | 6.1296 | 6.1143 | 6.1296 | 135604.0 |
| 2007-11-23 09:20:00 | AAPL | Stock | 6.1261 | 6.13 | 6.1168 | 6.1232 | 334432.0 |
| 2007-11-23 09:25:00 | AAPL | Stock | 6.1279 | 6.1414 | 6.125 | 6.1414 | 740712.0 |
| 2007-11-23 09:30:00 | AAPL | Stock | 6.1404 | 6.1446 | 6.0989 | 6.1071 | 29542940.0 |
| 2007-11-23 09:35:00 | AAPL | Stock | 6.1075 | 6.1154 | 6.0893 | 6.0904 | 17557428.0 |
| 2007-11-23 09:40:00 | AAPL | Stock | 6.0904 | 6.1032 | 6.0771 | 6.0936 | 19213684.0 |
| 2007-11-23 09:45:00 | AAPL | Stock | 6.0943 | 6.1143 | 6.0811 | 6.1118 | 16781996.0 |
| 2007-11-23 09:50:00 | AAPL | Stock | 6.1121 | 6.1179 | 6.0946 | 6.1025 | 14582960.0 |
| 2007-11-23 09:55:00 | AAPL | Stock | 6.1029 | 6.1146 | 6.0968 | 6.1118 | 13673744.0 |
| 2007-11-23 10:00:00 | AAPL | Stock | 6.1118 | 6.1168 | 6.0714 | 6.0961 | 13100864.0 |
| 2007-11-23 10:05:00 | AAPL | Stock | 6.0964 | 6.1071 | 6.0911 | 6.1043 | 11147248.0 |
| 2007-11-23 10:10:00 | AAPL | Stock | 6.105 | 6.1125 | 6.0989 | 6.1032 | 7980336.0 |
| 2007-11-23 10:15:00 | AAPL | Stock | 6.1036 | 6.1214 | 6.1021 | 6.1182 | 9887136.0 |
| 2007-11-23 10:20:00 | AAPL | Stock | 6.1182 | 6.1218 | 6.1018 | 6.1085 | 9975364.0 |
| 2007-11-23 10:25:00 | AAPL | Stock | 6.1071 | 6.1086 | 6.0929 | 6.0932 | 6195420.0 |
| 2007-11-23 10:30:00 | AAPL | Stock | 6.0932 | 6.1043 | 6.0893 | 6.1007 | 5432644.0 |
| 2007-11-23 10:35:00 | AAPL | Stock | 6.1014 | 6.1079 | 6.0961 | 6.0989 | 6881784.0 |
> showing 50 of 171,653 rows — these rows as CSV