PREVIEW / stock_5min / 2018-10-08
file: by_date/stock_5min/2018/2018-10-08.parquet size: 5.7 MB rows: 356,635 symbols: 2,761
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-10-08 04:05:00 | AAPL | Stock | 55.9975 | 55.9975 | 55.805 | 55.805 | 2256.0 |
| 2018-10-08 04:30:00 | AAPL | Stock | 55.805 | 55.805 | 55.805 | 55.805 | 520.0 |
| 2018-10-08 04:35:00 | AAPL | Stock | 55.785 | 55.785 | 55.785 | 55.785 | 400.0 |
| 2018-10-08 04:40:00 | AAPL | Stock | 55.775 | 55.775 | 55.72 | 55.72 | 2000.0 |
| 2018-10-08 05:00:00 | AAPL | Stock | 55.75 | 55.75 | 55.75 | 55.75 | 1396.0 |
| 2018-10-08 05:40:00 | AAPL | Stock | 55.7775 | 55.8625 | 55.7775 | 55.8625 | 9308.0 |
| 2018-10-08 05:55:00 | AAPL | Stock | 55.9375 | 55.94 | 55.93 | 55.9375 | 10356.0 |
| 2018-10-08 06:00:00 | AAPL | Stock | 55.97 | 55.97 | 55.9 | 55.97 | 5224.0 |
| 2018-10-08 06:05:00 | AAPL | Stock | 55.97 | 55.97 | 55.97 | 55.97 | 1692.0 |
| 2018-10-08 06:15:00 | AAPL | Stock | 55.925 | 56.0 | 55.925 | 55.9975 | 10800.0 |
| 2018-10-08 06:20:00 | AAPL | Stock | 55.9125 | 55.9125 | 55.9125 | 55.9125 | 4000.0 |
| 2018-10-08 06:35:00 | AAPL | Stock | 55.9175 | 55.9175 | 55.8675 | 55.905 | 9464.0 |
| 2018-10-08 06:40:00 | AAPL | Stock | 55.9 | 55.9 | 55.8825 | 55.8825 | 1200.0 |
| 2018-10-08 06:45:00 | AAPL | Stock | 55.9475 | 55.9475 | 55.9475 | 55.9475 | 400.0 |
| 2018-10-08 07:00:00 | AAPL | Stock | 55.945 | 55.9575 | 55.8925 | 55.8925 | 36836.0 |
| 2018-10-08 07:05:00 | AAPL | Stock | 55.9 | 55.9 | 55.8275 | 55.85 | 10148.0 |
| 2018-10-08 07:10:00 | AAPL | Stock | 55.87 | 55.8925 | 55.8525 | 55.875 | 7156.0 |
| 2018-10-08 07:15:00 | AAPL | Stock | 55.875 | 55.925 | 55.85 | 55.9125 | 19960.0 |
| 2018-10-08 07:20:00 | AAPL | Stock | 55.9 | 55.9975 | 55.9 | 55.945 | 52116.0 |
| 2018-10-08 07:25:00 | AAPL | Stock | 55.9475 | 56.1875 | 55.9475 | 56.125 | 86800.0 |
| 2018-10-08 07:30:00 | AAPL | Stock | 56.13 | 56.1725 | 56.1 | 56.135 | 39528.0 |
| 2018-10-08 07:35:00 | AAPL | Stock | 56.125 | 56.125 | 56.0525 | 56.055 | 15244.0 |
| 2018-10-08 07:40:00 | AAPL | Stock | 56.0625 | 56.0625 | 56.03 | 56.06 | 28144.0 |
| 2018-10-08 07:45:00 | AAPL | Stock | 56.0625 | 56.0625 | 56.045 | 56.055 | 11036.0 |
| 2018-10-08 07:50:00 | AAPL | Stock | 56.045 | 56.09 | 56.045 | 56.085 | 19720.0 |
| 2018-10-08 07:55:00 | AAPL | Stock | 56.09 | 56.1375 | 56.09 | 56.09 | 12048.0 |
| 2018-10-08 08:00:00 | AAPL | Stock | 55.9462 | 56.1425 | 55.8275 | 56.05 | 76744.0 |
| 2018-10-08 08:05:00 | AAPL | Stock | 56.07 | 56.0825 | 56.06 | 56.06 | 6244.0 |
| 2018-10-08 08:10:00 | AAPL | Stock | 56.065 | 56.0925 | 56.0625 | 56.075 | 13480.0 |
| 2018-10-08 08:15:00 | AAPL | Stock | 56.05 | 56.0625 | 56.05 | 56.0625 | 31164.0 |
| 2018-10-08 08:20:00 | AAPL | Stock | 56.0725 | 56.08 | 56.045 | 56.045 | 12896.0 |
| 2018-10-08 08:25:00 | AAPL | Stock | 56.045 | 56.0625 | 56.045 | 56.0625 | 40416.0 |
| 2018-10-08 08:30:00 | AAPL | Stock | 56.045 | 56.0475 | 56.0025 | 56.0075 | 18412.0 |
| 2018-10-08 08:35:00 | AAPL | Stock | 56.0075 | 56.025 | 56.0075 | 56.015 | 10588.0 |
| 2018-10-08 08:40:00 | AAPL | Stock | 56.035 | 56.04 | 55.935 | 55.935 | 49516.0 |
| 2018-10-08 08:45:00 | AAPL | Stock | 55.9525 | 55.955 | 55.9 | 55.955 | 21280.0 |
| 2018-10-08 08:50:00 | AAPL | Stock | 55.97 | 55.985 | 55.925 | 55.975 | 12668.0 |
| 2018-10-08 08:55:00 | AAPL | Stock | 55.975 | 55.9875 | 55.9275 | 55.9375 | 21232.0 |
| 2018-10-08 09:00:00 | AAPL | Stock | 55.9625 | 55.9625 | 55.9075 | 55.9075 | 23048.0 |
| 2018-10-08 09:05:00 | AAPL | Stock | 55.89 | 55.895 | 55.835 | 55.835 | 19204.0 |
| 2018-10-08 09:10:00 | AAPL | Stock | 55.835 | 55.85 | 55.8125 | 55.85 | 25536.0 |
| 2018-10-08 09:15:00 | AAPL | Stock | 55.835 | 55.8675 | 55.8125 | 55.8125 | 33764.0 |
| 2018-10-08 09:20:00 | AAPL | Stock | 55.8175 | 55.85 | 55.805 | 55.85 | 35064.0 |
| 2018-10-08 09:25:00 | AAPL | Stock | 55.875 | 55.875 | 55.515 | 55.6725 | 382448.0 |
| 2018-10-08 09:30:00 | AAPL | Stock | 55.64 | 55.64 | 55.255 | 55.5425 | 6606464.0 |
| 2018-10-08 09:35:00 | AAPL | Stock | 55.5425 | 55.7125 | 55.4425 | 55.57 | 2586440.0 |
| 2018-10-08 09:40:00 | AAPL | Stock | 55.5775 | 55.8375 | 55.48 | 55.77 | 2120896.0 |
| 2018-10-08 09:45:00 | AAPL | Stock | 55.7655 | 55.86 | 55.625 | 55.6375 | 1636876.0 |
| 2018-10-08 09:50:00 | AAPL | Stock | 55.6375 | 55.8375 | 55.6375 | 55.815 | 1651928.0 |
| 2018-10-08 09:55:00 | AAPL | Stock | 55.8125 | 55.82 | 55.69 | 55.71 | 1510492.0 |
> showing 50 of 356,635 rows — these rows as CSV