PREVIEW / stock_1min / 2014-03-28
file: by_date/stock_1min/2014/2014-03-28.parquet size: 14.4 MB rows: 1,056,261 symbols: 2,880
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 |
|---|---|---|---|---|---|---|---|
| 2014-03-28 04:38:00 | AAPL | Stock | 19.2657 | 19.2657 | 19.2657 | 19.2657 | 2800.0 |
| 2014-03-28 05:10:00 | AAPL | Stock | 19.2739 | 19.2739 | 19.2739 | 19.2739 | 2800.0 |
| 2014-03-28 05:42:00 | AAPL | Stock | 19.275 | 19.275 | 19.275 | 19.275 | 2800.0 |
| 2014-03-28 05:45:00 | AAPL | Stock | 19.2743 | 19.275 | 19.2743 | 19.275 | 28000.0 |
| 2014-03-28 05:46:00 | AAPL | Stock | 19.2782 | 19.2786 | 19.2782 | 19.2786 | 33600.0 |
| 2014-03-28 06:04:00 | AAPL | Stock | 19.2786 | 19.2857 | 19.2786 | 19.2857 | 27916.0 |
| 2014-03-28 06:17:00 | AAPL | Stock | 19.3121 | 19.3129 | 19.3121 | 19.3129 | 8400.0 |
| 2014-03-28 06:24:00 | AAPL | Stock | 19.3143 | 19.3143 | 19.3125 | 19.3125 | 14000.0 |
| 2014-03-28 06:44:00 | AAPL | Stock | 19.3214 | 19.3214 | 19.3214 | 19.3214 | 2800.0 |
| 2014-03-28 06:55:00 | AAPL | Stock | 19.3214 | 19.3214 | 19.3214 | 19.3214 | 2800.0 |
| 2014-03-28 06:56:00 | AAPL | Stock | 19.3125 | 19.3125 | 19.3125 | 19.3125 | 2800.0 |
| 2014-03-28 06:59:00 | AAPL | Stock | 19.3036 | 19.3036 | 19.2971 | 19.2971 | 8400.0 |
| 2014-03-28 07:00:00 | AAPL | Stock | 19.31 | 19.31 | 19.31 | 19.31 | 8400.0 |
| 2014-03-28 07:01:00 | AAPL | Stock | 19.3036 | 19.32 | 19.3036 | 19.3193 | 53760.0 |
| 2014-03-28 07:10:00 | AAPL | Stock | 19.29 | 19.29 | 19.29 | 19.29 | 2800.0 |
| 2014-03-28 07:15:00 | AAPL | Stock | 19.2946 | 19.2954 | 19.2879 | 19.2879 | 59780.0 |
| 2014-03-28 07:17:00 | AAPL | Stock | 19.2607 | 19.2607 | 19.2607 | 19.2607 | 2800.0 |
| 2014-03-28 07:20:00 | AAPL | Stock | 19.2768 | 19.2768 | 19.2768 | 19.2768 | 2800.0 |
| 2014-03-28 07:26:00 | AAPL | Stock | 19.2896 | 19.2896 | 19.2896 | 19.2896 | 2800.0 |
| 2014-03-28 07:32:00 | AAPL | Stock | 19.2932 | 19.2932 | 19.2929 | 19.2929 | 10248.0 |
| 2014-03-28 07:39:00 | AAPL | Stock | 19.2861 | 19.2861 | 19.2861 | 19.2861 | 2800.0 |
| 2014-03-28 07:42:00 | AAPL | Stock | 19.2861 | 19.2861 | 19.2861 | 19.2861 | 3892.0 |
| 2014-03-28 07:44:00 | AAPL | Stock | 19.2857 | 19.2918 | 19.2857 | 19.2918 | 5600.0 |
| 2014-03-28 07:46:00 | AAPL | Stock | 19.2857 | 19.2857 | 19.2857 | 19.2857 | 2800.0 |
| 2014-03-28 08:00:00 | AAPL | Stock | 19.2857 | 19.2911 | 19.2786 | 19.2857 | 69720.0 |
| 2014-03-28 08:02:00 | AAPL | Stock | 19.285 | 19.2857 | 19.2718 | 19.2718 | 8400.0 |
| 2014-03-28 08:03:00 | AAPL | Stock | 19.2857 | 19.2911 | 19.2857 | 19.2911 | 37800.0 |
| 2014-03-28 08:04:00 | AAPL | Stock | 19.2789 | 19.2961 | 19.2789 | 19.2961 | 37800.0 |
| 2014-03-28 08:05:00 | AAPL | Stock | 19.2982 | 19.2982 | 19.2946 | 19.2946 | 25200.0 |
| 2014-03-28 08:06:00 | AAPL | Stock | 19.295 | 19.3007 | 19.295 | 19.3004 | 42000.0 |
| 2014-03-28 08:07:00 | AAPL | Stock | 19.3014 | 19.3014 | 19.3014 | 19.3014 | 2800.0 |
| 2014-03-28 08:08:00 | AAPL | Stock | 19.2993 | 19.3 | 19.2993 | 19.3 | 11060.0 |
| 2014-03-28 08:09:00 | AAPL | Stock | 19.2929 | 19.2929 | 19.2929 | 19.2929 | 2800.0 |
| 2014-03-28 08:10:00 | AAPL | Stock | 19.3021 | 19.3021 | 19.3021 | 19.3021 | 2800.0 |
| 2014-03-28 08:12:00 | AAPL | Stock | 19.2929 | 19.2929 | 19.2857 | 19.2857 | 33600.0 |
| 2014-03-28 08:13:00 | AAPL | Stock | 19.2861 | 19.2868 | 19.2857 | 19.2857 | 12292.0 |
| 2014-03-28 08:19:00 | AAPL | Stock | 19.2768 | 19.2768 | 19.2768 | 19.2768 | 12600.0 |
| 2014-03-28 08:21:00 | AAPL | Stock | 19.2804 | 19.2804 | 19.2804 | 19.2804 | 13300.0 |
| 2014-03-28 08:22:00 | AAPL | Stock | 19.2768 | 19.2768 | 19.2761 | 19.2761 | 14000.0 |
| 2014-03-28 08:24:00 | AAPL | Stock | 19.2696 | 19.2696 | 19.2696 | 19.2696 | 5600.0 |
| 2014-03-28 08:28:00 | AAPL | Stock | 19.2679 | 19.2732 | 19.2679 | 19.2732 | 11480.0 |
| 2014-03-28 08:29:00 | AAPL | Stock | 19.2857 | 19.2857 | 19.2675 | 19.2675 | 8400.0 |
| 2014-03-28 08:30:00 | AAPL | Stock | 19.2646 | 19.2646 | 19.2646 | 19.2646 | 8400.0 |
| 2014-03-28 08:31:00 | AAPL | Stock | 19.2646 | 19.2646 | 19.2646 | 19.2646 | 2800.0 |
| 2014-03-28 08:33:00 | AAPL | Stock | 19.2661 | 19.2661 | 19.2661 | 19.2661 | 5600.0 |
| 2014-03-28 08:34:00 | AAPL | Stock | 19.2661 | 19.2661 | 19.2661 | 19.2661 | 2800.0 |
| 2014-03-28 08:35:00 | AAPL | Stock | 19.2646 | 19.2646 | 19.2589 | 19.2618 | 16800.0 |
| 2014-03-28 08:37:00 | AAPL | Stock | 19.2654 | 19.2668 | 19.2654 | 19.2668 | 5600.0 |
| 2014-03-28 08:45:00 | AAPL | Stock | 19.2564 | 19.2564 | 19.2536 | 19.2557 | 44492.0 |
| 2014-03-28 08:46:00 | AAPL | Stock | 19.2589 | 19.2668 | 19.2589 | 19.2668 | 40152.0 |
> showing 50 of 1,056,261 rows — these rows as CSV