PREVIEW / stock_30min / 2025-08-11
file: by_date/stock_30min/2025/2025-08-11.parquet size: 2.2 MB rows: 108,023 symbols: 343
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-11 04:00:00 | AAPL | Stock | 229.6 | 229.83 | 226.4 | 227.19 | 81535.0 |
| 2025-08-11 04:30:00 | AAPL | Stock | 227.13 | 227.7 | 226.79 | 227.7 | 24229.0 |
| 2025-08-11 05:00:00 | AAPL | Stock | 227.55 | 227.7 | 227.3 | 227.65 | 12701.0 |
| 2025-08-11 05:30:00 | AAPL | Stock | 227.7 | 227.75 | 227.16 | 227.16 | 14576.0 |
| 2025-08-11 06:00:00 | AAPL | Stock | 227.18 | 227.51 | 227.18 | 227.51 | 10950.0 |
| 2025-08-11 06:30:00 | AAPL | Stock | 227.48 | 227.6 | 227.19 | 227.57 | 20965.0 |
| 2025-08-11 07:00:00 | AAPL | Stock | 227.59 | 228.8 | 227.5 | 228.32 | 61600.0 |
| 2025-08-11 07:30:00 | AAPL | Stock | 228.44 | 228.59 | 228.1 | 228.11 | 20330.0 |
| 2025-08-11 08:00:00 | AAPL | Stock | 228.0 | 229.91 | 226.44 | 228.0 | 223995.0 |
| 2025-08-11 08:30:00 | AAPL | Stock | 228.0002 | 228.13 | 227.75 | 227.96 | 89920.0 |
| 2025-08-11 09:00:00 | AAPL | Stock | 227.9648 | 228.44 | 227.59 | 227.8 | 111956.0 |
| 2025-08-11 09:30:00 | AAPL | Stock | 227.925 | 228.73 | 224.76 | 226.0407 | 8505728.0 |
| 2025-08-11 10:00:00 | AAPL | Stock | 226.04 | 227.37 | 225.839 | 226.775 | 3372157.0 |
| 2025-08-11 10:30:00 | AAPL | Stock | 226.79 | 227.89 | 226.49 | 226.521 | 2550558.0 |
| 2025-08-11 11:00:00 | AAPL | Stock | 226.53 | 227.65 | 226.1 | 227.48 | 2283528.0 |
| 2025-08-11 11:30:00 | AAPL | Stock | 227.47 | 228.96 | 227.47 | 228.625 | 3138010.0 |
| 2025-08-11 12:00:00 | AAPL | Stock | 228.63 | 229.56 | 228.3401 | 228.73 | 2705568.0 |
| 2025-08-11 12:30:00 | AAPL | Stock | 228.735 | 229.0999 | 228.1 | 228.395 | 1604592.0 |
| 2025-08-11 13:00:00 | AAPL | Stock | 228.4 | 228.61 | 228.0 | 228.1 | 1619767.0 |
| 2025-08-11 13:30:00 | AAPL | Stock | 228.095 | 228.195 | 227.01 | 227.22 | 2212854.0 |
| 2025-08-11 14:00:00 | AAPL | Stock | 227.245 | 228.18 | 227.1 | 227.735 | 1812072.0 |
| 2025-08-11 14:30:00 | AAPL | Stock | 227.76 | 227.965 | 227.09 | 227.54 | 1491710.0 |
| 2025-08-11 15:00:00 | AAPL | Stock | 227.54 | 227.94 | 227.1862 | 227.65 | 1611417.0 |
| 2025-08-11 15:30:00 | AAPL | Stock | 227.66 | 227.695 | 226.62 | 227.27 | 4607941.0 |
| 2025-08-11 16:00:00 | AAPL | Stock | 227.18 | 227.6 | 226.7373 | 226.7531 | 5679540.0 |
| 2025-08-11 16:30:00 | AAPL | Stock | 226.7992 | 227.18 | 226.5135 | 226.62 | 45153.0 |
| 2025-08-11 17:00:00 | AAPL | Stock | 226.6 | 227.18 | 226.59 | 226.64 | 26103.0 |
| 2025-08-11 17:30:00 | AAPL | Stock | 226.65 | 226.7894 | 226.5601 | 226.63 | 23686.0 |
| 2025-08-11 18:00:00 | AAPL | Stock | 226.58 | 226.7 | 226.5 | 226.5001 | 26600.0 |
| 2025-08-11 18:30:00 | AAPL | Stock | 226.5 | 226.6 | 226.49 | 226.5518 | 11625.0 |
| 2025-08-11 19:00:00 | AAPL | Stock | 226.6 | 226.64 | 226.52 | 226.52 | 14130.0 |
| 2025-08-11 19:30:00 | AAPL | Stock | 226.52 | 226.55 | 226.2515 | 226.3225 | 19014.0 |
| 2025-08-11 04:00:00 | MSFT | Stock | 522.99 | 524.02 | 522.72 | 524.0 | 2462.0 |
| 2025-08-11 04:30:00 | MSFT | Stock | 524.54 | 524.9 | 524.21 | 524.21 | 1168.0 |
| 2025-08-11 05:00:00 | MSFT | Stock | 524.62 | 524.9 | 524.39 | 524.9 | 681.0 |
| 2025-08-11 05:30:00 | MSFT | Stock | 524.75 | 524.91 | 524.75 | 524.9 | 1320.0 |
| 2025-08-11 06:00:00 | MSFT | Stock | 524.56 | 524.72 | 524.56 | 524.72 | 426.0 |
| 2025-08-11 06:30:00 | MSFT | Stock | 524.9 | 524.9 | 524.2 | 524.5 | 2177.0 |
| 2025-08-11 07:00:00 | MSFT | Stock | 524.35 | 524.35 | 523.25 | 523.5 | 4811.0 |
| 2025-08-11 07:30:00 | MSFT | Stock | 523.38 | 523.6 | 523.38 | 523.6 | 920.0 |
| 2025-08-11 08:00:00 | MSFT | Stock | 524.35 | 524.71 | 522.48 | 523.27 | 37708.0 |
| 2025-08-11 08:30:00 | MSFT | Stock | 523.25 | 523.3 | 523.0 | 523.22 | 8305.0 |
| 2025-08-11 09:00:00 | MSFT | Stock | 523.25 | 523.386 | 521.74 | 522.33 | 8131.0 |
| 2025-08-11 09:30:00 | MSFT | Stock | 522.35 | 523.77 | 519.72 | 523.58 | 1218988.0 |
| 2025-08-11 10:00:00 | MSFT | Stock | 523.6 | 525.0999 | 522.79 | 522.95 | 691054.0 |
| 2025-08-11 10:30:00 | MSFT | Stock | 523.0 | 525.22 | 522.88 | 525.015 | 499123.0 |
| 2025-08-11 11:00:00 | MSFT | Stock | 525.02 | 526.7 | 524.915 | 524.94 | 684460.0 |
| 2025-08-11 11:30:00 | MSFT | Stock | 524.93 | 526.1 | 524.05 | 526.07 | 526320.0 |
| 2025-08-11 12:00:00 | MSFT | Stock | 526.0551 | 527.59 | 525.92 | 526.965 | 462174.0 |
| 2025-08-11 12:30:00 | MSFT | Stock | 526.965 | 527.32 | 525.38 | 525.78 | 291862.0 |
> showing 50 of 108,023 rows — these rows as CSV