PREVIEW / stock_30min / 2025-10-29
file: by_date/stock_30min/2025/2025-10-29.parquet size: 2.3 MB rows: 111,187 symbols: 222
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-29 04:00:00 | AAPL | Stock | 269.4 | 269.7 | 268.38 | 269.02 | 17455.0 |
| 2025-10-29 04:30:00 | AAPL | Stock | 269.07 | 269.09 | 268.6 | 268.65 | 5645.0 |
| 2025-10-29 05:00:00 | AAPL | Stock | 268.55 | 268.72 | 268.12 | 268.27 | 13320.0 |
| 2025-10-29 05:30:00 | AAPL | Stock | 268.23 | 270.0 | 268.23 | 269.84 | 101485.0 |
| 2025-10-29 06:00:00 | AAPL | Stock | 269.84 | 270.34 | 269.51 | 270.32 | 29764.0 |
| 2025-10-29 06:30:00 | AAPL | Stock | 269.92 | 269.92 | 269.55 | 269.58 | 9642.0 |
| 2025-10-29 07:00:00 | AAPL | Stock | 269.64 | 269.88 | 269.27 | 269.8 | 34330.0 |
| 2025-10-29 07:30:00 | AAPL | Stock | 269.85 | 269.86 | 269.4 | 269.64 | 21987.0 |
| 2025-10-29 08:00:00 | AAPL | Stock | 269.55 | 270.34 | 268.12 | 269.4 | 124154.0 |
| 2025-10-29 08:30:00 | AAPL | Stock | 269.4 | 269.41 | 268.92 | 269.2 | 42410.0 |
| 2025-10-29 09:00:00 | AAPL | Stock | 269.2893 | 269.48 | 268.61 | 269.26 | 79808.0 |
| 2025-10-29 09:30:00 | AAPL | Stock | 269.37 | 271.3 | 268.7 | 270.91 | 4798739.0 |
| 2025-10-29 10:00:00 | AAPL | Stock | 270.94 | 271.41 | 270.18 | 270.42 | 1909999.0 |
| 2025-10-29 10:30:00 | AAPL | Stock | 270.41 | 270.45 | 268.615 | 268.85 | 2484038.0 |
| 2025-10-29 11:00:00 | AAPL | Stock | 268.84 | 269.21 | 267.5122 | 267.63 | 2297089.0 |
| 2025-10-29 11:30:00 | AAPL | Stock | 267.62 | 268.17 | 267.11 | 267.77 | 1519651.0 |
| 2025-10-29 12:00:00 | AAPL | Stock | 267.78 | 268.86 | 267.7 | 268.62 | 961892.0 |
| 2025-10-29 12:30:00 | AAPL | Stock | 268.603 | 269.11 | 268.4701 | 268.87 | 946809.0 |
| 2025-10-29 13:00:00 | AAPL | Stock | 268.88 | 269.94 | 268.8683 | 269.9301 | 1460641.0 |
| 2025-10-29 13:30:00 | AAPL | Stock | 269.89 | 270.66 | 269.79 | 270.445 | 2168114.0 |
| 2025-10-29 14:00:00 | AAPL | Stock | 270.47 | 270.85 | 270.0616 | 270.8 | 1802493.0 |
| 2025-10-29 14:30:00 | AAPL | Stock | 270.785 | 270.93 | 268.6 | 269.51 | 2271831.0 |
| 2025-10-29 15:00:00 | AAPL | Stock | 269.5299 | 269.63 | 268.26 | 268.32 | 1355157.0 |
| 2025-10-29 15:30:00 | AAPL | Stock | 268.3 | 270.38 | 267.8 | 269.71 | 3251904.0 |
| 2025-10-29 16:00:00 | AAPL | Stock | 269.83 | 269.84 | 269.0 | 269.8 | 5118336.0 |
| 2025-10-29 16:30:00 | AAPL | Stock | 269.8296 | 270.2 | 269.6225 | 270.0693 | 71786.0 |
| 2025-10-29 17:00:00 | AAPL | Stock | 269.97 | 270.2 | 269.9 | 270.05 | 37356.0 |
| 2025-10-29 17:30:00 | AAPL | Stock | 270.03 | 270.25 | 269.98 | 270.06 | 31197.0 |
| 2025-10-29 18:00:00 | AAPL | Stock | 270.24 | 270.5 | 270.0 | 270.0 | 33428.0 |
| 2025-10-29 18:30:00 | AAPL | Stock | 270.0 | 270.37 | 270.0 | 270.23 | 12371.0 |
| 2025-10-29 19:00:00 | AAPL | Stock | 270.26 | 270.5 | 270.15 | 270.5 | 14277.0 |
| 2025-10-29 19:30:00 | AAPL | Stock | 270.5 | 270.91 | 270.2301 | 270.91 | 34820.0 |
| 2025-10-29 04:00:00 | MSFT | Stock | 544.65 | 546.49 | 544.18 | 544.38 | 8166.0 |
| 2025-10-29 04:30:00 | MSFT | Stock | 544.56 | 544.56 | 543.61 | 543.92 | 6607.0 |
| 2025-10-29 05:00:00 | MSFT | Stock | 543.55 | 543.97 | 542.89 | 543.89 | 7710.0 |
| 2025-10-29 05:30:00 | MSFT | Stock | 543.76 | 543.76 | 543.0 | 543.18 | 7600.0 |
| 2025-10-29 06:00:00 | MSFT | Stock | 543.3 | 544.1 | 543.11 | 543.85 | 2413.0 |
| 2025-10-29 06:30:00 | MSFT | Stock | 543.43 | 543.9 | 543.2 | 543.4 | 9983.0 |
| 2025-10-29 07:00:00 | MSFT | Stock | 543.97 | 544.6 | 543.45 | 544.3 | 15259.0 |
| 2025-10-29 07:30:00 | MSFT | Stock | 544.2 | 545.3 | 544.2 | 544.5 | 12732.0 |
| 2025-10-29 08:00:00 | MSFT | Stock | 544.6 | 546.2 | 543.1 | 544.24 | 86833.0 |
| 2025-10-29 08:30:00 | MSFT | Stock | 544.3 | 545.0 | 543.44 | 544.94 | 37840.0 |
| 2025-10-29 09:00:00 | MSFT | Stock | 544.81 | 546.9 | 544.45 | 544.61 | 64418.0 |
| 2025-10-29 09:30:00 | MSFT | Stock | 544.95 | 546.27 | 538.23 | 538.74 | 2434825.0 |
| 2025-10-29 10:00:00 | MSFT | Stock | 538.74 | 539.11 | 537.1701 | 538.195 | 970255.0 |
| 2025-10-29 10:30:00 | MSFT | Stock | 538.17 | 538.75 | 537.64 | 537.92 | 727057.0 |
| 2025-10-29 11:00:00 | MSFT | Stock | 537.935 | 539.57 | 537.5 | 537.63 | 890758.0 |
| 2025-10-29 11:30:00 | MSFT | Stock | 537.6 | 539.0 | 536.7287 | 538.655 | 862349.0 |
| 2025-10-29 12:00:00 | MSFT | Stock | 538.64 | 539.42 | 538.235 | 538.405 | 648046.0 |
| 2025-10-29 12:30:00 | MSFT | Stock | 538.405 | 539.39 | 538.11 | 538.83 | 451797.0 |
> showing 50 of 111,187 rows — these rows as CSV