PREVIEW / stock_5min / 2023-03-10
file: by_date/stock_5min/2023/2023-03-10.parquet size: 7.1 MB rows: 437,921 symbols: 1,792
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 |
|---|---|---|---|---|---|---|---|
| 2023-03-10 04:00:00 | AAPL | Stock | 150.29 | 150.4 | 149.77 | 150.25 | 6201.0 |
| 2023-03-10 04:05:00 | AAPL | Stock | 150.3 | 150.35 | 150.22 | 150.3 | 2978.0 |
| 2023-03-10 04:10:00 | AAPL | Stock | 150.3 | 150.35 | 150.3 | 150.32 | 1686.0 |
| 2023-03-10 04:15:00 | AAPL | Stock | 150.4 | 150.4 | 150.4 | 150.4 | 200.0 |
| 2023-03-10 04:20:00 | AAPL | Stock | 150.38 | 150.38 | 150.38 | 150.38 | 293.0 |
| 2023-03-10 04:25:00 | AAPL | Stock | 150.4 | 150.4 | 150.4 | 150.4 | 300.0 |
| 2023-03-10 04:30:00 | AAPL | Stock | 150.66 | 150.91 | 150.66 | 150.91 | 1452.0 |
| 2023-03-10 04:35:00 | AAPL | Stock | 150.88 | 150.89 | 150.69 | 150.69 | 2502.0 |
| 2023-03-10 04:40:00 | AAPL | Stock | 150.64 | 150.64 | 150.41 | 150.47 | 1512.0 |
| 2023-03-10 04:45:00 | AAPL | Stock | 150.62 | 150.62 | 150.62 | 150.62 | 124.0 |
| 2023-03-10 04:50:00 | AAPL | Stock | 150.63 | 150.63 | 150.62 | 150.62 | 629.0 |
| 2023-03-10 04:55:00 | AAPL | Stock | 150.47 | 150.64 | 150.47 | 150.64 | 559.0 |
| 2023-03-10 05:10:00 | AAPL | Stock | 150.58 | 150.65 | 150.58 | 150.65 | 639.0 |
| 2023-03-10 05:15:00 | AAPL | Stock | 150.64 | 150.69 | 150.6 | 150.68 | 956.0 |
| 2023-03-10 05:20:00 | AAPL | Stock | 150.75 | 150.93 | 150.75 | 150.93 | 1200.0 |
| 2023-03-10 05:25:00 | AAPL | Stock | 150.87 | 150.95 | 150.87 | 150.95 | 200.0 |
| 2023-03-10 05:30:00 | AAPL | Stock | 150.71 | 150.71 | 150.6 | 150.6 | 2197.0 |
| 2023-03-10 05:40:00 | AAPL | Stock | 150.6 | 150.6 | 150.6 | 150.6 | 2049.0 |
| 2023-03-10 05:45:00 | AAPL | Stock | 150.7 | 150.7 | 150.67 | 150.67 | 1082.0 |
| 2023-03-10 05:55:00 | AAPL | Stock | 150.65 | 150.65 | 150.51 | 150.51 | 2503.0 |
| 2023-03-10 06:00:00 | AAPL | Stock | 150.48 | 150.5 | 149.84 | 150.03 | 17335.0 |
| 2023-03-10 06:05:00 | AAPL | Stock | 149.94 | 149.94 | 149.55 | 149.75 | 8701.0 |
| 2023-03-10 06:10:00 | AAPL | Stock | 149.74 | 149.92 | 149.65 | 149.7 | 4437.0 |
| 2023-03-10 06:15:00 | AAPL | Stock | 149.72 | 149.85 | 149.65 | 149.85 | 4480.0 |
| 2023-03-10 06:20:00 | AAPL | Stock | 149.79 | 149.79 | 149.01 | 149.44 | 9085.0 |
| 2023-03-10 06:25:00 | AAPL | Stock | 149.46 | 149.91 | 149.45 | 149.91 | 2486.0 |
| 2023-03-10 06:30:00 | AAPL | Stock | 149.84 | 149.94 | 149.84 | 149.94 | 2952.0 |
| 2023-03-10 06:35:00 | AAPL | Stock | 149.92 | 150.21 | 149.92 | 150.21 | 6504.0 |
| 2023-03-10 06:40:00 | AAPL | Stock | 150.21 | 150.29 | 149.94 | 150.28 | 3992.0 |
| 2023-03-10 06:45:00 | AAPL | Stock | 150.27 | 150.27 | 150.0 | 150.0 | 1090.0 |
| 2023-03-10 06:50:00 | AAPL | Stock | 150.1 | 150.2 | 150.1 | 150.1 | 2555.0 |
| 2023-03-10 06:55:00 | AAPL | Stock | 150.05 | 150.1 | 150.02 | 150.06 | 2966.0 |
| 2023-03-10 07:00:00 | AAPL | Stock | 150.02 | 150.25 | 150.01 | 150.12 | 10884.0 |
| 2023-03-10 07:05:00 | AAPL | Stock | 150.15 | 150.28 | 150.15 | 150.25 | 7888.0 |
| 2023-03-10 07:10:00 | AAPL | Stock | 150.25 | 150.6 | 150.25 | 150.6 | 3846.0 |
| 2023-03-10 07:15:00 | AAPL | Stock | 150.59 | 150.64 | 150.55 | 150.64 | 1745.0 |
| 2023-03-10 07:20:00 | AAPL | Stock | 150.65 | 150.7 | 150.3 | 150.51 | 6793.0 |
| 2023-03-10 07:30:00 | AAPL | Stock | 150.4 | 150.5 | 150.25 | 150.25 | 2051.0 |
| 2023-03-10 07:35:00 | AAPL | Stock | 150.21 | 150.22 | 150.05 | 150.2 | 3878.0 |
| 2023-03-10 07:40:00 | AAPL | Stock | 150.23 | 150.3 | 150.21 | 150.26 | 816.0 |
| 2023-03-10 07:45:00 | AAPL | Stock | 150.36 | 150.5 | 150.36 | 150.5 | 1347.0 |
| 2023-03-10 07:50:00 | AAPL | Stock | 150.49 | 150.7 | 150.4 | 150.7 | 3875.0 |
| 2023-03-10 07:55:00 | AAPL | Stock | 150.72 | 150.81 | 150.64 | 150.64 | 8309.0 |
| 2023-03-10 08:00:00 | AAPL | Stock | 150.3 | 150.8314 | 149.6 | 150.52 | 61289.0 |
| 2023-03-10 08:05:00 | AAPL | Stock | 150.48 | 150.89 | 150.47 | 150.79 | 6733.0 |
| 2023-03-10 08:10:00 | AAPL | Stock | 150.8024 | 150.86 | 150.51 | 150.6498 | 9102.0 |
| 2023-03-10 08:15:00 | AAPL | Stock | 150.65 | 150.79 | 150.59 | 150.7795 | 4458.0 |
| 2023-03-10 08:20:00 | AAPL | Stock | 150.67 | 150.7 | 150.3206 | 150.6 | 23401.0 |
| 2023-03-10 08:25:00 | AAPL | Stock | 150.6 | 150.7 | 150.12 | 150.55 | 25015.0 |
| 2023-03-10 08:30:00 | AAPL | Stock | 150.6 | 152.0 | 149.99 | 151.6792 | 117899.0 |
> showing 50 of 437,921 rows — these rows as CSV