PREVIEW / stock_1min / 2011-07-26
file: by_date/stock_1min/2011/2011-07-26.parquet size: 12.9 MB rows: 958,622 symbols: 2,851
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 |
|---|---|---|---|---|---|---|---|
| 2011-07-26 04:03:00 | AAPL | Stock | 14.2754 | 14.2754 | 14.2754 | 14.2754 | 2800.0 |
| 2011-07-26 04:04:00 | AAPL | Stock | 14.2711 | 14.2711 | 14.2711 | 14.2711 | 2800.0 |
| 2011-07-26 04:09:00 | AAPL | Stock | 14.2707 | 14.2707 | 14.2707 | 14.2707 | 2800.0 |
| 2011-07-26 04:11:00 | AAPL | Stock | 14.2729 | 14.2729 | 14.2729 | 14.2729 | 2800.0 |
| 2011-07-26 04:20:00 | AAPL | Stock | 14.2643 | 14.2643 | 14.2643 | 14.2643 | 2800.0 |
| 2011-07-26 04:25:00 | AAPL | Stock | 14.2468 | 14.2468 | 14.2468 | 14.2468 | 2800.0 |
| 2011-07-26 04:27:00 | AAPL | Stock | 14.2486 | 14.2486 | 14.2179 | 14.2179 | 14000.0 |
| 2011-07-26 04:37:00 | AAPL | Stock | 14.2386 | 14.2386 | 14.2386 | 14.2386 | 2800.0 |
| 2011-07-26 04:59:00 | AAPL | Stock | 14.2386 | 14.2414 | 14.2289 | 14.2411 | 19600.0 |
| 2011-07-26 05:00:00 | AAPL | Stock | 14.2382 | 14.2389 | 14.2382 | 14.2389 | 11200.0 |
| 2011-07-26 05:03:00 | AAPL | Stock | 14.2382 | 14.2382 | 14.2382 | 14.2382 | 8400.0 |
| 2011-07-26 05:05:00 | AAPL | Stock | 14.2393 | 14.2393 | 14.2393 | 14.2393 | 2800.0 |
| 2011-07-26 05:07:00 | AAPL | Stock | 14.2289 | 14.2289 | 14.2289 | 14.2289 | 2800.0 |
| 2011-07-26 05:11:00 | AAPL | Stock | 14.2293 | 14.2293 | 14.2293 | 14.2293 | 5600.0 |
| 2011-07-26 05:17:00 | AAPL | Stock | 14.2293 | 14.2293 | 14.2289 | 14.2289 | 7084.0 |
| 2011-07-26 05:55:00 | AAPL | Stock | 14.2321 | 14.2321 | 14.2321 | 14.2321 | 4452.0 |
| 2011-07-26 06:03:00 | AAPL | Stock | 14.2464 | 14.2464 | 14.2464 | 14.2464 | 4452.0 |
| 2011-07-26 06:21:00 | AAPL | Stock | 14.2482 | 14.2482 | 14.2482 | 14.2482 | 5600.0 |
| 2011-07-26 06:23:00 | AAPL | Stock | 14.25 | 14.25 | 14.25 | 14.25 | 4452.0 |
| 2011-07-26 06:25:00 | AAPL | Stock | 14.25 | 14.2625 | 14.25 | 14.2625 | 13748.0 |
| 2011-07-26 06:26:00 | AAPL | Stock | 14.2614 | 14.2614 | 14.2614 | 14.2614 | 14000.0 |
| 2011-07-26 06:28:00 | AAPL | Stock | 14.2614 | 14.2614 | 14.2614 | 14.2614 | 5600.0 |
| 2011-07-26 06:57:00 | AAPL | Stock | 14.2446 | 14.2464 | 14.2446 | 14.2464 | 9800.0 |
| 2011-07-26 07:00:00 | AAPL | Stock | 14.2496 | 14.2532 | 14.2496 | 14.2532 | 9800.0 |
| 2011-07-26 07:01:00 | AAPL | Stock | 14.2596 | 14.2643 | 14.2589 | 14.2643 | 40040.0 |
| 2011-07-26 07:02:00 | AAPL | Stock | 14.2636 | 14.2636 | 14.2636 | 14.2636 | 7000.0 |
| 2011-07-26 07:03:00 | AAPL | Stock | 14.2589 | 14.2589 | 14.2589 | 14.2589 | 6664.0 |
| 2011-07-26 07:07:00 | AAPL | Stock | 14.2607 | 14.2607 | 14.2589 | 14.2589 | 11480.0 |
| 2011-07-26 07:08:00 | AAPL | Stock | 14.2675 | 14.2804 | 14.2675 | 14.2711 | 29400.0 |
| 2011-07-26 07:09:00 | AAPL | Stock | 14.2732 | 14.2771 | 14.2625 | 14.2643 | 33600.0 |
| 2011-07-26 07:10:00 | AAPL | Stock | 14.2607 | 14.2607 | 14.2607 | 14.2607 | 2800.0 |
| 2011-07-26 07:11:00 | AAPL | Stock | 14.2625 | 14.2625 | 14.2625 | 14.2625 | 5600.0 |
| 2011-07-26 07:12:00 | AAPL | Stock | 14.2571 | 14.2571 | 14.2571 | 14.2571 | 26712.0 |
| 2011-07-26 07:13:00 | AAPL | Stock | 14.2664 | 14.2664 | 14.2664 | 14.2664 | 2800.0 |
| 2011-07-26 07:14:00 | AAPL | Stock | 14.2664 | 14.2664 | 14.2664 | 14.2664 | 50400.0 |
| 2011-07-26 07:18:00 | AAPL | Stock | 14.2664 | 14.2664 | 14.2664 | 14.2664 | 5600.0 |
| 2011-07-26 07:19:00 | AAPL | Stock | 14.2661 | 14.2661 | 14.2661 | 14.2661 | 14000.0 |
| 2011-07-26 07:20:00 | AAPL | Stock | 14.26 | 14.26 | 14.26 | 14.26 | 11200.0 |
| 2011-07-26 07:21:00 | AAPL | Stock | 14.26 | 14.26 | 14.26 | 14.26 | 42000.0 |
| 2011-07-26 07:23:00 | AAPL | Stock | 14.2618 | 14.2618 | 14.2607 | 14.2607 | 25200.0 |
| 2011-07-26 07:24:00 | AAPL | Stock | 14.2679 | 14.2679 | 14.2679 | 14.2679 | 8400.0 |
| 2011-07-26 07:25:00 | AAPL | Stock | 14.2611 | 14.2611 | 14.2611 | 14.2611 | 14000.0 |
| 2011-07-26 07:29:00 | AAPL | Stock | 14.2639 | 14.2639 | 14.2625 | 14.2625 | 11200.0 |
| 2011-07-26 07:31:00 | AAPL | Stock | 14.2679 | 14.2786 | 14.2679 | 14.2768 | 56000.0 |
| 2011-07-26 07:32:00 | AAPL | Stock | 14.2818 | 14.2818 | 14.2675 | 14.2675 | 42000.0 |
| 2011-07-26 07:33:00 | AAPL | Stock | 14.2671 | 14.2671 | 14.2671 | 14.2671 | 2800.0 |
| 2011-07-26 07:34:00 | AAPL | Stock | 14.2646 | 14.2646 | 14.2643 | 14.2643 | 28000.0 |
| 2011-07-26 07:35:00 | AAPL | Stock | 14.2639 | 14.2714 | 14.2639 | 14.2714 | 31136.0 |
| 2011-07-26 07:37:00 | AAPL | Stock | 14.2786 | 14.2786 | 14.2786 | 14.2786 | 2800.0 |
| 2011-07-26 07:38:00 | AAPL | Stock | 14.2768 | 14.2768 | 14.2768 | 14.2768 | 5600.0 |
> showing 50 of 958,622 rows — these rows as CSV