PREVIEW / stock_5min / 2013-12-20
file: by_date/stock_5min/2013/2013-12-20.parquet size: 5.8 MB rows: 377,360 symbols: 3,541
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-12-20 04:30:00 | AAPL | Stock | 19.5082 | 19.5082 | 19.5075 | 19.5075 | 16800.0 |
| 2013-12-20 04:35:00 | AAPL | Stock | 19.5075 | 19.5075 | 19.5075 | 19.5075 | 5600.0 |
| 2013-12-20 04:50:00 | AAPL | Stock | 19.5104 | 19.5104 | 19.5075 | 19.5104 | 14000.0 |
| 2013-12-20 04:55:00 | AAPL | Stock | 19.5104 | 19.5104 | 19.5104 | 19.5104 | 2800.0 |
| 2013-12-20 05:10:00 | AAPL | Stock | 19.5046 | 19.5154 | 19.5043 | 19.5154 | 19600.0 |
| 2013-12-20 05:30:00 | AAPL | Stock | 19.5054 | 19.5054 | 19.5054 | 19.5054 | 2800.0 |
| 2013-12-20 05:40:00 | AAPL | Stock | 19.5046 | 19.5046 | 19.5046 | 19.5046 | 2800.0 |
| 2013-12-20 06:45:00 | AAPL | Stock | 19.5164 | 19.5164 | 19.4893 | 19.4893 | 12600.0 |
| 2013-12-20 06:50:00 | AAPL | Stock | 19.4721 | 19.4721 | 19.4721 | 19.4721 | 2800.0 |
| 2013-12-20 07:00:00 | AAPL | Stock | 19.4814 | 19.4929 | 19.4775 | 19.4775 | 16744.0 |
| 2013-12-20 07:05:00 | AAPL | Stock | 19.4786 | 19.4786 | 19.4536 | 19.4536 | 28000.0 |
| 2013-12-20 07:10:00 | AAPL | Stock | 19.4632 | 19.4643 | 19.4632 | 19.4643 | 46200.0 |
| 2013-12-20 07:15:00 | AAPL | Stock | 19.4686 | 19.4786 | 19.4686 | 19.4786 | 8988.0 |
| 2013-12-20 07:20:00 | AAPL | Stock | 19.4664 | 19.4664 | 19.4571 | 19.4571 | 19600.0 |
| 2013-12-20 07:25:00 | AAPL | Stock | 19.4639 | 19.4643 | 19.4625 | 19.4643 | 89600.0 |
| 2013-12-20 07:30:00 | AAPL | Stock | 19.4643 | 19.4821 | 19.4571 | 19.4821 | 50400.0 |
| 2013-12-20 07:35:00 | AAPL | Stock | 19.4857 | 19.4857 | 19.4857 | 19.4857 | 2800.0 |
| 2013-12-20 07:40:00 | AAPL | Stock | 19.4761 | 19.4761 | 19.4761 | 19.4761 | 2800.0 |
| 2013-12-20 07:45:00 | AAPL | Stock | 19.4757 | 19.4757 | 19.4757 | 19.4757 | 2800.0 |
| 2013-12-20 07:55:00 | AAPL | Stock | 19.49 | 19.4946 | 19.4857 | 19.4946 | 20160.0 |
| 2013-12-20 08:00:00 | AAPL | Stock | 19.4482 | 19.5286 | 19.4464 | 19.5179 | 208488.0 |
| 2013-12-20 08:05:00 | AAPL | Stock | 19.5179 | 19.5179 | 19.4961 | 19.5021 | 47600.0 |
| 2013-12-20 08:10:00 | AAPL | Stock | 19.5021 | 19.5021 | 19.4882 | 19.4986 | 31220.0 |
| 2013-12-20 08:15:00 | AAPL | Stock | 19.4993 | 19.5086 | 19.4993 | 19.4993 | 117964.0 |
| 2013-12-20 08:20:00 | AAPL | Stock | 19.4971 | 19.5036 | 19.445 | 19.5 | 200928.0 |
| 2013-12-20 08:25:00 | AAPL | Stock | 19.5036 | 19.5036 | 19.5 | 19.5018 | 22400.0 |
| 2013-12-20 08:30:00 | AAPL | Stock | 19.5 | 19.5104 | 19.5 | 19.5089 | 168476.0 |
| 2013-12-20 08:35:00 | AAPL | Stock | 19.5093 | 19.5093 | 19.5021 | 19.5021 | 8400.0 |
| 2013-12-20 08:40:00 | AAPL | Stock | 19.5054 | 19.5179 | 19.5039 | 19.5179 | 104720.0 |
| 2013-12-20 08:45:00 | AAPL | Stock | 19.5179 | 19.5207 | 19.5121 | 19.5121 | 62440.0 |
| 2013-12-20 08:50:00 | AAPL | Stock | 19.5125 | 19.5171 | 19.5121 | 19.5121 | 16800.0 |
| 2013-12-20 08:55:00 | AAPL | Stock | 19.5157 | 19.52 | 19.5157 | 19.5179 | 81900.0 |
| 2013-12-20 09:00:00 | AAPL | Stock | 19.5179 | 19.5279 | 19.5136 | 19.5279 | 173040.0 |
| 2013-12-20 09:05:00 | AAPL | Stock | 19.5282 | 19.5282 | 19.5121 | 19.5168 | 117600.0 |
| 2013-12-20 09:10:00 | AAPL | Stock | 19.5121 | 19.5121 | 19.5021 | 19.5021 | 110656.0 |
| 2013-12-20 09:15:00 | AAPL | Stock | 19.5086 | 19.5086 | 19.491 | 19.491 | 214872.0 |
| 2013-12-20 09:20:00 | AAPL | Stock | 19.4911 | 19.5018 | 19.4857 | 19.4911 | 239540.0 |
| 2013-12-20 09:25:00 | AAPL | Stock | 19.4864 | 19.4982 | 19.4646 | 19.4821 | 333928.0 |
| 2013-12-20 09:30:00 | AAPL | Stock | 19.4818 | 19.5257 | 19.4646 | 19.4882 | 49070588.0 |
| 2013-12-20 09:35:00 | AAPL | Stock | 19.4889 | 19.5696 | 19.4578 | 19.5436 | 10067288.0 |
| 2013-12-20 09:40:00 | AAPL | Stock | 19.5478 | 19.5882 | 19.5293 | 19.5704 | 7063672.0 |
| 2013-12-20 09:45:00 | AAPL | Stock | 19.57 | 19.61 | 19.5679 | 19.5964 | 7500136.0 |
| 2013-12-20 09:50:00 | AAPL | Stock | 19.6007 | 19.6157 | 19.5911 | 19.6039 | 6375712.0 |
| 2013-12-20 09:55:00 | AAPL | Stock | 19.6021 | 19.6196 | 19.5982 | 19.603 | 6510644.0 |
| 2013-12-20 10:00:00 | AAPL | Stock | 19.6046 | 19.6214 | 19.6018 | 19.6045 | 4008340.0 |
| 2013-12-20 10:05:00 | AAPL | Stock | 19.6043 | 19.6121 | 19.5746 | 19.5807 | 4710608.0 |
| 2013-12-20 10:10:00 | AAPL | Stock | 19.5768 | 19.6121 | 19.5757 | 19.6111 | 5458124.0 |
| 2013-12-20 10:15:00 | AAPL | Stock | 19.6107 | 19.6311 | 19.6096 | 19.6289 | 6280680.0 |
| 2013-12-20 10:20:00 | AAPL | Stock | 19.6295 | 19.6389 | 19.6036 | 19.6239 | 5747616.0 |
| 2013-12-20 10:25:00 | AAPL | Stock | 19.6246 | 19.6371 | 19.6179 | 19.6371 | 3347624.0 |
> showing 50 of 377,360 rows — these rows as CSV