PREVIEW / stock_5min / 2016-03-22
file: by_date/stock_5min/2016/2016-03-22.parquet size: 5.3 MB rows: 352,133 symbols: 3,332
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-03-22 04:00:00 | AAPL | Stock | 26.49 | 26.49 | 26.4 | 26.43 | 10920.0 |
| 2016-03-22 04:10:00 | AAPL | Stock | 26.3775 | 26.3775 | 26.375 | 26.375 | 6524.0 |
| 2016-03-22 04:15:00 | AAPL | Stock | 26.3925 | 26.3925 | 26.3925 | 26.3925 | 400.0 |
| 2016-03-22 04:20:00 | AAPL | Stock | 26.35 | 26.35 | 26.35 | 26.35 | 400.0 |
| 2016-03-22 04:40:00 | AAPL | Stock | 26.3025 | 26.3025 | 26.3025 | 26.3025 | 400.0 |
| 2016-03-22 05:35:00 | AAPL | Stock | 26.395 | 26.395 | 26.395 | 26.395 | 1200.0 |
| 2016-03-22 05:40:00 | AAPL | Stock | 26.425 | 26.425 | 26.425 | 26.425 | 400.0 |
| 2016-03-22 06:05:00 | AAPL | Stock | 26.425 | 26.425 | 26.425 | 26.425 | 2800.0 |
| 2016-03-22 06:10:00 | AAPL | Stock | 26.45 | 26.45 | 26.45 | 26.45 | 800.0 |
| 2016-03-22 06:40:00 | AAPL | Stock | 26.38 | 26.4075 | 26.38 | 26.4075 | 2800.0 |
| 2016-03-22 06:45:00 | AAPL | Stock | 26.41 | 26.41 | 26.41 | 26.41 | 400.0 |
| 2016-03-22 06:55:00 | AAPL | Stock | 26.385 | 26.385 | 26.385 | 26.385 | 428.0 |
| 2016-03-22 07:00:00 | AAPL | Stock | 26.3825 | 26.4 | 26.355 | 26.375 | 6400.0 |
| 2016-03-22 07:05:00 | AAPL | Stock | 26.37 | 26.4 | 26.3675 | 26.4 | 6080.0 |
| 2016-03-22 07:10:00 | AAPL | Stock | 26.4025 | 26.4025 | 26.4025 | 26.4025 | 1200.0 |
| 2016-03-22 07:15:00 | AAPL | Stock | 26.4025 | 26.43 | 26.4 | 26.43 | 6200.0 |
| 2016-03-22 07:20:00 | AAPL | Stock | 26.41 | 26.41 | 26.41 | 26.41 | 460.0 |
| 2016-03-22 07:30:00 | AAPL | Stock | 26.42 | 26.4325 | 26.4175 | 26.4175 | 2700.0 |
| 2016-03-22 07:35:00 | AAPL | Stock | 26.43 | 26.43 | 26.43 | 26.43 | 400.0 |
| 2016-03-22 07:40:00 | AAPL | Stock | 26.425 | 26.435 | 26.42 | 26.42 | 6332.0 |
| 2016-03-22 07:45:00 | AAPL | Stock | 26.42 | 26.42 | 26.4175 | 26.4175 | 4020.0 |
| 2016-03-22 07:50:00 | AAPL | Stock | 26.4175 | 26.4175 | 26.3875 | 26.3875 | 40200.0 |
| 2016-03-22 07:55:00 | AAPL | Stock | 26.38 | 26.3975 | 26.38 | 26.3975 | 2188.0 |
| 2016-03-22 08:00:00 | AAPL | Stock | 26.395 | 26.43 | 26.38 | 26.39 | 45128.0 |
| 2016-03-22 08:05:00 | AAPL | Stock | 26.3925 | 26.4125 | 26.3875 | 26.3875 | 10468.0 |
| 2016-03-22 08:10:00 | AAPL | Stock | 26.4 | 26.405 | 26.4 | 26.4025 | 8352.0 |
| 2016-03-22 08:15:00 | AAPL | Stock | 26.4025 | 26.4075 | 26.3925 | 26.3925 | 28412.0 |
| 2016-03-22 08:20:00 | AAPL | Stock | 26.395 | 26.3975 | 26.385 | 26.3875 | 20004.0 |
| 2016-03-22 08:25:00 | AAPL | Stock | 26.3875 | 26.4 | 26.3875 | 26.4 | 26412.0 |
| 2016-03-22 08:30:00 | AAPL | Stock | 26.4075 | 26.4075 | 26.4 | 26.4075 | 8576.0 |
| 2016-03-22 08:35:00 | AAPL | Stock | 26.41 | 26.4175 | 26.4075 | 26.4125 | 12816.0 |
| 2016-03-22 08:40:00 | AAPL | Stock | 26.4125 | 26.425 | 26.405 | 26.405 | 7400.0 |
| 2016-03-22 08:45:00 | AAPL | Stock | 26.41 | 26.42 | 26.4075 | 26.4075 | 4400.0 |
| 2016-03-22 08:50:00 | AAPL | Stock | 26.4125 | 26.425 | 26.3975 | 26.4075 | 42080.0 |
| 2016-03-22 08:55:00 | AAPL | Stock | 26.4 | 26.42 | 26.4 | 26.4025 | 6380.0 |
| 2016-03-22 09:00:00 | AAPL | Stock | 26.4 | 26.4 | 26.4 | 26.4 | 1520.0 |
| 2016-03-22 09:05:00 | AAPL | Stock | 26.4 | 26.4175 | 26.395 | 26.4025 | 39856.0 |
| 2016-03-22 09:10:00 | AAPL | Stock | 26.395 | 26.4 | 26.3825 | 26.3825 | 65580.0 |
| 2016-03-22 09:15:00 | AAPL | Stock | 26.3825 | 26.3825 | 26.36 | 26.365 | 76184.0 |
| 2016-03-22 09:20:00 | AAPL | Stock | 26.375 | 26.3875 | 26.365 | 26.38 | 12520.0 |
| 2016-03-22 09:25:00 | AAPL | Stock | 26.3875 | 26.3875 | 26.315 | 26.315 | 208648.0 |
| 2016-03-22 09:30:00 | AAPL | Stock | 26.3125 | 26.395 | 26.3025 | 26.395 | 4258292.0 |
| 2016-03-22 09:35:00 | AAPL | Stock | 26.395 | 26.4925 | 26.38 | 26.4925 | 2565708.0 |
| 2016-03-22 09:40:00 | AAPL | Stock | 26.4902 | 26.6 | 26.4475 | 26.59 | 3164136.0 |
| 2016-03-22 09:45:00 | AAPL | Stock | 26.59 | 26.6425 | 26.5265 | 26.625 | 3895476.0 |
| 2016-03-22 09:50:00 | AAPL | Stock | 26.6225 | 26.665 | 26.5878 | 26.655 | 2417464.0 |
| 2016-03-22 09:55:00 | AAPL | Stock | 26.6575 | 26.705 | 26.6475 | 26.66 | 3903852.0 |
| 2016-03-22 10:00:00 | AAPL | Stock | 26.66 | 26.7225 | 26.6585 | 26.6975 | 2766868.0 |
| 2016-03-22 10:05:00 | AAPL | Stock | 26.7 | 26.77 | 26.695 | 26.695 | 3404512.0 |
| 2016-03-22 10:10:00 | AAPL | Stock | 26.695 | 26.7712 | 26.6925 | 26.7502 | 2389540.0 |
> showing 50 of 352,133 rows — these rows as CSV