PREVIEW / stock_5min / 2018-05-02
file: by_date/stock_5min/2018/2018-05-02.parquet size: 5.5 MB rows: 355,065 symbols: 2,841
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-05-02 04:00:00 | AAPL | Stock | 43.59 | 43.825 | 43.59 | 43.755 | 35504.0 |
| 2018-05-02 04:05:00 | AAPL | Stock | 43.75 | 43.75 | 43.675 | 43.75 | 65148.0 |
| 2018-05-02 04:10:00 | AAPL | Stock | 43.75 | 43.75 | 43.6875 | 43.6875 | 32160.0 |
| 2018-05-02 04:15:00 | AAPL | Stock | 43.73 | 43.7325 | 43.705 | 43.725 | 17204.0 |
| 2018-05-02 04:20:00 | AAPL | Stock | 43.725 | 43.725 | 43.6875 | 43.6875 | 12740.0 |
| 2018-05-02 04:25:00 | AAPL | Stock | 43.69 | 43.69 | 43.6725 | 43.6725 | 8108.0 |
| 2018-05-02 04:30:00 | AAPL | Stock | 43.6725 | 43.6725 | 43.5975 | 43.6275 | 45160.0 |
| 2018-05-02 04:35:00 | AAPL | Stock | 43.6125 | 43.6325 | 43.575 | 43.6125 | 16640.0 |
| 2018-05-02 04:40:00 | AAPL | Stock | 43.625 | 43.625 | 43.5 | 43.5 | 24856.0 |
| 2018-05-02 04:45:00 | AAPL | Stock | 43.475 | 43.5 | 43.455 | 43.4925 | 64064.0 |
| 2018-05-02 04:50:00 | AAPL | Stock | 43.46 | 43.5 | 43.455 | 43.475 | 9668.0 |
| 2018-05-02 04:55:00 | AAPL | Stock | 43.5 | 43.5 | 43.4525 | 43.455 | 6800.0 |
| 2018-05-02 05:00:00 | AAPL | Stock | 43.4875 | 43.4875 | 43.4875 | 43.4875 | 1188.0 |
| 2018-05-02 05:05:00 | AAPL | Stock | 43.475 | 43.475 | 43.45 | 43.45 | 6244.0 |
| 2018-05-02 05:10:00 | AAPL | Stock | 43.4625 | 43.465 | 43.4625 | 43.465 | 10604.0 |
| 2018-05-02 05:15:00 | AAPL | Stock | 43.4475 | 43.4475 | 43.4275 | 43.4275 | 5644.0 |
| 2018-05-02 05:20:00 | AAPL | Stock | 43.44 | 43.525 | 43.415 | 43.525 | 33428.0 |
| 2018-05-02 05:25:00 | AAPL | Stock | 43.4875 | 43.55 | 43.4875 | 43.55 | 2856.0 |
| 2018-05-02 05:30:00 | AAPL | Stock | 43.55 | 43.55 | 43.55 | 43.55 | 800.0 |
| 2018-05-02 05:35:00 | AAPL | Stock | 43.575 | 43.6275 | 43.575 | 43.6125 | 5356.0 |
| 2018-05-02 05:40:00 | AAPL | Stock | 43.6275 | 43.71 | 43.6275 | 43.695 | 18008.0 |
| 2018-05-02 05:45:00 | AAPL | Stock | 43.7025 | 43.75 | 43.7025 | 43.725 | 33916.0 |
| 2018-05-02 05:50:00 | AAPL | Stock | 43.7325 | 43.75 | 43.7175 | 43.75 | 10212.0 |
| 2018-05-02 05:55:00 | AAPL | Stock | 43.765 | 43.765 | 43.7025 | 43.7325 | 19424.0 |
| 2018-05-02 06:00:00 | AAPL | Stock | 43.7375 | 43.75 | 43.6875 | 43.7025 | 28784.0 |
| 2018-05-02 06:05:00 | AAPL | Stock | 43.6875 | 43.715 | 43.625 | 43.6625 | 45560.0 |
| 2018-05-02 06:10:00 | AAPL | Stock | 43.6375 | 43.675 | 43.6375 | 43.66 | 9304.0 |
| 2018-05-02 06:15:00 | AAPL | Stock | 43.665 | 43.675 | 43.6425 | 43.6425 | 6388.0 |
| 2018-05-02 06:20:00 | AAPL | Stock | 43.6275 | 43.6275 | 43.5975 | 43.5975 | 10940.0 |
| 2018-05-02 06:25:00 | AAPL | Stock | 43.6 | 43.6125 | 43.575 | 43.575 | 5024.0 |
| 2018-05-02 06:30:00 | AAPL | Stock | 43.5625 | 43.575 | 43.55 | 43.55 | 3368.0 |
| 2018-05-02 06:35:00 | AAPL | Stock | 43.5525 | 43.6425 | 43.5525 | 43.6425 | 16552.0 |
| 2018-05-02 06:40:00 | AAPL | Stock | 43.6275 | 43.6425 | 43.625 | 43.6425 | 4432.0 |
| 2018-05-02 06:45:00 | AAPL | Stock | 43.6575 | 43.6575 | 43.6575 | 43.6575 | 800.0 |
| 2018-05-02 06:55:00 | AAPL | Stock | 43.6725 | 43.685 | 43.6725 | 43.685 | 1200.0 |
| 2018-05-02 07:00:00 | AAPL | Stock | 43.6825 | 43.7975 | 43.6575 | 43.7525 | 143860.0 |
| 2018-05-02 07:05:00 | AAPL | Stock | 43.7525 | 43.8625 | 43.75 | 43.8275 | 184288.0 |
| 2018-05-02 07:10:00 | AAPL | Stock | 43.845 | 43.875 | 43.785 | 43.8625 | 229144.0 |
| 2018-05-02 07:15:00 | AAPL | Stock | 43.8625 | 44.0375 | 43.8625 | 44.03 | 370244.0 |
| 2018-05-02 07:20:00 | AAPL | Stock | 44.0425 | 44.0625 | 44.0 | 44.0175 | 161768.0 |
| 2018-05-02 07:25:00 | AAPL | Stock | 44.025 | 44.1125 | 43.9975 | 44.0875 | 234012.0 |
| 2018-05-02 07:30:00 | AAPL | Stock | 44.075 | 44.17 | 44.065 | 44.15 | 283872.0 |
| 2018-05-02 07:35:00 | AAPL | Stock | 44.1475 | 44.2 | 44.125 | 44.1275 | 139488.0 |
| 2018-05-02 07:40:00 | AAPL | Stock | 44.13 | 44.165 | 44.125 | 44.1375 | 73696.0 |
| 2018-05-02 07:45:00 | AAPL | Stock | 44.1375 | 44.1425 | 44.0625 | 44.0625 | 148136.0 |
| 2018-05-02 07:50:00 | AAPL | Stock | 44.05 | 44.1875 | 44.05 | 44.1525 | 135508.0 |
| 2018-05-02 07:55:00 | AAPL | Stock | 44.15 | 44.24 | 44.125 | 44.22 | 216024.0 |
| 2018-05-02 08:00:00 | AAPL | Stock | 44.11 | 44.3125 | 43.775 | 44.235 | 1233452.0 |
| 2018-05-02 08:05:00 | AAPL | Stock | 44.2375 | 44.2425 | 43.675 | 44.1325 | 310420.0 |
| 2018-05-02 08:10:00 | AAPL | Stock | 44.135 | 44.2 | 44.125 | 44.1425 | 293624.0 |
> showing 50 of 355,065 rows — these rows as CSV