PREVIEW / stock_30min / 2025-11-14
file: by_date/stock_30min/2025/2025-11-14.parquet size: 2.2 MB rows: 106,605 symbols: 213
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-14 04:00:00 | AAPL | Stock | 273.25 | 273.52 | 272.52 | 273.07 | 11408.0 |
| 2025-11-14 04:30:00 | AAPL | Stock | 273.05 | 273.18 | 272.59 | 272.59 | 6913.0 |
| 2025-11-14 05:00:00 | AAPL | Stock | 272.56 | 272.78 | 272.54 | 272.78 | 4639.0 |
| 2025-11-14 05:30:00 | AAPL | Stock | 272.96 | 273.15 | 272.22 | 272.36 | 6353.0 |
| 2025-11-14 06:00:00 | AAPL | Stock | 272.32 | 272.32 | 271.76 | 272.1 | 12869.0 |
| 2025-11-14 06:30:00 | AAPL | Stock | 271.92 | 272.3 | 271.64 | 272.3 | 25824.0 |
| 2025-11-14 07:00:00 | AAPL | Stock | 272.27 | 273.0 | 271.92 | 272.82 | 35280.0 |
| 2025-11-14 07:30:00 | AAPL | Stock | 272.69 | 272.69 | 270.71 | 271.46 | 53839.0 |
| 2025-11-14 08:00:00 | AAPL | Stock | 273.32 | 274.37 | 270.58 | 271.05 | 177568.0 |
| 2025-11-14 08:30:00 | AAPL | Stock | 271.13 | 271.74 | 270.5747 | 271.35 | 70968.0 |
| 2025-11-14 09:00:00 | AAPL | Stock | 271.27 | 271.94 | 270.54 | 271.02 | 104932.0 |
| 2025-11-14 09:30:00 | AAPL | Stock | 271.02 | 273.0817 | 269.6 | 273.0 | 5329203.0 |
| 2025-11-14 10:00:00 | AAPL | Stock | 273.0 | 273.89 | 272.16 | 273.7592 | 2489672.0 |
| 2025-11-14 10:30:00 | AAPL | Stock | 273.77 | 274.53 | 273.2 | 274.2455 | 1778597.0 |
| 2025-11-14 11:00:00 | AAPL | Stock | 274.259 | 274.65 | 273.5273 | 274.65 | 1755880.0 |
| 2025-11-14 11:30:00 | AAPL | Stock | 274.645 | 274.9499 | 273.55 | 274.83 | 1980676.0 |
| 2025-11-14 12:00:00 | AAPL | Stock | 274.8 | 275.92 | 274.56 | 275.705 | 1819849.0 |
| 2025-11-14 12:30:00 | AAPL | Stock | 275.71 | 275.96 | 274.8498 | 275.13 | 988055.0 |
| 2025-11-14 13:00:00 | AAPL | Stock | 275.12 | 275.12 | 274.23 | 274.585 | 703306.0 |
| 2025-11-14 13:30:00 | AAPL | Stock | 274.57 | 274.76 | 273.84 | 274.18 | 745317.0 |
| 2025-11-14 14:00:00 | AAPL | Stock | 274.1668 | 274.42 | 273.85 | 273.96 | 675718.0 |
| 2025-11-14 14:30:00 | AAPL | Stock | 273.97 | 274.26 | 273.8 | 274.02 | 664188.0 |
| 2025-11-14 15:00:00 | AAPL | Stock | 274.02 | 274.24 | 272.89 | 272.99 | 1228784.0 |
| 2025-11-14 15:30:00 | AAPL | Stock | 272.97 | 273.28 | 272.17 | 272.6 | 3135844.0 |
| 2025-11-14 16:00:00 | AAPL | Stock | 272.41 | 272.65 | 272.0 | 272.4501 | 6135364.0 |
| 2025-11-14 16:30:00 | AAPL | Stock | 272.452 | 272.6 | 272.41 | 272.47 | 28653.0 |
| 2025-11-14 17:00:00 | AAPL | Stock | 272.59 | 272.59 | 272.47 | 272.47 | 10030.0 |
| 2025-11-14 17:30:00 | AAPL | Stock | 272.4504 | 272.5137 | 272.45 | 272.45 | 8647.0 |
| 2025-11-14 18:00:00 | AAPL | Stock | 272.47 | 272.55 | 272.45 | 272.55 | 9400.0 |
| 2025-11-14 18:30:00 | AAPL | Stock | 272.54 | 272.5899 | 272.51 | 272.58 | 2805.0 |
| 2025-11-14 19:00:00 | AAPL | Stock | 272.57 | 272.7465 | 272.57 | 272.7465 | 8724.0 |
| 2025-11-14 19:30:00 | AAPL | Stock | 272.64 | 272.83 | 272.5375 | 272.8275 | 7656.0 |
| 2025-11-14 04:00:00 | MSFT | Stock | 501.5 | 503.0 | 501.5 | 503.0 | 6125.0 |
| 2025-11-14 04:30:00 | MSFT | Stock | 502.75 | 502.87 | 501.04 | 501.63 | 5124.0 |
| 2025-11-14 05:00:00 | MSFT | Stock | 501.42 | 502.53 | 501.22 | 501.78 | 5657.0 |
| 2025-11-14 05:30:00 | MSFT | Stock | 502.63 | 502.63 | 501.31 | 501.51 | 3022.0 |
| 2025-11-14 06:00:00 | MSFT | Stock | 501.55 | 501.55 | 500.06 | 500.18 | 8169.0 |
| 2025-11-14 06:30:00 | MSFT | Stock | 500.25 | 500.38 | 499.45 | 500.12 | 9277.0 |
| 2025-11-14 07:00:00 | MSFT | Stock | 500.41 | 501.1 | 499.64 | 500.55 | 23080.0 |
| 2025-11-14 07:30:00 | MSFT | Stock | 500.06 | 500.49 | 498.71 | 500.15 | 19796.0 |
| 2025-11-14 08:00:00 | MSFT | Stock | 502.73 | 505.0 | 498.6 | 499.44 | 88810.0 |
| 2025-11-14 08:30:00 | MSFT | Stock | 499.3 | 499.8 | 497.85 | 498.25 | 39496.0 |
| 2025-11-14 09:00:00 | MSFT | Stock | 498.2 | 503.29 | 496.88 | 498.49 | 80103.0 |
| 2025-11-14 09:30:00 | MSFT | Stock | 498.23 | 503.06 | 497.44 | 502.4 | 2295901.0 |
| 2025-11-14 10:00:00 | MSFT | Stock | 502.42 | 506.225 | 501.7 | 505.4173 | 1112805.0 |
| 2025-11-14 10:30:00 | MSFT | Stock | 505.37 | 507.46 | 504.9 | 506.8826 | 936438.0 |
| 2025-11-14 11:00:00 | MSFT | Stock | 506.94 | 509.5 | 505.63 | 509.5 | 814657.0 |
| 2025-11-14 11:30:00 | MSFT | Stock | 509.51 | 510.59 | 508.12 | 510.46 | 820288.0 |
| 2025-11-14 12:00:00 | MSFT | Stock | 510.43 | 511.41 | 509.25 | 509.64 | 643172.0 |
| 2025-11-14 12:30:00 | MSFT | Stock | 509.65 | 509.8999 | 508.06 | 508.35 | 462064.0 |
> showing 50 of 106,605 rows — these rows as CSV