PREVIEW / stock_30min / 2025-06-10
file: by_date/stock_30min/2025/2025-06-10.parquet size: 2.2 MB rows: 105,093 symbols: 406
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-06-10 04:00:00 | AAPL | Stock | 202.14 | 202.14 | 201.11 | 201.2 | 16430.0 |
| 2025-06-10 04:30:00 | AAPL | Stock | 201.23 | 201.67 | 201.22 | 201.47 | 7531.0 |
| 2025-06-10 05:00:00 | AAPL | Stock | 201.48 | 201.79 | 201.48 | 201.67 | 20854.0 |
| 2025-06-10 05:30:00 | AAPL | Stock | 201.74 | 201.74 | 201.44 | 201.49 | 7204.0 |
| 2025-06-10 06:00:00 | AAPL | Stock | 201.48 | 201.64 | 201.41 | 201.5 | 13503.0 |
| 2025-06-10 06:30:00 | AAPL | Stock | 201.48 | 201.5 | 200.92 | 201.21 | 24224.0 |
| 2025-06-10 07:00:00 | AAPL | Stock | 201.25 | 201.28 | 200.5 | 200.84 | 41025.0 |
| 2025-06-10 07:30:00 | AAPL | Stock | 200.9 | 201.15 | 200.9 | 201.1 | 40640.0 |
| 2025-06-10 08:00:00 | AAPL | Stock | 201.25 | 202.67 | 200.5 | 201.5499 | 220718.0 |
| 2025-06-10 08:30:00 | AAPL | Stock | 201.55 | 201.61 | 201.25 | 201.3299 | 66890.0 |
| 2025-06-10 09:00:00 | AAPL | Stock | 201.4 | 201.4 | 200.24 | 200.65 | 228062.0 |
| 2025-06-10 09:30:00 | AAPL | Stock | 200.56 | 203.15 | 200.56 | 202.2 | 6360368.0 |
| 2025-06-10 10:00:00 | AAPL | Stock | 202.2 | 203.36 | 202.18 | 202.87 | 3031967.0 |
| 2025-06-10 10:30:00 | AAPL | Stock | 202.86 | 204.35 | 202.73 | 204.267 | 2980219.0 |
| 2025-06-10 11:00:00 | AAPL | Stock | 204.26 | 204.32 | 203.13 | 203.315 | 2237323.0 |
| 2025-06-10 11:30:00 | AAPL | Stock | 203.32 | 203.32 | 202.3001 | 202.92 | 1734555.0 |
| 2025-06-10 12:00:00 | AAPL | Stock | 202.93 | 203.17 | 202.4 | 202.5388 | 1591909.0 |
| 2025-06-10 12:30:00 | AAPL | Stock | 202.53 | 202.763 | 202.0704 | 202.585 | 1318717.0 |
| 2025-06-10 13:00:00 | AAPL | Stock | 202.585 | 202.645 | 201.75 | 201.76 | 1956930.0 |
| 2025-06-10 13:30:00 | AAPL | Stock | 201.78 | 202.04 | 201.31 | 201.75 | 2349615.0 |
| 2025-06-10 14:00:00 | AAPL | Stock | 201.7503 | 202.1 | 201.36 | 201.7 | 1732869.0 |
| 2025-06-10 14:30:00 | AAPL | Stock | 201.69 | 203.0735 | 201.6 | 202.66 | 1832286.0 |
| 2025-06-10 15:00:00 | AAPL | Stock | 202.68 | 203.23 | 202.65 | 202.82 | 1956040.0 |
| 2025-06-10 15:30:00 | AAPL | Stock | 202.8211 | 202.98 | 202.09 | 202.75 | 3125859.0 |
| 2025-06-10 16:00:00 | AAPL | Stock | 202.67 | 202.75 | 202.41 | 202.5495 | 7453708.0 |
| 2025-06-10 16:30:00 | AAPL | Stock | 202.5004 | 202.64 | 202.5001 | 202.59 | 15815.0 |
| 2025-06-10 17:00:00 | AAPL | Stock | 202.6378 | 202.64 | 202.5601 | 202.6392 | 13931.0 |
| 2025-06-10 17:30:00 | AAPL | Stock | 202.625 | 202.7 | 202.59 | 202.65 | 24066.0 |
| 2025-06-10 18:00:00 | AAPL | Stock | 202.66 | 202.72 | 202.66 | 202.7 | 16154.0 |
| 2025-06-10 18:30:00 | AAPL | Stock | 202.7 | 202.89 | 202.6 | 202.87 | 15356.0 |
| 2025-06-10 19:00:00 | AAPL | Stock | 202.82 | 203.24 | 202.5 | 203.0 | 33555.0 |
| 2025-06-10 19:30:00 | AAPL | Stock | 203.0799 | 203.0799 | 202.751 | 202.9 | 31516.0 |
| 2025-06-10 04:00:00 | MSFT | Stock | 471.02 | 471.14 | 470.42 | 470.89 | 2147.0 |
| 2025-06-10 04:30:00 | MSFT | Stock | 470.98 | 471.22 | 470.98 | 471.22 | 1023.0 |
| 2025-06-10 05:30:00 | MSFT | Stock | 471.56 | 471.56 | 471.56 | 471.56 | 125.0 |
| 2025-06-10 06:00:00 | MSFT | Stock | 471.66 | 471.66 | 471.66 | 471.66 | 106.0 |
| 2025-06-10 06:30:00 | MSFT | Stock | 471.85 | 471.85 | 471.85 | 471.85 | 106.0 |
| 2025-06-10 07:00:00 | MSFT | Stock | 471.6 | 471.61 | 471.26 | 471.26 | 1661.0 |
| 2025-06-10 07:30:00 | MSFT | Stock | 471.36 | 472.0 | 471.36 | 471.96 | 1309.0 |
| 2025-06-10 08:00:00 | MSFT | Stock | 471.4 | 473.2 | 470.1 | 472.01 | 15700.0 |
| 2025-06-10 08:30:00 | MSFT | Stock | 472.12 | 472.48 | 471.98 | 471.98 | 3935.0 |
| 2025-06-10 09:00:00 | MSFT | Stock | 472.0 | 472.0 | 470.7 | 471.62 | 10230.0 |
| 2025-06-10 09:30:00 | MSFT | Stock | 471.185 | 472.8 | 468.3301 | 470.09 | 1567862.0 |
| 2025-06-10 10:00:00 | MSFT | Stock | 470.11 | 470.9294 | 469.31 | 469.87 | 682316.0 |
| 2025-06-10 10:30:00 | MSFT | Stock | 469.85 | 470.03 | 468.96 | 469.03 | 491873.0 |
| 2025-06-10 11:00:00 | MSFT | Stock | 469.05 | 469.33 | 468.285 | 469.05 | 516302.0 |
| 2025-06-10 11:30:00 | MSFT | Stock | 469.04 | 469.0935 | 466.96 | 468.54 | 600081.0 |
| 2025-06-10 12:00:00 | MSFT | Stock | 468.54 | 469.66 | 468.49 | 469.5118 | 272940.0 |
| 2025-06-10 12:30:00 | MSFT | Stock | 469.515 | 469.9 | 469.263 | 469.777 | 246413.0 |
| 2025-06-10 13:00:00 | MSFT | Stock | 469.775 | 470.1709 | 469.39 | 469.4984 | 267783.0 |
> showing 50 of 105,093 rows — these rows as CSV