PREVIEW / stock_5min / 2016-12-08
file: by_date/stock_5min/2016/2016-12-08.parquet size: 5.7 MB rows: 375,263 symbols: 3,175
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-12-08 07:00:00 | AAPL | Stock | 27.7375 | 27.7375 | 27.7375 | 27.7375 | 820.0 |
| 2016-12-08 07:25:00 | AAPL | Stock | 27.7225 | 27.7225 | 27.7225 | 27.7225 | 536.0 |
| 2016-12-08 07:30:00 | AAPL | Stock | 27.73 | 27.73 | 27.73 | 27.73 | 1600.0 |
| 2016-12-08 07:40:00 | AAPL | Stock | 27.705 | 27.705 | 27.6625 | 27.695 | 18688.0 |
| 2016-12-08 07:45:00 | AAPL | Stock | 27.6675 | 27.6675 | 27.65 | 27.6575 | 14040.0 |
| 2016-12-08 07:50:00 | AAPL | Stock | 27.7 | 27.7 | 27.6375 | 27.6375 | 22724.0 |
| 2016-12-08 07:55:00 | AAPL | Stock | 27.6975 | 27.7 | 27.69 | 27.69 | 4212.0 |
| 2016-12-08 08:00:00 | AAPL | Stock | 27.7275 | 27.7275 | 27.6625 | 27.67 | 41700.0 |
| 2016-12-08 08:05:00 | AAPL | Stock | 27.67 | 27.67 | 27.625 | 27.625 | 8616.0 |
| 2016-12-08 08:10:00 | AAPL | Stock | 27.635 | 27.6825 | 27.635 | 27.6825 | 880.0 |
| 2016-12-08 08:15:00 | AAPL | Stock | 27.685 | 27.6875 | 27.685 | 27.6875 | 1348.0 |
| 2016-12-08 08:20:00 | AAPL | Stock | 27.6875 | 27.6875 | 27.6875 | 27.6875 | 972.0 |
| 2016-12-08 08:25:00 | AAPL | Stock | 27.675 | 27.675 | 27.675 | 27.675 | 1520.0 |
| 2016-12-08 08:30:00 | AAPL | Stock | 27.6975 | 27.6975 | 27.675 | 27.675 | 3784.0 |
| 2016-12-08 08:35:00 | AAPL | Stock | 27.675 | 27.6975 | 27.6725 | 27.6875 | 2640.0 |
| 2016-12-08 08:40:00 | AAPL | Stock | 27.69 | 27.71 | 27.6875 | 27.6875 | 2172.0 |
| 2016-12-08 08:45:00 | AAPL | Stock | 27.6875 | 27.6875 | 27.6875 | 27.6875 | 492.0 |
| 2016-12-08 08:50:00 | AAPL | Stock | 27.675 | 27.71 | 27.675 | 27.6925 | 16540.0 |
| 2016-12-08 08:55:00 | AAPL | Stock | 27.71 | 27.735 | 27.71 | 27.73 | 12308.0 |
| 2016-12-08 09:00:00 | AAPL | Stock | 27.7 | 27.7125 | 27.7 | 27.7125 | 7136.0 |
| 2016-12-08 09:10:00 | AAPL | Stock | 27.735 | 27.7375 | 27.7 | 27.7 | 10788.0 |
| 2016-12-08 09:15:00 | AAPL | Stock | 27.7 | 27.7325 | 27.695 | 27.7325 | 7704.0 |
| 2016-12-08 09:20:00 | AAPL | Stock | 27.7125 | 27.7125 | 27.7125 | 27.7125 | 1820.0 |
| 2016-12-08 09:25:00 | AAPL | Stock | 27.72 | 27.725 | 27.69 | 27.7 | 9176.0 |
| 2016-12-08 09:30:00 | AAPL | Stock | 27.715 | 27.827 | 27.65 | 27.8225 | 3520512.0 |
| 2016-12-08 09:35:00 | AAPL | Stock | 27.825 | 27.94 | 27.8075 | 27.9275 | 3367080.0 |
| 2016-12-08 09:40:00 | AAPL | Stock | 27.93 | 27.995 | 27.8975 | 27.9525 | 2877004.0 |
| 2016-12-08 09:45:00 | AAPL | Stock | 27.9525 | 27.9925 | 27.93 | 27.9675 | 2397720.0 |
| 2016-12-08 09:50:00 | AAPL | Stock | 27.97 | 28.0325 | 27.9675 | 28.0185 | 3656696.0 |
| 2016-12-08 09:55:00 | AAPL | Stock | 28.02 | 28.02 | 27.9425 | 28.0038 | 2440180.0 |
| 2016-12-08 10:00:00 | AAPL | Stock | 28.005 | 28.0072 | 27.915 | 27.915 | 1696924.0 |
| 2016-12-08 10:05:00 | AAPL | Stock | 27.9175 | 27.9325 | 27.885 | 27.9175 | 2751320.0 |
| 2016-12-08 10:10:00 | AAPL | Stock | 27.92 | 27.945 | 27.9 | 27.9412 | 1380020.0 |
| 2016-12-08 10:15:00 | AAPL | Stock | 27.9418 | 27.9775 | 27.93 | 27.9562 | 1293728.0 |
| 2016-12-08 10:20:00 | AAPL | Stock | 27.9575 | 27.96 | 27.925 | 27.9375 | 970808.0 |
| 2016-12-08 10:25:00 | AAPL | Stock | 27.9375 | 27.9862 | 27.935 | 27.9675 | 957124.0 |
| 2016-12-08 10:30:00 | AAPL | Stock | 27.9675 | 27.9875 | 27.9525 | 27.9525 | 946488.0 |
| 2016-12-08 10:35:00 | AAPL | Stock | 27.9538 | 27.954 | 27.895 | 27.9238 | 953756.0 |
| 2016-12-08 10:40:00 | AAPL | Stock | 27.9235 | 27.9425 | 27.9125 | 27.9355 | 869504.0 |
| 2016-12-08 10:45:00 | AAPL | Stock | 27.935 | 27.955 | 27.9125 | 27.9475 | 654992.0 |
| 2016-12-08 10:50:00 | AAPL | Stock | 27.95 | 27.9825 | 27.9315 | 27.9775 | 833080.0 |
| 2016-12-08 10:55:00 | AAPL | Stock | 27.9792 | 27.9975 | 27.9685 | 27.9825 | 1136488.0 |
| 2016-12-08 11:00:00 | AAPL | Stock | 27.9838 | 28.025 | 27.965 | 28.0175 | 1499348.0 |
| 2016-12-08 11:05:00 | AAPL | Stock | 28.0132 | 28.0825 | 28.0125 | 28.075 | 2349272.0 |
| 2016-12-08 11:10:00 | AAPL | Stock | 28.0725 | 28.095 | 28.0675 | 28.0938 | 1203356.0 |
| 2016-12-08 11:15:00 | AAPL | Stock | 28.0925 | 28.095 | 28.03 | 28.055 | 1442904.0 |
| 2016-12-08 11:20:00 | AAPL | Stock | 28.055 | 28.065 | 28.0375 | 28.0475 | 1105332.0 |
| 2016-12-08 11:25:00 | AAPL | Stock | 28.0485 | 28.055 | 28.008 | 28.0125 | 1127620.0 |
| 2016-12-08 11:30:00 | AAPL | Stock | 28.015 | 28.02 | 27.9762 | 28.015 | 1112336.0 |
| 2016-12-08 11:35:00 | AAPL | Stock | 28.015 | 28.0325 | 27.98 | 27.9835 | 747872.0 |
> showing 50 of 375,263 rows — these rows as CSV