PREVIEW / stock_30min / 2025-06-18
file: by_date/stock_30min/2025/2025-06-18.parquet size: 2.2 MB rows: 103,614 symbols: 393
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-06-18 04:00:00 | AAPL | Stock | 196.15 | 196.6 | 196.13 | 196.4 | 9254.0 |
| 2025-06-18 04:30:00 | AAPL | Stock | 196.43 | 196.58 | 196.38 | 196.5 | 7749.0 |
| 2025-06-18 05:00:00 | AAPL | Stock | 196.55 | 196.79 | 196.55 | 196.65 | 16433.0 |
| 2025-06-18 05:30:00 | AAPL | Stock | 196.61 | 196.64 | 196.51 | 196.55 | 4189.0 |
| 2025-06-18 06:00:00 | AAPL | Stock | 196.58 | 196.6 | 196.31 | 196.4 | 5697.0 |
| 2025-06-18 06:30:00 | AAPL | Stock | 196.36 | 196.4 | 195.81 | 195.99 | 11766.0 |
| 2025-06-18 07:00:00 | AAPL | Stock | 196.0 | 196.05 | 195.72 | 196.0 | 21611.0 |
| 2025-06-18 07:30:00 | AAPL | Stock | 196.02 | 196.28 | 195.95 | 196.16 | 9141.0 |
| 2025-06-18 08:00:00 | AAPL | Stock | 195.98 | 196.66 | 195.51 | 196.03 | 55218.0 |
| 2025-06-18 08:30:00 | AAPL | Stock | 196.0 | 196.12 | 195.98 | 196.07 | 15842.0 |
| 2025-06-18 09:00:00 | AAPL | Stock | 196.01 | 196.396 | 195.86 | 195.9188 | 49544.0 |
| 2025-06-18 09:30:00 | AAPL | Stock | 195.92 | 196.47 | 195.07 | 196.38 | 3550110.0 |
| 2025-06-18 10:00:00 | AAPL | Stock | 196.4 | 197.51 | 196.21 | 197.07 | 2587331.0 |
| 2025-06-18 10:30:00 | AAPL | Stock | 197.09 | 197.57 | 196.97 | 197.25 | 1606142.0 |
| 2025-06-18 11:00:00 | AAPL | Stock | 197.24 | 197.295 | 196.63 | 196.85 | 1355024.0 |
| 2025-06-18 11:30:00 | AAPL | Stock | 196.87 | 197.22 | 196.5003 | 196.82 | 1231487.0 |
| 2025-06-18 12:00:00 | AAPL | Stock | 196.82 | 197.23 | 196.76 | 196.9508 | 737457.0 |
| 2025-06-18 12:30:00 | AAPL | Stock | 196.95 | 197.02 | 196.42 | 196.455 | 914402.0 |
| 2025-06-18 13:00:00 | AAPL | Stock | 196.45 | 196.58 | 196.05 | 196.06 | 909284.0 |
| 2025-06-18 13:30:00 | AAPL | Stock | 196.07 | 196.8599 | 195.8 | 196.4999 | 1337123.0 |
| 2025-06-18 14:00:00 | AAPL | Stock | 196.46 | 196.98 | 195.63 | 195.91 | 1450584.0 |
| 2025-06-18 14:30:00 | AAPL | Stock | 195.91 | 196.46 | 195.11 | 195.36 | 1722498.0 |
| 2025-06-18 15:00:00 | AAPL | Stock | 195.37 | 196.2892 | 195.14 | 195.64 | 1908509.0 |
| 2025-06-18 15:30:00 | AAPL | Stock | 195.63 | 197.11 | 195.466 | 196.24 | 6167537.0 |
| 2025-06-18 16:00:00 | AAPL | Stock | 196.58 | 196.72 | 196.08 | 196.46 | 7698696.0 |
| 2025-06-18 16:30:00 | AAPL | Stock | 196.5 | 196.58 | 195.95 | 196.12 | 47318.0 |
| 2025-06-18 17:00:00 | AAPL | Stock | 196.3 | 196.3 | 195.81 | 195.9 | 32347.0 |
| 2025-06-18 17:30:00 | AAPL | Stock | 195.92 | 196.08 | 195.85 | 196.05 | 15036.0 |
| 2025-06-18 18:00:00 | AAPL | Stock | 196.06 | 196.08 | 195.99 | 196.07 | 4624.0 |
| 2025-06-18 18:30:00 | AAPL | Stock | 196.02 | 196.0798 | 195.9 | 196.05 | 11522.0 |
| 2025-06-18 19:00:00 | AAPL | Stock | 196.08 | 196.16 | 196.001 | 196.0144 | 5410.0 |
| 2025-06-18 19:30:00 | AAPL | Stock | 196.0 | 196.1 | 195.9 | 196.06 | 9933.0 |
| 2025-06-18 04:00:00 | MSFT | Stock | 478.15 | 478.85 | 477.87 | 478.65 | 1273.0 |
| 2025-06-18 04:30:00 | MSFT | Stock | 478.64 | 478.7 | 478.64 | 478.7 | 1148.0 |
| 2025-06-18 05:00:00 | MSFT | Stock | 479.29 | 479.29 | 478.99 | 478.99 | 1158.0 |
| 2025-06-18 05:30:00 | MSFT | Stock | 478.77 | 478.77 | 478.77 | 478.77 | 100.0 |
| 2025-06-18 06:00:00 | MSFT | Stock | 478.25 | 478.25 | 478.06 | 478.06 | 304.0 |
| 2025-06-18 06:30:00 | MSFT | Stock | 478.04 | 478.04 | 477.63 | 477.63 | 1987.0 |
| 2025-06-18 07:00:00 | MSFT | Stock | 477.51 | 477.55 | 476.94 | 477.0 | 7622.0 |
| 2025-06-18 07:30:00 | MSFT | Stock | 476.99 | 477.92 | 476.99 | 477.71 | 2249.0 |
| 2025-06-18 08:00:00 | MSFT | Stock | 477.4 | 478.78 | 476.93 | 477.68 | 5907.0 |
| 2025-06-18 08:30:00 | MSFT | Stock | 477.9401 | 478.0 | 477.5 | 477.78 | 4705.0 |
| 2025-06-18 09:00:00 | MSFT | Stock | 477.85 | 479.17 | 477.2 | 478.67 | 13930.0 |
| 2025-06-18 09:30:00 | MSFT | Stock | 478.0 | 478.51 | 475.2 | 477.21 | 1153264.0 |
| 2025-06-18 10:00:00 | MSFT | Stock | 477.21 | 478.65 | 474.46 | 478.365 | 529701.0 |
| 2025-06-18 10:30:00 | MSFT | Stock | 478.38 | 479.489 | 477.31 | 479.44 | 488491.0 |
| 2025-06-18 11:00:00 | MSFT | Stock | 479.415 | 479.495 | 478.74 | 478.945 | 319821.0 |
| 2025-06-18 11:30:00 | MSFT | Stock | 478.95 | 479.6599 | 478.8009 | 479.1079 | 383442.0 |
| 2025-06-18 12:00:00 | MSFT | Stock | 479.05 | 479.69 | 478.78 | 478.99 | 183558.0 |
| 2025-06-18 12:30:00 | MSFT | Stock | 478.97 | 479.8 | 478.88 | 479.14 | 209922.0 |
> showing 50 of 103,614 rows — these rows as CSV