PREVIEW / stock_1min / 2008-08-12
file: by_date/stock_1min/2008/2008-08-12.parquet size: 12.8 MB rows: 1,034,432 symbols: 2,709
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-08-12 06:36:00 | AAPL | Stock | 6.18 | 6.18 | 6.18 | 6.18 | 5600.0 |
| 2008-08-12 06:54:00 | AAPL | Stock | 6.1854 | 6.1854 | 6.1854 | 6.1854 | 5600.0 |
| 2008-08-12 07:03:00 | AAPL | Stock | 6.2043 | 6.2043 | 6.2043 | 6.2043 | 12600.0 |
| 2008-08-12 07:09:00 | AAPL | Stock | 6.1961 | 6.1961 | 6.1961 | 6.1961 | 5600.0 |
| 2008-08-12 07:13:00 | AAPL | Stock | 6.1964 | 6.1964 | 6.1964 | 6.1964 | 2800.0 |
| 2008-08-12 07:14:00 | AAPL | Stock | 6.1964 | 6.1964 | 6.1964 | 6.1964 | 5600.0 |
| 2008-08-12 07:18:00 | AAPL | Stock | 6.1993 | 6.1993 | 6.1993 | 6.1993 | 2800.0 |
| 2008-08-12 07:19:00 | AAPL | Stock | 6.1789 | 6.1789 | 6.1789 | 6.1789 | 2800.0 |
| 2008-08-12 07:20:00 | AAPL | Stock | 6.2054 | 6.2054 | 6.2054 | 6.2054 | 5600.0 |
| 2008-08-12 07:21:00 | AAPL | Stock | 6.2054 | 6.2057 | 6.2054 | 6.2057 | 5600.0 |
| 2008-08-12 07:22:00 | AAPL | Stock | 6.2182 | 6.2182 | 6.2182 | 6.2182 | 2800.0 |
| 2008-08-12 07:23:00 | AAPL | Stock | 6.2182 | 6.2254 | 6.2182 | 6.2196 | 16800.0 |
| 2008-08-12 07:24:00 | AAPL | Stock | 6.2286 | 6.2286 | 6.2286 | 6.2286 | 5600.0 |
| 2008-08-12 07:26:00 | AAPL | Stock | 6.2307 | 6.2339 | 6.2282 | 6.2339 | 44800.0 |
| 2008-08-12 07:27:00 | AAPL | Stock | 6.2343 | 6.235 | 6.2339 | 6.2339 | 231308.0 |
| 2008-08-12 07:28:00 | AAPL | Stock | 6.2339 | 6.2339 | 6.2339 | 6.2339 | 11200.0 |
| 2008-08-12 07:29:00 | AAPL | Stock | 6.2357 | 6.2461 | 6.2357 | 6.2461 | 65744.0 |
| 2008-08-12 07:30:00 | AAPL | Stock | 6.2496 | 6.2496 | 6.2496 | 6.2496 | 5600.0 |
| 2008-08-12 07:34:00 | AAPL | Stock | 6.2539 | 6.2546 | 6.25 | 6.25 | 130564.0 |
| 2008-08-12 07:35:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 39200.0 |
| 2008-08-12 07:37:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 8540.0 |
| 2008-08-12 07:40:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 36260.0 |
| 2008-08-12 07:41:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 15540.0 |
| 2008-08-12 07:43:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 95312.0 |
| 2008-08-12 07:51:00 | AAPL | Stock | 6.2339 | 6.2339 | 6.2339 | 6.2339 | 30800.0 |
| 2008-08-12 07:54:00 | AAPL | Stock | 6.2343 | 6.2343 | 6.2343 | 6.2343 | 33600.0 |
| 2008-08-12 07:56:00 | AAPL | Stock | 6.2339 | 6.2339 | 6.2339 | 6.2339 | 33600.0 |
| 2008-08-12 08:00:00 | AAPL | Stock | 6.2443 | 6.2443 | 6.2196 | 6.2321 | 208096.0 |
| 2008-08-12 08:01:00 | AAPL | Stock | 6.2321 | 6.2321 | 6.2271 | 6.2271 | 26264.0 |
| 2008-08-12 08:02:00 | AAPL | Stock | 6.2304 | 6.2321 | 6.2257 | 6.2321 | 28700.0 |
| 2008-08-12 08:03:00 | AAPL | Stock | 6.2246 | 6.225 | 6.2232 | 6.2232 | 22400.0 |
| 2008-08-12 08:04:00 | AAPL | Stock | 6.2232 | 6.225 | 6.2171 | 6.2171 | 123200.0 |
| 2008-08-12 08:05:00 | AAPL | Stock | 6.2196 | 6.2225 | 6.2196 | 6.2196 | 36400.0 |
| 2008-08-12 08:06:00 | AAPL | Stock | 6.2196 | 6.2232 | 6.2196 | 6.2232 | 25200.0 |
| 2008-08-12 08:07:00 | AAPL | Stock | 6.2232 | 6.2232 | 6.2232 | 6.2232 | 14000.0 |
| 2008-08-12 08:08:00 | AAPL | Stock | 6.225 | 6.2261 | 6.225 | 6.2261 | 42000.0 |
| 2008-08-12 08:09:00 | AAPL | Stock | 6.2261 | 6.2261 | 6.2246 | 6.2246 | 95340.0 |
| 2008-08-12 08:11:00 | AAPL | Stock | 6.2261 | 6.2268 | 6.2257 | 6.2257 | 8400.0 |
| 2008-08-12 08:12:00 | AAPL | Stock | 6.2286 | 6.2286 | 6.2286 | 6.2286 | 4228.0 |
| 2008-08-12 08:13:00 | AAPL | Stock | 6.2286 | 6.2286 | 6.2286 | 6.2286 | 3500.0 |
| 2008-08-12 08:14:00 | AAPL | Stock | 6.2289 | 6.2289 | 6.2289 | 6.2289 | 2800.0 |
| 2008-08-12 08:15:00 | AAPL | Stock | 6.2304 | 6.2304 | 6.2214 | 6.2214 | 127232.0 |
| 2008-08-12 08:16:00 | AAPL | Stock | 6.2254 | 6.2254 | 6.2254 | 6.2254 | 6580.0 |
| 2008-08-12 08:17:00 | AAPL | Stock | 6.2243 | 6.2243 | 6.2243 | 6.2243 | 2800.0 |
| 2008-08-12 08:18:00 | AAPL | Stock | 6.2221 | 6.2221 | 6.2207 | 6.2207 | 39620.0 |
| 2008-08-12 08:19:00 | AAPL | Stock | 6.2214 | 6.2214 | 6.2214 | 6.2214 | 8400.0 |
| 2008-08-12 08:20:00 | AAPL | Stock | 6.2204 | 6.2204 | 6.22 | 6.22 | 25200.0 |
| 2008-08-12 08:21:00 | AAPL | Stock | 6.2164 | 6.2207 | 6.2129 | 6.2129 | 133700.0 |
| 2008-08-12 08:22:00 | AAPL | Stock | 6.2207 | 6.2207 | 6.2193 | 6.2193 | 30800.0 |
| 2008-08-12 08:23:00 | AAPL | Stock | 6.2161 | 6.2161 | 6.2161 | 6.2161 | 6020.0 |
> showing 50 of 1,034,432 rows — these rows as CSV