PREVIEW / stock_5min / 2014-05-27
file: by_date/stock_5min/2014/2014-05-27.parquet size: 5.4 MB rows: 362,378 symbols: 3,574
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-05-27 04:00:00 | AAPL | Stock | 21.9614 | 22.0714 | 21.9614 | 22.0714 | 8400.0 |
| 2014-05-27 04:05:00 | AAPL | Stock | 22.0714 | 22.0714 | 22.0714 | 22.0714 | 11200.0 |
| 2014-05-27 04:30:00 | AAPL | Stock | 22.0732 | 22.0732 | 22.0679 | 22.0679 | 30800.0 |
| 2014-05-27 04:35:00 | AAPL | Stock | 22.0668 | 22.0668 | 22.0668 | 22.0668 | 2800.0 |
| 2014-05-27 04:55:00 | AAPL | Stock | 22.0714 | 22.0714 | 22.0714 | 22.0714 | 26040.0 |
| 2014-05-27 05:10:00 | AAPL | Stock | 22.0993 | 22.0993 | 22.0982 | 22.0982 | 5600.0 |
| 2014-05-27 05:15:00 | AAPL | Stock | 22.0982 | 22.0982 | 22.0982 | 22.0982 | 2800.0 |
| 2014-05-27 05:20:00 | AAPL | Stock | 22.0789 | 22.0789 | 22.0714 | 22.0714 | 14812.0 |
| 2014-05-27 05:25:00 | AAPL | Stock | 22.0714 | 22.0714 | 22.0632 | 22.0632 | 36400.0 |
| 2014-05-27 05:30:00 | AAPL | Stock | 22.0679 | 22.0679 | 22.0675 | 22.0675 | 38472.0 |
| 2014-05-27 05:35:00 | AAPL | Stock | 22.0675 | 22.0675 | 22.0675 | 22.0675 | 5600.0 |
| 2014-05-27 05:40:00 | AAPL | Stock | 22.0611 | 22.0611 | 22.0575 | 22.0575 | 5600.0 |
| 2014-05-27 05:55:00 | AAPL | Stock | 22.0679 | 22.0679 | 22.0679 | 22.0679 | 5600.0 |
| 2014-05-27 06:00:00 | AAPL | Stock | 22.0679 | 22.0679 | 22.0679 | 22.0679 | 2800.0 |
| 2014-05-27 06:05:00 | AAPL | Stock | 22.0786 | 22.0786 | 22.0679 | 22.0679 | 8960.0 |
| 2014-05-27 06:10:00 | AAPL | Stock | 22.0696 | 22.0871 | 22.0696 | 22.0871 | 5600.0 |
| 2014-05-27 06:15:00 | AAPL | Stock | 22.0786 | 22.0836 | 22.0786 | 22.0836 | 5600.0 |
| 2014-05-27 06:20:00 | AAPL | Stock | 22.0729 | 22.0729 | 22.0714 | 22.0714 | 11200.0 |
| 2014-05-27 06:25:00 | AAPL | Stock | 22.0736 | 22.0736 | 22.0714 | 22.0714 | 11200.0 |
| 2014-05-27 06:30:00 | AAPL | Stock | 22.0625 | 22.0625 | 22.0396 | 22.0396 | 22400.0 |
| 2014-05-27 06:35:00 | AAPL | Stock | 22.0396 | 22.0546 | 22.0375 | 22.0546 | 19572.0 |
| 2014-05-27 06:40:00 | AAPL | Stock | 22.0711 | 22.0711 | 22.0711 | 22.0711 | 3360.0 |
| 2014-05-27 06:45:00 | AAPL | Stock | 22.0714 | 22.0714 | 22.0711 | 22.0714 | 44492.0 |
| 2014-05-27 06:50:00 | AAPL | Stock | 22.0714 | 22.0714 | 22.0714 | 22.0714 | 16660.0 |
| 2014-05-27 06:55:00 | AAPL | Stock | 22.0714 | 22.0714 | 22.0714 | 22.0714 | 26852.0 |
| 2014-05-27 07:00:00 | AAPL | Stock | 22.0779 | 22.0786 | 22.0625 | 22.0629 | 27160.0 |
| 2014-05-27 07:05:00 | AAPL | Stock | 22.0714 | 22.0804 | 22.0714 | 22.0804 | 53088.0 |
| 2014-05-27 07:10:00 | AAPL | Stock | 22.0804 | 22.0821 | 22.0804 | 22.0821 | 17500.0 |
| 2014-05-27 07:15:00 | AAPL | Stock | 22.0714 | 22.0714 | 22.0679 | 22.0686 | 51044.0 |
| 2014-05-27 07:20:00 | AAPL | Stock | 22.0711 | 22.0714 | 22.0643 | 22.0714 | 70728.0 |
| 2014-05-27 07:25:00 | AAPL | Stock | 22.0714 | 22.075 | 22.0714 | 22.0714 | 52192.0 |
| 2014-05-27 07:30:00 | AAPL | Stock | 22.0714 | 22.0836 | 22.0714 | 22.0786 | 48048.0 |
| 2014-05-27 07:35:00 | AAPL | Stock | 22.0786 | 22.0786 | 22.0782 | 22.0786 | 11704.0 |
| 2014-05-27 07:40:00 | AAPL | Stock | 22.0804 | 22.0836 | 22.0804 | 22.0804 | 22400.0 |
| 2014-05-27 07:45:00 | AAPL | Stock | 22.075 | 22.0775 | 22.0714 | 22.0714 | 69916.0 |
| 2014-05-27 07:50:00 | AAPL | Stock | 22.07 | 22.07 | 22.07 | 22.07 | 8400.0 |
| 2014-05-27 07:55:00 | AAPL | Stock | 22.0629 | 22.0629 | 22.0625 | 22.0625 | 5600.0 |
| 2014-05-27 08:00:00 | AAPL | Stock | 22.0625 | 22.0836 | 22.0364 | 22.0836 | 381108.0 |
| 2014-05-27 08:05:00 | AAPL | Stock | 22.0836 | 22.1018 | 22.0829 | 22.1014 | 121800.0 |
| 2014-05-27 08:10:00 | AAPL | Stock | 22.1014 | 22.1061 | 22.0911 | 22.0954 | 173600.0 |
| 2014-05-27 08:15:00 | AAPL | Stock | 22.095 | 22.0993 | 22.09 | 22.0904 | 79716.0 |
| 2014-05-27 08:20:00 | AAPL | Stock | 22.0929 | 22.0964 | 22.075 | 22.075 | 377160.0 |
| 2014-05-27 08:25:00 | AAPL | Stock | 22.0786 | 22.0786 | 22.0668 | 22.0714 | 91560.0 |
| 2014-05-27 08:30:00 | AAPL | Stock | 22.0743 | 22.0839 | 22.0643 | 22.0839 | 142548.0 |
| 2014-05-27 08:35:00 | AAPL | Stock | 22.0804 | 22.0975 | 22.0804 | 22.0896 | 70588.0 |
| 2014-05-27 08:40:00 | AAPL | Stock | 22.0954 | 22.0961 | 22.0821 | 22.0821 | 108220.0 |
| 2014-05-27 08:45:00 | AAPL | Stock | 22.0857 | 22.0929 | 22.0821 | 22.0875 | 91448.0 |
| 2014-05-27 08:50:00 | AAPL | Stock | 22.0875 | 22.0875 | 22.0821 | 22.0821 | 21700.0 |
| 2014-05-27 08:55:00 | AAPL | Stock | 22.0839 | 22.0882 | 22.0786 | 22.0879 | 57568.0 |
| 2014-05-27 09:00:00 | AAPL | Stock | 22.0886 | 22.0961 | 22.0875 | 22.0893 | 156212.0 |
> showing 50 of 362,378 rows — these rows as CSV