PREVIEW / stock_30min / 2025-01-03
file: by_date/stock_30min/2025/2025-01-03.parquet size: 2.2 MB rows: 107,321 symbols: 599
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-01-03 04:00:00 | AAPL | Stock | 243.8 | 243.99 | 243.28 | 243.48 | 7844.0 |
| 2025-01-03 04:30:00 | AAPL | Stock | 243.45 | 243.66 | 243.25 | 243.65 | 5838.0 |
| 2025-01-03 05:00:00 | AAPL | Stock | 243.4 | 243.61 | 243.16 | 243.59 | 5097.0 |
| 2025-01-03 05:30:00 | AAPL | Stock | 243.59 | 243.69 | 243.32 | 243.51 | 2228.0 |
| 2025-01-03 06:00:00 | AAPL | Stock | 243.5 | 243.67 | 243.5 | 243.63 | 2431.0 |
| 2025-01-03 06:30:00 | AAPL | Stock | 243.71 | 244.66 | 243.7 | 244.35 | 6205.0 |
| 2025-01-03 07:00:00 | AAPL | Stock | 244.26 | 244.26 | 243.22 | 243.23 | 39532.0 |
| 2025-01-03 07:30:00 | AAPL | Stock | 243.3 | 243.3 | 242.41 | 242.46 | 57728.0 |
| 2025-01-03 08:00:00 | AAPL | Stock | 243.005 | 244.65 | 242.28 | 242.47 | 154152.0 |
| 2025-01-03 08:30:00 | AAPL | Stock | 242.6118 | 243.85 | 242.38 | 242.57 | 106465.0 |
| 2025-01-03 09:00:00 | AAPL | Stock | 242.59 | 243.4788 | 242.59 | 243.4 | 184606.0 |
| 2025-01-03 09:30:00 | AAPL | Stock | 243.4 | 244.18 | 241.89 | 243.095 | 4632302.0 |
| 2025-01-03 10:00:00 | AAPL | Stock | 243.11 | 244.0 | 242.35 | 242.4598 | 2003611.0 |
| 2025-01-03 10:30:00 | AAPL | Stock | 242.45 | 243.25 | 242.14 | 243.0075 | 1803990.0 |
| 2025-01-03 11:00:00 | AAPL | Stock | 243.03 | 243.6756 | 242.68 | 243.49 | 1478920.0 |
| 2025-01-03 11:30:00 | AAPL | Stock | 243.48 | 244.0486 | 243.3 | 243.3201 | 1384936.0 |
| 2025-01-03 12:00:00 | AAPL | Stock | 243.34 | 243.519 | 242.67 | 242.7707 | 1469499.0 |
| 2025-01-03 12:30:00 | AAPL | Stock | 242.78 | 242.91 | 242.39 | 242.528 | 1189499.0 |
| 2025-01-03 13:00:00 | AAPL | Stock | 242.515 | 243.16 | 242.28 | 243.005 | 1401090.0 |
| 2025-01-03 13:30:00 | AAPL | Stock | 243.0 | 243.06 | 242.54 | 242.72 | 1145886.0 |
| 2025-01-03 14:00:00 | AAPL | Stock | 242.71 | 242.985 | 242.57 | 242.67 | 1040768.0 |
| 2025-01-03 14:30:00 | AAPL | Stock | 242.66 | 243.4424 | 242.64 | 243.26 | 1408095.0 |
| 2025-01-03 15:00:00 | AAPL | Stock | 243.25 | 243.2599 | 242.8 | 242.85 | 888212.0 |
| 2025-01-03 15:30:00 | AAPL | Stock | 242.84 | 243.6 | 242.61 | 243.3 | 3463895.0 |
| 2025-01-03 16:00:00 | AAPL | Stock | 243.36 | 243.8 | 243.0002 | 243.1 | 5213575.0 |
| 2025-01-03 16:30:00 | AAPL | Stock | 243.36 | 243.36 | 243.02 | 243.1 | 28092.0 |
| 2025-01-03 17:00:00 | AAPL | Stock | 243.15 | 243.18 | 243.13 | 243.14 | 2706.0 |
| 2025-01-03 17:30:00 | AAPL | Stock | 243.14 | 243.2408 | 243.1 | 243.16 | 11565.0 |
| 2025-01-03 18:00:00 | AAPL | Stock | 243.18 | 243.36 | 243.12 | 243.3 | 5749.0 |
| 2025-01-03 18:30:00 | AAPL | Stock | 243.35 | 243.36 | 243.22 | 243.22 | 4163.0 |
| 2025-01-03 19:00:00 | AAPL | Stock | 243.21 | 243.3 | 243.1 | 243.28 | 10100.0 |
| 2025-01-03 19:30:00 | AAPL | Stock | 243.25 | 243.3908 | 243.1701 | 243.3908 | 7730.0 |
| 2025-01-03 04:00:00 | MSFT | Stock | 420.58 | 421.78 | 420.58 | 421.59 | 2398.0 |
| 2025-01-03 04:30:00 | MSFT | Stock | 421.57 | 421.6 | 421.33 | 421.33 | 700.0 |
| 2025-01-03 05:00:00 | MSFT | Stock | 421.3 | 421.3 | 420.96 | 420.99 | 1939.0 |
| 2025-01-03 05:30:00 | MSFT | Stock | 420.91 | 420.91 | 420.68 | 420.72 | 1820.0 |
| 2025-01-03 06:00:00 | MSFT | Stock | 420.65 | 420.8 | 420.48 | 420.7 | 1395.0 |
| 2025-01-03 06:30:00 | MSFT | Stock | 420.55 | 420.57 | 420.55 | 420.57 | 372.0 |
| 2025-01-03 07:00:00 | MSFT | Stock | 420.62 | 420.62 | 419.57 | 419.81 | 7536.0 |
| 2025-01-03 07:30:00 | MSFT | Stock | 419.9 | 420.26 | 419.88 | 420.0 | 4078.0 |
| 2025-01-03 08:00:00 | MSFT | Stock | 419.99 | 421.0 | 419.41 | 420.0 | 19526.0 |
| 2025-01-03 08:30:00 | MSFT | Stock | 420.0 | 420.2995 | 418.58 | 419.846 | 18819.0 |
| 2025-01-03 09:00:00 | MSFT | Stock | 419.82 | 422.0 | 419.5063 | 421.77 | 21185.0 |
| 2025-01-03 09:30:00 | MSFT | Stock | 421.08 | 422.8199 | 420.52 | 422.42 | 1175711.0 |
| 2025-01-03 10:00:00 | MSFT | Stock | 422.49 | 423.76 | 420.15 | 420.92 | 648611.0 |
| 2025-01-03 10:30:00 | MSFT | Stock | 420.92 | 422.09 | 420.32 | 421.33 | 436806.0 |
| 2025-01-03 11:00:00 | MSFT | Stock | 421.33 | 421.57 | 419.54 | 421.403 | 584956.0 |
| 2025-01-03 11:30:00 | MSFT | Stock | 421.36 | 422.655 | 421.31 | 421.54 | 493040.0 |
| 2025-01-03 12:00:00 | MSFT | Stock | 421.58 | 422.098 | 421.07 | 421.07 | 299003.0 |
| 2025-01-03 12:30:00 | MSFT | Stock | 421.11 | 422.25 | 420.94 | 421.9846 | 324037.0 |
> showing 50 of 107,321 rows — these rows as CSV