PREVIEW / stock_5min / 2013-11-21
file: by_date/stock_5min/2013/2013-11-21.parquet size: 5.4 MB rows: 354,412 symbols: 3,525
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 |
|---|---|---|---|---|---|---|---|
| 2013-11-21 04:25:00 | AAPL | Stock | 18.3889 | 18.3889 | 18.3768 | 18.3889 | 8400.0 |
| 2013-11-21 04:30:00 | AAPL | Stock | 18.3818 | 18.3946 | 18.3771 | 18.3771 | 28364.0 |
| 2013-11-21 04:35:00 | AAPL | Stock | 18.3854 | 18.3918 | 18.3854 | 18.3918 | 17052.0 |
| 2013-11-21 05:10:00 | AAPL | Stock | 18.3929 | 18.3929 | 18.3929 | 18.3929 | 14000.0 |
| 2013-11-21 05:15:00 | AAPL | Stock | 18.3929 | 18.3929 | 18.3929 | 18.3929 | 14000.0 |
| 2013-11-21 05:20:00 | AAPL | Stock | 18.4114 | 18.4114 | 18.4114 | 18.4114 | 2800.0 |
| 2013-11-21 05:45:00 | AAPL | Stock | 18.4161 | 18.4161 | 18.4161 | 18.4161 | 5600.0 |
| 2013-11-21 06:20:00 | AAPL | Stock | 18.4232 | 18.4286 | 18.415 | 18.415 | 61852.0 |
| 2013-11-21 06:40:00 | AAPL | Stock | 18.4286 | 18.4286 | 18.4286 | 18.4286 | 4620.0 |
| 2013-11-21 07:00:00 | AAPL | Stock | 18.4129 | 18.4129 | 18.4118 | 18.4118 | 5600.0 |
| 2013-11-21 07:10:00 | AAPL | Stock | 18.4196 | 18.4196 | 18.4196 | 18.4196 | 7000.0 |
| 2013-11-21 07:15:00 | AAPL | Stock | 18.4196 | 18.4268 | 18.4196 | 18.4268 | 20272.0 |
| 2013-11-21 07:20:00 | AAPL | Stock | 18.4214 | 18.4514 | 18.4214 | 18.4514 | 10108.0 |
| 2013-11-21 07:25:00 | AAPL | Stock | 18.4464 | 18.4464 | 18.4464 | 18.4464 | 2800.0 |
| 2013-11-21 07:30:00 | AAPL | Stock | 18.4607 | 18.4607 | 18.4486 | 18.4486 | 27440.0 |
| 2013-11-21 07:35:00 | AAPL | Stock | 18.4804 | 18.4864 | 18.4804 | 18.4864 | 21840.0 |
| 2013-11-21 07:40:00 | AAPL | Stock | 18.4679 | 18.4679 | 18.4554 | 18.4643 | 49000.0 |
| 2013-11-21 07:45:00 | AAPL | Stock | 18.4643 | 18.4643 | 18.4625 | 18.4625 | 30800.0 |
| 2013-11-21 07:50:00 | AAPL | Stock | 18.4761 | 18.4839 | 18.4761 | 18.4786 | 112000.0 |
| 2013-11-21 07:55:00 | AAPL | Stock | 18.4793 | 18.4864 | 18.4786 | 18.4821 | 49840.0 |
| 2013-11-21 08:00:00 | AAPL | Stock | 18.4786 | 18.4861 | 18.3893 | 18.4839 | 47880.0 |
| 2013-11-21 08:05:00 | AAPL | Stock | 18.4714 | 18.475 | 18.4643 | 18.475 | 54908.0 |
| 2013-11-21 08:10:00 | AAPL | Stock | 18.4643 | 18.4857 | 18.4643 | 18.4839 | 72800.0 |
| 2013-11-21 08:15:00 | AAPL | Stock | 18.4857 | 18.4857 | 18.3929 | 18.485 | 291200.0 |
| 2013-11-21 08:20:00 | AAPL | Stock | 18.4754 | 18.4754 | 18.465 | 18.475 | 57400.0 |
| 2013-11-21 08:25:00 | AAPL | Stock | 18.4646 | 18.475 | 18.4643 | 18.4679 | 145824.0 |
| 2013-11-21 08:30:00 | AAPL | Stock | 18.47 | 18.475 | 18.4596 | 18.4596 | 22120.0 |
| 2013-11-21 08:35:00 | AAPL | Stock | 18.4643 | 18.475 | 18.4604 | 18.475 | 126924.0 |
| 2013-11-21 08:40:00 | AAPL | Stock | 18.475 | 18.4893 | 18.475 | 18.4821 | 207816.0 |
| 2013-11-21 08:45:00 | AAPL | Stock | 18.4829 | 18.5171 | 18.4821 | 18.5125 | 529340.0 |
| 2013-11-21 08:50:00 | AAPL | Stock | 18.5054 | 18.5254 | 18.5054 | 18.5071 | 361788.0 |
| 2013-11-21 08:55:00 | AAPL | Stock | 18.51 | 18.5211 | 18.5075 | 18.5089 | 214312.0 |
| 2013-11-21 09:00:00 | AAPL | Stock | 18.5089 | 18.5214 | 18.5054 | 18.5211 | 96040.0 |
| 2013-11-21 09:05:00 | AAPL | Stock | 18.5107 | 18.5443 | 18.5107 | 18.5411 | 453516.0 |
| 2013-11-21 09:10:00 | AAPL | Stock | 18.5446 | 18.5518 | 18.5382 | 18.5446 | 306516.0 |
| 2013-11-21 09:15:00 | AAPL | Stock | 18.5461 | 18.5464 | 18.5357 | 18.5357 | 294840.0 |
| 2013-11-21 09:20:00 | AAPL | Stock | 18.5268 | 18.545 | 18.5268 | 18.5282 | 278152.0 |
| 2013-11-21 09:25:00 | AAPL | Stock | 18.5268 | 18.5286 | 18.4843 | 18.4857 | 483588.0 |
| 2013-11-21 09:30:00 | AAPL | Stock | 18.4871 | 18.5314 | 18.4396 | 18.5125 | 10571736.0 |
| 2013-11-21 09:35:00 | AAPL | Stock | 18.5115 | 18.5143 | 18.4757 | 18.5007 | 4514356.0 |
| 2013-11-21 09:40:00 | AAPL | Stock | 18.5059 | 18.5068 | 18.4557 | 18.5 | 6316716.0 |
| 2013-11-21 09:45:00 | AAPL | Stock | 18.5 | 18.5036 | 18.4829 | 18.4989 | 6138692.0 |
| 2013-11-21 09:50:00 | AAPL | Stock | 18.5 | 18.5 | 18.4589 | 18.4682 | 5726084.0 |
| 2013-11-21 09:55:00 | AAPL | Stock | 18.4689 | 18.5029 | 18.4607 | 18.492 | 7277424.0 |
| 2013-11-21 10:00:00 | AAPL | Stock | 18.4964 | 18.4996 | 18.4664 | 18.4732 | 2327332.0 |
| 2013-11-21 10:05:00 | AAPL | Stock | 18.475 | 18.4811 | 18.4472 | 18.4556 | 2816296.0 |
| 2013-11-21 10:10:00 | AAPL | Stock | 18.4561 | 18.4593 | 18.4189 | 18.4414 | 5204668.0 |
| 2013-11-21 10:15:00 | AAPL | Stock | 18.445 | 18.445 | 18.4089 | 18.4182 | 4376344.0 |
| 2013-11-21 10:20:00 | AAPL | Stock | 18.4214 | 18.4439 | 18.4179 | 18.4271 | 3351124.0 |
| 2013-11-21 10:25:00 | AAPL | Stock | 18.4243 | 18.4518 | 18.4229 | 18.4464 | 2249800.0 |
> showing 50 of 354,412 rows — these rows as CSV