PREVIEW / stock_5min / 2019-11-19
file: by_date/stock_5min/2019/2019-11-19.parquet size: 5.8 MB rows: 369,293 symbols: 2,511
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-19 04:00:00 | AAPL | Stock | 67.0 | 67.0 | 67.0 | 67.0 | 4000.0 |
| 2019-11-19 04:05:00 | AAPL | Stock | 66.9875 | 66.9875 | 66.9875 | 66.9875 | 956.0 |
| 2019-11-19 04:10:00 | AAPL | Stock | 67.0 | 67.0075 | 66.95 | 66.95 | 2936.0 |
| 2019-11-19 04:25:00 | AAPL | Stock | 66.985 | 66.985 | 66.985 | 66.985 | 400.0 |
| 2019-11-19 04:35:00 | AAPL | Stock | 66.9975 | 67.0 | 66.9975 | 67.0 | 4000.0 |
| 2019-11-19 04:40:00 | AAPL | Stock | 67.0 | 67.0075 | 67.0 | 67.0075 | 6432.0 |
| 2019-11-19 04:50:00 | AAPL | Stock | 67.0225 | 67.08 | 67.0225 | 67.08 | 10476.0 |
| 2019-11-19 04:55:00 | AAPL | Stock | 67.0725 | 67.075 | 67.0725 | 67.075 | 5208.0 |
| 2019-11-19 05:00:00 | AAPL | Stock | 67.06 | 67.06 | 67.06 | 67.06 | 1200.0 |
| 2019-11-19 05:15:00 | AAPL | Stock | 67.06 | 67.0625 | 67.06 | 67.0625 | 4376.0 |
| 2019-11-19 05:20:00 | AAPL | Stock | 67.06 | 67.06 | 67.06 | 67.06 | 400.0 |
| 2019-11-19 05:25:00 | AAPL | Stock | 67.0375 | 67.05 | 67.0375 | 67.05 | 800.0 |
| 2019-11-19 05:30:00 | AAPL | Stock | 67.065 | 67.075 | 67.065 | 67.075 | 20780.0 |
| 2019-11-19 05:45:00 | AAPL | Stock | 67.1 | 67.1 | 67.1 | 67.1 | 800.0 |
| 2019-11-19 05:50:00 | AAPL | Stock | 67.075 | 67.0875 | 67.0525 | 67.0875 | 18448.0 |
| 2019-11-19 06:00:00 | AAPL | Stock | 67.0525 | 67.085 | 67.0525 | 67.085 | 800.0 |
| 2019-11-19 06:10:00 | AAPL | Stock | 67.125 | 67.14 | 67.1125 | 67.14 | 17320.0 |
| 2019-11-19 06:15:00 | AAPL | Stock | 67.1325 | 67.1325 | 67.1325 | 67.1325 | 11916.0 |
| 2019-11-19 06:20:00 | AAPL | Stock | 67.1 | 67.1 | 67.1 | 67.1 | 1240.0 |
| 2019-11-19 06:25:00 | AAPL | Stock | 67.1 | 67.105 | 67.1 | 67.105 | 7700.0 |
| 2019-11-19 06:30:00 | AAPL | Stock | 67.1225 | 67.14 | 67.1225 | 67.14 | 1772.0 |
| 2019-11-19 06:35:00 | AAPL | Stock | 67.1 | 67.125 | 67.1 | 67.125 | 3516.0 |
| 2019-11-19 06:40:00 | AAPL | Stock | 67.125 | 67.125 | 67.1125 | 67.125 | 1600.0 |
| 2019-11-19 06:45:00 | AAPL | Stock | 67.125 | 67.125 | 67.0575 | 67.0575 | 6000.0 |
| 2019-11-19 06:50:00 | AAPL | Stock | 67.0975 | 67.1125 | 67.0975 | 67.1125 | 4400.0 |
| 2019-11-19 06:55:00 | AAPL | Stock | 67.0825 | 67.0825 | 67.0825 | 67.0825 | 648.0 |
| 2019-11-19 07:00:00 | AAPL | Stock | 67.0825 | 67.12 | 67.025 | 67.05 | 57532.0 |
| 2019-11-19 07:05:00 | AAPL | Stock | 67.05 | 67.0525 | 67.0 | 67.0 | 18288.0 |
| 2019-11-19 07:10:00 | AAPL | Stock | 67.0075 | 67.025 | 66.98 | 67.0 | 36364.0 |
| 2019-11-19 07:15:00 | AAPL | Stock | 67.0 | 67.025 | 67.0 | 67.0125 | 6232.0 |
| 2019-11-19 07:20:00 | AAPL | Stock | 67.0425 | 67.05 | 67.0225 | 67.0225 | 8000.0 |
| 2019-11-19 07:25:00 | AAPL | Stock | 67.005 | 67.005 | 67.0025 | 67.0025 | 1612.0 |
| 2019-11-19 07:30:00 | AAPL | Stock | 67.0025 | 67.0025 | 66.995 | 67.0 | 8096.0 |
| 2019-11-19 07:35:00 | AAPL | Stock | 67.015 | 67.045 | 67.015 | 67.045 | 5332.0 |
| 2019-11-19 07:40:00 | AAPL | Stock | 67.0375 | 67.0375 | 67.025 | 67.025 | 800.0 |
| 2019-11-19 07:45:00 | AAPL | Stock | 67.0325 | 67.0325 | 67.025 | 67.025 | 1896.0 |
| 2019-11-19 07:50:00 | AAPL | Stock | 67.0325 | 67.0375 | 67.025 | 67.0375 | 4452.0 |
| 2019-11-19 07:55:00 | AAPL | Stock | 67.0375 | 67.055 | 67.0175 | 67.0175 | 9400.0 |
| 2019-11-19 08:00:00 | AAPL | Stock | 67.05 | 67.1112 | 66.9625 | 67.029 | 188820.0 |
| 2019-11-19 08:05:00 | AAPL | Stock | 67.0275 | 67.0325 | 67.0275 | 67.0325 | 1588.0 |
| 2019-11-19 08:10:00 | AAPL | Stock | 67.0375 | 67.04 | 67.035 | 67.035 | 20108.0 |
| 2019-11-19 08:15:00 | AAPL | Stock | 67.035 | 67.0725 | 67.025 | 67.05 | 16856.0 |
| 2019-11-19 08:20:00 | AAPL | Stock | 67.05 | 67.05 | 67.0125 | 67.0125 | 15224.0 |
| 2019-11-19 08:25:00 | AAPL | Stock | 67.0125 | 67.0375 | 67.0075 | 67.0375 | 18588.0 |
| 2019-11-19 08:30:00 | AAPL | Stock | 67.015 | 67.025 | 67.0025 | 67.0225 | 19900.0 |
| 2019-11-19 08:35:00 | AAPL | Stock | 67.0225 | 67.0275 | 66.9875 | 66.9975 | 14220.0 |
| 2019-11-19 08:40:00 | AAPL | Stock | 66.9775 | 66.9825 | 66.9375 | 66.94 | 42420.0 |
| 2019-11-19 08:45:00 | AAPL | Stock | 66.965 | 66.975 | 66.94 | 66.975 | 12904.0 |
| 2019-11-19 08:50:00 | AAPL | Stock | 66.975 | 66.9825 | 66.9625 | 66.9625 | 15152.0 |
| 2019-11-19 08:55:00 | AAPL | Stock | 66.975 | 66.98 | 66.9625 | 66.9748 | 11252.0 |
> showing 50 of 369,293 rows — these rows as CSV