PREVIEW / stock_30min / 2025-10-09
file: by_date/stock_30min/2025/2025-10-09.parquet size: 2.3 MB rows: 111,683 symbols: 235
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-09 04:00:00 | AAPL | Stock | 257.07 | 257.45 | 257.01 | 257.39 | 10125.0 |
| 2025-10-09 04:30:00 | AAPL | Stock | 257.35 | 257.65 | 257.32 | 257.65 | 4615.0 |
| 2025-10-09 05:00:00 | AAPL | Stock | 257.62 | 257.86 | 257.51 | 257.77 | 4202.0 |
| 2025-10-09 05:30:00 | AAPL | Stock | 257.85 | 257.85 | 257.6 | 257.61 | 1513.0 |
| 2025-10-09 06:00:00 | AAPL | Stock | 257.6 | 257.7 | 257.45 | 257.45 | 2280.0 |
| 2025-10-09 06:30:00 | AAPL | Stock | 257.45 | 257.47 | 257.15 | 257.25 | 2517.0 |
| 2025-10-09 07:00:00 | AAPL | Stock | 257.44 | 257.85 | 257.44 | 257.6 | 8475.0 |
| 2025-10-09 07:30:00 | AAPL | Stock | 257.69 | 257.87 | 257.37 | 257.37 | 11456.0 |
| 2025-10-09 08:00:00 | AAPL | Stock | 257.4787 | 257.87 | 257.0 | 257.2462 | 55279.0 |
| 2025-10-09 08:30:00 | AAPL | Stock | 257.03 | 257.2 | 257.0 | 257.07 | 16999.0 |
| 2025-10-09 09:00:00 | AAPL | Stock | 257.08 | 258.0 | 257.05 | 257.78 | 68680.0 |
| 2025-10-09 09:30:00 | AAPL | Stock | 257.805 | 258.0 | 254.77 | 255.16 | 4284725.0 |
| 2025-10-09 10:00:00 | AAPL | Stock | 255.165 | 255.83 | 254.81 | 254.9 | 2306729.0 |
| 2025-10-09 10:30:00 | AAPL | Stock | 254.908 | 255.205 | 254.57 | 254.94 | 1378677.0 |
| 2025-10-09 11:00:00 | AAPL | Stock | 254.95 | 255.223 | 254.631 | 254.64 | 1428118.0 |
| 2025-10-09 11:30:00 | AAPL | Stock | 254.63 | 254.6554 | 253.81 | 254.1 | 1724551.0 |
| 2025-10-09 12:00:00 | AAPL | Stock | 254.1 | 254.76 | 253.75 | 253.99 | 1353229.0 |
| 2025-10-09 12:30:00 | AAPL | Stock | 254.0 | 254.05 | 253.525 | 253.785 | 988104.0 |
| 2025-10-09 13:00:00 | AAPL | Stock | 253.77 | 253.9 | 253.18 | 253.4 | 933253.0 |
| 2025-10-09 13:30:00 | AAPL | Stock | 253.395 | 253.74 | 253.14 | 253.63 | 876543.0 |
| 2025-10-09 14:00:00 | AAPL | Stock | 253.625 | 253.86 | 253.42 | 253.435 | 882180.0 |
| 2025-10-09 14:30:00 | AAPL | Stock | 253.42 | 253.82 | 253.32 | 253.8077 | 777606.0 |
| 2025-10-09 15:00:00 | AAPL | Stock | 253.8 | 254.115 | 253.64 | 253.775 | 1087015.0 |
| 2025-10-09 15:30:00 | AAPL | Stock | 253.77 | 254.5 | 253.56 | 254.03 | 3495325.0 |
| 2025-10-09 16:00:00 | AAPL | Stock | 254.02 | 254.23 | 253.74 | 254.04 | 5699263.0 |
| 2025-10-09 16:30:00 | AAPL | Stock | 254.07 | 254.07 | 253.8 | 254.0151 | 55835.0 |
| 2025-10-09 17:00:00 | AAPL | Stock | 254.0 | 254.04 | 253.8607 | 254.04 | 2618.0 |
| 2025-10-09 17:30:00 | AAPL | Stock | 254.0885 | 254.0885 | 253.95 | 253.97 | 12111.0 |
| 2025-10-09 18:00:00 | AAPL | Stock | 254.04 | 254.18 | 254.04 | 254.13 | 8012.0 |
| 2025-10-09 18:30:00 | AAPL | Stock | 254.0504 | 254.22 | 254.0504 | 254.16 | 13079.0 |
| 2025-10-09 19:00:00 | AAPL | Stock | 254.2 | 254.2 | 254.1 | 254.14 | 8007.0 |
| 2025-10-09 19:30:00 | AAPL | Stock | 254.13 | 254.29 | 254.1 | 254.29 | 15608.0 |
| 2025-10-09 04:00:00 | MSFT | Stock | 523.0 | 524.2 | 523.0 | 523.78 | 620.0 |
| 2025-10-09 04:30:00 | MSFT | Stock | 523.65 | 524.09 | 523.65 | 524.09 | 621.0 |
| 2025-10-09 05:00:00 | MSFT | Stock | 524.36 | 525.45 | 524.36 | 525.45 | 3205.0 |
| 2025-10-09 05:30:00 | MSFT | Stock | 525.64 | 525.8 | 525.41 | 525.41 | 1061.0 |
| 2025-10-09 06:00:00 | MSFT | Stock | 525.31 | 525.31 | 524.6 | 524.6 | 761.0 |
| 2025-10-09 06:30:00 | MSFT | Stock | 524.55 | 524.99 | 524.55 | 524.85 | 1275.0 |
| 2025-10-09 07:00:00 | MSFT | Stock | 525.0 | 525.0 | 524.53 | 524.53 | 1197.0 |
| 2025-10-09 07:30:00 | MSFT | Stock | 524.33 | 524.52 | 524.33 | 524.48 | 9999.0 |
| 2025-10-09 08:00:00 | MSFT | Stock | 524.86 | 525.06 | 521.0025 | 523.969 | 41894.0 |
| 2025-10-09 08:30:00 | MSFT | Stock | 523.1 | 524.0 | 523.1 | 523.9 | 10498.0 |
| 2025-10-09 09:00:00 | MSFT | Stock | 524.3 | 524.3 | 522.04 | 522.04 | 13162.0 |
| 2025-10-09 09:30:00 | MSFT | Stock | 522.05 | 524.325 | 519.85 | 521.77 | 1368110.0 |
| 2025-10-09 10:00:00 | MSFT | Stock | 521.81 | 522.6 | 521.2815 | 522.36 | 594234.0 |
| 2025-10-09 10:30:00 | MSFT | Stock | 522.3 | 522.67 | 521.16 | 521.705 | 476680.0 |
| 2025-10-09 11:00:00 | MSFT | Stock | 521.735 | 521.96 | 519.4 | 519.765 | 667983.0 |
| 2025-10-09 11:30:00 | MSFT | Stock | 519.76 | 520.1099 | 518.125 | 519.59 | 735167.0 |
| 2025-10-09 12:00:00 | MSFT | Stock | 519.65 | 520.25 | 519.214 | 519.515 | 499100.0 |
| 2025-10-09 12:30:00 | MSFT | Stock | 519.51 | 519.75 | 517.66 | 518.08 | 479958.0 |
> showing 50 of 111,683 rows — these rows as CSV