PREVIEW / stock_30min / 2025-11-19
file: by_date/stock_30min/2025/2025-11-19.parquet size: 2.2 MB rows: 103,068 symbols: 209
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-19 04:00:00 | AAPL | Stock | 267.19 | 267.19 | 266.43 | 266.56 | 4104.0 |
| 2025-11-19 04:30:00 | AAPL | Stock | 266.82 | 267.29 | 266.82 | 267.29 | 1955.0 |
| 2025-11-19 05:00:00 | AAPL | Stock | 267.3 | 267.41 | 267.3 | 267.41 | 203.0 |
| 2025-11-19 05:30:00 | AAPL | Stock | 267.34 | 267.55 | 267.27 | 267.46 | 2599.0 |
| 2025-11-19 06:00:00 | AAPL | Stock | 267.48 | 267.89 | 267.48 | 267.89 | 5649.0 |
| 2025-11-19 06:30:00 | AAPL | Stock | 267.69 | 267.85 | 267.31 | 267.51 | 2202.0 |
| 2025-11-19 07:00:00 | AAPL | Stock | 267.56 | 267.6 | 267.12 | 267.12 | 3985.0 |
| 2025-11-19 07:30:00 | AAPL | Stock | 267.18 | 267.43 | 267.11 | 267.24 | 2068.0 |
| 2025-11-19 08:00:00 | AAPL | Stock | 267.48 | 268.0 | 266.16 | 266.77 | 28600.0 |
| 2025-11-19 08:30:00 | AAPL | Stock | 266.77 | 266.8427 | 266.5 | 266.7499 | 10014.0 |
| 2025-11-19 09:00:00 | AAPL | Stock | 266.69 | 266.9988 | 264.65 | 265.5 | 165419.0 |
| 2025-11-19 09:30:00 | AAPL | Stock | 265.54 | 270.91 | 265.5 | 270.885 | 4172634.0 |
| 2025-11-19 10:00:00 | AAPL | Stock | 270.92 | 272.21 | 270.44 | 271.85 | 2250246.0 |
| 2025-11-19 10:30:00 | AAPL | Stock | 271.8501 | 272.01 | 270.0585 | 270.272 | 1319579.0 |
| 2025-11-19 11:00:00 | AAPL | Stock | 270.25 | 270.57 | 269.3201 | 269.73 | 1161031.0 |
| 2025-11-19 11:30:00 | AAPL | Stock | 269.75 | 270.59 | 269.53 | 270.56 | 958913.0 |
| 2025-11-19 12:00:00 | AAPL | Stock | 270.5618 | 270.67 | 269.72 | 270.43 | 888888.0 |
| 2025-11-19 12:30:00 | AAPL | Stock | 270.46 | 271.0 | 269.62 | 270.845 | 989082.0 |
| 2025-11-19 13:00:00 | AAPL | Stock | 270.845 | 271.31 | 270.01 | 270.03 | 992946.0 |
| 2025-11-19 13:30:00 | AAPL | Stock | 270.01 | 271.01 | 269.95 | 270.8 | 834651.0 |
| 2025-11-19 14:00:00 | AAPL | Stock | 270.88 | 270.95 | 269.63 | 269.67 | 718271.0 |
| 2025-11-19 14:30:00 | AAPL | Stock | 269.67 | 270.11 | 269.17 | 269.73 | 868763.0 |
| 2025-11-19 15:00:00 | AAPL | Stock | 269.72 | 270.735 | 269.66 | 269.99 | 1212703.0 |
| 2025-11-19 15:30:00 | AAPL | Stock | 269.975 | 270.33 | 268.14 | 268.5201 | 3971097.0 |
| 2025-11-19 16:00:00 | AAPL | Stock | 268.62 | 269.8999 | 267.7 | 268.85 | 7595026.0 |
| 2025-11-19 16:30:00 | AAPL | Stock | 268.93 | 269.79 | 268.5 | 268.5 | 42369.0 |
| 2025-11-19 17:00:00 | AAPL | Stock | 268.09 | 268.28 | 266.27 | 267.31 | 48574.0 |
| 2025-11-19 17:30:00 | AAPL | Stock | 267.35 | 267.9 | 267.01 | 267.77 | 20148.0 |
| 2025-11-19 18:00:00 | AAPL | Stock | 267.99 | 269.18 | 267.99 | 268.538 | 25357.0 |
| 2025-11-19 18:30:00 | AAPL | Stock | 268.55 | 269.01 | 268.52 | 269.0 | 8809.0 |
| 2025-11-19 19:00:00 | AAPL | Stock | 269.11 | 269.85 | 268.91 | 269.85 | 6805.0 |
| 2025-11-19 19:30:00 | AAPL | Stock | 269.84 | 270.0 | 269.03 | 269.65 | 18364.0 |
| 2025-11-19 04:00:00 | MSFT | Stock | 492.6 | 493.0 | 492.06 | 493.0 | 3751.0 |
| 2025-11-19 04:30:00 | MSFT | Stock | 493.5 | 494.27 | 493.29 | 494.0 | 2619.0 |
| 2025-11-19 05:00:00 | MSFT | Stock | 494.17 | 494.4 | 493.83 | 494.24 | 2483.0 |
| 2025-11-19 05:30:00 | MSFT | Stock | 494.25 | 494.35 | 493.98 | 494.05 | 3760.0 |
| 2025-11-19 06:00:00 | MSFT | Stock | 494.0 | 495.45 | 494.0 | 494.79 | 7441.0 |
| 2025-11-19 06:30:00 | MSFT | Stock | 494.5 | 494.5 | 494.16 | 494.16 | 2545.0 |
| 2025-11-19 07:00:00 | MSFT | Stock | 494.15 | 494.28 | 492.82 | 493.33 | 11484.0 |
| 2025-11-19 07:30:00 | MSFT | Stock | 493.7 | 494.0 | 492.93 | 492.93 | 5177.0 |
| 2025-11-19 08:00:00 | MSFT | Stock | 492.95 | 495.22 | 491.7 | 492.87 | 33352.0 |
| 2025-11-19 08:30:00 | MSFT | Stock | 493.0 | 493.1194 | 492.42 | 492.5 | 16235.0 |
| 2025-11-19 09:00:00 | MSFT | Stock | 492.37 | 492.69 | 488.34 | 489.93 | 68184.0 |
| 2025-11-19 09:30:00 | MSFT | Stock | 490.1 | 494.87 | 488.95 | 494.67 | 2052179.0 |
| 2025-11-19 10:00:00 | MSFT | Stock | 494.73 | 495.1872 | 493.46 | 494.7 | 960505.0 |
| 2025-11-19 10:30:00 | MSFT | Stock | 494.685 | 494.85 | 487.83 | 488.25 | 994770.0 |
| 2025-11-19 11:00:00 | MSFT | Stock | 488.23 | 489.73 | 487.93 | 489.1951 | 768792.0 |
| 2025-11-19 11:30:00 | MSFT | Stock | 489.11 | 489.61 | 487.625 | 488.85 | 547896.0 |
| 2025-11-19 12:00:00 | MSFT | Stock | 488.82 | 489.1613 | 486.125 | 487.3713 | 977472.0 |
| 2025-11-19 12:30:00 | MSFT | Stock | 487.37 | 487.4 | 484.18 | 485.755 | 1106233.0 |
> showing 50 of 103,068 rows — these rows as CSV