PREVIEW / stock_1min / 2011-02-04
file: by_date/stock_1min/2011/2011-02-04.parquet size: 12.8 MB rows: 963,862 symbols: 2,860
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-02-04 05:11:00 | AAPL | Stock | 12.2979 | 12.2979 | 12.2979 | 12.2979 | 2800.0 |
| 2011-02-04 05:28:00 | AAPL | Stock | 12.2979 | 12.2979 | 12.2979 | 12.2979 | 3220.0 |
| 2011-02-04 05:37:00 | AAPL | Stock | 12.2979 | 12.2979 | 12.2979 | 12.2979 | 3220.0 |
| 2011-02-04 06:00:00 | AAPL | Stock | 12.2946 | 12.2946 | 12.2946 | 12.2946 | 14000.0 |
| 2011-02-04 07:02:00 | AAPL | Stock | 12.2911 | 12.2911 | 12.2911 | 12.2911 | 2800.0 |
| 2011-02-04 07:04:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 2800.0 |
| 2011-02-04 07:16:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 22400.0 |
| 2011-02-04 07:21:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 2800.0 |
| 2011-02-04 07:23:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 14000.0 |
| 2011-02-04 07:25:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2761 | 12.2857 | 22400.0 |
| 2011-02-04 07:26:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 16800.0 |
| 2011-02-04 07:29:00 | AAPL | Stock | 12.2786 | 12.2786 | 12.2786 | 12.2786 | 2800.0 |
| 2011-02-04 07:31:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 30800.0 |
| 2011-02-04 07:34:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 2800.0 |
| 2011-02-04 07:38:00 | AAPL | Stock | 12.2875 | 12.2875 | 12.2875 | 12.2875 | 2800.0 |
| 2011-02-04 07:39:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 14700.0 |
| 2011-02-04 07:41:00 | AAPL | Stock | 12.2893 | 12.2893 | 12.2893 | 12.2893 | 8400.0 |
| 2011-02-04 07:43:00 | AAPL | Stock | 12.2996 | 12.3 | 12.2996 | 12.3 | 19600.0 |
| 2011-02-04 07:44:00 | AAPL | Stock | 12.2996 | 12.3071 | 12.2996 | 12.3071 | 7420.0 |
| 2011-02-04 07:45:00 | AAPL | Stock | 12.3107 | 12.3107 | 12.3107 | 12.3107 | 2800.0 |
| 2011-02-04 07:46:00 | AAPL | Stock | 12.3075 | 12.3214 | 12.3071 | 12.3157 | 62524.0 |
| 2011-02-04 07:49:00 | AAPL | Stock | 12.3161 | 12.3282 | 12.3161 | 12.3282 | 46200.0 |
| 2011-02-04 07:51:00 | AAPL | Stock | 12.3179 | 12.3179 | 12.3179 | 12.3179 | 2800.0 |
| 2011-02-04 07:55:00 | AAPL | Stock | 12.3039 | 12.3039 | 12.3039 | 12.3039 | 2800.0 |
| 2011-02-04 07:57:00 | AAPL | Stock | 12.3164 | 12.3164 | 12.3164 | 12.3164 | 2800.0 |
| 2011-02-04 08:00:00 | AAPL | Stock | 12.315 | 12.315 | 12.2836 | 12.3061 | 194628.0 |
| 2011-02-04 08:01:00 | AAPL | Stock | 12.2986 | 12.3071 | 12.2879 | 12.2879 | 67620.0 |
| 2011-02-04 08:02:00 | AAPL | Stock | 12.29 | 12.2968 | 12.2786 | 12.2968 | 159600.0 |
| 2011-02-04 08:03:00 | AAPL | Stock | 12.2918 | 12.2918 | 12.2857 | 12.2857 | 8400.0 |
| 2011-02-04 08:04:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 5600.0 |
| 2011-02-04 08:05:00 | AAPL | Stock | 12.2857 | 12.2914 | 12.2854 | 12.2854 | 39200.0 |
| 2011-02-04 08:06:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 2800.0 |
| 2011-02-04 08:07:00 | AAPL | Stock | 12.2821 | 12.2821 | 12.2782 | 12.2782 | 36400.0 |
| 2011-02-04 08:08:00 | AAPL | Stock | 12.2821 | 12.2857 | 12.2786 | 12.2786 | 8400.0 |
| 2011-02-04 08:09:00 | AAPL | Stock | 12.2804 | 12.2854 | 12.2804 | 12.2854 | 5600.0 |
| 2011-02-04 08:10:00 | AAPL | Stock | 12.2821 | 12.2821 | 12.2804 | 12.2804 | 20720.0 |
| 2011-02-04 08:11:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 5600.0 |
| 2011-02-04 08:12:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 7000.0 |
| 2011-02-04 08:13:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2846 | 12.2854 | 28140.0 |
| 2011-02-04 08:14:00 | AAPL | Stock | 12.2825 | 12.2893 | 12.2825 | 12.2893 | 38360.0 |
| 2011-02-04 08:15:00 | AAPL | Stock | 12.2864 | 12.2925 | 12.2846 | 12.2893 | 71120.0 |
| 2011-02-04 08:16:00 | AAPL | Stock | 12.2889 | 12.3 | 12.2889 | 12.3 | 85596.0 |
| 2011-02-04 08:17:00 | AAPL | Stock | 12.2993 | 12.3036 | 12.2929 | 12.3036 | 100604.0 |
| 2011-02-04 08:18:00 | AAPL | Stock | 12.3046 | 12.3161 | 12.3036 | 12.3161 | 152600.0 |
| 2011-02-04 08:19:00 | AAPL | Stock | 12.3161 | 12.3179 | 12.3111 | 12.3143 | 123200.0 |
| 2011-02-04 08:20:00 | AAPL | Stock | 12.3114 | 12.3114 | 12.3039 | 12.3039 | 21560.0 |
| 2011-02-04 08:21:00 | AAPL | Stock | 12.3114 | 12.3143 | 12.3114 | 12.3143 | 12740.0 |
| 2011-02-04 08:22:00 | AAPL | Stock | 12.3039 | 12.3039 | 12.3039 | 12.3039 | 2800.0 |
| 2011-02-04 08:23:00 | AAPL | Stock | 12.3054 | 12.3089 | 12.2954 | 12.2954 | 79800.0 |
| 2011-02-04 08:24:00 | AAPL | Stock | 12.3029 | 12.3029 | 12.2971 | 12.2971 | 5600.0 |
> showing 50 of 963,862 rows — these rows as CSV