PREVIEW / stock_5min / 2011-11-28
file: by_date/stock_5min/2011/2011-11-28.parquet size: 4.8 MB rows: 332,583 symbols: 3,538
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-28 04:00:00 | AAPL | Stock | 13.2561 | 13.2561 | 13.2561 | 13.2561 | 2800.0 |
| 2011-11-28 04:10:00 | AAPL | Stock | 13.2536 | 13.2536 | 13.2536 | 13.2536 | 14000.0 |
| 2011-11-28 04:20:00 | AAPL | Stock | 13.2643 | 13.2714 | 13.2643 | 13.2714 | 5600.0 |
| 2011-11-28 04:25:00 | AAPL | Stock | 13.2854 | 13.2857 | 13.2854 | 13.2857 | 5600.0 |
| 2011-11-28 04:40:00 | AAPL | Stock | 13.3214 | 13.3214 | 13.3214 | 13.3214 | 2800.0 |
| 2011-11-28 04:45:00 | AAPL | Stock | 13.2857 | 13.2857 | 13.2857 | 13.2857 | 4480.0 |
| 2011-11-28 04:50:00 | AAPL | Stock | 13.3036 | 13.3036 | 13.3036 | 13.3036 | 2800.0 |
| 2011-11-28 05:00:00 | AAPL | Stock | 13.3254 | 13.3254 | 13.3254 | 13.3254 | 2800.0 |
| 2011-11-28 05:15:00 | AAPL | Stock | 13.3304 | 13.3304 | 13.3304 | 13.3304 | 2800.0 |
| 2011-11-28 05:20:00 | AAPL | Stock | 13.3304 | 13.3304 | 13.3304 | 13.3304 | 2800.0 |
| 2011-11-28 05:30:00 | AAPL | Stock | 13.3304 | 13.3304 | 13.3304 | 13.3304 | 2800.0 |
| 2011-11-28 05:35:00 | AAPL | Stock | 13.3304 | 13.3432 | 13.3304 | 13.3432 | 8960.0 |
| 2011-11-28 05:40:00 | AAPL | Stock | 13.3393 | 13.3393 | 13.3393 | 13.3393 | 2800.0 |
| 2011-11-28 05:50:00 | AAPL | Stock | 13.3429 | 13.3429 | 13.3429 | 13.3429 | 2800.0 |
| 2011-11-28 06:10:00 | AAPL | Stock | 13.3571 | 13.3571 | 13.3571 | 13.3571 | 67060.0 |
| 2011-11-28 06:20:00 | AAPL | Stock | 13.3179 | 13.3179 | 13.3036 | 13.3036 | 11900.0 |
| 2011-11-28 06:30:00 | AAPL | Stock | 13.3532 | 13.3532 | 13.3532 | 13.3532 | 22400.0 |
| 2011-11-28 06:35:00 | AAPL | Stock | 13.3532 | 13.3643 | 13.3532 | 13.3643 | 10500.0 |
| 2011-11-28 06:50:00 | AAPL | Stock | 13.3257 | 13.3257 | 13.3257 | 13.3257 | 2800.0 |
| 2011-11-28 07:00:00 | AAPL | Stock | 13.3393 | 13.3532 | 13.3289 | 13.3418 | 49616.0 |
| 2011-11-28 07:05:00 | AAPL | Stock | 13.3418 | 13.3429 | 13.3214 | 13.3214 | 63280.0 |
| 2011-11-28 07:10:00 | AAPL | Stock | 13.3214 | 13.3214 | 13.2882 | 13.3175 | 57372.0 |
| 2011-11-28 07:15:00 | AAPL | Stock | 13.3039 | 13.3039 | 13.3036 | 13.3036 | 11200.0 |
| 2011-11-28 07:20:00 | AAPL | Stock | 13.3039 | 13.3089 | 13.3036 | 13.3039 | 30324.0 |
| 2011-11-28 07:25:00 | AAPL | Stock | 13.3043 | 13.3225 | 13.3036 | 13.3225 | 247352.0 |
| 2011-11-28 07:30:00 | AAPL | Stock | 13.3211 | 13.3321 | 13.3107 | 13.3321 | 125440.0 |
| 2011-11-28 07:35:00 | AAPL | Stock | 13.3371 | 13.3393 | 13.3232 | 13.3393 | 61600.0 |
| 2011-11-28 07:40:00 | AAPL | Stock | 13.3304 | 13.3421 | 13.3214 | 13.3393 | 168700.0 |
| 2011-11-28 07:45:00 | AAPL | Stock | 13.3418 | 13.3421 | 13.3321 | 13.3418 | 111692.0 |
| 2011-11-28 07:50:00 | AAPL | Stock | 13.3464 | 13.3464 | 13.3268 | 13.3393 | 256872.0 |
| 2011-11-28 07:55:00 | AAPL | Stock | 13.3393 | 13.3393 | 13.3304 | 13.3304 | 30800.0 |
| 2011-11-28 08:00:00 | AAPL | Stock | 13.3336 | 13.3568 | 13.3 | 13.3 | 607096.0 |
| 2011-11-28 08:05:00 | AAPL | Stock | 13.3071 | 13.3071 | 13.2982 | 13.3036 | 241976.0 |
| 2011-11-28 08:10:00 | AAPL | Stock | 13.3029 | 13.3121 | 13.3 | 13.3036 | 118412.0 |
| 2011-11-28 08:15:00 | AAPL | Stock | 13.3089 | 13.3154 | 13.3036 | 13.3107 | 174132.0 |
| 2011-11-28 08:20:00 | AAPL | Stock | 13.3111 | 13.3125 | 13.2857 | 13.3075 | 299320.0 |
| 2011-11-28 08:25:00 | AAPL | Stock | 13.3082 | 13.3089 | 13.2857 | 13.2971 | 189168.0 |
| 2011-11-28 08:30:00 | AAPL | Stock | 13.2911 | 13.2911 | 13.2771 | 13.2786 | 186648.0 |
| 2011-11-28 08:35:00 | AAPL | Stock | 13.2857 | 13.2889 | 13.2779 | 13.2782 | 98532.0 |
| 2011-11-28 08:40:00 | AAPL | Stock | 13.2857 | 13.2868 | 13.2604 | 13.2768 | 534744.0 |
| 2011-11-28 08:45:00 | AAPL | Stock | 13.2764 | 13.2886 | 13.2679 | 13.2886 | 342076.0 |
| 2011-11-28 08:50:00 | AAPL | Stock | 13.2864 | 13.2964 | 13.2864 | 13.2961 | 106400.0 |
| 2011-11-28 08:55:00 | AAPL | Stock | 13.2961 | 13.3054 | 13.2946 | 13.3004 | 590352.0 |
| 2011-11-28 09:00:00 | AAPL | Stock | 13.3011 | 13.3071 | 13.2975 | 13.3018 | 429548.0 |
| 2011-11-28 09:05:00 | AAPL | Stock | 13.2964 | 13.3036 | 13.2943 | 13.2943 | 486416.0 |
| 2011-11-28 09:10:00 | AAPL | Stock | 13.2993 | 13.3029 | 13.2929 | 13.3007 | 192500.0 |
| 2011-11-28 09:15:00 | AAPL | Stock | 13.2964 | 13.3018 | 13.2954 | 13.2982 | 203504.0 |
| 2011-11-28 09:20:00 | AAPL | Stock | 13.2957 | 13.3054 | 13.2946 | 13.3011 | 196448.0 |
| 2011-11-28 09:25:00 | AAPL | Stock | 13.2975 | 13.3036 | 13.2929 | 13.3036 | 389564.0 |
| 2011-11-28 09:30:00 | AAPL | Stock | 13.2982 | 13.3164 | 13.2393 | 13.2639 | 22165136.0 |
> showing 50 of 332,583 rows — these rows as CSV