PREVIEW / stock_30min / 2025-12-19
file: by_date/stock_30min/2025/2025-12-19.parquet size: 2.2 MB rows: 101,853 symbols: 179
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-19 04:00:00 | AAPL | Stock | 272.0 | 272.51 | 272.0 | 272.23 | 2365.0 |
| 2025-12-19 04:30:00 | AAPL | Stock | 272.18 | 272.18 | 272.18 | 272.18 | 257.0 |
| 2025-12-19 05:00:00 | AAPL | Stock | 272.2 | 272.45 | 272.08 | 272.45 | 2468.0 |
| 2025-12-19 05:30:00 | AAPL | Stock | 272.35 | 272.46 | 272.12 | 272.35 | 3595.0 |
| 2025-12-19 06:00:00 | AAPL | Stock | 272.35 | 272.35 | 272.04 | 272.16 | 788.0 |
| 2025-12-19 06:30:00 | AAPL | Stock | 271.9 | 271.9 | 271.6 | 271.6 | 200.0 |
| 2025-12-19 07:00:00 | AAPL | Stock | 271.6 | 271.84 | 271.29 | 271.4 | 9316.0 |
| 2025-12-19 07:30:00 | AAPL | Stock | 271.36 | 271.36 | 270.51 | 270.67 | 6752.0 |
| 2025-12-19 08:00:00 | AAPL | Stock | 272.52 | 272.52 | 270.5 | 270.98 | 37303.0 |
| 2025-12-19 08:30:00 | AAPL | Stock | 270.95 | 271.56 | 270.8 | 271.53 | 20212.0 |
| 2025-12-19 09:00:00 | AAPL | Stock | 271.45 | 272.63 | 270.8 | 272.51 | 144045.0 |
| 2025-12-19 09:30:00 | AAPL | Stock | 272.39 | 272.92 | 271.4547 | 271.7 | 13596922.0 |
| 2025-12-19 10:00:00 | AAPL | Stock | 271.69 | 272.18 | 270.95 | 271.735 | 2150410.0 |
| 2025-12-19 10:30:00 | AAPL | Stock | 271.7201 | 272.82 | 271.17 | 271.21 | 1823737.0 |
| 2025-12-19 11:00:00 | AAPL | Stock | 271.21 | 271.96 | 270.995 | 271.2608 | 1259563.0 |
| 2025-12-19 11:30:00 | AAPL | Stock | 271.25 | 271.46 | 270.84 | 270.99 | 1263432.0 |
| 2025-12-19 12:00:00 | AAPL | Stock | 271.0 | 271.18 | 270.265 | 270.655 | 1546339.0 |
| 2025-12-19 12:30:00 | AAPL | Stock | 270.66 | 271.63 | 270.33 | 271.4401 | 1522814.0 |
| 2025-12-19 13:00:00 | AAPL | Stock | 271.45 | 271.8095 | 270.74 | 270.75 | 1227307.0 |
| 2025-12-19 13:30:00 | AAPL | Stock | 270.76 | 271.07 | 270.4 | 270.86 | 1368205.0 |
| 2025-12-19 14:00:00 | AAPL | Stock | 270.85 | 271.51 | 270.56 | 271.37 | 1398471.0 |
| 2025-12-19 14:30:00 | AAPL | Stock | 271.38 | 271.74 | 271.345 | 271.47 | 1076550.0 |
| 2025-12-19 15:00:00 | AAPL | Stock | 271.46 | 271.56 | 270.175 | 270.8 | 2243739.0 |
| 2025-12-19 15:30:00 | AAPL | Stock | 270.81 | 274.6 | 269.9 | 273.62 | 9157337.0 |
| 2025-12-19 16:00:00 | AAPL | Stock | 273.86 | 274.54 | 272.5265 | 272.7 | 50036207.0 |
| 2025-12-19 16:30:00 | AAPL | Stock | 272.67 | 273.67 | 272.35 | 272.6499 | 77477.0 |
| 2025-12-19 17:00:00 | AAPL | Stock | 272.4801 | 272.9999 | 272.4801 | 272.85 | 13035.0 |
| 2025-12-19 17:30:00 | AAPL | Stock | 272.8598 | 273.0 | 272.55 | 272.77 | 8268.0 |
| 2025-12-19 18:00:00 | AAPL | Stock | 272.79 | 273.0 | 272.7084 | 272.91 | 7619.0 |
| 2025-12-19 18:30:00 | AAPL | Stock | 272.9481 | 272.97 | 272.91 | 272.9504 | 6910.0 |
| 2025-12-19 19:00:00 | AAPL | Stock | 272.98 | 273.0 | 272.97 | 272.9916 | 5455.0 |
| 2025-12-19 19:30:00 | AAPL | Stock | 272.9999 | 273.02 | 272.96 | 273.01 | 8187.0 |
| 2025-12-19 04:00:00 | MSFT | Stock | 484.8 | 485.98 | 484.78 | 485.9 | 1936.0 |
| 2025-12-19 04:30:00 | MSFT | Stock | 485.98 | 486.22 | 485.98 | 486.0 | 1007.0 |
| 2025-12-19 05:00:00 | MSFT | Stock | 485.8 | 485.8 | 485.47 | 485.47 | 802.0 |
| 2025-12-19 05:30:00 | MSFT | Stock | 485.16 | 485.36 | 485.0 | 485.0 | 1797.0 |
| 2025-12-19 06:00:00 | MSFT | Stock | 484.55 | 484.55 | 484.0 | 484.29 | 2037.0 |
| 2025-12-19 06:30:00 | MSFT | Stock | 484.5 | 484.79 | 484.5 | 484.51 | 1213.0 |
| 2025-12-19 07:00:00 | MSFT | Stock | 484.61 | 484.64 | 484.22 | 484.4 | 4523.0 |
| 2025-12-19 07:30:00 | MSFT | Stock | 484.43 | 484.83 | 484.13 | 484.51 | 4277.0 |
| 2025-12-19 08:00:00 | MSFT | Stock | 484.51 | 486.49 | 482.67 | 484.97 | 31292.0 |
| 2025-12-19 08:30:00 | MSFT | Stock | 484.91 | 485.6 | 484.91 | 485.06 | 4156.0 |
| 2025-12-19 09:00:00 | MSFT | Stock | 485.0 | 488.8 | 485.0 | 487.3 | 162578.0 |
| 2025-12-19 09:30:00 | MSFT | Stock | 487.38 | 487.85 | 482.95 | 486.4721 | 7808482.0 |
| 2025-12-19 10:00:00 | MSFT | Stock | 486.575 | 487.4699 | 484.97 | 485.5303 | 656574.0 |
| 2025-12-19 10:30:00 | MSFT | Stock | 485.51 | 486.8 | 484.11 | 484.46 | 763941.0 |
| 2025-12-19 11:00:00 | MSFT | Stock | 484.49 | 485.5699 | 484.2 | 485.1685 | 495250.0 |
| 2025-12-19 11:30:00 | MSFT | Stock | 485.15 | 485.76 | 484.2 | 484.41 | 472639.0 |
| 2025-12-19 12:00:00 | MSFT | Stock | 484.38 | 486.1299 | 484.23 | 485.875 | 758989.0 |
| 2025-12-19 12:30:00 | MSFT | Stock | 485.875 | 485.875 | 484.99 | 485.0005 | 373066.0 |
> showing 50 of 101,853 rows — these rows as CSV