PREVIEW / stock_30min / 2025-10-24
file: by_date/stock_30min/2025/2025-10-24.parquet size: 2.2 MB rows: 108,386 symbols: 222
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-24 04:00:00 | AAPL | Stock | 259.67 | 259.79 | 259.5 | 259.59 | 3950.0 |
| 2025-10-24 04:30:00 | AAPL | Stock | 259.54 | 259.58 | 259.3 | 259.58 | 2190.0 |
| 2025-10-24 05:00:00 | AAPL | Stock | 259.29 | 259.63 | 259.25 | 259.63 | 3104.0 |
| 2025-10-24 05:30:00 | AAPL | Stock | 259.63 | 259.66 | 259.44 | 259.44 | 2589.0 |
| 2025-10-24 06:00:00 | AAPL | Stock | 259.54 | 260.25 | 259.54 | 260.24 | 5507.0 |
| 2025-10-24 06:30:00 | AAPL | Stock | 260.25 | 260.42 | 260.04 | 260.34 | 2490.0 |
| 2025-10-24 07:00:00 | AAPL | Stock | 260.3 | 260.54 | 260.12 | 260.54 | 8901.0 |
| 2025-10-24 07:30:00 | AAPL | Stock | 260.56 | 260.57 | 260.42 | 260.5 | 3869.0 |
| 2025-10-24 08:00:00 | AAPL | Stock | 260.24 | 260.7043 | 259.43 | 260.58 | 37189.0 |
| 2025-10-24 08:30:00 | AAPL | Stock | 260.59 | 262.0 | 260.32 | 260.91 | 125035.0 |
| 2025-10-24 09:00:00 | AAPL | Stock | 260.98 | 261.55 | 260.65 | 261.1 | 68010.0 |
| 2025-10-24 09:30:00 | AAPL | Stock | 261.16 | 261.68 | 259.18 | 260.16 | 3406298.0 |
| 2025-10-24 10:00:00 | AAPL | Stock | 260.2 | 261.3 | 259.88 | 260.9414 | 1828851.0 |
| 2025-10-24 10:30:00 | AAPL | Stock | 260.94 | 262.35 | 260.78 | 261.831 | 2035014.0 |
| 2025-10-24 11:00:00 | AAPL | Stock | 261.85 | 263.37 | 261.76 | 263.28 | 2125636.0 |
| 2025-10-24 11:30:00 | AAPL | Stock | 263.29 | 263.785 | 262.93 | 263.3372 | 1904559.0 |
| 2025-10-24 12:00:00 | AAPL | Stock | 263.345 | 264.03 | 263.3002 | 263.575 | 1441527.0 |
| 2025-10-24 12:30:00 | AAPL | Stock | 263.59 | 263.6084 | 262.85 | 263.1099 | 1065586.0 |
| 2025-10-24 13:00:00 | AAPL | Stock | 263.1 | 263.71 | 263.09 | 263.61 | 1142239.0 |
| 2025-10-24 13:30:00 | AAPL | Stock | 263.61 | 264.09 | 263.41 | 263.9001 | 1080607.0 |
| 2025-10-24 14:00:00 | AAPL | Stock | 263.89 | 264.13 | 263.6 | 264.0278 | 1067342.0 |
| 2025-10-24 14:30:00 | AAPL | Stock | 264.025 | 264.1 | 263.42 | 263.52 | 1191136.0 |
| 2025-10-24 15:00:00 | AAPL | Stock | 263.51 | 263.565 | 263.15 | 263.5 | 1223620.0 |
| 2025-10-24 15:30:00 | AAPL | Stock | 263.51 | 263.66 | 262.08 | 262.77 | 3590571.0 |
| 2025-10-24 16:00:00 | AAPL | Stock | 262.83 | 263.0 | 262.61 | 262.75 | 5939303.0 |
| 2025-10-24 16:30:00 | AAPL | Stock | 262.78 | 262.86 | 262.6999 | 262.76 | 13314.0 |
| 2025-10-24 17:00:00 | AAPL | Stock | 262.76 | 263.0 | 262.24 | 262.85 | 49574.0 |
| 2025-10-24 17:30:00 | AAPL | Stock | 262.87 | 263.2 | 262.8501 | 263.1 | 11654.0 |
| 2025-10-24 18:00:00 | AAPL | Stock | 263.1 | 263.17 | 263.02 | 263.0234 | 7485.0 |
| 2025-10-24 18:30:00 | AAPL | Stock | 263.07 | 263.08 | 262.94 | 262.94 | 6171.0 |
| 2025-10-24 19:00:00 | AAPL | Stock | 262.97 | 263.1644 | 262.94 | 263.1644 | 2220.0 |
| 2025-10-24 19:30:00 | AAPL | Stock | 263.06 | 263.1 | 262.8844 | 263.01 | 4403.0 |
| 2025-10-24 04:00:00 | MSFT | Stock | 521.5 | 522.24 | 520.67 | 520.8 | 5944.0 |
| 2025-10-24 04:30:00 | MSFT | Stock | 520.8 | 521.96 | 520.78 | 521.53 | 9064.0 |
| 2025-10-24 05:00:00 | MSFT | Stock | 521.78 | 522.66 | 521.78 | 522.66 | 2542.0 |
| 2025-10-24 05:30:00 | MSFT | Stock | 522.48 | 522.66 | 522.3 | 522.47 | 1473.0 |
| 2025-10-24 06:00:00 | MSFT | Stock | 522.5 | 523.08 | 522.5 | 522.8 | 3902.0 |
| 2025-10-24 06:30:00 | MSFT | Stock | 522.99 | 524.49 | 520.9 | 521.1 | 25292.0 |
| 2025-10-24 07:00:00 | MSFT | Stock | 521.25 | 521.51 | 520.0 | 521.51 | 6959.0 |
| 2025-10-24 07:30:00 | MSFT | Stock | 521.69 | 522.04 | 520.98 | 522.0 | 12816.0 |
| 2025-10-24 08:00:00 | MSFT | Stock | 522.0 | 523.0 | 520.0 | 521.92 | 45889.0 |
| 2025-10-24 08:30:00 | MSFT | Stock | 522.39 | 524.5 | 522.39 | 523.1116 | 35171.0 |
| 2025-10-24 09:00:00 | MSFT | Stock | 523.17 | 524.08 | 522.42 | 522.68 | 34733.0 |
| 2025-10-24 09:30:00 | MSFT | Stock | 522.83 | 525.05 | 520.71 | 523.0 | 1403614.0 |
| 2025-10-24 10:00:00 | MSFT | Stock | 523.02 | 523.6 | 522.12 | 523.11 | 423634.0 |
| 2025-10-24 10:30:00 | MSFT | Stock | 523.105 | 523.78 | 522.0 | 522.975 | 361278.0 |
| 2025-10-24 11:00:00 | MSFT | Stock | 523.01 | 523.52 | 522.07 | 523.205 | 372359.0 |
| 2025-10-24 11:30:00 | MSFT | Stock | 523.2 | 523.8 | 522.14 | 522.305 | 259386.0 |
| 2025-10-24 12:00:00 | MSFT | Stock | 522.34 | 523.94 | 522.3202 | 523.94 | 231346.0 |
| 2025-10-24 12:30:00 | MSFT | Stock | 523.88 | 525.02 | 523.7 | 524.45 | 338835.0 |
> showing 50 of 108,386 rows — these rows as CSV