PREVIEW / stock_5min / 2022-07-29
file: by_date/stock_5min/2022/2022-07-29.parquet size: 6.9 MB rows: 429,724 symbols: 2,305
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 |
|---|---|---|---|---|---|---|---|
| 2022-07-29 04:00:00 | AAPL | Stock | 162.03 | 162.03 | 160.32 | 161.48 | 18703.0 |
| 2022-07-29 04:05:00 | AAPL | Stock | 161.48 | 161.8 | 161.48 | 161.8 | 7085.0 |
| 2022-07-29 04:10:00 | AAPL | Stock | 161.8 | 161.81 | 161.75 | 161.78 | 8405.0 |
| 2022-07-29 04:15:00 | AAPL | Stock | 161.75 | 161.8 | 161.68 | 161.8 | 6223.0 |
| 2022-07-29 04:20:00 | AAPL | Stock | 161.81 | 161.81 | 161.5 | 161.5 | 5852.0 |
| 2022-07-29 04:25:00 | AAPL | Stock | 161.51 | 161.7 | 161.48 | 161.69 | 7546.0 |
| 2022-07-29 04:30:00 | AAPL | Stock | 161.68 | 161.68 | 161.53 | 161.62 | 5446.0 |
| 2022-07-29 04:35:00 | AAPL | Stock | 161.63 | 161.63 | 161.48 | 161.48 | 11493.0 |
| 2022-07-29 04:40:00 | AAPL | Stock | 161.48 | 161.51 | 161.39 | 161.39 | 6155.0 |
| 2022-07-29 04:45:00 | AAPL | Stock | 161.33 | 161.35 | 161.0 | 161.0 | 11320.0 |
| 2022-07-29 04:50:00 | AAPL | Stock | 161.0 | 161.02 | 160.94 | 160.96 | 6115.0 |
| 2022-07-29 04:55:00 | AAPL | Stock | 161.02 | 161.25 | 161.0 | 161.2 | 7079.0 |
| 2022-07-29 05:00:00 | AAPL | Stock | 161.21 | 161.21 | 161.15 | 161.15 | 1838.0 |
| 2022-07-29 05:05:00 | AAPL | Stock | 161.05 | 161.1 | 161.04 | 161.05 | 1663.0 |
| 2022-07-29 05:10:00 | AAPL | Stock | 161.13 | 161.17 | 161.12 | 161.17 | 757.0 |
| 2022-07-29 05:15:00 | AAPL | Stock | 161.28 | 161.28 | 161.27 | 161.27 | 1751.0 |
| 2022-07-29 05:20:00 | AAPL | Stock | 161.27 | 161.3 | 161.23 | 161.3 | 1780.0 |
| 2022-07-29 05:25:00 | AAPL | Stock | 161.42 | 161.6 | 161.3 | 161.48 | 6303.0 |
| 2022-07-29 05:30:00 | AAPL | Stock | 161.58 | 161.64 | 161.55 | 161.56 | 5952.0 |
| 2022-07-29 05:35:00 | AAPL | Stock | 161.55 | 161.55 | 161.37 | 161.5 | 2277.0 |
| 2022-07-29 05:40:00 | AAPL | Stock | 161.49 | 161.49 | 161.38 | 161.38 | 200.0 |
| 2022-07-29 05:45:00 | AAPL | Stock | 161.4 | 161.46 | 161.35 | 161.46 | 763.0 |
| 2022-07-29 05:50:00 | AAPL | Stock | 161.4 | 161.4 | 161.34 | 161.4 | 545.0 |
| 2022-07-29 05:55:00 | AAPL | Stock | 161.37 | 161.46 | 161.37 | 161.46 | 783.0 |
| 2022-07-29 06:00:00 | AAPL | Stock | 161.45 | 161.5 | 161.2 | 161.3 | 7525.0 |
| 2022-07-29 06:05:00 | AAPL | Stock | 161.35 | 161.36 | 161.19 | 161.36 | 6087.0 |
| 2022-07-29 06:10:00 | AAPL | Stock | 161.31 | 161.31 | 161.01 | 161.01 | 8179.0 |
| 2022-07-29 06:15:00 | AAPL | Stock | 161.06 | 161.06 | 160.6 | 160.83 | 14578.0 |
| 2022-07-29 06:20:00 | AAPL | Stock | 160.89 | 160.89 | 160.75 | 160.86 | 22637.0 |
| 2022-07-29 06:25:00 | AAPL | Stock | 160.86 | 161.0 | 160.86 | 161.0 | 3847.0 |
| 2022-07-29 06:30:00 | AAPL | Stock | 161.08 | 161.15 | 161.08 | 161.1 | 4932.0 |
| 2022-07-29 06:35:00 | AAPL | Stock | 161.15 | 161.34 | 161.14 | 161.3 | 10342.0 |
| 2022-07-29 06:40:00 | AAPL | Stock | 161.3 | 161.3 | 161.15 | 161.15 | 2339.0 |
| 2022-07-29 06:45:00 | AAPL | Stock | 161.15 | 161.15 | 161.0 | 161.0 | 6238.0 |
| 2022-07-29 06:50:00 | AAPL | Stock | 161.13 | 161.14 | 161.11 | 161.14 | 300.0 |
| 2022-07-29 06:55:00 | AAPL | Stock | 161.07 | 161.07 | 160.86 | 160.88 | 10462.0 |
| 2022-07-29 07:00:00 | AAPL | Stock | 160.95 | 161.38 | 160.95 | 161.1 | 35540.0 |
| 2022-07-29 07:05:00 | AAPL | Stock | 161.1 | 161.18 | 161.07 | 161.1 | 27809.0 |
| 2022-07-29 07:10:00 | AAPL | Stock | 161.07 | 161.15 | 161.02 | 161.07 | 18322.0 |
| 2022-07-29 07:15:00 | AAPL | Stock | 161.1 | 161.26 | 161.0 | 161.26 | 16955.0 |
| 2022-07-29 07:20:00 | AAPL | Stock | 161.32 | 161.4 | 161.05 | 161.17 | 13209.0 |
| 2022-07-29 07:25:00 | AAPL | Stock | 161.15 | 161.15 | 161.0 | 161.02 | 23709.0 |
| 2022-07-29 07:30:00 | AAPL | Stock | 161.05 | 161.1 | 160.96 | 160.96 | 57403.0 |
| 2022-07-29 07:35:00 | AAPL | Stock | 160.96 | 161.25 | 160.96 | 161.25 | 14495.0 |
| 2022-07-29 07:40:00 | AAPL | Stock | 161.26 | 161.26 | 160.98 | 161.2 | 16087.0 |
| 2022-07-29 07:45:00 | AAPL | Stock | 161.2 | 161.63 | 161.19 | 161.38 | 39645.0 |
| 2022-07-29 07:50:00 | AAPL | Stock | 161.34 | 161.84 | 161.28 | 161.6 | 17843.0 |
| 2022-07-29 07:55:00 | AAPL | Stock | 161.57 | 161.83 | 161.45 | 161.8 | 10788.0 |
| 2022-07-29 08:00:00 | AAPL | Stock | 161.2387 | 162.0 | 160.95 | 161.6 | 317540.0 |
| 2022-07-29 08:05:00 | AAPL | Stock | 161.56 | 161.6 | 161.23 | 161.35 | 36155.0 |
> showing 50 of 429,724 rows — these rows as CSV