PREVIEW / stock_30min / 2025-12-23
file: by_date/stock_30min/2025/2025-12-23.parquet size: 2.1 MB rows: 101,360 symbols: 178
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-23 04:00:00 | AAPL | Stock | 270.8 | 271.14 | 270.76 | 271.02 | 7372.0 |
| 2025-12-23 04:30:00 | AAPL | Stock | 271.0 | 271.03 | 270.8 | 270.8 | 1743.0 |
| 2025-12-23 05:00:00 | AAPL | Stock | 270.84 | 270.92 | 270.84 | 270.92 | 1815.0 |
| 2025-12-23 05:30:00 | AAPL | Stock | 270.88 | 270.95 | 270.88 | 270.95 | 400.0 |
| 2025-12-23 06:00:00 | AAPL | Stock | 270.95 | 270.95 | 270.85 | 270.86 | 747.0 |
| 2025-12-23 06:30:00 | AAPL | Stock | 270.81 | 271.28 | 270.81 | 271.28 | 11568.0 |
| 2025-12-23 07:00:00 | AAPL | Stock | 271.24 | 271.24 | 270.81 | 270.86 | 5589.0 |
| 2025-12-23 07:30:00 | AAPL | Stock | 270.85 | 271.0 | 270.85 | 271.0 | 4297.0 |
| 2025-12-23 08:00:00 | AAPL | Stock | 270.99 | 271.3 | 270.51 | 271.3 | 36002.0 |
| 2025-12-23 08:30:00 | AAPL | Stock | 271.29 | 271.29 | 270.88 | 271.12 | 25150.0 |
| 2025-12-23 09:00:00 | AAPL | Stock | 271.17 | 271.666 | 270.32 | 270.94 | 75869.0 |
| 2025-12-23 09:30:00 | AAPL | Stock | 270.84 | 271.93 | 269.56 | 271.23 | 3057709.0 |
| 2025-12-23 10:00:00 | AAPL | Stock | 271.225 | 271.61 | 270.56 | 270.84 | 1730452.0 |
| 2025-12-23 10:30:00 | AAPL | Stock | 270.84 | 271.57 | 270.7 | 271.46 | 948718.0 |
| 2025-12-23 11:00:00 | AAPL | Stock | 271.44 | 271.95 | 271.4301 | 271.7814 | 1293531.0 |
| 2025-12-23 11:30:00 | AAPL | Stock | 271.79 | 272.32 | 271.72 | 272.159 | 993118.0 |
| 2025-12-23 12:00:00 | AAPL | Stock | 272.145 | 272.2315 | 271.473 | 271.53 | 1028888.0 |
| 2025-12-23 12:30:00 | AAPL | Stock | 271.54 | 271.65 | 271.11 | 271.61 | 651565.0 |
| 2025-12-23 13:00:00 | AAPL | Stock | 271.6 | 271.81 | 271.5 | 271.7 | 573173.0 |
| 2025-12-23 13:30:00 | AAPL | Stock | 271.7 | 272.12 | 271.64 | 271.7 | 642593.0 |
| 2025-12-23 14:00:00 | AAPL | Stock | 271.7 | 271.81 | 271.5 | 271.81 | 778258.0 |
| 2025-12-23 14:30:00 | AAPL | Stock | 271.81 | 272.44 | 271.76 | 272.085 | 952865.0 |
| 2025-12-23 15:00:00 | AAPL | Stock | 272.09 | 272.1799 | 271.93 | 272.11 | 883277.0 |
| 2025-12-23 15:30:00 | AAPL | Stock | 272.1 | 272.5 | 271.84 | 272.32 | 2598228.0 |
| 2025-12-23 16:00:00 | AAPL | Stock | 272.24 | 272.39 | 272.09 | 272.21 | 5900060.0 |
| 2025-12-23 16:30:00 | AAPL | Stock | 272.22 | 272.36 | 272.1 | 272.1 | 42824.0 |
| 2025-12-23 17:00:00 | AAPL | Stock | 272.19 | 272.2 | 272.05 | 272.19 | 6146.0 |
| 2025-12-23 17:30:00 | AAPL | Stock | 272.2 | 272.2 | 272.0792 | 272.18 | 4751.0 |
| 2025-12-23 18:00:00 | AAPL | Stock | 272.1599 | 272.21 | 272.08 | 272.18 | 4117.0 |
| 2025-12-23 18:30:00 | AAPL | Stock | 272.17 | 272.17 | 272.1 | 272.1 | 1632.0 |
| 2025-12-23 19:00:00 | AAPL | Stock | 272.1419 | 272.18 | 272.1419 | 272.17 | 2751.0 |
| 2025-12-23 19:30:00 | AAPL | Stock | 272.16 | 272.18 | 272.15 | 272.18 | 5847.0 |
| 2025-12-23 04:00:00 | MSFT | Stock | 484.93 | 485.58 | 484.93 | 485.15 | 812.0 |
| 2025-12-23 04:30:00 | MSFT | Stock | 485.16 | 485.65 | 485.01 | 485.53 | 3604.0 |
| 2025-12-23 05:00:00 | MSFT | Stock | 485.58 | 485.75 | 485.34 | 485.34 | 1422.0 |
| 2025-12-23 05:30:00 | MSFT | Stock | 485.32 | 485.32 | 485.32 | 485.32 | 73.0 |
| 2025-12-23 06:00:00 | MSFT | Stock | 485.51 | 485.72 | 485.29 | 485.72 | 1852.0 |
| 2025-12-23 06:30:00 | MSFT | Stock | 485.78 | 485.79 | 485.62 | 485.62 | 236.0 |
| 2025-12-23 07:00:00 | MSFT | Stock | 485.65 | 486.0 | 485.28 | 485.28 | 14093.0 |
| 2025-12-23 07:30:00 | MSFT | Stock | 485.2 | 485.69 | 485.2 | 485.67 | 1070.0 |
| 2025-12-23 08:00:00 | MSFT | Stock | 485.72 | 486.35 | 484.3 | 485.65 | 15477.0 |
| 2025-12-23 08:30:00 | MSFT | Stock | 485.7762 | 485.78 | 484.95 | 485.1 | 8956.0 |
| 2025-12-23 09:00:00 | MSFT | Stock | 485.1 | 485.23 | 484.5 | 484.94 | 12667.0 |
| 2025-12-23 09:30:00 | MSFT | Stock | 484.98 | 487.83 | 484.74 | 485.84 | 1557959.0 |
| 2025-12-23 10:00:00 | MSFT | Stock | 485.8 | 486.455 | 485.52 | 485.895 | 787779.0 |
| 2025-12-23 10:30:00 | MSFT | Stock | 485.88 | 486.39 | 485.73 | 485.815 | 543922.0 |
| 2025-12-23 11:00:00 | MSFT | Stock | 485.85 | 487.11 | 485.81 | 486.81 | 557993.0 |
| 2025-12-23 11:30:00 | MSFT | Stock | 486.81 | 487.29 | 486.26 | 486.485 | 468662.0 |
| 2025-12-23 12:00:00 | MSFT | Stock | 486.485 | 487.28 | 486.45 | 486.67 | 348923.0 |
| 2025-12-23 12:30:00 | MSFT | Stock | 486.66 | 486.82 | 486.0301 | 486.235 | 269844.0 |
> showing 50 of 101,360 rows — these rows as CSV