PREVIEW / stock_30min / 2025-10-16
file: by_date/stock_30min/2025/2025-10-16.parquet size: 2.3 MB rows: 112,187 symbols: 233
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-16 04:00:00 | AAPL | Stock | 249.88 | 250.25 | 249.81 | 249.81 | 11167.0 |
| 2025-10-16 04:30:00 | AAPL | Stock | 249.99 | 249.99 | 249.78 | 249.9 | 2694.0 |
| 2025-10-16 05:00:00 | AAPL | Stock | 250.04 | 250.22 | 249.78 | 250.0 | 5632.0 |
| 2025-10-16 05:30:00 | AAPL | Stock | 249.71 | 250.24 | 249.71 | 250.24 | 3605.0 |
| 2025-10-16 06:00:00 | AAPL | Stock | 250.35 | 250.64 | 250.25 | 250.45 | 21855.0 |
| 2025-10-16 06:30:00 | AAPL | Stock | 250.5 | 250.5 | 250.05 | 250.25 | 8986.0 |
| 2025-10-16 07:00:00 | AAPL | Stock | 250.14 | 250.36 | 250.0 | 250.0 | 13170.0 |
| 2025-10-16 07:30:00 | AAPL | Stock | 250.0 | 250.03 | 249.87 | 250.02 | 3872.0 |
| 2025-10-16 08:00:00 | AAPL | Stock | 250.0 | 250.49 | 249.0 | 250.1 | 67123.0 |
| 2025-10-16 08:30:00 | AAPL | Stock | 250.1 | 250.5754 | 250.05 | 250.43 | 17795.0 |
| 2025-10-16 09:00:00 | AAPL | Stock | 250.44 | 250.4995 | 247.45 | 248.31 | 298562.0 |
| 2025-10-16 09:30:00 | AAPL | Stock | 248.28 | 248.38 | 246.18 | 247.51 | 5061546.0 |
| 2025-10-16 10:00:00 | AAPL | Stock | 247.56 | 247.73 | 246.86 | 247.51 | 2216379.0 |
| 2025-10-16 10:30:00 | AAPL | Stock | 247.49 | 248.91 | 247.4817 | 248.6 | 2090090.0 |
| 2025-10-16 11:00:00 | AAPL | Stock | 248.62 | 249.04 | 247.89 | 248.19 | 1573942.0 |
| 2025-10-16 11:30:00 | AAPL | Stock | 248.17 | 248.6631 | 247.5017 | 247.97 | 1066888.0 |
| 2025-10-16 12:00:00 | AAPL | Stock | 247.96 | 248.2 | 247.03 | 247.72 | 1325716.0 |
| 2025-10-16 12:30:00 | AAPL | Stock | 247.72 | 247.72 | 246.04 | 247.65 | 1606146.0 |
| 2025-10-16 13:00:00 | AAPL | Stock | 247.65 | 247.7721 | 246.58 | 247.22 | 995589.0 |
| 2025-10-16 13:30:00 | AAPL | Stock | 247.22 | 247.45 | 246.2 | 246.565 | 932556.0 |
| 2025-10-16 14:00:00 | AAPL | Stock | 246.55 | 246.67 | 245.26 | 245.66 | 1367285.0 |
| 2025-10-16 14:30:00 | AAPL | Stock | 245.64 | 246.96 | 245.13 | 246.605 | 1382047.0 |
| 2025-10-16 15:00:00 | AAPL | Stock | 246.6 | 247.02 | 246.29 | 246.55 | 1259364.0 |
| 2025-10-16 15:30:00 | AAPL | Stock | 246.56 | 247.97 | 246.35 | 247.43 | 2663408.0 |
| 2025-10-16 16:00:00 | AAPL | Stock | 247.519 | 247.8 | 246.92 | 247.2 | 4998146.0 |
| 2025-10-16 16:30:00 | AAPL | Stock | 247.2 | 247.45 | 247.02 | 247.2 | 11775.0 |
| 2025-10-16 17:00:00 | AAPL | Stock | 247.45 | 247.45 | 247.01 | 247.0462 | 27716.0 |
| 2025-10-16 17:30:00 | AAPL | Stock | 247.15 | 247.2 | 247.0234 | 247.15 | 2792.0 |
| 2025-10-16 18:00:00 | AAPL | Stock | 247.2 | 247.6 | 247.01 | 247.1001 | 12392.0 |
| 2025-10-16 18:30:00 | AAPL | Stock | 247.1637 | 247.18 | 246.27 | 246.33 | 7221.0 |
| 2025-10-16 19:00:00 | AAPL | Stock | 246.53 | 246.75 | 246.4 | 246.4 | 4147.0 |
| 2025-10-16 19:30:00 | AAPL | Stock | 246.35 | 246.9429 | 246.26 | 246.61 | 7340.0 |
| 2025-10-16 04:00:00 | MSFT | Stock | 514.34 | 514.62 | 513.6 | 514.15 | 2566.0 |
| 2025-10-16 04:30:00 | MSFT | Stock | 513.81 | 513.81 | 513.81 | 513.81 | 100.0 |
| 2025-10-16 05:00:00 | MSFT | Stock | 514.0 | 514.65 | 513.89 | 514.65 | 2532.0 |
| 2025-10-16 05:30:00 | MSFT | Stock | 514.63 | 515.3 | 514.33 | 515.3 | 4158.0 |
| 2025-10-16 06:00:00 | MSFT | Stock | 515.55 | 516.3 | 515.43 | 515.45 | 3599.0 |
| 2025-10-16 06:30:00 | MSFT | Stock | 515.31 | 515.42 | 514.61 | 514.99 | 2083.0 |
| 2025-10-16 07:00:00 | MSFT | Stock | 515.06 | 515.5 | 515.06 | 515.11 | 2413.0 |
| 2025-10-16 07:30:00 | MSFT | Stock | 515.3 | 515.3 | 515.11 | 515.16 | 1350.0 |
| 2025-10-16 08:00:00 | MSFT | Stock | 515.0 | 515.86 | 512.99 | 514.15 | 18677.0 |
| 2025-10-16 08:30:00 | MSFT | Stock | 514.3 | 515.16 | 514.01 | 514.96 | 7672.0 |
| 2025-10-16 09:00:00 | MSFT | Stock | 514.91 | 515.1 | 511.92 | 512.53 | 27512.0 |
| 2025-10-16 09:30:00 | MSFT | Stock | 512.52 | 515.59 | 511.65 | 514.335 | 1036477.0 |
| 2025-10-16 10:00:00 | MSFT | Stock | 514.355 | 515.5 | 513.0 | 514.88 | 462873.0 |
| 2025-10-16 10:30:00 | MSFT | Stock | 514.98 | 516.85 | 514.6 | 514.995 | 354176.0 |
| 2025-10-16 11:00:00 | MSFT | Stock | 514.94 | 516.3 | 514.2 | 514.34 | 334533.0 |
| 2025-10-16 11:30:00 | MSFT | Stock | 514.29 | 515.0 | 513.4 | 513.74 | 245509.0 |
| 2025-10-16 12:00:00 | MSFT | Stock | 513.65 | 514.2 | 512.1994 | 512.245 | 279401.0 |
| 2025-10-16 12:30:00 | MSFT | Stock | 512.3 | 513.18 | 509.89 | 513.18 | 463722.0 |
> showing 50 of 112,187 rows — these rows as CSV