PREVIEW / stock_5min / 2016-12-16
file: by_date/stock_5min/2016/2016-12-16.parquet size: 5.6 MB rows: 367,105 symbols: 3,177
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-16 04:05:00 | AAPL | Stock | 28.8825 | 28.8825 | 28.88 | 28.88 | 6080.0 |
| 2016-12-16 04:10:00 | AAPL | Stock | 28.88 | 28.88 | 28.88 | 28.88 | 800.0 |
| 2016-12-16 04:55:00 | AAPL | Stock | 28.8825 | 28.8825 | 28.8825 | 28.8825 | 400.0 |
| 2016-12-16 05:00:00 | AAPL | Stock | 28.8375 | 28.8375 | 28.8375 | 28.8375 | 2800.0 |
| 2016-12-16 05:10:00 | AAPL | Stock | 28.8825 | 28.8825 | 28.855 | 28.855 | 1088.0 |
| 2016-12-16 05:20:00 | AAPL | Stock | 28.8825 | 28.8825 | 28.8825 | 28.8825 | 1720.0 |
| 2016-12-16 05:35:00 | AAPL | Stock | 28.8825 | 28.885 | 28.8825 | 28.885 | 8140.0 |
| 2016-12-16 05:40:00 | AAPL | Stock | 28.91 | 28.925 | 28.91 | 28.9225 | 4108.0 |
| 2016-12-16 05:50:00 | AAPL | Stock | 28.925 | 28.925 | 28.925 | 28.925 | 5600.0 |
| 2016-12-16 06:15:00 | AAPL | Stock | 28.9075 | 28.9075 | 28.9075 | 28.9075 | 400.0 |
| 2016-12-16 06:25:00 | AAPL | Stock | 28.9 | 28.9 | 28.9 | 28.9 | 716.0 |
| 2016-12-16 06:35:00 | AAPL | Stock | 28.93 | 28.93 | 28.93 | 28.93 | 1772.0 |
| 2016-12-16 06:45:00 | AAPL | Stock | 28.93 | 28.93 | 28.93 | 28.93 | 5600.0 |
| 2016-12-16 07:05:00 | AAPL | Stock | 28.965 | 28.9875 | 28.965 | 28.9875 | 4812.0 |
| 2016-12-16 07:20:00 | AAPL | Stock | 29.0125 | 29.045 | 29.005 | 29.005 | 22472.0 |
| 2016-12-16 07:25:00 | AAPL | Stock | 29.01 | 29.01 | 29.01 | 29.01 | 3408.0 |
| 2016-12-16 07:30:00 | AAPL | Stock | 29.0125 | 29.0375 | 29.0125 | 29.0375 | 1400.0 |
| 2016-12-16 07:35:00 | AAPL | Stock | 29.03 | 29.0375 | 29.03 | 29.0375 | 4160.0 |
| 2016-12-16 07:40:00 | AAPL | Stock | 29.045 | 29.0625 | 29.045 | 29.0625 | 3192.0 |
| 2016-12-16 07:45:00 | AAPL | Stock | 29.04 | 29.04 | 29.04 | 29.04 | 800.0 |
| 2016-12-16 07:50:00 | AAPL | Stock | 29.05 | 29.075 | 29.0475 | 29.075 | 14752.0 |
| 2016-12-16 07:55:00 | AAPL | Stock | 29.0625 | 29.0625 | 29.0625 | 29.0625 | 2800.0 |
| 2016-12-16 08:00:00 | AAPL | Stock | 29.0625 | 29.0875 | 29.0125 | 29.0875 | 24400.0 |
| 2016-12-16 08:05:00 | AAPL | Stock | 29.075 | 29.1075 | 29.0725 | 29.1025 | 93132.0 |
| 2016-12-16 08:10:00 | AAPL | Stock | 29.11 | 29.1175 | 29.1025 | 29.1125 | 17536.0 |
| 2016-12-16 08:15:00 | AAPL | Stock | 29.1025 | 29.1125 | 29.0975 | 29.0975 | 23868.0 |
| 2016-12-16 08:20:00 | AAPL | Stock | 29.0975 | 29.0975 | 29.0875 | 29.0875 | 42292.0 |
| 2016-12-16 08:25:00 | AAPL | Stock | 29.0975 | 29.0975 | 29.0875 | 29.0875 | 52800.0 |
| 2016-12-16 08:30:00 | AAPL | Stock | 29.0625 | 29.0775 | 29.0625 | 29.0775 | 1960.0 |
| 2016-12-16 08:35:00 | AAPL | Stock | 29.0875 | 29.095 | 29.075 | 29.0875 | 20460.0 |
| 2016-12-16 08:40:00 | AAPL | Stock | 29.0875 | 29.105 | 29.0875 | 29.1 | 14776.0 |
| 2016-12-16 08:45:00 | AAPL | Stock | 29.1 | 29.1075 | 29.0875 | 29.0875 | 42432.0 |
| 2016-12-16 08:50:00 | AAPL | Stock | 29.095 | 29.095 | 29.0875 | 29.0875 | 36864.0 |
| 2016-12-16 08:55:00 | AAPL | Stock | 29.0875 | 29.0875 | 29.0875 | 29.0875 | 932.0 |
| 2016-12-16 09:00:00 | AAPL | Stock | 29.0875 | 29.09 | 29.075 | 29.0875 | 20264.0 |
| 2016-12-16 09:05:00 | AAPL | Stock | 29.0825 | 29.0925 | 29.075 | 29.075 | 27552.0 |
| 2016-12-16 09:10:00 | AAPL | Stock | 29.075 | 29.0875 | 29.065 | 29.0875 | 24220.0 |
| 2016-12-16 09:15:00 | AAPL | Stock | 29.07 | 29.085 | 29.0625 | 29.0625 | 20520.0 |
| 2016-12-16 09:20:00 | AAPL | Stock | 29.0625 | 29.0875 | 29.0625 | 29.08 | 53060.0 |
| 2016-12-16 09:25:00 | AAPL | Stock | 29.0875 | 29.1325 | 29.07 | 29.0825 | 309624.0 |
| 2016-12-16 09:30:00 | AAPL | Stock | 29.0825 | 29.125 | 29.0375 | 29.085 | 32100976.0 |
| 2016-12-16 09:35:00 | AAPL | Stock | 29.085 | 29.0875 | 28.9875 | 29.025 | 2927868.0 |
| 2016-12-16 09:40:00 | AAPL | Stock | 29.0225 | 29.05 | 28.9725 | 29.05 | 1943540.0 |
| 2016-12-16 09:45:00 | AAPL | Stock | 29.05 | 29.06 | 29.0012 | 29.015 | 1680304.0 |
| 2016-12-16 09:50:00 | AAPL | Stock | 29.0125 | 29.055 | 29.005 | 29.039 | 1755544.0 |
| 2016-12-16 09:55:00 | AAPL | Stock | 29.04 | 29.08 | 29.03 | 29.07 | 1791884.0 |
| 2016-12-16 10:00:00 | AAPL | Stock | 29.0725 | 29.0825 | 29.008 | 29.0365 | 1294948.0 |
| 2016-12-16 10:05:00 | AAPL | Stock | 29.0362 | 29.0475 | 29.0138 | 29.0362 | 743832.0 |
| 2016-12-16 10:10:00 | AAPL | Stock | 29.035 | 29.0725 | 29.02 | 29.02 | 1032372.0 |
| 2016-12-16 10:15:00 | AAPL | Stock | 29.0225 | 29.0225 | 28.9762 | 28.9975 | 1575216.0 |
> showing 50 of 367,105 rows — these rows as CSV