PREVIEW / stock_30min / 2025-08-29
file: by_date/stock_30min/2025/2025-08-29.parquet size: 2.2 MB rows: 103,420 symbols: 328
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-29 04:00:00 | AAPL | Stock | 232.01 | 232.13 | 231.5 | 231.62 | 7391.0 |
| 2025-08-29 04:30:00 | AAPL | Stock | 231.66 | 231.72 | 231.5 | 231.5 | 1213.0 |
| 2025-08-29 05:00:00 | AAPL | Stock | 231.39 | 231.49 | 231.26 | 231.42 | 2120.0 |
| 2025-08-29 05:30:00 | AAPL | Stock | 231.41 | 231.49 | 231.4 | 231.42 | 877.0 |
| 2025-08-29 06:00:00 | AAPL | Stock | 231.41 | 231.61 | 231.41 | 231.6 | 2960.0 |
| 2025-08-29 06:30:00 | AAPL | Stock | 231.5 | 231.55 | 231.29 | 231.3 | 9331.0 |
| 2025-08-29 07:00:00 | AAPL | Stock | 231.6 | 232.22 | 231.6 | 232.06 | 5169.0 |
| 2025-08-29 07:30:00 | AAPL | Stock | 232.1 | 232.24 | 232.08 | 232.15 | 3485.0 |
| 2025-08-29 08:00:00 | AAPL | Stock | 231.94 | 232.36 | 231.3 | 232.25 | 51214.0 |
| 2025-08-29 08:30:00 | AAPL | Stock | 232.28 | 232.88 | 232.23 | 232.75 | 30163.0 |
| 2025-08-29 09:00:00 | AAPL | Stock | 232.87 | 232.93 | 231.92 | 232.571 | 38882.0 |
| 2025-08-29 09:30:00 | AAPL | Stock | 232.55 | 233.38 | 231.83 | 232.56 | 3164001.0 |
| 2025-08-29 10:00:00 | AAPL | Stock | 232.58 | 232.9 | 231.37 | 232.8096 | 2691283.0 |
| 2025-08-29 10:30:00 | AAPL | Stock | 232.805 | 233.16 | 232.5 | 232.875 | 1449995.0 |
| 2025-08-29 11:00:00 | AAPL | Stock | 232.86 | 233.11 | 232.62 | 232.96 | 1220333.0 |
| 2025-08-29 11:30:00 | AAPL | Stock | 232.98 | 233.03 | 231.4 | 231.7732 | 2306979.0 |
| 2025-08-29 12:00:00 | AAPL | Stock | 231.75 | 232.62 | 231.73 | 232.5 | 1200021.0 |
| 2025-08-29 12:30:00 | AAPL | Stock | 232.51 | 232.96 | 232.51 | 232.86 | 887854.0 |
| 2025-08-29 13:00:00 | AAPL | Stock | 232.85 | 232.86 | 231.98 | 232.03 | 1053668.0 |
| 2025-08-29 13:30:00 | AAPL | Stock | 232.0325 | 232.58 | 232.02 | 232.33 | 804417.0 |
| 2025-08-29 14:00:00 | AAPL | Stock | 232.33 | 232.47 | 231.97 | 232.18 | 944490.0 |
| 2025-08-29 14:30:00 | AAPL | Stock | 232.19 | 232.415 | 232.0 | 232.15 | 770719.0 |
| 2025-08-29 15:00:00 | AAPL | Stock | 232.1499 | 232.75 | 232.1102 | 232.3543 | 1009844.0 |
| 2025-08-29 15:30:00 | AAPL | Stock | 232.36 | 232.8377 | 231.48 | 232.27 | 3604910.0 |
| 2025-08-29 16:00:00 | AAPL | Stock | 232.27 | 232.86 | 231.89 | 231.95 | 6942137.0 |
| 2025-08-29 16:30:00 | AAPL | Stock | 231.99 | 232.14 | 231.9 | 232.0001 | 16761.0 |
| 2025-08-29 17:00:00 | AAPL | Stock | 232.09 | 232.1 | 232.0 | 232.1 | 19944.0 |
| 2025-08-29 17:30:00 | AAPL | Stock | 232.13 | 232.14 | 232.0 | 232.1 | 1736.0 |
| 2025-08-29 18:00:00 | AAPL | Stock | 232.1001 | 232.19 | 232.0 | 232.0564 | 7386.0 |
| 2025-08-29 18:30:00 | AAPL | Stock | 232.07 | 232.1027 | 232.01 | 232.1 | 3661.0 |
| 2025-08-29 19:00:00 | AAPL | Stock | 232.1 | 232.15 | 232.0256 | 232.08 | 2652.0 |
| 2025-08-29 19:30:00 | AAPL | Stock | 232.08 | 232.08 | 231.91 | 232.01 | 12862.0 |
| 2025-08-29 04:00:00 | MSFT | Stock | 509.56 | 509.56 | 508.49 | 508.6 | 1285.0 |
| 2025-08-29 04:30:00 | MSFT | Stock | 508.31 | 508.31 | 508.31 | 508.31 | 107.0 |
| 2025-08-29 05:00:00 | MSFT | Stock | 508.71 | 508.71 | 508.71 | 508.71 | 125.0 |
| 2025-08-29 05:30:00 | MSFT | Stock | 508.93 | 508.93 | 508.88 | 508.88 | 200.0 |
| 2025-08-29 06:00:00 | MSFT | Stock | 508.76 | 509.01 | 508.76 | 509.01 | 717.0 |
| 2025-08-29 06:30:00 | MSFT | Stock | 509.0 | 509.0 | 508.5 | 508.5 | 640.0 |
| 2025-08-29 07:00:00 | MSFT | Stock | 509.0 | 509.1 | 509.0 | 509.0 | 866.0 |
| 2025-08-29 07:30:00 | MSFT | Stock | 508.99 | 509.125 | 508.6 | 508.6 | 1129.0 |
| 2025-08-29 08:00:00 | MSFT | Stock | 509.0 | 509.65 | 508.23 | 508.5 | 7051.0 |
| 2025-08-29 08:30:00 | MSFT | Stock | 508.7 | 509.19 | 508.5041 | 508.51 | 10435.0 |
| 2025-08-29 09:00:00 | MSFT | Stock | 509.25 | 509.6 | 508.4 | 508.4208 | 7181.0 |
| 2025-08-29 09:30:00 | MSFT | Stock | 508.43 | 509.6 | 504.68 | 504.74 | 1052999.0 |
| 2025-08-29 10:00:00 | MSFT | Stock | 504.93 | 506.38 | 504.4915 | 506.08 | 686400.0 |
| 2025-08-29 10:30:00 | MSFT | Stock | 506.01 | 506.96 | 505.64 | 506.825 | 376545.0 |
| 2025-08-29 11:00:00 | MSFT | Stock | 506.77 | 508.36 | 506.45 | 508.12 | 389701.0 |
| 2025-08-29 11:30:00 | MSFT | Stock | 508.12 | 508.195 | 507.12 | 507.25 | 464154.0 |
| 2025-08-29 12:00:00 | MSFT | Stock | 507.265 | 508.0482 | 507.2281 | 507.43 | 401765.0 |
| 2025-08-29 12:30:00 | MSFT | Stock | 507.425 | 508.81 | 507.3251 | 508.67 | 434791.0 |
> showing 50 of 103,420 rows — these rows as CSV