PREVIEW / stock_5min / 2012-03-05
file: by_date/stock_5min/2012/2012-03-05.parquet size: 4.8 MB rows: 325,609 symbols: 3,492
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 |
|---|---|---|---|---|---|---|---|
| 2012-03-05 04:00:00 | AAPL | Stock | 19.4107 | 19.4107 | 19.4107 | 19.4107 | 2800.0 |
| 2012-03-05 04:50:00 | AAPL | Stock | 19.4436 | 19.4436 | 19.4436 | 19.4436 | 10220.0 |
| 2012-03-05 05:00:00 | AAPL | Stock | 19.4546 | 19.4621 | 19.4546 | 19.4621 | 19600.0 |
| 2012-03-05 05:30:00 | AAPL | Stock | 19.4643 | 19.4643 | 19.4643 | 19.4643 | 2800.0 |
| 2012-03-05 06:15:00 | AAPL | Stock | 19.4786 | 19.4893 | 19.4786 | 19.4893 | 14952.0 |
| 2012-03-05 06:20:00 | AAPL | Stock | 19.4904 | 19.4904 | 19.4904 | 19.4904 | 2800.0 |
| 2012-03-05 06:40:00 | AAPL | Stock | 19.4821 | 19.4821 | 19.4821 | 19.4821 | 18200.0 |
| 2012-03-05 06:45:00 | AAPL | Stock | 19.4821 | 19.4821 | 19.4821 | 19.4821 | 8400.0 |
| 2012-03-05 06:55:00 | AAPL | Stock | 19.4704 | 19.4704 | 19.4679 | 19.4679 | 11200.0 |
| 2012-03-05 07:00:00 | AAPL | Stock | 19.4643 | 19.4643 | 19.4461 | 19.4464 | 51800.0 |
| 2012-03-05 07:05:00 | AAPL | Stock | 19.44 | 19.4464 | 19.4339 | 19.4393 | 56000.0 |
| 2012-03-05 07:10:00 | AAPL | Stock | 19.445 | 19.4554 | 19.4436 | 19.4554 | 38248.0 |
| 2012-03-05 07:20:00 | AAPL | Stock | 19.4571 | 19.4571 | 19.4482 | 19.4482 | 40908.0 |
| 2012-03-05 07:25:00 | AAPL | Stock | 19.4468 | 19.4468 | 19.4393 | 19.4407 | 24668.0 |
| 2012-03-05 07:30:00 | AAPL | Stock | 19.4429 | 19.4514 | 19.4429 | 19.4514 | 5600.0 |
| 2012-03-05 07:35:00 | AAPL | Stock | 19.4529 | 19.4536 | 19.4529 | 19.4536 | 47600.0 |
| 2012-03-05 07:40:00 | AAPL | Stock | 19.4607 | 19.4625 | 19.4571 | 19.4571 | 22064.0 |
| 2012-03-05 07:45:00 | AAPL | Stock | 19.4604 | 19.4604 | 19.4571 | 19.4571 | 14420.0 |
| 2012-03-05 07:50:00 | AAPL | Stock | 19.4557 | 19.4604 | 19.4554 | 19.4554 | 39480.0 |
| 2012-03-05 07:55:00 | AAPL | Stock | 19.4554 | 19.4554 | 19.4554 | 19.4554 | 2800.0 |
| 2012-03-05 08:00:00 | AAPL | Stock | 19.4468 | 19.4621 | 19.4464 | 19.4589 | 334936.0 |
| 2012-03-05 08:05:00 | AAPL | Stock | 19.4607 | 19.4786 | 19.4579 | 19.475 | 413896.0 |
| 2012-03-05 08:10:00 | AAPL | Stock | 19.4786 | 19.4789 | 19.4639 | 19.4639 | 577248.0 |
| 2012-03-05 08:15:00 | AAPL | Stock | 19.4643 | 19.4736 | 19.4643 | 19.4718 | 83160.0 |
| 2012-03-05 08:20:00 | AAPL | Stock | 19.4732 | 19.475 | 19.4475 | 19.4475 | 824880.0 |
| 2012-03-05 08:25:00 | AAPL | Stock | 19.4471 | 19.4643 | 19.4432 | 19.4561 | 331884.0 |
| 2012-03-05 08:30:00 | AAPL | Stock | 19.4621 | 19.4704 | 19.4596 | 19.4643 | 172284.0 |
| 2012-03-05 08:35:00 | AAPL | Stock | 19.4643 | 19.4671 | 19.4607 | 19.4671 | 128128.0 |
| 2012-03-05 08:40:00 | AAPL | Stock | 19.4632 | 19.4682 | 19.4607 | 19.4675 | 98728.0 |
| 2012-03-05 08:45:00 | AAPL | Stock | 19.4646 | 19.4646 | 19.4643 | 19.4643 | 41916.0 |
| 2012-03-05 08:50:00 | AAPL | Stock | 19.4643 | 19.4782 | 19.4625 | 19.4782 | 156800.0 |
| 2012-03-05 08:55:00 | AAPL | Stock | 19.4739 | 19.5057 | 19.4732 | 19.4929 | 509320.0 |
| 2012-03-05 09:00:00 | AAPL | Stock | 19.4954 | 19.5179 | 19.4875 | 19.5039 | 571088.0 |
| 2012-03-05 09:05:00 | AAPL | Stock | 19.5057 | 19.5164 | 19.5043 | 19.5164 | 318640.0 |
| 2012-03-05 09:10:00 | AAPL | Stock | 19.5125 | 19.5143 | 19.4929 | 19.4946 | 531692.0 |
| 2012-03-05 09:15:00 | AAPL | Stock | 19.5 | 19.5086 | 19.4936 | 19.4936 | 212492.0 |
| 2012-03-05 09:20:00 | AAPL | Stock | 19.4929 | 19.4929 | 19.475 | 19.4768 | 342776.0 |
| 2012-03-05 09:25:00 | AAPL | Stock | 19.4771 | 19.5 | 19.4679 | 19.4857 | 444584.0 |
| 2012-03-05 09:30:00 | AAPL | Stock | 19.4825 | 19.5107 | 19.4511 | 19.4939 | 17520188.0 |
| 2012-03-05 09:35:00 | AAPL | Stock | 19.4926 | 19.5421 | 19.4868 | 19.5418 | 13926080.0 |
| 2012-03-05 09:40:00 | AAPL | Stock | 19.5407 | 19.5529 | 19.5132 | 19.53 | 11655784.0 |
| 2012-03-05 09:45:00 | AAPL | Stock | 19.5286 | 19.5386 | 19.5154 | 19.5386 | 7667604.0 |
| 2012-03-05 09:50:00 | AAPL | Stock | 19.5384 | 19.5384 | 19.5 | 19.5132 | 7965104.0 |
| 2012-03-05 09:55:00 | AAPL | Stock | 19.5166 | 19.5293 | 19.4896 | 19.5052 | 7072716.0 |
| 2012-03-05 10:00:00 | AAPL | Stock | 19.506 | 19.5357 | 19.4918 | 19.5357 | 7166320.0 |
| 2012-03-05 10:05:00 | AAPL | Stock | 19.5357 | 19.5378 | 19.5136 | 19.5292 | 8174124.0 |
| 2012-03-05 10:10:00 | AAPL | Stock | 19.5279 | 19.5307 | 19.5129 | 19.5239 | 6840288.0 |
| 2012-03-05 10:15:00 | AAPL | Stock | 19.5259 | 19.5325 | 19.4971 | 19.4975 | 5907468.0 |
| 2012-03-05 10:20:00 | AAPL | Stock | 19.499 | 19.5021 | 19.4464 | 19.4643 | 10392508.0 |
| 2012-03-05 10:25:00 | AAPL | Stock | 19.4661 | 19.4689 | 19.4321 | 19.4347 | 8089144.0 |
> showing 50 of 325,609 rows — these rows as CSV