PREVIEW / stock_30min / 2025-09-05
file: by_date/stock_30min/2025/2025-09-05.parquet size: 2.2 MB rows: 105,483 symbols: 316
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-05 04:00:00 | AAPL | Stock | 239.36 | 239.56 | 239.25 | 239.47 | 8755.0 |
| 2025-09-05 04:30:00 | AAPL | Stock | 239.47 | 239.5 | 239.29 | 239.35 | 2702.0 |
| 2025-09-05 05:00:00 | AAPL | Stock | 239.38 | 239.4 | 239.25 | 239.31 | 4054.0 |
| 2025-09-05 05:30:00 | AAPL | Stock | 239.36 | 239.48 | 239.36 | 239.43 | 3483.0 |
| 2025-09-05 06:00:00 | AAPL | Stock | 239.36 | 239.4 | 239.23 | 239.25 | 2817.0 |
| 2025-09-05 06:30:00 | AAPL | Stock | 239.25 | 239.32 | 239.15 | 239.3 | 4485.0 |
| 2025-09-05 07:00:00 | AAPL | Stock | 239.3 | 239.45 | 239.27 | 239.3 | 13448.0 |
| 2025-09-05 07:30:00 | AAPL | Stock | 239.37 | 239.37 | 239.15 | 239.27 | 6597.0 |
| 2025-09-05 08:00:00 | AAPL | Stock | 239.34 | 240.02 | 238.8312 | 239.1647 | 75689.0 |
| 2025-09-05 08:30:00 | AAPL | Stock | 239.08 | 239.91 | 238.76 | 239.85 | 126434.0 |
| 2025-09-05 09:00:00 | AAPL | Stock | 239.85 | 240.2 | 239.3 | 240.0 | 168543.0 |
| 2025-09-05 09:30:00 | AAPL | Stock | 239.995 | 240.66 | 239.18 | 240.0742 | 6634071.0 |
| 2025-09-05 10:00:00 | AAPL | Stock | 240.085 | 241.32 | 239.12 | 239.285 | 4764126.0 |
| 2025-09-05 10:30:00 | AAPL | Stock | 239.25 | 239.6399 | 238.63 | 238.99 | 2657308.0 |
| 2025-09-05 11:00:00 | AAPL | Stock | 238.99 | 240.17 | 238.79 | 239.805 | 2435157.0 |
| 2025-09-05 11:30:00 | AAPL | Stock | 239.82 | 240.33 | 238.92 | 238.9946 | 2014970.0 |
| 2025-09-05 12:00:00 | AAPL | Stock | 238.99 | 239.265 | 238.52 | 238.77 | 1316991.0 |
| 2025-09-05 12:30:00 | AAPL | Stock | 238.78 | 239.72 | 238.4901 | 239.33 | 1826714.0 |
| 2025-09-05 13:00:00 | AAPL | Stock | 239.3 | 239.73 | 239.15 | 239.625 | 1256857.0 |
| 2025-09-05 13:30:00 | AAPL | Stock | 239.6485 | 239.65 | 238.73 | 238.87 | 1168575.0 |
| 2025-09-05 14:00:00 | AAPL | Stock | 238.86 | 239.24 | 238.85 | 239.12 | 920927.0 |
| 2025-09-05 14:30:00 | AAPL | Stock | 239.12 | 239.98 | 239.1 | 239.955 | 1739919.0 |
| 2025-09-05 15:00:00 | AAPL | Stock | 239.95 | 240.13 | 239.76 | 239.925 | 2248003.0 |
| 2025-09-05 15:30:00 | AAPL | Stock | 239.93 | 240.015 | 239.05 | 239.67 | 3564385.0 |
| 2025-09-05 16:00:00 | AAPL | Stock | 239.68 | 239.86 | 239.51 | 239.62 | 6408992.0 |
| 2025-09-05 16:30:00 | AAPL | Stock | 239.6 | 239.69 | 239.52 | 239.69 | 150585.0 |
| 2025-09-05 17:00:00 | AAPL | Stock | 239.55 | 239.7 | 239.52 | 239.7 | 10564.0 |
| 2025-09-05 17:30:00 | AAPL | Stock | 239.74 | 239.78 | 239.52 | 239.6001 | 6579.0 |
| 2025-09-05 18:00:00 | AAPL | Stock | 239.6 | 239.6 | 239.21 | 239.5 | 8108.0 |
| 2025-09-05 18:30:00 | AAPL | Stock | 239.45 | 239.45 | 239.2 | 239.2 | 6826.0 |
| 2025-09-05 19:00:00 | AAPL | Stock | 239.21 | 239.38 | 239.01 | 239.2 | 7931.0 |
| 2025-09-05 19:30:00 | AAPL | Stock | 239.23 | 239.23 | 239.072 | 239.23 | 6454.0 |
| 2025-09-05 04:00:00 | MSFT | Stock | 508.99 | 510.17 | 508.99 | 510.17 | 2141.0 |
| 2025-09-05 04:30:00 | MSFT | Stock | 510.2 | 510.2 | 509.34 | 509.34 | 2937.0 |
| 2025-09-05 05:00:00 | MSFT | Stock | 509.7 | 509.7 | 509.24 | 509.62 | 587.0 |
| 2025-09-05 05:30:00 | MSFT | Stock | 509.6 | 509.76 | 509.6 | 509.76 | 299.0 |
| 2025-09-05 06:00:00 | MSFT | Stock | 509.55 | 509.64 | 509.55 | 509.64 | 244.0 |
| 2025-09-05 06:30:00 | MSFT | Stock | 509.6 | 509.6 | 509.6 | 509.6 | 291.0 |
| 2025-09-05 07:00:00 | MSFT | Stock | 509.04 | 509.04 | 509.0 | 509.0 | 2351.0 |
| 2025-09-05 07:30:00 | MSFT | Stock | 509.0 | 509.0 | 508.7 | 508.7 | 327.0 |
| 2025-09-05 08:00:00 | MSFT | Stock | 509.66 | 510.49 | 508.25 | 509.06 | 13984.0 |
| 2025-09-05 08:30:00 | MSFT | Stock | 508.7 | 511.9 | 508.25 | 511.9 | 36339.0 |
| 2025-09-05 09:00:00 | MSFT | Stock | 511.71 | 512.3 | 508.82 | 508.9 | 34881.0 |
| 2025-09-05 09:30:00 | MSFT | Stock | 508.81 | 511.97 | 499.91 | 502.465 | 3281664.0 |
| 2025-09-05 10:00:00 | MSFT | Stock | 502.4614 | 502.5256 | 498.17 | 499.21 | 1626923.0 |
| 2025-09-05 10:30:00 | MSFT | Stock | 499.15 | 499.6 | 495.06 | 495.31 | 1291553.0 |
| 2025-09-05 11:00:00 | MSFT | Stock | 495.32 | 497.5279 | 494.5 | 497.115 | 1388514.0 |
| 2025-09-05 11:30:00 | MSFT | Stock | 497.1148 | 497.74 | 496.0 | 496.31 | 821840.0 |
| 2025-09-05 12:00:00 | MSFT | Stock | 496.3 | 497.2 | 495.78 | 496.845 | 450752.0 |
| 2025-09-05 12:30:00 | MSFT | Stock | 496.87 | 497.0104 | 494.0 | 495.15 | 961293.0 |
> showing 50 of 105,483 rows — these rows as CSV