PREVIEW / stock_5min / 2014-05-06
file: by_date/stock_5min/2014/2014-05-06.parquet size: 5.4 MB rows: 358,797 symbols: 3,530
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 |
|---|---|---|---|---|---|---|---|
| 2014-05-06 04:00:00 | AAPL | Stock | 21.5354 | 21.5429 | 21.5354 | 21.5396 | 21560.0 |
| 2014-05-06 04:10:00 | AAPL | Stock | 21.5446 | 21.5821 | 21.5446 | 21.5821 | 39200.0 |
| 2014-05-06 04:15:00 | AAPL | Stock | 21.5693 | 21.5693 | 21.5464 | 21.5464 | 19600.0 |
| 2014-05-06 04:20:00 | AAPL | Stock | 21.4911 | 21.4911 | 21.4911 | 21.4911 | 4200.0 |
| 2014-05-06 04:35:00 | AAPL | Stock | 21.5289 | 21.5289 | 21.5289 | 21.5289 | 2800.0 |
| 2014-05-06 04:50:00 | AAPL | Stock | 21.5289 | 21.5289 | 21.5289 | 21.5289 | 2800.0 |
| 2014-05-06 05:20:00 | AAPL | Stock | 21.5286 | 21.5286 | 21.5286 | 21.5286 | 12880.0 |
| 2014-05-06 06:00:00 | AAPL | Stock | 21.5357 | 21.5357 | 21.5357 | 21.5357 | 54796.0 |
| 2014-05-06 06:10:00 | AAPL | Stock | 21.5179 | 21.5179 | 21.5179 | 21.5179 | 2800.0 |
| 2014-05-06 06:15:00 | AAPL | Stock | 21.5318 | 21.5318 | 21.5318 | 21.5318 | 2800.0 |
| 2014-05-06 06:40:00 | AAPL | Stock | 21.5286 | 21.5286 | 21.5286 | 21.5286 | 11200.0 |
| 2014-05-06 06:45:00 | AAPL | Stock | 21.5286 | 21.5286 | 21.5286 | 21.5286 | 2800.0 |
| 2014-05-06 06:55:00 | AAPL | Stock | 21.5286 | 21.5286 | 21.5 | 21.5 | 23884.0 |
| 2014-05-06 07:00:00 | AAPL | Stock | 21.5 | 21.52 | 21.5 | 21.5179 | 57316.0 |
| 2014-05-06 07:05:00 | AAPL | Stock | 21.5036 | 21.5214 | 21.5036 | 21.5214 | 22680.0 |
| 2014-05-06 07:10:00 | AAPL | Stock | 21.5243 | 21.5243 | 21.5139 | 21.5179 | 36120.0 |
| 2014-05-06 07:15:00 | AAPL | Stock | 21.5179 | 21.5179 | 21.5071 | 21.5175 | 28476.0 |
| 2014-05-06 07:20:00 | AAPL | Stock | 21.5175 | 21.5193 | 21.5089 | 21.5193 | 34832.0 |
| 2014-05-06 07:30:00 | AAPL | Stock | 21.5039 | 21.5164 | 21.5039 | 21.5086 | 24640.0 |
| 2014-05-06 07:35:00 | AAPL | Stock | 21.5175 | 21.5179 | 21.5111 | 21.5179 | 18200.0 |
| 2014-05-06 07:40:00 | AAPL | Stock | 21.5179 | 21.5179 | 21.5175 | 21.5175 | 22400.0 |
| 2014-05-06 07:45:00 | AAPL | Stock | 21.5175 | 21.5179 | 21.5143 | 21.5143 | 32424.0 |
| 2014-05-06 07:50:00 | AAPL | Stock | 21.5086 | 21.5086 | 21.4904 | 21.4904 | 132748.0 |
| 2014-05-06 07:55:00 | AAPL | Stock | 21.4964 | 21.4964 | 21.4964 | 21.4964 | 2800.0 |
| 2014-05-06 08:00:00 | AAPL | Stock | 21.4982 | 21.5304 | 21.4739 | 21.4739 | 341096.0 |
| 2014-05-06 08:05:00 | AAPL | Stock | 21.485 | 21.4939 | 21.485 | 21.4929 | 23296.0 |
| 2014-05-06 08:10:00 | AAPL | Stock | 21.4875 | 21.4875 | 21.4821 | 21.4836 | 35224.0 |
| 2014-05-06 08:15:00 | AAPL | Stock | 21.4868 | 21.4918 | 21.4664 | 21.4686 | 99260.0 |
| 2014-05-06 08:20:00 | AAPL | Stock | 21.4711 | 21.4714 | 21.4539 | 21.4714 | 189420.0 |
| 2014-05-06 08:25:00 | AAPL | Stock | 21.4796 | 21.4814 | 21.4654 | 21.4807 | 123144.0 |
| 2014-05-06 08:30:00 | AAPL | Stock | 21.48 | 21.4814 | 21.4682 | 21.4682 | 81368.0 |
| 2014-05-06 08:35:00 | AAPL | Stock | 21.4686 | 21.4757 | 21.4643 | 21.4757 | 45024.0 |
| 2014-05-06 08:40:00 | AAPL | Stock | 21.4696 | 21.4696 | 21.4357 | 21.4379 | 182476.0 |
| 2014-05-06 08:45:00 | AAPL | Stock | 21.4464 | 21.4536 | 21.4379 | 21.4489 | 110600.0 |
| 2014-05-06 08:50:00 | AAPL | Stock | 21.4471 | 21.4536 | 21.4464 | 21.4536 | 58800.0 |
| 2014-05-06 08:55:00 | AAPL | Stock | 21.4571 | 21.4607 | 21.4571 | 21.4604 | 69328.0 |
| 2014-05-06 09:00:00 | AAPL | Stock | 21.4643 | 21.4929 | 21.4643 | 21.4814 | 127344.0 |
| 2014-05-06 09:05:00 | AAPL | Stock | 21.4914 | 21.5089 | 21.4911 | 21.5068 | 268576.0 |
| 2014-05-06 09:10:00 | AAPL | Stock | 21.5039 | 21.5143 | 21.5036 | 21.5054 | 193004.0 |
| 2014-05-06 09:15:00 | AAPL | Stock | 21.505 | 21.5086 | 21.4954 | 21.4996 | 267204.0 |
| 2014-05-06 09:20:00 | AAPL | Stock | 21.4929 | 21.5 | 21.4929 | 21.4989 | 64400.0 |
| 2014-05-06 09:25:00 | AAPL | Stock | 21.4943 | 21.5082 | 21.4843 | 21.4943 | 315084.0 |
| 2014-05-06 09:30:00 | AAPL | Stock | 21.4929 | 21.5343 | 21.4675 | 21.4975 | 17048136.0 |
| 2014-05-06 09:35:00 | AAPL | Stock | 21.4889 | 21.4946 | 21.4175 | 21.4704 | 10483004.0 |
| 2014-05-06 09:40:00 | AAPL | Stock | 21.4675 | 21.5 | 21.45 | 21.4946 | 6849976.0 |
| 2014-05-06 09:45:00 | AAPL | Stock | 21.4946 | 21.5536 | 21.4864 | 21.5361 | 9594872.0 |
| 2014-05-06 09:50:00 | AAPL | Stock | 21.5339 | 21.5393 | 21.4893 | 21.5327 | 5887280.0 |
| 2014-05-06 09:55:00 | AAPL | Stock | 21.5325 | 21.5786 | 21.5125 | 21.5779 | 6174112.0 |
| 2014-05-06 10:00:00 | AAPL | Stock | 21.5793 | 21.5861 | 21.5289 | 21.5436 | 7703752.0 |
| 2014-05-06 10:05:00 | AAPL | Stock | 21.5479 | 21.5604 | 21.4775 | 21.4775 | 6793136.0 |
> showing 50 of 358,797 rows — these rows as CSV