PREVIEW / stock_30min / 2025-11-18
file: by_date/stock_30min/2025/2025-11-18.parquet size: 2.2 MB rows: 102,836 symbols: 211
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-18 04:00:00 | AAPL | Stock | 266.7 | 268.1 | 266.7 | 267.55 | 16477.0 |
| 2025-11-18 04:30:00 | AAPL | Stock | 267.43 | 268.8 | 267.36 | 268.59 | 7972.0 |
| 2025-11-18 05:00:00 | AAPL | Stock | 268.58 | 268.6 | 268.2 | 268.6 | 6348.0 |
| 2025-11-18 05:30:00 | AAPL | Stock | 268.62 | 269.7 | 268.62 | 269.3 | 23378.0 |
| 2025-11-18 06:00:00 | AAPL | Stock | 269.43 | 269.58 | 268.8 | 269.06 | 6166.0 |
| 2025-11-18 06:30:00 | AAPL | Stock | 269.13 | 269.13 | 268.83 | 268.97 | 3980.0 |
| 2025-11-18 07:00:00 | AAPL | Stock | 269.0 | 269.1 | 268.4 | 268.4 | 19198.0 |
| 2025-11-18 07:30:00 | AAPL | Stock | 268.41 | 268.6 | 267.95 | 268.08 | 9173.0 |
| 2025-11-18 08:00:00 | AAPL | Stock | 268.9209 | 269.49 | 266.1 | 268.1 | 69199.0 |
| 2025-11-18 08:30:00 | AAPL | Stock | 268.09 | 269.2 | 268.08 | 268.38 | 38394.0 |
| 2025-11-18 09:00:00 | AAPL | Stock | 268.55 | 270.05 | 267.6 | 269.92 | 119368.0 |
| 2025-11-18 09:30:00 | AAPL | Stock | 269.99 | 270.71 | 266.45 | 266.73 | 4497075.0 |
| 2025-11-18 10:00:00 | AAPL | Stock | 266.725 | 267.95 | 265.32 | 267.65 | 3040657.0 |
| 2025-11-18 10:30:00 | AAPL | Stock | 267.665 | 268.13 | 266.46 | 266.55 | 1485103.0 |
| 2025-11-18 11:00:00 | AAPL | Stock | 266.55 | 268.12 | 266.028 | 267.84 | 1887234.0 |
| 2025-11-18 11:30:00 | AAPL | Stock | 267.84 | 268.338 | 267.27 | 267.7 | 1347702.0 |
| 2025-11-18 12:00:00 | AAPL | Stock | 267.7 | 268.21 | 267.13 | 267.165 | 981702.0 |
| 2025-11-18 12:30:00 | AAPL | Stock | 267.16 | 268.79 | 266.43 | 268.56 | 1057777.0 |
| 2025-11-18 13:00:00 | AAPL | Stock | 268.5786 | 268.93 | 268.02 | 268.45 | 920415.0 |
| 2025-11-18 13:30:00 | AAPL | Stock | 268.43 | 269.22 | 268.17 | 268.27 | 970255.0 |
| 2025-11-18 14:00:00 | AAPL | Stock | 268.27 | 268.74 | 267.96 | 268.0345 | 930871.0 |
| 2025-11-18 14:30:00 | AAPL | Stock | 268.05 | 268.8 | 267.68 | 268.795 | 971656.0 |
| 2025-11-18 15:00:00 | AAPL | Stock | 268.79 | 268.93 | 267.975 | 268.28 | 879871.0 |
| 2025-11-18 15:30:00 | AAPL | Stock | 268.3 | 268.43 | 267.33 | 267.43 | 2788296.0 |
| 2025-11-18 16:00:00 | AAPL | Stock | 267.4098 | 267.95 | 266.69 | 267.11 | 8351026.0 |
| 2025-11-18 16:30:00 | AAPL | Stock | 267.0272 | 267.44 | 266.9725 | 266.9982 | 15189.0 |
| 2025-11-18 17:00:00 | AAPL | Stock | 266.8052 | 267.08 | 266.7863 | 266.99 | 2774.0 |
| 2025-11-18 17:30:00 | AAPL | Stock | 267.0 | 267.0 | 266.77 | 266.9 | 5778.0 |
| 2025-11-18 18:00:00 | AAPL | Stock | 266.95 | 268.05 | 266.95 | 267.76 | 13762.0 |
| 2025-11-18 18:30:00 | AAPL | Stock | 267.96 | 268.0 | 267.54 | 267.55 | 4241.0 |
| 2025-11-18 19:00:00 | AAPL | Stock | 267.78 | 267.78 | 266.55 | 266.76 | 6945.0 |
| 2025-11-18 19:30:00 | AAPL | Stock | 266.77 | 267.48 | 266.75 | 267.29 | 11614.0 |
| 2025-11-18 04:00:00 | MSFT | Stock | 503.8 | 504.56 | 503.0 | 503.66 | 12122.0 |
| 2025-11-18 04:30:00 | MSFT | Stock | 503.71 | 503.76 | 503.01 | 503.65 | 5806.0 |
| 2025-11-18 05:00:00 | MSFT | Stock | 503.65 | 503.66 | 502.65 | 502.7 | 5948.0 |
| 2025-11-18 05:30:00 | MSFT | Stock | 502.71 | 503.01 | 501.02 | 501.86 | 9864.0 |
| 2025-11-18 06:00:00 | MSFT | Stock | 501.78 | 502.25 | 501.26 | 501.4 | 10244.0 |
| 2025-11-18 06:30:00 | MSFT | Stock | 501.3 | 501.38 | 500.22 | 500.82 | 9106.0 |
| 2025-11-18 07:00:00 | MSFT | Stock | 501.09 | 501.14 | 499.14 | 499.54 | 20482.0 |
| 2025-11-18 07:30:00 | MSFT | Stock | 499.67 | 501.04 | 498.28 | 498.5 | 16619.0 |
| 2025-11-18 08:00:00 | MSFT | Stock | 504.23 | 505.42 | 497.0 | 497.35 | 127711.0 |
| 2025-11-18 08:30:00 | MSFT | Stock | 497.48 | 498.57 | 496.25 | 497.1 | 67774.0 |
| 2025-11-18 09:00:00 | MSFT | Stock | 497.28 | 497.5 | 495.0 | 495.1 | 77366.0 |
| 2025-11-18 09:30:00 | MSFT | Stock | 495.365 | 501.01 | 493.06 | 493.99 | 3326635.0 |
| 2025-11-18 10:00:00 | MSFT | Stock | 493.93 | 502.98 | 492.5 | 493.54 | 3043207.0 |
| 2025-11-18 10:30:00 | MSFT | Stock | 493.54 | 494.01 | 489.0 | 489.4 | 1983721.0 |
| 2025-11-18 11:00:00 | MSFT | Stock | 489.395 | 492.66 | 486.78 | 492.24 | 1729553.0 |
| 2025-11-18 11:30:00 | MSFT | Stock | 492.205 | 494.44 | 490.67 | 491.4395 | 1549357.0 |
| 2025-11-18 12:00:00 | MSFT | Stock | 491.48 | 492.16 | 488.63 | 488.8499 | 923517.0 |
| 2025-11-18 12:30:00 | MSFT | Stock | 488.805 | 492.7648 | 487.9 | 492.55 | 984198.0 |
> showing 50 of 102,836 rows — these rows as CSV