PREVIEW / stock_30min / 2025-09-04
file: by_date/stock_30min/2025/2025-09-04.parquet size: 2.2 MB rows: 104,544 symbols: 318
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-04 04:00:00 | AAPL | Stock | 238.77 | 238.77 | 238.19 | 238.35 | 8381.0 |
| 2025-09-04 04:30:00 | AAPL | Stock | 238.27 | 238.3 | 238.21 | 238.22 | 2023.0 |
| 2025-09-04 05:00:00 | AAPL | Stock | 238.28 | 238.29 | 238.05 | 238.05 | 5131.0 |
| 2025-09-04 05:30:00 | AAPL | Stock | 238.03 | 238.17 | 238.03 | 238.1 | 3242.0 |
| 2025-09-04 06:00:00 | AAPL | Stock | 238.05 | 238.15 | 237.76 | 237.77 | 5576.0 |
| 2025-09-04 06:30:00 | AAPL | Stock | 237.85 | 238.81 | 237.85 | 238.11 | 34391.0 |
| 2025-09-04 07:00:00 | AAPL | Stock | 238.11 | 238.18 | 237.77 | 237.77 | 17353.0 |
| 2025-09-04 07:30:00 | AAPL | Stock | 237.77 | 237.8 | 237.5 | 237.5 | 20310.0 |
| 2025-09-04 08:00:00 | AAPL | Stock | 238.0 | 238.54 | 237.0 | 237.4 | 109518.0 |
| 2025-09-04 08:30:00 | AAPL | Stock | 237.44 | 237.7 | 237.2 | 237.59 | 45985.0 |
| 2025-09-04 09:00:00 | AAPL | Stock | 237.55 | 238.54 | 237.34 | 238.47 | 114200.0 |
| 2025-09-04 09:30:00 | AAPL | Stock | 238.45 | 239.8932 | 237.03 | 239.5 | 6060518.0 |
| 2025-09-04 10:00:00 | AAPL | Stock | 239.54 | 239.59 | 237.61 | 237.69 | 2894684.0 |
| 2025-09-04 10:30:00 | AAPL | Stock | 237.68 | 238.1 | 237.16 | 237.4716 | 2084870.0 |
| 2025-09-04 11:00:00 | AAPL | Stock | 237.47 | 238.1 | 237.075 | 237.4 | 1865819.0 |
| 2025-09-04 11:30:00 | AAPL | Stock | 237.39 | 237.49 | 236.74 | 237.41 | 1729337.0 |
| 2025-09-04 12:00:00 | AAPL | Stock | 237.4184 | 237.6746 | 237.07 | 237.16 | 1091125.0 |
| 2025-09-04 12:30:00 | AAPL | Stock | 237.15 | 237.63 | 236.97 | 237.51 | 1153502.0 |
| 2025-09-04 13:00:00 | AAPL | Stock | 237.515 | 238.09 | 237.5 | 238.04 | 1139359.0 |
| 2025-09-04 13:30:00 | AAPL | Stock | 238.0401 | 238.22 | 237.51 | 238.145 | 1098166.0 |
| 2025-09-04 14:00:00 | AAPL | Stock | 238.15 | 238.39 | 237.88 | 238.06 | 1082369.0 |
| 2025-09-04 14:30:00 | AAPL | Stock | 238.07 | 238.7115 | 237.88 | 238.475 | 1315072.0 |
| 2025-09-04 15:00:00 | AAPL | Stock | 238.48 | 238.98 | 238.33 | 238.7045 | 1505137.0 |
| 2025-09-04 15:30:00 | AAPL | Stock | 238.7 | 239.8999 | 238.49 | 239.71 | 4382648.0 |
| 2025-09-04 16:00:00 | AAPL | Stock | 239.7 | 239.92 | 238.0902 | 239.78 | 5369890.0 |
| 2025-09-04 16:30:00 | AAPL | Stock | 239.67 | 239.78 | 239.4 | 239.78 | 30808.0 |
| 2025-09-04 17:00:00 | AAPL | Stock | 239.54 | 239.6 | 239.22 | 239.45 | 19030.0 |
| 2025-09-04 17:30:00 | AAPL | Stock | 239.48 | 239.49 | 239.31 | 239.33 | 18426.0 |
| 2025-09-04 18:00:00 | AAPL | Stock | 239.31 | 239.45 | 239.19 | 239.45 | 12107.0 |
| 2025-09-04 18:30:00 | AAPL | Stock | 239.37 | 239.39 | 239.22 | 239.35 | 3808.0 |
| 2025-09-04 19:00:00 | AAPL | Stock | 239.3 | 239.4788 | 239.2899 | 239.4788 | 1291.0 |
| 2025-09-04 19:30:00 | AAPL | Stock | 239.4 | 239.48 | 239.1304 | 239.1999 | 23254.0 |
| 2025-09-04 04:00:00 | MSFT | Stock | 504.5 | 504.5 | 504.22 | 504.3 | 575.0 |
| 2025-09-04 04:30:00 | MSFT | Stock | 504.3 | 504.3 | 504.18 | 504.18 | 525.0 |
| 2025-09-04 05:00:00 | MSFT | Stock | 504.42 | 504.42 | 504.28 | 504.28 | 572.0 |
| 2025-09-04 05:30:00 | MSFT | Stock | 504.4 | 504.4 | 504.4 | 504.4 | 330.0 |
| 2025-09-04 06:00:00 | MSFT | Stock | 505.0 | 505.18 | 505.0 | 505.18 | 700.0 |
| 2025-09-04 06:30:00 | MSFT | Stock | 504.77 | 504.77 | 504.73 | 504.75 | 504.0 |
| 2025-09-04 07:00:00 | MSFT | Stock | 504.5 | 504.55 | 504.5 | 504.55 | 200.0 |
| 2025-09-04 07:30:00 | MSFT | Stock | 504.67 | 504.7 | 504.34 | 504.51 | 2802.0 |
| 2025-09-04 08:00:00 | MSFT | Stock | 504.77 | 505.0 | 503.77 | 503.77 | 12044.0 |
| 2025-09-04 08:30:00 | MSFT | Stock | 504.0 | 504.35 | 503.6 | 504.35 | 11401.0 |
| 2025-09-04 09:00:00 | MSFT | Stock | 504.1 | 504.5 | 503.25 | 504.48 | 11474.0 |
| 2025-09-04 09:30:00 | MSFT | Stock | 504.3 | 506.91 | 503.6155 | 503.9 | 1109378.0 |
| 2025-09-04 10:00:00 | MSFT | Stock | 503.9 | 505.62 | 503.15 | 505.4802 | 584254.0 |
| 2025-09-04 10:30:00 | MSFT | Stock | 505.46 | 507.65 | 505.46 | 507.55 | 569059.0 |
| 2025-09-04 11:00:00 | MSFT | Stock | 507.4964 | 508.05 | 506.13 | 507.675 | 477772.0 |
| 2025-09-04 11:30:00 | MSFT | Stock | 507.73 | 507.74 | 506.7 | 506.89 | 468020.0 |
| 2025-09-04 12:00:00 | MSFT | Stock | 506.8975 | 507.01 | 505.8344 | 506.0 | 302951.0 |
| 2025-09-04 12:30:00 | MSFT | Stock | 506.04 | 507.09 | 505.97 | 506.365 | 319185.0 |
> showing 50 of 104,544 rows — these rows as CSV