PREVIEW / stock_30min / 2025-10-27
file: by_date/stock_30min/2025/2025-10-27.parquet size: 2.3 MB rows: 113,459 symbols: 223
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-10-27 04:00:00 | AAPL | Stock | 264.27 | 265.66 | 264.27 | 264.5 | 22911.0 |
| 2025-10-27 04:30:00 | AAPL | Stock | 264.51 | 264.79 | 264.26 | 264.44 | 6185.0 |
| 2025-10-27 05:00:00 | AAPL | Stock | 264.55 | 264.59 | 264.32 | 264.59 | 5779.0 |
| 2025-10-27 05:30:00 | AAPL | Stock | 264.66 | 265.34 | 264.66 | 264.75 | 8739.0 |
| 2025-10-27 06:00:00 | AAPL | Stock | 264.65 | 265.14 | 264.6 | 264.95 | 9971.0 |
| 2025-10-27 06:30:00 | AAPL | Stock | 264.8 | 264.94 | 264.63 | 264.83 | 7042.0 |
| 2025-10-27 07:00:00 | AAPL | Stock | 264.71 | 265.26 | 264.58 | 264.98 | 31147.0 |
| 2025-10-27 07:30:00 | AAPL | Stock | 264.9 | 264.94 | 264.5 | 264.9 | 22351.0 |
| 2025-10-27 08:00:00 | AAPL | Stock | 265.0 | 265.88 | 264.35 | 265.4 | 173602.0 |
| 2025-10-27 08:30:00 | AAPL | Stock | 265.32 | 265.45 | 264.8 | 265.19 | 33920.0 |
| 2025-10-27 09:00:00 | AAPL | Stock | 265.12 | 265.35 | 264.07 | 264.99 | 96756.0 |
| 2025-10-27 09:30:00 | AAPL | Stock | 264.88 | 266.66 | 264.6501 | 266.25 | 4527712.0 |
| 2025-10-27 10:00:00 | AAPL | Stock | 266.24 | 267.05 | 265.66 | 265.73 | 2161601.0 |
| 2025-10-27 10:30:00 | AAPL | Stock | 265.74 | 266.42 | 265.2 | 265.4 | 1681069.0 |
| 2025-10-27 11:00:00 | AAPL | Stock | 265.4 | 266.11 | 265.19 | 265.71 | 1357436.0 |
| 2025-10-27 11:30:00 | AAPL | Stock | 265.71 | 265.78 | 265.05 | 265.4102 | 1328233.0 |
| 2025-10-27 12:00:00 | AAPL | Stock | 265.42 | 266.09 | 265.24 | 265.93 | 1323645.0 |
| 2025-10-27 12:30:00 | AAPL | Stock | 265.94 | 266.125 | 265.56 | 265.59 | 896421.0 |
| 2025-10-27 13:00:00 | AAPL | Stock | 265.59 | 265.8855 | 265.51 | 265.62 | 707886.0 |
| 2025-10-27 13:30:00 | AAPL | Stock | 265.63 | 266.02 | 265.5 | 265.8601 | 901382.0 |
| 2025-10-27 14:00:00 | AAPL | Stock | 265.86 | 265.86 | 265.5215 | 265.595 | 677581.0 |
| 2025-10-27 14:30:00 | AAPL | Stock | 265.59 | 266.33 | 265.47 | 266.235 | 1169054.0 |
| 2025-10-27 15:00:00 | AAPL | Stock | 266.235 | 267.4 | 266.03 | 267.275 | 2066762.0 |
| 2025-10-27 15:30:00 | AAPL | Stock | 267.27 | 269.12 | 267.21 | 268.74 | 5562109.0 |
| 2025-10-27 16:00:00 | AAPL | Stock | 268.75 | 268.9752 | 266.7636 | 268.62 | 7967600.0 |
| 2025-10-27 16:30:00 | AAPL | Stock | 268.62 | 268.81 | 268.6 | 268.72 | 34214.0 |
| 2025-10-27 17:00:00 | AAPL | Stock | 268.7 | 268.75 | 268.57 | 268.68 | 27789.0 |
| 2025-10-27 17:30:00 | AAPL | Stock | 268.69 | 268.82 | 268.56 | 268.79 | 20382.0 |
| 2025-10-27 18:00:00 | AAPL | Stock | 268.75 | 268.9 | 268.69 | 268.85 | 71208.0 |
| 2025-10-27 18:30:00 | AAPL | Stock | 268.9 | 269.15 | 268.8504 | 269.06 | 22739.0 |
| 2025-10-27 19:00:00 | AAPL | Stock | 269.01 | 269.12 | 268.85 | 269.04 | 21806.0 |
| 2025-10-27 19:30:00 | AAPL | Stock | 269.1 | 269.3027 | 268.99 | 269.07 | 50629.0 |
| 2025-10-27 04:00:00 | MSFT | Stock | 529.77 | 530.01 | 528.0 | 528.69 | 7022.0 |
| 2025-10-27 04:30:00 | MSFT | Stock | 528.76 | 529.25 | 528.76 | 529.25 | 2100.0 |
| 2025-10-27 05:00:00 | MSFT | Stock | 529.25 | 529.25 | 528.5 | 528.93 | 1377.0 |
| 2025-10-27 05:30:00 | MSFT | Stock | 529.0 | 530.58 | 529.0 | 530.12 | 7774.0 |
| 2025-10-27 06:00:00 | MSFT | Stock | 529.99 | 529.99 | 529.12 | 529.7 | 6808.0 |
| 2025-10-27 06:30:00 | MSFT | Stock | 529.55 | 530.13 | 529.3 | 529.89 | 5239.0 |
| 2025-10-27 07:00:00 | MSFT | Stock | 529.7 | 530.7 | 528.2 | 530.4 | 20210.0 |
| 2025-10-27 07:30:00 | MSFT | Stock | 530.29 | 530.75 | 530.1 | 530.12 | 9495.0 |
| 2025-10-27 08:00:00 | MSFT | Stock | 529.69 | 531.73 | 527.36 | 531.0 | 77467.0 |
| 2025-10-27 08:30:00 | MSFT | Stock | 531.0 | 531.1 | 530.76 | 531.05 | 20749.0 |
| 2025-10-27 09:00:00 | MSFT | Stock | 531.07 | 532.4 | 530.89 | 531.96 | 82854.0 |
| 2025-10-27 09:30:00 | MSFT | Stock | 531.78 | 532.286 | 529.01 | 531.565 | 1717255.0 |
| 2025-10-27 10:00:00 | MSFT | Stock | 531.55 | 533.8 | 531.52 | 533.27 | 1010850.0 |
| 2025-10-27 10:30:00 | MSFT | Stock | 533.26 | 534.58 | 532.71 | 532.72 | 775086.0 |
| 2025-10-27 11:00:00 | MSFT | Stock | 532.745 | 533.44 | 532.24 | 532.6651 | 474687.0 |
| 2025-10-27 11:30:00 | MSFT | Stock | 532.6475 | 533.38 | 531.92 | 532.53 | 429761.0 |
| 2025-10-27 12:00:00 | MSFT | Stock | 532.5 | 532.78 | 531.6 | 531.72 | 286080.0 |
| 2025-10-27 12:30:00 | MSFT | Stock | 531.745 | 531.83 | 530.9101 | 531.37 | 321737.0 |
> showing 50 of 113,459 rows — these rows as CSV