PREVIEW / stock_30min / 2025-09-30
file: by_date/stock_30min/2025/2025-09-30.parquet size: 2.3 MB rows: 109,965 symbols: 300
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-09-30 04:00:00 | AAPL | Stock | 253.55 | 253.74 | 253.23 | 253.48 | 4764.0 |
| 2025-09-30 04:30:00 | AAPL | Stock | 253.6 | 253.73 | 253.52 | 253.73 | 1262.0 |
| 2025-09-30 05:00:00 | AAPL | Stock | 253.57 | 253.58 | 253.42 | 253.58 | 1250.0 |
| 2025-09-30 05:30:00 | AAPL | Stock | 253.62 | 253.65 | 253.42 | 253.55 | 1254.0 |
| 2025-09-30 06:00:00 | AAPL | Stock | 253.61 | 253.61 | 253.46 | 253.46 | 602.0 |
| 2025-09-30 06:30:00 | AAPL | Stock | 253.45 | 253.58 | 253.45 | 253.53 | 1999.0 |
| 2025-09-30 07:00:00 | AAPL | Stock | 253.56 | 253.69 | 253.54 | 253.6 | 9528.0 |
| 2025-09-30 07:30:00 | AAPL | Stock | 253.75 | 253.85 | 253.7 | 253.75 | 6638.0 |
| 2025-09-30 08:00:00 | AAPL | Stock | 254.43 | 254.43 | 253.21 | 253.9 | 42757.0 |
| 2025-09-30 08:30:00 | AAPL | Stock | 253.9 | 254.0 | 253.8 | 253.86 | 5229.0 |
| 2025-09-30 09:00:00 | AAPL | Stock | 253.79 | 254.92 | 253.58 | 254.88 | 37635.0 |
| 2025-09-30 09:30:00 | AAPL | Stock | 254.89 | 255.64 | 253.96 | 255.49 | 3826218.0 |
| 2025-09-30 10:00:00 | AAPL | Stock | 255.48 | 255.919 | 254.58 | 254.8862 | 1931145.0 |
| 2025-09-30 10:30:00 | AAPL | Stock | 254.91 | 255.52 | 254.77 | 255.5 | 1288289.0 |
| 2025-09-30 11:00:00 | AAPL | Stock | 255.5 | 255.675 | 253.8201 | 254.22 | 1411907.0 |
| 2025-09-30 11:30:00 | AAPL | Stock | 254.21 | 254.89 | 254.1601 | 254.69 | 941143.0 |
| 2025-09-30 12:00:00 | AAPL | Stock | 254.69 | 254.98 | 254.38 | 254.5351 | 676606.0 |
| 2025-09-30 12:30:00 | AAPL | Stock | 254.5506 | 254.67 | 254.035 | 254.0799 | 692963.0 |
| 2025-09-30 13:00:00 | AAPL | Stock | 254.065 | 254.25 | 253.3117 | 253.735 | 1166722.0 |
| 2025-09-30 13:30:00 | AAPL | Stock | 253.75 | 253.99 | 253.6 | 253.725 | 711386.0 |
| 2025-09-30 14:00:00 | AAPL | Stock | 253.72 | 253.9499 | 253.11 | 253.34 | 1005376.0 |
| 2025-09-30 14:30:00 | AAPL | Stock | 253.34 | 254.24 | 253.271 | 254.19 | 989773.0 |
| 2025-09-30 15:00:00 | AAPL | Stock | 254.195 | 254.24 | 253.5 | 253.95 | 1104737.0 |
| 2025-09-30 15:30:00 | AAPL | Stock | 253.96 | 255.18 | 253.81 | 254.56 | 3221274.0 |
| 2025-09-30 16:00:00 | AAPL | Stock | 254.53 | 254.76 | 254.03 | 254.11 | 9675307.0 |
| 2025-09-30 16:30:00 | AAPL | Stock | 254.11 | 254.63 | 254.0818 | 254.63 | 11521.0 |
| 2025-09-30 17:00:00 | AAPL | Stock | 254.08 | 254.16 | 254.0 | 254.1464 | 7134.0 |
| 2025-09-30 17:30:00 | AAPL | Stock | 254.0003 | 254.1342 | 254.0 | 254.02 | 2093.0 |
| 2025-09-30 18:00:00 | AAPL | Stock | 254.15 | 254.2 | 253.95 | 254.05 | 6162.0 |
| 2025-09-30 18:30:00 | AAPL | Stock | 254.13 | 254.15 | 253.6 | 253.6 | 7807.0 |
| 2025-09-30 19:00:00 | AAPL | Stock | 253.62 | 253.89 | 253.5601 | 253.6255 | 3529.0 |
| 2025-09-30 19:30:00 | AAPL | Stock | 253.6413 | 253.8 | 253.51 | 253.51 | 10284.0 |
| 2025-09-30 04:00:00 | MSFT | Stock | 513.23 | 513.66 | 513.23 | 513.66 | 304.0 |
| 2025-09-30 04:30:00 | MSFT | Stock | 513.95 | 513.95 | 513.95 | 513.95 | 100.0 |
| 2025-09-30 05:00:00 | MSFT | Stock | 513.83 | 513.83 | 513.6 | 513.6 | 451.0 |
| 2025-09-30 06:00:00 | MSFT | Stock | 513.26 | 513.26 | 513.26 | 513.26 | 250.0 |
| 2025-09-30 06:30:00 | MSFT | Stock | 513.15 | 513.15 | 513.15 | 513.15 | 100.0 |
| 2025-09-30 07:00:00 | MSFT | Stock | 513.85 | 513.86 | 513.67 | 513.67 | 920.0 |
| 2025-09-30 07:30:00 | MSFT | Stock | 513.68 | 513.68 | 513.68 | 513.68 | 100.0 |
| 2025-09-30 08:00:00 | MSFT | Stock | 514.6 | 514.68 | 513.0 | 513.85 | 8242.0 |
| 2025-09-30 08:30:00 | MSFT | Stock | 513.99 | 514.83 | 513.85 | 514.31 | 5956.0 |
| 2025-09-30 09:00:00 | MSFT | Stock | 514.4 | 514.6 | 512.55 | 513.1 | 11718.0 |
| 2025-09-30 09:30:00 | MSFT | Stock | 513.14 | 513.48 | 509.66 | 512.73 | 1192858.0 |
| 2025-09-30 10:00:00 | MSFT | Stock | 512.68 | 513.8 | 512.33 | 513.0547 | 495322.0 |
| 2025-09-30 10:30:00 | MSFT | Stock | 513.05 | 516.84 | 512.91 | 516.709 | 709783.0 |
| 2025-09-30 11:00:00 | MSFT | Stock | 516.66 | 517.63 | 514.65 | 514.65 | 706722.0 |
| 2025-09-30 11:30:00 | MSFT | Stock | 514.66 | 515.96 | 514.53 | 515.94 | 449932.0 |
| 2025-09-30 12:00:00 | MSFT | Stock | 515.9 | 516.8 | 515.13 | 515.865 | 252631.0 |
| 2025-09-30 12:30:00 | MSFT | Stock | 515.95 | 516.01 | 515.08 | 515.48 | 233945.0 |
| 2025-09-30 13:00:00 | MSFT | Stock | 515.48 | 515.73 | 514.575 | 514.96 | 329737.0 |
> showing 50 of 109,965 rows — these rows as CSV