PREVIEW / stock_5min / 2014-04-10
file: by_date/stock_5min/2014/2014-04-10.parquet size: 5.6 MB rows: 370,590 symbols: 3,553
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 |
|---|---|---|---|---|---|---|---|
| 2014-04-10 04:05:00 | AAPL | Stock | 19.0368 | 19.0368 | 19.0357 | 19.0357 | 26600.0 |
| 2014-04-10 04:15:00 | AAPL | Stock | 19.05 | 19.05 | 19.05 | 19.05 | 5600.0 |
| 2014-04-10 04:50:00 | AAPL | Stock | 19.0357 | 19.0357 | 19.0254 | 19.0254 | 11200.0 |
| 2014-04-10 05:00:00 | AAPL | Stock | 19.0357 | 19.0357 | 19.0357 | 19.0357 | 2800.0 |
| 2014-04-10 05:20:00 | AAPL | Stock | 18.9482 | 18.9846 | 18.9482 | 18.9846 | 28000.0 |
| 2014-04-10 05:50:00 | AAPL | Stock | 18.9554 | 18.9554 | 18.9554 | 18.9554 | 2800.0 |
| 2014-04-10 05:55:00 | AAPL | Stock | 18.9554 | 18.9554 | 18.9464 | 18.9464 | 5600.0 |
| 2014-04-10 06:30:00 | AAPL | Stock | 18.9446 | 18.9446 | 18.9446 | 18.9446 | 11480.0 |
| 2014-04-10 06:35:00 | AAPL | Stock | 18.9446 | 18.9446 | 18.9446 | 18.9446 | 14000.0 |
| 2014-04-10 06:45:00 | AAPL | Stock | 18.9293 | 18.9643 | 18.9293 | 18.9621 | 16240.0 |
| 2014-04-10 06:55:00 | AAPL | Stock | 18.9643 | 18.975 | 18.9643 | 18.975 | 23464.0 |
| 2014-04-10 07:05:00 | AAPL | Stock | 18.975 | 18.975 | 18.9643 | 18.975 | 30800.0 |
| 2014-04-10 07:10:00 | AAPL | Stock | 18.9843 | 18.9843 | 18.9843 | 18.9843 | 2800.0 |
| 2014-04-10 07:15:00 | AAPL | Stock | 18.9929 | 19.0 | 18.9929 | 18.9996 | 157080.0 |
| 2014-04-10 07:20:00 | AAPL | Stock | 18.9964 | 18.9964 | 18.9964 | 18.9964 | 2800.0 |
| 2014-04-10 07:30:00 | AAPL | Stock | 19.0107 | 19.0357 | 19.0107 | 19.0357 | 53760.0 |
| 2014-04-10 07:35:00 | AAPL | Stock | 19.0364 | 19.0364 | 19.0246 | 19.0268 | 68320.0 |
| 2014-04-10 07:40:00 | AAPL | Stock | 19.0125 | 19.0357 | 19.0121 | 19.0357 | 124180.0 |
| 2014-04-10 07:45:00 | AAPL | Stock | 19.0357 | 19.0464 | 19.0357 | 19.0357 | 31892.0 |
| 2014-04-10 07:50:00 | AAPL | Stock | 19.0268 | 19.0268 | 19.0043 | 19.0179 | 66976.0 |
| 2014-04-10 07:55:00 | AAPL | Stock | 19.0193 | 19.0193 | 19.0071 | 19.0179 | 51576.0 |
| 2014-04-10 08:00:00 | AAPL | Stock | 19.0036 | 19.0357 | 18.975 | 18.9893 | 102004.0 |
| 2014-04-10 08:05:00 | AAPL | Stock | 19.0004 | 19.0068 | 18.9968 | 18.9996 | 63280.0 |
| 2014-04-10 08:10:00 | AAPL | Stock | 19.0 | 19.0114 | 19.0 | 19.005 | 75488.0 |
| 2014-04-10 08:15:00 | AAPL | Stock | 18.9907 | 18.9907 | 18.9646 | 18.9764 | 103964.0 |
| 2014-04-10 08:20:00 | AAPL | Stock | 18.98 | 18.9875 | 18.9779 | 18.9779 | 71400.0 |
| 2014-04-10 08:25:00 | AAPL | Stock | 18.975 | 18.9907 | 18.975 | 18.9907 | 33404.0 |
| 2014-04-10 08:30:00 | AAPL | Stock | 18.9793 | 18.9929 | 18.9793 | 18.9864 | 76776.0 |
| 2014-04-10 08:35:00 | AAPL | Stock | 18.9757 | 18.9768 | 18.975 | 18.975 | 120092.0 |
| 2014-04-10 08:40:00 | AAPL | Stock | 18.9754 | 18.9843 | 18.975 | 18.9818 | 56364.0 |
| 2014-04-10 08:50:00 | AAPL | Stock | 18.975 | 18.9814 | 18.9579 | 18.9579 | 78400.0 |
| 2014-04-10 08:55:00 | AAPL | Stock | 18.9525 | 18.9598 | 18.9525 | 18.9554 | 70056.0 |
| 2014-04-10 09:00:00 | AAPL | Stock | 18.9618 | 18.9639 | 18.9564 | 18.9564 | 19600.0 |
| 2014-04-10 09:05:00 | AAPL | Stock | 18.9564 | 18.9618 | 18.9482 | 18.9564 | 66024.0 |
| 2014-04-10 09:10:00 | AAPL | Stock | 18.9593 | 18.9593 | 18.9468 | 18.9589 | 21784.0 |
| 2014-04-10 09:15:00 | AAPL | Stock | 18.9571 | 18.9632 | 18.9482 | 18.9632 | 66584.0 |
| 2014-04-10 09:20:00 | AAPL | Stock | 18.9543 | 18.9607 | 18.9475 | 18.9607 | 48776.0 |
| 2014-04-10 09:25:00 | AAPL | Stock | 18.9625 | 18.9636 | 18.9536 | 18.9607 | 98840.0 |
| 2014-04-10 09:30:00 | AAPL | Stock | 18.9529 | 18.9636 | 18.8839 | 18.89 | 7671524.0 |
| 2014-04-10 09:35:00 | AAPL | Stock | 18.8875 | 18.9268 | 18.8804 | 18.9046 | 4198656.0 |
| 2014-04-10 09:40:00 | AAPL | Stock | 18.9071 | 18.9607 | 18.9029 | 18.9029 | 4302592.0 |
| 2014-04-10 09:45:00 | AAPL | Stock | 18.9032 | 18.9175 | 18.8682 | 18.8746 | 3215296.0 |
| 2014-04-10 09:50:00 | AAPL | Stock | 18.8758 | 18.8771 | 18.8354 | 18.8677 | 3840564.0 |
| 2014-04-10 09:55:00 | AAPL | Stock | 18.8643 | 18.8782 | 18.855 | 18.8746 | 1951880.0 |
| 2014-04-10 10:00:00 | AAPL | Stock | 18.8746 | 18.8761 | 18.8536 | 18.8661 | 1526392.0 |
| 2014-04-10 10:05:00 | AAPL | Stock | 18.8614 | 18.8946 | 18.8571 | 18.8927 | 2125088.0 |
| 2014-04-10 10:10:00 | AAPL | Stock | 18.8925 | 18.9239 | 18.8879 | 18.9093 | 3050908.0 |
| 2014-04-10 10:15:00 | AAPL | Stock | 18.9093 | 18.9221 | 18.8925 | 18.8954 | 2080876.0 |
| 2014-04-10 10:20:00 | AAPL | Stock | 18.9025 | 18.9818 | 18.9025 | 18.9685 | 4733120.0 |
| 2014-04-10 10:25:00 | AAPL | Stock | 18.9718 | 19.0075 | 18.9575 | 18.9952 | 6044556.0 |
> showing 50 of 370,590 rows — these rows as CSV