PREVIEW / stock_30min / 2025-08-25
file: by_date/stock_30min/2025/2025-08-25.parquet size: 2.2 MB rows: 106,645 symbols: 330
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-25 04:00:00 | AAPL | Stock | 227.9 | 227.9 | 227.06 | 227.23 | 6894.0 |
| 2025-08-25 04:30:00 | AAPL | Stock | 227.16 | 227.29 | 226.99 | 226.99 | 18485.0 |
| 2025-08-25 05:00:00 | AAPL | Stock | 226.94 | 227.0 | 226.86 | 226.88 | 2977.0 |
| 2025-08-25 05:30:00 | AAPL | Stock | 226.94 | 227.06 | 226.86 | 226.86 | 955.0 |
| 2025-08-25 06:00:00 | AAPL | Stock | 227.0 | 227.05 | 227.0 | 227.02 | 324.0 |
| 2025-08-25 06:30:00 | AAPL | Stock | 226.9 | 226.96 | 226.74 | 226.89 | 2789.0 |
| 2025-08-25 07:00:00 | AAPL | Stock | 227.04 | 227.04 | 226.73 | 226.84 | 8595.0 |
| 2025-08-25 07:30:00 | AAPL | Stock | 226.94 | 227.01 | 226.89 | 227.01 | 9073.0 |
| 2025-08-25 08:00:00 | AAPL | Stock | 227.56 | 227.97 | 226.2 | 226.43 | 115979.0 |
| 2025-08-25 08:30:00 | AAPL | Stock | 226.4057 | 226.95 | 226.4057 | 226.93 | 43040.0 |
| 2025-08-25 09:00:00 | AAPL | Stock | 226.85 | 226.97 | 226.25 | 226.45 | 59908.0 |
| 2025-08-25 09:30:00 | AAPL | Stock | 226.48 | 229.05 | 226.23 | 228.565 | 3703001.0 |
| 2025-08-25 10:00:00 | AAPL | Stock | 228.57 | 229.12 | 228.09 | 228.81 | 2188816.0 |
| 2025-08-25 10:30:00 | AAPL | Stock | 228.8 | 229.24 | 228.29 | 228.93 | 1657211.0 |
| 2025-08-25 11:00:00 | AAPL | Stock | 228.93 | 229.19 | 228.46 | 228.565 | 1322992.0 |
| 2025-08-25 11:30:00 | AAPL | Stock | 228.57 | 229.3 | 228.5001 | 229.16 | 998185.0 |
| 2025-08-25 12:00:00 | AAPL | Stock | 229.15 | 229.18 | 228.51 | 228.54 | 824308.0 |
| 2025-08-25 12:30:00 | AAPL | Stock | 228.54 | 228.6483 | 228.3477 | 228.505 | 787722.0 |
| 2025-08-25 13:00:00 | AAPL | Stock | 228.505 | 228.76 | 228.315 | 228.435 | 1008354.0 |
| 2025-08-25 13:30:00 | AAPL | Stock | 228.435 | 228.655 | 228.265 | 228.3 | 812372.0 |
| 2025-08-25 14:00:00 | AAPL | Stock | 228.31 | 228.3711 | 227.74 | 227.88 | 953395.0 |
| 2025-08-25 14:30:00 | AAPL | Stock | 227.875 | 227.905 | 227.445 | 227.55 | 1003395.0 |
| 2025-08-25 15:00:00 | AAPL | Stock | 227.545 | 227.8358 | 227.52 | 227.5984 | 951478.0 |
| 2025-08-25 15:30:00 | AAPL | Stock | 227.6 | 227.72 | 227.12 | 227.15 | 2363494.0 |
| 2025-08-25 16:00:00 | AAPL | Stock | 227.18 | 227.412 | 227.1 | 227.25 | 3797632.0 |
| 2025-08-25 16:30:00 | AAPL | Stock | 227.25 | 227.35 | 227.03 | 227.27 | 13823.0 |
| 2025-08-25 17:00:00 | AAPL | Stock | 227.23 | 227.27 | 227.15 | 227.25 | 6570.0 |
| 2025-08-25 17:30:00 | AAPL | Stock | 227.2 | 227.2 | 227.07 | 227.1012 | 3075.0 |
| 2025-08-25 18:00:00 | AAPL | Stock | 227.16 | 227.37 | 227.16 | 227.34 | 4193.0 |
| 2025-08-25 18:30:00 | AAPL | Stock | 227.2007 | 227.29 | 227.2 | 227.21 | 2215.0 |
| 2025-08-25 19:00:00 | AAPL | Stock | 227.28 | 227.3 | 227.06 | 227.06 | 2538.0 |
| 2025-08-25 19:30:00 | AAPL | Stock | 227.14 | 227.2742 | 227.03 | 227.07 | 3527.0 |
| 2025-08-25 04:00:00 | MSFT | Stock | 506.72 | 507.36 | 506.72 | 507.36 | 3372.0 |
| 2025-08-25 04:30:00 | MSFT | Stock | 507.5 | 507.5 | 506.95 | 507.05 | 933.0 |
| 2025-08-25 05:00:00 | MSFT | Stock | 507.16 | 507.16 | 505.0 | 505.4 | 5546.0 |
| 2025-08-25 05:30:00 | MSFT | Stock | 505.7 | 505.7 | 505.7 | 505.7 | 256.0 |
| 2025-08-25 06:00:00 | MSFT | Stock | 505.62 | 505.62 | 505.4 | 505.4 | 1601.0 |
| 2025-08-25 06:30:00 | MSFT | Stock | 505.49 | 505.9 | 505.49 | 505.84 | 658.0 |
| 2025-08-25 07:00:00 | MSFT | Stock | 505.82 | 506.12 | 505.23 | 505.23 | 1302.0 |
| 2025-08-25 07:30:00 | MSFT | Stock | 505.57 | 505.57 | 504.88 | 504.98 | 3301.0 |
| 2025-08-25 08:00:00 | MSFT | Stock | 505.82 | 507.3 | 504.7399 | 504.8573 | 18784.0 |
| 2025-08-25 08:30:00 | MSFT | Stock | 504.78 | 505.31 | 504.78 | 505.0 | 5224.0 |
| 2025-08-25 09:00:00 | MSFT | Stock | 504.9 | 507.02 | 503.7025 | 506.6 | 29903.0 |
| 2025-08-25 09:30:00 | MSFT | Stock | 506.62 | 508.15 | 504.59 | 506.78 | 1142187.0 |
| 2025-08-25 10:00:00 | MSFT | Stock | 506.775 | 508.1799 | 506.05 | 507.21 | 456157.0 |
| 2025-08-25 10:30:00 | MSFT | Stock | 507.1775 | 508.1 | 506.73 | 507.375 | 383690.0 |
| 2025-08-25 11:00:00 | MSFT | Stock | 507.36 | 508.19 | 507.31 | 507.4 | 654356.0 |
| 2025-08-25 11:30:00 | MSFT | Stock | 507.38 | 507.65 | 506.7 | 507.2 | 518185.0 |
| 2025-08-25 12:00:00 | MSFT | Stock | 507.16 | 507.84 | 507.03 | 507.25 | 388310.0 |
| 2025-08-25 12:30:00 | MSFT | Stock | 507.22 | 507.4091 | 506.725 | 506.8268 | 272867.0 |
> showing 50 of 106,645 rows — these rows as CSV