PREVIEW / stock_5min / 2021-06-28
file: by_date/stock_5min/2021/2021-06-28.parquet size: 7.8 MB rows: 482,093 symbols: 2,973
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 |
|---|---|---|---|---|---|---|---|
| 2021-06-28 04:00:00 | AAPL | Stock | 133.11 | 133.41 | 133.11 | 133.41 | 2231.0 |
| 2021-06-28 04:05:00 | AAPL | Stock | 133.41 | 133.48 | 133.41 | 133.48 | 556.0 |
| 2021-06-28 04:10:00 | AAPL | Stock | 133.4 | 133.47 | 133.37 | 133.47 | 754.0 |
| 2021-06-28 04:15:00 | AAPL | Stock | 133.38 | 133.48 | 133.38 | 133.48 | 244.0 |
| 2021-06-28 04:20:00 | AAPL | Stock | 133.4 | 133.4 | 133.38 | 133.38 | 800.0 |
| 2021-06-28 04:25:00 | AAPL | Stock | 133.26 | 133.26 | 133.26 | 133.26 | 100.0 |
| 2021-06-28 04:30:00 | AAPL | Stock | 133.1 | 133.1 | 133.02 | 133.02 | 455.0 |
| 2021-06-28 04:35:00 | AAPL | Stock | 133.05 | 133.05 | 133.05 | 133.05 | 200.0 |
| 2021-06-28 04:40:00 | AAPL | Stock | 133.06 | 133.06 | 133.02 | 133.02 | 840.0 |
| 2021-06-28 04:50:00 | AAPL | Stock | 133.08 | 133.12 | 133.07 | 133.12 | 1097.0 |
| 2021-06-28 04:55:00 | AAPL | Stock | 133.15 | 133.19 | 133.15 | 133.19 | 570.0 |
| 2021-06-28 05:10:00 | AAPL | Stock | 133.14 | 133.15 | 133.12 | 133.14 | 1020.0 |
| 2021-06-28 05:15:00 | AAPL | Stock | 133.15 | 133.15 | 133.15 | 133.15 | 320.0 |
| 2021-06-28 05:20:00 | AAPL | Stock | 133.16 | 133.16 | 133.1 | 133.1 | 556.0 |
| 2021-06-28 05:25:00 | AAPL | Stock | 133.15 | 133.15 | 133.11 | 133.11 | 300.0 |
| 2021-06-28 05:45:00 | AAPL | Stock | 133.15 | 133.15 | 133.15 | 133.15 | 100.0 |
| 2021-06-28 06:00:00 | AAPL | Stock | 133.11 | 133.11 | 133.11 | 133.11 | 103.0 |
| 2021-06-28 06:05:00 | AAPL | Stock | 133.11 | 133.11 | 133.11 | 133.11 | 769.0 |
| 2021-06-28 06:10:00 | AAPL | Stock | 133.1 | 133.1 | 133.06 | 133.06 | 1594.0 |
| 2021-06-28 06:15:00 | AAPL | Stock | 133.06 | 133.06 | 133.02 | 133.02 | 1322.0 |
| 2021-06-28 06:20:00 | AAPL | Stock | 133.01 | 133.01 | 133.01 | 133.01 | 749.0 |
| 2021-06-28 06:55:00 | AAPL | Stock | 133.07 | 133.07 | 133.07 | 133.07 | 100.0 |
| 2021-06-28 07:00:00 | AAPL | Stock | 133.08 | 133.08 | 133.0 | 133.06 | 3353.0 |
| 2021-06-28 07:05:00 | AAPL | Stock | 133.08 | 133.15 | 133.06 | 133.06 | 2962.0 |
| 2021-06-28 07:10:00 | AAPL | Stock | 133.03 | 133.14 | 133.03 | 133.11 | 15302.0 |
| 2021-06-28 07:15:00 | AAPL | Stock | 133.09 | 133.12 | 133.09 | 133.11 | 5061.0 |
| 2021-06-28 07:20:00 | AAPL | Stock | 133.12 | 133.3 | 133.12 | 133.16 | 11632.0 |
| 2021-06-28 07:25:00 | AAPL | Stock | 133.16 | 133.18 | 133.11 | 133.12 | 3138.0 |
| 2021-06-28 07:30:00 | AAPL | Stock | 133.12 | 133.12 | 133.08 | 133.1 | 12626.0 |
| 2021-06-28 07:35:00 | AAPL | Stock | 133.09 | 133.1 | 133.05 | 133.09 | 8296.0 |
| 2021-06-28 07:40:00 | AAPL | Stock | 133.1 | 133.1 | 133.0 | 133.07 | 10081.0 |
| 2021-06-28 07:45:00 | AAPL | Stock | 133.11 | 133.13 | 133.09 | 133.13 | 6021.0 |
| 2021-06-28 07:50:00 | AAPL | Stock | 133.13 | 133.16 | 133.12 | 133.15 | 1732.0 |
| 2021-06-28 07:55:00 | AAPL | Stock | 133.17 | 133.17 | 133.15 | 133.17 | 4270.0 |
| 2021-06-28 08:00:00 | AAPL | Stock | 133.19 | 133.28 | 132.778 | 133.07 | 76308.0 |
| 2021-06-28 08:05:00 | AAPL | Stock | 133.0801 | 133.15 | 133.08 | 133.12 | 17255.0 |
| 2021-06-28 08:10:00 | AAPL | Stock | 133.13 | 133.13 | 133.1 | 133.13 | 5441.0 |
| 2021-06-28 08:15:00 | AAPL | Stock | 133.14 | 133.2 | 133.13 | 133.18 | 18428.0 |
| 2021-06-28 08:20:00 | AAPL | Stock | 133.18 | 133.18 | 133.15 | 133.15 | 8540.0 |
| 2021-06-28 08:25:00 | AAPL | Stock | 133.15 | 133.25 | 133.13 | 133.23 | 17844.0 |
| 2021-06-28 08:30:00 | AAPL | Stock | 133.24 | 133.26 | 133.17 | 133.18 | 8363.0 |
| 2021-06-28 08:35:00 | AAPL | Stock | 133.18 | 133.23 | 133.18 | 133.2 | 16106.0 |
| 2021-06-28 08:40:00 | AAPL | Stock | 133.21 | 133.24 | 133.18 | 133.225 | 10113.0 |
| 2021-06-28 08:45:00 | AAPL | Stock | 133.225 | 133.225 | 133.18 | 133.2 | 17752.0 |
| 2021-06-28 08:50:00 | AAPL | Stock | 133.19 | 133.21 | 133.18 | 133.2 | 13782.0 |
| 2021-06-28 08:55:00 | AAPL | Stock | 133.2 | 133.23 | 133.11 | 133.11 | 121609.0 |
| 2021-06-28 09:00:00 | AAPL | Stock | 133.22 | 133.22 | 133.17 | 133.2 | 18917.0 |
| 2021-06-28 09:05:00 | AAPL | Stock | 133.21 | 133.23 | 133.19 | 133.2 | 11781.0 |
| 2021-06-28 09:10:00 | AAPL | Stock | 133.219 | 133.27 | 133.2 | 133.27 | 13113.0 |
| 2021-06-28 09:15:00 | AAPL | Stock | 133.27 | 133.27 | 133.22 | 133.22 | 6279.0 |
> showing 50 of 482,093 rows — these rows as CSV