PREVIEW / stock_1min / 2008-01-14
file: by_date/stock_1min/2008/2008-01-14.parquet size: 12.3 MB rows: 1,001,888 symbols: 2,662
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-01-14 04:33:00 | AAPL | Stock | 6.2143 | 6.2143 | 6.2143 | 6.2143 | 5600.0 |
| 2008-01-14 04:44:00 | AAPL | Stock | 6.2086 | 6.2096 | 6.2086 | 6.2096 | 5600.0 |
| 2008-01-14 04:46:00 | AAPL | Stock | 6.2086 | 6.2086 | 6.2086 | 6.2086 | 2800.0 |
| 2008-01-14 04:47:00 | AAPL | Stock | 6.2086 | 6.2086 | 6.2086 | 6.2086 | 2800.0 |
| 2008-01-14 04:55:00 | AAPL | Stock | 6.2096 | 6.2096 | 6.2096 | 6.2096 | 2800.0 |
| 2008-01-14 05:09:00 | AAPL | Stock | 6.2096 | 6.2107 | 6.2096 | 6.2107 | 6440.0 |
| 2008-01-14 05:13:00 | AAPL | Stock | 6.2143 | 6.2143 | 6.2143 | 6.2143 | 11200.0 |
| 2008-01-14 05:18:00 | AAPL | Stock | 6.1971 | 6.1971 | 6.1971 | 6.1971 | 5600.0 |
| 2008-01-14 05:34:00 | AAPL | Stock | 6.2143 | 6.2143 | 6.2143 | 6.2143 | 2800.0 |
| 2008-01-14 05:35:00 | AAPL | Stock | 6.2143 | 6.2143 | 6.2143 | 6.2143 | 53200.0 |
| 2008-01-14 05:44:00 | AAPL | Stock | 6.2232 | 6.2232 | 6.2232 | 6.2232 | 56000.0 |
| 2008-01-14 05:51:00 | AAPL | Stock | 6.2321 | 6.2321 | 6.2321 | 6.2321 | 3752.0 |
| 2008-01-14 05:56:00 | AAPL | Stock | 6.2282 | 6.2282 | 6.2282 | 6.2282 | 5600.0 |
| 2008-01-14 06:05:00 | AAPL | Stock | 6.2271 | 6.2271 | 6.2271 | 6.2271 | 14000.0 |
| 2008-01-14 06:12:00 | AAPL | Stock | 6.2411 | 6.2411 | 6.2411 | 6.2411 | 33600.0 |
| 2008-01-14 06:29:00 | AAPL | Stock | 6.2229 | 6.2229 | 6.2229 | 6.2229 | 2800.0 |
| 2008-01-14 06:35:00 | AAPL | Stock | 6.2143 | 6.2143 | 6.2143 | 6.2143 | 8400.0 |
| 2008-01-14 06:46:00 | AAPL | Stock | 6.2143 | 6.2143 | 6.2143 | 6.2143 | 2800.0 |
| 2008-01-14 06:53:00 | AAPL | Stock | 6.2232 | 6.2232 | 6.2232 | 6.2232 | 28000.0 |
| 2008-01-14 06:54:00 | AAPL | Stock | 6.2232 | 6.2232 | 6.2232 | 6.2232 | 6440.0 |
| 2008-01-14 07:00:00 | AAPL | Stock | 6.2232 | 6.2232 | 6.2232 | 6.2232 | 16800.0 |
| 2008-01-14 07:02:00 | AAPL | Stock | 6.2232 | 6.2232 | 6.2232 | 6.2232 | 2800.0 |
| 2008-01-14 07:03:00 | AAPL | Stock | 6.2214 | 6.2214 | 6.2214 | 6.2214 | 27860.0 |
| 2008-01-14 07:06:00 | AAPL | Stock | 6.2214 | 6.2214 | 6.2214 | 6.2214 | 25340.0 |
| 2008-01-14 07:08:00 | AAPL | Stock | 6.22 | 6.22 | 6.22 | 6.22 | 14000.0 |
| 2008-01-14 07:11:00 | AAPL | Stock | 6.2179 | 6.2179 | 6.2179 | 6.2179 | 28000.0 |
| 2008-01-14 07:12:00 | AAPL | Stock | 6.2179 | 6.2179 | 6.2175 | 6.2175 | 42000.0 |
| 2008-01-14 07:13:00 | AAPL | Stock | 6.2161 | 6.2161 | 6.2161 | 6.2161 | 5600.0 |
| 2008-01-14 07:14:00 | AAPL | Stock | 6.2175 | 6.2175 | 6.2175 | 6.2175 | 14000.0 |
| 2008-01-14 07:18:00 | AAPL | Stock | 6.2182 | 6.2182 | 6.2161 | 6.2161 | 10920.0 |
| 2008-01-14 07:20:00 | AAPL | Stock | 6.2211 | 6.2211 | 6.2211 | 6.2211 | 14000.0 |
| 2008-01-14 07:22:00 | AAPL | Stock | 6.2182 | 6.2182 | 6.2182 | 6.2182 | 2800.0 |
| 2008-01-14 07:23:00 | AAPL | Stock | 6.2211 | 6.2211 | 6.2175 | 6.2175 | 37352.0 |
| 2008-01-14 07:24:00 | AAPL | Stock | 6.2161 | 6.2161 | 6.2143 | 6.2143 | 30520.0 |
| 2008-01-14 07:25:00 | AAPL | Stock | 6.2143 | 6.2143 | 6.2143 | 6.2143 | 14000.0 |
| 2008-01-14 07:26:00 | AAPL | Stock | 6.2161 | 6.2179 | 6.2161 | 6.2179 | 41720.0 |
| 2008-01-14 07:28:00 | AAPL | Stock | 6.2161 | 6.2161 | 6.2143 | 6.2143 | 28000.0 |
| 2008-01-14 07:30:00 | AAPL | Stock | 6.225 | 6.225 | 6.225 | 6.225 | 22400.0 |
| 2008-01-14 07:31:00 | AAPL | Stock | 6.225 | 6.2279 | 6.225 | 6.2279 | 54600.0 |
| 2008-01-14 07:33:00 | AAPL | Stock | 6.2393 | 6.245 | 6.2271 | 6.2271 | 48020.0 |
| 2008-01-14 07:34:00 | AAPL | Stock | 6.2393 | 6.2493 | 6.2393 | 6.2493 | 69720.0 |
| 2008-01-14 07:35:00 | AAPL | Stock | 6.2643 | 6.275 | 6.2507 | 6.275 | 53200.0 |
| 2008-01-14 07:36:00 | AAPL | Stock | 6.275 | 6.2768 | 6.2671 | 6.2768 | 89600.0 |
| 2008-01-14 07:37:00 | AAPL | Stock | 6.2707 | 6.2707 | 6.2707 | 6.2707 | 8400.0 |
| 2008-01-14 07:38:00 | AAPL | Stock | 6.2689 | 6.3 | 6.2679 | 6.2921 | 106400.0 |
| 2008-01-14 07:39:00 | AAPL | Stock | 6.2893 | 6.2911 | 6.2807 | 6.2807 | 16800.0 |
| 2008-01-14 07:40:00 | AAPL | Stock | 6.2857 | 6.2857 | 6.2857 | 6.2857 | 8400.0 |
| 2008-01-14 07:41:00 | AAPL | Stock | 6.285 | 6.285 | 6.285 | 6.285 | 5600.0 |
| 2008-01-14 07:42:00 | AAPL | Stock | 6.285 | 6.285 | 6.2839 | 6.2839 | 35560.0 |
| 2008-01-14 07:43:00 | AAPL | Stock | 6.2889 | 6.2904 | 6.285 | 6.285 | 176316.0 |
> showing 50 of 1,001,888 rows — these rows as CSV