PREVIEW / stock_5min / 2014-02-28
file: by_date/stock_5min/2014/2014-02-28.parquet size: 5.7 MB rows: 370,209 symbols: 3,536
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-02-28 06:10:00 | AAPL | Stock | 18.8943 | 18.9 | 18.8929 | 18.8929 | 16212.0 |
| 2014-02-28 07:00:00 | AAPL | Stock | 18.8929 | 18.8929 | 18.8746 | 18.8746 | 11088.0 |
| 2014-02-28 07:05:00 | AAPL | Stock | 18.8657 | 18.8664 | 18.8289 | 18.8321 | 46732.0 |
| 2014-02-28 07:10:00 | AAPL | Stock | 18.8321 | 18.8321 | 18.8296 | 18.8296 | 5600.0 |
| 2014-02-28 07:15:00 | AAPL | Stock | 18.8464 | 18.8464 | 18.8321 | 18.8321 | 39340.0 |
| 2014-02-28 07:20:00 | AAPL | Stock | 18.8304 | 18.8304 | 18.8304 | 18.8304 | 2800.0 |
| 2014-02-28 07:25:00 | AAPL | Stock | 18.8379 | 18.8464 | 18.8339 | 18.8339 | 24080.0 |
| 2014-02-28 07:30:00 | AAPL | Stock | 18.8464 | 18.8464 | 18.8464 | 18.8464 | 14000.0 |
| 2014-02-28 07:40:00 | AAPL | Stock | 18.8464 | 18.8464 | 18.8429 | 18.8429 | 8400.0 |
| 2014-02-28 07:45:00 | AAPL | Stock | 18.8429 | 18.8429 | 18.8393 | 18.8393 | 16800.0 |
| 2014-02-28 07:55:00 | AAPL | Stock | 18.8346 | 18.8346 | 18.8346 | 18.8346 | 2800.0 |
| 2014-02-28 08:00:00 | AAPL | Stock | 18.8489 | 18.8493 | 18.8304 | 18.8461 | 85960.0 |
| 2014-02-28 08:05:00 | AAPL | Stock | 18.8461 | 18.8482 | 18.8446 | 18.8446 | 37268.0 |
| 2014-02-28 08:10:00 | AAPL | Stock | 18.8493 | 18.8493 | 18.8493 | 18.8493 | 2800.0 |
| 2014-02-28 08:15:00 | AAPL | Stock | 18.8421 | 18.8493 | 18.8411 | 18.8493 | 22400.0 |
| 2014-02-28 08:20:00 | AAPL | Stock | 18.8446 | 18.8446 | 18.8446 | 18.8446 | 6328.0 |
| 2014-02-28 08:25:00 | AAPL | Stock | 18.8471 | 18.8493 | 18.8407 | 18.8493 | 17668.0 |
| 2014-02-28 08:30:00 | AAPL | Stock | 18.8493 | 18.8579 | 18.8446 | 18.8579 | 21700.0 |
| 2014-02-28 08:35:00 | AAPL | Stock | 18.8579 | 18.875 | 18.8579 | 18.875 | 94080.0 |
| 2014-02-28 08:40:00 | AAPL | Stock | 18.8736 | 18.8818 | 18.8729 | 18.8793 | 51240.0 |
| 2014-02-28 08:45:00 | AAPL | Stock | 18.8771 | 18.8932 | 18.8754 | 18.8754 | 76804.0 |
| 2014-02-28 08:50:00 | AAPL | Stock | 18.8771 | 18.8886 | 18.8764 | 18.8843 | 94640.0 |
| 2014-02-28 08:55:00 | AAPL | Stock | 18.8843 | 18.8843 | 18.8829 | 18.8829 | 11900.0 |
| 2014-02-28 09:00:00 | AAPL | Stock | 18.8846 | 18.8911 | 18.8796 | 18.8857 | 121772.0 |
| 2014-02-28 09:05:00 | AAPL | Stock | 18.8861 | 18.8861 | 18.875 | 18.8775 | 212072.0 |
| 2014-02-28 09:10:00 | AAPL | Stock | 18.8786 | 18.8886 | 18.8671 | 18.8857 | 204568.0 |
| 2014-02-28 09:15:00 | AAPL | Stock | 18.8857 | 18.8893 | 18.8804 | 18.8893 | 156212.0 |
| 2014-02-28 09:20:00 | AAPL | Stock | 18.8896 | 18.9 | 18.8879 | 18.8986 | 233296.0 |
| 2014-02-28 09:25:00 | AAPL | Stock | 18.895 | 18.9036 | 18.8825 | 18.8975 | 385392.0 |
| 2014-02-28 09:30:00 | AAPL | Stock | 18.8957 | 18.9375 | 18.8486 | 18.9075 | 15891120.0 |
| 2014-02-28 09:35:00 | AAPL | Stock | 18.9071 | 18.9821 | 18.9071 | 18.9821 | 10525872.0 |
| 2014-02-28 09:40:00 | AAPL | Stock | 18.9821 | 18.9942 | 18.9389 | 18.9918 | 7850584.0 |
| 2014-02-28 09:45:00 | AAPL | Stock | 18.9924 | 18.9954 | 18.9579 | 18.9582 | 4152596.0 |
| 2014-02-28 09:50:00 | AAPL | Stock | 18.9596 | 18.9843 | 18.9468 | 18.96 | 3900596.0 |
| 2014-02-28 09:55:00 | AAPL | Stock | 18.9614 | 18.9896 | 18.9564 | 18.9718 | 3246068.0 |
| 2014-02-28 10:00:00 | AAPL | Stock | 18.9721 | 19.0125 | 18.9686 | 19.0125 | 5966044.0 |
| 2014-02-28 10:05:00 | AAPL | Stock | 19.0111 | 19.0254 | 18.9921 | 19.0016 | 4568144.0 |
| 2014-02-28 10:10:00 | AAPL | Stock | 19.0007 | 19.0268 | 18.9975 | 19.025 | 3967572.0 |
| 2014-02-28 10:15:00 | AAPL | Stock | 19.0207 | 19.025 | 18.9929 | 19.0 | 2898532.0 |
| 2014-02-28 10:20:00 | AAPL | Stock | 19.0012 | 19.0029 | 18.9364 | 18.9379 | 4613196.0 |
| 2014-02-28 10:25:00 | AAPL | Stock | 18.9446 | 18.9516 | 18.9061 | 18.9234 | 5291496.0 |
| 2014-02-28 10:30:00 | AAPL | Stock | 18.925 | 18.9754 | 18.9154 | 18.9507 | 4877796.0 |
| 2014-02-28 10:35:00 | AAPL | Stock | 18.9496 | 18.9636 | 18.9318 | 18.9363 | 3162012.0 |
| 2014-02-28 10:40:00 | AAPL | Stock | 18.9368 | 18.9457 | 18.9157 | 18.9179 | 3101952.0 |
| 2014-02-28 10:45:00 | AAPL | Stock | 18.9179 | 18.9207 | 18.8764 | 18.8933 | 4389252.0 |
| 2014-02-28 10:50:00 | AAPL | Stock | 18.8914 | 18.9111 | 18.8696 | 18.8711 | 2983792.0 |
| 2014-02-28 10:55:00 | AAPL | Stock | 18.8732 | 18.8821 | 18.8571 | 18.8639 | 2988356.0 |
| 2014-02-28 11:00:00 | AAPL | Stock | 18.8643 | 18.8696 | 18.8196 | 18.8325 | 4636016.0 |
| 2014-02-28 11:05:00 | AAPL | Stock | 18.8371 | 18.8425 | 18.8143 | 18.8154 | 3224676.0 |
| 2014-02-28 11:10:00 | AAPL | Stock | 18.8164 | 18.8439 | 18.8157 | 18.8393 | 2788744.0 |
> showing 50 of 370,209 rows — these rows as CSV