PREVIEW / stock_5min / 2011-02-02
file: by_date/stock_5min/2011/2011-02-02.parquet size: 4.8 MB rows: 327,911 symbols: 3,514
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-02 04:35:00 | AAPL | Stock | 12.3225 | 12.3332 | 12.3225 | 12.3332 | 5600.0 |
| 2011-02-02 04:40:00 | AAPL | Stock | 12.3496 | 12.3496 | 12.3496 | 12.3496 | 2800.0 |
| 2011-02-02 05:15:00 | AAPL | Stock | 12.3393 | 12.3393 | 12.3393 | 12.3393 | 2800.0 |
| 2011-02-02 05:20:00 | AAPL | Stock | 12.3307 | 12.3307 | 12.3286 | 12.3286 | 5600.0 |
| 2011-02-02 06:25:00 | AAPL | Stock | 12.3429 | 12.3429 | 12.3429 | 12.3429 | 14000.0 |
| 2011-02-02 06:30:00 | AAPL | Stock | 12.3429 | 12.3429 | 12.3321 | 12.3321 | 14000.0 |
| 2011-02-02 06:45:00 | AAPL | Stock | 12.3286 | 12.3286 | 12.3286 | 12.3286 | 5600.0 |
| 2011-02-02 07:00:00 | AAPL | Stock | 12.3314 | 12.3314 | 12.3225 | 12.3225 | 75460.0 |
| 2011-02-02 07:05:00 | AAPL | Stock | 12.3318 | 12.3332 | 12.3318 | 12.3332 | 8400.0 |
| 2011-02-02 07:10:00 | AAPL | Stock | 12.3332 | 12.3539 | 12.3332 | 12.3375 | 61600.0 |
| 2011-02-02 07:15:00 | AAPL | Stock | 12.3479 | 12.3479 | 12.3479 | 12.3479 | 2800.0 |
| 2011-02-02 07:20:00 | AAPL | Stock | 12.3479 | 12.3479 | 12.3464 | 12.3464 | 15652.0 |
| 2011-02-02 07:30:00 | AAPL | Stock | 12.3307 | 12.3307 | 12.33 | 12.33 | 5600.0 |
| 2011-02-02 07:35:00 | AAPL | Stock | 12.3304 | 12.3304 | 12.3304 | 12.3304 | 8400.0 |
| 2011-02-02 07:40:00 | AAPL | Stock | 12.3225 | 12.3225 | 12.3225 | 12.3225 | 16800.0 |
| 2011-02-02 07:45:00 | AAPL | Stock | 12.3214 | 12.3321 | 12.3214 | 12.3321 | 8400.0 |
| 2011-02-02 08:00:00 | AAPL | Stock | 12.3279 | 12.3279 | 12.3196 | 12.3196 | 34496.0 |
| 2011-02-02 08:05:00 | AAPL | Stock | 12.3125 | 12.3129 | 12.3096 | 12.3118 | 47600.0 |
| 2011-02-02 08:10:00 | AAPL | Stock | 12.3079 | 12.3079 | 12.2946 | 12.3014 | 174468.0 |
| 2011-02-02 08:15:00 | AAPL | Stock | 12.3014 | 12.3214 | 12.3014 | 12.3143 | 189000.0 |
| 2011-02-02 08:20:00 | AAPL | Stock | 12.3143 | 12.3232 | 12.3143 | 12.3232 | 116060.0 |
| 2011-02-02 08:25:00 | AAPL | Stock | 12.3214 | 12.3243 | 12.3125 | 12.3136 | 229936.0 |
| 2011-02-02 08:30:00 | AAPL | Stock | 12.3039 | 12.3107 | 12.3039 | 12.3057 | 14000.0 |
| 2011-02-02 08:35:00 | AAPL | Stock | 12.305 | 12.305 | 12.2964 | 12.3011 | 125636.0 |
| 2011-02-02 08:40:00 | AAPL | Stock | 12.3 | 12.3011 | 12.2893 | 12.3011 | 130900.0 |
| 2011-02-02 08:45:00 | AAPL | Stock | 12.3007 | 12.3011 | 12.2957 | 12.2982 | 19600.0 |
| 2011-02-02 08:50:00 | AAPL | Stock | 12.2982 | 12.2982 | 12.2957 | 12.2964 | 32984.0 |
| 2011-02-02 08:55:00 | AAPL | Stock | 12.2975 | 12.2975 | 12.2954 | 12.2961 | 26320.0 |
| 2011-02-02 09:00:00 | AAPL | Stock | 12.2961 | 12.2961 | 12.2896 | 12.2896 | 23240.0 |
| 2011-02-02 09:05:00 | AAPL | Stock | 12.2893 | 12.29 | 12.2804 | 12.2821 | 281344.0 |
| 2011-02-02 09:10:00 | AAPL | Stock | 12.2821 | 12.2857 | 12.2768 | 12.2857 | 180488.0 |
| 2011-02-02 09:15:00 | AAPL | Stock | 12.2839 | 12.2839 | 12.2643 | 12.2679 | 514696.0 |
| 2011-02-02 09:20:00 | AAPL | Stock | 12.2704 | 12.2818 | 12.2704 | 12.2782 | 39900.0 |
| 2011-02-02 09:25:00 | AAPL | Stock | 12.2789 | 12.3014 | 12.2689 | 12.3014 | 255360.0 |
| 2011-02-02 09:30:00 | AAPL | Stock | 12.3014 | 12.3171 | 12.28 | 12.3093 | 12603472.0 |
| 2011-02-02 09:35:00 | AAPL | Stock | 12.3111 | 12.3168 | 12.2936 | 12.3027 | 6419196.0 |
| 2011-02-02 09:40:00 | AAPL | Stock | 12.3014 | 12.3143 | 12.28 | 12.3143 | 9233728.0 |
| 2011-02-02 09:45:00 | AAPL | Stock | 12.3143 | 12.3304 | 12.3064 | 12.3189 | 9718016.0 |
| 2011-02-02 09:50:00 | AAPL | Stock | 12.3186 | 12.3236 | 12.303 | 12.3171 | 4862116.0 |
| 2011-02-02 09:55:00 | AAPL | Stock | 12.3179 | 12.3218 | 12.3054 | 12.3057 | 4761820.0 |
| 2011-02-02 10:00:00 | AAPL | Stock | 12.3057 | 12.3093 | 12.2696 | 12.2779 | 10824716.0 |
| 2011-02-02 10:05:00 | AAPL | Stock | 12.2789 | 12.2971 | 12.2696 | 12.2761 | 6515992.0 |
| 2011-02-02 10:10:00 | AAPL | Stock | 12.2761 | 12.3089 | 12.2757 | 12.2911 | 5269908.0 |
| 2011-02-02 10:15:00 | AAPL | Stock | 12.2914 | 12.3125 | 12.2886 | 12.3089 | 4054176.0 |
| 2011-02-02 10:20:00 | AAPL | Stock | 12.3093 | 12.3179 | 12.2932 | 12.2939 | 4563944.0 |
| 2011-02-02 10:25:00 | AAPL | Stock | 12.2929 | 12.3155 | 12.2907 | 12.3118 | 3706332.0 |
| 2011-02-02 10:30:00 | AAPL | Stock | 12.312 | 12.3179 | 12.2989 | 12.3031 | 4379312.0 |
| 2011-02-02 10:35:00 | AAPL | Stock | 12.3035 | 12.3179 | 12.3029 | 12.3075 | 2633680.0 |
| 2011-02-02 10:40:00 | AAPL | Stock | 12.3086 | 12.3089 | 12.2886 | 12.3082 | 4729004.0 |
| 2011-02-02 10:45:00 | AAPL | Stock | 12.3082 | 12.3136 | 12.2942 | 12.2946 | 2739100.0 |
> showing 50 of 327,911 rows — these rows as CSV