PREVIEW / stock_5min / 2018-11-02
file: by_date/stock_5min/2018/2018-11-02.parquet size: 5.7 MB rows: 361,015 symbols: 2,747
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-11-02 04:00:00 | AAPL | Stock | 52.495 | 52.4975 | 52.3525 | 52.4975 | 94368.0 |
| 2018-11-02 04:05:00 | AAPL | Stock | 52.4975 | 52.7475 | 52.4975 | 52.65 | 31584.0 |
| 2018-11-02 04:10:00 | AAPL | Stock | 52.65 | 52.65 | 52.6 | 52.6 | 38912.0 |
| 2018-11-02 04:15:00 | AAPL | Stock | 52.62 | 52.75 | 52.62 | 52.745 | 33400.0 |
| 2018-11-02 04:20:00 | AAPL | Stock | 52.7125 | 52.8725 | 52.7125 | 52.855 | 28524.0 |
| 2018-11-02 04:25:00 | AAPL | Stock | 52.8475 | 53.05 | 52.8425 | 53.0 | 47892.0 |
| 2018-11-02 04:30:00 | AAPL | Stock | 53.005 | 53.05 | 52.8725 | 52.875 | 32240.0 |
| 2018-11-02 04:35:00 | AAPL | Stock | 52.8975 | 52.9975 | 52.8975 | 52.9925 | 14452.0 |
| 2018-11-02 04:40:00 | AAPL | Stock | 52.9925 | 52.9925 | 52.7925 | 52.88 | 21560.0 |
| 2018-11-02 04:45:00 | AAPL | Stock | 52.91 | 52.91 | 52.8025 | 52.8025 | 9136.0 |
| 2018-11-02 04:50:00 | AAPL | Stock | 52.7775 | 52.7775 | 52.5 | 52.69 | 61640.0 |
| 2018-11-02 04:55:00 | AAPL | Stock | 52.725 | 52.75 | 52.675 | 52.7125 | 24428.0 |
| 2018-11-02 05:00:00 | AAPL | Stock | 52.7475 | 52.75 | 52.7 | 52.7 | 15340.0 |
| 2018-11-02 05:05:00 | AAPL | Stock | 52.7 | 52.7375 | 52.6875 | 52.7225 | 8516.0 |
| 2018-11-02 05:10:00 | AAPL | Stock | 52.74 | 52.74 | 52.7175 | 52.7175 | 800.0 |
| 2018-11-02 05:15:00 | AAPL | Stock | 52.725 | 52.725 | 52.65 | 52.65 | 11704.0 |
| 2018-11-02 05:20:00 | AAPL | Stock | 52.65 | 52.65 | 52.5 | 52.56 | 41788.0 |
| 2018-11-02 05:25:00 | AAPL | Stock | 52.5625 | 52.745 | 52.5625 | 52.735 | 10792.0 |
| 2018-11-02 05:30:00 | AAPL | Stock | 52.7 | 52.8 | 52.7 | 52.725 | 34996.0 |
| 2018-11-02 05:35:00 | AAPL | Stock | 52.7 | 52.7725 | 52.7 | 52.7725 | 9524.0 |
| 2018-11-02 05:40:00 | AAPL | Stock | 52.735 | 52.7725 | 52.625 | 52.625 | 42576.0 |
| 2018-11-02 05:45:00 | AAPL | Stock | 52.6275 | 52.6925 | 52.5025 | 52.65 | 72072.0 |
| 2018-11-02 05:50:00 | AAPL | Stock | 52.6925 | 52.92 | 52.6625 | 52.85 | 23620.0 |
| 2018-11-02 05:55:00 | AAPL | Stock | 52.825 | 52.825 | 52.6875 | 52.6875 | 99944.0 |
| 2018-11-02 06:00:00 | AAPL | Stock | 52.6975 | 52.7375 | 52.67 | 52.71 | 9428.0 |
| 2018-11-02 06:05:00 | AAPL | Stock | 52.715 | 52.87 | 52.69 | 52.87 | 28124.0 |
| 2018-11-02 06:10:00 | AAPL | Stock | 52.8975 | 52.9125 | 52.7 | 52.7 | 56892.0 |
| 2018-11-02 06:15:00 | AAPL | Stock | 52.6975 | 52.6975 | 52.355 | 52.355 | 330232.0 |
| 2018-11-02 06:20:00 | AAPL | Stock | 52.3525 | 52.5175 | 52.35 | 52.4925 | 48072.0 |
| 2018-11-02 06:25:00 | AAPL | Stock | 52.395 | 52.6 | 52.39 | 52.575 | 46804.0 |
| 2018-11-02 06:30:00 | AAPL | Stock | 52.57 | 52.575 | 52.4025 | 52.4825 | 49788.0 |
| 2018-11-02 06:35:00 | AAPL | Stock | 52.4575 | 52.4575 | 52.375 | 52.4 | 27440.0 |
| 2018-11-02 06:40:00 | AAPL | Stock | 52.46 | 52.7 | 52.425 | 52.6975 | 47288.0 |
| 2018-11-02 06:45:00 | AAPL | Stock | 52.6725 | 52.6725 | 52.58 | 52.65 | 30184.0 |
| 2018-11-02 06:50:00 | AAPL | Stock | 52.5975 | 52.5975 | 52.425 | 52.4775 | 110020.0 |
| 2018-11-02 06:55:00 | AAPL | Stock | 52.4625 | 52.675 | 52.43 | 52.6375 | 26304.0 |
| 2018-11-02 07:00:00 | AAPL | Stock | 52.5925 | 52.8 | 52.4625 | 52.4625 | 447580.0 |
| 2018-11-02 07:05:00 | AAPL | Stock | 52.4575 | 52.595 | 52.4375 | 52.44 | 287700.0 |
| 2018-11-02 07:10:00 | AAPL | Stock | 52.47 | 52.475 | 52.2875 | 52.3475 | 184364.0 |
| 2018-11-02 07:15:00 | AAPL | Stock | 52.35 | 52.435 | 52.32 | 52.375 | 358400.0 |
| 2018-11-02 07:20:00 | AAPL | Stock | 52.3625 | 52.375 | 52.2025 | 52.25 | 261928.0 |
| 2018-11-02 07:25:00 | AAPL | Stock | 52.25 | 52.3425 | 52.025 | 52.1025 | 301256.0 |
| 2018-11-02 07:30:00 | AAPL | Stock | 52.1475 | 52.25 | 52.1475 | 52.1775 | 115852.0 |
| 2018-11-02 07:35:00 | AAPL | Stock | 52.1775 | 52.2825 | 52.1525 | 52.2825 | 117256.0 |
| 2018-11-02 07:40:00 | AAPL | Stock | 52.2825 | 52.325 | 52.1875 | 52.1875 | 210796.0 |
| 2018-11-02 07:45:00 | AAPL | Stock | 52.1875 | 52.2325 | 52.08 | 52.1375 | 141576.0 |
| 2018-11-02 07:50:00 | AAPL | Stock | 52.125 | 52.2675 | 52.11 | 52.2125 | 139216.0 |
| 2018-11-02 07:55:00 | AAPL | Stock | 52.2 | 52.4375 | 52.1875 | 52.4 | 191184.0 |
| 2018-11-02 08:00:00 | AAPL | Stock | 52.4 | 52.8 | 52.0975 | 52.29 | 1125648.0 |
| 2018-11-02 08:05:00 | AAPL | Stock | 52.2975 | 52.2975 | 52.1475 | 52.2275 | 290132.0 |
> showing 50 of 361,015 rows — these rows as CSV