PREVIEW / stock_5min / 2018-12-10
file: by_date/stock_5min/2018/2018-12-10.parquet size: 5.8 MB rows: 368,866 symbols: 2,731
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-12-10 04:00:00 | AAPL | Stock | 41.7 | 41.77 | 41.7 | 41.75 | 11560.0 |
| 2018-12-10 04:10:00 | AAPL | Stock | 41.815 | 41.825 | 41.7625 | 41.825 | 11908.0 |
| 2018-12-10 04:20:00 | AAPL | Stock | 41.8 | 41.825 | 41.8 | 41.825 | 3736.0 |
| 2018-12-10 04:25:00 | AAPL | Stock | 41.83 | 41.85 | 41.7525 | 41.7525 | 5940.0 |
| 2018-12-10 04:30:00 | AAPL | Stock | 41.7 | 41.7525 | 41.7 | 41.7525 | 17700.0 |
| 2018-12-10 04:35:00 | AAPL | Stock | 41.775 | 41.82 | 41.775 | 41.82 | 3520.0 |
| 2018-12-10 04:40:00 | AAPL | Stock | 41.775 | 41.775 | 41.775 | 41.775 | 4372.0 |
| 2018-12-10 04:45:00 | AAPL | Stock | 41.7925 | 41.7925 | 41.7925 | 41.7925 | 400.0 |
| 2018-12-10 04:50:00 | AAPL | Stock | 41.845 | 41.85 | 41.845 | 41.85 | 3508.0 |
| 2018-12-10 05:00:00 | AAPL | Stock | 41.825 | 41.825 | 41.825 | 41.825 | 3656.0 |
| 2018-12-10 05:10:00 | AAPL | Stock | 41.8475 | 41.8475 | 41.8475 | 41.8475 | 400.0 |
| 2018-12-10 05:30:00 | AAPL | Stock | 41.825 | 41.825 | 41.825 | 41.825 | 400.0 |
| 2018-12-10 05:45:00 | AAPL | Stock | 41.8 | 41.81 | 41.775 | 41.81 | 3200.0 |
| 2018-12-10 06:05:00 | AAPL | Stock | 41.8125 | 41.9375 | 41.8125 | 41.9375 | 11688.0 |
| 2018-12-10 06:10:00 | AAPL | Stock | 41.925 | 42.05 | 41.875 | 42.05 | 21580.0 |
| 2018-12-10 06:20:00 | AAPL | Stock | 41.9925 | 41.9925 | 41.9925 | 41.9925 | 800.0 |
| 2018-12-10 06:25:00 | AAPL | Stock | 41.95 | 41.965 | 41.95 | 41.965 | 1228.0 |
| 2018-12-10 06:30:00 | AAPL | Stock | 41.9875 | 41.9875 | 41.98 | 41.9875 | 2200.0 |
| 2018-12-10 06:35:00 | AAPL | Stock | 41.9875 | 41.9875 | 41.9875 | 41.9875 | 488.0 |
| 2018-12-10 06:40:00 | AAPL | Stock | 41.9875 | 41.9875 | 41.95 | 41.9775 | 10536.0 |
| 2018-12-10 06:45:00 | AAPL | Stock | 41.9775 | 41.9775 | 41.9725 | 41.9725 | 2400.0 |
| 2018-12-10 07:00:00 | AAPL | Stock | 41.9875 | 42.0125 | 41.95 | 42.0125 | 29272.0 |
| 2018-12-10 07:05:00 | AAPL | Stock | 42.0 | 42.0 | 41.9375 | 41.9575 | 15084.0 |
| 2018-12-10 07:10:00 | AAPL | Stock | 41.9375 | 41.9375 | 41.9075 | 41.9125 | 9344.0 |
| 2018-12-10 07:15:00 | AAPL | Stock | 41.8925 | 41.8925 | 41.8125 | 41.8375 | 17904.0 |
| 2018-12-10 07:20:00 | AAPL | Stock | 41.8725 | 41.8775 | 41.83 | 41.8725 | 21356.0 |
| 2018-12-10 07:25:00 | AAPL | Stock | 41.8725 | 41.875 | 41.8725 | 41.875 | 7008.0 |
| 2018-12-10 07:30:00 | AAPL | Stock | 41.865 | 41.865 | 41.8375 | 41.8625 | 16860.0 |
| 2018-12-10 07:35:00 | AAPL | Stock | 41.8625 | 41.925 | 41.8625 | 41.9 | 39364.0 |
| 2018-12-10 07:40:00 | AAPL | Stock | 41.9075 | 42.045 | 41.875 | 42.025 | 48916.0 |
| 2018-12-10 07:45:00 | AAPL | Stock | 42.0375 | 42.05 | 42.0 | 42.0 | 97512.0 |
| 2018-12-10 07:50:00 | AAPL | Stock | 42.025 | 42.0475 | 42.0 | 42.0475 | 24188.0 |
| 2018-12-10 07:55:00 | AAPL | Stock | 42.0475 | 42.055 | 41.99 | 41.99 | 51120.0 |
| 2018-12-10 08:00:00 | AAPL | Stock | 41.9775 | 42.05 | 41.816 | 42.035 | 164292.0 |
| 2018-12-10 08:05:00 | AAPL | Stock | 42.035 | 42.0675 | 42.03 | 42.05 | 83900.0 |
| 2018-12-10 08:10:00 | AAPL | Stock | 42.05 | 42.0625 | 42.0125 | 42.0125 | 115476.0 |
| 2018-12-10 08:15:00 | AAPL | Stock | 42.015 | 42.0525 | 42.0125 | 42.045 | 65332.0 |
| 2018-12-10 08:20:00 | AAPL | Stock | 42.0525 | 42.055 | 41.98 | 41.98 | 212080.0 |
| 2018-12-10 08:25:00 | AAPL | Stock | 41.975 | 41.9925 | 41.885 | 41.9125 | 50524.0 |
| 2018-12-10 08:30:00 | AAPL | Stock | 41.8875 | 41.95 | 41.8875 | 41.9125 | 73708.0 |
| 2018-12-10 08:35:00 | AAPL | Stock | 41.9075 | 41.9075 | 41.855 | 41.875 | 138724.0 |
| 2018-12-10 08:40:00 | AAPL | Stock | 41.875 | 41.875 | 41.7275 | 41.7525 | 155596.0 |
| 2018-12-10 08:45:00 | AAPL | Stock | 41.7325 | 41.7475 | 41.5875 | 41.5975 | 233316.0 |
| 2018-12-10 08:50:00 | AAPL | Stock | 41.5875 | 41.7125 | 41.58 | 41.6025 | 292908.0 |
| 2018-12-10 08:55:00 | AAPL | Stock | 41.6025 | 41.6875 | 41.57 | 41.625 | 218852.0 |
| 2018-12-10 09:00:00 | AAPL | Stock | 41.625 | 41.6875 | 41.25 | 41.445 | 1260552.0 |
| 2018-12-10 09:05:00 | AAPL | Stock | 41.44 | 41.5 | 41.2 | 41.2975 | 853172.0 |
| 2018-12-10 09:10:00 | AAPL | Stock | 41.265 | 41.3 | 41.125 | 41.2725 | 699484.0 |
| 2018-12-10 09:15:00 | AAPL | Stock | 41.27 | 41.31 | 41.1875 | 41.2875 | 359184.0 |
| 2018-12-10 09:20:00 | AAPL | Stock | 41.2925 | 41.31 | 41.22 | 41.285 | 395728.0 |
> showing 50 of 368,866 rows — these rows as CSV