PREVIEW / stock_5min / 2019-12-31
file: by_date/stock_5min/2019/2019-12-31.parquet size: 5.9 MB rows: 369,962 symbols: 2,494
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-12-31 04:05:00 | AAPL | Stock | 72.85 | 72.85 | 72.85 | 72.85 | 800.0 |
| 2019-12-31 04:45:00 | AAPL | Stock | 72.75 | 72.75 | 72.75 | 72.75 | 400.0 |
| 2019-12-31 05:25:00 | AAPL | Stock | 72.8225 | 72.8225 | 72.8225 | 72.8225 | 2000.0 |
| 2019-12-31 05:35:00 | AAPL | Stock | 72.8225 | 72.85 | 72.8225 | 72.85 | 1200.0 |
| 2019-12-31 06:15:00 | AAPL | Stock | 72.825 | 72.825 | 72.825 | 72.825 | 400.0 |
| 2019-12-31 06:55:00 | AAPL | Stock | 72.75 | 72.75 | 72.75 | 72.75 | 800.0 |
| 2019-12-31 07:00:00 | AAPL | Stock | 72.8125 | 72.825 | 72.7875 | 72.825 | 8628.0 |
| 2019-12-31 07:05:00 | AAPL | Stock | 72.8 | 72.8 | 72.7125 | 72.7125 | 22792.0 |
| 2019-12-31 07:10:00 | AAPL | Stock | 72.7125 | 72.73 | 72.7125 | 72.7125 | 10204.0 |
| 2019-12-31 07:15:00 | AAPL | Stock | 72.6775 | 72.6775 | 72.625 | 72.625 | 4592.0 |
| 2019-12-31 07:20:00 | AAPL | Stock | 72.705 | 72.705 | 72.6575 | 72.6575 | 12960.0 |
| 2019-12-31 07:25:00 | AAPL | Stock | 72.7 | 72.7 | 72.67 | 72.6775 | 2400.0 |
| 2019-12-31 07:30:00 | AAPL | Stock | 72.7 | 72.745 | 72.69 | 72.69 | 3480.0 |
| 2019-12-31 07:35:00 | AAPL | Stock | 72.7125 | 72.725 | 72.7 | 72.7 | 3560.0 |
| 2019-12-31 07:40:00 | AAPL | Stock | 72.7125 | 72.7125 | 72.69 | 72.69 | 8000.0 |
| 2019-12-31 07:45:00 | AAPL | Stock | 72.69 | 72.7 | 72.65 | 72.65 | 28916.0 |
| 2019-12-31 07:50:00 | AAPL | Stock | 72.65 | 72.65 | 72.6375 | 72.645 | 5956.0 |
| 2019-12-31 07:55:00 | AAPL | Stock | 72.675 | 72.675 | 72.675 | 72.675 | 3600.0 |
| 2019-12-31 08:00:00 | AAPL | Stock | 72.8 | 72.8125 | 72.6275 | 72.7125 | 89304.0 |
| 2019-12-31 08:05:00 | AAPL | Stock | 72.6925 | 72.725 | 72.69 | 72.725 | 8300.0 |
| 2019-12-31 08:10:00 | AAPL | Stock | 72.745 | 72.7475 | 72.725 | 72.725 | 4576.0 |
| 2019-12-31 08:15:00 | AAPL | Stock | 72.725 | 72.725 | 72.665 | 72.6675 | 8984.0 |
| 2019-12-31 08:20:00 | AAPL | Stock | 72.7 | 72.725 | 72.665 | 72.6775 | 5268.0 |
| 2019-12-31 08:25:00 | AAPL | Stock | 72.7 | 72.7125 | 72.6975 | 72.6975 | 8900.0 |
| 2019-12-31 08:30:00 | AAPL | Stock | 72.7125 | 72.7175 | 72.6625 | 72.6625 | 19668.0 |
| 2019-12-31 08:35:00 | AAPL | Stock | 72.6625 | 72.68 | 72.6325 | 72.68 | 8476.0 |
| 2019-12-31 08:40:00 | AAPL | Stock | 72.6625 | 72.675 | 72.65 | 72.675 | 5060.0 |
| 2019-12-31 08:45:00 | AAPL | Stock | 72.645 | 72.6475 | 72.5625 | 72.5975 | 21052.0 |
| 2019-12-31 08:50:00 | AAPL | Stock | 72.5975 | 72.6125 | 72.52 | 72.5575 | 46288.0 |
| 2019-12-31 08:55:00 | AAPL | Stock | 72.5625 | 72.6 | 72.5298 | 72.575 | 21560.0 |
| 2019-12-31 09:00:00 | AAPL | Stock | 72.575 | 72.5975 | 72.5325 | 72.5575 | 40568.0 |
| 2019-12-31 09:05:00 | AAPL | Stock | 72.5575 | 72.5725 | 72.5268 | 72.55 | 50196.0 |
| 2019-12-31 09:10:00 | AAPL | Stock | 72.5525 | 72.6125 | 72.5525 | 72.5675 | 14560.0 |
| 2019-12-31 09:15:00 | AAPL | Stock | 72.5625 | 72.5775 | 72.5325 | 72.5625 | 30940.0 |
| 2019-12-31 09:20:00 | AAPL | Stock | 72.595 | 72.61 | 72.5625 | 72.5875 | 64132.0 |
| 2019-12-31 09:25:00 | AAPL | Stock | 72.5825 | 72.61 | 72.4125 | 72.485 | 141552.0 |
| 2019-12-31 09:30:00 | AAPL | Stock | 72.4825 | 72.875 | 72.38 | 72.814 | 4038688.0 |
| 2019-12-31 09:35:00 | AAPL | Stock | 72.8125 | 73.22 | 72.8125 | 73.035 | 3038532.0 |
| 2019-12-31 09:40:00 | AAPL | Stock | 73.0325 | 73.1125 | 72.92 | 73.0325 | 1991044.0 |
| 2019-12-31 09:45:00 | AAPL | Stock | 73.0375 | 73.1175 | 72.975 | 73.079 | 1645020.0 |
| 2019-12-31 09:50:00 | AAPL | Stock | 73.075 | 73.0812 | 72.99 | 73.0012 | 1266932.0 |
| 2019-12-31 09:55:00 | AAPL | Stock | 73.0 | 73.0525 | 72.9675 | 73.04 | 1315560.0 |
| 2019-12-31 10:00:00 | AAPL | Stock | 73.045 | 73.075 | 72.77 | 72.79 | 1807140.0 |
| 2019-12-31 10:05:00 | AAPL | Stock | 72.79 | 72.87 | 72.67 | 72.85 | 1684432.0 |
| 2019-12-31 10:10:00 | AAPL | Stock | 72.8475 | 72.9575 | 72.8175 | 72.9575 | 1329828.0 |
| 2019-12-31 10:15:00 | AAPL | Stock | 72.9625 | 73.035 | 72.935 | 73.015 | 1262544.0 |
| 2019-12-31 10:20:00 | AAPL | Stock | 73.015 | 73.015 | 72.88 | 72.9718 | 996984.0 |
| 2019-12-31 10:25:00 | AAPL | Stock | 72.975 | 72.975 | 72.785 | 72.7975 | 867192.0 |
| 2019-12-31 10:30:00 | AAPL | Stock | 72.805 | 72.905 | 72.7878 | 72.855 | 995392.0 |
| 2019-12-31 10:35:00 | AAPL | Stock | 72.855 | 72.94 | 72.8325 | 72.8638 | 842276.0 |
> showing 50 of 369,962 rows — these rows as CSV