PREVIEW / stock_1min / 2011-11-02
file: by_date/stock_1min/2011/2011-11-02.parquet size: 13.3 MB rows: 995,784 symbols: 2,826
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-11-02 04:03:00 | AAPL | Stock | 14.2686 | 14.2686 | 14.2686 | 14.2686 | 5600.0 |
| 2011-11-02 04:06:00 | AAPL | Stock | 14.2786 | 14.2854 | 14.2786 | 14.2854 | 8400.0 |
| 2011-11-02 04:09:00 | AAPL | Stock | 14.2996 | 14.2996 | 14.2996 | 14.2996 | 2800.0 |
| 2011-11-02 04:13:00 | AAPL | Stock | 14.3036 | 14.3036 | 14.3036 | 14.3036 | 2800.0 |
| 2011-11-02 04:22:00 | AAPL | Stock | 14.315 | 14.315 | 14.315 | 14.315 | 8400.0 |
| 2011-11-02 04:48:00 | AAPL | Stock | 14.2875 | 14.2875 | 14.2875 | 14.2875 | 2800.0 |
| 2011-11-02 04:56:00 | AAPL | Stock | 14.3125 | 14.3125 | 14.3125 | 14.3125 | 14000.0 |
| 2011-11-02 05:01:00 | AAPL | Stock | 14.3125 | 14.3125 | 14.3125 | 14.3125 | 2800.0 |
| 2011-11-02 05:14:00 | AAPL | Stock | 14.2964 | 14.2964 | 14.2964 | 14.2964 | 5600.0 |
| 2011-11-02 05:25:00 | AAPL | Stock | 14.2857 | 14.2857 | 14.2857 | 14.2857 | 8400.0 |
| 2011-11-02 05:34:00 | AAPL | Stock | 14.2732 | 14.2732 | 14.2732 | 14.2732 | 8400.0 |
| 2011-11-02 05:40:00 | AAPL | Stock | 14.25 | 14.25 | 14.25 | 14.25 | 2800.0 |
| 2011-11-02 05:52:00 | AAPL | Stock | 14.2179 | 14.2179 | 14.2179 | 14.2179 | 2800.0 |
| 2011-11-02 05:53:00 | AAPL | Stock | 14.2143 | 14.2143 | 14.2143 | 14.2143 | 8400.0 |
| 2011-11-02 05:55:00 | AAPL | Stock | 14.2286 | 14.2286 | 14.2286 | 14.2286 | 16800.0 |
| 2011-11-02 06:04:00 | AAPL | Stock | 14.2214 | 14.2214 | 14.2214 | 14.2214 | 2800.0 |
| 2011-11-02 06:14:00 | AAPL | Stock | 14.2286 | 14.2286 | 14.2286 | 14.2286 | 8400.0 |
| 2011-11-02 06:15:00 | AAPL | Stock | 14.2286 | 14.2286 | 14.2286 | 14.2286 | 2800.0 |
| 2011-11-02 06:50:00 | AAPL | Stock | 14.225 | 14.225 | 14.225 | 14.225 | 2800.0 |
| 2011-11-02 07:02:00 | AAPL | Stock | 14.2286 | 14.2286 | 14.2286 | 14.2286 | 2800.0 |
| 2011-11-02 07:06:00 | AAPL | Stock | 14.2314 | 14.2321 | 14.2314 | 14.2321 | 5600.0 |
| 2011-11-02 07:16:00 | AAPL | Stock | 14.2321 | 14.2321 | 14.2321 | 14.2321 | 19600.0 |
| 2011-11-02 07:27:00 | AAPL | Stock | 14.2436 | 14.25 | 14.2436 | 14.25 | 40880.0 |
| 2011-11-02 07:28:00 | AAPL | Stock | 14.2679 | 14.2679 | 14.2679 | 14.2679 | 27160.0 |
| 2011-11-02 07:34:00 | AAPL | Stock | 14.2679 | 14.2679 | 14.2679 | 14.2679 | 2800.0 |
| 2011-11-02 07:40:00 | AAPL | Stock | 14.25 | 14.25 | 14.25 | 14.25 | 15960.0 |
| 2011-11-02 07:42:00 | AAPL | Stock | 14.25 | 14.25 | 14.25 | 14.25 | 12880.0 |
| 2011-11-02 07:47:00 | AAPL | Stock | 14.2611 | 14.2611 | 14.2611 | 14.2611 | 2800.0 |
| 2011-11-02 07:48:00 | AAPL | Stock | 14.2625 | 14.2679 | 14.2625 | 14.2679 | 8400.0 |
| 2011-11-02 07:50:00 | AAPL | Stock | 14.2679 | 14.2857 | 14.2679 | 14.2843 | 25200.0 |
| 2011-11-02 07:52:00 | AAPL | Stock | 14.2857 | 14.2857 | 14.2857 | 14.2857 | 10920.0 |
| 2011-11-02 07:53:00 | AAPL | Stock | 14.275 | 14.2786 | 14.275 | 14.2786 | 5600.0 |
| 2011-11-02 07:54:00 | AAPL | Stock | 14.2682 | 14.2682 | 14.2682 | 14.2682 | 2800.0 |
| 2011-11-02 07:55:00 | AAPL | Stock | 14.2679 | 14.2679 | 14.2679 | 14.2679 | 8400.0 |
| 2011-11-02 08:00:00 | AAPL | Stock | 14.25 | 14.2679 | 14.25 | 14.2604 | 35000.0 |
| 2011-11-02 08:01:00 | AAPL | Stock | 14.2604 | 14.2607 | 14.2557 | 14.2557 | 23800.0 |
| 2011-11-02 08:02:00 | AAPL | Stock | 14.2554 | 14.2654 | 14.2536 | 14.2654 | 19600.0 |
| 2011-11-02 08:03:00 | AAPL | Stock | 14.2636 | 14.2654 | 14.2518 | 14.2518 | 17948.0 |
| 2011-11-02 08:04:00 | AAPL | Stock | 14.2614 | 14.2614 | 14.2614 | 14.2614 | 4200.0 |
| 2011-11-02 08:06:00 | AAPL | Stock | 14.2575 | 14.2639 | 14.2571 | 14.2639 | 22400.0 |
| 2011-11-02 08:07:00 | AAPL | Stock | 14.2639 | 14.2679 | 14.2639 | 14.2679 | 56000.0 |
| 2011-11-02 08:08:00 | AAPL | Stock | 14.2732 | 14.2743 | 14.2689 | 14.2739 | 52584.0 |
| 2011-11-02 08:09:00 | AAPL | Stock | 14.2714 | 14.2743 | 14.2689 | 14.2732 | 19600.0 |
| 2011-11-02 08:10:00 | AAPL | Stock | 14.2736 | 14.2736 | 14.2736 | 14.2736 | 5600.0 |
| 2011-11-02 08:11:00 | AAPL | Stock | 14.2739 | 14.2739 | 14.2718 | 14.2718 | 5600.0 |
| 2011-11-02 08:12:00 | AAPL | Stock | 14.2689 | 14.2689 | 14.2689 | 14.2689 | 40964.0 |
| 2011-11-02 08:13:00 | AAPL | Stock | 14.2664 | 14.2689 | 14.2657 | 14.2657 | 19740.0 |
| 2011-11-02 08:14:00 | AAPL | Stock | 14.2654 | 14.2654 | 14.2643 | 14.2643 | 32088.0 |
| 2011-11-02 08:15:00 | AAPL | Stock | 14.2661 | 14.2768 | 14.2596 | 14.2604 | 150696.0 |
| 2011-11-02 08:16:00 | AAPL | Stock | 14.2607 | 14.2607 | 14.2607 | 14.2607 | 16800.0 |
> showing 50 of 995,784 rows — these rows as CSV