PREVIEW / stock_5min / 2018-08-30
file: by_date/stock_5min/2018/2018-08-30.parquet size: 5.5 MB rows: 349,182 symbols: 2,780
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 |
|---|---|---|---|---|---|---|---|
| 2018-08-30 04:00:00 | AAPL | Stock | 56.0 | 56.0 | 55.7825 | 55.7825 | 2004.0 |
| 2018-08-30 04:10:00 | AAPL | Stock | 55.83 | 55.83 | 55.83 | 55.83 | 400.0 |
| 2018-08-30 04:20:00 | AAPL | Stock | 55.79 | 55.8375 | 55.7825 | 55.8125 | 14936.0 |
| 2018-08-30 04:40:00 | AAPL | Stock | 55.775 | 55.775 | 55.7125 | 55.7125 | 16460.0 |
| 2018-08-30 04:45:00 | AAPL | Stock | 55.7225 | 55.7225 | 55.7125 | 55.7125 | 2020.0 |
| 2018-08-30 04:55:00 | AAPL | Stock | 55.7125 | 55.75 | 55.7125 | 55.75 | 1560.0 |
| 2018-08-30 05:10:00 | AAPL | Stock | 55.75 | 55.75 | 55.75 | 55.75 | 1880.0 |
| 2018-08-30 05:15:00 | AAPL | Stock | 55.7625 | 55.7625 | 55.75 | 55.75 | 1200.0 |
| 2018-08-30 05:20:00 | AAPL | Stock | 55.7475 | 55.7625 | 55.7475 | 55.7625 | 2108.0 |
| 2018-08-30 05:25:00 | AAPL | Stock | 55.75 | 55.75 | 55.75 | 55.75 | 1200.0 |
| 2018-08-30 05:35:00 | AAPL | Stock | 55.7625 | 55.7625 | 55.7625 | 55.7625 | 1600.0 |
| 2018-08-30 05:45:00 | AAPL | Stock | 55.75 | 55.75 | 55.75 | 55.75 | 400.0 |
| 2018-08-30 05:50:00 | AAPL | Stock | 55.73 | 55.73 | 55.73 | 55.73 | 400.0 |
| 2018-08-30 06:00:00 | AAPL | Stock | 55.75 | 55.75 | 55.75 | 55.75 | 1792.0 |
| 2018-08-30 06:05:00 | AAPL | Stock | 55.73 | 55.73 | 55.725 | 55.725 | 7496.0 |
| 2018-08-30 06:10:00 | AAPL | Stock | 55.7125 | 55.7125 | 55.7125 | 55.7125 | 920.0 |
| 2018-08-30 06:15:00 | AAPL | Stock | 55.72 | 55.72 | 55.72 | 55.72 | 400.0 |
| 2018-08-30 06:20:00 | AAPL | Stock | 55.68 | 55.6825 | 55.68 | 55.6825 | 7200.0 |
| 2018-08-30 06:35:00 | AAPL | Stock | 55.7 | 55.7125 | 55.685 | 55.7125 | 6008.0 |
| 2018-08-30 06:40:00 | AAPL | Stock | 55.7125 | 55.75 | 55.7125 | 55.75 | 11972.0 |
| 2018-08-30 06:50:00 | AAPL | Stock | 55.7675 | 55.8125 | 55.7675 | 55.8125 | 4520.0 |
| 2018-08-30 06:55:00 | AAPL | Stock | 55.77 | 55.77 | 55.77 | 55.77 | 732.0 |
| 2018-08-30 07:00:00 | AAPL | Stock | 55.78 | 55.81 | 55.5525 | 55.775 | 41096.0 |
| 2018-08-30 07:05:00 | AAPL | Stock | 55.8 | 55.8 | 55.8 | 55.8 | 4000.0 |
| 2018-08-30 07:10:00 | AAPL | Stock | 55.7875 | 55.7875 | 55.745 | 55.75 | 18840.0 |
| 2018-08-30 07:15:00 | AAPL | Stock | 55.7675 | 55.775 | 55.7675 | 55.775 | 2000.0 |
| 2018-08-30 07:20:00 | AAPL | Stock | 55.775 | 55.775 | 55.775 | 55.775 | 7504.0 |
| 2018-08-30 07:25:00 | AAPL | Stock | 55.775 | 55.775 | 55.775 | 55.775 | 8804.0 |
| 2018-08-30 07:30:00 | AAPL | Stock | 55.775 | 55.845 | 55.775 | 55.84 | 6044.0 |
| 2018-08-30 07:35:00 | AAPL | Stock | 55.835 | 55.835 | 55.8075 | 55.8075 | 1400.0 |
| 2018-08-30 07:40:00 | AAPL | Stock | 55.805 | 55.805 | 55.805 | 55.805 | 1200.0 |
| 2018-08-30 07:45:00 | AAPL | Stock | 55.8075 | 55.8075 | 55.8075 | 55.8075 | 8908.0 |
| 2018-08-30 07:50:00 | AAPL | Stock | 55.805 | 55.825 | 55.7925 | 55.825 | 6112.0 |
| 2018-08-30 07:55:00 | AAPL | Stock | 55.835 | 55.85 | 55.825 | 55.825 | 30588.0 |
| 2018-08-30 08:00:00 | AAPL | Stock | 55.7575 | 55.85 | 55.6625 | 55.805 | 105396.0 |
| 2018-08-30 08:05:00 | AAPL | Stock | 55.8075 | 55.85 | 55.8075 | 55.85 | 13768.0 |
| 2018-08-30 08:10:00 | AAPL | Stock | 55.8475 | 55.935 | 55.8475 | 55.925 | 52212.0 |
| 2018-08-30 08:15:00 | AAPL | Stock | 55.9375 | 55.965 | 55.9025 | 55.9225 | 60060.0 |
| 2018-08-30 08:20:00 | AAPL | Stock | 55.9 | 55.9225 | 55.89 | 55.9225 | 25096.0 |
| 2018-08-30 08:25:00 | AAPL | Stock | 55.9225 | 55.935 | 55.91 | 55.91 | 19616.0 |
| 2018-08-30 08:30:00 | AAPL | Stock | 55.91 | 55.93 | 55.91 | 55.925 | 24200.0 |
| 2018-08-30 08:35:00 | AAPL | Stock | 55.925 | 55.96 | 55.925 | 55.95 | 14132.0 |
| 2018-08-30 08:40:00 | AAPL | Stock | 55.95 | 55.9625 | 55.925 | 55.925 | 33128.0 |
| 2018-08-30 08:45:00 | AAPL | Stock | 55.925 | 55.96 | 55.8625 | 55.8725 | 83940.0 |
| 2018-08-30 08:50:00 | AAPL | Stock | 55.875 | 55.9 | 55.875 | 55.8875 | 7840.0 |
| 2018-08-30 08:55:00 | AAPL | Stock | 55.8825 | 55.8825 | 55.8525 | 55.8575 | 41732.0 |
| 2018-08-30 09:00:00 | AAPL | Stock | 55.8575 | 55.89 | 55.85 | 55.8875 | 20164.0 |
| 2018-08-30 09:05:00 | AAPL | Stock | 55.8752 | 55.885 | 55.825 | 55.8275 | 48844.0 |
| 2018-08-30 09:10:00 | AAPL | Stock | 55.83 | 55.85 | 55.83 | 55.8375 | 44600.0 |
| 2018-08-30 09:15:00 | AAPL | Stock | 55.835 | 55.8475 | 55.825 | 55.825 | 31924.0 |
> showing 50 of 349,182 rows — these rows as CSV