PREVIEW / stock_5min / 2012-12-26
file: by_date/stock_5min/2012/2012-12-26.parquet size: 4.6 MB rows: 312,677 symbols: 3,481
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-12-26 07:05:00 | AAPL | Stock | 18.6468 | 18.6468 | 18.6339 | 18.6339 | 39200.0 |
| 2012-12-26 07:10:00 | AAPL | Stock | 18.6429 | 18.6429 | 18.6429 | 18.6429 | 5600.0 |
| 2012-12-26 07:15:00 | AAPL | Stock | 18.6164 | 18.6393 | 18.6164 | 18.6393 | 11200.0 |
| 2012-12-26 07:20:00 | AAPL | Stock | 18.6393 | 18.6418 | 18.6393 | 18.6418 | 16800.0 |
| 2012-12-26 07:30:00 | AAPL | Stock | 18.6429 | 18.6429 | 18.6429 | 18.6429 | 2800.0 |
| 2012-12-26 07:40:00 | AAPL | Stock | 18.6311 | 18.6311 | 18.615 | 18.615 | 25200.0 |
| 2012-12-26 07:45:00 | AAPL | Stock | 18.6179 | 18.6179 | 18.6143 | 18.6143 | 24080.0 |
| 2012-12-26 07:50:00 | AAPL | Stock | 18.6125 | 18.6125 | 18.6071 | 18.6071 | 27860.0 |
| 2012-12-26 07:55:00 | AAPL | Stock | 18.6071 | 18.6136 | 18.6071 | 18.6136 | 5600.0 |
| 2012-12-26 08:00:00 | AAPL | Stock | 18.6111 | 18.6429 | 18.5932 | 18.5932 | 89908.0 |
| 2012-12-26 08:05:00 | AAPL | Stock | 18.5982 | 18.5982 | 18.5821 | 18.5821 | 94108.0 |
| 2012-12-26 08:10:00 | AAPL | Stock | 18.5832 | 18.5836 | 18.5721 | 18.5804 | 95564.0 |
| 2012-12-26 08:15:00 | AAPL | Stock | 18.5786 | 18.5786 | 18.56 | 18.5657 | 78400.0 |
| 2012-12-26 08:20:00 | AAPL | Stock | 18.5714 | 18.5925 | 18.5714 | 18.5925 | 77224.0 |
| 2012-12-26 08:25:00 | AAPL | Stock | 18.5961 | 18.6064 | 18.5961 | 18.6057 | 98000.0 |
| 2012-12-26 08:30:00 | AAPL | Stock | 18.5986 | 18.6054 | 18.595 | 18.595 | 26880.0 |
| 2012-12-26 08:35:00 | AAPL | Stock | 18.5971 | 18.6 | 18.5857 | 18.5857 | 35000.0 |
| 2012-12-26 08:40:00 | AAPL | Stock | 18.5879 | 18.5886 | 18.5846 | 18.5846 | 16800.0 |
| 2012-12-26 08:45:00 | AAPL | Stock | 18.5832 | 18.5832 | 18.5714 | 18.5782 | 105756.0 |
| 2012-12-26 08:50:00 | AAPL | Stock | 18.5768 | 18.5882 | 18.5768 | 18.5864 | 77140.0 |
| 2012-12-26 08:55:00 | AAPL | Stock | 18.5843 | 18.5843 | 18.5668 | 18.57 | 159124.0 |
| 2012-12-26 09:00:00 | AAPL | Stock | 18.5696 | 18.5718 | 18.5625 | 18.5718 | 103096.0 |
| 2012-12-26 09:05:00 | AAPL | Stock | 18.58 | 18.5821 | 18.5786 | 18.5796 | 28000.0 |
| 2012-12-26 09:10:00 | AAPL | Stock | 18.5736 | 18.5736 | 18.5679 | 18.5714 | 114352.0 |
| 2012-12-26 09:15:00 | AAPL | Stock | 18.5679 | 18.5771 | 18.5679 | 18.5704 | 264264.0 |
| 2012-12-26 09:20:00 | AAPL | Stock | 18.5664 | 18.5736 | 18.5536 | 18.5536 | 126224.0 |
| 2012-12-26 09:25:00 | AAPL | Stock | 18.5539 | 18.5661 | 18.515 | 18.5275 | 528696.0 |
| 2012-12-26 09:30:00 | AAPL | Stock | 18.535 | 18.5521 | 18.475 | 18.475 | 8820980.0 |
| 2012-12-26 09:35:00 | AAPL | Stock | 18.4804 | 18.5146 | 18.4636 | 18.5029 | 6678224.0 |
| 2012-12-26 09:40:00 | AAPL | Stock | 18.5025 | 18.5346 | 18.4439 | 18.4557 | 6439692.0 |
| 2012-12-26 09:45:00 | AAPL | Stock | 18.4514 | 18.5068 | 18.4493 | 18.5021 | 3770900.0 |
| 2012-12-26 09:50:00 | AAPL | Stock | 18.4925 | 18.5104 | 18.47 | 18.47 | 3306408.0 |
| 2012-12-26 09:55:00 | AAPL | Stock | 18.471 | 18.525 | 18.4669 | 18.5118 | 3212776.0 |
| 2012-12-26 10:00:00 | AAPL | Stock | 18.5064 | 18.5232 | 18.4796 | 18.4868 | 2475900.0 |
| 2012-12-26 10:05:00 | AAPL | Stock | 18.4873 | 18.5114 | 18.4696 | 18.4825 | 3394860.0 |
| 2012-12-26 10:10:00 | AAPL | Stock | 18.4796 | 18.4868 | 18.4536 | 18.4625 | 2464476.0 |
| 2012-12-26 10:15:00 | AAPL | Stock | 18.4611 | 18.48 | 18.4382 | 18.4536 | 2990792.0 |
| 2012-12-26 10:20:00 | AAPL | Stock | 18.4457 | 18.4521 | 18.4157 | 18.42 | 5206656.0 |
| 2012-12-26 10:25:00 | AAPL | Stock | 18.4225 | 18.4407 | 18.4146 | 18.4321 | 3458280.0 |
| 2012-12-26 10:30:00 | AAPL | Stock | 18.4354 | 18.4386 | 18.4057 | 18.4229 | 4432456.0 |
| 2012-12-26 10:35:00 | AAPL | Stock | 18.4232 | 18.4293 | 18.3639 | 18.3639 | 9246020.0 |
| 2012-12-26 10:40:00 | AAPL | Stock | 18.3654 | 18.3893 | 18.3375 | 18.3575 | 8069460.0 |
| 2012-12-26 10:45:00 | AAPL | Stock | 18.3569 | 18.3718 | 18.3425 | 18.352 | 4719820.0 |
| 2012-12-26 10:50:00 | AAPL | Stock | 18.3518 | 18.3582 | 18.3239 | 18.3347 | 4685016.0 |
| 2012-12-26 10:55:00 | AAPL | Stock | 18.3325 | 18.3661 | 18.3293 | 18.3375 | 4987472.0 |
| 2012-12-26 11:00:00 | AAPL | Stock | 18.3375 | 18.3607 | 18.3107 | 18.3189 | 6260548.0 |
| 2012-12-26 11:05:00 | AAPL | Stock | 18.3193 | 18.3193 | 18.2679 | 18.2846 | 8689436.0 |
| 2012-12-26 11:10:00 | AAPL | Stock | 18.2839 | 18.31 | 18.2679 | 18.2879 | 5168996.0 |
| 2012-12-26 11:15:00 | AAPL | Stock | 18.2918 | 18.3118 | 18.275 | 18.2986 | 4178524.0 |
| 2012-12-26 11:20:00 | AAPL | Stock | 18.3021 | 18.3161 | 18.2768 | 18.3125 | 4525276.0 |
> showing 50 of 312,677 rows — these rows as CSV