PREVIEW / stock_5min / 2022-11-02
file: by_date/stock_5min/2022/2022-11-02.parquet size: 6.8 MB rows: 420,692 symbols: 2,084
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-02 04:00:00 | AAPL | Stock | 150.72 | 150.73 | 150.41 | 150.73 | 2748.0 |
| 2022-11-02 04:05:00 | AAPL | Stock | 150.75 | 150.75 | 150.59 | 150.67 | 6431.0 |
| 2022-11-02 04:10:00 | AAPL | Stock | 150.59 | 150.73 | 150.58 | 150.73 | 738.0 |
| 2022-11-02 04:15:00 | AAPL | Stock | 150.6 | 150.73 | 150.6 | 150.73 | 848.0 |
| 2022-11-02 04:20:00 | AAPL | Stock | 150.71 | 150.74 | 150.7 | 150.71 | 2116.0 |
| 2022-11-02 04:25:00 | AAPL | Stock | 150.8 | 150.93 | 150.8 | 150.93 | 1584.0 |
| 2022-11-02 04:30:00 | AAPL | Stock | 150.81 | 150.84 | 150.8 | 150.8 | 1005.0 |
| 2022-11-02 04:35:00 | AAPL | Stock | 150.79 | 150.81 | 150.78 | 150.8 | 3499.0 |
| 2022-11-02 04:40:00 | AAPL | Stock | 150.72 | 150.72 | 150.72 | 150.72 | 300.0 |
| 2022-11-02 04:45:00 | AAPL | Stock | 150.72 | 150.72 | 150.65 | 150.65 | 1583.0 |
| 2022-11-02 04:50:00 | AAPL | Stock | 150.62 | 150.62 | 150.62 | 150.62 | 200.0 |
| 2022-11-02 04:55:00 | AAPL | Stock | 150.65 | 150.65 | 150.6 | 150.6 | 725.0 |
| 2022-11-02 05:00:00 | AAPL | Stock | 150.6 | 150.6 | 150.6 | 150.6 | 600.0 |
| 2022-11-02 05:05:00 | AAPL | Stock | 150.57 | 150.57 | 150.5 | 150.5 | 2250.0 |
| 2022-11-02 05:10:00 | AAPL | Stock | 150.43 | 150.43 | 150.43 | 150.43 | 100.0 |
| 2022-11-02 05:15:00 | AAPL | Stock | 150.49 | 150.49 | 150.49 | 150.49 | 100.0 |
| 2022-11-02 05:20:00 | AAPL | Stock | 150.43 | 150.43 | 150.31 | 150.31 | 1349.0 |
| 2022-11-02 05:25:00 | AAPL | Stock | 150.33 | 150.33 | 150.25 | 150.25 | 3119.0 |
| 2022-11-02 05:30:00 | AAPL | Stock | 150.25 | 150.25 | 150.15 | 150.2 | 520.0 |
| 2022-11-02 05:35:00 | AAPL | Stock | 150.22 | 150.25 | 150.22 | 150.23 | 676.0 |
| 2022-11-02 05:40:00 | AAPL | Stock | 150.28 | 150.28 | 150.28 | 150.28 | 100.0 |
| 2022-11-02 05:45:00 | AAPL | Stock | 150.28 | 150.4 | 150.28 | 150.4 | 983.0 |
| 2022-11-02 05:55:00 | AAPL | Stock | 150.34 | 150.38 | 150.33 | 150.38 | 1381.0 |
| 2022-11-02 06:00:00 | AAPL | Stock | 150.34 | 150.34 | 150.29 | 150.32 | 1136.0 |
| 2022-11-02 06:05:00 | AAPL | Stock | 150.32 | 150.32 | 150.3 | 150.3 | 376.0 |
| 2022-11-02 06:10:00 | AAPL | Stock | 150.3 | 150.31 | 150.3 | 150.31 | 413.0 |
| 2022-11-02 06:20:00 | AAPL | Stock | 150.35 | 150.4 | 150.32 | 150.4 | 1252.0 |
| 2022-11-02 06:25:00 | AAPL | Stock | 150.32 | 150.32 | 150.25 | 150.25 | 5148.0 |
| 2022-11-02 06:30:00 | AAPL | Stock | 150.26 | 150.3 | 150.25 | 150.3 | 614.0 |
| 2022-11-02 06:35:00 | AAPL | Stock | 150.26 | 150.26 | 150.19 | 150.2 | 3529.0 |
| 2022-11-02 06:40:00 | AAPL | Stock | 150.2 | 150.2 | 149.88 | 149.9 | 11931.0 |
| 2022-11-02 06:45:00 | AAPL | Stock | 149.95 | 149.98 | 149.87 | 149.87 | 13806.0 |
| 2022-11-02 06:50:00 | AAPL | Stock | 149.9 | 149.9 | 149.69 | 149.7 | 17421.0 |
| 2022-11-02 06:55:00 | AAPL | Stock | 149.74 | 149.8 | 149.74 | 149.8 | 1710.0 |
| 2022-11-02 07:00:00 | AAPL | Stock | 149.95 | 150.0 | 149.67 | 149.79 | 8700.0 |
| 2022-11-02 07:05:00 | AAPL | Stock | 149.78 | 149.81 | 149.73 | 149.75 | 3976.0 |
| 2022-11-02 07:10:00 | AAPL | Stock | 149.78 | 149.8 | 149.74 | 149.79 | 1052.0 |
| 2022-11-02 07:15:00 | AAPL | Stock | 149.87 | 149.89 | 149.84 | 149.87 | 2808.0 |
| 2022-11-02 07:20:00 | AAPL | Stock | 149.84 | 149.85 | 149.74 | 149.74 | 2981.0 |
| 2022-11-02 07:25:00 | AAPL | Stock | 149.73 | 149.73 | 149.41 | 149.43 | 22201.0 |
| 2022-11-02 07:30:00 | AAPL | Stock | 149.44 | 149.55 | 149.42 | 149.52 | 13783.0 |
| 2022-11-02 07:35:00 | AAPL | Stock | 149.53 | 149.53 | 149.44 | 149.44 | 6296.0 |
| 2022-11-02 07:40:00 | AAPL | Stock | 149.45 | 149.45 | 149.27 | 149.27 | 6900.0 |
| 2022-11-02 07:45:00 | AAPL | Stock | 149.27 | 149.32 | 149.22 | 149.3 | 17926.0 |
| 2022-11-02 07:50:00 | AAPL | Stock | 149.31 | 149.36 | 149.26 | 149.33 | 5534.0 |
| 2022-11-02 07:55:00 | AAPL | Stock | 149.33 | 149.42 | 149.32 | 149.38 | 7361.0 |
| 2022-11-02 08:00:00 | AAPL | Stock | 149.9 | 150.0 | 149.22 | 149.31 | 78584.0 |
| 2022-11-02 08:05:00 | AAPL | Stock | 149.33 | 149.34 | 149.12 | 149.13 | 8306.0 |
| 2022-11-02 08:10:00 | AAPL | Stock | 149.1 | 149.1 | 149.0 | 149.04 | 39200.0 |
| 2022-11-02 08:15:00 | AAPL | Stock | 149.02 | 149.0315 | 148.45 | 148.86 | 27535.0 |
> showing 50 of 420,692 rows — these rows as CSV