PREVIEW / stock_5min / 2022-05-20
file: by_date/stock_5min/2022/2022-05-20.parquet size: 7.1 MB rows: 446,074 symbols: 2,399
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-05-20 04:00:00 | AAPL | Stock | 139.02 | 140.1 | 138.32 | 139.29 | 30424.0 |
| 2022-05-20 04:05:00 | AAPL | Stock | 139.25 | 139.36 | 139.25 | 139.34 | 4109.0 |
| 2022-05-20 04:10:00 | AAPL | Stock | 139.3 | 139.34 | 138.86 | 138.9 | 5381.0 |
| 2022-05-20 04:15:00 | AAPL | Stock | 138.93 | 139.1 | 138.93 | 139.08 | 5080.0 |
| 2022-05-20 04:20:00 | AAPL | Stock | 139.08 | 139.24 | 139.08 | 139.24 | 2810.0 |
| 2022-05-20 04:25:00 | AAPL | Stock | 139.2 | 139.36 | 139.2 | 139.36 | 5230.0 |
| 2022-05-20 04:30:00 | AAPL | Stock | 139.34 | 139.5 | 139.34 | 139.41 | 7229.0 |
| 2022-05-20 04:35:00 | AAPL | Stock | 139.44 | 139.44 | 139.36 | 139.41 | 3456.0 |
| 2022-05-20 04:40:00 | AAPL | Stock | 139.41 | 139.5 | 139.39 | 139.47 | 1500.0 |
| 2022-05-20 04:45:00 | AAPL | Stock | 139.48 | 139.48 | 139.41 | 139.41 | 200.0 |
| 2022-05-20 04:50:00 | AAPL | Stock | 139.4 | 139.4 | 139.3 | 139.35 | 1211.0 |
| 2022-05-20 04:55:00 | AAPL | Stock | 139.34 | 139.47 | 139.33 | 139.43 | 8738.0 |
| 2022-05-20 05:00:00 | AAPL | Stock | 139.36 | 139.36 | 139.26 | 139.32 | 13763.0 |
| 2022-05-20 05:05:00 | AAPL | Stock | 139.35 | 139.35 | 139.33 | 139.35 | 1312.0 |
| 2022-05-20 05:10:00 | AAPL | Stock | 139.31 | 139.48 | 139.31 | 139.41 | 3008.0 |
| 2022-05-20 05:15:00 | AAPL | Stock | 139.47 | 139.6 | 139.47 | 139.57 | 9263.0 |
| 2022-05-20 05:20:00 | AAPL | Stock | 139.59 | 139.59 | 139.55 | 139.55 | 5282.0 |
| 2022-05-20 05:25:00 | AAPL | Stock | 139.51 | 139.51 | 139.42 | 139.43 | 1819.0 |
| 2022-05-20 05:30:00 | AAPL | Stock | 139.45 | 139.45 | 139.4 | 139.4 | 2614.0 |
| 2022-05-20 05:35:00 | AAPL | Stock | 139.36 | 139.36 | 139.33 | 139.35 | 2109.0 |
| 2022-05-20 05:40:00 | AAPL | Stock | 139.33 | 139.35 | 139.03 | 139.03 | 2459.0 |
| 2022-05-20 05:45:00 | AAPL | Stock | 139.07 | 139.31 | 139.0 | 139.31 | 8012.0 |
| 2022-05-20 05:50:00 | AAPL | Stock | 139.18 | 139.3 | 139.18 | 139.29 | 6235.0 |
| 2022-05-20 05:55:00 | AAPL | Stock | 139.27 | 139.27 | 139.16 | 139.23 | 1447.0 |
| 2022-05-20 06:00:00 | AAPL | Stock | 139.18 | 139.18 | 139.18 | 139.18 | 211.0 |
| 2022-05-20 06:05:00 | AAPL | Stock | 139.17 | 139.3 | 139.17 | 139.3 | 2131.0 |
| 2022-05-20 06:10:00 | AAPL | Stock | 139.3 | 139.35 | 139.3 | 139.35 | 968.0 |
| 2022-05-20 06:15:00 | AAPL | Stock | 139.26 | 139.27 | 139.22 | 139.22 | 515.0 |
| 2022-05-20 06:20:00 | AAPL | Stock | 139.23 | 139.3 | 139.2 | 139.3 | 807.0 |
| 2022-05-20 06:25:00 | AAPL | Stock | 139.34 | 139.44 | 139.33 | 139.44 | 1414.0 |
| 2022-05-20 06:30:00 | AAPL | Stock | 139.41 | 139.46 | 139.33 | 139.38 | 3299.0 |
| 2022-05-20 06:40:00 | AAPL | Stock | 139.27 | 139.37 | 139.26 | 139.37 | 1132.0 |
| 2022-05-20 06:45:00 | AAPL | Stock | 139.26 | 139.3 | 139.26 | 139.3 | 535.0 |
| 2022-05-20 06:50:00 | AAPL | Stock | 139.3 | 139.3 | 139.16 | 139.18 | 2124.0 |
| 2022-05-20 06:55:00 | AAPL | Stock | 139.25 | 139.25 | 139.19 | 139.19 | 938.0 |
| 2022-05-20 07:00:00 | AAPL | Stock | 139.17 | 139.29 | 139.02 | 139.05 | 20868.0 |
| 2022-05-20 07:05:00 | AAPL | Stock | 139.02 | 139.08 | 138.91 | 138.91 | 14209.0 |
| 2022-05-20 07:10:00 | AAPL | Stock | 138.91 | 139.05 | 138.88 | 139.0 | 7911.0 |
| 2022-05-20 07:15:00 | AAPL | Stock | 139.06 | 139.15 | 139.02 | 139.08 | 5980.0 |
| 2022-05-20 07:20:00 | AAPL | Stock | 139.12 | 139.28 | 139.12 | 139.2 | 13517.0 |
| 2022-05-20 07:25:00 | AAPL | Stock | 139.19 | 139.21 | 139.18 | 139.21 | 1230.0 |
| 2022-05-20 07:30:00 | AAPL | Stock | 139.23 | 139.45 | 139.23 | 139.44 | 12876.0 |
| 2022-05-20 07:35:00 | AAPL | Stock | 139.42 | 139.45 | 139.38 | 139.38 | 2993.0 |
| 2022-05-20 07:40:00 | AAPL | Stock | 139.32 | 139.59 | 139.32 | 139.46 | 27104.0 |
| 2022-05-20 07:45:00 | AAPL | Stock | 139.46 | 139.72 | 139.46 | 139.59 | 10739.0 |
| 2022-05-20 07:50:00 | AAPL | Stock | 139.6 | 139.91 | 139.6 | 139.91 | 18161.0 |
| 2022-05-20 07:55:00 | AAPL | Stock | 139.93 | 139.99 | 139.6 | 139.6 | 23563.0 |
| 2022-05-20 08:00:00 | AAPL | Stock | 139.05 | 139.99 | 138.86 | 139.5 | 390377.0 |
| 2022-05-20 08:05:00 | AAPL | Stock | 139.4999 | 139.68 | 139.4999 | 139.55 | 37981.0 |
| 2022-05-20 08:10:00 | AAPL | Stock | 139.56 | 139.58 | 139.36 | 139.36 | 44949.0 |
> showing 50 of 446,074 rows — these rows as CSV