PREVIEW / stock_1min / 2014-01-08
file: by_date/stock_1min/2014/2014-01-08.parquet size: 14.8 MB rows: 1,069,772 symbols: 2,854
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-01-08 05:00:00 | AAPL | Stock | 19.2868 | 19.2868 | 19.2868 | 19.2868 | 2800.0 |
| 2014-01-08 05:02:00 | AAPL | Stock | 19.2907 | 19.2907 | 19.2904 | 19.2904 | 5600.0 |
| 2014-01-08 05:35:00 | AAPL | Stock | 19.3179 | 19.3179 | 19.3179 | 19.3179 | 2800.0 |
| 2014-01-08 05:37:00 | AAPL | Stock | 19.3361 | 19.3361 | 19.3361 | 19.3361 | 2800.0 |
| 2014-01-08 05:55:00 | AAPL | Stock | 19.3086 | 19.3086 | 19.3086 | 19.3086 | 2800.0 |
| 2014-01-08 06:03:00 | AAPL | Stock | 19.3011 | 19.3011 | 19.3011 | 19.3011 | 8400.0 |
| 2014-01-08 06:04:00 | AAPL | Stock | 19.2968 | 19.2968 | 19.2968 | 19.2968 | 2800.0 |
| 2014-01-08 06:51:00 | AAPL | Stock | 19.2971 | 19.2971 | 19.2971 | 19.2971 | 2800.0 |
| 2014-01-08 06:54:00 | AAPL | Stock | 19.2718 | 19.2718 | 19.2718 | 19.2718 | 2800.0 |
| 2014-01-08 06:56:00 | AAPL | Stock | 19.2814 | 19.2814 | 19.2814 | 19.2814 | 2800.0 |
| 2014-01-08 07:02:00 | AAPL | Stock | 19.2679 | 19.2679 | 19.2679 | 19.2679 | 2800.0 |
| 2014-01-08 07:06:00 | AAPL | Stock | 19.2675 | 19.2675 | 19.2675 | 19.2675 | 2800.0 |
| 2014-01-08 07:21:00 | AAPL | Stock | 19.2764 | 19.2764 | 19.2764 | 19.2764 | 6440.0 |
| 2014-01-08 07:25:00 | AAPL | Stock | 19.2843 | 19.2843 | 19.2843 | 19.2843 | 2800.0 |
| 2014-01-08 07:27:00 | AAPL | Stock | 19.2857 | 19.2857 | 19.2857 | 19.2857 | 5600.0 |
| 2014-01-08 07:38:00 | AAPL | Stock | 19.2954 | 19.2954 | 19.2879 | 19.2879 | 7224.0 |
| 2014-01-08 07:49:00 | AAPL | Stock | 19.29 | 19.29 | 19.29 | 19.29 | 2800.0 |
| 2014-01-08 07:55:00 | AAPL | Stock | 19.2954 | 19.2954 | 19.2954 | 19.2954 | 2800.0 |
| 2014-01-08 07:57:00 | AAPL | Stock | 19.3029 | 19.3104 | 19.3029 | 19.3104 | 39200.0 |
| 2014-01-08 07:58:00 | AAPL | Stock | 19.3111 | 19.3111 | 19.3107 | 19.3107 | 5600.0 |
| 2014-01-08 07:59:00 | AAPL | Stock | 19.3193 | 19.3193 | 19.3193 | 19.3193 | 2800.0 |
| 2014-01-08 08:00:00 | AAPL | Stock | 19.3071 | 19.3089 | 19.2714 | 19.3071 | 82964.0 |
| 2014-01-08 08:04:00 | AAPL | Stock | 19.2954 | 19.2954 | 19.2954 | 19.2954 | 3752.0 |
| 2014-01-08 08:05:00 | AAPL | Stock | 19.2954 | 19.2954 | 19.2954 | 19.2954 | 2800.0 |
| 2014-01-08 08:07:00 | AAPL | Stock | 19.3082 | 19.3096 | 19.3082 | 19.3096 | 10080.0 |
| 2014-01-08 08:08:00 | AAPL | Stock | 19.3179 | 19.3179 | 19.3179 | 19.3179 | 5600.0 |
| 2014-01-08 08:10:00 | AAPL | Stock | 19.3104 | 19.3204 | 19.3104 | 19.3204 | 5600.0 |
| 2014-01-08 08:11:00 | AAPL | Stock | 19.3203 | 19.3203 | 19.3096 | 19.3096 | 30520.0 |
| 2014-01-08 08:17:00 | AAPL | Stock | 19.3096 | 19.3096 | 19.3096 | 19.3096 | 5600.0 |
| 2014-01-08 08:19:00 | AAPL | Stock | 19.3039 | 19.3143 | 19.3039 | 19.3054 | 31584.0 |
| 2014-01-08 08:20:00 | AAPL | Stock | 19.3039 | 19.3039 | 19.3039 | 19.3039 | 2800.0 |
| 2014-01-08 08:21:00 | AAPL | Stock | 19.3107 | 19.3107 | 19.3107 | 19.3107 | 2800.0 |
| 2014-01-08 08:22:00 | AAPL | Stock | 19.3104 | 19.3118 | 19.3104 | 19.3118 | 28000.0 |
| 2014-01-08 08:25:00 | AAPL | Stock | 19.3 | 19.3 | 19.3 | 19.3 | 2800.0 |
| 2014-01-08 08:26:00 | AAPL | Stock | 19.3004 | 19.3007 | 19.3004 | 19.3007 | 7000.0 |
| 2014-01-08 08:27:00 | AAPL | Stock | 19.3036 | 19.3036 | 19.2868 | 19.2868 | 58800.0 |
| 2014-01-08 08:28:00 | AAPL | Stock | 19.2868 | 19.2868 | 19.2857 | 19.2857 | 14000.0 |
| 2014-01-08 08:29:00 | AAPL | Stock | 19.2814 | 19.2914 | 19.2804 | 19.2914 | 112280.0 |
| 2014-01-08 08:30:00 | AAPL | Stock | 19.2814 | 19.2814 | 19.2814 | 19.2814 | 8400.0 |
| 2014-01-08 08:33:00 | AAPL | Stock | 19.2771 | 19.2771 | 19.2771 | 19.2771 | 2800.0 |
| 2014-01-08 08:35:00 | AAPL | Stock | 19.2779 | 19.2786 | 19.2768 | 19.2786 | 39200.0 |
| 2014-01-08 08:36:00 | AAPL | Stock | 19.2821 | 19.2857 | 19.2821 | 19.2857 | 39340.0 |
| 2014-01-08 08:38:00 | AAPL | Stock | 19.2932 | 19.2946 | 19.2796 | 19.2796 | 61600.0 |
| 2014-01-08 08:41:00 | AAPL | Stock | 19.28 | 19.28 | 19.28 | 19.28 | 2800.0 |
| 2014-01-08 08:46:00 | AAPL | Stock | 19.2779 | 19.2786 | 19.2779 | 19.2786 | 8400.0 |
| 2014-01-08 08:48:00 | AAPL | Stock | 19.2768 | 19.2786 | 19.2768 | 19.2786 | 11200.0 |
| 2014-01-08 08:49:00 | AAPL | Stock | 19.2771 | 19.2771 | 19.2771 | 19.2771 | 2800.0 |
| 2014-01-08 08:52:00 | AAPL | Stock | 19.2821 | 19.2875 | 19.2779 | 19.2811 | 185360.0 |
| 2014-01-08 08:53:00 | AAPL | Stock | 19.2839 | 19.3021 | 19.2839 | 19.2946 | 88872.0 |
| 2014-01-08 08:54:00 | AAPL | Stock | 19.2946 | 19.3125 | 19.2946 | 19.3043 | 73528.0 |
> showing 50 of 1,069,772 rows — these rows as CSV