PREVIEW / stock_1min / 2012-09-07
file: by_date/stock_1min/2012/2012-09-07.parquet size: 12.5 MB rows: 932,505 symbols: 2,792
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 |
|---|---|---|---|---|---|---|---|
| 2012-09-07 04:17:00 | AAPL | Stock | 24.2489 | 24.2489 | 24.2489 | 24.2489 | 2800.0 |
| 2012-09-07 04:31:00 | AAPL | Stock | 24.25 | 24.25 | 24.25 | 24.25 | 3500.0 |
| 2012-09-07 04:34:00 | AAPL | Stock | 24.2343 | 24.2343 | 24.2321 | 24.2321 | 8400.0 |
| 2012-09-07 04:47:00 | AAPL | Stock | 24.2411 | 24.2411 | 24.2411 | 24.2411 | 2800.0 |
| 2012-09-07 05:16:00 | AAPL | Stock | 24.2371 | 24.2375 | 24.2371 | 24.2375 | 5600.0 |
| 2012-09-07 06:32:00 | AAPL | Stock | 24.25 | 24.25 | 24.25 | 24.25 | 2800.0 |
| 2012-09-07 06:33:00 | AAPL | Stock | 24.2679 | 24.2679 | 24.2679 | 24.2679 | 5600.0 |
| 2012-09-07 06:42:00 | AAPL | Stock | 24.25 | 24.25 | 24.25 | 24.25 | 2800.0 |
| 2012-09-07 06:51:00 | AAPL | Stock | 24.2475 | 24.2475 | 24.2475 | 24.2475 | 5516.0 |
| 2012-09-07 06:52:00 | AAPL | Stock | 24.2475 | 24.2475 | 24.2475 | 24.2475 | 5600.0 |
| 2012-09-07 07:01:00 | AAPL | Stock | 24.2443 | 24.2464 | 24.2443 | 24.2464 | 11200.0 |
| 2012-09-07 07:02:00 | AAPL | Stock | 24.2321 | 24.2321 | 24.2257 | 24.2257 | 11060.0 |
| 2012-09-07 07:03:00 | AAPL | Stock | 24.2254 | 24.2254 | 24.2236 | 24.2236 | 8400.0 |
| 2012-09-07 07:04:00 | AAPL | Stock | 24.2339 | 24.2339 | 24.2339 | 24.2339 | 2800.0 |
| 2012-09-07 07:05:00 | AAPL | Stock | 24.2371 | 24.2371 | 24.2371 | 24.2371 | 5600.0 |
| 2012-09-07 07:06:00 | AAPL | Stock | 24.2429 | 24.2429 | 24.2429 | 24.2429 | 5600.0 |
| 2012-09-07 07:07:00 | AAPL | Stock | 24.2429 | 24.2429 | 24.2429 | 24.2429 | 16800.0 |
| 2012-09-07 07:10:00 | AAPL | Stock | 24.2343 | 24.2343 | 24.2343 | 24.2343 | 2800.0 |
| 2012-09-07 07:12:00 | AAPL | Stock | 24.2464 | 24.2464 | 24.2464 | 24.2464 | 8400.0 |
| 2012-09-07 07:13:00 | AAPL | Stock | 24.2393 | 24.2393 | 24.2393 | 24.2393 | 2800.0 |
| 2012-09-07 07:15:00 | AAPL | Stock | 24.24 | 24.2429 | 24.24 | 24.2411 | 11200.0 |
| 2012-09-07 07:17:00 | AAPL | Stock | 24.2386 | 24.2393 | 24.2357 | 24.2393 | 12180.0 |
| 2012-09-07 07:20:00 | AAPL | Stock | 24.2393 | 24.2429 | 24.2393 | 24.2429 | 24192.0 |
| 2012-09-07 07:21:00 | AAPL | Stock | 24.2336 | 24.2396 | 24.2336 | 24.2396 | 5600.0 |
| 2012-09-07 07:22:00 | AAPL | Stock | 24.2375 | 24.2375 | 24.2321 | 24.2321 | 5600.0 |
| 2012-09-07 07:23:00 | AAPL | Stock | 24.2321 | 24.2321 | 24.2321 | 24.2321 | 5600.0 |
| 2012-09-07 07:24:00 | AAPL | Stock | 24.2279 | 24.2279 | 24.2279 | 24.2279 | 7000.0 |
| 2012-09-07 07:26:00 | AAPL | Stock | 24.2232 | 24.2279 | 24.2182 | 24.2279 | 14700.0 |
| 2012-09-07 07:31:00 | AAPL | Stock | 24.2357 | 24.2357 | 24.2357 | 24.2357 | 2800.0 |
| 2012-09-07 07:35:00 | AAPL | Stock | 24.2286 | 24.2286 | 24.2286 | 24.2286 | 2800.0 |
| 2012-09-07 07:37:00 | AAPL | Stock | 24.2268 | 24.2268 | 24.2268 | 24.2268 | 25172.0 |
| 2012-09-07 07:38:00 | AAPL | Stock | 24.2221 | 24.2221 | 24.2221 | 24.2221 | 5600.0 |
| 2012-09-07 07:39:00 | AAPL | Stock | 24.2221 | 24.235 | 24.2221 | 24.235 | 8400.0 |
| 2012-09-07 07:43:00 | AAPL | Stock | 24.2232 | 24.2232 | 24.2232 | 24.2232 | 2800.0 |
| 2012-09-07 07:45:00 | AAPL | Stock | 24.2314 | 24.2321 | 24.2314 | 24.2321 | 56588.0 |
| 2012-09-07 07:46:00 | AAPL | Stock | 24.2321 | 24.2375 | 24.2321 | 24.2375 | 33600.0 |
| 2012-09-07 07:49:00 | AAPL | Stock | 24.2279 | 24.2321 | 24.2243 | 24.2321 | 14000.0 |
| 2012-09-07 07:50:00 | AAPL | Stock | 24.2179 | 24.2179 | 24.2179 | 24.2179 | 2800.0 |
| 2012-09-07 07:51:00 | AAPL | Stock | 24.2182 | 24.2182 | 24.2182 | 24.2182 | 2800.0 |
| 2012-09-07 07:52:00 | AAPL | Stock | 24.2232 | 24.2232 | 24.2232 | 24.2232 | 2800.0 |
| 2012-09-07 07:53:00 | AAPL | Stock | 24.2282 | 24.2321 | 24.225 | 24.225 | 12600.0 |
| 2012-09-07 07:54:00 | AAPL | Stock | 24.2286 | 24.2286 | 24.2286 | 24.2286 | 2800.0 |
| 2012-09-07 07:57:00 | AAPL | Stock | 24.2286 | 24.2286 | 24.2286 | 24.2286 | 2800.0 |
| 2012-09-07 07:59:00 | AAPL | Stock | 24.23 | 24.23 | 24.225 | 24.225 | 22400.0 |
| 2012-09-07 08:00:00 | AAPL | Stock | 24.2286 | 24.2429 | 24.1929 | 24.205 | 123984.0 |
| 2012-09-07 08:01:00 | AAPL | Stock | 24.1829 | 24.2054 | 24.1829 | 24.1904 | 30268.0 |
| 2012-09-07 08:02:00 | AAPL | Stock | 24.1921 | 24.2029 | 24.1921 | 24.1971 | 14000.0 |
| 2012-09-07 08:03:00 | AAPL | Stock | 24.2021 | 24.2025 | 24.1982 | 24.1982 | 14000.0 |
| 2012-09-07 08:04:00 | AAPL | Stock | 24.2025 | 24.2121 | 24.2021 | 24.2121 | 23660.0 |
| 2012-09-07 08:05:00 | AAPL | Stock | 24.2043 | 24.2089 | 24.2 | 24.2025 | 92400.0 |
> showing 50 of 932,505 rows — these rows as CSV