PREVIEW / stock_30min / 2025-07-02
file: by_date/stock_30min/2025/2025-07-02.parquet size: 2.2 MB rows: 105,837 symbols: 379
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 |
|---|---|---|---|---|---|---|---|
| 2025-07-02 04:00:00 | AAPL | Stock | 209.38 | 209.62 | 209.01 | 209.5 | 17589.0 |
| 2025-07-02 04:30:00 | AAPL | Stock | 209.44 | 209.44 | 209.05 | 209.19 | 4377.0 |
| 2025-07-02 05:00:00 | AAPL | Stock | 209.28 | 209.39 | 209.21 | 209.39 | 9406.0 |
| 2025-07-02 05:30:00 | AAPL | Stock | 209.39 | 209.55 | 209.28 | 209.46 | 7688.0 |
| 2025-07-02 06:00:00 | AAPL | Stock | 209.49 | 209.57 | 209.45 | 209.5 | 11927.0 |
| 2025-07-02 06:30:00 | AAPL | Stock | 209.5 | 209.5 | 209.3 | 209.34 | 17152.0 |
| 2025-07-02 07:00:00 | AAPL | Stock | 209.35 | 209.6 | 209.2 | 209.6 | 64874.0 |
| 2025-07-02 07:30:00 | AAPL | Stock | 209.6 | 210.32 | 209.58 | 210.05 | 56636.0 |
| 2025-07-02 08:00:00 | AAPL | Stock | 210.11 | 210.92 | 209.18 | 210.6 | 396016.0 |
| 2025-07-02 08:30:00 | AAPL | Stock | 210.6 | 210.6 | 209.57 | 209.64 | 151990.0 |
| 2025-07-02 09:00:00 | AAPL | Stock | 209.6982 | 209.86 | 208.78 | 208.98 | 205761.0 |
| 2025-07-02 09:30:00 | AAPL | Stock | 208.99 | 213.34 | 208.14 | 212.62 | 12880897.0 |
| 2025-07-02 10:00:00 | AAPL | Stock | 212.625 | 212.97 | 211.2737 | 212.3 | 6213871.0 |
| 2025-07-02 10:30:00 | AAPL | Stock | 212.28 | 212.85 | 211.46 | 211.91 | 3816915.0 |
| 2025-07-02 11:00:00 | AAPL | Stock | 211.92 | 212.59 | 211.42 | 211.475 | 2848897.0 |
| 2025-07-02 11:30:00 | AAPL | Stock | 211.48 | 212.02 | 211.23 | 211.55 | 2313994.0 |
| 2025-07-02 12:00:00 | AAPL | Stock | 211.56 | 211.9188 | 210.86 | 210.9203 | 2577844.0 |
| 2025-07-02 12:30:00 | AAPL | Stock | 210.92 | 211.25 | 210.22 | 211.105 | 2285682.0 |
| 2025-07-02 13:00:00 | AAPL | Stock | 211.1 | 211.35 | 210.43 | 210.805 | 1704949.0 |
| 2025-07-02 13:30:00 | AAPL | Stock | 210.81 | 211.72 | 210.74 | 211.61 | 1583411.0 |
| 2025-07-02 14:00:00 | AAPL | Stock | 211.61 | 211.77 | 211.16 | 211.58 | 1242195.0 |
| 2025-07-02 14:30:00 | AAPL | Stock | 211.575 | 212.5 | 211.37 | 212.27 | 2237638.0 |
| 2025-07-02 15:00:00 | AAPL | Stock | 212.27 | 212.96 | 211.84 | 211.945 | 3276332.0 |
| 2025-07-02 15:30:00 | AAPL | Stock | 211.94 | 212.75 | 211.93 | 212.41 | 4829921.0 |
| 2025-07-02 16:00:00 | AAPL | Stock | 212.35 | 212.64 | 212.0 | 212.0817 | 5165251.0 |
| 2025-07-02 16:30:00 | AAPL | Stock | 212.09 | 212.44 | 211.85 | 211.86 | 106137.0 |
| 2025-07-02 17:00:00 | AAPL | Stock | 211.84 | 212.44 | 211.83 | 211.9 | 22058.0 |
| 2025-07-02 17:30:00 | AAPL | Stock | 211.9 | 212.1 | 211.89 | 212.08 | 13211.0 |
| 2025-07-02 18:00:00 | AAPL | Stock | 212.02 | 212.4 | 211.92 | 212.08 | 7843.0 |
| 2025-07-02 18:30:00 | AAPL | Stock | 211.93 | 212.08 | 211.93 | 212.002 | 4883.0 |
| 2025-07-02 19:00:00 | AAPL | Stock | 212.01 | 212.1 | 212.01 | 212.02 | 9952.0 |
| 2025-07-02 19:30:00 | AAPL | Stock | 212.05 | 212.16 | 212.01 | 212.1111 | 14572.0 |
| 2025-07-02 04:00:00 | MSFT | Stock | 491.57 | 491.57 | 491.41 | 491.41 | 911.0 |
| 2025-07-02 04:30:00 | MSFT | Stock | 491.4 | 491.4 | 491.4 | 491.4 | 222.0 |
| 2025-07-02 05:00:00 | MSFT | Stock | 491.01 | 491.01 | 491.0 | 491.0 | 556.0 |
| 2025-07-02 05:30:00 | MSFT | Stock | 490.94 | 490.94 | 490.88 | 490.9 | 319.0 |
| 2025-07-02 06:00:00 | MSFT | Stock | 490.57 | 490.57 | 490.52 | 490.52 | 200.0 |
| 2025-07-02 06:30:00 | MSFT | Stock | 490.5 | 490.5 | 490.19 | 490.19 | 1900.0 |
| 2025-07-02 07:00:00 | MSFT | Stock | 490.73 | 490.8 | 490.69 | 490.8 | 1076.0 |
| 2025-07-02 07:30:00 | MSFT | Stock | 490.69 | 490.71 | 489.05 | 489.43 | 10016.0 |
| 2025-07-02 08:00:00 | MSFT | Stock | 489.64 | 491.0 | 488.78 | 489.12 | 14609.0 |
| 2025-07-02 08:30:00 | MSFT | Stock | 489.35 | 489.35 | 488.33 | 489.02 | 13174.0 |
| 2025-07-02 09:00:00 | MSFT | Stock | 488.94 | 490.24 | 488.81 | 489.16 | 21516.0 |
| 2025-07-02 09:30:00 | MSFT | Stock | 489.99 | 493.5 | 488.7 | 491.015 | 1418296.0 |
| 2025-07-02 10:00:00 | MSFT | Stock | 490.99 | 491.95 | 490.31 | 491.765 | 620160.0 |
| 2025-07-02 10:30:00 | MSFT | Stock | 491.8 | 492.6487 | 491.12 | 491.81 | 528345.0 |
| 2025-07-02 11:00:00 | MSFT | Stock | 491.81 | 492.76 | 491.81 | 491.935 | 450046.0 |
| 2025-07-02 11:30:00 | MSFT | Stock | 491.96 | 492.39 | 491.24 | 491.68 | 412537.0 |
| 2025-07-02 12:00:00 | MSFT | Stock | 491.68 | 492.69 | 491.64 | 492.176 | 339120.0 |
| 2025-07-02 12:30:00 | MSFT | Stock | 492.15 | 492.21 | 491.2301 | 491.3 | 255493.0 |
> showing 50 of 105,837 rows — these rows as CSV