PREVIEW / stock_5min / 2022-11-11
file: by_date/stock_5min/2022/2022-11-11.parquet size: 7.1 MB rows: 433,069 symbols: 2,071
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-11-11 04:00:00 | AAPL | Stock | 148.06 | 148.74 | 147.86 | 148.29 | 19884.0 |
| 2022-11-11 04:05:00 | AAPL | Stock | 148.24 | 148.24 | 148.03 | 148.19 | 6680.0 |
| 2022-11-11 04:10:00 | AAPL | Stock | 148.17 | 148.29 | 148.15 | 148.18 | 4375.0 |
| 2022-11-11 04:15:00 | AAPL | Stock | 148.2 | 148.2 | 148.0 | 148.1 | 24706.0 |
| 2022-11-11 04:20:00 | AAPL | Stock | 148.06 | 148.07 | 147.74 | 148.02 | 10483.0 |
| 2022-11-11 04:25:00 | AAPL | Stock | 148.02 | 148.02 | 147.9 | 148.0 | 10777.0 |
| 2022-11-11 04:30:00 | AAPL | Stock | 147.93 | 147.94 | 147.85 | 147.87 | 977.0 |
| 2022-11-11 04:35:00 | AAPL | Stock | 147.94 | 148.02 | 147.94 | 148.01 | 2136.0 |
| 2022-11-11 04:40:00 | AAPL | Stock | 147.9 | 147.9 | 147.83 | 147.83 | 3342.0 |
| 2022-11-11 04:45:00 | AAPL | Stock | 147.87 | 147.87 | 147.82 | 147.87 | 2366.0 |
| 2022-11-11 04:50:00 | AAPL | Stock | 147.97 | 147.97 | 147.91 | 147.97 | 1227.0 |
| 2022-11-11 04:55:00 | AAPL | Stock | 147.91 | 147.97 | 147.91 | 147.97 | 1336.0 |
| 2022-11-11 05:00:00 | AAPL | Stock | 147.97 | 147.99 | 147.89 | 147.89 | 18142.0 |
| 2022-11-11 05:05:00 | AAPL | Stock | 147.88 | 147.88 | 147.7 | 147.72 | 3372.0 |
| 2022-11-11 05:10:00 | AAPL | Stock | 147.8 | 147.85 | 147.72 | 147.8 | 29064.0 |
| 2022-11-11 05:15:00 | AAPL | Stock | 147.85 | 147.9 | 147.85 | 147.9 | 3217.0 |
| 2022-11-11 05:20:00 | AAPL | Stock | 147.9 | 147.9 | 147.71 | 147.71 | 2507.0 |
| 2022-11-11 05:25:00 | AAPL | Stock | 147.71 | 147.71 | 147.6 | 147.6 | 2700.0 |
| 2022-11-11 05:30:00 | AAPL | Stock | 147.69 | 147.78 | 147.69 | 147.77 | 3167.0 |
| 2022-11-11 05:35:00 | AAPL | Stock | 147.7 | 147.7 | 147.65 | 147.69 | 14492.0 |
| 2022-11-11 05:40:00 | AAPL | Stock | 147.62 | 147.66 | 147.6 | 147.66 | 987.0 |
| 2022-11-11 05:45:00 | AAPL | Stock | 147.64 | 147.66 | 147.56 | 147.56 | 3264.0 |
| 2022-11-11 05:50:00 | AAPL | Stock | 147.53 | 147.58 | 147.4 | 147.58 | 9848.0 |
| 2022-11-11 05:55:00 | AAPL | Stock | 147.64 | 147.67 | 147.52 | 147.52 | 17046.0 |
| 2022-11-11 06:00:00 | AAPL | Stock | 147.5 | 147.5 | 147.45 | 147.45 | 247.0 |
| 2022-11-11 06:05:00 | AAPL | Stock | 147.45 | 147.55 | 147.34 | 147.55 | 16934.0 |
| 2022-11-11 06:10:00 | AAPL | Stock | 147.57 | 147.57 | 147.52 | 147.52 | 735.0 |
| 2022-11-11 06:15:00 | AAPL | Stock | 147.5 | 147.64 | 147.47 | 147.59 | 15929.0 |
| 2022-11-11 06:20:00 | AAPL | Stock | 147.52 | 147.52 | 147.49 | 147.5 | 3414.0 |
| 2022-11-11 06:25:00 | AAPL | Stock | 147.52 | 147.55 | 147.51 | 147.51 | 1471.0 |
| 2022-11-11 06:30:00 | AAPL | Stock | 147.53 | 147.56 | 147.53 | 147.56 | 522.0 |
| 2022-11-11 06:35:00 | AAPL | Stock | 147.55 | 147.58 | 147.5 | 147.5 | 2960.0 |
| 2022-11-11 06:40:00 | AAPL | Stock | 147.5 | 147.5 | 147.33 | 147.33 | 15874.0 |
| 2022-11-11 06:45:00 | AAPL | Stock | 147.33 | 147.33 | 147.29 | 147.29 | 517.0 |
| 2022-11-11 06:50:00 | AAPL | Stock | 147.31 | 147.44 | 147.3 | 147.44 | 11716.0 |
| 2022-11-11 06:55:00 | AAPL | Stock | 147.29 | 147.4 | 147.29 | 147.39 | 4752.0 |
| 2022-11-11 07:00:00 | AAPL | Stock | 147.43 | 147.47 | 147.29 | 147.35 | 6348.0 |
| 2022-11-11 07:05:00 | AAPL | Stock | 147.3 | 147.3 | 147.07 | 147.19 | 16372.0 |
| 2022-11-11 07:10:00 | AAPL | Stock | 147.2 | 147.24 | 147.1 | 147.15 | 14167.0 |
| 2022-11-11 07:15:00 | AAPL | Stock | 147.11 | 147.15 | 147.02 | 147.12 | 12200.0 |
| 2022-11-11 07:20:00 | AAPL | Stock | 147.09 | 147.09 | 146.9 | 147.0 | 24468.0 |
| 2022-11-11 07:25:00 | AAPL | Stock | 146.99 | 147.1 | 146.99 | 147.0 | 13763.0 |
| 2022-11-11 07:30:00 | AAPL | Stock | 147.0 | 147.2 | 146.93 | 147.2 | 10710.0 |
| 2022-11-11 07:35:00 | AAPL | Stock | 147.19 | 147.35 | 147.19 | 147.21 | 20920.0 |
| 2022-11-11 07:40:00 | AAPL | Stock | 147.16 | 147.23 | 147.07 | 147.09 | 6778.0 |
| 2022-11-11 07:45:00 | AAPL | Stock | 147.07 | 147.25 | 147.05 | 147.12 | 6576.0 |
| 2022-11-11 07:50:00 | AAPL | Stock | 147.15 | 147.3 | 147.07 | 147.26 | 15372.0 |
| 2022-11-11 07:55:00 | AAPL | Stock | 147.26 | 147.52 | 147.24 | 147.43 | 35172.0 |
| 2022-11-11 08:00:00 | AAPL | Stock | 147.35 | 148.33 | 146.91 | 147.47 | 91215.0 |
| 2022-11-11 08:05:00 | AAPL | Stock | 147.49 | 147.57 | 147.45 | 147.52 | 18559.0 |
> showing 50 of 433,069 rows — these rows as CSV