PREVIEW / stock_30min / 2025-08-12
file: by_date/stock_30min/2025/2025-08-12.parquet size: 2.3 MB rows: 107,925 symbols: 340
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-08-12 04:00:00 | AAPL | Stock | 226.27 | 226.68 | 226.27 | 226.38 | 4390.0 |
| 2025-08-12 04:30:00 | AAPL | Stock | 226.35 | 226.35 | 226.01 | 226.02 | 5583.0 |
| 2025-08-12 05:00:00 | AAPL | Stock | 226.02 | 226.05 | 225.85 | 225.89 | 3173.0 |
| 2025-08-12 05:30:00 | AAPL | Stock | 225.96 | 226.16 | 225.91 | 226.16 | 1983.0 |
| 2025-08-12 06:00:00 | AAPL | Stock | 226.0 | 226.06 | 225.91 | 225.96 | 6512.0 |
| 2025-08-12 06:30:00 | AAPL | Stock | 226.0 | 226.1 | 225.95 | 226.01 | 4913.0 |
| 2025-08-12 07:00:00 | AAPL | Stock | 226.0 | 226.18 | 225.97 | 225.98 | 14182.0 |
| 2025-08-12 07:30:00 | AAPL | Stock | 226.0 | 226.08 | 225.77 | 225.88 | 11567.0 |
| 2025-08-12 08:00:00 | AAPL | Stock | 225.98 | 226.84 | 225.8001 | 226.3999 | 128249.0 |
| 2025-08-12 08:30:00 | AAPL | Stock | 226.4 | 228.47 | 226.34 | 227.953 | 317243.0 |
| 2025-08-12 09:00:00 | AAPL | Stock | 227.98 | 228.05 | 226.97 | 228.0 | 110353.0 |
| 2025-08-12 09:30:00 | AAPL | Stock | 228.005 | 229.9399 | 227.07 | 227.875 | 6245152.0 |
| 2025-08-12 10:00:00 | AAPL | Stock | 227.875 | 229.48 | 227.32 | 228.57 | 3261472.0 |
| 2025-08-12 10:30:00 | AAPL | Stock | 228.59 | 229.72 | 228.26 | 229.5003 | 2190321.0 |
| 2025-08-12 11:00:00 | AAPL | Stock | 229.5273 | 230.5865 | 229.429 | 229.73 | 3855237.0 |
| 2025-08-12 11:30:00 | AAPL | Stock | 229.7299 | 229.87 | 228.32 | 229.7 | 2530116.0 |
| 2025-08-12 12:00:00 | AAPL | Stock | 229.71 | 230.11 | 229.45 | 229.78 | 1347518.0 |
| 2025-08-12 12:30:00 | AAPL | Stock | 229.78 | 230.8 | 229.66 | 230.39 | 1973672.0 |
| 2025-08-12 13:00:00 | AAPL | Stock | 230.4 | 230.71 | 229.77 | 229.775 | 1269000.0 |
| 2025-08-12 13:30:00 | AAPL | Stock | 229.7701 | 230.55 | 229.52 | 229.945 | 1698036.0 |
| 2025-08-12 14:00:00 | AAPL | Stock | 229.9462 | 230.1097 | 229.45 | 229.57 | 1171401.0 |
| 2025-08-12 14:30:00 | AAPL | Stock | 229.58 | 229.61 | 229.01 | 229.2901 | 1256090.0 |
| 2025-08-12 15:00:00 | AAPL | Stock | 229.305 | 229.32 | 228.92 | 229.18 | 1240253.0 |
| 2025-08-12 15:30:00 | AAPL | Stock | 229.17 | 230.1 | 229.01 | 229.64 | 3744384.0 |
| 2025-08-12 16:00:00 | AAPL | Stock | 229.63 | 229.6501 | 229.4 | 229.4057 | 7325577.0 |
| 2025-08-12 16:30:00 | AAPL | Stock | 229.4 | 229.66 | 229.19 | 229.65 | 26821.0 |
| 2025-08-12 17:00:00 | AAPL | Stock | 229.65 | 229.6791 | 229.43 | 229.47 | 16431.0 |
| 2025-08-12 17:30:00 | AAPL | Stock | 229.44 | 229.6 | 229.44 | 229.502 | 5428.0 |
| 2025-08-12 18:00:00 | AAPL | Stock | 229.46 | 229.5428 | 229.3001 | 229.35 | 5600.0 |
| 2025-08-12 18:30:00 | AAPL | Stock | 229.35 | 229.44 | 229.31 | 229.34 | 4280.0 |
| 2025-08-12 19:00:00 | AAPL | Stock | 229.31 | 229.48 | 229.31 | 229.37 | 4082.0 |
| 2025-08-12 19:30:00 | AAPL | Stock | 229.37 | 229.65 | 229.3 | 229.65 | 20874.0 |
| 2025-08-12 04:00:00 | MSFT | Stock | 522.88 | 523.9 | 522.88 | 523.55 | 3945.0 |
| 2025-08-12 04:30:00 | MSFT | Stock | 523.21 | 523.4 | 523.21 | 523.21 | 547.0 |
| 2025-08-12 05:30:00 | MSFT | Stock | 523.46 | 523.5 | 523.46 | 523.5 | 226.0 |
| 2025-08-12 06:00:00 | MSFT | Stock | 523.21 | 523.21 | 522.61 | 522.61 | 1157.0 |
| 2025-08-12 06:30:00 | MSFT | Stock | 522.4 | 522.49 | 522.4 | 522.49 | 200.0 |
| 2025-08-12 07:00:00 | MSFT | Stock | 522.62 | 522.62 | 522.47 | 522.49 | 1797.0 |
| 2025-08-12 07:30:00 | MSFT | Stock | 522.35 | 522.42 | 522.08 | 522.34 | 1014.0 |
| 2025-08-12 08:00:00 | MSFT | Stock | 522.54 | 523.9 | 521.8118 | 522.6 | 14583.0 |
| 2025-08-12 08:30:00 | MSFT | Stock | 522.77 | 524.95 | 522.77 | 524.1 | 44968.0 |
| 2025-08-12 09:00:00 | MSFT | Stock | 524.3 | 524.3 | 523.64 | 523.88 | 12495.0 |
| 2025-08-12 09:30:00 | MSFT | Stock | 523.75 | 527.59 | 523.64 | 524.73 | 1419035.0 |
| 2025-08-12 10:00:00 | MSFT | Stock | 524.6331 | 526.8698 | 522.7 | 526.12 | 899664.0 |
| 2025-08-12 10:30:00 | MSFT | Stock | 526.195 | 526.77 | 524.35 | 525.0 | 614036.0 |
| 2025-08-12 11:00:00 | MSFT | Stock | 525.01 | 527.05 | 524.7101 | 526.425 | 447697.0 |
| 2025-08-12 11:30:00 | MSFT | Stock | 526.5 | 527.27 | 525.93 | 526.96 | 442912.0 |
| 2025-08-12 12:00:00 | MSFT | Stock | 526.945 | 528.2 | 526.27 | 527.93 | 538549.0 |
| 2025-08-12 12:30:00 | MSFT | Stock | 527.93 | 528.772 | 527.25 | 528.28 | 378695.0 |
| 2025-08-12 13:00:00 | MSFT | Stock | 528.265 | 529.08 | 528.125 | 528.17 | 315383.0 |
> showing 50 of 107,925 rows — these rows as CSV