PREVIEW / stock_30min / 2025-05-15
file: by_date/stock_30min/2025/2025-05-15.parquet size: 2.2 MB rows: 103,806 symbols: 414
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-05-15 04:00:00 | AAPL | Stock | 211.48 | 211.48 | 210.69 | 210.98 | 10344.0 |
| 2025-05-15 04:30:00 | AAPL | Stock | 210.85 | 210.85 | 209.75 | 209.99 | 19553.0 |
| 2025-05-15 05:00:00 | AAPL | Stock | 210.0 | 210.12 | 209.5 | 210.0 | 10171.0 |
| 2025-05-15 05:30:00 | AAPL | Stock | 210.15 | 210.32 | 210.01 | 210.3 | 7055.0 |
| 2025-05-15 06:00:00 | AAPL | Stock | 210.06 | 210.06 | 209.68 | 209.68 | 12538.0 |
| 2025-05-15 06:30:00 | AAPL | Stock | 209.6 | 209.66 | 209.29 | 209.5 | 26731.0 |
| 2025-05-15 07:00:00 | AAPL | Stock | 209.58 | 210.35 | 209.51 | 210.265 | 22649.0 |
| 2025-05-15 07:30:00 | AAPL | Stock | 210.3 | 210.39 | 210.03 | 210.03 | 13829.0 |
| 2025-05-15 08:00:00 | AAPL | Stock | 209.75 | 212.15 | 209.55 | 209.6622 | 75321.0 |
| 2025-05-15 08:30:00 | AAPL | Stock | 209.79 | 210.5 | 209.66 | 209.86 | 65079.0 |
| 2025-05-15 09:00:00 | AAPL | Stock | 209.8987 | 211.14 | 209.8987 | 210.88 | 143579.0 |
| 2025-05-15 09:30:00 | AAPL | Stock | 210.95 | 212.53 | 210.08 | 210.42 | 4212144.0 |
| 2025-05-15 10:00:00 | AAPL | Stock | 210.45 | 210.71 | 209.54 | 210.275 | 2125711.0 |
| 2025-05-15 10:30:00 | AAPL | Stock | 210.32 | 211.94 | 210.19 | 211.92 | 2052876.0 |
| 2025-05-15 11:00:00 | AAPL | Stock | 211.93 | 212.8 | 211.27 | 212.5 | 1844278.0 |
| 2025-05-15 11:30:00 | AAPL | Stock | 212.5 | 212.96 | 211.88 | 211.96 | 1949458.0 |
| 2025-05-15 12:00:00 | AAPL | Stock | 211.9613 | 212.25 | 211.4101 | 211.64 | 1367852.0 |
| 2025-05-15 12:30:00 | AAPL | Stock | 211.63 | 212.1 | 211.21 | 212.04 | 1078881.0 |
| 2025-05-15 13:00:00 | AAPL | Stock | 212.025 | 212.28 | 211.73 | 212.1201 | 1075183.0 |
| 2025-05-15 13:30:00 | AAPL | Stock | 212.13 | 212.13 | 211.04 | 211.1801 | 1117904.0 |
| 2025-05-15 14:00:00 | AAPL | Stock | 211.18 | 211.3299 | 210.25 | 210.63 | 1631984.0 |
| 2025-05-15 14:30:00 | AAPL | Stock | 210.63 | 211.21 | 210.49 | 210.65 | 1237515.0 |
| 2025-05-15 15:00:00 | AAPL | Stock | 210.66 | 211.09 | 210.31 | 210.36 | 1480812.0 |
| 2025-05-15 15:30:00 | AAPL | Stock | 210.35 | 211.47 | 210.15 | 211.45 | 4558990.0 |
| 2025-05-15 16:00:00 | AAPL | Stock | 211.45 | 211.45 | 210.92 | 211.17 | 6648979.0 |
| 2025-05-15 16:30:00 | AAPL | Stock | 211.16 | 211.45 | 211.05 | 211.101 | 17214.0 |
| 2025-05-15 17:00:00 | AAPL | Stock | 211.11 | 211.15 | 211.0298 | 211.15 | 9629.0 |
| 2025-05-15 17:30:00 | AAPL | Stock | 211.23 | 211.23 | 211.0292 | 211.13 | 7078.0 |
| 2025-05-15 18:00:00 | AAPL | Stock | 211.1378 | 211.1378 | 210.92 | 210.95 | 12530.0 |
| 2025-05-15 18:30:00 | AAPL | Stock | 211.09 | 211.1 | 210.91 | 210.91 | 3677.0 |
| 2025-05-15 19:00:00 | AAPL | Stock | 210.91 | 210.9595 | 210.8025 | 210.9 | 5816.0 |
| 2025-05-15 19:30:00 | AAPL | Stock | 210.88 | 211.25 | 210.83 | 211.01 | 26708.0 |
| 2025-05-15 04:00:00 | MSFT | Stock | 450.61 | 450.61 | 448.7 | 449.67 | 3155.0 |
| 2025-05-15 04:30:00 | MSFT | Stock | 449.74 | 449.81 | 449.3 | 449.67 | 1953.0 |
| 2025-05-15 05:00:00 | MSFT | Stock | 449.79 | 450.09 | 449.11 | 449.9 | 8015.0 |
| 2025-05-15 05:30:00 | MSFT | Stock | 450.16 | 450.56 | 450.11 | 450.56 | 2061.0 |
| 2025-05-15 06:00:00 | MSFT | Stock | 450.3 | 450.75 | 450.17 | 450.75 | 964.0 |
| 2025-05-15 06:30:00 | MSFT | Stock | 450.66 | 451.17 | 450.66 | 450.67 | 1933.0 |
| 2025-05-15 07:00:00 | MSFT | Stock | 450.75 | 451.0 | 450.0 | 450.44 | 3502.0 |
| 2025-05-15 07:30:00 | MSFT | Stock | 450.94 | 451.0 | 450.56 | 450.79 | 4488.0 |
| 2025-05-15 08:00:00 | MSFT | Stock | 450.0 | 452.5 | 449.75 | 450.64 | 13232.0 |
| 2025-05-15 08:30:00 | MSFT | Stock | 450.9 | 451.85 | 450.9 | 451.55 | 11709.0 |
| 2025-05-15 09:00:00 | MSFT | Stock | 451.0628 | 451.83 | 450.64 | 451.09 | 8901.0 |
| 2025-05-15 09:30:00 | MSFT | Stock | 450.98 | 453.47 | 450.4301 | 453.0 | 1217021.0 |
| 2025-05-15 10:00:00 | MSFT | Stock | 453.14 | 454.25 | 452.395 | 453.6405 | 713116.0 |
| 2025-05-15 10:30:00 | MSFT | Stock | 453.69 | 453.78 | 452.29 | 453.14 | 582588.0 |
| 2025-05-15 11:00:00 | MSFT | Stock | 453.115 | 455.51 | 453.0076 | 454.9263 | 880459.0 |
| 2025-05-15 11:30:00 | MSFT | Stock | 454.93 | 455.51 | 454.2201 | 455.35 | 600437.0 |
| 2025-05-15 12:00:00 | MSFT | Stock | 455.35 | 456.0 | 454.9 | 455.258 | 587780.0 |
| 2025-05-15 12:30:00 | MSFT | Stock | 455.25 | 455.6996 | 454.7712 | 455.58 | 296276.0 |
> showing 50 of 103,806 rows — these rows as CSV