PREVIEW / stock_5min / 2011-07-27
file: by_date/stock_5min/2011/2011-07-27.parquet size: 5.0 MB rows: 338,375 symbols: 3,544
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-07-27 05:45:00 | AAPL | Stock | 14.4214 | 14.4214 | 14.4214 | 14.4214 | 2800.0 |
| 2011-07-27 06:45:00 | AAPL | Stock | 14.4018 | 14.4018 | 14.4018 | 14.4018 | 14000.0 |
| 2011-07-27 07:00:00 | AAPL | Stock | 14.4011 | 14.4111 | 14.4011 | 14.4107 | 21000.0 |
| 2011-07-27 07:05:00 | AAPL | Stock | 14.4068 | 14.4082 | 14.4068 | 14.4082 | 11200.0 |
| 2011-07-27 07:10:00 | AAPL | Stock | 14.4107 | 14.4107 | 14.4086 | 14.4086 | 40600.0 |
| 2011-07-27 07:15:00 | AAPL | Stock | 14.4107 | 14.4107 | 14.4107 | 14.4107 | 5600.0 |
| 2011-07-27 07:20:00 | AAPL | Stock | 14.4107 | 14.4229 | 14.4104 | 14.4107 | 50400.0 |
| 2011-07-27 07:25:00 | AAPL | Stock | 14.4075 | 14.4075 | 14.3929 | 14.3929 | 44800.0 |
| 2011-07-27 07:30:00 | AAPL | Stock | 14.3921 | 14.3929 | 14.3921 | 14.3929 | 5600.0 |
| 2011-07-27 07:35:00 | AAPL | Stock | 14.3986 | 14.3986 | 14.3986 | 14.3986 | 7000.0 |
| 2011-07-27 07:40:00 | AAPL | Stock | 14.3932 | 14.3932 | 14.3929 | 14.3929 | 16800.0 |
| 2011-07-27 07:45:00 | AAPL | Stock | 14.3911 | 14.3911 | 14.3911 | 14.3911 | 8400.0 |
| 2011-07-27 07:50:00 | AAPL | Stock | 14.3911 | 14.3911 | 14.3875 | 14.3875 | 48524.0 |
| 2011-07-27 07:55:00 | AAPL | Stock | 14.3875 | 14.3875 | 14.3714 | 14.3714 | 28000.0 |
| 2011-07-27 08:00:00 | AAPL | Stock | 14.3714 | 14.375 | 14.3643 | 14.3743 | 305620.0 |
| 2011-07-27 08:05:00 | AAPL | Stock | 14.3636 | 14.3679 | 14.3579 | 14.3614 | 152544.0 |
| 2011-07-27 08:10:00 | AAPL | Stock | 14.3611 | 14.3661 | 14.3579 | 14.36 | 155820.0 |
| 2011-07-27 08:15:00 | AAPL | Stock | 14.3643 | 14.3657 | 14.3214 | 14.3386 | 537656.0 |
| 2011-07-27 08:20:00 | AAPL | Stock | 14.3389 | 14.3464 | 14.3318 | 14.3464 | 139272.0 |
| 2011-07-27 08:25:00 | AAPL | Stock | 14.3464 | 14.3507 | 14.3279 | 14.3454 | 285292.0 |
| 2011-07-27 08:30:00 | AAPL | Stock | 14.3325 | 14.3371 | 14.3054 | 14.3243 | 481040.0 |
| 2011-07-27 08:35:00 | AAPL | Stock | 14.3232 | 14.34 | 14.3146 | 14.3214 | 231756.0 |
| 2011-07-27 08:40:00 | AAPL | Stock | 14.3214 | 14.325 | 14.3054 | 14.3157 | 294504.0 |
| 2011-07-27 08:45:00 | AAPL | Stock | 14.3093 | 14.3157 | 14.29 | 14.2946 | 505484.0 |
| 2011-07-27 08:50:00 | AAPL | Stock | 14.2946 | 14.3125 | 14.2857 | 14.3125 | 681016.0 |
| 2011-07-27 08:55:00 | AAPL | Stock | 14.3104 | 14.3125 | 14.3011 | 14.3029 | 138404.0 |
| 2011-07-27 09:00:00 | AAPL | Stock | 14.2982 | 14.3214 | 14.295 | 14.315 | 141120.0 |
| 2011-07-27 09:05:00 | AAPL | Stock | 14.3154 | 14.3171 | 14.2868 | 14.295 | 517580.0 |
| 2011-07-27 09:10:00 | AAPL | Stock | 14.2954 | 14.3021 | 14.2857 | 14.2925 | 527884.0 |
| 2011-07-27 09:15:00 | AAPL | Stock | 14.2925 | 14.3196 | 14.2925 | 14.3132 | 208852.0 |
| 2011-07-27 09:20:00 | AAPL | Stock | 14.3129 | 14.3214 | 14.3071 | 14.3214 | 119980.0 |
| 2011-07-27 09:25:00 | AAPL | Stock | 14.3214 | 14.3214 | 14.2871 | 14.3068 | 512008.0 |
| 2011-07-27 09:30:00 | AAPL | Stock | 14.3054 | 14.38 | 14.2875 | 14.3757 | 20931652.0 |
| 2011-07-27 09:35:00 | AAPL | Stock | 14.3791 | 14.38 | 14.24 | 14.2561 | 24486168.0 |
| 2011-07-27 09:40:00 | AAPL | Stock | 14.2561 | 14.2786 | 14.2071 | 14.2693 | 27697936.0 |
| 2011-07-27 09:45:00 | AAPL | Stock | 14.2682 | 14.2735 | 14.2357 | 14.2361 | 12752656.0 |
| 2011-07-27 09:50:00 | AAPL | Stock | 14.2357 | 14.2529 | 14.2186 | 14.2261 | 10786860.0 |
| 2011-07-27 09:55:00 | AAPL | Stock | 14.2268 | 14.2568 | 14.2225 | 14.2336 | 7347816.0 |
| 2011-07-27 10:00:00 | AAPL | Stock | 14.2375 | 14.2629 | 14.2206 | 14.2375 | 10096296.0 |
| 2011-07-27 10:05:00 | AAPL | Stock | 14.2396 | 14.2511 | 14.2196 | 14.2311 | 8722756.0 |
| 2011-07-27 10:10:00 | AAPL | Stock | 14.2314 | 14.2314 | 14.0939 | 14.1129 | 35713748.0 |
| 2011-07-27 10:15:00 | AAPL | Stock | 14.1114 | 14.1561 | 14.1057 | 14.1307 | 19332852.0 |
| 2011-07-27 10:20:00 | AAPL | Stock | 14.1312 | 14.1489 | 14.0643 | 14.0799 | 23455936.0 |
| 2011-07-27 10:25:00 | AAPL | Stock | 14.0768 | 14.0961 | 14.0457 | 14.0779 | 18550952.0 |
| 2011-07-27 10:30:00 | AAPL | Stock | 14.0779 | 14.1157 | 14.0268 | 14.1082 | 23320108.0 |
| 2011-07-27 10:35:00 | AAPL | Stock | 14.1082 | 14.1154 | 14.0814 | 14.1014 | 11987836.0 |
| 2011-07-27 10:40:00 | AAPL | Stock | 14.102 | 14.1557 | 14.095 | 14.1519 | 15157520.0 |
| 2011-07-27 10:45:00 | AAPL | Stock | 14.1548 | 14.1568 | 14.1189 | 14.1371 | 7804216.0 |
| 2011-07-27 10:50:00 | AAPL | Stock | 14.1337 | 14.1996 | 14.1337 | 14.1875 | 12412456.0 |
| 2011-07-27 10:55:00 | AAPL | Stock | 14.188 | 14.2107 | 14.1714 | 14.2025 | 7522928.0 |
> showing 50 of 338,375 rows — these rows as CSV