PREVIEW / stock_5min / 2011-05-06
file: by_date/stock_5min/2011/2011-05-06.parquet size: 4.9 MB rows: 331,349 symbols: 3,549
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 |
|---|---|---|---|---|---|---|---|
| 2011-05-06 04:05:00 | AAPL | Stock | 12.3829 | 12.3829 | 12.375 | 12.3768 | 36288.0 |
| 2011-05-06 04:10:00 | AAPL | Stock | 12.3768 | 12.3768 | 12.3768 | 12.3768 | 2800.0 |
| 2011-05-06 04:15:00 | AAPL | Stock | 12.375 | 12.375 | 12.375 | 12.375 | 2800.0 |
| 2011-05-06 05:25:00 | AAPL | Stock | 12.4179 | 12.4179 | 12.4179 | 12.4179 | 2800.0 |
| 2011-05-06 05:35:00 | AAPL | Stock | 12.4357 | 12.4357 | 12.4357 | 12.4357 | 2800.0 |
| 2011-05-06 05:55:00 | AAPL | Stock | 12.4457 | 12.4457 | 12.4457 | 12.4457 | 2800.0 |
| 2011-05-06 07:05:00 | AAPL | Stock | 12.4175 | 12.4175 | 12.4171 | 12.4171 | 8400.0 |
| 2011-05-06 07:10:00 | AAPL | Stock | 12.4125 | 12.4125 | 12.4125 | 12.4125 | 2912.0 |
| 2011-05-06 07:20:00 | AAPL | Stock | 12.4286 | 12.4286 | 12.4286 | 12.4286 | 14000.0 |
| 2011-05-06 07:35:00 | AAPL | Stock | 12.4125 | 12.4125 | 12.4125 | 12.4125 | 4564.0 |
| 2011-05-06 07:40:00 | AAPL | Stock | 12.4286 | 12.4357 | 12.4286 | 12.4357 | 28000.0 |
| 2011-05-06 07:50:00 | AAPL | Stock | 12.4175 | 12.4175 | 12.4171 | 12.4171 | 5600.0 |
| 2011-05-06 07:55:00 | AAPL | Stock | 12.4286 | 12.4286 | 12.4286 | 12.4286 | 19600.0 |
| 2011-05-06 08:00:00 | AAPL | Stock | 12.425 | 12.425 | 12.425 | 12.425 | 5600.0 |
| 2011-05-06 08:05:00 | AAPL | Stock | 12.425 | 12.425 | 12.4161 | 12.4161 | 43540.0 |
| 2011-05-06 08:10:00 | AAPL | Stock | 12.425 | 12.425 | 12.4193 | 12.4246 | 14532.0 |
| 2011-05-06 08:15:00 | AAPL | Stock | 12.4229 | 12.4246 | 12.4229 | 12.4246 | 57960.0 |
| 2011-05-06 08:20:00 | AAPL | Stock | 12.4246 | 12.4271 | 12.4125 | 12.4125 | 83300.0 |
| 2011-05-06 08:25:00 | AAPL | Stock | 12.4161 | 12.4254 | 12.4161 | 12.4232 | 41888.0 |
| 2011-05-06 08:30:00 | AAPL | Stock | 12.4196 | 12.4982 | 12.4196 | 12.4821 | 2025828.0 |
| 2011-05-06 08:35:00 | AAPL | Stock | 12.4821 | 12.4911 | 12.4746 | 12.4836 | 615748.0 |
| 2011-05-06 08:40:00 | AAPL | Stock | 12.4829 | 12.4886 | 12.4829 | 12.4879 | 57400.0 |
| 2011-05-06 08:45:00 | AAPL | Stock | 12.4868 | 12.5 | 12.4821 | 12.4968 | 307496.0 |
| 2011-05-06 08:50:00 | AAPL | Stock | 12.4993 | 12.5 | 12.4904 | 12.4946 | 489160.0 |
| 2011-05-06 08:55:00 | AAPL | Stock | 12.4936 | 12.4946 | 12.4821 | 12.4911 | 372904.0 |
| 2011-05-06 09:00:00 | AAPL | Stock | 12.4914 | 12.4996 | 12.4875 | 12.4964 | 299656.0 |
| 2011-05-06 09:05:00 | AAPL | Stock | 12.4996 | 12.5089 | 12.4957 | 12.5 | 467292.0 |
| 2011-05-06 09:10:00 | AAPL | Stock | 12.4996 | 12.5125 | 12.4996 | 12.5043 | 318248.0 |
| 2011-05-06 09:15:00 | AAPL | Stock | 12.5082 | 12.5139 | 12.5043 | 12.5043 | 321440.0 |
| 2011-05-06 09:20:00 | AAPL | Stock | 12.5046 | 12.5054 | 12.4964 | 12.4964 | 256480.0 |
| 2011-05-06 09:25:00 | AAPL | Stock | 12.4996 | 12.5054 | 12.4821 | 12.4904 | 338520.0 |
| 2011-05-06 09:30:00 | AAPL | Stock | 12.4889 | 12.5 | 12.4643 | 12.4964 | 14473956.0 |
| 2011-05-06 09:35:00 | AAPL | Stock | 12.4943 | 12.4943 | 12.4657 | 12.4725 | 7582988.0 |
| 2011-05-06 09:40:00 | AAPL | Stock | 12.4729 | 12.4804 | 12.45 | 12.4543 | 8267868.0 |
| 2011-05-06 09:45:00 | AAPL | Stock | 12.4542 | 12.4761 | 12.4336 | 12.4436 | 6909588.0 |
| 2011-05-06 09:50:00 | AAPL | Stock | 12.4404 | 12.4775 | 12.4404 | 12.4704 | 6126176.0 |
| 2011-05-06 09:55:00 | AAPL | Stock | 12.4682 | 12.4764 | 12.4507 | 12.4575 | 4309396.0 |
| 2011-05-06 10:00:00 | AAPL | Stock | 12.4575 | 12.4732 | 12.455 | 12.4625 | 3311476.0 |
| 2011-05-06 10:05:00 | AAPL | Stock | 12.4616 | 12.4643 | 12.4471 | 12.4536 | 4405044.0 |
| 2011-05-06 10:10:00 | AAPL | Stock | 12.4536 | 12.4668 | 12.4468 | 12.4668 | 3713892.0 |
| 2011-05-06 10:15:00 | AAPL | Stock | 12.4671 | 12.4682 | 12.4509 | 12.4621 | 2830856.0 |
| 2011-05-06 10:20:00 | AAPL | Stock | 12.4649 | 12.4786 | 12.4621 | 12.475 | 4251940.0 |
| 2011-05-06 10:25:00 | AAPL | Stock | 12.4771 | 12.4789 | 12.4646 | 12.4646 | 2724204.0 |
| 2011-05-06 10:30:00 | AAPL | Stock | 12.4675 | 12.4704 | 12.4554 | 12.46 | 2546432.0 |
| 2011-05-06 10:35:00 | AAPL | Stock | 12.4593 | 12.4696 | 12.4554 | 12.4689 | 2172856.0 |
| 2011-05-06 10:40:00 | AAPL | Stock | 12.4679 | 12.4764 | 12.4664 | 12.4718 | 3114608.0 |
| 2011-05-06 10:45:00 | AAPL | Stock | 12.4721 | 12.4768 | 12.4686 | 12.4739 | 2616460.0 |
| 2011-05-06 10:50:00 | AAPL | Stock | 12.4739 | 12.4764 | 12.4643 | 12.4643 | 2278556.0 |
| 2011-05-06 10:55:00 | AAPL | Stock | 12.4643 | 12.4789 | 12.4636 | 12.4757 | 2108708.0 |
| 2011-05-06 11:00:00 | AAPL | Stock | 12.4754 | 12.4854 | 12.4732 | 12.4836 | 2951396.0 |
> showing 50 of 331,349 rows — these rows as CSV