PREVIEW / stock_30min / 2025-06-13
file: by_date/stock_30min/2025/2025-06-13.parquet size: 2.2 MB rows: 107,583 symbols: 400
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-13 04:00:00 | AAPL | Stock | 196.11 | 197.37 | 196.0 | 197.09 | 20993.0 |
| 2025-06-13 04:30:00 | AAPL | Stock | 197.05 | 197.1 | 196.58 | 196.68 | 4755.0 |
| 2025-06-13 05:00:00 | AAPL | Stock | 196.64 | 197.37 | 196.64 | 197.37 | 7213.0 |
| 2025-06-13 05:30:00 | AAPL | Stock | 197.26 | 197.63 | 197.1 | 197.63 | 19149.0 |
| 2025-06-13 06:00:00 | AAPL | Stock | 197.47 | 197.85 | 197.24 | 197.83 | 13749.0 |
| 2025-06-13 06:30:00 | AAPL | Stock | 197.8 | 198.61 | 197.8 | 198.61 | 26096.0 |
| 2025-06-13 07:00:00 | AAPL | Stock | 198.61 | 199.12 | 198.41 | 198.79 | 71251.0 |
| 2025-06-13 07:30:00 | AAPL | Stock | 198.77 | 199.75 | 198.77 | 199.54 | 96015.0 |
| 2025-06-13 08:00:00 | AAPL | Stock | 199.0 | 200.2 | 195.87 | 200.0 | 315905.0 |
| 2025-06-13 08:30:00 | AAPL | Stock | 199.94 | 200.11 | 199.4 | 200.0001 | 117466.0 |
| 2025-06-13 09:00:00 | AAPL | Stock | 200.0 | 200.1865 | 199.4 | 199.75 | 250565.0 |
| 2025-06-13 09:30:00 | AAPL | Stock | 199.83 | 200.37 | 196.76 | 196.9 | 6709456.0 |
| 2025-06-13 10:00:00 | AAPL | Stock | 196.93 | 197.3999 | 195.91 | 196.155 | 3477050.0 |
| 2025-06-13 10:30:00 | AAPL | Stock | 196.16 | 197.1998 | 195.98 | 197.11 | 2665366.0 |
| 2025-06-13 11:00:00 | AAPL | Stock | 197.11 | 197.642 | 196.98 | 197.51 | 1852678.0 |
| 2025-06-13 11:30:00 | AAPL | Stock | 197.52 | 197.88 | 197.21 | 197.6888 | 1498470.0 |
| 2025-06-13 12:00:00 | AAPL | Stock | 197.68 | 198.0475 | 197.22 | 197.27 | 1612479.0 |
| 2025-06-13 12:30:00 | AAPL | Stock | 197.29 | 197.57 | 197.08 | 197.45 | 1401879.0 |
| 2025-06-13 13:00:00 | AAPL | Stock | 197.43 | 197.53 | 196.91 | 197.26 | 1198141.0 |
| 2025-06-13 13:30:00 | AAPL | Stock | 197.25 | 197.71 | 197.2 | 197.54 | 982881.0 |
| 2025-06-13 14:00:00 | AAPL | Stock | 197.54 | 197.69 | 196.22 | 196.278 | 2054120.0 |
| 2025-06-13 14:30:00 | AAPL | Stock | 196.26 | 196.485 | 195.81 | 196.465 | 2140972.0 |
| 2025-06-13 15:00:00 | AAPL | Stock | 196.455 | 196.64 | 196.08 | 196.22 | 1677739.0 |
| 2025-06-13 15:30:00 | AAPL | Stock | 196.24 | 196.69 | 195.7 | 196.45 | 4309496.0 |
| 2025-06-13 16:00:00 | AAPL | Stock | 196.46 | 196.55 | 196.11 | 196.28 | 5506597.0 |
| 2025-06-13 16:30:00 | AAPL | Stock | 196.33 | 196.53 | 196.28 | 196.45 | 34575.0 |
| 2025-06-13 17:00:00 | AAPL | Stock | 196.4484 | 196.48 | 196.39 | 196.4494 | 13222.0 |
| 2025-06-13 17:30:00 | AAPL | Stock | 196.42 | 196.5 | 196.31 | 196.45 | 18706.0 |
| 2025-06-13 18:00:00 | AAPL | Stock | 196.45 | 196.6 | 196.4 | 196.5 | 20397.0 |
| 2025-06-13 18:30:00 | AAPL | Stock | 196.45 | 196.5 | 196.3901 | 196.46 | 13064.0 |
| 2025-06-13 19:00:00 | AAPL | Stock | 196.4599 | 196.48 | 196.4 | 196.4 | 9747.0 |
| 2025-06-13 19:30:00 | AAPL | Stock | 196.4 | 196.46 | 196.3 | 196.3998 | 14950.0 |
| 2025-06-13 04:00:00 | MSFT | Stock | 473.01 | 474.32 | 472.88 | 473.5 | 7867.0 |
| 2025-06-13 04:30:00 | MSFT | Stock | 473.48 | 473.73 | 473.0 | 473.5 | 2075.0 |
| 2025-06-13 05:00:00 | MSFT | Stock | 473.45 | 473.94 | 472.98 | 473.2 | 3030.0 |
| 2025-06-13 05:30:00 | MSFT | Stock | 473.1 | 473.22 | 472.71 | 473.12 | 5607.0 |
| 2025-06-13 06:00:00 | MSFT | Stock | 473.12 | 473.79 | 472.82 | 473.72 | 3887.0 |
| 2025-06-13 06:30:00 | MSFT | Stock | 473.39 | 474.02 | 473.29 | 474.02 | 2144.0 |
| 2025-06-13 07:00:00 | MSFT | Stock | 474.02 | 475.35 | 473.98 | 474.4 | 9036.0 |
| 2025-06-13 07:30:00 | MSFT | Stock | 474.88 | 475.5 | 474.88 | 475.04 | 10968.0 |
| 2025-06-13 08:00:00 | MSFT | Stock | 474.49 | 475.47 | 471.79 | 475.2 | 52488.0 |
| 2025-06-13 08:30:00 | MSFT | Stock | 475.24 | 475.4 | 474.3 | 474.53 | 16260.0 |
| 2025-06-13 09:00:00 | MSFT | Stock | 474.54 | 477.2 | 473.6177 | 476.68 | 31025.0 |
| 2025-06-13 09:30:00 | MSFT | Stock | 476.63 | 478.82 | 475.37 | 478.42 | 1342004.0 |
| 2025-06-13 10:00:00 | MSFT | Stock | 478.5 | 479.18 | 475.13 | 475.22 | 921918.0 |
| 2025-06-13 10:30:00 | MSFT | Stock | 475.29 | 477.22 | 474.95 | 476.4315 | 607953.0 |
| 2025-06-13 11:00:00 | MSFT | Stock | 476.4 | 476.74 | 475.65 | 476.395 | 451622.0 |
| 2025-06-13 11:30:00 | MSFT | Stock | 476.38 | 477.455 | 475.72 | 477.28 | 338694.0 |
| 2025-06-13 12:00:00 | MSFT | Stock | 477.3 | 478.08 | 476.965 | 477.16 | 395328.0 |
| 2025-06-13 12:30:00 | MSFT | Stock | 477.17 | 477.35 | 475.9 | 476.66 | 336086.0 |
> showing 50 of 107,583 rows — these rows as CSV