PREVIEW / stock_1min / 2007-11-14
file: by_date/stock_1min/2007/2007-11-14.parquet size: 12.3 MB rows: 995,915 symbols: 2,620
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-14 04:56:00 | AAPL | Stock | 6.2321 | 6.2321 | 6.2321 | 6.2321 | 8288.0 |
| 2007-11-14 04:57:00 | AAPL | Stock | 6.2111 | 6.2111 | 6.2107 | 6.2107 | 5600.0 |
| 2007-11-14 05:04:00 | AAPL | Stock | 6.2214 | 6.2214 | 6.2214 | 6.2214 | 8708.0 |
| 2007-11-14 05:09:00 | AAPL | Stock | 6.225 | 6.225 | 6.225 | 6.225 | 11200.0 |
| 2007-11-14 05:13:00 | AAPL | Stock | 6.2436 | 6.2436 | 6.2436 | 6.2436 | 5600.0 |
| 2007-11-14 05:16:00 | AAPL | Stock | 6.2257 | 6.2257 | 6.2257 | 6.2257 | 5600.0 |
| 2007-11-14 05:19:00 | AAPL | Stock | 6.2218 | 6.2218 | 6.22 | 6.22 | 5600.0 |
| 2007-11-14 05:20:00 | AAPL | Stock | 6.2161 | 6.2161 | 6.2161 | 6.2161 | 14000.0 |
| 2007-11-14 05:21:00 | AAPL | Stock | 6.2161 | 6.2161 | 6.2161 | 6.2161 | 36316.0 |
| 2007-11-14 05:27:00 | AAPL | Stock | 6.2339 | 6.2339 | 6.2339 | 6.2339 | 2800.0 |
| 2007-11-14 05:47:00 | AAPL | Stock | 6.2246 | 6.2246 | 6.2246 | 6.2246 | 28000.0 |
| 2007-11-14 05:52:00 | AAPL | Stock | 6.2496 | 6.2496 | 6.2496 | 6.2496 | 5600.0 |
| 2007-11-14 05:53:00 | AAPL | Stock | 6.2496 | 6.2496 | 6.2496 | 6.2496 | 2800.0 |
| 2007-11-14 05:58:00 | AAPL | Stock | 6.2214 | 6.2214 | 6.22 | 6.22 | 11200.0 |
| 2007-11-14 06:01:00 | AAPL | Stock | 6.2339 | 6.235 | 6.2339 | 6.235 | 5600.0 |
| 2007-11-14 06:25:00 | AAPL | Stock | 6.2232 | 6.2232 | 6.2232 | 6.2232 | 11200.0 |
| 2007-11-14 06:28:00 | AAPL | Stock | 6.2232 | 6.2232 | 6.22 | 6.22 | 11200.0 |
| 2007-11-14 06:30:00 | AAPL | Stock | 6.2375 | 6.2375 | 6.2375 | 6.2375 | 5460.0 |
| 2007-11-14 06:39:00 | AAPL | Stock | 6.2268 | 6.2268 | 6.2164 | 6.2164 | 16800.0 |
| 2007-11-14 06:40:00 | AAPL | Stock | 6.2164 | 6.2164 | 6.2143 | 6.2143 | 19600.0 |
| 2007-11-14 06:41:00 | AAPL | Stock | 6.2107 | 6.2143 | 6.2075 | 6.2075 | 184800.0 |
| 2007-11-14 06:44:00 | AAPL | Stock | 6.2036 | 6.2036 | 6.2021 | 6.2036 | 11200.0 |
| 2007-11-14 06:45:00 | AAPL | Stock | 6.2036 | 6.2036 | 6.2036 | 6.2036 | 2800.0 |
| 2007-11-14 06:46:00 | AAPL | Stock | 6.1982 | 6.2143 | 6.1982 | 6.2143 | 28560.0 |
| 2007-11-14 06:49:00 | AAPL | Stock | 6.2143 | 6.2143 | 6.2143 | 6.2143 | 2800.0 |
| 2007-11-14 06:51:00 | AAPL | Stock | 6.2036 | 6.2036 | 6.2036 | 6.2036 | 47600.0 |
| 2007-11-14 06:52:00 | AAPL | Stock | 6.2107 | 6.2107 | 6.2107 | 6.2107 | 4676.0 |
| 2007-11-14 06:54:00 | AAPL | Stock | 6.2086 | 6.2089 | 6.2086 | 6.2089 | 8568.0 |
| 2007-11-14 07:00:00 | AAPL | Stock | 6.1982 | 6.1982 | 6.1811 | 6.1811 | 30800.0 |
| 2007-11-14 07:01:00 | AAPL | Stock | 6.1868 | 6.1893 | 6.1868 | 6.1893 | 11200.0 |
| 2007-11-14 07:02:00 | AAPL | Stock | 6.1811 | 6.1811 | 6.175 | 6.1779 | 30800.0 |
| 2007-11-14 07:03:00 | AAPL | Stock | 6.175 | 6.1764 | 6.1657 | 6.1764 | 51800.0 |
| 2007-11-14 07:04:00 | AAPL | Stock | 6.1643 | 6.1643 | 6.1482 | 6.1482 | 33600.0 |
| 2007-11-14 07:05:00 | AAPL | Stock | 6.1482 | 6.1482 | 6.1482 | 6.1482 | 2800.0 |
| 2007-11-14 07:08:00 | AAPL | Stock | 6.1664 | 6.1682 | 6.1664 | 6.1682 | 53200.0 |
| 2007-11-14 07:12:00 | AAPL | Stock | 6.1607 | 6.1607 | 6.1607 | 6.1607 | 5600.0 |
| 2007-11-14 07:14:00 | AAPL | Stock | 6.1557 | 6.1557 | 6.1536 | 6.1536 | 28000.0 |
| 2007-11-14 07:15:00 | AAPL | Stock | 6.1607 | 6.1607 | 6.1607 | 6.1607 | 96460.0 |
| 2007-11-14 07:16:00 | AAPL | Stock | 6.1643 | 6.1643 | 6.1643 | 6.1643 | 23380.0 |
| 2007-11-14 07:17:00 | AAPL | Stock | 6.1607 | 6.1607 | 6.1607 | 6.1607 | 4060.0 |
| 2007-11-14 07:20:00 | AAPL | Stock | 6.1518 | 6.1518 | 6.1432 | 6.1432 | 51660.0 |
| 2007-11-14 07:21:00 | AAPL | Stock | 6.1589 | 6.1589 | 6.1429 | 6.1429 | 25200.0 |
| 2007-11-14 07:22:00 | AAPL | Stock | 6.1429 | 6.1429 | 6.1429 | 6.1429 | 3444.0 |
| 2007-11-14 07:25:00 | AAPL | Stock | 6.1518 | 6.1518 | 6.1429 | 6.1429 | 43316.0 |
| 2007-11-14 07:26:00 | AAPL | Stock | 6.1382 | 6.1607 | 6.1375 | 6.1607 | 55944.0 |
| 2007-11-14 07:30:00 | AAPL | Stock | 6.1446 | 6.1586 | 6.1446 | 6.1586 | 19180.0 |
| 2007-11-14 07:32:00 | AAPL | Stock | 6.1429 | 6.15 | 6.1375 | 6.15 | 39200.0 |
| 2007-11-14 07:33:00 | AAPL | Stock | 6.1429 | 6.1464 | 6.1429 | 6.1454 | 30800.0 |
| 2007-11-14 07:35:00 | AAPL | Stock | 6.15 | 6.15 | 6.1482 | 6.1482 | 21504.0 |
| 2007-11-14 07:36:00 | AAPL | Stock | 6.1614 | 6.1614 | 6.1536 | 6.1536 | 11200.0 |
> showing 50 of 995,915 rows — these rows as CSV