PREVIEW / stock_30min / 2025-10-31
file: by_date/stock_30min/2025/2025-10-31.parquet size: 2.2 MB rows: 108,321 symbols: 219
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-10-31 04:00:00 | AAPL | Stock | 278.12 | 278.75 | 275.0 | 277.41 | 34818.0 |
| 2025-10-31 04:30:00 | AAPL | Stock | 277.4 | 277.5 | 275.71 | 276.23 | 56144.0 |
| 2025-10-31 05:00:00 | AAPL | Stock | 276.45 | 277.0 | 276.02 | 276.02 | 15709.0 |
| 2025-10-31 05:30:00 | AAPL | Stock | 276.25 | 276.5 | 275.56 | 276.17 | 25652.0 |
| 2025-10-31 06:00:00 | AAPL | Stock | 276.44 | 276.77 | 275.82 | 276.15 | 14716.0 |
| 2025-10-31 06:30:00 | AAPL | Stock | 276.18 | 277.02 | 276.14 | 276.75 | 16901.0 |
| 2025-10-31 07:00:00 | AAPL | Stock | 276.75 | 277.72 | 276.31 | 277.68 | 83912.0 |
| 2025-10-31 07:30:00 | AAPL | Stock | 277.7 | 278.0 | 276.65 | 277.11 | 116149.0 |
| 2025-10-31 08:00:00 | AAPL | Stock | 278.2 | 279.5 | 275.6 | 278.21 | 327815.0 |
| 2025-10-31 08:30:00 | AAPL | Stock | 278.2984 | 278.35 | 276.55 | 276.9 | 180336.0 |
| 2025-10-31 09:00:00 | AAPL | Stock | 276.91 | 277.69 | 275.98 | 277.0 | 496518.0 |
| 2025-10-31 09:30:00 | AAPL | Stock | 276.99 | 277.32 | 269.16 | 270.437 | 11783632.0 |
| 2025-10-31 10:00:00 | AAPL | Stock | 270.435 | 270.72 | 269.16 | 270.36 | 3717580.0 |
| 2025-10-31 10:30:00 | AAPL | Stock | 270.43 | 271.5599 | 270.1001 | 270.59 | 2605455.0 |
| 2025-10-31 11:00:00 | AAPL | Stock | 270.6 | 271.52 | 270.39 | 271.3 | 2031052.0 |
| 2025-10-31 11:30:00 | AAPL | Stock | 271.2999 | 271.55 | 270.22 | 271.45 | 2057287.0 |
| 2025-10-31 12:00:00 | AAPL | Stock | 271.44 | 272.8585 | 270.73 | 272.435 | 2396684.0 |
| 2025-10-31 12:30:00 | AAPL | Stock | 272.44 | 273.17 | 271.48 | 271.62 | 2352756.0 |
| 2025-10-31 13:00:00 | AAPL | Stock | 271.64 | 271.79 | 270.15 | 270.3488 | 1767794.0 |
| 2025-10-31 13:30:00 | AAPL | Stock | 270.33 | 271.61 | 270.11 | 271.37 | 1157506.0 |
| 2025-10-31 14:00:00 | AAPL | Stock | 271.36 | 272.0599 | 271.2205 | 271.81 | 1203425.0 |
| 2025-10-31 14:30:00 | AAPL | Stock | 271.79 | 272.12 | 271.27 | 271.67 | 1164134.0 |
| 2025-10-31 15:00:00 | AAPL | Stock | 271.7 | 272.175 | 271.38 | 272.105 | 1654555.0 |
| 2025-10-31 15:30:00 | AAPL | Stock | 272.11 | 272.65 | 269.96 | 270.25 | 6725116.0 |
| 2025-10-31 16:00:00 | AAPL | Stock | 270.25 | 271.32 | 270.24 | 270.6925 | 11593979.0 |
| 2025-10-31 16:30:00 | AAPL | Stock | 270.75 | 270.7984 | 270.2499 | 270.404 | 37585.0 |
| 2025-10-31 17:00:00 | AAPL | Stock | 270.4001 | 270.45 | 270.02 | 270.33 | 25935.0 |
| 2025-10-31 17:30:00 | AAPL | Stock | 270.05 | 270.35 | 270.0 | 270.25 | 19571.0 |
| 2025-10-31 18:00:00 | AAPL | Stock | 270.26 | 270.26 | 270.0906 | 270.1999 | 18479.0 |
| 2025-10-31 18:30:00 | AAPL | Stock | 270.17 | 270.22 | 270.01 | 270.0106 | 10842.0 |
| 2025-10-31 19:00:00 | AAPL | Stock | 270.1 | 270.14 | 270.0 | 270.06 | 8944.0 |
| 2025-10-31 19:30:00 | AAPL | Stock | 270.05 | 270.05 | 269.9 | 270.04 | 18193.0 |
| 2025-10-31 04:00:00 | MSFT | Stock | 527.53 | 527.85 | 525.85 | 526.46 | 5466.0 |
| 2025-10-31 04:30:00 | MSFT | Stock | 526.6 | 527.8 | 526.6 | 527.8 | 3511.0 |
| 2025-10-31 05:00:00 | MSFT | Stock | 527.4 | 528.08 | 527.4 | 528.06 | 11073.0 |
| 2025-10-31 05:30:00 | MSFT | Stock | 528.0 | 528.0 | 527.3 | 527.95 | 14402.0 |
| 2025-10-31 06:00:00 | MSFT | Stock | 527.76 | 528.08 | 527.58 | 527.7 | 3062.0 |
| 2025-10-31 06:30:00 | MSFT | Stock | 527.76 | 528.11 | 527.44 | 527.44 | 6606.0 |
| 2025-10-31 07:00:00 | MSFT | Stock | 527.64 | 528.29 | 527.26 | 528.29 | 18626.0 |
| 2025-10-31 07:30:00 | MSFT | Stock | 528.17 | 528.45 | 528.17 | 528.28 | 3915.0 |
| 2025-10-31 08:00:00 | MSFT | Stock | 527.53 | 530.5146 | 526.01 | 530.31 | 76535.0 |
| 2025-10-31 08:30:00 | MSFT | Stock | 530.15 | 530.3 | 528.6 | 529.41 | 29992.0 |
| 2025-10-31 09:00:00 | MSFT | Stock | 529.3 | 530.8802 | 528.5011 | 529.11 | 39870.0 |
| 2025-10-31 09:30:00 | MSFT | Stock | 528.875 | 529.32 | 517.82 | 519.24 | 2790769.0 |
| 2025-10-31 10:00:00 | MSFT | Stock | 519.27 | 519.575 | 515.1 | 518.0 | 2403309.0 |
| 2025-10-31 10:30:00 | MSFT | Stock | 517.92 | 521.0 | 517.5 | 520.94 | 1258975.0 |
| 2025-10-31 11:00:00 | MSFT | Stock | 520.9175 | 522.0 | 519.06 | 519.395 | 967164.0 |
| 2025-10-31 11:30:00 | MSFT | Stock | 519.47 | 520.44 | 516.46 | 516.644 | 1243400.0 |
| 2025-10-31 12:00:00 | MSFT | Stock | 516.59 | 517.842 | 515.9 | 517.6899 | 765268.0 |
| 2025-10-31 12:30:00 | MSFT | Stock | 517.625 | 518.6396 | 517.0 | 517.265 | 547099.0 |
> showing 50 of 108,321 rows — these rows as CSV