PREVIEW / stock_30min / 2025-09-15
file: by_date/stock_30min/2025/2025-09-15.parquet size: 2.3 MB rows: 111,853 symbols: 315
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-15 04:00:00 | AAPL | Stock | 234.54 | 235.88 | 234.12 | 235.72 | 35918.0 |
| 2025-09-15 04:30:00 | AAPL | Stock | 235.68 | 237.27 | 235.5 | 236.76 | 66529.0 |
| 2025-09-15 05:00:00 | AAPL | Stock | 236.46 | 236.64 | 236.12 | 236.64 | 6932.0 |
| 2025-09-15 05:30:00 | AAPL | Stock | 236.62 | 236.62 | 236.2 | 236.45 | 7594.0 |
| 2025-09-15 06:00:00 | AAPL | Stock | 236.15 | 236.32 | 236.03 | 236.12 | 15465.0 |
| 2025-09-15 06:30:00 | AAPL | Stock | 236.1 | 236.4 | 235.9 | 236.3 | 25019.0 |
| 2025-09-15 07:00:00 | AAPL | Stock | 236.31 | 237.12 | 236.05 | 236.3 | 48940.0 |
| 2025-09-15 07:30:00 | AAPL | Stock | 236.26 | 236.6 | 236.02 | 236.57 | 28255.0 |
| 2025-09-15 08:00:00 | AAPL | Stock | 236.1 | 237.27 | 234.34 | 236.7 | 195083.0 |
| 2025-09-15 08:30:00 | AAPL | Stock | 236.6 | 237.6996 | 236.5 | 237.17 | 132906.0 |
| 2025-09-15 09:00:00 | AAPL | Stock | 237.17 | 237.35 | 237.0 | 237.0 | 149296.0 |
| 2025-09-15 09:30:00 | AAPL | Stock | 237.0 | 238.19 | 235.03 | 235.3599 | 7317510.0 |
| 2025-09-15 10:00:00 | AAPL | Stock | 235.33 | 236.3 | 235.055 | 236.215 | 2517215.0 |
| 2025-09-15 10:30:00 | AAPL | Stock | 236.21 | 237.02 | 235.66 | 236.96 | 2186743.0 |
| 2025-09-15 11:00:00 | AAPL | Stock | 236.95 | 237.0 | 236.42 | 236.815 | 1544106.0 |
| 2025-09-15 11:30:00 | AAPL | Stock | 236.815 | 237.3 | 236.74 | 237.065 | 1681217.0 |
| 2025-09-15 12:00:00 | AAPL | Stock | 237.065 | 237.065 | 236.47 | 236.57 | 1065976.0 |
| 2025-09-15 12:30:00 | AAPL | Stock | 236.5649 | 236.5905 | 236.08 | 236.23 | 1029490.0 |
| 2025-09-15 13:00:00 | AAPL | Stock | 236.23 | 236.37 | 235.7 | 235.76 | 1155202.0 |
| 2025-09-15 13:30:00 | AAPL | Stock | 235.75 | 236.12 | 235.58 | 236.02 | 1283296.0 |
| 2025-09-15 14:00:00 | AAPL | Stock | 236.02 | 236.14 | 235.6324 | 235.64 | 985945.0 |
| 2025-09-15 14:30:00 | AAPL | Stock | 235.635 | 236.17 | 235.27 | 236.17 | 1273131.0 |
| 2025-09-15 15:00:00 | AAPL | Stock | 236.175 | 236.34 | 235.71 | 235.97 | 1309599.0 |
| 2025-09-15 15:30:00 | AAPL | Stock | 235.97 | 236.79 | 235.68 | 236.76 | 3688339.0 |
| 2025-09-15 16:00:00 | AAPL | Stock | 236.76 | 237.34 | 236.2 | 236.48 | 3887950.0 |
| 2025-09-15 16:30:00 | AAPL | Stock | 236.3614 | 236.7 | 236.1401 | 236.35 | 26578.0 |
| 2025-09-15 17:00:00 | AAPL | Stock | 236.3 | 236.44 | 236.3 | 236.39 | 14352.0 |
| 2025-09-15 17:30:00 | AAPL | Stock | 236.3305 | 236.4 | 236.2653 | 236.3 | 3263.0 |
| 2025-09-15 18:00:00 | AAPL | Stock | 236.33 | 236.57 | 236.3 | 236.3889 | 13690.0 |
| 2025-09-15 18:30:00 | AAPL | Stock | 236.3016 | 236.7 | 236.1672 | 236.22 | 10923.0 |
| 2025-09-15 19:00:00 | AAPL | Stock | 236.24 | 236.269 | 236.12 | 236.25 | 7853.0 |
| 2025-09-15 19:30:00 | AAPL | Stock | 236.27 | 236.33 | 236.25 | 236.3 | 7763.0 |
| 2025-09-15 04:00:00 | MSFT | Stock | 511.24 | 511.24 | 508.47 | 509.43 | 19640.0 |
| 2025-09-15 04:30:00 | MSFT | Stock | 509.4 | 509.51 | 508.64 | 508.64 | 1488.0 |
| 2025-09-15 05:00:00 | MSFT | Stock | 508.32 | 508.32 | 507.52 | 507.96 | 3115.0 |
| 2025-09-15 05:30:00 | MSFT | Stock | 508.0 | 508.32 | 508.0 | 508.13 | 2392.0 |
| 2025-09-15 06:00:00 | MSFT | Stock | 508.37 | 508.37 | 506.5 | 506.71 | 6487.0 |
| 2025-09-15 06:30:00 | MSFT | Stock | 507.0 | 507.0 | 506.1 | 506.5 | 8170.0 |
| 2025-09-15 07:00:00 | MSFT | Stock | 506.9 | 506.94 | 505.16 | 505.42 | 13210.0 |
| 2025-09-15 07:30:00 | MSFT | Stock | 505.52 | 506.65 | 505.03 | 506.65 | 10578.0 |
| 2025-09-15 08:00:00 | MSFT | Stock | 506.68 | 512.18 | 505.11 | 506.09 | 63266.0 |
| 2025-09-15 08:30:00 | MSFT | Stock | 505.9 | 507.0 | 505.2518 | 506.91 | 17750.0 |
| 2025-09-15 09:00:00 | MSFT | Stock | 506.9 | 509.46 | 506.9 | 508.84 | 51902.0 |
| 2025-09-15 09:30:00 | MSFT | Stock | 508.79 | 511.7 | 507.0 | 510.28 | 1312443.0 |
| 2025-09-15 10:00:00 | MSFT | Stock | 510.33 | 512.38 | 510.29 | 510.65 | 557744.0 |
| 2025-09-15 10:30:00 | MSFT | Stock | 510.71 | 512.5 | 510.2 | 512.49 | 501648.0 |
| 2025-09-15 11:00:00 | MSFT | Stock | 512.45 | 514.25 | 512.12 | 512.43 | 630555.0 |
| 2025-09-15 11:30:00 | MSFT | Stock | 512.4759 | 514.0 | 512.4759 | 513.153 | 368029.0 |
| 2025-09-15 12:00:00 | MSFT | Stock | 513.145 | 513.34 | 512.19 | 512.51 | 406985.0 |
| 2025-09-15 12:30:00 | MSFT | Stock | 512.425 | 513.15 | 511.78 | 511.89 | 287134.0 |
> showing 50 of 111,853 rows — these rows as CSV