PREVIEW / stock_5min / 2023-06-02
file: by_date/stock_5min/2023/2023-06-02.parquet size: 6.9 MB rows: 422,814 symbols: 1,634
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-06-02 04:00:00 | AAPL | Stock | 180.68 | 180.69 | 180.57 | 180.57 | 3235.0 |
| 2023-06-02 04:05:00 | AAPL | Stock | 180.57 | 180.71 | 180.55 | 180.55 | 4294.0 |
| 2023-06-02 04:10:00 | AAPL | Stock | 180.56 | 180.56 | 180.52 | 180.52 | 728.0 |
| 2023-06-02 04:15:00 | AAPL | Stock | 180.52 | 180.78 | 180.52 | 180.63 | 2262.0 |
| 2023-06-02 04:20:00 | AAPL | Stock | 180.69 | 180.76 | 180.62 | 180.76 | 1169.0 |
| 2023-06-02 04:30:00 | AAPL | Stock | 180.75 | 180.75 | 180.7 | 180.75 | 3836.0 |
| 2023-06-02 04:45:00 | AAPL | Stock | 180.76 | 180.88 | 180.7 | 180.88 | 11390.0 |
| 2023-06-02 04:50:00 | AAPL | Stock | 180.75 | 180.75 | 180.75 | 180.75 | 404.0 |
| 2023-06-02 04:55:00 | AAPL | Stock | 180.92 | 181.02 | 180.92 | 181.02 | 4580.0 |
| 2023-06-02 05:00:00 | AAPL | Stock | 181.0 | 181.0 | 180.95 | 180.95 | 332.0 |
| 2023-06-02 05:10:00 | AAPL | Stock | 180.97 | 181.1 | 180.97 | 181.1 | 2802.0 |
| 2023-06-02 05:15:00 | AAPL | Stock | 181.1 | 181.28 | 181.1 | 181.28 | 1905.0 |
| 2023-06-02 05:20:00 | AAPL | Stock | 181.26 | 181.26 | 181.2 | 181.2 | 3478.0 |
| 2023-06-02 05:25:00 | AAPL | Stock | 181.2 | 181.26 | 181.2 | 181.26 | 3869.0 |
| 2023-06-02 05:30:00 | AAPL | Stock | 181.25 | 181.38 | 181.25 | 181.27 | 2988.0 |
| 2023-06-02 05:35:00 | AAPL | Stock | 181.33 | 181.35 | 181.27 | 181.35 | 2801.0 |
| 2023-06-02 05:40:00 | AAPL | Stock | 181.3 | 181.3 | 181.16 | 181.21 | 3028.0 |
| 2023-06-02 05:45:00 | AAPL | Stock | 181.2 | 181.25 | 181.2 | 181.25 | 411.0 |
| 2023-06-02 05:50:00 | AAPL | Stock | 181.2 | 181.25 | 181.2 | 181.2 | 789.0 |
| 2023-06-02 05:55:00 | AAPL | Stock | 181.25 | 181.25 | 181.21 | 181.25 | 1112.0 |
| 2023-06-02 06:00:00 | AAPL | Stock | 181.25 | 181.29 | 181.22 | 181.22 | 3150.0 |
| 2023-06-02 06:05:00 | AAPL | Stock | 181.3 | 181.3 | 181.22 | 181.26 | 864.0 |
| 2023-06-02 06:10:00 | AAPL | Stock | 181.22 | 181.25 | 181.22 | 181.23 | 764.0 |
| 2023-06-02 06:15:00 | AAPL | Stock | 181.25 | 181.35 | 181.25 | 181.35 | 1417.0 |
| 2023-06-02 06:20:00 | AAPL | Stock | 181.33 | 181.33 | 181.28 | 181.28 | 1622.0 |
| 2023-06-02 06:25:00 | AAPL | Stock | 181.28 | 181.28 | 181.22 | 181.22 | 4269.0 |
| 2023-06-02 06:30:00 | AAPL | Stock | 181.26 | 181.26 | 181.1 | 181.1 | 1485.0 |
| 2023-06-02 06:35:00 | AAPL | Stock | 181.06 | 181.14 | 181.03 | 181.11 | 900.0 |
| 2023-06-02 06:40:00 | AAPL | Stock | 181.11 | 181.15 | 181.08 | 181.1 | 2159.0 |
| 2023-06-02 06:45:00 | AAPL | Stock | 181.05 | 181.1 | 181.05 | 181.1 | 1141.0 |
| 2023-06-02 06:50:00 | AAPL | Stock | 181.07 | 181.07 | 181.01 | 181.03 | 15571.0 |
| 2023-06-02 06:55:00 | AAPL | Stock | 181.05 | 181.1 | 181.02 | 181.09 | 1119.0 |
| 2023-06-02 07:00:00 | AAPL | Stock | 181.01 | 181.18 | 181.0 | 181.03 | 21849.0 |
| 2023-06-02 07:05:00 | AAPL | Stock | 181.07 | 181.18 | 181.06 | 181.18 | 8518.0 |
| 2023-06-02 07:10:00 | AAPL | Stock | 181.16 | 181.32 | 181.12 | 181.21 | 8993.0 |
| 2023-06-02 07:15:00 | AAPL | Stock | 181.21 | 181.21 | 181.11 | 181.17 | 10641.0 |
| 2023-06-02 07:20:00 | AAPL | Stock | 181.16 | 181.38 | 181.16 | 181.34 | 7318.0 |
| 2023-06-02 07:25:00 | AAPL | Stock | 181.31 | 181.45 | 181.3 | 181.45 | 5699.0 |
| 2023-06-02 07:30:00 | AAPL | Stock | 181.45 | 181.45 | 181.3 | 181.34 | 7237.0 |
| 2023-06-02 07:35:00 | AAPL | Stock | 181.33 | 181.35 | 181.24 | 181.25 | 8276.0 |
| 2023-06-02 07:40:00 | AAPL | Stock | 181.33 | 181.35 | 181.2 | 181.24 | 7850.0 |
| 2023-06-02 07:45:00 | AAPL | Stock | 181.2 | 181.35 | 181.15 | 181.15 | 7625.0 |
| 2023-06-02 07:50:00 | AAPL | Stock | 181.17 | 181.32 | 181.16 | 181.3 | 4493.0 |
| 2023-06-02 07:55:00 | AAPL | Stock | 181.31 | 181.32 | 181.28 | 181.31 | 2221.0 |
| 2023-06-02 08:00:00 | AAPL | Stock | 181.04 | 181.45 | 180.5615 | 181.33 | 67450.0 |
| 2023-06-02 08:05:00 | AAPL | Stock | 181.32 | 181.37 | 181.2 | 181.2 | 12226.0 |
| 2023-06-02 08:10:00 | AAPL | Stock | 181.23 | 181.23 | 181.12 | 181.14 | 14348.0 |
| 2023-06-02 08:15:00 | AAPL | Stock | 181.18 | 181.18 | 180.92 | 180.94 | 19856.0 |
| 2023-06-02 08:20:00 | AAPL | Stock | 180.9 | 181.24 | 180.9 | 181.2 | 45071.0 |
| 2023-06-02 08:25:00 | AAPL | Stock | 181.19 | 181.3 | 181.14 | 181.3 | 26417.0 |
> showing 50 of 422,814 rows — these rows as CSV