PREVIEW / stock_30min / 2025-11-07
file: by_date/stock_30min/2025/2025-11-07.parquet size: 2.3 MB rows: 108,838 symbols: 215
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-11-07 04:00:00 | AAPL | Stock | 269.58 | 269.7 | 269.24 | 269.5 | 5044.0 |
| 2025-11-07 04:30:00 | AAPL | Stock | 269.5 | 269.52 | 269.39 | 269.42 | 2680.0 |
| 2025-11-07 05:00:00 | AAPL | Stock | 269.28 | 269.5 | 269.18 | 269.36 | 2117.0 |
| 2025-11-07 05:30:00 | AAPL | Stock | 269.58 | 269.6 | 269.41 | 269.41 | 1994.0 |
| 2025-11-07 06:00:00 | AAPL | Stock | 269.43 | 269.43 | 268.75 | 269.14 | 5290.0 |
| 2025-11-07 06:30:00 | AAPL | Stock | 268.83 | 269.77 | 268.67 | 269.77 | 7273.0 |
| 2025-11-07 07:00:00 | AAPL | Stock | 269.5 | 269.91 | 269.5 | 269.65 | 6227.0 |
| 2025-11-07 07:30:00 | AAPL | Stock | 269.55 | 269.55 | 268.74 | 269.04 | 7693.0 |
| 2025-11-07 08:00:00 | AAPL | Stock | 269.75 | 270.11 | 268.67 | 269.08 | 62464.0 |
| 2025-11-07 08:30:00 | AAPL | Stock | 269.09 | 269.78 | 268.9048 | 269.68 | 30994.0 |
| 2025-11-07 09:00:00 | AAPL | Stock | 269.66 | 269.77 | 268.52 | 269.75 | 54178.0 |
| 2025-11-07 09:30:00 | AAPL | Stock | 269.795 | 270.5 | 267.27 | 270.0 | 4441679.0 |
| 2025-11-07 10:00:00 | AAPL | Stock | 269.93 | 272.29 | 269.8133 | 271.55 | 3097363.0 |
| 2025-11-07 10:30:00 | AAPL | Stock | 271.57 | 271.98 | 270.61 | 270.68 | 1891809.0 |
| 2025-11-07 11:00:00 | AAPL | Stock | 270.655 | 271.21 | 269.48 | 269.53 | 1937258.0 |
| 2025-11-07 11:30:00 | AAPL | Stock | 269.52 | 269.89 | 268.56 | 268.895 | 1553956.0 |
| 2025-11-07 12:00:00 | AAPL | Stock | 268.88 | 269.47 | 268.32 | 269.11 | 1795811.0 |
| 2025-11-07 12:30:00 | AAPL | Stock | 269.115 | 269.15 | 268.27 | 268.7913 | 1134792.0 |
| 2025-11-07 13:00:00 | AAPL | Stock | 268.8 | 269.045 | 268.0588 | 268.45 | 869827.0 |
| 2025-11-07 13:30:00 | AAPL | Stock | 268.435 | 268.66 | 267.6349 | 268.105 | 1089319.0 |
| 2025-11-07 14:00:00 | AAPL | Stock | 268.13 | 268.3504 | 267.095 | 267.25 | 1114421.0 |
| 2025-11-07 14:30:00 | AAPL | Stock | 267.26 | 268.5 | 267.25 | 267.6232 | 1822354.0 |
| 2025-11-07 15:00:00 | AAPL | Stock | 267.6 | 267.86 | 266.77 | 267.7599 | 1843630.0 |
| 2025-11-07 15:30:00 | AAPL | Stock | 267.75 | 268.5899 | 267.62 | 268.54 | 3611629.0 |
| 2025-11-07 16:00:00 | AAPL | Stock | 268.46 | 268.7 | 268.3018 | 268.41 | 7118915.0 |
| 2025-11-07 16:30:00 | AAPL | Stock | 268.4 | 268.55 | 268.39 | 268.4636 | 13936.0 |
| 2025-11-07 17:00:00 | AAPL | Stock | 268.53 | 268.61 | 268.47 | 268.61 | 19679.0 |
| 2025-11-07 17:30:00 | AAPL | Stock | 268.55 | 268.55 | 268.4707 | 268.55 | 5764.0 |
| 2025-11-07 18:00:00 | AAPL | Stock | 268.54 | 268.7 | 268.52 | 268.6999 | 6980.0 |
| 2025-11-07 18:30:00 | AAPL | Stock | 268.69 | 268.7 | 268.5453 | 268.68 | 5684.0 |
| 2025-11-07 19:00:00 | AAPL | Stock | 268.69 | 268.69 | 268.63 | 268.6899 | 2487.0 |
| 2025-11-07 19:30:00 | AAPL | Stock | 268.69 | 268.69 | 268.66 | 268.689 | 4362.0 |
| 2025-11-07 04:00:00 | MSFT | Stock | 497.94 | 498.08 | 497.34 | 497.86 | 7623.0 |
| 2025-11-07 04:30:00 | MSFT | Stock | 497.5 | 497.65 | 496.5 | 496.5 | 2849.0 |
| 2025-11-07 05:00:00 | MSFT | Stock | 496.53 | 497.15 | 495.98 | 496.69 | 2288.0 |
| 2025-11-07 05:30:00 | MSFT | Stock | 496.73 | 496.79 | 496.19 | 496.49 | 5049.0 |
| 2025-11-07 06:00:00 | MSFT | Stock | 496.31 | 496.31 | 494.23 | 494.84 | 11106.0 |
| 2025-11-07 06:30:00 | MSFT | Stock | 494.62 | 495.99 | 494.43 | 495.75 | 8921.0 |
| 2025-11-07 07:00:00 | MSFT | Stock | 495.99 | 496.27 | 495.0 | 495.33 | 10575.0 |
| 2025-11-07 07:30:00 | MSFT | Stock | 495.5 | 495.5 | 494.4 | 494.9 | 12037.0 |
| 2025-11-07 08:00:00 | MSFT | Stock | 498.0 | 498.76 | 494.247 | 496.03 | 73195.0 |
| 2025-11-07 08:30:00 | MSFT | Stock | 495.98 | 497.36 | 495.6 | 496.6865 | 35933.0 |
| 2025-11-07 09:00:00 | MSFT | Stock | 496.6562 | 497.5 | 495.19 | 496.93 | 34225.0 |
| 2025-11-07 09:30:00 | MSFT | Stock | 496.945 | 499.377 | 494.41 | 495.63 | 2495933.0 |
| 2025-11-07 10:00:00 | MSFT | Stock | 495.49 | 496.98 | 493.25 | 496.0284 | 1235112.0 |
| 2025-11-07 10:30:00 | MSFT | Stock | 496.06 | 496.82 | 494.88 | 495.175 | 716954.0 |
| 2025-11-07 11:00:00 | MSFT | Stock | 495.1112 | 495.85 | 493.87 | 495.19 | 817742.0 |
| 2025-11-07 11:30:00 | MSFT | Stock | 495.19 | 495.44 | 494.36 | 495.02 | 597759.0 |
| 2025-11-07 12:00:00 | MSFT | Stock | 495.04 | 495.69 | 494.18 | 494.855 | 696669.0 |
| 2025-11-07 12:30:00 | MSFT | Stock | 494.8 | 495.03 | 493.61 | 494.71 | 513212.0 |
> showing 50 of 108,838 rows — these rows as CSV