PREVIEW / stock_30min / 2025-10-14
file: by_date/stock_30min/2025/2025-10-14.parquet size: 2.3 MB rows: 113,423 symbols: 232
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-14 04:00:00 | AAPL | Stock | 246.28 | 246.97 | 244.86 | 245.1 | 18993.0 |
| 2025-10-14 04:30:00 | AAPL | Stock | 245.15 | 245.4 | 245.1 | 245.4 | 9579.0 |
| 2025-10-14 05:00:00 | AAPL | Stock | 245.85 | 245.85 | 245.41 | 245.46 | 1776.0 |
| 2025-10-14 05:30:00 | AAPL | Stock | 245.55 | 245.6 | 245.29 | 245.32 | 2617.0 |
| 2025-10-14 06:00:00 | AAPL | Stock | 245.34 | 245.55 | 245.2 | 245.2 | 4238.0 |
| 2025-10-14 06:30:00 | AAPL | Stock | 245.2 | 246.54 | 245.19 | 245.46 | 51709.0 |
| 2025-10-14 07:00:00 | AAPL | Stock | 245.69 | 246.0 | 245.45 | 245.7 | 8856.0 |
| 2025-10-14 07:30:00 | AAPL | Stock | 245.69 | 246.72 | 245.69 | 246.36 | 18933.0 |
| 2025-10-14 08:00:00 | AAPL | Stock | 245.21 | 247.66 | 244.85 | 246.13 | 221673.0 |
| 2025-10-14 08:30:00 | AAPL | Stock | 246.16 | 246.24 | 245.21 | 245.5048 | 33540.0 |
| 2025-10-14 09:00:00 | AAPL | Stock | 245.75 | 246.81 | 245.7116 | 246.5 | 50733.0 |
| 2025-10-14 09:30:00 | AAPL | Stock | 246.6 | 247.14 | 244.7 | 246.24 | 2960246.0 |
| 2025-10-14 10:00:00 | AAPL | Stock | 246.24 | 247.23 | 245.8675 | 247.02 | 1708544.0 |
| 2025-10-14 10:30:00 | AAPL | Stock | 246.99 | 247.7 | 246.9501 | 247.26 | 1264913.0 |
| 2025-10-14 11:00:00 | AAPL | Stock | 247.26 | 247.7499 | 246.12 | 246.22 | 1048829.0 |
| 2025-10-14 11:30:00 | AAPL | Stock | 246.23 | 247.46 | 246.17 | 247.38 | 970558.0 |
| 2025-10-14 12:00:00 | AAPL | Stock | 247.36 | 247.75 | 246.85 | 247.39 | 801032.0 |
| 2025-10-14 12:30:00 | AAPL | Stock | 247.39 | 248.0354 | 247.385 | 247.58 | 805155.0 |
| 2025-10-14 13:00:00 | AAPL | Stock | 247.575 | 247.9 | 247.465 | 247.798 | 661847.0 |
| 2025-10-14 13:30:00 | AAPL | Stock | 247.81 | 247.82 | 247.18 | 247.58 | 737741.0 |
| 2025-10-14 14:00:00 | AAPL | Stock | 247.58 | 247.705 | 247.17 | 247.485 | 680155.0 |
| 2025-10-14 14:30:00 | AAPL | Stock | 247.49 | 247.96 | 247.14 | 247.94 | 991768.0 |
| 2025-10-14 15:00:00 | AAPL | Stock | 247.94 | 248.75 | 247.9 | 248.42 | 1853895.0 |
| 2025-10-14 15:30:00 | AAPL | Stock | 248.43 | 248.845 | 246.71 | 247.85 | 3126559.0 |
| 2025-10-14 16:00:00 | AAPL | Stock | 247.85 | 248.15 | 247.08 | 247.15 | 7870608.0 |
| 2025-10-14 16:30:00 | AAPL | Stock | 247.18 | 247.77 | 247.18 | 247.6 | 21063.0 |
| 2025-10-14 17:00:00 | AAPL | Stock | 247.62 | 247.77 | 247.413 | 247.55 | 8633.0 |
| 2025-10-14 17:30:00 | AAPL | Stock | 247.6 | 247.6 | 247.3 | 247.46 | 5490.0 |
| 2025-10-14 18:00:00 | AAPL | Stock | 247.59 | 247.71 | 247.16 | 247.5 | 12966.0 |
| 2025-10-14 18:30:00 | AAPL | Stock | 247.31 | 247.53 | 247.27 | 247.5 | 3979.0 |
| 2025-10-14 19:00:00 | AAPL | Stock | 247.68 | 247.9 | 247.36 | 247.65 | 4718.0 |
| 2025-10-14 19:30:00 | AAPL | Stock | 247.67 | 247.79 | 247.2836 | 247.36 | 6173.0 |
| 2025-10-14 04:00:00 | MSFT | Stock | 510.4 | 511.0 | 510.4 | 511.0 | 1425.0 |
| 2025-10-14 04:30:00 | MSFT | Stock | 511.32 | 511.52 | 511.32 | 511.41 | 930.0 |
| 2025-10-14 05:00:00 | MSFT | Stock | 511.43 | 511.43 | 511.0 | 511.0 | 1144.0 |
| 2025-10-14 05:30:00 | MSFT | Stock | 510.37 | 510.37 | 510.3 | 510.3 | 3355.0 |
| 2025-10-14 06:00:00 | MSFT | Stock | 510.77 | 510.9 | 509.68 | 509.68 | 9614.0 |
| 2025-10-14 06:30:00 | MSFT | Stock | 509.5 | 509.5 | 508.59 | 508.97 | 4155.0 |
| 2025-10-14 07:00:00 | MSFT | Stock | 509.47 | 510.66 | 509.25 | 510.66 | 2195.0 |
| 2025-10-14 07:30:00 | MSFT | Stock | 510.3 | 510.87 | 510.3 | 510.44 | 809.0 |
| 2025-10-14 08:00:00 | MSFT | Stock | 509.81 | 513.5 | 508.5 | 510.7 | 23169.0 |
| 2025-10-14 08:30:00 | MSFT | Stock | 510.5 | 510.7501 | 509.13 | 510.45 | 12923.0 |
| 2025-10-14 09:00:00 | MSFT | Stock | 510.79 | 511.33 | 509.3 | 510.0 | 16142.0 |
| 2025-10-14 09:30:00 | MSFT | Stock | 510.23 | 510.23 | 506.0 | 509.92 | 1529617.0 |
| 2025-10-14 10:00:00 | MSFT | Stock | 509.94 | 510.7 | 508.9501 | 510.69 | 500523.0 |
| 2025-10-14 10:30:00 | MSFT | Stock | 510.7 | 510.85 | 509.2 | 509.95 | 360168.0 |
| 2025-10-14 11:00:00 | MSFT | Stock | 509.97 | 511.375 | 509.71 | 510.6784 | 290818.0 |
| 2025-10-14 11:30:00 | MSFT | Stock | 510.61 | 512.06 | 510.25 | 511.26 | 329601.0 |
| 2025-10-14 12:00:00 | MSFT | Stock | 511.34 | 512.83 | 510.92 | 512.6025 | 289064.0 |
| 2025-10-14 12:30:00 | MSFT | Stock | 512.6 | 513.63 | 512.38 | 513.241 | 302178.0 |
> showing 50 of 113,423 rows — these rows as CSV