PREVIEW / stock_30min / 2025-07-03
file: by_date/stock_30min/2025/2025-07-03.parquet size: 1.5 MB rows: 70,973 symbols: 380
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-07-03 04:00:00 | AAPL | Stock | 212.8 | 213.09 | 212.51 | 212.51 | 24531.0 |
| 2025-07-03 04:30:00 | AAPL | Stock | 212.51 | 212.54 | 212.09 | 212.13 | 8265.0 |
| 2025-07-03 05:00:00 | AAPL | Stock | 212.13 | 212.27 | 211.9 | 212.08 | 5716.0 |
| 2025-07-03 05:30:00 | AAPL | Stock | 212.01 | 212.04 | 210.41 | 210.43 | 26948.0 |
| 2025-07-03 06:00:00 | AAPL | Stock | 210.42 | 210.78 | 209.85 | 210.52 | 39864.0 |
| 2025-07-03 06:30:00 | AAPL | Stock | 210.55 | 210.9 | 210.55 | 210.9 | 15267.0 |
| 2025-07-03 07:00:00 | AAPL | Stock | 210.9 | 211.52 | 210.86 | 211.28 | 25154.0 |
| 2025-07-03 07:30:00 | AAPL | Stock | 211.3 | 211.3 | 211.07 | 211.149 | 11202.0 |
| 2025-07-03 08:00:00 | AAPL | Stock | 210.92 | 212.9646 | 209.81 | 211.6 | 133791.0 |
| 2025-07-03 08:30:00 | AAPL | Stock | 211.7 | 212.3989 | 211.4 | 211.7999 | 161501.0 |
| 2025-07-03 09:00:00 | AAPL | Stock | 211.7899 | 212.3 | 211.73 | 212.15 | 98040.0 |
| 2025-07-03 09:30:00 | AAPL | Stock | 212.07 | 213.79 | 211.8101 | 213.33 | 5684403.0 |
| 2025-07-03 10:00:00 | AAPL | Stock | 213.33 | 213.8599 | 213.23 | 213.735 | 2964857.0 |
| 2025-07-03 10:30:00 | AAPL | Stock | 213.74 | 214.41 | 213.04 | 213.96 | 4023983.0 |
| 2025-07-03 11:00:00 | AAPL | Stock | 213.97 | 214.46 | 213.84 | 213.88 | 2346225.0 |
| 2025-07-03 11:30:00 | AAPL | Stock | 213.885 | 214.65 | 213.67 | 214.33 | 2201826.0 |
| 2025-07-03 12:00:00 | AAPL | Stock | 214.34 | 214.4999 | 213.95 | 214.1 | 1788022.0 |
| 2025-07-03 12:30:00 | AAPL | Stock | 214.1 | 214.14 | 213.33 | 213.59 | 2943763.0 |
| 2025-07-03 13:00:00 | AAPL | Stock | 213.33 | 213.55 | 213.24 | 213.25 | 4074816.0 |
| 2025-07-03 13:30:00 | AAPL | Stock | 213.24 | 213.4 | 213.19 | 213.35 | 36560.0 |
| 2025-07-03 14:00:00 | AAPL | Stock | 213.34 | 213.35 | 213.25 | 213.26 | 11903.0 |
| 2025-07-03 14:30:00 | AAPL | Stock | 213.28 | 213.3 | 213.2 | 213.25 | 12090.0 |
| 2025-07-03 15:00:00 | AAPL | Stock | 213.21 | 213.2499 | 213.1098 | 213.16 | 17594.0 |
| 2025-07-03 15:30:00 | AAPL | Stock | 213.15 | 213.62 | 213.11 | 213.39 | 28625.0 |
| 2025-07-03 16:00:00 | AAPL | Stock | 213.4 | 213.55 | 213.38 | 213.53 | 9081.0 |
| 2025-07-03 16:30:00 | AAPL | Stock | 213.42 | 213.59 | 213.35 | 213.55 | 18096.0 |
| 2025-07-03 04:00:00 | MSFT | Stock | 492.0 | 492.0 | 491.67 | 491.76 | 1101.0 |
| 2025-07-03 04:30:00 | MSFT | Stock | 491.55 | 491.63 | 491.12 | 491.12 | 3037.0 |
| 2025-07-03 05:00:00 | MSFT | Stock | 491.13 | 491.2 | 491.13 | 491.2 | 1005.0 |
| 2025-07-03 05:30:00 | MSFT | Stock | 491.0 | 491.0 | 490.97 | 490.97 | 200.0 |
| 2025-07-03 06:00:00 | MSFT | Stock | 490.82 | 490.82 | 490.32 | 490.79 | 1764.0 |
| 2025-07-03 06:30:00 | MSFT | Stock | 490.72 | 490.8 | 490.72 | 490.8 | 300.0 |
| 2025-07-03 07:00:00 | MSFT | Stock | 490.76 | 491.49 | 490.76 | 491.49 | 586.0 |
| 2025-07-03 07:30:00 | MSFT | Stock | 491.2 | 491.25 | 490.7 | 490.75 | 1809.0 |
| 2025-07-03 08:00:00 | MSFT | Stock | 490.8187 | 491.81 | 490.57 | 490.75 | 15132.0 |
| 2025-07-03 08:30:00 | MSFT | Stock | 491.51 | 492.2499 | 490.75 | 491.98 | 35421.0 |
| 2025-07-03 09:00:00 | MSFT | Stock | 492.23 | 494.13 | 492.16 | 493.74 | 21979.0 |
| 2025-07-03 09:30:00 | MSFT | Stock | 493.81 | 496.3842 | 493.44 | 496.075 | 1289188.0 |
| 2025-07-03 10:00:00 | MSFT | Stock | 496.07 | 499.04 | 496.07 | 498.2762 | 1260246.0 |
| 2025-07-03 10:30:00 | MSFT | Stock | 498.31 | 498.66 | 497.568 | 498.565 | 556944.0 |
| 2025-07-03 11:00:00 | MSFT | Stock | 498.55 | 499.68 | 498.33 | 498.43 | 878567.0 |
| 2025-07-03 11:30:00 | MSFT | Stock | 498.45 | 500.13 | 498.3247 | 499.65 | 752119.0 |
| 2025-07-03 12:00:00 | MSFT | Stock | 499.68 | 499.8 | 498.83 | 498.9285 | 410533.0 |
| 2025-07-03 12:30:00 | MSFT | Stock | 498.93 | 499.85 | 498.23 | 498.69 | 947547.0 |
| 2025-07-03 13:00:00 | MSFT | Stock | 498.54 | 498.847 | 498.2 | 498.69 | 2420790.0 |
| 2025-07-03 13:30:00 | MSFT | Stock | 498.72 | 498.84 | 498.33 | 498.339 | 20198.0 |
| 2025-07-03 14:00:00 | MSFT | Stock | 498.34 | 498.5207 | 498.0 | 498.25 | 18350.0 |
| 2025-07-03 14:30:00 | MSFT | Stock | 498.34 | 498.47 | 497.5 | 498.07 | 6989.0 |
| 2025-07-03 15:00:00 | MSFT | Stock | 498.23 | 498.4 | 498.05 | 498.0693 | 3470.0 |
| 2025-07-03 15:30:00 | MSFT | Stock | 498.1 | 498.95 | 498.05 | 498.2 | 5262.0 |
> showing 50 of 70,973 rows — these rows as CSV