PREVIEW / stock_5min / 2008-12-30
file: by_date/stock_5min/2008/2008-12-30.parquet size: 4.5 MB rows: 320,355 symbols: 3,381
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 |
|---|---|---|---|---|---|---|---|
| 2008-12-30 04:20:00 | AAPL | Stock | 3.1293 | 3.1443 | 3.1293 | 3.1443 | 8400.0 |
| 2008-12-30 05:25:00 | AAPL | Stock | 3.1539 | 3.1539 | 3.1536 | 3.1536 | 19600.0 |
| 2008-12-30 07:00:00 | AAPL | Stock | 3.1536 | 3.1536 | 3.1536 | 3.1536 | 8400.0 |
| 2008-12-30 07:10:00 | AAPL | Stock | 3.1604 | 3.1782 | 3.1604 | 3.1782 | 15764.0 |
| 2008-12-30 07:30:00 | AAPL | Stock | 3.1743 | 3.1743 | 3.1743 | 3.1743 | 8876.0 |
| 2008-12-30 07:35:00 | AAPL | Stock | 3.1704 | 3.1714 | 3.1704 | 3.1714 | 21084.0 |
| 2008-12-30 07:40:00 | AAPL | Stock | 3.1679 | 3.1714 | 3.15 | 3.15 | 207564.0 |
| 2008-12-30 07:45:00 | AAPL | Stock | 3.1693 | 3.1693 | 3.1464 | 3.1464 | 47600.0 |
| 2008-12-30 07:55:00 | AAPL | Stock | 3.1343 | 3.1475 | 3.1343 | 3.1429 | 54880.0 |
| 2008-12-30 08:00:00 | AAPL | Stock | 3.1339 | 3.1482 | 3.1143 | 3.1286 | 242032.0 |
| 2008-12-30 08:05:00 | AAPL | Stock | 3.1307 | 3.1321 | 3.1286 | 3.13 | 81984.0 |
| 2008-12-30 08:10:00 | AAPL | Stock | 3.1286 | 3.1393 | 3.1286 | 3.1343 | 158928.0 |
| 2008-12-30 08:15:00 | AAPL | Stock | 3.1346 | 3.1346 | 3.1286 | 3.1286 | 147784.0 |
| 2008-12-30 08:20:00 | AAPL | Stock | 3.1289 | 3.1289 | 3.1236 | 3.1286 | 88116.0 |
| 2008-12-30 08:25:00 | AAPL | Stock | 3.1282 | 3.1343 | 3.1243 | 3.1343 | 120736.0 |
| 2008-12-30 08:30:00 | AAPL | Stock | 3.1332 | 3.1357 | 3.1268 | 3.13 | 472500.0 |
| 2008-12-30 08:35:00 | AAPL | Stock | 3.1271 | 3.1318 | 3.1236 | 3.1236 | 99680.0 |
| 2008-12-30 08:40:00 | AAPL | Stock | 3.1286 | 3.1286 | 3.1271 | 3.1286 | 65828.0 |
| 2008-12-30 08:45:00 | AAPL | Stock | 3.1286 | 3.1304 | 3.1286 | 3.1286 | 55132.0 |
| 2008-12-30 08:50:00 | AAPL | Stock | 3.1314 | 3.1336 | 3.1314 | 3.1336 | 65520.0 |
| 2008-12-30 08:55:00 | AAPL | Stock | 3.1339 | 3.1343 | 3.1271 | 3.1275 | 95200.0 |
| 2008-12-30 09:00:00 | AAPL | Stock | 3.1275 | 3.1339 | 3.1275 | 3.1339 | 93464.0 |
| 2008-12-30 09:05:00 | AAPL | Stock | 3.1339 | 3.1386 | 3.1339 | 3.1375 | 300580.0 |
| 2008-12-30 09:10:00 | AAPL | Stock | 3.1339 | 3.1357 | 3.1339 | 3.1357 | 169260.0 |
| 2008-12-30 09:15:00 | AAPL | Stock | 3.1361 | 3.1393 | 3.1321 | 3.1321 | 128632.0 |
| 2008-12-30 09:20:00 | AAPL | Stock | 3.1321 | 3.1411 | 3.1321 | 3.1357 | 131012.0 |
| 2008-12-30 09:25:00 | AAPL | Stock | 3.1382 | 3.1393 | 3.1239 | 3.125 | 427364.0 |
| 2008-12-30 09:30:00 | AAPL | Stock | 3.1243 | 3.1286 | 3.1114 | 3.1181 | 12606524.0 |
| 2008-12-30 09:35:00 | AAPL | Stock | 3.1182 | 3.1182 | 3.1079 | 3.1139 | 7525952.0 |
| 2008-12-30 09:40:00 | AAPL | Stock | 3.1143 | 3.1318 | 3.1107 | 3.1311 | 14844760.0 |
| 2008-12-30 09:45:00 | AAPL | Stock | 3.1314 | 3.1357 | 3.125 | 3.1304 | 10365376.0 |
| 2008-12-30 09:50:00 | AAPL | Stock | 3.1307 | 3.1321 | 3.1179 | 3.1179 | 7844340.0 |
| 2008-12-30 09:55:00 | AAPL | Stock | 3.1179 | 3.1207 | 3.1107 | 3.1146 | 8589504.0 |
| 2008-12-30 10:00:00 | AAPL | Stock | 3.1146 | 3.1146 | 3.1004 | 3.1079 | 15683640.0 |
| 2008-12-30 10:05:00 | AAPL | Stock | 3.1079 | 3.1082 | 3.0957 | 3.0961 | 11846828.0 |
| 2008-12-30 10:10:00 | AAPL | Stock | 3.0957 | 3.105 | 3.0939 | 3.104 | 11094020.0 |
| 2008-12-30 10:15:00 | AAPL | Stock | 3.1043 | 3.1154 | 3.1039 | 3.1129 | 10400740.0 |
| 2008-12-30 10:20:00 | AAPL | Stock | 3.1132 | 3.1221 | 3.1114 | 3.1171 | 9325792.0 |
| 2008-12-30 10:25:00 | AAPL | Stock | 3.1175 | 3.1246 | 3.1154 | 3.1232 | 7133560.0 |
| 2008-12-30 10:30:00 | AAPL | Stock | 3.1232 | 3.1296 | 3.1232 | 3.1243 | 10680600.0 |
| 2008-12-30 10:35:00 | AAPL | Stock | 3.1243 | 3.125 | 3.1193 | 3.1229 | 5557328.0 |
| 2008-12-30 10:40:00 | AAPL | Stock | 3.1231 | 3.1246 | 3.1189 | 3.1193 | 3689952.0 |
| 2008-12-30 10:45:00 | AAPL | Stock | 3.1193 | 3.1282 | 3.1171 | 3.1225 | 6545728.0 |
| 2008-12-30 10:50:00 | AAPL | Stock | 3.1229 | 3.1254 | 3.1193 | 3.1207 | 4194484.0 |
| 2008-12-30 10:55:00 | AAPL | Stock | 3.1207 | 3.1214 | 3.1168 | 3.1179 | 4529588.0 |
| 2008-12-30 11:00:00 | AAPL | Stock | 3.1175 | 3.1186 | 3.1114 | 3.1125 | 7473004.0 |
| 2008-12-30 11:05:00 | AAPL | Stock | 3.1118 | 3.1189 | 3.1096 | 3.11 | 5162304.0 |
| 2008-12-30 11:10:00 | AAPL | Stock | 3.11 | 3.1111 | 3.1039 | 3.1096 | 6286420.0 |
| 2008-12-30 11:15:00 | AAPL | Stock | 3.1089 | 3.1154 | 3.1086 | 3.1143 | 4226264.0 |
| 2008-12-30 11:20:00 | AAPL | Stock | 3.1132 | 3.1164 | 3.1118 | 3.1154 | 3163412.0 |
> showing 50 of 320,355 rows — these rows as CSV