PREVIEW / stock_30min / 2025-11-13
file: by_date/stock_30min/2025/2025-11-13.parquet size: 2.2 MB rows: 105,481 symbols: 215
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-11-13 04:00:00 | AAPL | Stock | 274.02 | 274.96 | 273.4 | 273.62 | 13402.0 |
| 2025-11-13 04:30:00 | AAPL | Stock | 273.41 | 273.41 | 273.27 | 273.3 | 500.0 |
| 2025-11-13 05:00:00 | AAPL | Stock | 273.3 | 273.66 | 273.3 | 273.33 | 3219.0 |
| 2025-11-13 05:30:00 | AAPL | Stock | 273.41 | 273.5 | 273.16 | 273.18 | 2151.0 |
| 2025-11-13 06:00:00 | AAPL | Stock | 273.19 | 274.99 | 273.19 | 273.68 | 15496.0 |
| 2025-11-13 06:30:00 | AAPL | Stock | 273.91 | 273.91 | 273.42 | 273.79 | 6167.0 |
| 2025-11-13 07:00:00 | AAPL | Stock | 273.59 | 273.8 | 273.5 | 273.69 | 4262.0 |
| 2025-11-13 07:30:00 | AAPL | Stock | 273.7 | 274.1 | 273.51 | 273.51 | 6662.0 |
| 2025-11-13 08:00:00 | AAPL | Stock | 274.0 | 274.82 | 273.0537 | 273.3 | 57264.0 |
| 2025-11-13 08:30:00 | AAPL | Stock | 273.37 | 273.37 | 272.76 | 272.78 | 47748.0 |
| 2025-11-13 09:00:00 | AAPL | Stock | 272.82 | 274.27 | 272.45 | 274.2 | 94809.0 |
| 2025-11-13 09:30:00 | AAPL | Stock | 274.27 | 276.699 | 273.57 | 275.147 | 4643020.0 |
| 2025-11-13 10:00:00 | AAPL | Stock | 275.13 | 275.16 | 273.29 | 273.73 | 1910637.0 |
| 2025-11-13 10:30:00 | AAPL | Stock | 273.725 | 273.74 | 272.18 | 272.93 | 1827793.0 |
| 2025-11-13 11:00:00 | AAPL | Stock | 272.945 | 274.2 | 272.38 | 274.0371 | 1700561.0 |
| 2025-11-13 11:30:00 | AAPL | Stock | 274.01 | 274.4899 | 273.05 | 273.745 | 1140595.0 |
| 2025-11-13 12:00:00 | AAPL | Stock | 273.73 | 274.04 | 272.46 | 272.86 | 918992.0 |
| 2025-11-13 12:30:00 | AAPL | Stock | 272.84 | 273.0393 | 272.5 | 272.6099 | 825844.0 |
| 2025-11-13 13:00:00 | AAPL | Stock | 272.6 | 273.32 | 272.49 | 272.5701 | 883044.0 |
| 2025-11-13 13:30:00 | AAPL | Stock | 272.57 | 273.85 | 272.09 | 273.4392 | 1591580.0 |
| 2025-11-13 14:00:00 | AAPL | Stock | 273.46 | 273.8 | 272.86 | 273.53 | 1036150.0 |
| 2025-11-13 14:30:00 | AAPL | Stock | 273.54 | 273.69 | 272.55 | 272.98 | 1073144.0 |
| 2025-11-13 15:00:00 | AAPL | Stock | 272.98 | 273.12 | 272.545 | 273.0396 | 1209405.0 |
| 2025-11-13 15:30:00 | AAPL | Stock | 273.04 | 273.65 | 272.44 | 273.05 | 3141815.0 |
| 2025-11-13 16:00:00 | AAPL | Stock | 273.05 | 273.7 | 272.95 | 273.3 | 6349663.0 |
| 2025-11-13 16:30:00 | AAPL | Stock | 273.13 | 273.13 | 272.95 | 273.12 | 26777.0 |
| 2025-11-13 17:00:00 | AAPL | Stock | 273.13 | 273.3 | 272.95 | 273.2018 | 12185.0 |
| 2025-11-13 17:30:00 | AAPL | Stock | 273.2 | 273.22 | 273.0 | 273.0 | 13927.0 |
| 2025-11-13 18:00:00 | AAPL | Stock | 273.2194 | 273.68 | 273.0 | 273.05 | 9546.0 |
| 2025-11-13 18:30:00 | AAPL | Stock | 273.45 | 273.49 | 273.01 | 273.11 | 3327.0 |
| 2025-11-13 19:00:00 | AAPL | Stock | 273.09 | 273.46 | 273.0 | 273.3 | 8029.0 |
| 2025-11-13 19:30:00 | AAPL | Stock | 273.33 | 273.5 | 273.11 | 273.45 | 8232.0 |
| 2025-11-13 04:00:00 | MSFT | Stock | 511.72 | 511.92 | 509.37 | 509.6 | 12128.0 |
| 2025-11-13 04:30:00 | MSFT | Stock | 509.6 | 510.1 | 509.13 | 509.49 | 2123.0 |
| 2025-11-13 05:00:00 | MSFT | Stock | 509.31 | 510.26 | 509.27 | 510.21 | 3047.0 |
| 2025-11-13 05:30:00 | MSFT | Stock | 510.42 | 510.42 | 509.97 | 510.0 | 2492.0 |
| 2025-11-13 06:00:00 | MSFT | Stock | 510.24 | 510.24 | 509.5 | 509.5 | 732.0 |
| 2025-11-13 06:30:00 | MSFT | Stock | 509.32 | 509.75 | 509.29 | 509.5 | 2289.0 |
| 2025-11-13 07:00:00 | MSFT | Stock | 509.78 | 509.81 | 508.8 | 509.25 | 6282.0 |
| 2025-11-13 07:30:00 | MSFT | Stock | 509.35 | 512.57 | 509.35 | 512.2 | 13132.0 |
| 2025-11-13 08:00:00 | MSFT | Stock | 509.3 | 513.61 | 508.8156 | 511.63 | 42993.0 |
| 2025-11-13 08:30:00 | MSFT | Stock | 511.52 | 511.99 | 510.0 | 510.93 | 28292.0 |
| 2025-11-13 09:00:00 | MSFT | Stock | 510.61 | 511.3 | 509.11 | 510.0 | 26630.0 |
| 2025-11-13 09:30:00 | MSFT | Stock | 510.31 | 511.6 | 505.45 | 509.535 | 1578209.0 |
| 2025-11-13 10:00:00 | MSFT | Stock | 509.5 | 513.5 | 509.47 | 511.6536 | 1001007.0 |
| 2025-11-13 10:30:00 | MSFT | Stock | 511.65 | 512.94 | 509.9 | 511.3 | 978927.0 |
| 2025-11-13 11:00:00 | MSFT | Stock | 511.25 | 512.1499 | 509.27 | 509.915 | 743294.0 |
| 2025-11-13 11:30:00 | MSFT | Stock | 509.97 | 510.45 | 508.32 | 508.62 | 548484.0 |
| 2025-11-13 12:00:00 | MSFT | Stock | 508.62 | 509.79 | 508.01 | 509.705 | 508866.0 |
| 2025-11-13 12:30:00 | MSFT | Stock | 509.74 | 510.0373 | 507.12 | 507.37 | 418586.0 |
> showing 50 of 105,481 rows — these rows as CSV