PREVIEW / stock_30min / 2025-06-30
file: by_date/stock_30min/2025/2025-06-30.parquet size: 2.3 MB rows: 109,702 symbols: 393
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-30 04:00:00 | AAPL | Stock | 202.0 | 202.29 | 201.69 | 202.2 | 15495.0 |
| 2025-06-30 04:30:00 | AAPL | Stock | 202.21 | 202.32 | 202.09 | 202.09 | 7061.0 |
| 2025-06-30 05:00:00 | AAPL | Stock | 202.08 | 202.32 | 202.08 | 202.29 | 3046.0 |
| 2025-06-30 05:30:00 | AAPL | Stock | 202.3 | 202.47 | 202.2 | 202.21 | 8685.0 |
| 2025-06-30 06:00:00 | AAPL | Stock | 202.25 | 202.5 | 202.25 | 202.44 | 6455.0 |
| 2025-06-30 06:30:00 | AAPL | Stock | 202.39 | 202.51 | 202.39 | 202.5 | 12307.0 |
| 2025-06-30 07:00:00 | AAPL | Stock | 202.48 | 202.74 | 202.36 | 202.56 | 26381.0 |
| 2025-06-30 07:30:00 | AAPL | Stock | 202.5 | 202.53 | 202.34 | 202.4 | 16225.0 |
| 2025-06-30 08:00:00 | AAPL | Stock | 202.4 | 202.74 | 200.578 | 202.19 | 149425.0 |
| 2025-06-30 08:30:00 | AAPL | Stock | 202.11 | 202.19 | 201.77 | 201.9 | 57140.0 |
| 2025-06-30 09:00:00 | AAPL | Stock | 201.92 | 202.15 | 201.87 | 201.99 | 84651.0 |
| 2025-06-30 09:30:00 | AAPL | Stock | 202.06 | 202.19 | 200.5501 | 200.76 | 4331006.0 |
| 2025-06-30 10:00:00 | AAPL | Stock | 200.755 | 201.3711 | 200.3524 | 201.0099 | 2646332.0 |
| 2025-06-30 10:30:00 | AAPL | Stock | 201.005 | 201.32 | 199.5901 | 199.97 | 3462374.0 |
| 2025-06-30 11:00:00 | AAPL | Stock | 199.97 | 200.2853 | 199.63 | 199.97 | 2053358.0 |
| 2025-06-30 11:30:00 | AAPL | Stock | 199.98 | 200.23 | 199.8 | 200.035 | 1676906.0 |
| 2025-06-30 12:00:00 | AAPL | Stock | 200.04 | 200.42 | 199.99 | 200.31 | 1141230.0 |
| 2025-06-30 12:30:00 | AAPL | Stock | 200.31 | 200.48 | 199.845 | 200.12 | 1587464.0 |
| 2025-06-30 13:00:00 | AAPL | Stock | 200.12 | 200.265 | 199.94 | 200.155 | 1789170.0 |
| 2025-06-30 13:30:00 | AAPL | Stock | 200.155 | 200.34 | 199.9 | 200.27 | 1163448.0 |
| 2025-06-30 14:00:00 | AAPL | Stock | 200.275 | 200.83 | 200.275 | 200.695 | 1459105.0 |
| 2025-06-30 14:30:00 | AAPL | Stock | 200.6951 | 202.68 | 199.2607 | 201.9195 | 6995975.0 |
| 2025-06-30 15:00:00 | AAPL | Stock | 201.91 | 207.09 | 201.885 | 206.5856 | 15691007.0 |
| 2025-06-30 15:30:00 | AAPL | Stock | 206.54 | 207.39 | 205.05 | 205.12 | 11092834.0 |
| 2025-06-30 16:00:00 | AAPL | Stock | 205.06 | 206.3 | 204.66 | 205.23 | 14838620.0 |
| 2025-06-30 16:30:00 | AAPL | Stock | 205.23 | 205.78 | 205.16 | 205.45 | 149466.0 |
| 2025-06-30 17:00:00 | AAPL | Stock | 205.26 | 205.35 | 205.13 | 205.17 | 68674.0 |
| 2025-06-30 17:30:00 | AAPL | Stock | 205.18 | 205.62 | 205.13 | 205.4 | 67247.0 |
| 2025-06-30 18:00:00 | AAPL | Stock | 205.41 | 205.5 | 205.0 | 205.061 | 93077.0 |
| 2025-06-30 18:30:00 | AAPL | Stock | 205.14 | 205.2451 | 205.0 | 205.2451 | 50448.0 |
| 2025-06-30 19:00:00 | AAPL | Stock | 205.2 | 205.6 | 205.17 | 205.5467 | 48480.0 |
| 2025-06-30 19:30:00 | AAPL | Stock | 205.5 | 205.96 | 205.44 | 205.44 | 93960.0 |
| 2025-06-30 04:00:00 | MSFT | Stock | 497.51 | 497.9 | 497.5 | 497.9 | 712.0 |
| 2025-06-30 04:30:00 | MSFT | Stock | 497.73 | 497.73 | 497.73 | 497.73 | 100.0 |
| 2025-06-30 05:00:00 | MSFT | Stock | 497.75 | 498.0 | 497.75 | 498.0 | 455.0 |
| 2025-06-30 05:30:00 | MSFT | Stock | 498.24 | 498.66 | 498.2 | 498.2 | 1415.0 |
| 2025-06-30 06:00:00 | MSFT | Stock | 498.68 | 498.75 | 498.68 | 498.75 | 200.0 |
| 2025-06-30 06:30:00 | MSFT | Stock | 498.84 | 498.85 | 498.84 | 498.84 | 1176.0 |
| 2025-06-30 07:00:00 | MSFT | Stock | 498.75 | 499.0 | 498.55 | 499.0 | 3040.0 |
| 2025-06-30 07:30:00 | MSFT | Stock | 499.0 | 499.0 | 498.5 | 498.6 | 7262.0 |
| 2025-06-30 08:00:00 | MSFT | Stock | 498.75 | 499.1799 | 494.701 | 498.59 | 16939.0 |
| 2025-06-30 08:30:00 | MSFT | Stock | 498.35 | 498.4997 | 497.4 | 497.5 | 20237.0 |
| 2025-06-30 09:00:00 | MSFT | Stock | 497.7 | 498.34 | 496.5 | 497.18 | 15878.0 |
| 2025-06-30 09:30:00 | MSFT | Stock | 497.04 | 498.0 | 495.58 | 496.875 | 1258834.0 |
| 2025-06-30 10:00:00 | MSFT | Stock | 496.875 | 496.95 | 495.625 | 496.0577 | 806779.0 |
| 2025-06-30 10:30:00 | MSFT | Stock | 496.075 | 497.02 | 495.33 | 496.56 | 544408.0 |
| 2025-06-30 11:00:00 | MSFT | Stock | 496.64 | 497.51 | 496.49 | 497.3875 | 541682.0 |
| 2025-06-30 11:30:00 | MSFT | Stock | 497.43 | 499.31 | 497.25 | 498.57 | 763758.0 |
| 2025-06-30 12:00:00 | MSFT | Stock | 498.59 | 499.18 | 497.76 | 497.83 | 464492.0 |
| 2025-06-30 12:30:00 | MSFT | Stock | 497.815 | 498.76 | 497.73 | 498.035 | 499308.0 |
> showing 50 of 109,702 rows — these rows as CSV