PREVIEW / stock_30min / 2025-06-05
file: by_date/stock_30min/2025/2025-06-05.parquet size: 2.2 MB rows: 104,778 symbols: 404
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-05 04:00:00 | AAPL | Stock | 202.99 | 203.38 | 202.7 | 203.22 | 23688.0 |
| 2025-06-05 04:30:00 | AAPL | Stock | 203.23 | 203.25 | 202.85 | 203.01 | 30433.0 |
| 2025-06-05 05:00:00 | AAPL | Stock | 202.97 | 203.01 | 202.75 | 202.93 | 13024.0 |
| 2025-06-05 05:30:00 | AAPL | Stock | 203.0 | 203.1 | 202.83 | 202.83 | 1390.0 |
| 2025-06-05 06:00:00 | AAPL | Stock | 202.95 | 203.13 | 202.93 | 203.1 | 4650.0 |
| 2025-06-05 06:30:00 | AAPL | Stock | 203.03 | 203.03 | 202.52 | 202.6 | 14442.0 |
| 2025-06-05 07:00:00 | AAPL | Stock | 202.59 | 202.59 | 202.0 | 202.28 | 18737.0 |
| 2025-06-05 07:30:00 | AAPL | Stock | 202.28 | 202.51 | 202.17 | 202.49 | 9371.0 |
| 2025-06-05 08:00:00 | AAPL | Stock | 202.25 | 203.28 | 201.75 | 202.7018 | 69318.0 |
| 2025-06-05 08:30:00 | AAPL | Stock | 202.63 | 204.2 | 202.5 | 203.55 | 158758.0 |
| 2025-06-05 09:00:00 | AAPL | Stock | 203.6 | 204.0 | 203.36 | 203.5 | 105900.0 |
| 2025-06-05 09:30:00 | AAPL | Stock | 203.56 | 203.84 | 201.27 | 201.56 | 3971536.0 |
| 2025-06-05 10:00:00 | AAPL | Stock | 201.56 | 202.5338 | 201.34 | 202.45 | 2700668.0 |
| 2025-06-05 10:30:00 | AAPL | Stock | 202.45 | 203.33 | 201.65 | 203.2 | 2670291.0 |
| 2025-06-05 11:00:00 | AAPL | Stock | 203.2 | 204.59 | 203.06 | 204.5438 | 2250697.0 |
| 2025-06-05 11:30:00 | AAPL | Stock | 204.535 | 204.75 | 203.8711 | 204.165 | 1893189.0 |
| 2025-06-05 12:00:00 | AAPL | Stock | 204.165 | 204.39 | 202.48 | 203.14 | 1701529.0 |
| 2025-06-05 12:30:00 | AAPL | Stock | 203.14 | 203.25 | 201.6964 | 201.8437 | 1506047.0 |
| 2025-06-05 13:00:00 | AAPL | Stock | 201.835 | 202.67 | 201.55 | 202.6001 | 1470576.0 |
| 2025-06-05 13:30:00 | AAPL | Stock | 202.6 | 202.9 | 202.25 | 202.37 | 951281.0 |
| 2025-06-05 14:00:00 | AAPL | Stock | 202.37 | 202.41 | 201.15 | 202.2104 | 1380908.0 |
| 2025-06-05 14:30:00 | AAPL | Stock | 202.21 | 202.74 | 202.04 | 202.35 | 1087092.0 |
| 2025-06-05 15:00:00 | AAPL | Stock | 202.34 | 202.41 | 200.2 | 200.73 | 2455583.0 |
| 2025-06-05 15:30:00 | AAPL | Stock | 200.74 | 201.77 | 200.15 | 200.63 | 4625846.0 |
| 2025-06-05 16:00:00 | AAPL | Stock | 200.58 | 200.94 | 200.5 | 200.8 | 10596810.0 |
| 2025-06-05 16:30:00 | AAPL | Stock | 200.66 | 200.95 | 200.25 | 200.6001 | 61566.0 |
| 2025-06-05 17:00:00 | AAPL | Stock | 200.71 | 200.89 | 200.25 | 200.779 | 30483.0 |
| 2025-06-05 17:30:00 | AAPL | Stock | 200.8 | 200.8 | 200.21 | 200.28 | 16678.0 |
| 2025-06-05 18:00:00 | AAPL | Stock | 200.29 | 200.88 | 200.2 | 200.63 | 29587.0 |
| 2025-06-05 18:30:00 | AAPL | Stock | 200.63 | 200.84 | 200.6 | 200.8 | 17835.0 |
| 2025-06-05 19:00:00 | AAPL | Stock | 200.8 | 200.98 | 200.55 | 200.85 | 17917.0 |
| 2025-06-05 19:30:00 | AAPL | Stock | 200.8964 | 201.0 | 200.65 | 200.8 | 21697.0 |
| 2025-06-05 04:00:00 | MSFT | Stock | 465.31 | 465.31 | 465.19 | 465.19 | 204.0 |
| 2025-06-05 04:30:00 | MSFT | Stock | 465.58 | 465.6 | 464.5 | 464.5 | 2988.0 |
| 2025-06-05 05:00:00 | MSFT | Stock | 464.25 | 464.43 | 463.77 | 464.03 | 2257.0 |
| 2025-06-05 06:30:00 | MSFT | Stock | 464.21 | 464.21 | 463.43 | 463.64 | 1863.0 |
| 2025-06-05 07:00:00 | MSFT | Stock | 463.65 | 463.88 | 463.4 | 463.7 | 2272.0 |
| 2025-06-05 07:30:00 | MSFT | Stock | 463.84 | 464.26 | 463.84 | 464.25 | 5227.0 |
| 2025-06-05 08:00:00 | MSFT | Stock | 463.75 | 465.26 | 463.4001 | 464.42 | 13394.0 |
| 2025-06-05 08:30:00 | MSFT | Stock | 464.2 | 466.95 | 463.18 | 464.99 | 18590.0 |
| 2025-06-05 09:00:00 | MSFT | Stock | 465.0 | 465.35 | 464.22 | 465.18 | 11083.0 |
| 2025-06-05 09:30:00 | MSFT | Stock | 464.955 | 467.36 | 464.03 | 464.85 | 1014835.0 |
| 2025-06-05 10:00:00 | MSFT | Stock | 464.86 | 466.7 | 464.44 | 466.405 | 500035.0 |
| 2025-06-05 10:30:00 | MSFT | Stock | 466.4 | 467.49 | 464.51 | 466.555 | 738740.0 |
| 2025-06-05 11:00:00 | MSFT | Stock | 466.63 | 467.88 | 466.48 | 467.64 | 396252.0 |
| 2025-06-05 11:30:00 | MSFT | Stock | 467.66 | 468.29 | 467.24 | 467.97 | 635402.0 |
| 2025-06-05 12:00:00 | MSFT | Stock | 467.93 | 468.7493 | 467.37 | 468.185 | 492608.0 |
| 2025-06-05 12:30:00 | MSFT | Stock | 468.185 | 468.49 | 466.4 | 466.635 | 545306.0 |
| 2025-06-05 13:00:00 | MSFT | Stock | 466.59 | 467.815 | 466.2431 | 467.29 | 416547.0 |
| 2025-06-05 13:30:00 | MSFT | Stock | 467.29 | 467.99 | 467.29 | 467.71 | 324766.0 |
> showing 50 of 104,778 rows — these rows as CSV