PREVIEW / stock_30min / 2025-04-29
file: by_date/stock_30min/2025/2025-04-29.parquet size: 2.1 MB rows: 101,607 symbols: 428
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-04-29 04:00:00 | AAPL | Stock | 210.65 | 211.1 | 210.32 | 210.91 | 11090.0 |
| 2025-04-29 04:30:00 | AAPL | Stock | 210.91 | 211.05 | 210.9 | 211.0 | 2673.0 |
| 2025-04-29 05:00:00 | AAPL | Stock | 211.04 | 211.04 | 210.75 | 210.84 | 3938.0 |
| 2025-04-29 05:30:00 | AAPL | Stock | 210.86 | 210.87 | 210.81 | 210.87 | 1032.0 |
| 2025-04-29 06:00:00 | AAPL | Stock | 210.92 | 210.93 | 210.69 | 210.75 | 6374.0 |
| 2025-04-29 06:30:00 | AAPL | Stock | 210.75 | 210.75 | 209.78 | 209.97 | 21321.0 |
| 2025-04-29 07:00:00 | AAPL | Stock | 210.37 | 210.6 | 210.29 | 210.57 | 6254.0 |
| 2025-04-29 07:30:00 | AAPL | Stock | 210.5 | 210.5 | 210.23 | 210.31 | 4012.0 |
| 2025-04-29 08:00:00 | AAPL | Stock | 210.4 | 211.16 | 209.59 | 210.06 | 59660.0 |
| 2025-04-29 08:30:00 | AAPL | Stock | 210.0 | 210.55 | 209.57 | 209.57 | 44525.0 |
| 2025-04-29 09:00:00 | AAPL | Stock | 209.5 | 209.9415 | 208.6 | 208.85 | 92267.0 |
| 2025-04-29 09:30:00 | AAPL | Stock | 208.8 | 211.25 | 208.37 | 210.8 | 2538444.0 |
| 2025-04-29 10:00:00 | AAPL | Stock | 210.81 | 212.24 | 210.33 | 210.95 | 2273283.0 |
| 2025-04-29 10:30:00 | AAPL | Stock | 210.96 | 212.07 | 210.84 | 211.6111 | 1218858.0 |
| 2025-04-29 11:00:00 | AAPL | Stock | 211.62 | 211.8 | 210.67 | 211.04 | 1102091.0 |
| 2025-04-29 11:30:00 | AAPL | Stock | 211.04 | 211.21 | 210.4 | 210.615 | 823882.0 |
| 2025-04-29 12:00:00 | AAPL | Stock | 210.615 | 211.3253 | 210.42 | 210.488 | 805233.0 |
| 2025-04-29 12:30:00 | AAPL | Stock | 210.47 | 210.62 | 209.35 | 209.7326 | 1096554.0 |
| 2025-04-29 13:00:00 | AAPL | Stock | 209.74 | 210.69 | 209.5 | 210.38 | 829449.0 |
| 2025-04-29 13:30:00 | AAPL | Stock | 210.37 | 211.75 | 210.22 | 211.58 | 889645.0 |
| 2025-04-29 14:00:00 | AAPL | Stock | 211.585 | 211.85 | 211.16 | 211.7227 | 931282.0 |
| 2025-04-29 14:30:00 | AAPL | Stock | 211.72 | 211.9606 | 211.1879 | 211.3 | 674891.0 |
| 2025-04-29 15:00:00 | AAPL | Stock | 211.3 | 211.9 | 211.1001 | 211.3 | 1066788.0 |
| 2025-04-29 15:30:00 | AAPL | Stock | 211.31 | 211.77 | 210.95 | 211.24 | 2409925.0 |
| 2025-04-29 16:00:00 | AAPL | Stock | 211.2 | 211.21 | 210.79 | 210.9 | 6634237.0 |
| 2025-04-29 16:30:00 | AAPL | Stock | 210.86 | 211.21 | 210.65 | 211.21 | 34086.0 |
| 2025-04-29 17:00:00 | AAPL | Stock | 210.89 | 210.98 | 210.55 | 210.55 | 19358.0 |
| 2025-04-29 17:30:00 | AAPL | Stock | 210.511 | 210.93 | 210.511 | 210.93 | 10750.0 |
| 2025-04-29 18:00:00 | AAPL | Stock | 210.9 | 211.0 | 210.64 | 210.64 | 7577.0 |
| 2025-04-29 18:30:00 | AAPL | Stock | 210.93 | 210.93 | 210.6562 | 210.7 | 3731.0 |
| 2025-04-29 19:00:00 | AAPL | Stock | 210.7 | 210.7 | 210.33 | 210.5 | 11473.0 |
| 2025-04-29 19:30:00 | AAPL | Stock | 210.5 | 210.7996 | 210.46 | 210.556 | 9535.0 |
| 2025-04-29 04:00:00 | MSFT | Stock | 392.48 | 392.91 | 392.0 | 392.73 | 5242.0 |
| 2025-04-29 04:30:00 | MSFT | Stock | 392.72 | 393.18 | 392.7 | 393.08 | 2755.0 |
| 2025-04-29 05:00:00 | MSFT | Stock | 393.08 | 393.1 | 392.47 | 392.47 | 884.0 |
| 2025-04-29 05:30:00 | MSFT | Stock | 392.77 | 392.78 | 392.77 | 392.78 | 200.0 |
| 2025-04-29 06:00:00 | MSFT | Stock | 392.81 | 392.81 | 392.61 | 392.65 | 754.0 |
| 2025-04-29 06:30:00 | MSFT | Stock | 392.69 | 392.69 | 391.0 | 391.0 | 2025.0 |
| 2025-04-29 07:00:00 | MSFT | Stock | 391.37 | 392.0 | 391.36 | 391.7 | 1976.0 |
| 2025-04-29 07:30:00 | MSFT | Stock | 391.72 | 391.8 | 391.6 | 391.6 | 1200.0 |
| 2025-04-29 08:00:00 | MSFT | Stock | 391.56 | 392.0 | 390.026 | 390.026 | 10529.0 |
| 2025-04-29 08:30:00 | MSFT | Stock | 391.18 | 391.9995 | 390.21 | 390.21 | 6635.0 |
| 2025-04-29 09:00:00 | MSFT | Stock | 390.2 | 391.36 | 389.3106 | 391.03 | 25840.0 |
| 2025-04-29 09:30:00 | MSFT | Stock | 391.04 | 394.08 | 390.38 | 393.5 | 1069448.0 |
| 2025-04-29 10:00:00 | MSFT | Stock | 393.54 | 394.9 | 392.65 | 393.57 | 650185.0 |
| 2025-04-29 10:30:00 | MSFT | Stock | 393.58 | 394.82 | 393.33 | 394.46 | 409633.0 |
| 2025-04-29 11:00:00 | MSFT | Stock | 394.4 | 394.6799 | 392.49 | 393.155 | 396259.0 |
| 2025-04-29 11:30:00 | MSFT | Stock | 393.165 | 393.66 | 392.12 | 392.59 | 261860.0 |
| 2025-04-29 12:00:00 | MSFT | Stock | 392.59 | 394.13 | 392.56 | 393.4 | 243660.0 |
| 2025-04-29 12:30:00 | MSFT | Stock | 393.4838 | 393.7274 | 391.6 | 392.0984 | 270972.0 |
> showing 50 of 101,607 rows — these rows as CSV