PREVIEW / stock_30min / 2025-01-08
file: by_date/stock_30min/2025/2025-01-08.parquet size: 2.3 MB rows: 108,766 symbols: 602
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-08 04:00:00 | AAPL | Stock | 242.0 | 242.75 | 242.0 | 242.6 | 6267.0 |
| 2025-01-08 04:30:00 | AAPL | Stock | 242.56 | 242.7 | 242.56 | 242.69 | 2381.0 |
| 2025-01-08 05:00:00 | AAPL | Stock | 242.82 | 242.83 | 242.71 | 242.78 | 1496.0 |
| 2025-01-08 05:30:00 | AAPL | Stock | 242.82 | 242.92 | 242.82 | 242.89 | 1259.0 |
| 2025-01-08 06:00:00 | AAPL | Stock | 242.91 | 242.91 | 242.0 | 242.0 | 5657.0 |
| 2025-01-08 06:30:00 | AAPL | Stock | 242.03 | 242.03 | 241.09 | 241.88 | 13149.0 |
| 2025-01-08 07:00:00 | AAPL | Stock | 241.68 | 241.86 | 240.9 | 240.99 | 39001.0 |
| 2025-01-08 07:30:00 | AAPL | Stock | 240.93 | 241.25 | 240.73 | 240.79 | 16916.0 |
| 2025-01-08 08:00:00 | AAPL | Stock | 241.56 | 243.04 | 240.5 | 241.81 | 86980.0 |
| 2025-01-08 08:30:00 | AAPL | Stock | 241.99 | 242.19 | 241.5 | 242.0 | 22924.0 |
| 2025-01-08 09:00:00 | AAPL | Stock | 242.1 | 242.12 | 241.23 | 242.0 | 45117.0 |
| 2025-01-08 09:30:00 | AAPL | Stock | 241.92 | 242.0 | 240.05 | 240.9286 | 3328164.0 |
| 2025-01-08 10:00:00 | AAPL | Stock | 240.945 | 242.8655 | 240.87 | 242.4099 | 1972927.0 |
| 2025-01-08 10:30:00 | AAPL | Stock | 242.39 | 243.7123 | 242.08 | 243.47 | 1963652.0 |
| 2025-01-08 11:00:00 | AAPL | Stock | 243.48 | 243.67 | 242.66 | 242.71 | 1313154.0 |
| 2025-01-08 11:30:00 | AAPL | Stock | 242.7261 | 243.58 | 242.64 | 243.275 | 955364.0 |
| 2025-01-08 12:00:00 | AAPL | Stock | 243.28 | 243.2828 | 241.24 | 241.37 | 1252037.0 |
| 2025-01-08 12:30:00 | AAPL | Stock | 241.39 | 241.683 | 241.2 | 241.4 | 1105340.0 |
| 2025-01-08 13:00:00 | AAPL | Stock | 241.39 | 242.52 | 241.35 | 242.35 | 895684.0 |
| 2025-01-08 13:30:00 | AAPL | Stock | 242.35 | 242.48 | 241.125 | 241.422 | 946242.0 |
| 2025-01-08 14:00:00 | AAPL | Stock | 241.425 | 242.98 | 241.04 | 242.795 | 1156035.0 |
| 2025-01-08 14:30:00 | AAPL | Stock | 242.78 | 242.78 | 241.76 | 241.87 | 756305.0 |
| 2025-01-08 15:00:00 | AAPL | Stock | 241.89 | 242.5 | 241.69 | 242.384 | 887055.0 |
| 2025-01-08 15:30:00 | AAPL | Stock | 242.38 | 242.987 | 241.8 | 242.72 | 2694613.0 |
| 2025-01-08 16:00:00 | AAPL | Stock | 242.72 | 242.92 | 242.0795 | 242.75 | 6546233.0 |
| 2025-01-08 16:30:00 | AAPL | Stock | 242.66 | 242.7 | 242.3 | 242.48 | 21682.0 |
| 2025-01-08 17:00:00 | AAPL | Stock | 242.43 | 242.4799 | 242.35 | 242.4 | 6297.0 |
| 2025-01-08 17:30:00 | AAPL | Stock | 242.43 | 242.43 | 242.3 | 242.4 | 909.0 |
| 2025-01-08 18:00:00 | AAPL | Stock | 242.43 | 242.59 | 242.3 | 242.3101 | 8562.0 |
| 2025-01-08 18:30:00 | AAPL | Stock | 242.36 | 242.49 | 242.16 | 242.16 | 1908.0 |
| 2025-01-08 19:00:00 | AAPL | Stock | 242.31 | 242.51 | 242.19 | 242.39 | 11196.0 |
| 2025-01-08 19:30:00 | AAPL | Stock | 242.3993 | 242.4 | 242.2 | 242.4 | 21609.0 |
| 2025-01-08 04:00:00 | MSFT | Stock | 424.0 | 424.83 | 423.63 | 424.83 | 2549.0 |
| 2025-01-08 04:30:00 | MSFT | Stock | 424.62 | 424.62 | 424.35 | 424.35 | 200.0 |
| 2025-01-08 05:00:00 | MSFT | Stock | 424.66 | 424.66 | 424.53 | 424.6 | 400.0 |
| 2025-01-08 05:30:00 | MSFT | Stock | 424.51 | 424.73 | 424.51 | 424.73 | 600.0 |
| 2025-01-08 06:00:00 | MSFT | Stock | 424.84 | 424.95 | 424.16 | 424.16 | 937.0 |
| 2025-01-08 06:30:00 | MSFT | Stock | 423.4 | 423.96 | 422.33 | 423.96 | 3778.0 |
| 2025-01-08 07:00:00 | MSFT | Stock | 423.73 | 423.73 | 421.75 | 422.01 | 11411.0 |
| 2025-01-08 07:30:00 | MSFT | Stock | 421.8 | 422.53 | 421.41 | 422.23 | 4069.0 |
| 2025-01-08 08:00:00 | MSFT | Stock | 423.1 | 424.45 | 421.41 | 424.2 | 25645.0 |
| 2025-01-08 08:30:00 | MSFT | Stock | 423.8 | 424.2 | 423.37 | 423.87 | 10624.0 |
| 2025-01-08 09:00:00 | MSFT | Stock | 423.81 | 424.35 | 423.2568 | 424.11 | 9637.0 |
| 2025-01-08 09:30:00 | MSFT | Stock | 423.46 | 425.86 | 422.79 | 425.72 | 1156320.0 |
| 2025-01-08 10:00:00 | MSFT | Stock | 425.72 | 426.97 | 424.63 | 425.98 | 806853.0 |
| 2025-01-08 10:30:00 | MSFT | Stock | 425.84 | 426.52 | 425.28 | 426.09 | 398049.0 |
| 2025-01-08 11:00:00 | MSFT | Stock | 426.165 | 426.32 | 424.34 | 424.74 | 379247.0 |
| 2025-01-08 11:30:00 | MSFT | Stock | 424.77 | 425.83 | 424.66 | 424.867 | 273084.0 |
| 2025-01-08 12:00:00 | MSFT | Stock | 424.83 | 424.97 | 421.54 | 421.8 | 413625.0 |
| 2025-01-08 12:30:00 | MSFT | Stock | 421.81 | 422.8703 | 421.54 | 422.605 | 311349.0 |
> showing 50 of 108,766 rows — these rows as CSV