PREVIEW / stock_5min / 2016-12-09
file: by_date/stock_5min/2016/2016-12-09.parquet size: 5.6 MB rows: 369,593 symbols: 3,167
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-12-09 04:00:00 | AAPL | Stock | 28.0 | 28.0 | 28.0 | 28.0 | 5600.0 |
| 2016-12-09 04:30:00 | AAPL | Stock | 27.9125 | 27.9125 | 27.9125 | 27.9125 | 400.0 |
| 2016-12-09 04:40:00 | AAPL | Stock | 27.9125 | 27.9125 | 27.9125 | 27.9125 | 400.0 |
| 2016-12-09 04:45:00 | AAPL | Stock | 27.9125 | 27.9125 | 27.9125 | 27.9125 | 400.0 |
| 2016-12-09 05:10:00 | AAPL | Stock | 27.905 | 27.905 | 27.905 | 27.905 | 400.0 |
| 2016-12-09 05:15:00 | AAPL | Stock | 27.905 | 27.905 | 27.905 | 27.905 | 400.0 |
| 2016-12-09 05:35:00 | AAPL | Stock | 27.95 | 27.95 | 27.95 | 27.95 | 400.0 |
| 2016-12-09 06:30:00 | AAPL | Stock | 27.9375 | 27.9375 | 27.9375 | 27.9375 | 1248.0 |
| 2016-12-09 07:05:00 | AAPL | Stock | 27.995 | 28.0 | 27.995 | 28.0 | 10400.0 |
| 2016-12-09 07:10:00 | AAPL | Stock | 28.0 | 28.0 | 27.995 | 27.995 | 1256.0 |
| 2016-12-09 07:15:00 | AAPL | Stock | 27.9975 | 28.01 | 27.995 | 28.01 | 6080.0 |
| 2016-12-09 07:20:00 | AAPL | Stock | 27.99 | 27.99 | 27.99 | 27.99 | 420.0 |
| 2016-12-09 07:25:00 | AAPL | Stock | 28.0 | 28.005 | 27.9975 | 28.005 | 16900.0 |
| 2016-12-09 07:30:00 | AAPL | Stock | 27.9925 | 28.01 | 27.9925 | 28.01 | 7200.0 |
| 2016-12-09 07:35:00 | AAPL | Stock | 28.0225 | 28.0225 | 28.0225 | 28.0225 | 3200.0 |
| 2016-12-09 07:45:00 | AAPL | Stock | 28.0075 | 28.0225 | 28.0075 | 28.0225 | 2020.0 |
| 2016-12-09 07:50:00 | AAPL | Stock | 28.0075 | 28.0075 | 28.0075 | 28.0075 | 952.0 |
| 2016-12-09 08:00:00 | AAPL | Stock | 28.025 | 28.025 | 27.975 | 28.0125 | 21852.0 |
| 2016-12-09 08:05:00 | AAPL | Stock | 28.0125 | 28.025 | 28.0125 | 28.025 | 8400.0 |
| 2016-12-09 08:10:00 | AAPL | Stock | 28.025 | 28.025 | 28.0125 | 28.0125 | 18000.0 |
| 2016-12-09 08:15:00 | AAPL | Stock | 28.025 | 28.0275 | 28.025 | 28.0275 | 3696.0 |
| 2016-12-09 08:20:00 | AAPL | Stock | 28.025 | 28.025 | 28.025 | 28.025 | 1560.0 |
| 2016-12-09 08:30:00 | AAPL | Stock | 28.02 | 28.025 | 28.02 | 28.025 | 6400.0 |
| 2016-12-09 08:35:00 | AAPL | Stock | 28.0375 | 28.045 | 28.0375 | 28.045 | 11800.0 |
| 2016-12-09 08:40:00 | AAPL | Stock | 28.06 | 28.08 | 28.04 | 28.08 | 18836.0 |
| 2016-12-09 08:45:00 | AAPL | Stock | 28.0675 | 28.095 | 28.0675 | 28.095 | 2372.0 |
| 2016-12-09 08:50:00 | AAPL | Stock | 28.095 | 28.1 | 28.095 | 28.1 | 6736.0 |
| 2016-12-09 08:55:00 | AAPL | Stock | 28.0875 | 28.0875 | 28.0875 | 28.0875 | 6428.0 |
| 2016-12-09 09:00:00 | AAPL | Stock | 28.0875 | 28.115 | 28.0875 | 28.1075 | 13716.0 |
| 2016-12-09 09:05:00 | AAPL | Stock | 28.1075 | 28.115 | 28.1 | 28.1 | 20624.0 |
| 2016-12-09 09:10:00 | AAPL | Stock | 28.1 | 28.125 | 28.1 | 28.12 | 45740.0 |
| 2016-12-09 09:15:00 | AAPL | Stock | 28.12 | 28.1275 | 28.12 | 28.125 | 17700.0 |
| 2016-12-09 09:20:00 | AAPL | Stock | 28.12 | 28.1475 | 28.1175 | 28.1375 | 10320.0 |
| 2016-12-09 09:25:00 | AAPL | Stock | 28.1375 | 28.1525 | 28.095 | 28.13 | 69948.0 |
| 2016-12-09 09:30:00 | AAPL | Stock | 28.0775 | 28.31 | 28.0775 | 28.3088 | 6780080.0 |
| 2016-12-09 09:35:00 | AAPL | Stock | 28.31 | 28.3275 | 28.25 | 28.275 | 3742176.0 |
| 2016-12-09 09:40:00 | AAPL | Stock | 28.2725 | 28.3275 | 28.2325 | 28.3275 | 2665608.0 |
| 2016-12-09 09:45:00 | AAPL | Stock | 28.33 | 28.3775 | 28.32 | 28.35 | 3805448.0 |
| 2016-12-09 09:50:00 | AAPL | Stock | 28.35 | 28.355 | 28.315 | 28.325 | 1615084.0 |
| 2016-12-09 09:55:00 | AAPL | Stock | 28.325 | 28.36 | 28.305 | 28.3575 | 1591328.0 |
| 2016-12-09 10:00:00 | AAPL | Stock | 28.3575 | 28.365 | 28.31 | 28.3525 | 2087376.0 |
| 2016-12-09 10:05:00 | AAPL | Stock | 28.3525 | 28.3525 | 28.305 | 28.325 | 1816908.0 |
| 2016-12-09 10:10:00 | AAPL | Stock | 28.3238 | 28.3675 | 28.29 | 28.36 | 1846136.0 |
| 2016-12-09 10:15:00 | AAPL | Stock | 28.3625 | 28.4202 | 28.3588 | 28.395 | 2556560.0 |
| 2016-12-09 10:20:00 | AAPL | Stock | 28.395 | 28.4725 | 28.3795 | 28.472 | 2361992.0 |
| 2016-12-09 10:25:00 | AAPL | Stock | 28.4715 | 28.5 | 28.455 | 28.4925 | 2896040.0 |
| 2016-12-09 10:30:00 | AAPL | Stock | 28.495 | 28.5425 | 28.47 | 28.5425 | 3780724.0 |
| 2016-12-09 10:35:00 | AAPL | Stock | 28.5425 | 28.6225 | 28.53 | 28.62 | 3840276.0 |
| 2016-12-09 10:40:00 | AAPL | Stock | 28.62 | 28.675 | 28.575 | 28.5785 | 3965980.0 |
| 2016-12-09 10:45:00 | AAPL | Stock | 28.5788 | 28.6225 | 28.5325 | 28.56 | 2511240.0 |
> showing 50 of 369,593 rows — these rows as CSV