PREVIEW / stock_5min / 2020-04-16
file: by_date/stock_5min/2020/2020-04-16.parquet size: 6.5 MB rows: 415,802 symbols: 2,389
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 |
|---|---|---|---|---|---|---|---|
| 2020-04-16 04:00:00 | AAPL | Stock | 71.9175 | 72.14 | 71.9175 | 72.125 | 16288.0 |
| 2020-04-16 04:05:00 | AAPL | Stock | 72.015 | 72.13 | 72.015 | 72.125 | 4264.0 |
| 2020-04-16 04:10:00 | AAPL | Stock | 72.125 | 72.1425 | 72.125 | 72.14 | 4716.0 |
| 2020-04-16 04:15:00 | AAPL | Stock | 72.1175 | 72.14 | 72.1175 | 72.13 | 4576.0 |
| 2020-04-16 04:20:00 | AAPL | Stock | 72.055 | 72.0875 | 72.0475 | 72.0875 | 4016.0 |
| 2020-04-16 04:25:00 | AAPL | Stock | 72.125 | 72.125 | 72.0325 | 72.125 | 3180.0 |
| 2020-04-16 04:30:00 | AAPL | Stock | 72.0875 | 72.115 | 72.0525 | 72.115 | 2624.0 |
| 2020-04-16 04:35:00 | AAPL | Stock | 72.125 | 72.135 | 72.125 | 72.125 | 2000.0 |
| 2020-04-16 04:40:00 | AAPL | Stock | 72.1725 | 72.1725 | 72.15 | 72.15 | 1528.0 |
| 2020-04-16 04:45:00 | AAPL | Stock | 72.17 | 72.17 | 72.1375 | 72.1375 | 6048.0 |
| 2020-04-16 04:50:00 | AAPL | Stock | 72.0925 | 72.0925 | 72.0925 | 72.0925 | 400.0 |
| 2020-04-16 04:55:00 | AAPL | Stock | 72.075 | 72.11 | 72.075 | 72.11 | 824.0 |
| 2020-04-16 05:00:00 | AAPL | Stock | 71.89 | 71.9775 | 71.89 | 71.9775 | 800.0 |
| 2020-04-16 05:05:00 | AAPL | Stock | 71.85 | 71.8825 | 71.85 | 71.8825 | 800.0 |
| 2020-04-16 05:10:00 | AAPL | Stock | 72.0075 | 72.0075 | 72.0075 | 72.0075 | 480.0 |
| 2020-04-16 05:15:00 | AAPL | Stock | 72.045 | 72.045 | 72.045 | 72.045 | 400.0 |
| 2020-04-16 05:20:00 | AAPL | Stock | 71.975 | 71.975 | 71.95 | 71.95 | 2400.0 |
| 2020-04-16 05:30:00 | AAPL | Stock | 71.9425 | 72.0025 | 71.9425 | 72.0025 | 4000.0 |
| 2020-04-16 05:35:00 | AAPL | Stock | 72.0475 | 72.0475 | 72.0 | 72.0 | 2292.0 |
| 2020-04-16 05:45:00 | AAPL | Stock | 72.025 | 72.025 | 72.025 | 72.025 | 400.0 |
| 2020-04-16 06:00:00 | AAPL | Stock | 72.025 | 72.11 | 72.025 | 72.055 | 4900.0 |
| 2020-04-16 06:05:00 | AAPL | Stock | 72.005 | 72.005 | 71.9525 | 71.9525 | 1964.0 |
| 2020-04-16 06:10:00 | AAPL | Stock | 72.0 | 72.0375 | 72.0 | 72.0375 | 1164.0 |
| 2020-04-16 06:20:00 | AAPL | Stock | 72.0375 | 72.05 | 72.0 | 72.0 | 4712.0 |
| 2020-04-16 06:25:00 | AAPL | Stock | 72.0625 | 72.2075 | 72.0625 | 72.2075 | 924.0 |
| 2020-04-16 06:30:00 | AAPL | Stock | 72.2 | 72.2 | 72.2 | 72.2 | 1204.0 |
| 2020-04-16 06:35:00 | AAPL | Stock | 72.22 | 72.22 | 72.155 | 72.155 | 1392.0 |
| 2020-04-16 06:40:00 | AAPL | Stock | 72.22 | 72.2525 | 72.22 | 72.22 | 19896.0 |
| 2020-04-16 06:45:00 | AAPL | Stock | 72.1575 | 72.1575 | 72.1575 | 72.1575 | 400.0 |
| 2020-04-16 06:50:00 | AAPL | Stock | 72.16 | 72.16 | 72.1425 | 72.1425 | 1868.0 |
| 2020-04-16 06:55:00 | AAPL | Stock | 72.165 | 72.175 | 72.0625 | 72.15 | 4688.0 |
| 2020-04-16 07:00:00 | AAPL | Stock | 72.0875 | 72.125 | 71.925 | 71.975 | 36712.0 |
| 2020-04-16 07:05:00 | AAPL | Stock | 71.9425 | 72.0 | 71.925 | 71.97 | 15704.0 |
| 2020-04-16 07:10:00 | AAPL | Stock | 71.995 | 72.0125 | 71.95 | 71.95 | 17084.0 |
| 2020-04-16 07:15:00 | AAPL | Stock | 71.99 | 71.99 | 71.9175 | 71.9175 | 16588.0 |
| 2020-04-16 07:20:00 | AAPL | Stock | 71.925 | 71.9375 | 71.86 | 71.86 | 25544.0 |
| 2020-04-16 07:25:00 | AAPL | Stock | 71.8975 | 71.9375 | 71.865 | 71.8775 | 20956.0 |
| 2020-04-16 07:30:00 | AAPL | Stock | 71.9025 | 71.9175 | 71.695 | 71.7 | 43456.0 |
| 2020-04-16 07:35:00 | AAPL | Stock | 71.745 | 71.795 | 71.6875 | 71.7425 | 18048.0 |
| 2020-04-16 07:40:00 | AAPL | Stock | 71.7 | 71.7475 | 71.6875 | 71.7125 | 22612.0 |
| 2020-04-16 07:45:00 | AAPL | Stock | 71.69 | 71.7125 | 71.6725 | 71.6875 | 23872.0 |
| 2020-04-16 07:50:00 | AAPL | Stock | 71.6875 | 71.7975 | 71.67 | 71.7625 | 16876.0 |
| 2020-04-16 07:55:00 | AAPL | Stock | 71.7625 | 71.7975 | 71.735 | 71.7375 | 22624.0 |
| 2020-04-16 08:00:00 | AAPL | Stock | 71.9375 | 72.05 | 71.285 | 71.795 | 145296.0 |
| 2020-04-16 08:05:00 | AAPL | Stock | 71.7925 | 71.8625 | 71.75 | 71.8 | 32800.0 |
| 2020-04-16 08:10:00 | AAPL | Stock | 71.7975 | 71.7975 | 71.725 | 71.7775 | 30120.0 |
| 2020-04-16 08:15:00 | AAPL | Stock | 71.7525 | 71.7675 | 71.64 | 71.64 | 44412.0 |
| 2020-04-16 08:20:00 | AAPL | Stock | 71.65 | 71.85 | 71.64 | 71.85 | 94080.0 |
| 2020-04-16 08:25:00 | AAPL | Stock | 71.81 | 71.9525 | 71.7548 | 71.85 | 57852.0 |
| 2020-04-16 08:30:00 | AAPL | Stock | 71.84 | 72.2125 | 71.84 | 72.165 | 162832.0 |
> showing 50 of 415,802 rows — these rows as CSV