PREVIEW / stock_1min / 2013-07-22
file: by_date/stock_1min/2013/2013-07-22.parquet size: 13.4 MB rows: 981,295 symbols: 2,844
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 |
|---|---|---|---|---|---|---|---|
| 2013-07-22 05:14:00 | AAPL | Stock | 15.2039 | 15.2039 | 15.2039 | 15.2039 | 2800.0 |
| 2013-07-22 05:51:00 | AAPL | Stock | 15.2086 | 15.2086 | 15.2086 | 15.2086 | 2800.0 |
| 2013-07-22 06:41:00 | AAPL | Stock | 15.2093 | 15.2093 | 15.2089 | 15.2089 | 11900.0 |
| 2013-07-22 06:50:00 | AAPL | Stock | 15.2032 | 15.2082 | 15.2032 | 15.2082 | 5600.0 |
| 2013-07-22 06:51:00 | AAPL | Stock | 15.2082 | 15.2082 | 15.2082 | 15.2082 | 8400.0 |
| 2013-07-22 07:03:00 | AAPL | Stock | 15.1893 | 15.1893 | 15.1893 | 15.1893 | 12880.0 |
| 2013-07-22 07:17:00 | AAPL | Stock | 15.2143 | 15.2143 | 15.2143 | 15.2143 | 2800.0 |
| 2013-07-22 07:21:00 | AAPL | Stock | 15.2143 | 15.2143 | 15.2143 | 15.2143 | 5600.0 |
| 2013-07-22 07:22:00 | AAPL | Stock | 15.1964 | 15.1964 | 15.1964 | 15.1964 | 5600.0 |
| 2013-07-22 07:36:00 | AAPL | Stock | 15.2086 | 15.2196 | 15.2086 | 15.2196 | 20160.0 |
| 2013-07-22 07:37:00 | AAPL | Stock | 15.2136 | 15.2196 | 15.2107 | 15.2196 | 17920.0 |
| 2013-07-22 07:42:00 | AAPL | Stock | 15.2207 | 15.2207 | 15.2207 | 15.2207 | 2800.0 |
| 2013-07-22 07:43:00 | AAPL | Stock | 15.2214 | 15.2321 | 15.2214 | 15.2321 | 44520.0 |
| 2013-07-22 07:44:00 | AAPL | Stock | 15.2382 | 15.25 | 15.2382 | 15.25 | 16800.0 |
| 2013-07-22 07:45:00 | AAPL | Stock | 15.2514 | 15.2571 | 15.2514 | 15.2571 | 11200.0 |
| 2013-07-22 07:48:00 | AAPL | Stock | 15.2625 | 15.27 | 15.2625 | 15.27 | 16800.0 |
| 2013-07-22 07:51:00 | AAPL | Stock | 15.2657 | 15.2657 | 15.2646 | 15.2657 | 11200.0 |
| 2013-07-22 07:53:00 | AAPL | Stock | 15.2643 | 15.2643 | 15.2643 | 15.2643 | 2800.0 |
| 2013-07-22 07:54:00 | AAPL | Stock | 15.2575 | 15.2575 | 15.2571 | 15.2571 | 19600.0 |
| 2013-07-22 07:57:00 | AAPL | Stock | 15.2514 | 15.2514 | 15.2486 | 15.2486 | 36400.0 |
| 2013-07-22 07:58:00 | AAPL | Stock | 15.2482 | 15.2604 | 15.2482 | 15.2604 | 42196.0 |
| 2013-07-22 07:59:00 | AAPL | Stock | 15.2607 | 15.2607 | 15.2582 | 15.2582 | 89600.0 |
| 2013-07-22 08:00:00 | AAPL | Stock | 15.2468 | 15.2582 | 15.2143 | 15.25 | 63980.0 |
| 2013-07-22 08:01:00 | AAPL | Stock | 15.2518 | 15.2525 | 15.25 | 15.25 | 37240.0 |
| 2013-07-22 08:02:00 | AAPL | Stock | 15.25 | 15.2607 | 15.25 | 15.2607 | 21000.0 |
| 2013-07-22 08:03:00 | AAPL | Stock | 15.2507 | 15.2507 | 15.25 | 15.25 | 16436.0 |
| 2013-07-22 08:04:00 | AAPL | Stock | 15.2411 | 15.2411 | 15.2386 | 15.2386 | 27860.0 |
| 2013-07-22 08:05:00 | AAPL | Stock | 15.2361 | 15.2361 | 15.2361 | 15.2361 | 8400.0 |
| 2013-07-22 08:07:00 | AAPL | Stock | 15.2321 | 15.2321 | 15.225 | 15.225 | 75600.0 |
| 2013-07-22 08:08:00 | AAPL | Stock | 15.2268 | 15.2321 | 15.2221 | 15.2314 | 61320.0 |
| 2013-07-22 08:09:00 | AAPL | Stock | 15.2268 | 15.2268 | 15.2186 | 15.2186 | 42000.0 |
| 2013-07-22 08:10:00 | AAPL | Stock | 15.2232 | 15.2232 | 15.2214 | 15.2214 | 5600.0 |
| 2013-07-22 08:11:00 | AAPL | Stock | 15.2261 | 15.2261 | 15.2193 | 15.2193 | 28000.0 |
| 2013-07-22 08:12:00 | AAPL | Stock | 15.2182 | 15.2268 | 15.2182 | 15.2261 | 62188.0 |
| 2013-07-22 08:13:00 | AAPL | Stock | 15.23 | 15.2318 | 15.2286 | 15.2318 | 39200.0 |
| 2013-07-22 08:15:00 | AAPL | Stock | 15.2321 | 15.2321 | 15.23 | 15.23 | 5600.0 |
| 2013-07-22 08:16:00 | AAPL | Stock | 15.2393 | 15.2393 | 15.2325 | 15.2325 | 11200.0 |
| 2013-07-22 08:18:00 | AAPL | Stock | 15.2393 | 15.2393 | 15.2375 | 15.2375 | 11200.0 |
| 2013-07-22 08:19:00 | AAPL | Stock | 15.2357 | 15.2357 | 15.2357 | 15.2357 | 2800.0 |
| 2013-07-22 08:20:00 | AAPL | Stock | 15.2393 | 15.2393 | 15.2393 | 15.2393 | 2800.0 |
| 2013-07-22 08:21:00 | AAPL | Stock | 15.2393 | 15.2461 | 15.2393 | 15.2461 | 28196.0 |
| 2013-07-22 08:22:00 | AAPL | Stock | 15.2479 | 15.2482 | 15.2321 | 15.2321 | 97804.0 |
| 2013-07-22 08:23:00 | AAPL | Stock | 15.2354 | 15.2357 | 15.2343 | 15.2357 | 16800.0 |
| 2013-07-22 08:24:00 | AAPL | Stock | 15.2357 | 15.2357 | 15.2343 | 15.2354 | 14000.0 |
| 2013-07-22 08:25:00 | AAPL | Stock | 15.2286 | 15.2286 | 15.2261 | 15.2282 | 26600.0 |
| 2013-07-22 08:26:00 | AAPL | Stock | 15.2286 | 15.2286 | 15.2261 | 15.2261 | 14000.0 |
| 2013-07-22 08:28:00 | AAPL | Stock | 15.2311 | 15.2311 | 15.2232 | 15.225 | 25200.0 |
| 2013-07-22 08:29:00 | AAPL | Stock | 15.2232 | 15.2311 | 15.2232 | 15.2236 | 21700.0 |
| 2013-07-22 08:30:00 | AAPL | Stock | 15.2307 | 15.2321 | 15.2307 | 15.2321 | 46200.0 |
| 2013-07-22 08:32:00 | AAPL | Stock | 15.2329 | 15.2329 | 15.2321 | 15.2329 | 14000.0 |
> showing 50 of 981,295 rows — these rows as CSV