PREVIEW / stock_30min / 2025-08-18
file: by_date/stock_30min/2025/2025-08-18.parquet size: 2.2 MB rows: 106,658 symbols: 339
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-08-18 04:00:00 | AAPL | Stock | 231.18 | 231.31 | 230.9 | 230.91 | 9664.0 |
| 2025-08-18 04:30:00 | AAPL | Stock | 231.1 | 231.36 | 231.1 | 231.1 | 2543.0 |
| 2025-08-18 05:00:00 | AAPL | Stock | 231.02 | 231.1 | 230.98 | 231.0 | 3952.0 |
| 2025-08-18 05:30:00 | AAPL | Stock | 231.01 | 231.09 | 230.98 | 231.05 | 6867.0 |
| 2025-08-18 06:00:00 | AAPL | Stock | 231.1 | 231.1 | 231.0 | 231.0 | 2427.0 |
| 2025-08-18 06:30:00 | AAPL | Stock | 231.14 | 231.14 | 231.04 | 231.04 | 2090.0 |
| 2025-08-18 07:00:00 | AAPL | Stock | 231.15 | 231.15 | 231.04 | 231.08 | 4555.0 |
| 2025-08-18 07:30:00 | AAPL | Stock | 231.08 | 231.35 | 231.05 | 231.32 | 4731.0 |
| 2025-08-18 08:00:00 | AAPL | Stock | 231.0 | 231.7 | 230.97 | 231.0 | 41426.0 |
| 2025-08-18 08:30:00 | AAPL | Stock | 231.03 | 231.18 | 230.96 | 231.1601 | 11593.0 |
| 2025-08-18 09:00:00 | AAPL | Stock | 231.16 | 231.77 | 230.8 | 231.75 | 85107.0 |
| 2025-08-18 09:30:00 | AAPL | Stock | 231.77 | 232.73 | 231.34 | 232.35 | 3883676.0 |
| 2025-08-18 10:00:00 | AAPL | Stock | 232.35 | 233.12 | 230.61 | 230.66 | 3242961.0 |
| 2025-08-18 10:30:00 | AAPL | Stock | 230.62 | 231.15 | 230.37 | 230.51 | 2070260.0 |
| 2025-08-18 11:00:00 | AAPL | Stock | 230.5305 | 231.22 | 230.47 | 230.86 | 1402948.0 |
| 2025-08-18 11:30:00 | AAPL | Stock | 230.865 | 231.04 | 230.5 | 230.905 | 1328328.0 |
| 2025-08-18 12:00:00 | AAPL | Stock | 230.9 | 231.11 | 230.65 | 230.68 | 998751.0 |
| 2025-08-18 12:30:00 | AAPL | Stock | 230.68 | 230.76 | 230.11 | 230.595 | 1339529.0 |
| 2025-08-18 13:00:00 | AAPL | Stock | 230.595 | 231.15 | 230.59 | 231.07 | 894997.0 |
| 2025-08-18 13:30:00 | AAPL | Stock | 231.08 | 231.67 | 230.9 | 231.08 | 1099147.0 |
| 2025-08-18 14:00:00 | AAPL | Stock | 231.09 | 231.33 | 230.94 | 231.145 | 883777.0 |
| 2025-08-18 14:30:00 | AAPL | Stock | 231.15 | 231.57 | 231.1 | 231.47 | 917462.0 |
| 2025-08-18 15:00:00 | AAPL | Stock | 231.47 | 231.675 | 231.16 | 231.225 | 1231851.0 |
| 2025-08-18 15:30:00 | AAPL | Stock | 231.225 | 231.58 | 230.88 | 230.88 | 2152936.0 |
| 2025-08-18 16:00:00 | AAPL | Stock | 230.89 | 231.12 | 230.83 | 230.86 | 5646861.0 |
| 2025-08-18 16:30:00 | AAPL | Stock | 230.82 | 230.94 | 230.8 | 230.83 | 12766.0 |
| 2025-08-18 17:00:00 | AAPL | Stock | 230.8 | 230.97 | 230.8 | 230.89 | 14532.0 |
| 2025-08-18 17:30:00 | AAPL | Stock | 230.95 | 231.2001 | 230.95 | 231.0 | 13091.0 |
| 2025-08-18 18:00:00 | AAPL | Stock | 231.0 | 231.25 | 230.9547 | 230.9768 | 5243.0 |
| 2025-08-18 18:30:00 | AAPL | Stock | 231.19 | 231.19 | 230.95 | 231.0 | 2682.0 |
| 2025-08-18 19:00:00 | AAPL | Stock | 231.05 | 231.09 | 230.886 | 230.9065 | 5498.0 |
| 2025-08-18 19:30:00 | AAPL | Stock | 230.91 | 231.0 | 230.8 | 230.91 | 5160.0 |
| 2025-08-18 04:00:00 | MSFT | Stock | 522.0 | 522.0 | 520.65 | 520.83 | 1656.0 |
| 2025-08-18 04:30:00 | MSFT | Stock | 520.91 | 521.4 | 520.91 | 521.26 | 1016.0 |
| 2025-08-18 05:00:00 | MSFT | Stock | 520.97 | 520.97 | 520.4 | 520.4 | 329.0 |
| 2025-08-18 05:30:00 | MSFT | Stock | 520.52 | 520.52 | 520.52 | 520.52 | 119.0 |
| 2025-08-18 06:00:00 | MSFT | Stock | 520.61 | 520.61 | 520.61 | 520.61 | 225.0 |
| 2025-08-18 06:30:00 | MSFT | Stock | 520.86 | 521.57 | 520.86 | 521.5 | 4008.0 |
| 2025-08-18 07:00:00 | MSFT | Stock | 521.5 | 521.5 | 520.49 | 520.51 | 4390.0 |
| 2025-08-18 07:30:00 | MSFT | Stock | 520.45 | 520.8 | 520.45 | 520.8 | 2334.0 |
| 2025-08-18 08:00:00 | MSFT | Stock | 521.0 | 521.6 | 518.87 | 520.65 | 20376.0 |
| 2025-08-18 08:30:00 | MSFT | Stock | 520.61 | 521.0 | 520.5 | 520.84 | 5078.0 |
| 2025-08-18 09:00:00 | MSFT | Stock | 520.77 | 521.74 | 520.55 | 521.74 | 15093.0 |
| 2025-08-18 09:30:00 | MSFT | Stock | 521.53 | 522.82 | 518.36 | 519.195 | 1221027.0 |
| 2025-08-18 10:00:00 | MSFT | Stock | 519.21 | 520.25 | 517.8901 | 517.99 | 680864.0 |
| 2025-08-18 10:30:00 | MSFT | Stock | 517.9 | 518.5 | 517.66 | 518.18 | 995546.0 |
| 2025-08-18 11:00:00 | MSFT | Stock | 518.16 | 518.22 | 516.57 | 516.6775 | 594963.0 |
| 2025-08-18 11:30:00 | MSFT | Stock | 516.68 | 517.0 | 515.8 | 516.925 | 677704.0 |
| 2025-08-18 12:00:00 | MSFT | Stock | 516.965 | 517.37 | 516.63 | 517.19 | 586421.0 |
| 2025-08-18 12:30:00 | MSFT | Stock | 517.1876 | 517.8495 | 515.76 | 516.0 | 561847.0 |
> showing 50 of 106,658 rows — these rows as CSV