PREVIEW / stock_5min / 2012-02-21
file: by_date/stock_5min/2012/2012-02-21.parquet size: 5.0 MB rows: 332,634 symbols: 3,558
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 |
|---|---|---|---|---|---|---|---|
| 2012-02-21 04:00:00 | AAPL | Stock | 18.1068 | 18.1089 | 18.1068 | 18.1071 | 12600.0 |
| 2012-02-21 04:05:00 | AAPL | Stock | 18.0786 | 18.0882 | 18.0786 | 18.0882 | 44800.0 |
| 2012-02-21 04:10:00 | AAPL | Stock | 18.0821 | 18.0821 | 18.0771 | 18.0771 | 25200.0 |
| 2012-02-21 04:15:00 | AAPL | Stock | 18.075 | 18.075 | 18.075 | 18.075 | 2800.0 |
| 2012-02-21 04:20:00 | AAPL | Stock | 18.0736 | 18.0736 | 18.0714 | 18.0714 | 16800.0 |
| 2012-02-21 04:25:00 | AAPL | Stock | 18.0696 | 18.0696 | 18.0696 | 18.0696 | 2800.0 |
| 2012-02-21 04:30:00 | AAPL | Stock | 18.0629 | 18.0629 | 18.0629 | 18.0629 | 5600.0 |
| 2012-02-21 04:45:00 | AAPL | Stock | 18.0589 | 18.0589 | 18.0589 | 18.0589 | 5600.0 |
| 2012-02-21 05:00:00 | AAPL | Stock | 18.0543 | 18.0543 | 18.0543 | 18.0543 | 5600.0 |
| 2012-02-21 05:05:00 | AAPL | Stock | 18.04 | 18.04 | 18.0007 | 18.0007 | 30800.0 |
| 2012-02-21 05:10:00 | AAPL | Stock | 18.0 | 18.0 | 18.0 | 18.0 | 5600.0 |
| 2012-02-21 05:15:00 | AAPL | Stock | 17.9979 | 17.9979 | 17.9961 | 17.9961 | 28000.0 |
| 2012-02-21 05:20:00 | AAPL | Stock | 17.9714 | 17.9714 | 17.9714 | 17.9714 | 5600.0 |
| 2012-02-21 05:35:00 | AAPL | Stock | 17.9993 | 17.9993 | 17.9993 | 17.9993 | 2800.0 |
| 2012-02-21 05:45:00 | AAPL | Stock | 18.0 | 18.0 | 18.0 | 18.0 | 2800.0 |
| 2012-02-21 05:55:00 | AAPL | Stock | 17.9821 | 17.9821 | 17.9704 | 17.9704 | 67256.0 |
| 2012-02-21 06:25:00 | AAPL | Stock | 17.9857 | 18.0268 | 17.9857 | 17.9857 | 107548.0 |
| 2012-02-21 06:50:00 | AAPL | Stock | 17.9679 | 17.9679 | 17.9643 | 17.9643 | 28084.0 |
| 2012-02-21 07:00:00 | AAPL | Stock | 17.985 | 18.0175 | 17.9786 | 17.99 | 73640.0 |
| 2012-02-21 07:05:00 | AAPL | Stock | 17.9946 | 18.0129 | 17.9907 | 17.9907 | 30800.0 |
| 2012-02-21 07:10:00 | AAPL | Stock | 17.9954 | 17.9961 | 17.9821 | 17.9821 | 19656.0 |
| 2012-02-21 07:15:00 | AAPL | Stock | 17.9829 | 17.9964 | 17.9518 | 17.9518 | 215348.0 |
| 2012-02-21 07:20:00 | AAPL | Stock | 17.9643 | 17.9929 | 17.9643 | 17.9675 | 304080.0 |
| 2012-02-21 07:25:00 | AAPL | Stock | 17.9625 | 17.9679 | 17.945 | 17.9554 | 231504.0 |
| 2012-02-21 07:30:00 | AAPL | Stock | 17.9575 | 17.9821 | 17.9575 | 17.9743 | 125384.0 |
| 2012-02-21 07:35:00 | AAPL | Stock | 17.9807 | 17.9821 | 17.9807 | 17.9821 | 25872.0 |
| 2012-02-21 07:40:00 | AAPL | Stock | 17.9843 | 17.9929 | 17.9821 | 17.9929 | 55300.0 |
| 2012-02-21 07:45:00 | AAPL | Stock | 17.9929 | 17.9929 | 17.9846 | 17.9846 | 47600.0 |
| 2012-02-21 07:50:00 | AAPL | Stock | 17.9921 | 18.0007 | 17.9921 | 17.9993 | 64008.0 |
| 2012-02-21 07:55:00 | AAPL | Stock | 17.9936 | 17.9936 | 17.9821 | 17.9893 | 14560.0 |
| 2012-02-21 08:00:00 | AAPL | Stock | 17.9982 | 18.0157 | 17.9821 | 17.9821 | 488236.0 |
| 2012-02-21 08:05:00 | AAPL | Stock | 17.9754 | 17.995 | 17.9689 | 17.9929 | 219184.0 |
| 2012-02-21 08:10:00 | AAPL | Stock | 17.9929 | 18.0086 | 17.9843 | 18.0086 | 251300.0 |
| 2012-02-21 08:15:00 | AAPL | Stock | 18.0107 | 18.0496 | 18.0107 | 18.0446 | 657496.0 |
| 2012-02-21 08:20:00 | AAPL | Stock | 18.0482 | 18.0714 | 18.0446 | 18.0654 | 506772.0 |
| 2012-02-21 08:25:00 | AAPL | Stock | 18.0668 | 18.0861 | 18.0646 | 18.0861 | 582484.0 |
| 2012-02-21 08:30:00 | AAPL | Stock | 18.0871 | 18.125 | 18.0646 | 18.0714 | 636384.0 |
| 2012-02-21 08:35:00 | AAPL | Stock | 18.0761 | 18.0846 | 18.0689 | 18.0832 | 597408.0 |
| 2012-02-21 08:40:00 | AAPL | Stock | 18.0757 | 18.0793 | 18.0625 | 18.0707 | 135016.0 |
| 2012-02-21 08:45:00 | AAPL | Stock | 18.0711 | 18.0804 | 18.0675 | 18.0743 | 204792.0 |
| 2012-02-21 08:50:00 | AAPL | Stock | 18.0811 | 18.0968 | 18.0811 | 18.0832 | 258888.0 |
| 2012-02-21 08:55:00 | AAPL | Stock | 18.0921 | 18.0946 | 18.0818 | 18.0829 | 213108.0 |
| 2012-02-21 09:00:00 | AAPL | Stock | 18.0829 | 18.0921 | 18.0821 | 18.0889 | 185640.0 |
| 2012-02-21 09:05:00 | AAPL | Stock | 18.0889 | 18.0975 | 18.0832 | 18.0975 | 300216.0 |
| 2012-02-21 09:10:00 | AAPL | Stock | 18.0971 | 18.0971 | 18.0821 | 18.0875 | 167972.0 |
| 2012-02-21 09:15:00 | AAPL | Stock | 18.0857 | 18.1114 | 18.085 | 18.1071 | 593852.0 |
| 2012-02-21 09:20:00 | AAPL | Stock | 18.1071 | 18.1071 | 18.0911 | 18.0911 | 211456.0 |
| 2012-02-21 09:25:00 | AAPL | Stock | 18.0929 | 18.1179 | 18.0871 | 18.1089 | 622384.0 |
| 2012-02-21 09:30:00 | AAPL | Stock | 18.1029 | 18.1154 | 18.0464 | 18.1009 | 19960892.0 |
| 2012-02-21 09:35:00 | AAPL | Stock | 18.095 | 18.1246 | 18.0651 | 18.0982 | 14786604.0 |
> showing 50 of 332,634 rows — these rows as CSV