PREVIEW / stock_1min / 2007-12-27
file: by_date/stock_1min/2007/2007-12-27.parquet size: 12.0 MB rows: 978,975 symbols: 2,663
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-12-27 04:20:00 | AAPL | Stock | 7.0982 | 7.0982 | 7.0982 | 7.0982 | 2800.0 |
| 2007-12-27 07:01:00 | AAPL | Stock | 7.1179 | 7.1179 | 7.1179 | 7.1179 | 5600.0 |
| 2007-12-27 07:02:00 | AAPL | Stock | 7.1254 | 7.1254 | 7.1254 | 7.1254 | 2800.0 |
| 2007-12-27 07:16:00 | AAPL | Stock | 7.1214 | 7.1214 | 7.1214 | 7.1214 | 5320.0 |
| 2007-12-27 07:20:00 | AAPL | Stock | 7.125 | 7.125 | 7.125 | 7.125 | 2800.0 |
| 2007-12-27 07:24:00 | AAPL | Stock | 7.125 | 7.125 | 7.125 | 7.125 | 2800.0 |
| 2007-12-27 07:25:00 | AAPL | Stock | 7.125 | 7.125 | 7.125 | 7.125 | 5600.0 |
| 2007-12-27 07:27:00 | AAPL | Stock | 7.1271 | 7.1271 | 7.1271 | 7.1271 | 5012.0 |
| 2007-12-27 07:29:00 | AAPL | Stock | 7.1304 | 7.1339 | 7.1304 | 7.1339 | 58800.0 |
| 2007-12-27 07:30:00 | AAPL | Stock | 7.1357 | 7.1357 | 7.1357 | 7.1357 | 2800.0 |
| 2007-12-27 07:31:00 | AAPL | Stock | 7.1304 | 7.1304 | 7.1304 | 7.1304 | 2800.0 |
| 2007-12-27 07:32:00 | AAPL | Stock | 7.1354 | 7.1357 | 7.1354 | 7.1357 | 15400.0 |
| 2007-12-27 07:33:00 | AAPL | Stock | 7.1357 | 7.1429 | 7.1357 | 7.1379 | 81200.0 |
| 2007-12-27 07:34:00 | AAPL | Stock | 7.1429 | 7.1429 | 7.1429 | 7.1429 | 5600.0 |
| 2007-12-27 07:35:00 | AAPL | Stock | 7.1304 | 7.1304 | 7.1304 | 7.1304 | 36400.0 |
| 2007-12-27 07:39:00 | AAPL | Stock | 7.1289 | 7.1289 | 7.1289 | 7.1289 | 7000.0 |
| 2007-12-27 07:40:00 | AAPL | Stock | 7.1254 | 7.1271 | 7.125 | 7.125 | 11648.0 |
| 2007-12-27 07:41:00 | AAPL | Stock | 7.1214 | 7.1214 | 7.1214 | 7.1214 | 4032.0 |
| 2007-12-27 07:42:00 | AAPL | Stock | 7.1275 | 7.1275 | 7.1275 | 7.1275 | 4900.0 |
| 2007-12-27 07:48:00 | AAPL | Stock | 7.1279 | 7.1279 | 7.1279 | 7.1279 | 2800.0 |
| 2007-12-27 07:49:00 | AAPL | Stock | 7.1279 | 7.1286 | 7.1279 | 7.1286 | 28000.0 |
| 2007-12-27 07:57:00 | AAPL | Stock | 7.1268 | 7.1268 | 7.1268 | 7.1268 | 14000.0 |
| 2007-12-27 08:00:00 | AAPL | Stock | 7.1268 | 7.1429 | 7.1268 | 7.1304 | 298368.0 |
| 2007-12-27 08:01:00 | AAPL | Stock | 7.1386 | 7.1429 | 7.1329 | 7.1429 | 207620.0 |
| 2007-12-27 08:02:00 | AAPL | Stock | 7.1429 | 7.1475 | 7.14 | 7.1446 | 163156.0 |
| 2007-12-27 08:03:00 | AAPL | Stock | 7.1425 | 7.1429 | 7.1357 | 7.1357 | 262752.0 |
| 2007-12-27 08:04:00 | AAPL | Stock | 7.1382 | 7.1393 | 7.1339 | 7.1339 | 55076.0 |
| 2007-12-27 08:05:00 | AAPL | Stock | 7.1361 | 7.1393 | 7.1321 | 7.1321 | 41412.0 |
| 2007-12-27 08:06:00 | AAPL | Stock | 7.1339 | 7.1375 | 7.1339 | 7.1375 | 65492.0 |
| 2007-12-27 08:07:00 | AAPL | Stock | 7.1375 | 7.1393 | 7.1357 | 7.1393 | 95480.0 |
| 2007-12-27 08:08:00 | AAPL | Stock | 7.1375 | 7.1375 | 7.1357 | 7.1357 | 17976.0 |
| 2007-12-27 08:09:00 | AAPL | Stock | 7.1357 | 7.1368 | 7.1339 | 7.1364 | 39200.0 |
| 2007-12-27 08:10:00 | AAPL | Stock | 7.1339 | 7.1339 | 7.1332 | 7.1339 | 32900.0 |
| 2007-12-27 08:11:00 | AAPL | Stock | 7.1339 | 7.1354 | 7.1332 | 7.1332 | 103460.0 |
| 2007-12-27 08:12:00 | AAPL | Stock | 7.1332 | 7.1339 | 7.1329 | 7.1329 | 14700.0 |
| 2007-12-27 08:13:00 | AAPL | Stock | 7.1321 | 7.1329 | 7.1321 | 7.1329 | 33656.0 |
| 2007-12-27 08:14:00 | AAPL | Stock | 7.1343 | 7.1343 | 7.1304 | 7.1304 | 140532.0 |
| 2007-12-27 08:15:00 | AAPL | Stock | 7.1286 | 7.1336 | 7.1286 | 7.1336 | 11200.0 |
| 2007-12-27 08:16:00 | AAPL | Stock | 7.1329 | 7.1329 | 7.1275 | 7.1275 | 58800.0 |
| 2007-12-27 08:17:00 | AAPL | Stock | 7.125 | 7.125 | 7.1214 | 7.1214 | 35868.0 |
| 2007-12-27 08:18:00 | AAPL | Stock | 7.1232 | 7.1236 | 7.1071 | 7.1236 | 158144.0 |
| 2007-12-27 08:19:00 | AAPL | Stock | 7.1275 | 7.1275 | 7.1275 | 7.1275 | 25340.0 |
| 2007-12-27 08:20:00 | AAPL | Stock | 7.1286 | 7.1286 | 7.1286 | 7.1286 | 8400.0 |
| 2007-12-27 08:21:00 | AAPL | Stock | 7.1275 | 7.1275 | 7.1164 | 7.1214 | 180460.0 |
| 2007-12-27 08:22:00 | AAPL | Stock | 7.1182 | 7.1236 | 7.1171 | 7.1236 | 22120.0 |
| 2007-12-27 08:23:00 | AAPL | Stock | 7.1243 | 7.1286 | 7.1236 | 7.1286 | 22400.0 |
| 2007-12-27 08:24:00 | AAPL | Stock | 7.1286 | 7.1286 | 7.1286 | 7.1286 | 16800.0 |
| 2007-12-27 08:25:00 | AAPL | Stock | 7.125 | 7.1275 | 7.125 | 7.125 | 15960.0 |
| 2007-12-27 08:26:00 | AAPL | Stock | 7.1214 | 7.1318 | 7.1214 | 7.1318 | 144060.0 |
| 2007-12-27 08:27:00 | AAPL | Stock | 7.1268 | 7.1268 | 7.1164 | 7.1164 | 154420.0 |
> showing 50 of 978,975 rows — these rows as CSV