PREVIEW / stock_30min / 2025-12-18
file: by_date/stock_30min/2025/2025-12-18.parquet size: 2.2 MB rows: 102,254 symbols: 180
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-12-18 04:00:00 | AAPL | Stock | 271.35 | 271.99 | 271.35 | 271.56 | 6275.0 |
| 2025-12-18 04:30:00 | AAPL | Stock | 271.65 | 271.85 | 271.5 | 271.81 | 7585.0 |
| 2025-12-18 05:00:00 | AAPL | Stock | 271.85 | 271.85 | 271.57 | 271.67 | 3401.0 |
| 2025-12-18 05:30:00 | AAPL | Stock | 271.6 | 271.74 | 271.45 | 271.49 | 3079.0 |
| 2025-12-18 06:00:00 | AAPL | Stock | 271.5 | 271.77 | 271.39 | 271.77 | 1969.0 |
| 2025-12-18 06:30:00 | AAPL | Stock | 271.66 | 271.69 | 271.65 | 271.69 | 702.0 |
| 2025-12-18 07:00:00 | AAPL | Stock | 271.79 | 271.89 | 271.64 | 271.66 | 4770.0 |
| 2025-12-18 07:30:00 | AAPL | Stock | 271.62 | 271.69 | 271.32 | 271.32 | 6297.0 |
| 2025-12-18 08:00:00 | AAPL | Stock | 271.69 | 272.0 | 271.32 | 271.44 | 37147.0 |
| 2025-12-18 08:30:00 | AAPL | Stock | 271.5 | 272.78 | 271.41 | 272.3 | 61393.0 |
| 2025-12-18 09:00:00 | AAPL | Stock | 272.38 | 273.75 | 272.25 | 273.67 | 64706.0 |
| 2025-12-18 09:30:00 | AAPL | Stock | 273.605 | 273.63 | 266.95 | 268.82 | 7099248.0 |
| 2025-12-18 10:00:00 | AAPL | Stock | 268.82 | 271.065 | 268.38 | 270.9 | 3065458.0 |
| 2025-12-18 10:30:00 | AAPL | Stock | 270.862 | 272.225 | 270.81 | 272.02 | 2011509.0 |
| 2025-12-18 11:00:00 | AAPL | Stock | 272.0 | 272.72 | 271.93 | 272.3 | 1674823.0 |
| 2025-12-18 11:30:00 | AAPL | Stock | 272.29 | 273.164 | 272.26 | 272.86 | 1169989.0 |
| 2025-12-18 12:00:00 | AAPL | Stock | 272.855 | 272.86 | 269.94 | 270.23 | 1196542.0 |
| 2025-12-18 12:30:00 | AAPL | Stock | 270.21 | 272.42 | 270.1 | 272.4 | 1088652.0 |
| 2025-12-18 13:00:00 | AAPL | Stock | 272.37 | 272.75 | 271.86 | 272.65 | 772269.0 |
| 2025-12-18 13:30:00 | AAPL | Stock | 272.665 | 272.96 | 271.61 | 271.75 | 951810.0 |
| 2025-12-18 14:00:00 | AAPL | Stock | 271.715 | 271.9 | 271.09 | 271.37 | 1129154.0 |
| 2025-12-18 14:30:00 | AAPL | Stock | 271.3705 | 271.39 | 270.5 | 270.865 | 1317361.0 |
| 2025-12-18 15:00:00 | AAPL | Stock | 270.88 | 271.9699 | 270.67 | 271.84 | 1418360.0 |
| 2025-12-18 15:30:00 | AAPL | Stock | 271.85 | 273.21 | 271.785 | 272.16 | 2928468.0 |
| 2025-12-18 16:00:00 | AAPL | Stock | 272.13 | 272.19 | 271.54 | 271.78 | 10959642.0 |
| 2025-12-18 16:30:00 | AAPL | Stock | 271.7 | 272.19 | 271.01 | 271.54 | 6034.0 |
| 2025-12-18 17:00:00 | AAPL | Stock | 271.68 | 272.19 | 271.4378 | 271.58 | 5782.0 |
| 2025-12-18 17:30:00 | AAPL | Stock | 271.55 | 272.19 | 271.4208 | 271.4208 | 5120.0 |
| 2025-12-18 18:00:00 | AAPL | Stock | 271.42 | 271.68 | 271.01 | 271.2 | 14467.0 |
| 2025-12-18 18:30:00 | AAPL | Stock | 271.2 | 271.52 | 271.05 | 271.52 | 4913.0 |
| 2025-12-18 19:00:00 | AAPL | Stock | 271.52 | 271.82 | 271.32 | 271.53 | 5350.0 |
| 2025-12-18 19:30:00 | AAPL | Stock | 271.34 | 271.39 | 271.04 | 271.39 | 5227.0 |
| 2025-12-18 04:00:00 | MSFT | Stock | 479.0 | 479.28 | 478.4 | 479.2 | 5810.0 |
| 2025-12-18 04:30:00 | MSFT | Stock | 479.22 | 479.75 | 478.8 | 479.75 | 2877.0 |
| 2025-12-18 05:00:00 | MSFT | Stock | 479.61 | 479.85 | 479.16 | 479.33 | 3167.0 |
| 2025-12-18 05:30:00 | MSFT | Stock | 479.61 | 479.61 | 479.0 | 479.17 | 1016.0 |
| 2025-12-18 06:00:00 | MSFT | Stock | 479.27 | 479.45 | 479.13 | 479.13 | 1027.0 |
| 2025-12-18 06:30:00 | MSFT | Stock | 479.2 | 479.5 | 479.2 | 479.36 | 515.0 |
| 2025-12-18 07:00:00 | MSFT | Stock | 479.24 | 479.25 | 478.68 | 478.72 | 2903.0 |
| 2025-12-18 07:30:00 | MSFT | Stock | 478.87 | 479.0 | 478.41 | 478.61 | 2423.0 |
| 2025-12-18 08:00:00 | MSFT | Stock | 478.88 | 479.6736 | 476.61 | 479.31 | 20044.0 |
| 2025-12-18 08:30:00 | MSFT | Stock | 479.4 | 480.46 | 478.59 | 479.74 | 32574.0 |
| 2025-12-18 09:00:00 | MSFT | Stock | 479.8 | 480.23 | 477.78 | 478.25 | 43225.0 |
| 2025-12-18 09:30:00 | MSFT | Stock | 478.19 | 483.83 | 477.89 | 483.45 | 1940049.0 |
| 2025-12-18 10:00:00 | MSFT | Stock | 483.445 | 485.395 | 482.94 | 484.74 | 1817295.0 |
| 2025-12-18 10:30:00 | MSFT | Stock | 484.71 | 487.58 | 484.2906 | 487.58 | 1226624.0 |
| 2025-12-18 11:00:00 | MSFT | Stock | 487.555 | 488.08 | 487.06 | 487.65 | 835621.0 |
| 2025-12-18 11:30:00 | MSFT | Stock | 487.635 | 489.6 | 487.16 | 487.19 | 927445.0 |
| 2025-12-18 12:00:00 | MSFT | Stock | 487.17 | 487.34 | 484.19 | 484.95 | 741895.0 |
| 2025-12-18 12:30:00 | MSFT | Stock | 484.96 | 487.15 | 484.7723 | 486.83 | 567494.0 |
> showing 50 of 102,254 rows — these rows as CSV