PREVIEW / stock_30min / 2025-10-23
file: by_date/stock_30min/2025/2025-10-23.parquet size: 2.2 MB rows: 107,734 symbols: 224
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-23 04:00:00 | AAPL | Stock | 259.61 | 259.67 | 259.38 | 259.55 | 6213.0 |
| 2025-10-23 04:30:00 | AAPL | Stock | 259.37 | 259.43 | 259.07 | 259.11 | 3335.0 |
| 2025-10-23 05:00:00 | AAPL | Stock | 259.11 | 259.11 | 258.8 | 259.06 | 2207.0 |
| 2025-10-23 05:30:00 | AAPL | Stock | 259.12 | 259.12 | 258.92 | 258.98 | 619.0 |
| 2025-10-23 06:00:00 | AAPL | Stock | 259.26 | 259.26 | 259.1 | 259.21 | 1312.0 |
| 2025-10-23 06:30:00 | AAPL | Stock | 259.18 | 259.65 | 259.18 | 259.29 | 8084.0 |
| 2025-10-23 07:00:00 | AAPL | Stock | 259.23 | 259.23 | 258.0 | 258.6 | 15679.0 |
| 2025-10-23 07:30:00 | AAPL | Stock | 258.47 | 258.5 | 257.64 | 257.86 | 8619.0 |
| 2025-10-23 08:00:00 | AAPL | Stock | 258.88 | 259.79 | 257.68 | 257.8 | 53569.0 |
| 2025-10-23 08:30:00 | AAPL | Stock | 258.0 | 259.45 | 257.5527 | 258.8 | 42585.0 |
| 2025-10-23 09:00:00 | AAPL | Stock | 258.79 | 260.1 | 258.24 | 259.99 | 73507.0 |
| 2025-10-23 09:30:00 | AAPL | Stock | 259.89 | 260.1799 | 258.0101 | 258.35 | 2870080.0 |
| 2025-10-23 10:00:00 | AAPL | Stock | 258.36 | 259.63 | 258.12 | 259.4799 | 1580914.0 |
| 2025-10-23 10:30:00 | AAPL | Stock | 259.45 | 259.66 | 258.73 | 259.6222 | 1132247.0 |
| 2025-10-23 11:00:00 | AAPL | Stock | 259.61 | 259.68 | 258.95 | 259.4 | 971220.0 |
| 2025-10-23 11:30:00 | AAPL | Stock | 259.4 | 260.55 | 259.0834 | 260.25 | 1584526.0 |
| 2025-10-23 12:00:00 | AAPL | Stock | 260.22 | 260.62 | 259.92 | 260.03 | 805645.0 |
| 2025-10-23 12:30:00 | AAPL | Stock | 260.05 | 260.39 | 259.95 | 260.25 | 846222.0 |
| 2025-10-23 13:00:00 | AAPL | Stock | 260.27 | 260.55 | 259.52 | 259.86 | 1139174.0 |
| 2025-10-23 13:30:00 | AAPL | Stock | 259.88 | 260.425 | 259.83 | 260.19 | 719082.0 |
| 2025-10-23 14:00:00 | AAPL | Stock | 260.22 | 260.42 | 259.843 | 259.97 | 720849.0 |
| 2025-10-23 14:30:00 | AAPL | Stock | 259.97 | 260.02 | 259.65 | 259.85 | 763528.0 |
| 2025-10-23 15:00:00 | AAPL | Stock | 259.86 | 259.92 | 259.62 | 259.91 | 872877.0 |
| 2025-10-23 15:30:00 | AAPL | Stock | 259.91 | 260.05 | 259.08 | 259.58 | 2295721.0 |
| 2025-10-23 16:00:00 | AAPL | Stock | 259.58 | 260.17 | 259.51 | 260.1 | 6182650.0 |
| 2025-10-23 16:30:00 | AAPL | Stock | 260.03 | 260.03 | 259.0431 | 259.3 | 20532.0 |
| 2025-10-23 17:00:00 | AAPL | Stock | 259.3 | 259.6819 | 259.1575 | 259.35 | 15029.0 |
| 2025-10-23 17:30:00 | AAPL | Stock | 259.45 | 259.7 | 259.3508 | 259.5 | 3805.0 |
| 2025-10-23 18:00:00 | AAPL | Stock | 259.7 | 259.7 | 259.42 | 259.6409 | 1276.0 |
| 2025-10-23 18:30:00 | AAPL | Stock | 259.69 | 259.89 | 259.6 | 259.65 | 2064.0 |
| 2025-10-23 19:00:00 | AAPL | Stock | 259.8 | 259.8 | 259.62 | 259.6201 | 6160.0 |
| 2025-10-23 19:30:00 | AAPL | Stock | 259.6 | 259.61 | 259.15 | 259.53 | 18040.0 |
| 2025-10-23 04:00:00 | MSFT | Stock | 522.33 | 522.33 | 521.91 | 521.91 | 649.0 |
| 2025-10-23 04:30:00 | MSFT | Stock | 521.99 | 521.99 | 521.9 | 521.9 | 200.0 |
| 2025-10-23 05:00:00 | MSFT | Stock | 522.04 | 522.04 | 521.47 | 521.93 | 1157.0 |
| 2025-10-23 06:00:00 | MSFT | Stock | 522.27 | 522.27 | 522.27 | 522.27 | 105.0 |
| 2025-10-23 06:30:00 | MSFT | Stock | 522.02 | 522.03 | 521.79 | 522.03 | 352.0 |
| 2025-10-23 07:00:00 | MSFT | Stock | 521.88 | 521.88 | 521.17 | 521.64 | 1836.0 |
| 2025-10-23 07:30:00 | MSFT | Stock | 521.45 | 521.45 | 521.0 | 521.0 | 1069.0 |
| 2025-10-23 08:00:00 | MSFT | Stock | 521.5 | 522.26 | 520.63 | 521.1 | 9681.0 |
| 2025-10-23 08:30:00 | MSFT | Stock | 521.4905 | 521.8 | 520.64 | 521.8 | 4944.0 |
| 2025-10-23 09:00:00 | MSFT | Stock | 522.0 | 523.03 | 521.5298 | 522.67 | 8827.0 |
| 2025-10-23 09:30:00 | MSFT | Stock | 522.4 | 523.2 | 518.61 | 521.9 | 1114917.0 |
| 2025-10-23 10:00:00 | MSFT | Stock | 521.68 | 522.44 | 520.7 | 521.4051 | 553200.0 |
| 2025-10-23 10:30:00 | MSFT | Stock | 521.35 | 523.235 | 521.2 | 522.6335 | 448365.0 |
| 2025-10-23 11:00:00 | MSFT | Stock | 522.705 | 523.23 | 521.58 | 523.1582 | 338195.0 |
| 2025-10-23 11:30:00 | MSFT | Stock | 523.17 | 523.63 | 521.45 | 522.4672 | 373970.0 |
| 2025-10-23 12:00:00 | MSFT | Stock | 522.51 | 523.95 | 522.075 | 522.49 | 266501.0 |
| 2025-10-23 12:30:00 | MSFT | Stock | 522.51 | 523.11 | 522.02 | 522.41 | 249517.0 |
| 2025-10-23 13:00:00 | MSFT | Stock | 522.34 | 522.61 | 521.63 | 522.06 | 224985.0 |
> showing 50 of 107,734 rows — these rows as CSV