PREVIEW / stock_5min / 2011-09-26
file: by_date/stock_5min/2011/2011-09-26.parquet size: 4.9 MB rows: 330,539 symbols: 3,528
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-09-26 04:00:00 | AAPL | Stock | 14.4321 | 14.4321 | 14.4321 | 14.4321 | 2800.0 |
| 2011-09-26 04:05:00 | AAPL | Stock | 14.3811 | 14.3811 | 14.3811 | 14.3811 | 11200.0 |
| 2011-09-26 04:15:00 | AAPL | Stock | 14.4046 | 14.4229 | 14.4046 | 14.4229 | 5600.0 |
| 2011-09-26 04:20:00 | AAPL | Stock | 14.4582 | 14.4582 | 14.4582 | 14.4582 | 11200.0 |
| 2011-09-26 04:25:00 | AAPL | Stock | 14.4464 | 14.4464 | 14.4464 | 14.4464 | 28000.0 |
| 2011-09-26 04:30:00 | AAPL | Stock | 14.4321 | 14.4321 | 14.4321 | 14.4321 | 9800.0 |
| 2011-09-26 04:35:00 | AAPL | Stock | 14.4321 | 14.4464 | 14.4321 | 14.4464 | 28000.0 |
| 2011-09-26 04:40:00 | AAPL | Stock | 14.4464 | 14.4464 | 14.4464 | 14.4464 | 16800.0 |
| 2011-09-26 04:50:00 | AAPL | Stock | 14.46 | 14.46 | 14.46 | 14.46 | 2800.0 |
| 2011-09-26 04:55:00 | AAPL | Stock | 14.4932 | 14.4964 | 14.4932 | 14.4964 | 11200.0 |
| 2011-09-26 05:00:00 | AAPL | Stock | 14.5 | 14.5 | 14.5 | 14.5 | 2800.0 |
| 2011-09-26 05:05:00 | AAPL | Stock | 14.4964 | 14.4964 | 14.4964 | 14.4964 | 2800.0 |
| 2011-09-26 05:10:00 | AAPL | Stock | 14.5257 | 14.5321 | 14.5257 | 14.5321 | 51660.0 |
| 2011-09-26 05:15:00 | AAPL | Stock | 14.5321 | 14.5321 | 14.5179 | 14.5179 | 22400.0 |
| 2011-09-26 05:30:00 | AAPL | Stock | 14.5357 | 14.5357 | 14.5286 | 14.5286 | 22400.0 |
| 2011-09-26 05:35:00 | AAPL | Stock | 14.5179 | 14.5179 | 14.5 | 14.5179 | 47684.0 |
| 2011-09-26 05:40:00 | AAPL | Stock | 14.5 | 14.5 | 14.5 | 14.5 | 2800.0 |
| 2011-09-26 05:50:00 | AAPL | Stock | 14.5061 | 14.5061 | 14.5061 | 14.5061 | 2800.0 |
| 2011-09-26 05:55:00 | AAPL | Stock | 14.5054 | 14.5054 | 14.5054 | 14.5054 | 2800.0 |
| 2011-09-26 06:00:00 | AAPL | Stock | 14.4782 | 14.4821 | 14.4779 | 14.4786 | 64400.0 |
| 2011-09-26 06:10:00 | AAPL | Stock | 14.4786 | 14.4786 | 14.4786 | 14.4786 | 2800.0 |
| 2011-09-26 06:25:00 | AAPL | Stock | 14.4643 | 14.4643 | 14.4636 | 14.4636 | 11200.0 |
| 2011-09-26 06:30:00 | AAPL | Stock | 14.4764 | 14.4764 | 14.4286 | 14.4286 | 65800.0 |
| 2011-09-26 06:35:00 | AAPL | Stock | 14.4286 | 14.4464 | 14.4286 | 14.4464 | 5600.0 |
| 2011-09-26 06:40:00 | AAPL | Stock | 14.4464 | 14.4464 | 14.4464 | 14.4464 | 30800.0 |
| 2011-09-26 06:50:00 | AAPL | Stock | 14.4704 | 14.4704 | 14.4696 | 14.4696 | 5600.0 |
| 2011-09-26 06:55:00 | AAPL | Stock | 14.4868 | 14.4868 | 14.4464 | 14.4464 | 76160.0 |
| 2011-09-26 07:00:00 | AAPL | Stock | 14.4464 | 14.4857 | 14.4207 | 14.4821 | 482272.0 |
| 2011-09-26 07:05:00 | AAPL | Stock | 14.4679 | 14.4679 | 14.4232 | 14.4289 | 322196.0 |
| 2011-09-26 07:10:00 | AAPL | Stock | 14.4286 | 14.4286 | 14.3393 | 14.3471 | 477820.0 |
| 2011-09-26 07:15:00 | AAPL | Stock | 14.3571 | 14.3571 | 14.2396 | 14.305 | 231560.0 |
| 2011-09-26 07:20:00 | AAPL | Stock | 14.3046 | 14.3046 | 14.2839 | 14.2857 | 622300.0 |
| 2011-09-26 07:25:00 | AAPL | Stock | 14.2857 | 14.3393 | 14.2857 | 14.3357 | 284928.0 |
| 2011-09-26 07:30:00 | AAPL | Stock | 14.3393 | 14.3446 | 14.2946 | 14.3179 | 266280.0 |
| 2011-09-26 07:35:00 | AAPL | Stock | 14.3089 | 14.3089 | 14.1071 | 14.1429 | 701960.0 |
| 2011-09-26 07:40:00 | AAPL | Stock | 14.1339 | 14.2304 | 14.125 | 14.2264 | 745584.0 |
| 2011-09-26 07:45:00 | AAPL | Stock | 14.2264 | 14.2282 | 14.1825 | 14.2143 | 442428.0 |
| 2011-09-26 07:50:00 | AAPL | Stock | 14.2207 | 14.25 | 14.2011 | 14.25 | 349468.0 |
| 2011-09-26 07:55:00 | AAPL | Stock | 14.2318 | 14.2857 | 14.2214 | 14.2679 | 415800.0 |
| 2011-09-26 08:00:00 | AAPL | Stock | 14.2836 | 14.4393 | 14.267 | 14.3321 | 1782200.0 |
| 2011-09-26 08:05:00 | AAPL | Stock | 14.3393 | 14.3393 | 14.295 | 14.2964 | 487340.0 |
| 2011-09-26 08:10:00 | AAPL | Stock | 14.3004 | 14.3214 | 14.2957 | 14.3046 | 555100.0 |
| 2011-09-26 08:15:00 | AAPL | Stock | 14.3036 | 14.3036 | 14.2679 | 14.2861 | 1031912.0 |
| 2011-09-26 08:20:00 | AAPL | Stock | 14.2861 | 14.3168 | 14.2646 | 14.2754 | 746172.0 |
| 2011-09-26 08:25:00 | AAPL | Stock | 14.275 | 14.3346 | 14.275 | 14.3214 | 1299340.0 |
| 2011-09-26 08:30:00 | AAPL | Stock | 14.3075 | 14.375 | 14.3075 | 14.3743 | 1241772.0 |
| 2011-09-26 08:35:00 | AAPL | Stock | 14.3639 | 14.3882 | 14.3543 | 14.3571 | 1181236.0 |
| 2011-09-26 08:40:00 | AAPL | Stock | 14.3543 | 14.3918 | 14.3525 | 14.3786 | 523320.0 |
| 2011-09-26 08:45:00 | AAPL | Stock | 14.3786 | 14.4107 | 14.3786 | 14.3861 | 1740228.0 |
| 2011-09-26 08:50:00 | AAPL | Stock | 14.3846 | 14.4104 | 14.3689 | 14.3689 | 2839732.0 |
> showing 50 of 330,539 rows — these rows as CSV