PREVIEW / stock_5min / 2013-08-23
file: by_date/stock_5min/2013/2013-08-23.parquet size: 5.0 MB rows: 334,553 symbols: 3,519
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-08-23 04:00:00 | AAPL | Stock | 18.0 | 18.0332 | 18.0 | 18.0332 | 19600.0 |
| 2013-08-23 04:25:00 | AAPL | Stock | 18.0521 | 18.0521 | 18.0521 | 18.0521 | 2800.0 |
| 2013-08-23 04:30:00 | AAPL | Stock | 18.0529 | 18.0607 | 18.05 | 18.0607 | 11200.0 |
| 2013-08-23 04:55:00 | AAPL | Stock | 18.0539 | 18.0539 | 18.0539 | 18.0539 | 2800.0 |
| 2013-08-23 05:15:00 | AAPL | Stock | 18.0586 | 18.0586 | 18.0586 | 18.0586 | 2800.0 |
| 2013-08-23 05:25:00 | AAPL | Stock | 18.0454 | 18.0454 | 18.0357 | 18.0357 | 5600.0 |
| 2013-08-23 05:30:00 | AAPL | Stock | 18.0357 | 18.0357 | 18.0357 | 18.0357 | 8400.0 |
| 2013-08-23 05:35:00 | AAPL | Stock | 18.0357 | 18.0357 | 18.0357 | 18.0357 | 2800.0 |
| 2013-08-23 05:40:00 | AAPL | Stock | 18.0357 | 18.0357 | 18.0357 | 18.0357 | 2800.0 |
| 2013-08-23 06:00:00 | AAPL | Stock | 18.0357 | 18.0357 | 18.0357 | 18.0357 | 5600.0 |
| 2013-08-23 06:45:00 | AAPL | Stock | 18.0064 | 18.0064 | 18.0064 | 18.0064 | 5600.0 |
| 2013-08-23 06:50:00 | AAPL | Stock | 18.0089 | 18.0089 | 18.0089 | 18.0089 | 2800.0 |
| 2013-08-23 07:00:00 | AAPL | Stock | 18.0007 | 18.0264 | 17.9975 | 18.0089 | 99540.0 |
| 2013-08-23 07:05:00 | AAPL | Stock | 18.0071 | 18.0071 | 18.0071 | 18.0071 | 29120.0 |
| 2013-08-23 07:10:00 | AAPL | Stock | 18.0071 | 18.0071 | 18.0071 | 18.0071 | 5600.0 |
| 2013-08-23 07:15:00 | AAPL | Stock | 18.0071 | 18.0071 | 18.0071 | 18.0071 | 2800.0 |
| 2013-08-23 07:20:00 | AAPL | Stock | 18.0071 | 18.0071 | 18.0071 | 18.0071 | 3500.0 |
| 2013-08-23 07:30:00 | AAPL | Stock | 18.0168 | 18.0168 | 18.0007 | 18.0007 | 5600.0 |
| 2013-08-23 07:35:00 | AAPL | Stock | 18.0007 | 18.0007 | 18.0 | 18.0 | 5600.0 |
| 2013-08-23 07:40:00 | AAPL | Stock | 17.9946 | 18.0 | 17.9946 | 18.0 | 39592.0 |
| 2013-08-23 07:45:00 | AAPL | Stock | 17.9946 | 17.9957 | 17.9936 | 17.9957 | 36400.0 |
| 2013-08-23 07:50:00 | AAPL | Stock | 17.9957 | 17.9957 | 17.9804 | 17.9929 | 70980.0 |
| 2013-08-23 07:55:00 | AAPL | Stock | 17.9786 | 17.9829 | 17.9779 | 17.9779 | 46200.0 |
| 2013-08-23 08:00:00 | AAPL | Stock | 17.9857 | 18.0171 | 17.9786 | 17.9932 | 195300.0 |
| 2013-08-23 08:05:00 | AAPL | Stock | 17.99 | 17.9907 | 17.9464 | 17.9571 | 346892.0 |
| 2013-08-23 08:10:00 | AAPL | Stock | 17.9639 | 17.9639 | 17.9339 | 17.9539 | 213248.0 |
| 2013-08-23 08:15:00 | AAPL | Stock | 17.9518 | 17.9721 | 17.9518 | 17.9721 | 57960.0 |
| 2013-08-23 08:20:00 | AAPL | Stock | 17.9618 | 17.9768 | 17.9593 | 17.9643 | 153020.0 |
| 2013-08-23 08:25:00 | AAPL | Stock | 17.9643 | 17.9714 | 17.9636 | 17.9646 | 42252.0 |
| 2013-08-23 08:30:00 | AAPL | Stock | 17.9714 | 17.9714 | 17.9679 | 17.9696 | 20972.0 |
| 2013-08-23 08:35:00 | AAPL | Stock | 17.9714 | 17.9714 | 17.9675 | 17.9675 | 30940.0 |
| 2013-08-23 08:40:00 | AAPL | Stock | 17.965 | 17.9693 | 17.9536 | 17.9643 | 115248.0 |
| 2013-08-23 08:45:00 | AAPL | Stock | 17.9629 | 17.9711 | 17.9468 | 17.9661 | 119840.0 |
| 2013-08-23 08:50:00 | AAPL | Stock | 17.9646 | 17.9732 | 17.9611 | 17.9693 | 42000.0 |
| 2013-08-23 08:55:00 | AAPL | Stock | 17.9679 | 17.9714 | 17.9582 | 17.9582 | 180376.0 |
| 2013-08-23 09:00:00 | AAPL | Stock | 17.9554 | 17.9714 | 17.9539 | 17.9636 | 78680.0 |
| 2013-08-23 09:05:00 | AAPL | Stock | 17.9643 | 17.9693 | 17.9643 | 17.9657 | 23884.0 |
| 2013-08-23 09:10:00 | AAPL | Stock | 17.9664 | 17.9664 | 17.945 | 17.9496 | 108920.0 |
| 2013-08-23 09:15:00 | AAPL | Stock | 17.9496 | 17.9529 | 17.9396 | 17.9468 | 123676.0 |
| 2013-08-23 09:20:00 | AAPL | Stock | 17.9482 | 17.9643 | 17.9482 | 17.9571 | 129920.0 |
| 2013-08-23 09:25:00 | AAPL | Stock | 17.9611 | 17.975 | 17.9482 | 17.9607 | 234920.0 |
| 2013-08-23 09:30:00 | AAPL | Stock | 17.9568 | 17.9768 | 17.8964 | 17.9116 | 12764192.0 |
| 2013-08-23 09:35:00 | AAPL | Stock | 17.9114 | 17.915 | 17.8714 | 17.913 | 8723540.0 |
| 2013-08-23 09:40:00 | AAPL | Stock | 17.9118 | 17.9175 | 17.835 | 17.8357 | 8168972.0 |
| 2013-08-23 09:45:00 | AAPL | Stock | 17.8339 | 17.8725 | 17.8339 | 17.8604 | 7679784.0 |
| 2013-08-23 09:50:00 | AAPL | Stock | 17.8604 | 17.9046 | 17.8443 | 17.8921 | 9554412.0 |
| 2013-08-23 09:55:00 | AAPL | Stock | 17.8907 | 17.8936 | 17.8596 | 17.8921 | 6210624.0 |
| 2013-08-23 10:00:00 | AAPL | Stock | 17.8896 | 17.8943 | 17.8361 | 17.8693 | 6947220.0 |
| 2013-08-23 10:05:00 | AAPL | Stock | 17.8711 | 17.89 | 17.8604 | 17.89 | 3582096.0 |
| 2013-08-23 10:10:00 | AAPL | Stock | 17.887 | 17.91 | 17.8768 | 17.9017 | 4091920.0 |
> showing 50 of 334,553 rows — these rows as CSV