PREVIEW / stock_30min / 2025-09-19
file: by_date/stock_30min/2025/2025-09-19.parquet size: 2.3 MB rows: 110,309 symbols: 313
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-09-19 04:00:00 | AAPL | Stock | 238.25 | 238.64 | 238.0 | 238.45 | 18667.0 |
| 2025-09-19 04:30:00 | AAPL | Stock | 238.45 | 238.55 | 238.42 | 238.42 | 2638.0 |
| 2025-09-19 05:00:00 | AAPL | Stock | 238.43 | 240.42 | 238.4 | 239.76 | 89742.0 |
| 2025-09-19 05:30:00 | AAPL | Stock | 239.72 | 239.83 | 239.57 | 239.62 | 7193.0 |
| 2025-09-19 06:00:00 | AAPL | Stock | 239.62 | 239.78 | 239.13 | 239.64 | 16278.0 |
| 2025-09-19 06:30:00 | AAPL | Stock | 239.7 | 239.74 | 239.33 | 239.36 | 4457.0 |
| 2025-09-19 07:00:00 | AAPL | Stock | 239.49 | 239.72 | 239.34 | 239.52 | 26551.0 |
| 2025-09-19 07:30:00 | AAPL | Stock | 239.575 | 240.8 | 239.52 | 240.65 | 95993.0 |
| 2025-09-19 08:00:00 | AAPL | Stock | 239.43 | 241.07 | 237.92 | 240.93 | 400376.0 |
| 2025-09-19 08:30:00 | AAPL | Stock | 240.95 | 240.95 | 240.0 | 240.22 | 97607.0 |
| 2025-09-19 09:00:00 | AAPL | Stock | 240.25 | 241.71 | 239.8 | 241.21 | 546712.0 |
| 2025-09-19 09:30:00 | AAPL | Stock | 241.2 | 242.7 | 240.35 | 240.885 | 17626161.0 |
| 2025-09-19 10:00:00 | AAPL | Stock | 240.885 | 241.51 | 240.2106 | 241.15 | 3777969.0 |
| 2025-09-19 10:30:00 | AAPL | Stock | 241.15 | 243.16 | 241.06 | 242.84 | 5005330.0 |
| 2025-09-19 11:00:00 | AAPL | Stock | 242.85 | 243.0 | 241.8 | 242.28 | 3122125.0 |
| 2025-09-19 11:30:00 | AAPL | Stock | 242.2737 | 243.39 | 242.0492 | 243.29 | 2583663.0 |
| 2025-09-19 12:00:00 | AAPL | Stock | 243.27 | 244.57 | 243.17 | 244.52 | 3831245.0 |
| 2025-09-19 12:30:00 | AAPL | Stock | 244.5125 | 245.92 | 244.265 | 245.155 | 5448118.0 |
| 2025-09-19 13:00:00 | AAPL | Stock | 245.16 | 245.5 | 244.9 | 245.25 | 2576858.0 |
| 2025-09-19 13:30:00 | AAPL | Stock | 245.24 | 245.95 | 244.9 | 245.4 | 2546425.0 |
| 2025-09-19 14:00:00 | AAPL | Stock | 245.405 | 246.2699 | 244.95 | 245.49 | 3653070.0 |
| 2025-09-19 14:30:00 | AAPL | Stock | 245.485 | 246.1 | 245.19 | 245.51 | 2503053.0 |
| 2025-09-19 15:00:00 | AAPL | Stock | 245.5 | 245.89 | 245.44 | 245.61 | 2928571.0 |
| 2025-09-19 15:30:00 | AAPL | Stock | 245.6 | 246.3 | 244.74 | 245.28 | 10484103.0 |
| 2025-09-19 16:00:00 | AAPL | Stock | 245.5 | 245.61 | 245.0 | 245.48 | 54460908.0 |
| 2025-09-19 16:30:00 | AAPL | Stock | 245.49 | 245.8 | 245.47 | 245.49 | 114720.0 |
| 2025-09-19 17:00:00 | AAPL | Stock | 245.4894 | 245.69 | 245.47 | 245.5825 | 77074.0 |
| 2025-09-19 17:30:00 | AAPL | Stock | 245.58 | 245.61 | 245.47 | 245.49 | 14237.0 |
| 2025-09-19 18:00:00 | AAPL | Stock | 245.5 | 245.6999 | 245.5 | 245.62 | 29584.0 |
| 2025-09-19 18:30:00 | AAPL | Stock | 245.6499 | 245.7 | 245.63 | 245.65 | 9235.0 |
| 2025-09-19 19:00:00 | AAPL | Stock | 245.66 | 245.75 | 245.66 | 245.75 | 17084.0 |
| 2025-09-19 19:30:00 | AAPL | Stock | 245.74 | 245.74 | 245.64 | 245.69 | 25987.0 |
| 2025-09-19 04:00:00 | MSFT | Stock | 508.96 | 509.0 | 508.96 | 509.0 | 261.0 |
| 2025-09-19 04:30:00 | MSFT | Stock | 509.16 | 509.46 | 509.16 | 509.38 | 848.0 |
| 2025-09-19 05:00:00 | MSFT | Stock | 509.35 | 509.58 | 509.35 | 509.58 | 200.0 |
| 2025-09-19 05:30:00 | MSFT | Stock | 509.35 | 509.8 | 509.35 | 509.8 | 1270.0 |
| 2025-09-19 06:00:00 | MSFT | Stock | 509.4 | 509.4 | 509.0 | 509.0 | 1485.0 |
| 2025-09-19 06:30:00 | MSFT | Stock | 509.0 | 509.0 | 508.5 | 508.5 | 1144.0 |
| 2025-09-19 07:00:00 | MSFT | Stock | 508.69 | 509.27 | 508.69 | 509.27 | 621.0 |
| 2025-09-19 07:30:00 | MSFT | Stock | 509.3 | 509.7 | 509.3 | 509.65 | 2656.0 |
| 2025-09-19 08:00:00 | MSFT | Stock | 509.2 | 509.8981 | 508.45 | 509.84 | 15887.0 |
| 2025-09-19 08:30:00 | MSFT | Stock | 509.8 | 509.8 | 509.24 | 509.24 | 7416.0 |
| 2025-09-19 09:00:00 | MSFT | Stock | 509.26 | 511.97 | 509.2131 | 510.53 | 177038.0 |
| 2025-09-19 09:30:00 | MSFT | Stock | 510.61 | 514.88 | 510.31 | 514.325 | 6355650.0 |
| 2025-09-19 10:00:00 | MSFT | Stock | 514.38 | 514.625 | 511.95 | 513.11 | 724752.0 |
| 2025-09-19 10:30:00 | MSFT | Stock | 513.09 | 513.8 | 512.4601 | 513.69 | 531351.0 |
| 2025-09-19 11:00:00 | MSFT | Stock | 513.73 | 513.955 | 511.875 | 512.22 | 857175.0 |
| 2025-09-19 11:30:00 | MSFT | Stock | 512.225 | 512.27 | 511.32 | 511.88 | 322974.0 |
| 2025-09-19 12:00:00 | MSFT | Stock | 511.92 | 513.36 | 511.92 | 512.86 | 396357.0 |
| 2025-09-19 12:30:00 | MSFT | Stock | 512.8522 | 512.96 | 511.89 | 512.335 | 378303.0 |
> showing 50 of 110,309 rows — these rows as CSV