PREVIEW / stock_30min / 2025-06-27
file: by_date/stock_30min/2025/2025-06-27.parquet size: 2.2 MB rows: 106,074 symbols: 392
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-27 04:00:00 | AAPL | Stock | 201.88 | 202.09 | 201.66 | 201.88 | 15703.0 |
| 2025-06-27 04:30:00 | AAPL | Stock | 201.98 | 202.07 | 201.94 | 202.05 | 6110.0 |
| 2025-06-27 05:00:00 | AAPL | Stock | 202.0 | 202.03 | 201.85 | 201.93 | 4826.0 |
| 2025-06-27 05:30:00 | AAPL | Stock | 201.86 | 201.99 | 201.75 | 201.99 | 1572.0 |
| 2025-06-27 06:00:00 | AAPL | Stock | 201.91 | 201.97 | 201.88 | 201.94 | 3240.0 |
| 2025-06-27 06:30:00 | AAPL | Stock | 201.89 | 201.89 | 201.7 | 201.7 | 2200.0 |
| 2025-06-27 07:00:00 | AAPL | Stock | 201.67 | 201.96 | 201.58 | 201.9 | 36399.0 |
| 2025-06-27 07:30:00 | AAPL | Stock | 201.93 | 202.01 | 201.9 | 201.98 | 24977.0 |
| 2025-06-27 08:00:00 | AAPL | Stock | 201.84 | 202.09 | 201.18 | 201.91 | 154458.0 |
| 2025-06-27 08:30:00 | AAPL | Stock | 201.85 | 201.8992 | 201.64 | 201.77 | 56089.0 |
| 2025-06-27 09:00:00 | AAPL | Stock | 201.71 | 201.959 | 201.59 | 201.9071 | 46903.0 |
| 2025-06-27 09:30:00 | AAPL | Stock | 201.92 | 203.22 | 201.25 | 202.7974 | 5398294.0 |
| 2025-06-27 10:00:00 | AAPL | Stock | 202.85 | 202.99 | 201.43 | 201.5801 | 3180175.0 |
| 2025-06-27 10:30:00 | AAPL | Stock | 201.59 | 201.9502 | 200.85 | 201.1987 | 3088899.0 |
| 2025-06-27 11:00:00 | AAPL | Stock | 201.2 | 201.44 | 200.955 | 201.3818 | 1650596.0 |
| 2025-06-27 11:30:00 | AAPL | Stock | 201.4 | 202.05 | 201.39 | 201.88 | 1794924.0 |
| 2025-06-27 12:00:00 | AAPL | Stock | 201.88 | 202.03 | 201.57 | 201.99 | 1425899.0 |
| 2025-06-27 12:30:00 | AAPL | Stock | 201.99 | 202.63 | 201.73 | 202.6 | 1737727.0 |
| 2025-06-27 13:00:00 | AAPL | Stock | 202.58 | 202.7 | 202.02 | 202.1 | 1773664.0 |
| 2025-06-27 13:30:00 | AAPL | Stock | 202.1 | 202.125 | 200.93 | 201.3736 | 2216517.0 |
| 2025-06-27 14:00:00 | AAPL | Stock | 201.38 | 201.6568 | 201.13 | 201.44 | 1586202.0 |
| 2025-06-27 14:30:00 | AAPL | Stock | 201.45 | 201.53 | 200.79 | 200.905 | 2121924.0 |
| 2025-06-27 15:00:00 | AAPL | Stock | 200.91 | 201.44 | 200.84 | 201.125 | 1948601.0 |
| 2025-06-27 15:30:00 | AAPL | Stock | 201.13 | 201.27 | 200.0 | 201.1 | 4911183.0 |
| 2025-06-27 16:00:00 | AAPL | Stock | 201.06 | 201.3 | 200.8998 | 201.27 | 19099997.0 |
| 2025-06-27 16:30:00 | AAPL | Stock | 201.21 | 201.35 | 201.08 | 201.27 | 68354.0 |
| 2025-06-27 17:00:00 | AAPL | Stock | 201.22 | 201.31 | 201.21 | 201.21 | 17426.0 |
| 2025-06-27 17:30:00 | AAPL | Stock | 201.21 | 201.26 | 201.1 | 201.14 | 14670.0 |
| 2025-06-27 18:00:00 | AAPL | Stock | 201.15 | 201.25 | 201.15 | 201.16 | 6383.0 |
| 2025-06-27 18:30:00 | AAPL | Stock | 201.1988 | 201.2 | 201.15 | 201.15 | 29165.0 |
| 2025-06-27 19:00:00 | AAPL | Stock | 201.1501 | 201.2297 | 201.15 | 201.18 | 9604.0 |
| 2025-06-27 19:30:00 | AAPL | Stock | 201.15 | 201.2198 | 201.15 | 201.1869 | 10103.0 |
| 2025-06-27 04:00:00 | MSFT | Stock | 498.04 | 498.04 | 497.25 | 497.3 | 3086.0 |
| 2025-06-27 04:30:00 | MSFT | Stock | 497.4 | 497.6 | 497.18 | 497.57 | 1632.0 |
| 2025-06-27 05:00:00 | MSFT | Stock | 497.4 | 497.4 | 496.99 | 497.0 | 1100.0 |
| 2025-06-27 05:30:00 | MSFT | Stock | 497.25 | 497.25 | 497.21 | 497.21 | 649.0 |
| 2025-06-27 06:00:00 | MSFT | Stock | 497.3 | 497.3 | 497.3 | 497.3 | 222.0 |
| 2025-06-27 07:00:00 | MSFT | Stock | 497.02 | 497.48 | 497.02 | 497.48 | 1239.0 |
| 2025-06-27 07:30:00 | MSFT | Stock | 497.55 | 497.94 | 497.55 | 497.89 | 2399.0 |
| 2025-06-27 08:00:00 | MSFT | Stock | 497.6 | 498.53 | 496.207 | 497.7 | 11784.0 |
| 2025-06-27 08:30:00 | MSFT | Stock | 497.575 | 497.7 | 496.92 | 497.21 | 17466.0 |
| 2025-06-27 09:00:00 | MSFT | Stock | 497.0 | 499.0 | 494.0 | 497.73 | 105234.0 |
| 2025-06-27 09:30:00 | MSFT | Stock | 497.54 | 498.17 | 496.2 | 496.98 | 1723563.0 |
| 2025-06-27 10:00:00 | MSFT | Stock | 497.055 | 498.08 | 496.9951 | 497.75 | 757523.0 |
| 2025-06-27 10:30:00 | MSFT | Stock | 497.75 | 498.06 | 496.588 | 496.86 | 519094.0 |
| 2025-06-27 11:00:00 | MSFT | Stock | 496.83 | 498.08 | 496.31 | 497.925 | 441279.0 |
| 2025-06-27 11:30:00 | MSFT | Stock | 497.9156 | 499.3 | 497.84 | 499.08 | 526735.0 |
| 2025-06-27 12:00:00 | MSFT | Stock | 499.05 | 499.24 | 497.91 | 497.96 | 568398.0 |
| 2025-06-27 12:30:00 | MSFT | Stock | 497.96 | 498.35 | 497.74 | 497.987 | 600171.0 |
| 2025-06-27 13:00:00 | MSFT | Stock | 497.9999 | 498.17 | 497.1942 | 497.48 | 413011.0 |
> showing 50 of 106,074 rows — these rows as CSV