PREVIEW / stock_5min / 2019-11-14
file: by_date/stock_5min/2019/2019-11-14.parquet size: 5.7 MB rows: 357,977 symbols: 2,497
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 |
|---|---|---|---|---|---|---|---|
| 2019-11-14 04:00:00 | AAPL | Stock | 66.0625 | 66.0625 | 66.0375 | 66.0625 | 4088.0 |
| 2019-11-14 04:05:00 | AAPL | Stock | 66.025 | 66.025 | 66.025 | 66.025 | 400.0 |
| 2019-11-14 04:10:00 | AAPL | Stock | 66.0125 | 66.0125 | 65.975 | 65.975 | 6056.0 |
| 2019-11-14 04:15:00 | AAPL | Stock | 65.975 | 65.975 | 65.975 | 65.975 | 2000.0 |
| 2019-11-14 04:25:00 | AAPL | Stock | 66.1375 | 66.1375 | 66.1375 | 66.1375 | 1880.0 |
| 2019-11-14 04:45:00 | AAPL | Stock | 66.075 | 66.075 | 66.075 | 66.075 | 400.0 |
| 2019-11-14 05:00:00 | AAPL | Stock | 66.075 | 66.115 | 66.075 | 66.115 | 4268.0 |
| 2019-11-14 05:05:00 | AAPL | Stock | 66.1375 | 66.15 | 66.1375 | 66.1375 | 1600.0 |
| 2019-11-14 06:00:00 | AAPL | Stock | 66.08 | 66.08 | 66.08 | 66.08 | 436.0 |
| 2019-11-14 06:05:00 | AAPL | Stock | 66.075 | 66.0775 | 66.0125 | 66.0125 | 5300.0 |
| 2019-11-14 06:10:00 | AAPL | Stock | 66.005 | 66.0175 | 66.005 | 66.0175 | 11600.0 |
| 2019-11-14 06:20:00 | AAPL | Stock | 66.0025 | 66.005 | 66.0025 | 66.005 | 952.0 |
| 2019-11-14 06:25:00 | AAPL | Stock | 66.005 | 66.005 | 66.005 | 66.005 | 800.0 |
| 2019-11-14 06:30:00 | AAPL | Stock | 66.0175 | 66.03 | 66.0175 | 66.03 | 1200.0 |
| 2019-11-14 06:40:00 | AAPL | Stock | 66.0275 | 66.0425 | 66.025 | 66.0425 | 1700.0 |
| 2019-11-14 06:45:00 | AAPL | Stock | 66.0425 | 66.0425 | 66.0425 | 66.0425 | 448.0 |
| 2019-11-14 06:55:00 | AAPL | Stock | 66.03 | 66.055 | 66.03 | 66.055 | 4944.0 |
| 2019-11-14 07:00:00 | AAPL | Stock | 66.085 | 66.0875 | 66.0425 | 66.0875 | 20832.0 |
| 2019-11-14 07:05:00 | AAPL | Stock | 66.0875 | 66.0875 | 66.0625 | 66.08 | 9980.0 |
| 2019-11-14 07:10:00 | AAPL | Stock | 66.075 | 66.075 | 66.0625 | 66.0625 | 4724.0 |
| 2019-11-14 07:15:00 | AAPL | Stock | 66.0625 | 66.0625 | 66.0625 | 66.0625 | 2540.0 |
| 2019-11-14 07:20:00 | AAPL | Stock | 66.0525 | 66.0525 | 66.0525 | 66.0525 | 1752.0 |
| 2019-11-14 07:25:00 | AAPL | Stock | 66.05 | 66.05 | 66.05 | 66.05 | 912.0 |
| 2019-11-14 07:30:00 | AAPL | Stock | 66.0625 | 66.0675 | 66.025 | 66.0625 | 24616.0 |
| 2019-11-14 07:35:00 | AAPL | Stock | 66.0325 | 66.0325 | 66.0125 | 66.0125 | 8392.0 |
| 2019-11-14 07:40:00 | AAPL | Stock | 66.0125 | 66.0125 | 65.7625 | 65.825 | 214448.0 |
| 2019-11-14 07:45:00 | AAPL | Stock | 65.805 | 65.89 | 65.8025 | 65.8425 | 59772.0 |
| 2019-11-14 07:50:00 | AAPL | Stock | 65.8375 | 65.845 | 65.715 | 65.75 | 91776.0 |
| 2019-11-14 07:55:00 | AAPL | Stock | 65.745 | 65.75 | 65.6875 | 65.7125 | 61428.0 |
| 2019-11-14 08:00:00 | AAPL | Stock | 66.0875 | 66.0875 | 65.6875 | 65.7375 | 157412.0 |
| 2019-11-14 08:05:00 | AAPL | Stock | 65.725 | 65.7375 | 65.7125 | 65.72 | 19664.0 |
| 2019-11-14 08:10:00 | AAPL | Stock | 65.7375 | 65.7575 | 65.7125 | 65.7425 | 59864.0 |
| 2019-11-14 08:15:00 | AAPL | Stock | 65.7425 | 65.765 | 65.725 | 65.729 | 55552.0 |
| 2019-11-14 08:20:00 | AAPL | Stock | 65.76 | 65.77 | 65.7 | 65.7 | 58228.0 |
| 2019-11-14 08:25:00 | AAPL | Stock | 65.7225 | 65.74 | 65.655 | 65.7225 | 145132.0 |
| 2019-11-14 08:30:00 | AAPL | Stock | 65.7225 | 65.7425 | 65.7025 | 65.7425 | 30824.0 |
| 2019-11-14 08:35:00 | AAPL | Stock | 65.7425 | 65.7575 | 65.64 | 65.6525 | 82376.0 |
| 2019-11-14 08:40:00 | AAPL | Stock | 65.655 | 65.6625 | 65.615 | 65.6625 | 123332.0 |
| 2019-11-14 08:45:00 | AAPL | Stock | 65.65 | 65.7075 | 65.65 | 65.7075 | 32088.0 |
| 2019-11-14 08:50:00 | AAPL | Stock | 65.7075 | 65.7125 | 65.6875 | 65.7085 | 17764.0 |
| 2019-11-14 08:55:00 | AAPL | Stock | 65.7125 | 65.8 | 65.7125 | 65.8 | 63908.0 |
| 2019-11-14 09:00:00 | AAPL | Stock | 65.7675 | 65.8375 | 65.765 | 65.8 | 41040.0 |
| 2019-11-14 09:05:00 | AAPL | Stock | 65.8 | 65.8 | 65.7525 | 65.765 | 55488.0 |
| 2019-11-14 09:10:00 | AAPL | Stock | 65.7575 | 65.7875 | 65.7525 | 65.7875 | 20368.0 |
| 2019-11-14 09:15:00 | AAPL | Stock | 65.8 | 65.815 | 65.79 | 65.8 | 27180.0 |
| 2019-11-14 09:20:00 | AAPL | Stock | 65.8125 | 65.825 | 65.78 | 65.78 | 53532.0 |
| 2019-11-14 09:25:00 | AAPL | Stock | 65.765 | 65.9875 | 65.765 | 65.975 | 345920.0 |
| 2019-11-14 09:30:00 | AAPL | Stock | 65.97 | 66.0625 | 65.88 | 66.0052 | 4878872.0 |
| 2019-11-14 09:35:00 | AAPL | Stock | 66.005 | 66.185 | 66.0025 | 66.0755 | 2297240.0 |
| 2019-11-14 09:40:00 | AAPL | Stock | 66.0812 | 66.1155 | 65.9525 | 65.955 | 2124992.0 |
> showing 50 of 357,977 rows — these rows as CSV