PREVIEW / stock_5min / 2011-05-02
file: by_date/stock_5min/2011/2011-05-02.parquet size: 4.9 MB rows: 331,768 symbols: 3,567
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-02 04:00:00 | AAPL | Stock | 12.5786 | 12.6071 | 12.5786 | 12.6071 | 60760.0 |
| 2011-05-02 04:55:00 | AAPL | Stock | 12.5932 | 12.5932 | 12.5932 | 12.5932 | 2800.0 |
| 2011-05-02 05:10:00 | AAPL | Stock | 12.6071 | 12.6071 | 12.6071 | 12.6071 | 5600.0 |
| 2011-05-02 05:30:00 | AAPL | Stock | 12.6154 | 12.6154 | 12.6154 | 12.6154 | 2800.0 |
| 2011-05-02 05:40:00 | AAPL | Stock | 12.6107 | 12.6107 | 12.6071 | 12.6071 | 8400.0 |
| 2011-05-02 06:05:00 | AAPL | Stock | 12.5829 | 12.5829 | 12.5829 | 12.5829 | 14000.0 |
| 2011-05-02 06:10:00 | AAPL | Stock | 12.5821 | 12.5821 | 12.5714 | 12.5714 | 11200.0 |
| 2011-05-02 06:20:00 | AAPL | Stock | 12.5961 | 12.5961 | 12.5961 | 12.5961 | 5600.0 |
| 2011-05-02 06:25:00 | AAPL | Stock | 12.61 | 12.61 | 12.5982 | 12.6018 | 35000.0 |
| 2011-05-02 06:30:00 | AAPL | Stock | 12.6018 | 12.6018 | 12.6004 | 12.6018 | 22400.0 |
| 2011-05-02 06:35:00 | AAPL | Stock | 12.6004 | 12.6004 | 12.5961 | 12.5961 | 59360.0 |
| 2011-05-02 07:00:00 | AAPL | Stock | 12.5796 | 12.5796 | 12.5486 | 12.5707 | 129500.0 |
| 2011-05-02 07:05:00 | AAPL | Stock | 12.5704 | 12.5714 | 12.5618 | 12.5625 | 148008.0 |
| 2011-05-02 07:10:00 | AAPL | Stock | 12.5596 | 12.5714 | 12.5368 | 12.57 | 54600.0 |
| 2011-05-02 07:15:00 | AAPL | Stock | 12.5639 | 12.5768 | 12.5639 | 12.5714 | 181020.0 |
| 2011-05-02 07:20:00 | AAPL | Stock | 12.5714 | 12.5757 | 12.5714 | 12.5757 | 193900.0 |
| 2011-05-02 07:25:00 | AAPL | Stock | 12.575 | 12.5857 | 12.575 | 12.5857 | 97216.0 |
| 2011-05-02 07:30:00 | AAPL | Stock | 12.5871 | 12.5929 | 12.5854 | 12.5911 | 361200.0 |
| 2011-05-02 07:35:00 | AAPL | Stock | 12.5911 | 12.5964 | 12.5896 | 12.5896 | 193424.0 |
| 2011-05-02 07:40:00 | AAPL | Stock | 12.5889 | 12.5889 | 12.5714 | 12.5718 | 53200.0 |
| 2011-05-02 07:45:00 | AAPL | Stock | 12.5721 | 12.575 | 12.5721 | 12.575 | 58800.0 |
| 2011-05-02 07:50:00 | AAPL | Stock | 12.575 | 12.5789 | 12.5718 | 12.5718 | 58800.0 |
| 2011-05-02 07:55:00 | AAPL | Stock | 12.5721 | 12.5721 | 12.5539 | 12.5689 | 289296.0 |
| 2011-05-02 08:00:00 | AAPL | Stock | 12.5643 | 12.5732 | 12.5536 | 12.5536 | 558880.0 |
| 2011-05-02 08:05:00 | AAPL | Stock | 12.5546 | 12.5589 | 12.5236 | 12.5268 | 377300.0 |
| 2011-05-02 08:10:00 | AAPL | Stock | 12.5268 | 12.5286 | 12.5143 | 12.5196 | 383516.0 |
| 2011-05-02 08:15:00 | AAPL | Stock | 12.5164 | 12.52 | 12.5071 | 12.5136 | 437276.0 |
| 2011-05-02 08:20:00 | AAPL | Stock | 12.5171 | 12.5179 | 12.4368 | 12.5136 | 331212.0 |
| 2011-05-02 08:25:00 | AAPL | Stock | 12.5143 | 12.5175 | 12.5089 | 12.5129 | 768264.0 |
| 2011-05-02 08:30:00 | AAPL | Stock | 12.5132 | 12.5175 | 12.5121 | 12.5129 | 1004192.0 |
| 2011-05-02 08:35:00 | AAPL | Stock | 12.5129 | 12.5154 | 12.5125 | 12.5132 | 305452.0 |
| 2011-05-02 08:40:00 | AAPL | Stock | 12.5125 | 12.5143 | 12.5071 | 12.5082 | 288456.0 |
| 2011-05-02 08:45:00 | AAPL | Stock | 12.5082 | 12.5121 | 12.4875 | 12.4875 | 1185828.0 |
| 2011-05-02 08:50:00 | AAPL | Stock | 12.4875 | 12.4936 | 12.4507 | 12.4586 | 2254588.0 |
| 2011-05-02 08:55:00 | AAPL | Stock | 12.4586 | 12.4907 | 12.4475 | 12.4671 | 1470532.0 |
| 2011-05-02 09:00:00 | AAPL | Stock | 12.4668 | 12.4721 | 12.4554 | 12.47 | 510720.0 |
| 2011-05-02 09:05:00 | AAPL | Stock | 12.4679 | 12.4768 | 12.4671 | 12.475 | 773444.0 |
| 2011-05-02 09:10:00 | AAPL | Stock | 12.4754 | 12.4925 | 12.4368 | 12.4893 | 667968.0 |
| 2011-05-02 09:15:00 | AAPL | Stock | 12.4879 | 12.5018 | 12.4875 | 12.4911 | 535332.0 |
| 2011-05-02 09:20:00 | AAPL | Stock | 12.4921 | 12.4986 | 12.4857 | 12.49 | 182308.0 |
| 2011-05-02 09:25:00 | AAPL | Stock | 12.4907 | 12.5046 | 12.4857 | 12.4921 | 1727236.0 |
| 2011-05-02 09:30:00 | AAPL | Stock | 12.4904 | 12.5167 | 12.425 | 12.4315 | 26373648.0 |
| 2011-05-02 09:35:00 | AAPL | Stock | 12.4318 | 12.5129 | 12.4311 | 12.4943 | 21326788.0 |
| 2011-05-02 09:40:00 | AAPL | Stock | 12.4916 | 12.4979 | 12.4346 | 12.4368 | 17628520.0 |
| 2011-05-02 09:45:00 | AAPL | Stock | 12.4361 | 12.4696 | 12.4334 | 12.4511 | 10859240.0 |
| 2011-05-02 09:50:00 | AAPL | Stock | 12.4548 | 12.4554 | 12.4325 | 12.4468 | 9261784.0 |
| 2011-05-02 09:55:00 | AAPL | Stock | 12.4493 | 12.4846 | 12.4393 | 12.4714 | 11955776.0 |
| 2011-05-02 10:00:00 | AAPL | Stock | 12.4714 | 12.4829 | 12.4589 | 12.4802 | 7606648.0 |
| 2011-05-02 10:05:00 | AAPL | Stock | 12.481 | 12.4843 | 12.455 | 12.4714 | 6347236.0 |
| 2011-05-02 10:10:00 | AAPL | Stock | 12.4714 | 12.4918 | 12.4677 | 12.4829 | 7793856.0 |
> showing 50 of 331,768 rows — these rows as CSV