PREVIEW / stock_30min / 2025-08-28
file: by_date/stock_30min/2025/2025-08-28.parquet size: 2.2 MB rows: 103,864 symbols: 324
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-28 04:00:00 | AAPL | Stock | 231.3 | 231.6 | 231.0 | 231.48 | 10983.0 |
| 2025-08-28 04:30:00 | AAPL | Stock | 231.47 | 231.47 | 231.21 | 231.21 | 2912.0 |
| 2025-08-28 05:00:00 | AAPL | Stock | 231.23 | 231.3 | 231.23 | 231.24 | 1973.0 |
| 2025-08-28 05:30:00 | AAPL | Stock | 231.3 | 231.38 | 231.25 | 231.25 | 1082.0 |
| 2025-08-28 06:00:00 | AAPL | Stock | 231.21 | 231.22 | 231.19 | 231.19 | 4342.0 |
| 2025-08-28 06:30:00 | AAPL | Stock | 231.27 | 231.27 | 231.09 | 231.09 | 1595.0 |
| 2025-08-28 07:00:00 | AAPL | Stock | 231.17 | 231.17 | 230.9 | 230.9 | 2967.0 |
| 2025-08-28 07:30:00 | AAPL | Stock | 230.89 | 231.1 | 230.88 | 231.1 | 4516.0 |
| 2025-08-28 08:00:00 | AAPL | Stock | 230.95 | 231.6 | 230.77 | 231.0 | 54539.0 |
| 2025-08-28 08:30:00 | AAPL | Stock | 231.0 | 231.25 | 230.88 | 230.94 | 44025.0 |
| 2025-08-28 09:00:00 | AAPL | Stock | 230.9899 | 231.5 | 230.73 | 230.82 | 118909.0 |
| 2025-08-28 09:30:00 | AAPL | Stock | 230.82 | 230.9 | 229.335 | 230.49 | 3143125.0 |
| 2025-08-28 10:00:00 | AAPL | Stock | 230.44 | 230.9 | 230.01 | 230.4158 | 1400833.0 |
| 2025-08-28 10:30:00 | AAPL | Stock | 230.44 | 231.91 | 230.35 | 231.3599 | 1750818.0 |
| 2025-08-28 11:00:00 | AAPL | Stock | 231.36 | 231.59 | 230.71 | 230.95 | 1190913.0 |
| 2025-08-28 11:30:00 | AAPL | Stock | 230.96 | 231.785 | 230.9482 | 231.555 | 1091636.0 |
| 2025-08-28 12:00:00 | AAPL | Stock | 231.55 | 232.355 | 231.41 | 232.29 | 1240917.0 |
| 2025-08-28 12:30:00 | AAPL | Stock | 232.28 | 232.59 | 232.08 | 232.45 | 1450109.0 |
| 2025-08-28 13:00:00 | AAPL | Stock | 232.46 | 233.12 | 232.39 | 233.0 | 1367541.0 |
| 2025-08-28 13:30:00 | AAPL | Stock | 233.01 | 233.38 | 232.925 | 233.165 | 1088290.0 |
| 2025-08-28 14:00:00 | AAPL | Stock | 233.16 | 233.41 | 232.83 | 232.92 | 1304456.0 |
| 2025-08-28 14:30:00 | AAPL | Stock | 232.92 | 233.17 | 232.69 | 232.87 | 940931.0 |
| 2025-08-28 15:00:00 | AAPL | Stock | 232.87 | 233.06 | 232.71 | 232.975 | 1032441.0 |
| 2025-08-28 15:30:00 | AAPL | Stock | 232.975 | 233.33 | 232.48 | 232.49 | 3812612.0 |
| 2025-08-28 16:00:00 | AAPL | Stock | 232.49 | 232.75 | 232.1784 | 232.3701 | 5822720.0 |
| 2025-08-28 16:30:00 | AAPL | Stock | 232.37 | 232.56 | 232.25 | 232.5 | 24178.0 |
| 2025-08-28 17:00:00 | AAPL | Stock | 232.49 | 232.56 | 232.49 | 232.5 | 5341.0 |
| 2025-08-28 17:30:00 | AAPL | Stock | 232.45 | 232.67 | 232.41 | 232.52 | 14951.0 |
| 2025-08-28 18:00:00 | AAPL | Stock | 232.6 | 232.63 | 232.45 | 232.45 | 5905.0 |
| 2025-08-28 18:30:00 | AAPL | Stock | 232.4 | 232.55 | 232.34 | 232.42 | 4842.0 |
| 2025-08-28 19:00:00 | AAPL | Stock | 232.47 | 232.52 | 232.41 | 232.43 | 2185.0 |
| 2025-08-28 19:30:00 | AAPL | Stock | 232.43 | 232.56 | 232.43 | 232.56 | 9900.0 |
| 2025-08-28 04:00:00 | MSFT | Stock | 508.8 | 509.61 | 508.79 | 509.56 | 1720.0 |
| 2025-08-28 04:30:00 | MSFT | Stock | 509.54 | 509.54 | 508.74 | 508.74 | 2500.0 |
| 2025-08-28 05:00:00 | MSFT | Stock | 508.7 | 508.7 | 508.4 | 508.4 | 300.0 |
| 2025-08-28 05:30:00 | MSFT | Stock | 508.19 | 508.19 | 507.81 | 507.83 | 3805.0 |
| 2025-08-28 06:00:00 | MSFT | Stock | 507.82 | 507.99 | 507.82 | 507.99 | 956.0 |
| 2025-08-28 06:30:00 | MSFT | Stock | 508.18 | 508.2 | 508.18 | 508.2 | 423.0 |
| 2025-08-28 07:00:00 | MSFT | Stock | 507.99 | 508.07 | 507.5 | 507.5 | 1256.0 |
| 2025-08-28 07:30:00 | MSFT | Stock | 507.7 | 509.21 | 507.7 | 509.21 | 3271.0 |
| 2025-08-28 08:00:00 | MSFT | Stock | 508.9619 | 509.48 | 507.31 | 509.05 | 24248.0 |
| 2025-08-28 08:30:00 | MSFT | Stock | 509.2 | 509.6 | 507.81 | 508.1596 | 12170.0 |
| 2025-08-28 09:00:00 | MSFT | Stock | 508.4167 | 508.78 | 506.74 | 507.09 | 28983.0 |
| 2025-08-28 09:30:00 | MSFT | Stock | 507.09 | 510.25 | 505.5 | 506.79 | 1369665.0 |
| 2025-08-28 10:00:00 | MSFT | Stock | 506.65 | 507.2799 | 505.913 | 506.03 | 545819.0 |
| 2025-08-28 10:30:00 | MSFT | Stock | 506.045 | 507.715 | 505.8322 | 507.0 | 444638.0 |
| 2025-08-28 11:00:00 | MSFT | Stock | 507.0 | 508.7 | 506.95 | 507.23 | 533543.0 |
| 2025-08-28 11:30:00 | MSFT | Stock | 507.23 | 508.145 | 507.15 | 508.095 | 283923.0 |
| 2025-08-28 12:00:00 | MSFT | Stock | 508.08 | 509.4 | 507.92 | 508.97 | 618509.0 |
| 2025-08-28 12:30:00 | MSFT | Stock | 508.955 | 509.0 | 507.6102 | 507.83 | 268414.0 |
> showing 50 of 103,864 rows — these rows as CSV