PREVIEW / stock_1min / 2008-11-18
file: by_date/stock_1min/2008/2008-11-18.parquet size: 12.4 MB rows: 1,000,806 symbols: 2,711
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-11-18 06:37:00 | AAPL | Stock | 3.11 | 3.11 | 3.11 | 3.11 | 5600.0 |
| 2008-11-18 06:57:00 | AAPL | Stock | 3.0925 | 3.0925 | 3.0925 | 3.0925 | 2800.0 |
| 2008-11-18 07:16:00 | AAPL | Stock | 3.1286 | 3.1289 | 3.1286 | 3.1289 | 5600.0 |
| 2008-11-18 07:17:00 | AAPL | Stock | 3.1286 | 3.1286 | 3.1286 | 3.1286 | 11200.0 |
| 2008-11-18 07:26:00 | AAPL | Stock | 3.1271 | 3.1271 | 3.1271 | 3.1271 | 2800.0 |
| 2008-11-18 07:33:00 | AAPL | Stock | 3.1264 | 3.1264 | 3.1264 | 3.1264 | 14000.0 |
| 2008-11-18 07:34:00 | AAPL | Stock | 3.1275 | 3.1339 | 3.1275 | 3.1339 | 5600.0 |
| 2008-11-18 07:35:00 | AAPL | Stock | 3.1339 | 3.1357 | 3.1339 | 3.1357 | 19600.0 |
| 2008-11-18 07:37:00 | AAPL | Stock | 3.1364 | 3.1368 | 3.1339 | 3.1357 | 30800.0 |
| 2008-11-18 07:41:00 | AAPL | Stock | 3.1357 | 3.1357 | 3.1357 | 3.1357 | 5600.0 |
| 2008-11-18 07:42:00 | AAPL | Stock | 3.1339 | 3.1339 | 3.1339 | 3.1339 | 4480.0 |
| 2008-11-18 07:46:00 | AAPL | Stock | 3.1339 | 3.1339 | 3.1339 | 3.1339 | 9520.0 |
| 2008-11-18 07:47:00 | AAPL | Stock | 3.1346 | 3.1346 | 3.1339 | 3.1339 | 42000.0 |
| 2008-11-18 07:48:00 | AAPL | Stock | 3.1339 | 3.1339 | 3.1339 | 3.1339 | 22400.0 |
| 2008-11-18 07:50:00 | AAPL | Stock | 3.1339 | 3.1339 | 3.1339 | 3.1339 | 10864.0 |
| 2008-11-18 07:59:00 | AAPL | Stock | 3.1364 | 3.1364 | 3.1364 | 3.1364 | 5600.0 |
| 2008-11-18 08:00:00 | AAPL | Stock | 3.1357 | 3.1382 | 3.1339 | 3.1339 | 92904.0 |
| 2008-11-18 08:01:00 | AAPL | Stock | 3.1371 | 3.1514 | 3.1371 | 3.1514 | 158816.0 |
| 2008-11-18 08:02:00 | AAPL | Stock | 3.1532 | 3.1639 | 3.1532 | 3.1554 | 64344.0 |
| 2008-11-18 08:04:00 | AAPL | Stock | 3.1589 | 3.1607 | 3.1589 | 3.1596 | 11200.0 |
| 2008-11-18 08:05:00 | AAPL | Stock | 3.1689 | 3.1743 | 3.1571 | 3.1671 | 91000.0 |
| 2008-11-18 08:06:00 | AAPL | Stock | 3.1786 | 3.1946 | 3.17 | 3.1786 | 90860.0 |
| 2008-11-18 08:07:00 | AAPL | Stock | 3.1811 | 3.1918 | 3.18 | 3.1911 | 70000.0 |
| 2008-11-18 08:08:00 | AAPL | Stock | 3.1864 | 3.1957 | 3.1864 | 3.1957 | 163520.0 |
| 2008-11-18 08:09:00 | AAPL | Stock | 3.1932 | 3.2036 | 3.1879 | 3.1893 | 298480.0 |
| 2008-11-18 08:10:00 | AAPL | Stock | 3.1964 | 3.1964 | 3.1911 | 3.1911 | 29820.0 |
| 2008-11-18 08:11:00 | AAPL | Stock | 3.1911 | 3.2032 | 3.1911 | 3.2029 | 72520.0 |
| 2008-11-18 08:12:00 | AAPL | Stock | 3.2018 | 3.2143 | 3.2004 | 3.2143 | 322504.0 |
| 2008-11-18 08:13:00 | AAPL | Stock | 3.2207 | 3.2214 | 3.2075 | 3.22 | 303324.0 |
| 2008-11-18 08:14:00 | AAPL | Stock | 3.2146 | 3.2193 | 3.2089 | 3.2143 | 87136.0 |
| 2008-11-18 08:15:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2071 | 3.2107 | 73164.0 |
| 2008-11-18 08:16:00 | AAPL | Stock | 3.2129 | 3.2143 | 3.2111 | 3.2143 | 54320.0 |
| 2008-11-18 08:17:00 | AAPL | Stock | 3.2143 | 3.2407 | 3.2143 | 3.2357 | 428736.0 |
| 2008-11-18 08:18:00 | AAPL | Stock | 3.2314 | 3.2354 | 3.2214 | 3.2214 | 53200.0 |
| 2008-11-18 08:19:00 | AAPL | Stock | 3.2346 | 3.2357 | 3.2236 | 3.2346 | 162008.0 |
| 2008-11-18 08:20:00 | AAPL | Stock | 3.2254 | 3.2254 | 3.2232 | 3.2232 | 47040.0 |
| 2008-11-18 08:21:00 | AAPL | Stock | 3.2232 | 3.2321 | 3.2232 | 3.2321 | 111524.0 |
| 2008-11-18 08:22:00 | AAPL | Stock | 3.2346 | 3.2346 | 3.2243 | 3.2243 | 18480.0 |
| 2008-11-18 08:23:00 | AAPL | Stock | 3.2232 | 3.2232 | 3.2232 | 3.2232 | 2800.0 |
| 2008-11-18 08:24:00 | AAPL | Stock | 3.2232 | 3.2286 | 3.2221 | 3.2229 | 89320.0 |
| 2008-11-18 08:25:00 | AAPL | Stock | 3.2229 | 3.2268 | 3.2229 | 3.2268 | 33320.0 |
| 2008-11-18 08:26:00 | AAPL | Stock | 3.2218 | 3.225 | 3.2218 | 3.2229 | 49000.0 |
| 2008-11-18 08:28:00 | AAPL | Stock | 3.2236 | 3.2314 | 3.215 | 3.2314 | 160720.0 |
| 2008-11-18 08:29:00 | AAPL | Stock | 3.2279 | 3.2279 | 3.2279 | 3.2279 | 4200.0 |
| 2008-11-18 08:30:00 | AAPL | Stock | 3.2268 | 3.2357 | 3.2232 | 3.2318 | 114240.0 |
| 2008-11-18 08:31:00 | AAPL | Stock | 3.2236 | 3.2236 | 3.2143 | 3.2143 | 290920.0 |
| 2008-11-18 08:32:00 | AAPL | Stock | 3.2146 | 3.2264 | 3.2146 | 3.225 | 38640.0 |
| 2008-11-18 08:33:00 | AAPL | Stock | 3.225 | 3.2279 | 3.2204 | 3.2204 | 146440.0 |
| 2008-11-18 08:34:00 | AAPL | Stock | 3.2232 | 3.2279 | 3.2204 | 3.2279 | 96040.0 |
| 2008-11-18 08:35:00 | AAPL | Stock | 3.225 | 3.2357 | 3.225 | 3.2357 | 217224.0 |
> showing 50 of 1,000,806 rows — these rows as CSV