PREVIEW / stock_5min / 2020-06-11
file: by_date/stock_5min/2020/2020-06-11.parquet size: 7.3 MB rows: 462,634 symbols: 2,434
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-06-11 04:00:00 | AAPL | Stock | 87.235 | 87.235 | 86.875 | 87.0125 | 9384.0 |
| 2020-06-11 04:05:00 | AAPL | Stock | 87.12 | 87.2025 | 87.075 | 87.1325 | 10660.0 |
| 2020-06-11 04:10:00 | AAPL | Stock | 87.1325 | 87.1975 | 87.1325 | 87.1975 | 11848.0 |
| 2020-06-11 04:15:00 | AAPL | Stock | 87.2225 | 87.2225 | 87.175 | 87.175 | 1200.0 |
| 2020-06-11 04:20:00 | AAPL | Stock | 87.18 | 87.18 | 87.0325 | 87.0325 | 3872.0 |
| 2020-06-11 04:25:00 | AAPL | Stock | 87.0175 | 87.0175 | 86.875 | 86.875 | 25648.0 |
| 2020-06-11 04:30:00 | AAPL | Stock | 86.88 | 86.88 | 86.88 | 86.88 | 1084.0 |
| 2020-06-11 04:35:00 | AAPL | Stock | 87.015 | 87.0525 | 86.8625 | 86.8625 | 3492.0 |
| 2020-06-11 04:40:00 | AAPL | Stock | 86.8575 | 86.8575 | 86.765 | 86.85 | 1916.0 |
| 2020-06-11 04:45:00 | AAPL | Stock | 86.7625 | 86.8625 | 86.6025 | 86.75 | 9136.0 |
| 2020-06-11 04:50:00 | AAPL | Stock | 86.6625 | 86.695 | 86.6325 | 86.695 | 13348.0 |
| 2020-06-11 04:55:00 | AAPL | Stock | 86.75 | 86.7975 | 86.745 | 86.7975 | 6488.0 |
| 2020-06-11 05:00:00 | AAPL | Stock | 86.755 | 86.755 | 86.755 | 86.755 | 400.0 |
| 2020-06-11 05:05:00 | AAPL | Stock | 86.7475 | 86.8775 | 86.7475 | 86.8775 | 11928.0 |
| 2020-06-11 05:10:00 | AAPL | Stock | 86.9 | 86.99 | 86.9 | 86.99 | 1600.0 |
| 2020-06-11 05:15:00 | AAPL | Stock | 86.9375 | 87.0525 | 86.9375 | 87.03 | 3660.0 |
| 2020-06-11 05:20:00 | AAPL | Stock | 87.125 | 87.125 | 87.0775 | 87.1175 | 2988.0 |
| 2020-06-11 05:25:00 | AAPL | Stock | 87.1025 | 87.1875 | 87.1025 | 87.1875 | 2556.0 |
| 2020-06-11 05:30:00 | AAPL | Stock | 87.1875 | 87.3 | 87.1875 | 87.3 | 2908.0 |
| 2020-06-11 05:35:00 | AAPL | Stock | 87.25 | 87.25 | 87.25 | 87.25 | 400.0 |
| 2020-06-11 05:40:00 | AAPL | Stock | 87.1325 | 87.175 | 87.1325 | 87.175 | 3600.0 |
| 2020-06-11 05:45:00 | AAPL | Stock | 87.135 | 87.135 | 87.135 | 87.135 | 400.0 |
| 2020-06-11 05:50:00 | AAPL | Stock | 87.125 | 87.125 | 87.1125 | 87.1125 | 1200.0 |
| 2020-06-11 05:55:00 | AAPL | Stock | 87.2325 | 87.2775 | 87.2325 | 87.275 | 3212.0 |
| 2020-06-11 06:00:00 | AAPL | Stock | 87.2675 | 87.2675 | 87.2675 | 87.2675 | 400.0 |
| 2020-06-11 06:10:00 | AAPL | Stock | 87.17 | 87.225 | 87.12 | 87.12 | 7436.0 |
| 2020-06-11 06:15:00 | AAPL | Stock | 87.1925 | 87.1925 | 87.115 | 87.115 | 800.0 |
| 2020-06-11 06:20:00 | AAPL | Stock | 87.1775 | 87.1775 | 87.12 | 87.12 | 6576.0 |
| 2020-06-11 06:25:00 | AAPL | Stock | 87.1925 | 87.2225 | 87.1875 | 87.2225 | 3744.0 |
| 2020-06-11 06:30:00 | AAPL | Stock | 87.1975 | 87.1975 | 87.175 | 87.175 | 2000.0 |
| 2020-06-11 06:35:00 | AAPL | Stock | 87.1825 | 87.1825 | 87.0675 | 87.0675 | 6184.0 |
| 2020-06-11 06:45:00 | AAPL | Stock | 87.065 | 87.1175 | 87.025 | 87.08 | 2820.0 |
| 2020-06-11 06:50:00 | AAPL | Stock | 87.175 | 87.175 | 87.175 | 87.175 | 1920.0 |
| 2020-06-11 06:55:00 | AAPL | Stock | 87.15 | 87.195 | 87.0625 | 87.08 | 3448.0 |
| 2020-06-11 07:00:00 | AAPL | Stock | 87.0575 | 87.145 | 87.01 | 87.06 | 69768.0 |
| 2020-06-11 07:05:00 | AAPL | Stock | 87.055 | 87.1 | 86.95 | 86.95 | 63724.0 |
| 2020-06-11 07:10:00 | AAPL | Stock | 86.95 | 86.995 | 86.885 | 86.925 | 55484.0 |
| 2020-06-11 07:15:00 | AAPL | Stock | 86.9225 | 86.925 | 86.8125 | 86.9 | 97880.0 |
| 2020-06-11 07:20:00 | AAPL | Stock | 86.8775 | 86.9375 | 86.8125 | 86.9225 | 29496.0 |
| 2020-06-11 07:25:00 | AAPL | Stock | 86.9125 | 87.12 | 86.875 | 87.1 | 52236.0 |
| 2020-06-11 07:30:00 | AAPL | Stock | 87.025 | 87.1875 | 87.02 | 87.125 | 52432.0 |
| 2020-06-11 07:35:00 | AAPL | Stock | 87.1225 | 87.225 | 87.095 | 87.1275 | 37068.0 |
| 2020-06-11 07:40:00 | AAPL | Stock | 87.15 | 87.1875 | 87.12 | 87.12 | 10436.0 |
| 2020-06-11 07:45:00 | AAPL | Stock | 87.115 | 87.125 | 87.0125 | 87.0125 | 40128.0 |
| 2020-06-11 07:50:00 | AAPL | Stock | 87.0125 | 87.0125 | 86.7825 | 86.8125 | 47928.0 |
| 2020-06-11 07:55:00 | AAPL | Stock | 86.81 | 87.065 | 86.7175 | 86.8925 | 106884.0 |
| 2020-06-11 08:00:00 | AAPL | Stock | 86.9235 | 87.225 | 86.7488 | 86.9425 | 212000.0 |
| 2020-06-11 08:05:00 | AAPL | Stock | 86.925 | 87.0325 | 86.88 | 86.8825 | 27264.0 |
| 2020-06-11 08:10:00 | AAPL | Stock | 86.96 | 87.0 | 86.765 | 86.925 | 70360.0 |
| 2020-06-11 08:15:00 | AAPL | Stock | 86.9125 | 86.945 | 86.75 | 86.75 | 66404.0 |
> showing 50 of 462,634 rows — these rows as CSV