PREVIEW / stock_5min / 2013-04-30
file: by_date/stock_5min/2013/2013-04-30.parquet size: 5.1 MB rows: 339,272 symbols: 3,487
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-04-30 04:00:00 | AAPL | Stock | 15.3571 | 15.3571 | 15.3571 | 15.3571 | 22540.0 |
| 2013-04-30 04:05:00 | AAPL | Stock | 15.3575 | 15.3575 | 15.3575 | 15.3575 | 13916.0 |
| 2013-04-30 04:40:00 | AAPL | Stock | 15.4196 | 15.4196 | 15.4196 | 15.4196 | 11200.0 |
| 2013-04-30 04:45:00 | AAPL | Stock | 15.4196 | 15.4196 | 15.4196 | 15.4196 | 5600.0 |
| 2013-04-30 05:45:00 | AAPL | Stock | 15.4268 | 15.4268 | 15.4268 | 15.4268 | 2800.0 |
| 2013-04-30 06:10:00 | AAPL | Stock | 15.4496 | 15.4521 | 15.4496 | 15.4521 | 7000.0 |
| 2013-04-30 06:15:00 | AAPL | Stock | 15.4304 | 15.4304 | 15.4304 | 15.4304 | 2800.0 |
| 2013-04-30 06:50:00 | AAPL | Stock | 15.4289 | 15.4289 | 15.4289 | 15.4289 | 2800.0 |
| 2013-04-30 06:55:00 | AAPL | Stock | 15.4214 | 15.4214 | 15.4186 | 15.4214 | 11200.0 |
| 2013-04-30 07:00:00 | AAPL | Stock | 15.4186 | 15.4186 | 15.4096 | 15.4186 | 22064.0 |
| 2013-04-30 07:05:00 | AAPL | Stock | 15.4186 | 15.4286 | 15.4025 | 15.4154 | 42672.0 |
| 2013-04-30 07:10:00 | AAPL | Stock | 15.4129 | 15.4129 | 15.3929 | 15.3929 | 39200.0 |
| 2013-04-30 07:15:00 | AAPL | Stock | 15.3971 | 15.4214 | 15.3886 | 15.3886 | 70700.0 |
| 2013-04-30 07:20:00 | AAPL | Stock | 15.3929 | 15.4032 | 15.3929 | 15.3932 | 8400.0 |
| 2013-04-30 07:25:00 | AAPL | Stock | 15.4021 | 15.4021 | 15.4021 | 15.4021 | 2800.0 |
| 2013-04-30 07:30:00 | AAPL | Stock | 15.3996 | 15.4214 | 15.3996 | 15.4214 | 45416.0 |
| 2013-04-30 07:35:00 | AAPL | Stock | 15.4146 | 15.4186 | 15.4132 | 15.4132 | 22400.0 |
| 2013-04-30 07:40:00 | AAPL | Stock | 15.4114 | 15.4114 | 15.4107 | 15.4107 | 12516.0 |
| 2013-04-30 07:50:00 | AAPL | Stock | 15.4071 | 15.4125 | 15.4071 | 15.4107 | 33628.0 |
| 2013-04-30 07:55:00 | AAPL | Stock | 15.4039 | 15.4079 | 15.4036 | 15.405 | 25200.0 |
| 2013-04-30 08:00:00 | AAPL | Stock | 15.3986 | 15.4214 | 15.3861 | 15.4025 | 372904.0 |
| 2013-04-30 08:05:00 | AAPL | Stock | 15.3943 | 15.4011 | 15.3786 | 15.3786 | 106316.0 |
| 2013-04-30 08:10:00 | AAPL | Stock | 15.3768 | 15.3904 | 15.3571 | 15.3846 | 276052.0 |
| 2013-04-30 08:15:00 | AAPL | Stock | 15.3629 | 15.3736 | 15.3536 | 15.3729 | 139104.0 |
| 2013-04-30 08:20:00 | AAPL | Stock | 15.3729 | 15.3936 | 15.3679 | 15.3879 | 330708.0 |
| 2013-04-30 08:25:00 | AAPL | Stock | 15.3946 | 15.4086 | 15.3946 | 15.4018 | 538664.0 |
| 2013-04-30 08:30:00 | AAPL | Stock | 15.4068 | 15.4179 | 15.4011 | 15.4107 | 150500.0 |
| 2013-04-30 08:35:00 | AAPL | Stock | 15.4146 | 15.4161 | 15.4018 | 15.4018 | 143976.0 |
| 2013-04-30 08:40:00 | AAPL | Stock | 15.4107 | 15.4343 | 15.4054 | 15.425 | 482132.0 |
| 2013-04-30 08:45:00 | AAPL | Stock | 15.425 | 15.45 | 15.4214 | 15.45 | 593012.0 |
| 2013-04-30 08:50:00 | AAPL | Stock | 15.4529 | 15.4604 | 15.4489 | 15.4604 | 527968.0 |
| 2013-04-30 08:55:00 | AAPL | Stock | 15.4575 | 15.4857 | 15.4571 | 15.4854 | 850108.0 |
| 2013-04-30 09:00:00 | AAPL | Stock | 15.4832 | 15.4875 | 15.4643 | 15.4689 | 504308.0 |
| 2013-04-30 09:05:00 | AAPL | Stock | 15.4704 | 15.4704 | 15.4554 | 15.4611 | 501872.0 |
| 2013-04-30 09:10:00 | AAPL | Stock | 15.4643 | 15.5079 | 15.4643 | 15.5079 | 741384.0 |
| 2013-04-30 09:15:00 | AAPL | Stock | 15.5057 | 15.5071 | 15.4821 | 15.4821 | 324744.0 |
| 2013-04-30 09:20:00 | AAPL | Stock | 15.4807 | 15.4896 | 15.4779 | 15.4854 | 190876.0 |
| 2013-04-30 09:25:00 | AAPL | Stock | 15.4821 | 15.5475 | 15.4821 | 15.5411 | 1735748.0 |
| 2013-04-30 09:30:00 | AAPL | Stock | 15.5393 | 15.5843 | 15.5089 | 15.5625 | 31829784.0 |
| 2013-04-30 09:35:00 | AAPL | Stock | 15.5611 | 15.65 | 15.54 | 15.6397 | 23046156.0 |
| 2013-04-30 09:40:00 | AAPL | Stock | 15.6361 | 15.6654 | 15.6007 | 15.6307 | 24270904.0 |
| 2013-04-30 09:45:00 | AAPL | Stock | 15.635 | 15.6393 | 15.5714 | 15.6082 | 14047852.0 |
| 2013-04-30 09:50:00 | AAPL | Stock | 15.6111 | 15.6111 | 15.4968 | 15.5068 | 17886120.0 |
| 2013-04-30 09:55:00 | AAPL | Stock | 15.5061 | 15.5254 | 15.4311 | 15.4696 | 19035660.0 |
| 2013-04-30 10:00:00 | AAPL | Stock | 15.4716 | 15.5411 | 15.4621 | 15.495 | 14471604.0 |
| 2013-04-30 10:05:00 | AAPL | Stock | 15.4957 | 15.5671 | 15.4779 | 15.5621 | 10731168.0 |
| 2013-04-30 10:10:00 | AAPL | Stock | 15.5671 | 15.5711 | 15.5254 | 15.5546 | 7522956.0 |
| 2013-04-30 10:15:00 | AAPL | Stock | 15.5546 | 15.56 | 15.5268 | 15.535 | 4688544.0 |
| 2013-04-30 10:20:00 | AAPL | Stock | 15.5337 | 15.5354 | 15.4936 | 15.5071 | 5384204.0 |
| 2013-04-30 10:25:00 | AAPL | Stock | 15.5118 | 15.5307 | 15.5024 | 15.5057 | 4738328.0 |
> showing 50 of 339,272 rows — these rows as CSV