PREVIEW / stock_5min / 2016-11-10
file: by_date/stock_5min/2016/2016-11-10.parquet size: 5.9 MB rows: 383,271 symbols: 3,198
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-10 04:00:00 | AAPL | Stock | 27.885 | 28.0 | 27.885 | 28.0 | 6472.0 |
| 2016-11-10 04:15:00 | AAPL | Stock | 27.9725 | 27.9725 | 27.9725 | 27.9725 | 400.0 |
| 2016-11-10 04:25:00 | AAPL | Stock | 27.955 | 28.0 | 27.955 | 28.0 | 5600.0 |
| 2016-11-10 04:30:00 | AAPL | Stock | 28.0 | 28.0 | 27.985 | 27.985 | 800.0 |
| 2016-11-10 04:35:00 | AAPL | Stock | 27.9875 | 27.9875 | 27.9875 | 27.9875 | 400.0 |
| 2016-11-10 05:05:00 | AAPL | Stock | 27.9375 | 27.9375 | 27.9375 | 27.9375 | 400.0 |
| 2016-11-10 05:40:00 | AAPL | Stock | 27.9625 | 27.9675 | 27.9425 | 27.9425 | 3972.0 |
| 2016-11-10 06:00:00 | AAPL | Stock | 27.9625 | 27.9625 | 27.9425 | 27.9425 | 5328.0 |
| 2016-11-10 06:25:00 | AAPL | Stock | 27.8775 | 27.8775 | 27.8775 | 27.8775 | 400.0 |
| 2016-11-10 06:45:00 | AAPL | Stock | 27.935 | 27.9375 | 27.9325 | 27.935 | 16484.0 |
| 2016-11-10 06:50:00 | AAPL | Stock | 27.9325 | 27.935 | 27.9325 | 27.935 | 1600.0 |
| 2016-11-10 06:55:00 | AAPL | Stock | 27.935 | 27.935 | 27.935 | 27.935 | 400.0 |
| 2016-11-10 07:00:00 | AAPL | Stock | 27.935 | 27.9475 | 27.9275 | 27.9375 | 10144.0 |
| 2016-11-10 07:05:00 | AAPL | Stock | 27.925 | 27.925 | 27.9025 | 27.9025 | 1200.0 |
| 2016-11-10 07:10:00 | AAPL | Stock | 27.905 | 27.9125 | 27.8875 | 27.9125 | 20400.0 |
| 2016-11-10 07:15:00 | AAPL | Stock | 27.9125 | 27.9175 | 27.9125 | 27.9175 | 2300.0 |
| 2016-11-10 07:20:00 | AAPL | Stock | 27.9125 | 27.925 | 27.9125 | 27.9125 | 6748.0 |
| 2016-11-10 07:25:00 | AAPL | Stock | 27.9 | 27.9 | 27.8625 | 27.8625 | 19096.0 |
| 2016-11-10 07:30:00 | AAPL | Stock | 27.8625 | 27.87 | 27.7575 | 27.7575 | 26200.0 |
| 2016-11-10 07:35:00 | AAPL | Stock | 27.775 | 27.775 | 27.75 | 27.7625 | 30328.0 |
| 2016-11-10 07:40:00 | AAPL | Stock | 27.7625 | 27.775 | 27.75 | 27.75 | 47792.0 |
| 2016-11-10 07:45:00 | AAPL | Stock | 27.7475 | 27.775 | 27.7475 | 27.775 | 17400.0 |
| 2016-11-10 07:50:00 | AAPL | Stock | 27.775 | 27.775 | 27.75 | 27.75 | 33080.0 |
| 2016-11-10 07:55:00 | AAPL | Stock | 27.75 | 27.75 | 27.7175 | 27.75 | 23504.0 |
| 2016-11-10 08:00:00 | AAPL | Stock | 27.7475 | 27.925 | 27.7375 | 27.75 | 116740.0 |
| 2016-11-10 08:05:00 | AAPL | Stock | 27.75 | 27.75 | 27.745 | 27.75 | 88900.0 |
| 2016-11-10 08:10:00 | AAPL | Stock | 27.75 | 27.775 | 27.745 | 27.775 | 24764.0 |
| 2016-11-10 08:15:00 | AAPL | Stock | 27.77 | 27.77 | 27.755 | 27.755 | 8264.0 |
| 2016-11-10 08:20:00 | AAPL | Stock | 27.745 | 27.745 | 27.72 | 27.745 | 49920.0 |
| 2016-11-10 08:25:00 | AAPL | Stock | 27.7375 | 27.75 | 27.7375 | 27.75 | 99044.0 |
| 2016-11-10 08:30:00 | AAPL | Stock | 27.745 | 27.75 | 27.74 | 27.75 | 28636.0 |
| 2016-11-10 08:35:00 | AAPL | Stock | 27.75 | 27.75 | 27.7375 | 27.7475 | 29464.0 |
| 2016-11-10 08:40:00 | AAPL | Stock | 27.74 | 27.74 | 27.7275 | 27.7325 | 48496.0 |
| 2016-11-10 08:45:00 | AAPL | Stock | 27.7325 | 27.7375 | 27.7125 | 27.735 | 49752.0 |
| 2016-11-10 08:50:00 | AAPL | Stock | 27.735 | 27.7375 | 27.725 | 27.7375 | 53540.0 |
| 2016-11-10 08:55:00 | AAPL | Stock | 27.7375 | 27.75 | 27.7325 | 27.7425 | 31052.0 |
| 2016-11-10 09:00:00 | AAPL | Stock | 27.7425 | 27.745 | 27.735 | 27.735 | 17380.0 |
| 2016-11-10 09:05:00 | AAPL | Stock | 27.7375 | 27.7375 | 27.7125 | 27.7125 | 47792.0 |
| 2016-11-10 09:10:00 | AAPL | Stock | 27.715 | 27.715 | 27.7075 | 27.7125 | 20384.0 |
| 2016-11-10 09:15:00 | AAPL | Stock | 27.7125 | 27.7125 | 27.6925 | 27.695 | 44280.0 |
| 2016-11-10 09:20:00 | AAPL | Stock | 27.7 | 27.7 | 27.675 | 27.7 | 57992.0 |
| 2016-11-10 09:25:00 | AAPL | Stock | 27.7 | 27.8 | 27.675 | 27.7725 | 226856.0 |
| 2016-11-10 09:30:00 | AAPL | Stock | 27.77 | 27.7725 | 27.595 | 27.6225 | 5779508.0 |
| 2016-11-10 09:35:00 | AAPL | Stock | 27.625 | 27.695 | 27.5575 | 27.575 | 2752928.0 |
| 2016-11-10 09:40:00 | AAPL | Stock | 27.575 | 27.6788 | 27.5652 | 27.66 | 3700720.0 |
| 2016-11-10 09:45:00 | AAPL | Stock | 27.66 | 27.75 | 27.645 | 27.745 | 2546932.0 |
| 2016-11-10 09:50:00 | AAPL | Stock | 27.75 | 27.755 | 27.5312 | 27.6125 | 3718732.0 |
| 2016-11-10 09:55:00 | AAPL | Stock | 27.6175 | 27.6238 | 27.5375 | 27.5725 | 1995148.0 |
| 2016-11-10 10:00:00 | AAPL | Stock | 27.5775 | 27.65 | 27.5425 | 27.545 | 2187348.0 |
| 2016-11-10 10:05:00 | AAPL | Stock | 27.5475 | 27.565 | 27.33 | 27.3588 | 4878412.0 |
> showing 50 of 383,271 rows — these rows as CSV