PREVIEW / stock_30min / 2025-10-10
file: by_date/stock_30min/2025/2025-10-10.parquet size: 2.4 MB rows: 117,165 symbols: 236
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-10 04:00:00 | AAPL | Stock | 253.68 | 254.07 | 253.61 | 253.7 | 6191.0 |
| 2025-10-10 04:30:00 | AAPL | Stock | 253.71 | 253.9 | 253.53 | 253.83 | 2483.0 |
| 2025-10-10 05:00:00 | AAPL | Stock | 253.78 | 253.78 | 253.25 | 253.34 | 5783.0 |
| 2025-10-10 05:30:00 | AAPL | Stock | 253.35 | 253.35 | 253.12 | 253.2 | 4670.0 |
| 2025-10-10 06:00:00 | AAPL | Stock | 253.34 | 253.76 | 253.34 | 253.51 | 2147.0 |
| 2025-10-10 06:30:00 | AAPL | Stock | 253.37 | 253.59 | 253.37 | 253.59 | 907.0 |
| 2025-10-10 07:00:00 | AAPL | Stock | 253.68 | 253.83 | 253.57 | 253.69 | 5287.0 |
| 2025-10-10 07:30:00 | AAPL | Stock | 253.75 | 254.13 | 253.75 | 254.1 | 4272.0 |
| 2025-10-10 08:00:00 | AAPL | Stock | 253.79 | 254.4 | 253.0 | 253.8053 | 47174.0 |
| 2025-10-10 08:30:00 | AAPL | Stock | 253.7499 | 253.7499 | 253.34 | 253.35 | 30449.0 |
| 2025-10-10 09:00:00 | AAPL | Stock | 253.38 | 255.3 | 253.37 | 254.94 | 99914.0 |
| 2025-10-10 09:30:00 | AAPL | Stock | 254.94 | 256.38 | 254.43 | 255.46 | 3801962.0 |
| 2025-10-10 10:00:00 | AAPL | Stock | 255.49 | 256.05 | 254.74 | 255.0206 | 1697929.0 |
| 2025-10-10 10:30:00 | AAPL | Stock | 255.04 | 255.34 | 252.52 | 253.17 | 1549744.0 |
| 2025-10-10 11:00:00 | AAPL | Stock | 253.11 | 253.11 | 248.92 | 249.12 | 6096309.0 |
| 2025-10-10 11:30:00 | AAPL | Stock | 249.1 | 250.04 | 248.33 | 248.79 | 3629531.0 |
| 2025-10-10 12:00:00 | AAPL | Stock | 248.78 | 249.02 | 247.76 | 248.61 | 1804342.0 |
| 2025-10-10 12:30:00 | AAPL | Stock | 248.59 | 249.06 | 247.32 | 247.49 | 1619635.0 |
| 2025-10-10 13:00:00 | AAPL | Stock | 247.5 | 247.88 | 247.06 | 247.81 | 1500578.0 |
| 2025-10-10 13:30:00 | AAPL | Stock | 247.77 | 248.58 | 247.68 | 248.01 | 1544744.0 |
| 2025-10-10 14:00:00 | AAPL | Stock | 248.03 | 248.05 | 247.08 | 247.16 | 1470180.0 |
| 2025-10-10 14:30:00 | AAPL | Stock | 247.1371 | 247.31 | 245.815 | 245.9995 | 2123305.0 |
| 2025-10-10 15:00:00 | AAPL | Stock | 246.0 | 246.41 | 245.88 | 246.165 | 1821660.0 |
| 2025-10-10 15:30:00 | AAPL | Stock | 246.17 | 246.99 | 244.0 | 245.28 | 6050192.0 |
| 2025-10-10 16:00:00 | AAPL | Stock | 245.33 | 245.94 | 244.8597 | 245.29 | 9521461.0 |
| 2025-10-10 16:30:00 | AAPL | Stock | 245.27 | 245.79 | 239.49 | 243.355 | 657300.0 |
| 2025-10-10 17:00:00 | AAPL | Stock | 243.36 | 243.64 | 242.0 | 242.8 | 351113.0 |
| 2025-10-10 17:30:00 | AAPL | Stock | 242.72 | 243.88 | 241.5 | 242.05 | 94640.0 |
| 2025-10-10 18:00:00 | AAPL | Stock | 242.05 | 245.6992 | 242.01 | 244.85 | 100593.0 |
| 2025-10-10 18:30:00 | AAPL | Stock | 244.9 | 244.9799 | 243.31 | 243.8 | 30058.0 |
| 2025-10-10 19:00:00 | AAPL | Stock | 243.8 | 244.25 | 243.7201 | 244.04 | 13740.0 |
| 2025-10-10 19:30:00 | AAPL | Stock | 244.49 | 246.0 | 244.02 | 245.4 | 37528.0 |
| 2025-10-10 04:00:00 | MSFT | Stock | 522.7 | 523.17 | 522.64 | 522.8 | 1719.0 |
| 2025-10-10 04:30:00 | MSFT | Stock | 523.14 | 523.16 | 523.14 | 523.16 | 200.0 |
| 2025-10-10 05:00:00 | MSFT | Stock | 523.2 | 523.2 | 523.2 | 523.2 | 170.0 |
| 2025-10-10 05:30:00 | MSFT | Stock | 522.35 | 522.35 | 521.23 | 521.23 | 2823.0 |
| 2025-10-10 06:00:00 | MSFT | Stock | 521.88 | 522.19 | 521.88 | 522.19 | 484.0 |
| 2025-10-10 06:30:00 | MSFT | Stock | 522.01 | 522.15 | 521.8 | 522.15 | 1139.0 |
| 2025-10-10 07:00:00 | MSFT | Stock | 522.29 | 522.29 | 522.16 | 522.16 | 200.0 |
| 2025-10-10 07:30:00 | MSFT | Stock | 522.0 | 522.17 | 521.75 | 522.17 | 365.0 |
| 2025-10-10 08:00:00 | MSFT | Stock | 522.3325 | 523.4 | 521.5 | 522.7 | 5683.0 |
| 2025-10-10 08:30:00 | MSFT | Stock | 522.86 | 522.86 | 522.4 | 522.59 | 5292.0 |
| 2025-10-10 09:00:00 | MSFT | Stock | 522.8 | 523.35 | 519.74 | 519.74 | 31643.0 |
| 2025-10-10 09:30:00 | MSFT | Stock | 519.74 | 523.58 | 519.6 | 522.555 | 1105776.0 |
| 2025-10-10 10:00:00 | MSFT | Stock | 522.55 | 522.86 | 520.8835 | 521.34 | 557464.0 |
| 2025-10-10 10:30:00 | MSFT | Stock | 521.26 | 521.5599 | 518.44 | 519.41 | 463343.0 |
| 2025-10-10 11:00:00 | MSFT | Stock | 519.25 | 519.25 | 515.75 | 516.555 | 1167204.0 |
| 2025-10-10 11:30:00 | MSFT | Stock | 516.47 | 518.06 | 514.0501 | 516.33 | 1012600.0 |
| 2025-10-10 12:00:00 | MSFT | Stock | 516.3 | 516.62 | 515.05 | 515.69 | 376256.0 |
| 2025-10-10 12:30:00 | MSFT | Stock | 515.68 | 516.5 | 513.92 | 514.3488 | 359661.0 |
> showing 50 of 117,165 rows — these rows as CSV