PREVIEW / stock_1min / 2007-12-26
file: by_date/stock_1min/2007/2007-12-26.parquet size: 11.7 MB rows: 967,304 symbols: 2,652
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-26 07:19:00 | AAPL | Stock | 7.1071 | 7.1071 | 7.1071 | 7.1071 | 2800.0 |
| 2007-12-26 07:22:00 | AAPL | Stock | 7.1307 | 7.1307 | 7.1307 | 7.1307 | 28000.0 |
| 2007-12-26 07:23:00 | AAPL | Stock | 7.1307 | 7.1307 | 7.1268 | 7.1268 | 39200.0 |
| 2007-12-26 07:25:00 | AAPL | Stock | 7.1214 | 7.1214 | 7.1214 | 7.1214 | 28000.0 |
| 2007-12-26 07:27:00 | AAPL | Stock | 7.1214 | 7.1214 | 7.1214 | 7.1214 | 2800.0 |
| 2007-12-26 07:29:00 | AAPL | Stock | 7.1286 | 7.1286 | 7.1286 | 7.1286 | 2800.0 |
| 2007-12-26 07:31:00 | AAPL | Stock | 7.1379 | 7.1379 | 7.1379 | 7.1379 | 16800.0 |
| 2007-12-26 07:32:00 | AAPL | Stock | 7.1393 | 7.1393 | 7.1393 | 7.1393 | 2800.0 |
| 2007-12-26 07:33:00 | AAPL | Stock | 7.1379 | 7.1393 | 7.1379 | 7.1393 | 33600.0 |
| 2007-12-26 07:34:00 | AAPL | Stock | 7.1393 | 7.1429 | 7.1393 | 7.1393 | 68600.0 |
| 2007-12-26 07:35:00 | AAPL | Stock | 7.1396 | 7.1429 | 7.1393 | 7.1429 | 65800.0 |
| 2007-12-26 07:36:00 | AAPL | Stock | 7.1429 | 7.1429 | 7.1429 | 7.1429 | 29792.0 |
| 2007-12-26 07:37:00 | AAPL | Stock | 7.1429 | 7.1429 | 7.1429 | 7.1429 | 3640.0 |
| 2007-12-26 07:40:00 | AAPL | Stock | 7.1429 | 7.1464 | 7.1429 | 7.1464 | 10192.0 |
| 2007-12-26 07:41:00 | AAPL | Stock | 7.1429 | 7.1429 | 7.1393 | 7.1393 | 126168.0 |
| 2007-12-26 07:42:00 | AAPL | Stock | 7.1357 | 7.1364 | 7.1357 | 7.1364 | 5600.0 |
| 2007-12-26 07:43:00 | AAPL | Stock | 7.1321 | 7.1321 | 7.1321 | 7.1321 | 14000.0 |
| 2007-12-26 07:52:00 | AAPL | Stock | 7.1196 | 7.1196 | 7.1196 | 7.1196 | 5600.0 |
| 2007-12-26 07:55:00 | AAPL | Stock | 7.1221 | 7.1221 | 7.1221 | 7.1221 | 14000.0 |
| 2007-12-26 07:57:00 | AAPL | Stock | 7.1218 | 7.1218 | 7.1218 | 7.1218 | 2800.0 |
| 2007-12-26 07:58:00 | AAPL | Stock | 7.115 | 7.115 | 7.1146 | 7.1146 | 11200.0 |
| 2007-12-26 08:00:00 | AAPL | Stock | 7.1214 | 7.1421 | 7.1214 | 7.1314 | 456988.0 |
| 2007-12-26 08:01:00 | AAPL | Stock | 7.1318 | 7.1425 | 7.1296 | 7.1361 | 269220.0 |
| 2007-12-26 08:02:00 | AAPL | Stock | 7.14 | 7.1461 | 7.1382 | 7.1436 | 500416.0 |
| 2007-12-26 08:03:00 | AAPL | Stock | 7.1439 | 7.1464 | 7.1414 | 7.1464 | 137564.0 |
| 2007-12-26 08:04:00 | AAPL | Stock | 7.1471 | 7.15 | 7.1446 | 7.1446 | 159040.0 |
| 2007-12-26 08:05:00 | AAPL | Stock | 7.1464 | 7.1464 | 7.1375 | 7.1418 | 479724.0 |
| 2007-12-26 08:06:00 | AAPL | Stock | 7.14 | 7.1425 | 7.1357 | 7.1389 | 266140.0 |
| 2007-12-26 08:07:00 | AAPL | Stock | 7.1364 | 7.1393 | 7.135 | 7.135 | 67228.0 |
| 2007-12-26 08:08:00 | AAPL | Stock | 7.1361 | 7.1411 | 7.1361 | 7.1411 | 235956.0 |
| 2007-12-26 08:09:00 | AAPL | Stock | 7.1418 | 7.1468 | 7.1411 | 7.1429 | 336392.0 |
| 2007-12-26 08:10:00 | AAPL | Stock | 7.1464 | 7.1768 | 7.1454 | 7.1536 | 253232.0 |
| 2007-12-26 08:11:00 | AAPL | Stock | 7.1504 | 7.1607 | 7.1504 | 7.1607 | 156688.0 |
| 2007-12-26 08:12:00 | AAPL | Stock | 7.1607 | 7.1621 | 7.1564 | 7.1621 | 141820.0 |
| 2007-12-26 08:13:00 | AAPL | Stock | 7.1607 | 7.1679 | 7.1607 | 7.1679 | 73808.0 |
| 2007-12-26 08:14:00 | AAPL | Stock | 7.1671 | 7.1693 | 7.1639 | 7.1679 | 252840.0 |
| 2007-12-26 08:15:00 | AAPL | Stock | 7.1657 | 7.1711 | 7.1575 | 7.1646 | 483140.0 |
| 2007-12-26 08:16:00 | AAPL | Stock | 7.1614 | 7.1643 | 7.1614 | 7.1643 | 16520.0 |
| 2007-12-26 08:17:00 | AAPL | Stock | 7.1654 | 7.1654 | 7.1654 | 7.1654 | 2800.0 |
| 2007-12-26 08:18:00 | AAPL | Stock | 7.1625 | 7.1629 | 7.1571 | 7.1571 | 155148.0 |
| 2007-12-26 08:19:00 | AAPL | Stock | 7.1589 | 7.1643 | 7.1536 | 7.1536 | 103600.0 |
| 2007-12-26 08:20:00 | AAPL | Stock | 7.1521 | 7.1554 | 7.15 | 7.1518 | 179648.0 |
| 2007-12-26 08:21:00 | AAPL | Stock | 7.1571 | 7.1571 | 7.15 | 7.15 | 48160.0 |
| 2007-12-26 08:22:00 | AAPL | Stock | 7.1543 | 7.1575 | 7.1543 | 7.1575 | 50456.0 |
| 2007-12-26 08:23:00 | AAPL | Stock | 7.1543 | 7.1543 | 7.1536 | 7.1543 | 22120.0 |
| 2007-12-26 08:24:00 | AAPL | Stock | 7.1536 | 7.1543 | 7.1514 | 7.1514 | 180796.0 |
| 2007-12-26 08:25:00 | AAPL | Stock | 7.1536 | 7.1536 | 7.1517 | 7.1536 | 67900.0 |
| 2007-12-26 08:26:00 | AAPL | Stock | 7.1536 | 7.1543 | 7.1504 | 7.1504 | 79100.0 |
| 2007-12-26 08:27:00 | AAPL | Stock | 7.1518 | 7.1518 | 7.15 | 7.15 | 71400.0 |
| 2007-12-26 08:28:00 | AAPL | Stock | 7.15 | 7.15 | 7.1482 | 7.1482 | 60172.0 |
> showing 50 of 967,304 rows — these rows as CSV