PREVIEW / stock_1min / 2009-11-13
file: by_date/stock_1min/2009/2009-11-13.parquet size: 12.3 MB rows: 934,333 symbols: 2,768
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 |
|---|---|---|---|---|---|---|---|
| 2009-11-13 05:23:00 | AAPL | Stock | 7.2411 | 7.2411 | 7.2232 | 7.2232 | 5600.0 |
| 2009-11-13 05:24:00 | AAPL | Stock | 7.215 | 7.215 | 7.215 | 7.215 | 7336.0 |
| 2009-11-13 05:33:00 | AAPL | Stock | 7.215 | 7.215 | 7.215 | 7.215 | 4872.0 |
| 2009-11-13 05:35:00 | AAPL | Stock | 7.2004 | 7.2004 | 7.1714 | 7.1714 | 11200.0 |
| 2009-11-13 05:36:00 | AAPL | Stock | 7.2004 | 7.2004 | 7.2004 | 7.2004 | 2800.0 |
| 2009-11-13 05:42:00 | AAPL | Stock | 7.2071 | 7.2071 | 7.2071 | 7.2071 | 2800.0 |
| 2009-11-13 06:03:00 | AAPL | Stock | 7.2146 | 7.2146 | 7.2146 | 7.2146 | 2800.0 |
| 2009-11-13 06:25:00 | AAPL | Stock | 7.2404 | 7.2404 | 7.2404 | 7.2404 | 2800.0 |
| 2009-11-13 07:03:00 | AAPL | Stock | 7.2429 | 7.2429 | 7.2429 | 7.2429 | 5600.0 |
| 2009-11-13 07:58:00 | AAPL | Stock | 7.2364 | 7.2364 | 7.2364 | 7.2364 | 8400.0 |
| 2009-11-13 08:01:00 | AAPL | Stock | 7.2321 | 7.2411 | 7.2321 | 7.2332 | 58660.0 |
| 2009-11-13 08:02:00 | AAPL | Stock | 7.2339 | 7.2404 | 7.2339 | 7.2404 | 54600.0 |
| 2009-11-13 08:04:00 | AAPL | Stock | 7.2364 | 7.2364 | 7.2357 | 7.2357 | 42000.0 |
| 2009-11-13 08:05:00 | AAPL | Stock | 7.2361 | 7.2361 | 7.2268 | 7.2268 | 56000.0 |
| 2009-11-13 08:06:00 | AAPL | Stock | 7.2314 | 7.2321 | 7.2314 | 7.2321 | 7700.0 |
| 2009-11-13 08:07:00 | AAPL | Stock | 7.2257 | 7.2318 | 7.225 | 7.2314 | 25172.0 |
| 2009-11-13 08:08:00 | AAPL | Stock | 7.23 | 7.2314 | 7.23 | 7.2314 | 16296.0 |
| 2009-11-13 08:09:00 | AAPL | Stock | 7.2321 | 7.2321 | 7.2321 | 7.2321 | 4200.0 |
| 2009-11-13 08:14:00 | AAPL | Stock | 7.2325 | 7.2357 | 7.2318 | 7.2354 | 44184.0 |
| 2009-11-13 08:15:00 | AAPL | Stock | 7.235 | 7.2357 | 7.235 | 7.2357 | 12516.0 |
| 2009-11-13 08:16:00 | AAPL | Stock | 7.2357 | 7.2357 | 7.2357 | 7.2357 | 2800.0 |
| 2009-11-13 08:17:00 | AAPL | Stock | 7.2321 | 7.2321 | 7.2321 | 7.2321 | 2800.0 |
| 2009-11-13 08:18:00 | AAPL | Stock | 7.2354 | 7.2354 | 7.2329 | 7.2329 | 5992.0 |
| 2009-11-13 08:19:00 | AAPL | Stock | 7.2329 | 7.2329 | 7.2329 | 7.2329 | 9800.0 |
| 2009-11-13 08:23:00 | AAPL | Stock | 7.2357 | 7.2393 | 7.2357 | 7.2393 | 106400.0 |
| 2009-11-13 08:24:00 | AAPL | Stock | 7.24 | 7.2429 | 7.24 | 7.2411 | 36400.0 |
| 2009-11-13 08:25:00 | AAPL | Stock | 7.2429 | 7.2429 | 7.2429 | 7.2429 | 4200.0 |
| 2009-11-13 08:27:00 | AAPL | Stock | 7.2429 | 7.2429 | 7.2429 | 7.2429 | 25060.0 |
| 2009-11-13 08:30:00 | AAPL | Stock | 7.2429 | 7.2443 | 7.2429 | 7.2443 | 16800.0 |
| 2009-11-13 08:31:00 | AAPL | Stock | 7.2443 | 7.2482 | 7.2443 | 7.2482 | 43400.0 |
| 2009-11-13 08:32:00 | AAPL | Stock | 7.2482 | 7.2554 | 7.2482 | 7.2554 | 100660.0 |
| 2009-11-13 08:33:00 | AAPL | Stock | 7.2532 | 7.2536 | 7.2532 | 7.2536 | 8400.0 |
| 2009-11-13 08:34:00 | AAPL | Stock | 7.2536 | 7.2554 | 7.2536 | 7.2554 | 21000.0 |
| 2009-11-13 08:35:00 | AAPL | Stock | 7.2554 | 7.2604 | 7.2554 | 7.2604 | 100044.0 |
| 2009-11-13 08:36:00 | AAPL | Stock | 7.26 | 7.2607 | 7.2589 | 7.2607 | 22400.0 |
| 2009-11-13 08:37:00 | AAPL | Stock | 7.2607 | 7.2643 | 7.2607 | 7.2629 | 85904.0 |
| 2009-11-13 08:38:00 | AAPL | Stock | 7.2639 | 7.2707 | 7.2629 | 7.2704 | 67200.0 |
| 2009-11-13 08:39:00 | AAPL | Stock | 7.2646 | 7.2696 | 7.2646 | 7.2696 | 124236.0 |
| 2009-11-13 08:40:00 | AAPL | Stock | 7.2707 | 7.2757 | 7.2696 | 7.2696 | 105700.0 |
| 2009-11-13 08:41:00 | AAPL | Stock | 7.2707 | 7.2711 | 7.2679 | 7.2711 | 34720.0 |
| 2009-11-13 08:42:00 | AAPL | Stock | 7.2682 | 7.2682 | 7.2679 | 7.2679 | 8400.0 |
| 2009-11-13 08:43:00 | AAPL | Stock | 7.2661 | 7.2661 | 7.265 | 7.265 | 39424.0 |
| 2009-11-13 08:44:00 | AAPL | Stock | 7.265 | 7.265 | 7.2593 | 7.2593 | 128856.0 |
| 2009-11-13 08:45:00 | AAPL | Stock | 7.2621 | 7.2643 | 7.2614 | 7.2643 | 11200.0 |
| 2009-11-13 08:46:00 | AAPL | Stock | 7.2621 | 7.2621 | 7.2607 | 7.2607 | 29400.0 |
| 2009-11-13 08:47:00 | AAPL | Stock | 7.2625 | 7.2679 | 7.2621 | 7.2621 | 208488.0 |
| 2009-11-13 08:48:00 | AAPL | Stock | 7.2679 | 7.2679 | 7.2675 | 7.2679 | 47600.0 |
| 2009-11-13 08:49:00 | AAPL | Stock | 7.2636 | 7.2636 | 7.2618 | 7.2625 | 72800.0 |
| 2009-11-13 08:50:00 | AAPL | Stock | 7.2629 | 7.2629 | 7.2629 | 7.2629 | 2800.0 |
| 2009-11-13 08:52:00 | AAPL | Stock | 7.2632 | 7.2632 | 7.2607 | 7.2625 | 30800.0 |
> showing 50 of 934,333 rows — these rows as CSV