PREVIEW / stock_5min / 2021-09-27
file: by_date/stock_5min/2021/2021-09-27.parquet size: 7.5 MB rows: 459,825 symbols: 2,728
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-09-27 04:00:00 | AAPL | Stock | 147.0 | 147.28 | 146.99 | 147.19 | 3636.0 |
| 2021-09-27 04:05:00 | AAPL | Stock | 147.15 | 147.21 | 147.15 | 147.21 | 580.0 |
| 2021-09-27 04:10:00 | AAPL | Stock | 147.21 | 147.28 | 147.19 | 147.19 | 1965.0 |
| 2021-09-27 04:15:00 | AAPL | Stock | 147.19 | 147.24 | 147.19 | 147.2 | 889.0 |
| 2021-09-27 04:20:00 | AAPL | Stock | 147.18 | 147.18 | 147.1 | 147.15 | 1109.0 |
| 2021-09-27 04:35:00 | AAPL | Stock | 147.1 | 147.12 | 147.1 | 147.12 | 1149.0 |
| 2021-09-27 04:40:00 | AAPL | Stock | 147.11 | 147.13 | 147.04 | 147.04 | 1788.0 |
| 2021-09-27 04:45:00 | AAPL | Stock | 147.01 | 147.01 | 147.0 | 147.01 | 1226.0 |
| 2021-09-27 04:50:00 | AAPL | Stock | 147.01 | 147.01 | 146.97 | 146.97 | 579.0 |
| 2021-09-27 04:55:00 | AAPL | Stock | 146.92 | 146.99 | 146.92 | 146.99 | 540.0 |
| 2021-09-27 05:00:00 | AAPL | Stock | 146.98 | 146.99 | 146.98 | 146.99 | 960.0 |
| 2021-09-27 05:05:00 | AAPL | Stock | 146.99 | 146.99 | 146.99 | 146.99 | 200.0 |
| 2021-09-27 05:10:00 | AAPL | Stock | 147.01 | 147.03 | 147.01 | 147.03 | 1581.0 |
| 2021-09-27 05:20:00 | AAPL | Stock | 147.03 | 147.03 | 147.03 | 147.03 | 100.0 |
| 2021-09-27 05:25:00 | AAPL | Stock | 147.0 | 147.0 | 146.87 | 146.87 | 7504.0 |
| 2021-09-27 05:30:00 | AAPL | Stock | 146.87 | 146.87 | 146.65 | 146.7 | 4808.0 |
| 2021-09-27 05:35:00 | AAPL | Stock | 146.48 | 146.51 | 146.34 | 146.51 | 5928.0 |
| 2021-09-27 05:40:00 | AAPL | Stock | 146.5 | 146.5 | 146.4 | 146.45 | 425.0 |
| 2021-09-27 05:45:00 | AAPL | Stock | 146.32 | 146.55 | 146.32 | 146.55 | 1199.0 |
| 2021-09-27 05:50:00 | AAPL | Stock | 146.43 | 146.43 | 146.35 | 146.4 | 1020.0 |
| 2021-09-27 05:55:00 | AAPL | Stock | 146.3 | 146.38 | 146.27 | 146.34 | 1715.0 |
| 2021-09-27 06:00:00 | AAPL | Stock | 146.3 | 146.3 | 146.21 | 146.29 | 1690.0 |
| 2021-09-27 06:05:00 | AAPL | Stock | 146.28 | 146.31 | 146.22 | 146.28 | 968.0 |
| 2021-09-27 06:10:00 | AAPL | Stock | 146.48 | 146.5 | 146.39 | 146.45 | 1335.0 |
| 2021-09-27 06:15:00 | AAPL | Stock | 146.46 | 146.49 | 146.44 | 146.45 | 1989.0 |
| 2021-09-27 06:20:00 | AAPL | Stock | 146.33 | 146.33 | 146.31 | 146.31 | 547.0 |
| 2021-09-27 06:25:00 | AAPL | Stock | 146.31 | 146.35 | 146.31 | 146.35 | 3224.0 |
| 2021-09-27 06:30:00 | AAPL | Stock | 146.35 | 146.35 | 146.22 | 146.27 | 4252.0 |
| 2021-09-27 06:35:00 | AAPL | Stock | 146.27 | 146.27 | 146.27 | 146.27 | 400.0 |
| 2021-09-27 06:40:00 | AAPL | Stock | 146.27 | 146.27 | 146.19 | 146.19 | 1640.0 |
| 2021-09-27 06:45:00 | AAPL | Stock | 146.2 | 146.26 | 145.97 | 145.97 | 7084.0 |
| 2021-09-27 06:50:00 | AAPL | Stock | 145.95 | 146.05 | 145.95 | 145.95 | 3494.0 |
| 2021-09-27 06:55:00 | AAPL | Stock | 145.97 | 146.1 | 145.75 | 145.85 | 18783.0 |
| 2021-09-27 07:00:00 | AAPL | Stock | 145.97 | 146.2 | 145.95 | 145.98 | 26927.0 |
| 2021-09-27 07:05:00 | AAPL | Stock | 146.0 | 146.01 | 145.84 | 145.91 | 34898.0 |
| 2021-09-27 07:10:00 | AAPL | Stock | 145.95 | 146.07 | 145.95 | 146.0 | 19516.0 |
| 2021-09-27 07:15:00 | AAPL | Stock | 145.97 | 146.11 | 145.9 | 146.05 | 10523.0 |
| 2021-09-27 07:20:00 | AAPL | Stock | 146.03 | 146.05 | 145.98 | 146.02 | 10393.0 |
| 2021-09-27 07:25:00 | AAPL | Stock | 146.0 | 146.04 | 145.9 | 145.9 | 15588.0 |
| 2021-09-27 07:30:00 | AAPL | Stock | 145.93 | 145.99 | 145.85 | 145.99 | 23587.0 |
| 2021-09-27 07:35:00 | AAPL | Stock | 146.0 | 146.0 | 145.85 | 145.95 | 12684.0 |
| 2021-09-27 07:40:00 | AAPL | Stock | 145.95 | 146.09 | 145.95 | 146.09 | 15034.0 |
| 2021-09-27 07:45:00 | AAPL | Stock | 146.1 | 146.1 | 146.02 | 146.08 | 5241.0 |
| 2021-09-27 07:50:00 | AAPL | Stock | 146.08 | 146.11 | 146.03 | 146.09 | 9854.0 |
| 2021-09-27 07:55:00 | AAPL | Stock | 146.08 | 146.13 | 146.0 | 146.05 | 10700.0 |
| 2021-09-27 08:00:00 | AAPL | Stock | 146.1899 | 146.25 | 145.8401 | 145.92 | 177438.0 |
| 2021-09-27 08:05:00 | AAPL | Stock | 145.94 | 146.02 | 145.86 | 146.02 | 28628.0 |
| 2021-09-27 08:10:00 | AAPL | Stock | 146.0 | 146.02 | 145.8 | 145.92 | 27779.0 |
| 2021-09-27 08:15:00 | AAPL | Stock | 145.93 | 145.95 | 145.79 | 145.83 | 62008.0 |
| 2021-09-27 08:20:00 | AAPL | Stock | 145.85 | 145.93 | 145.68 | 145.76 | 87518.0 |
> showing 50 of 459,825 rows — these rows as CSV