PREVIEW / stock_5min / 2016-11-02
file: by_date/stock_5min/2016/2016-11-02.parquet size: 5.3 MB rows: 350,919 symbols: 3,183
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 |
|---|---|---|---|---|---|---|---|
| 2016-11-02 04:00:00 | AAPL | Stock | 27.8 | 27.8 | 27.8 | 27.8 | 4000.0 |
| 2016-11-02 04:05:00 | AAPL | Stock | 27.75 | 27.75 | 27.75 | 27.75 | 1400.0 |
| 2016-11-02 04:15:00 | AAPL | Stock | 27.715 | 27.715 | 27.715 | 27.715 | 1196.0 |
| 2016-11-02 04:20:00 | AAPL | Stock | 27.7125 | 27.7125 | 27.7125 | 27.7125 | 400.0 |
| 2016-11-02 04:25:00 | AAPL | Stock | 27.7125 | 27.7125 | 27.675 | 27.675 | 1280.0 |
| 2016-11-02 04:35:00 | AAPL | Stock | 27.6875 | 27.6875 | 27.6875 | 27.6875 | 2000.0 |
| 2016-11-02 04:40:00 | AAPL | Stock | 27.7125 | 27.7225 | 27.71 | 27.71 | 3948.0 |
| 2016-11-02 05:00:00 | AAPL | Stock | 27.7125 | 27.7125 | 27.7 | 27.7 | 3580.0 |
| 2016-11-02 05:10:00 | AAPL | Stock | 27.7175 | 27.7175 | 27.7075 | 27.7075 | 1600.0 |
| 2016-11-02 05:45:00 | AAPL | Stock | 27.7275 | 27.7275 | 27.725 | 27.725 | 1600.0 |
| 2016-11-02 05:55:00 | AAPL | Stock | 27.7475 | 27.7475 | 27.7475 | 27.7475 | 1604.0 |
| 2016-11-02 06:15:00 | AAPL | Stock | 27.7275 | 27.7275 | 27.7275 | 27.7275 | 400.0 |
| 2016-11-02 06:25:00 | AAPL | Stock | 27.7675 | 27.7675 | 27.7675 | 27.7675 | 680.0 |
| 2016-11-02 06:35:00 | AAPL | Stock | 27.775 | 27.775 | 27.775 | 27.775 | 400.0 |
| 2016-11-02 06:45:00 | AAPL | Stock | 27.75 | 27.75 | 27.75 | 27.75 | 400.0 |
| 2016-11-02 07:00:00 | AAPL | Stock | 27.7525 | 27.7525 | 27.75 | 27.75 | 3344.0 |
| 2016-11-02 07:05:00 | AAPL | Stock | 27.7875 | 27.8225 | 27.7875 | 27.8225 | 8960.0 |
| 2016-11-02 07:10:00 | AAPL | Stock | 27.8225 | 27.8425 | 27.8225 | 27.8375 | 4052.0 |
| 2016-11-02 07:15:00 | AAPL | Stock | 27.8375 | 27.8375 | 27.8375 | 27.8375 | 400.0 |
| 2016-11-02 07:20:00 | AAPL | Stock | 27.8325 | 27.8325 | 27.82 | 27.82 | 3864.0 |
| 2016-11-02 07:25:00 | AAPL | Stock | 27.82 | 27.82 | 27.8 | 27.8 | 16324.0 |
| 2016-11-02 07:30:00 | AAPL | Stock | 27.8 | 27.8 | 27.78 | 27.79 | 22000.0 |
| 2016-11-02 07:35:00 | AAPL | Stock | 27.79 | 27.8 | 27.7875 | 27.8 | 13920.0 |
| 2016-11-02 07:40:00 | AAPL | Stock | 27.835 | 27.835 | 27.835 | 27.835 | 800.0 |
| 2016-11-02 07:45:00 | AAPL | Stock | 27.81 | 27.81 | 27.81 | 27.81 | 400.0 |
| 2016-11-02 07:55:00 | AAPL | Stock | 27.805 | 27.805 | 27.805 | 27.805 | 800.0 |
| 2016-11-02 08:00:00 | AAPL | Stock | 27.7875 | 27.825 | 27.75 | 27.825 | 18400.0 |
| 2016-11-02 08:05:00 | AAPL | Stock | 27.81 | 27.8125 | 27.81 | 27.8125 | 6600.0 |
| 2016-11-02 08:10:00 | AAPL | Stock | 27.8075 | 27.8075 | 27.805 | 27.8075 | 24352.0 |
| 2016-11-02 08:15:00 | AAPL | Stock | 27.8075 | 27.81 | 27.8075 | 27.8075 | 21000.0 |
| 2016-11-02 08:20:00 | AAPL | Stock | 27.81 | 27.81 | 27.795 | 27.8075 | 18444.0 |
| 2016-11-02 08:25:00 | AAPL | Stock | 27.79 | 27.7925 | 27.79 | 27.79 | 9908.0 |
| 2016-11-02 08:30:00 | AAPL | Stock | 27.79 | 27.8 | 27.7675 | 27.7675 | 38148.0 |
| 2016-11-02 08:35:00 | AAPL | Stock | 27.795 | 27.795 | 27.76 | 27.76 | 11712.0 |
| 2016-11-02 08:40:00 | AAPL | Stock | 27.77 | 27.79 | 27.7625 | 27.79 | 8244.0 |
| 2016-11-02 08:45:00 | AAPL | Stock | 27.79 | 27.79 | 27.7775 | 27.7875 | 13228.0 |
| 2016-11-02 08:50:00 | AAPL | Stock | 27.7975 | 27.82 | 27.7975 | 27.82 | 10792.0 |
| 2016-11-02 08:55:00 | AAPL | Stock | 27.825 | 27.825 | 27.8175 | 27.825 | 22400.0 |
| 2016-11-02 09:00:00 | AAPL | Stock | 27.825 | 27.825 | 27.825 | 27.825 | 1320.0 |
| 2016-11-02 09:05:00 | AAPL | Stock | 27.8175 | 27.82 | 27.8125 | 27.82 | 27600.0 |
| 2016-11-02 09:10:00 | AAPL | Stock | 27.8175 | 27.83 | 27.8175 | 27.83 | 4400.0 |
| 2016-11-02 09:15:00 | AAPL | Stock | 27.8175 | 27.8175 | 27.8125 | 27.815 | 9388.0 |
| 2016-11-02 09:20:00 | AAPL | Stock | 27.8175 | 27.825 | 27.815 | 27.825 | 25544.0 |
| 2016-11-02 09:25:00 | AAPL | Stock | 27.815 | 27.835 | 27.805 | 27.81 | 136328.0 |
| 2016-11-02 09:30:00 | AAPL | Stock | 27.85 | 28.0 | 27.8075 | 27.945 | 4905100.0 |
| 2016-11-02 09:35:00 | AAPL | Stock | 27.9438 | 28.0625 | 27.9225 | 28.0025 | 2971868.0 |
| 2016-11-02 09:40:00 | AAPL | Stock | 28.0038 | 28.025 | 27.9675 | 27.99 | 1525344.0 |
| 2016-11-02 09:45:00 | AAPL | Stock | 27.99 | 28.0275 | 27.99 | 28.0125 | 1765152.0 |
| 2016-11-02 09:50:00 | AAPL | Stock | 28.01 | 28.045 | 28.0025 | 28.03 | 2452548.0 |
| 2016-11-02 09:55:00 | AAPL | Stock | 28.03 | 28.0312 | 27.9825 | 28.0125 | 1538056.0 |
> showing 50 of 350,919 rows — these rows as CSV