PREVIEW / stock_5min / 2019-10-04
file: by_date/stock_5min/2019/2019-10-04.parquet size: 5.4 MB rows: 343,553 symbols: 2,519
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-10-04 04:00:00 | AAPL | Stock | 55.675 | 55.8275 | 55.675 | 55.8275 | 16008.0 |
| 2019-10-04 04:05:00 | AAPL | Stock | 55.815 | 55.85 | 55.815 | 55.8275 | 7160.0 |
| 2019-10-04 04:10:00 | AAPL | Stock | 55.93 | 56.015 | 55.93 | 55.97 | 32808.0 |
| 2019-10-04 04:15:00 | AAPL | Stock | 56.01 | 56.01 | 55.985 | 55.985 | 1268.0 |
| 2019-10-04 04:20:00 | AAPL | Stock | 55.955 | 55.98 | 55.955 | 55.98 | 9672.0 |
| 2019-10-04 04:25:00 | AAPL | Stock | 55.9925 | 56.0025 | 55.9925 | 56.0025 | 13372.0 |
| 2019-10-04 04:30:00 | AAPL | Stock | 56.0 | 56.045 | 56.0 | 56.045 | 5228.0 |
| 2019-10-04 04:35:00 | AAPL | Stock | 56.05 | 56.065 | 56.05 | 56.065 | 10800.0 |
| 2019-10-04 04:40:00 | AAPL | Stock | 56.055 | 56.055 | 55.98 | 55.98 | 6796.0 |
| 2019-10-04 04:45:00 | AAPL | Stock | 55.975 | 55.9775 | 55.9725 | 55.9725 | 4288.0 |
| 2019-10-04 04:50:00 | AAPL | Stock | 56.025 | 56.1175 | 56.01 | 56.01 | 7896.0 |
| 2019-10-04 04:55:00 | AAPL | Stock | 56.0625 | 56.0625 | 56.0625 | 56.0625 | 400.0 |
| 2019-10-04 05:00:00 | AAPL | Stock | 56.0075 | 56.0075 | 56.0 | 56.0 | 16600.0 |
| 2019-10-04 05:10:00 | AAPL | Stock | 56.055 | 56.06 | 56.055 | 56.06 | 8068.0 |
| 2019-10-04 05:15:00 | AAPL | Stock | 56.0825 | 56.1 | 56.0825 | 56.0875 | 5048.0 |
| 2019-10-04 05:20:00 | AAPL | Stock | 56.0875 | 56.0875 | 56.06 | 56.06 | 14212.0 |
| 2019-10-04 05:25:00 | AAPL | Stock | 56.005 | 56.005 | 56.0025 | 56.0025 | 4956.0 |
| 2019-10-04 05:35:00 | AAPL | Stock | 56.0 | 56.0 | 55.96 | 55.96 | 46568.0 |
| 2019-10-04 05:40:00 | AAPL | Stock | 55.96 | 55.9625 | 55.96 | 55.9625 | 800.0 |
| 2019-10-04 05:45:00 | AAPL | Stock | 56.0425 | 56.1 | 55.75 | 55.9625 | 12844.0 |
| 2019-10-04 05:50:00 | AAPL | Stock | 55.92 | 55.92 | 55.8975 | 55.8975 | 5544.0 |
| 2019-10-04 05:55:00 | AAPL | Stock | 55.875 | 55.9125 | 55.875 | 55.88 | 14136.0 |
| 2019-10-04 06:00:00 | AAPL | Stock | 55.8875 | 56.0 | 55.8875 | 56.0 | 15244.0 |
| 2019-10-04 06:05:00 | AAPL | Stock | 55.99 | 56.025 | 55.99 | 56.025 | 6008.0 |
| 2019-10-04 06:10:00 | AAPL | Stock | 56.0 | 56.0 | 56.0 | 56.0 | 3992.0 |
| 2019-10-04 06:15:00 | AAPL | Stock | 56.0125 | 56.0175 | 56.0125 | 56.0175 | 2000.0 |
| 2019-10-04 06:20:00 | AAPL | Stock | 55.9575 | 55.9575 | 55.88 | 55.88 | 8492.0 |
| 2019-10-04 06:25:00 | AAPL | Stock | 55.8875 | 55.8875 | 55.875 | 55.875 | 2800.0 |
| 2019-10-04 06:30:00 | AAPL | Stock | 55.9375 | 55.9375 | 55.9375 | 55.9375 | 800.0 |
| 2019-10-04 06:35:00 | AAPL | Stock | 55.9375 | 55.9375 | 55.9025 | 55.9025 | 2000.0 |
| 2019-10-04 06:40:00 | AAPL | Stock | 55.8975 | 55.8975 | 55.8975 | 55.8975 | 2836.0 |
| 2019-10-04 06:45:00 | AAPL | Stock | 55.875 | 55.875 | 55.875 | 55.875 | 400.0 |
| 2019-10-04 06:50:00 | AAPL | Stock | 55.9175 | 55.99 | 55.8925 | 55.9275 | 9508.0 |
| 2019-10-04 06:55:00 | AAPL | Stock | 55.95 | 55.9525 | 55.895 | 55.9375 | 7600.0 |
| 2019-10-04 07:00:00 | AAPL | Stock | 55.88 | 55.9375 | 55.805 | 55.855 | 107632.0 |
| 2019-10-04 07:05:00 | AAPL | Stock | 55.855 | 55.8625 | 55.85 | 55.85 | 12820.0 |
| 2019-10-04 07:10:00 | AAPL | Stock | 55.86 | 55.8975 | 55.86 | 55.8725 | 26672.0 |
| 2019-10-04 07:15:00 | AAPL | Stock | 55.8625 | 55.97 | 55.8625 | 55.9675 | 100740.0 |
| 2019-10-04 07:20:00 | AAPL | Stock | 55.955 | 55.9875 | 55.95 | 55.9875 | 79836.0 |
| 2019-10-04 07:25:00 | AAPL | Stock | 55.975 | 56.0375 | 55.975 | 56.0 | 96888.0 |
| 2019-10-04 07:30:00 | AAPL | Stock | 55.99 | 56.0 | 55.97 | 56.0 | 24088.0 |
| 2019-10-04 07:35:00 | AAPL | Stock | 56.0 | 56.0275 | 56.0 | 56.025 | 26244.0 |
| 2019-10-04 07:40:00 | AAPL | Stock | 56.005 | 56.1 | 56.005 | 56.07 | 73568.0 |
| 2019-10-04 07:45:00 | AAPL | Stock | 56.08 | 56.1 | 56.035 | 56.0625 | 112096.0 |
| 2019-10-04 07:50:00 | AAPL | Stock | 56.085 | 56.0975 | 56.0525 | 56.055 | 41424.0 |
| 2019-10-04 07:55:00 | AAPL | Stock | 56.055 | 56.1075 | 56.055 | 56.085 | 12108.0 |
| 2019-10-04 08:00:00 | AAPL | Stock | 56.08 | 56.1 | 55.85 | 56.1 | 382412.0 |
| 2019-10-04 08:05:00 | AAPL | Stock | 56.095 | 56.1 | 56.0675 | 56.0875 | 67188.0 |
| 2019-10-04 08:10:00 | AAPL | Stock | 56.0875 | 56.1 | 56.08 | 56.0875 | 70680.0 |
| 2019-10-04 08:15:00 | AAPL | Stock | 56.0825 | 56.1025 | 56.065 | 56.0675 | 58420.0 |
> showing 50 of 343,553 rows — these rows as CSV