PREVIEW / stock_5min / 2019-01-04
file: by_date/stock_5min/2019/2019-01-04.parquet size: 5.7 MB rows: 366,565 symbols: 2,704
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-01-04 04:00:00 | AAPL | Stock | 35.95 | 36.0025 | 35.9475 | 35.9475 | 7584.0 |
| 2019-01-04 04:05:00 | AAPL | Stock | 35.9525 | 35.9525 | 35.9125 | 35.915 | 19548.0 |
| 2019-01-04 04:10:00 | AAPL | Stock | 35.9425 | 35.9975 | 35.9425 | 35.9975 | 8052.0 |
| 2019-01-04 04:15:00 | AAPL | Stock | 35.98 | 35.98 | 35.975 | 35.975 | 4088.0 |
| 2019-01-04 04:20:00 | AAPL | Stock | 35.95 | 35.95 | 35.9425 | 35.9475 | 3200.0 |
| 2019-01-04 04:25:00 | AAPL | Stock | 35.97 | 36.0025 | 35.97 | 36.0025 | 9056.0 |
| 2019-01-04 04:30:00 | AAPL | Stock | 36.0375 | 36.15 | 36.0375 | 36.1275 | 21300.0 |
| 2019-01-04 04:35:00 | AAPL | Stock | 36.13 | 36.1625 | 36.1225 | 36.1625 | 17504.0 |
| 2019-01-04 04:40:00 | AAPL | Stock | 36.105 | 36.105 | 36.0525 | 36.0525 | 30712.0 |
| 2019-01-04 04:45:00 | AAPL | Stock | 36.0525 | 36.0525 | 36.005 | 36.005 | 13884.0 |
| 2019-01-04 04:50:00 | AAPL | Stock | 36.04 | 36.04 | 35.95 | 35.97 | 19992.0 |
| 2019-01-04 04:55:00 | AAPL | Stock | 35.95 | 35.995 | 35.95 | 35.9575 | 18188.0 |
| 2019-01-04 05:00:00 | AAPL | Stock | 35.98 | 36.0 | 35.9675 | 35.9675 | 6468.0 |
| 2019-01-04 05:05:00 | AAPL | Stock | 35.9675 | 36.0 | 35.9625 | 36.0 | 26288.0 |
| 2019-01-04 05:10:00 | AAPL | Stock | 36.0375 | 36.0875 | 35.9875 | 36.0875 | 8724.0 |
| 2019-01-04 05:15:00 | AAPL | Stock | 36.0375 | 36.0375 | 36.0 | 36.0375 | 8084.0 |
| 2019-01-04 05:20:00 | AAPL | Stock | 36.0525 | 36.1 | 36.0525 | 36.1 | 4776.0 |
| 2019-01-04 05:25:00 | AAPL | Stock | 36.075 | 36.125 | 36.075 | 36.125 | 8028.0 |
| 2019-01-04 05:30:00 | AAPL | Stock | 36.1225 | 36.125 | 36.0775 | 36.0775 | 15068.0 |
| 2019-01-04 05:35:00 | AAPL | Stock | 36.0775 | 36.085 | 36.0725 | 36.0725 | 11408.0 |
| 2019-01-04 05:40:00 | AAPL | Stock | 36.1175 | 36.16 | 36.1175 | 36.1375 | 16816.0 |
| 2019-01-04 05:45:00 | AAPL | Stock | 36.14 | 36.1575 | 36.13 | 36.13 | 6448.0 |
| 2019-01-04 05:50:00 | AAPL | Stock | 36.1275 | 36.2 | 36.1275 | 36.2 | 13860.0 |
| 2019-01-04 05:55:00 | AAPL | Stock | 36.2025 | 36.2375 | 36.2 | 36.2025 | 12920.0 |
| 2019-01-04 06:00:00 | AAPL | Stock | 36.2025 | 36.2025 | 36.2 | 36.2 | 5004.0 |
| 2019-01-04 06:05:00 | AAPL | Stock | 36.175 | 36.195 | 36.175 | 36.1775 | 6428.0 |
| 2019-01-04 06:10:00 | AAPL | Stock | 36.2375 | 36.2375 | 36.2025 | 36.2025 | 2280.0 |
| 2019-01-04 06:15:00 | AAPL | Stock | 36.2025 | 36.205 | 36.2 | 36.205 | 4320.0 |
| 2019-01-04 06:20:00 | AAPL | Stock | 36.2225 | 36.235 | 36.2225 | 36.225 | 18808.0 |
| 2019-01-04 06:25:00 | AAPL | Stock | 36.2275 | 36.2275 | 36.175 | 36.175 | 25800.0 |
| 2019-01-04 06:30:00 | AAPL | Stock | 36.1875 | 36.1975 | 36.125 | 36.1475 | 16124.0 |
| 2019-01-04 06:35:00 | AAPL | Stock | 36.11 | 36.125 | 36.0925 | 36.125 | 10180.0 |
| 2019-01-04 06:40:00 | AAPL | Stock | 36.125 | 36.15 | 36.125 | 36.15 | 37100.0 |
| 2019-01-04 06:45:00 | AAPL | Stock | 36.175 | 36.1875 | 36.1025 | 36.1025 | 14032.0 |
| 2019-01-04 06:50:00 | AAPL | Stock | 36.1025 | 36.125 | 36.0525 | 36.0625 | 49408.0 |
| 2019-01-04 06:55:00 | AAPL | Stock | 36.0575 | 36.0825 | 36.0375 | 36.0825 | 22320.0 |
| 2019-01-04 07:00:00 | AAPL | Stock | 36.0525 | 36.1 | 36.015 | 36.0175 | 72384.0 |
| 2019-01-04 07:05:00 | AAPL | Stock | 36.015 | 36.0175 | 35.965 | 36.0075 | 134388.0 |
| 2019-01-04 07:10:00 | AAPL | Stock | 35.98 | 36.0075 | 35.975 | 35.9775 | 27788.0 |
| 2019-01-04 07:15:00 | AAPL | Stock | 35.9775 | 36.015 | 35.9775 | 36.005 | 50952.0 |
| 2019-01-04 07:20:00 | AAPL | Stock | 36.0375 | 36.0925 | 36.0075 | 36.0625 | 37632.0 |
| 2019-01-04 07:25:00 | AAPL | Stock | 36.065 | 36.115 | 36.045 | 36.0475 | 25084.0 |
| 2019-01-04 07:30:00 | AAPL | Stock | 36.0475 | 36.0875 | 36.0025 | 36.0025 | 22804.0 |
| 2019-01-04 07:35:00 | AAPL | Stock | 36.0 | 36.05 | 35.99 | 36.0475 | 23744.0 |
| 2019-01-04 07:40:00 | AAPL | Stock | 36.015 | 36.025 | 35.9925 | 36.0 | 31652.0 |
| 2019-01-04 07:45:00 | AAPL | Stock | 36.0325 | 36.05 | 36.0 | 36.0 | 30288.0 |
| 2019-01-04 07:50:00 | AAPL | Stock | 35.995 | 36.0375 | 35.995 | 36.005 | 20344.0 |
| 2019-01-04 07:55:00 | AAPL | Stock | 36.0125 | 36.0375 | 36.0 | 36.0375 | 34868.0 |
| 2019-01-04 08:00:00 | AAPL | Stock | 35.9775 | 36.1125 | 35.9775 | 36.0475 | 235472.0 |
| 2019-01-04 08:05:00 | AAPL | Stock | 36.0175 | 36.04 | 36.0125 | 36.04 | 58560.0 |
> showing 50 of 366,565 rows — these rows as CSV