PREVIEW / stock_5min / 2013-10-08
file: by_date/stock_5min/2013/2013-10-08.parquet size: 5.3 MB rows: 348,225 symbols: 3,520
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-10-08 04:10:00 | AAPL | Stock | 17.4196 | 17.4196 | 17.4196 | 17.4196 | 2800.0 |
| 2013-10-08 06:20:00 | AAPL | Stock | 17.4021 | 17.4021 | 17.4021 | 17.4021 | 2800.0 |
| 2013-10-08 06:25:00 | AAPL | Stock | 17.425 | 17.425 | 17.425 | 17.425 | 2800.0 |
| 2013-10-08 06:45:00 | AAPL | Stock | 17.4279 | 17.4279 | 17.4279 | 17.4279 | 2800.0 |
| 2013-10-08 07:00:00 | AAPL | Stock | 17.4286 | 17.4286 | 17.4286 | 17.4286 | 8400.0 |
| 2013-10-08 07:10:00 | AAPL | Stock | 17.4289 | 17.4289 | 17.4282 | 17.4282 | 8400.0 |
| 2013-10-08 07:15:00 | AAPL | Stock | 17.4196 | 17.4196 | 17.4196 | 17.4196 | 2800.0 |
| 2013-10-08 07:20:00 | AAPL | Stock | 17.4 | 17.4 | 17.3929 | 17.3929 | 33600.0 |
| 2013-10-08 07:25:00 | AAPL | Stock | 17.4054 | 17.4054 | 17.4032 | 17.4036 | 14000.0 |
| 2013-10-08 07:30:00 | AAPL | Stock | 17.4154 | 17.4232 | 17.4154 | 17.4221 | 28000.0 |
| 2013-10-08 07:45:00 | AAPL | Stock | 17.4246 | 17.4246 | 17.4107 | 17.4232 | 50960.0 |
| 2013-10-08 07:50:00 | AAPL | Stock | 17.4339 | 17.4414 | 17.4339 | 17.4354 | 64400.0 |
| 2013-10-08 07:55:00 | AAPL | Stock | 17.4404 | 17.4439 | 17.4404 | 17.4439 | 28280.0 |
| 2013-10-08 08:00:00 | AAPL | Stock | 17.4511 | 17.4729 | 17.3929 | 17.4554 | 275604.0 |
| 2013-10-08 08:05:00 | AAPL | Stock | 17.4554 | 17.5075 | 17.4554 | 17.4821 | 249900.0 |
| 2013-10-08 08:10:00 | AAPL | Stock | 17.495 | 17.4986 | 17.4821 | 17.4889 | 121100.0 |
| 2013-10-08 08:15:00 | AAPL | Stock | 17.4929 | 17.4964 | 17.4643 | 17.4821 | 202384.0 |
| 2013-10-08 08:20:00 | AAPL | Stock | 17.4839 | 17.4857 | 17.4786 | 17.4839 | 64400.0 |
| 2013-10-08 08:25:00 | AAPL | Stock | 17.4854 | 17.4889 | 17.4829 | 17.4875 | 144760.0 |
| 2013-10-08 08:30:00 | AAPL | Stock | 17.4814 | 17.4875 | 17.4757 | 17.4786 | 68376.0 |
| 2013-10-08 08:35:00 | AAPL | Stock | 17.4786 | 17.4804 | 17.475 | 17.475 | 47796.0 |
| 2013-10-08 08:40:00 | AAPL | Stock | 17.4757 | 17.4757 | 17.4643 | 17.4732 | 298760.0 |
| 2013-10-08 08:45:00 | AAPL | Stock | 17.4721 | 17.4768 | 17.4682 | 17.4768 | 231672.0 |
| 2013-10-08 08:50:00 | AAPL | Stock | 17.4771 | 17.4857 | 17.4764 | 17.4839 | 203280.0 |
| 2013-10-08 08:55:00 | AAPL | Stock | 17.4821 | 17.4846 | 17.4775 | 17.4779 | 64400.0 |
| 2013-10-08 09:00:00 | AAPL | Stock | 17.4811 | 17.4854 | 17.4757 | 17.4854 | 44800.0 |
| 2013-10-08 09:05:00 | AAPL | Stock | 17.4861 | 17.4868 | 17.4825 | 17.4829 | 32200.0 |
| 2013-10-08 09:10:00 | AAPL | Stock | 17.4821 | 17.4882 | 17.4821 | 17.4821 | 89040.0 |
| 2013-10-08 09:15:00 | AAPL | Stock | 17.4871 | 17.4946 | 17.4854 | 17.4939 | 174580.0 |
| 2013-10-08 09:20:00 | AAPL | Stock | 17.49 | 17.5064 | 17.4896 | 17.49 | 379092.0 |
| 2013-10-08 09:25:00 | AAPL | Stock | 17.4911 | 17.5 | 17.4843 | 17.4843 | 223020.0 |
| 2013-10-08 09:30:00 | AAPL | Stock | 17.4875 | 17.5089 | 17.4246 | 17.4492 | 12016704.0 |
| 2013-10-08 09:35:00 | AAPL | Stock | 17.4536 | 17.4786 | 17.4307 | 17.4702 | 5448548.0 |
| 2013-10-08 09:40:00 | AAPL | Stock | 17.47 | 17.4961 | 17.4286 | 17.4929 | 7191744.0 |
| 2013-10-08 09:45:00 | AAPL | Stock | 17.49 | 17.4929 | 17.4321 | 17.4322 | 6525288.0 |
| 2013-10-08 09:50:00 | AAPL | Stock | 17.4322 | 17.4714 | 17.3968 | 17.4714 | 8630412.0 |
| 2013-10-08 09:55:00 | AAPL | Stock | 17.4664 | 17.4918 | 17.4579 | 17.4782 | 5767692.0 |
| 2013-10-08 10:00:00 | AAPL | Stock | 17.4768 | 17.4814 | 17.4282 | 17.4682 | 7165032.0 |
| 2013-10-08 10:05:00 | AAPL | Stock | 17.4689 | 17.4889 | 17.4554 | 17.4811 | 3689420.0 |
| 2013-10-08 10:10:00 | AAPL | Stock | 17.4846 | 17.5 | 17.4554 | 17.4679 | 6142808.0 |
| 2013-10-08 10:15:00 | AAPL | Stock | 17.4682 | 17.5229 | 17.46 | 17.5061 | 6850872.0 |
| 2013-10-08 10:20:00 | AAPL | Stock | 17.5096 | 17.5229 | 17.4857 | 17.4964 | 3885728.0 |
| 2013-10-08 10:25:00 | AAPL | Stock | 17.4964 | 17.5057 | 17.4107 | 17.4227 | 5869332.0 |
| 2013-10-08 10:30:00 | AAPL | Stock | 17.4271 | 17.4511 | 17.4051 | 17.4446 | 4682888.0 |
| 2013-10-08 10:35:00 | AAPL | Stock | 17.4436 | 17.4493 | 17.4107 | 17.4277 | 4370632.0 |
| 2013-10-08 10:40:00 | AAPL | Stock | 17.4261 | 17.4311 | 17.3625 | 17.4079 | 6919416.0 |
| 2013-10-08 10:45:00 | AAPL | Stock | 17.4107 | 17.4175 | 17.3375 | 17.3407 | 6837712.0 |
| 2013-10-08 10:50:00 | AAPL | Stock | 17.3432 | 17.375 | 17.3089 | 17.3136 | 8345876.0 |
| 2013-10-08 10:55:00 | AAPL | Stock | 17.3211 | 17.3382 | 17.3086 | 17.33 | 4648896.0 |
| 2013-10-08 11:00:00 | AAPL | Stock | 17.3286 | 17.3382 | 17.3039 | 17.3139 | 4081560.0 |
> showing 50 of 348,225 rows — these rows as CSV