PREVIEW / stock_30min / 2025-10-21
file: by_date/stock_30min/2025/2025-10-21.parquet size: 2.3 MB rows: 109,312 symbols: 227
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-21 04:00:00 | AAPL | Stock | 262.26 | 262.26 | 260.91 | 261.58 | 14792.0 |
| 2025-10-21 04:30:00 | AAPL | Stock | 261.35 | 261.96 | 261.35 | 261.41 | 12762.0 |
| 2025-10-21 05:00:00 | AAPL | Stock | 261.6 | 261.8 | 261.43 | 261.47 | 10731.0 |
| 2025-10-21 05:30:00 | AAPL | Stock | 261.7 | 261.89 | 261.56 | 261.78 | 8173.0 |
| 2025-10-21 06:00:00 | AAPL | Stock | 261.87 | 262.05 | 260.69 | 261.16 | 35298.0 |
| 2025-10-21 06:30:00 | AAPL | Stock | 261.19 | 261.4 | 261.03 | 261.31 | 20833.0 |
| 2025-10-21 07:00:00 | AAPL | Stock | 261.35 | 262.029 | 261.35 | 261.65 | 53811.0 |
| 2025-10-21 07:30:00 | AAPL | Stock | 261.6 | 261.83 | 261.55 | 261.809 | 24850.0 |
| 2025-10-21 08:00:00 | AAPL | Stock | 261.11 | 262.57 | 260.75 | 261.85 | 168385.0 |
| 2025-10-21 08:30:00 | AAPL | Stock | 261.88 | 261.88 | 261.45 | 261.45 | 65528.0 |
| 2025-10-21 09:00:00 | AAPL | Stock | 261.44 | 261.9997 | 261.3 | 261.9997 | 146092.0 |
| 2025-10-21 09:30:00 | AAPL | Stock | 261.88 | 265.29 | 261.83 | 263.805 | 9552437.0 |
| 2025-10-21 10:00:00 | AAPL | Stock | 263.79 | 264.64 | 263.22 | 263.4999 | 3071571.0 |
| 2025-10-21 10:30:00 | AAPL | Stock | 263.46 | 263.83 | 262.53 | 263.0499 | 1805243.0 |
| 2025-10-21 11:00:00 | AAPL | Stock | 263.08 | 263.753 | 262.5 | 263.662 | 1537353.0 |
| 2025-10-21 11:30:00 | AAPL | Stock | 263.67 | 264.535 | 263.67 | 264.12 | 1871642.0 |
| 2025-10-21 12:00:00 | AAPL | Stock | 264.11 | 264.387 | 263.0801 | 263.17 | 1408410.0 |
| 2025-10-21 12:30:00 | AAPL | Stock | 263.16 | 263.41 | 262.85 | 263.07 | 984145.0 |
| 2025-10-21 13:00:00 | AAPL | Stock | 263.065 | 263.6799 | 262.835 | 263.3265 | 929153.0 |
| 2025-10-21 13:30:00 | AAPL | Stock | 263.3258 | 263.9 | 263.29 | 263.77 | 867328.0 |
| 2025-10-21 14:00:00 | AAPL | Stock | 263.7783 | 264.055 | 262.15 | 263.4499 | 1637169.0 |
| 2025-10-21 14:30:00 | AAPL | Stock | 263.4496 | 263.7399 | 263.23 | 263.42 | 1028825.0 |
| 2025-10-21 15:00:00 | AAPL | Stock | 263.43 | 263.57 | 262.95 | 263.085 | 1514102.0 |
| 2025-10-21 15:30:00 | AAPL | Stock | 263.09 | 263.21 | 262.47 | 262.84 | 2544607.0 |
| 2025-10-21 16:00:00 | AAPL | Stock | 262.77 | 263.15 | 262.57 | 262.77 | 4725901.0 |
| 2025-10-21 16:30:00 | AAPL | Stock | 262.83 | 263.0 | 262.61 | 262.98 | 13341.0 |
| 2025-10-21 17:00:00 | AAPL | Stock | 262.8501 | 263.0 | 262.71 | 262.85 | 25356.0 |
| 2025-10-21 17:30:00 | AAPL | Stock | 262.71 | 262.91 | 262.65 | 262.66 | 4321.0 |
| 2025-10-21 18:00:00 | AAPL | Stock | 262.73 | 262.73 | 262.5 | 262.6 | 7152.0 |
| 2025-10-21 18:30:00 | AAPL | Stock | 262.64 | 262.66 | 262.605 | 262.66 | 3457.0 |
| 2025-10-21 19:00:00 | AAPL | Stock | 262.63 | 262.66 | 262.5 | 262.5011 | 6558.0 |
| 2025-10-21 19:30:00 | AAPL | Stock | 262.54 | 262.6 | 262.4 | 262.4 | 13167.0 |
| 2025-10-21 04:00:00 | MSFT | Stock | 517.13 | 517.13 | 516.8 | 516.8 | 200.0 |
| 2025-10-21 04:30:00 | MSFT | Stock | 517.01 | 517.01 | 516.93 | 516.93 | 435.0 |
| 2025-10-21 05:00:00 | MSFT | Stock | 516.8 | 516.8 | 516.8 | 516.8 | 125.0 |
| 2025-10-21 05:30:00 | MSFT | Stock | 517.05 | 517.08 | 517.04 | 517.08 | 526.0 |
| 2025-10-21 06:00:00 | MSFT | Stock | 516.94 | 517.17 | 516.94 | 517.17 | 329.0 |
| 2025-10-21 06:30:00 | MSFT | Stock | 517.05 | 517.49 | 517.05 | 517.48 | 424.0 |
| 2025-10-21 07:00:00 | MSFT | Stock | 517.12 | 517.39 | 517.05 | 517.39 | 532.0 |
| 2025-10-21 07:30:00 | MSFT | Stock | 517.27 | 517.27 | 517.0 | 517.1 | 865.0 |
| 2025-10-21 08:00:00 | MSFT | Stock | 517.11 | 517.58 | 516.38 | 517.11 | 8034.0 |
| 2025-10-21 08:30:00 | MSFT | Stock | 516.75 | 517.5 | 516.5168 | 517.15 | 6989.0 |
| 2025-10-21 09:00:00 | MSFT | Stock | 517.5 | 517.72 | 516.9 | 517.72 | 5198.0 |
| 2025-10-21 09:30:00 | MSFT | Stock | 517.79 | 518.69 | 516.23 | 517.88 | 969328.0 |
| 2025-10-21 10:00:00 | MSFT | Stock | 517.99 | 518.28 | 514.75 | 514.855 | 631175.0 |
| 2025-10-21 10:30:00 | MSFT | Stock | 514.855 | 516.58 | 514.1 | 516.5125 | 517767.0 |
| 2025-10-21 11:00:00 | MSFT | Stock | 516.515 | 517.56 | 515.9 | 516.05 | 457127.0 |
| 2025-10-21 11:30:00 | MSFT | Stock | 516.076 | 516.21 | 515.6 | 515.7646 | 280046.0 |
| 2025-10-21 12:00:00 | MSFT | Stock | 515.765 | 516.14 | 515.55 | 515.73 | 305433.0 |
| 2025-10-21 12:30:00 | MSFT | Stock | 515.73 | 515.8899 | 514.34 | 514.45 | 373247.0 |
> showing 50 of 109,312 rows — these rows as CSV