PREVIEW / stock_30min / 2025-09-10
file: by_date/stock_30min/2025/2025-09-10.parquet size: 2.3 MB rows: 110,427 symbols: 316
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-09-10 04:00:00 | AAPL | Stock | 234.3 | 234.3 | 233.5 | 233.5 | 18749.0 |
| 2025-09-10 04:30:00 | AAPL | Stock | 233.43 | 233.5 | 233.25 | 233.44 | 9540.0 |
| 2025-09-10 05:00:00 | AAPL | Stock | 233.35 | 233.35 | 233.2 | 233.35 | 4656.0 |
| 2025-09-10 05:30:00 | AAPL | Stock | 233.42 | 233.73 | 233.42 | 233.5 | 7379.0 |
| 2025-09-10 06:00:00 | AAPL | Stock | 233.51 | 233.6 | 233.4 | 233.5 | 8345.0 |
| 2025-09-10 06:30:00 | AAPL | Stock | 233.51 | 233.6 | 233.29 | 233.54 | 12325.0 |
| 2025-09-10 07:00:00 | AAPL | Stock | 233.55 | 233.84 | 233.3 | 233.33 | 25437.0 |
| 2025-09-10 07:30:00 | AAPL | Stock | 233.4 | 233.4 | 233.14 | 233.3 | 27974.0 |
| 2025-09-10 08:00:00 | AAPL | Stock | 233.67 | 234.8 | 232.06 | 232.4689 | 244178.0 |
| 2025-09-10 08:30:00 | AAPL | Stock | 232.7 | 233.51 | 232.48 | 233.01 | 223727.0 |
| 2025-09-10 09:00:00 | AAPL | Stock | 233.0199 | 234.09 | 231.52 | 231.97 | 361705.0 |
| 2025-09-10 09:30:00 | AAPL | Stock | 231.97 | 232.42 | 228.84 | 229.5496 | 9967514.0 |
| 2025-09-10 10:00:00 | AAPL | Stock | 229.5326 | 229.8 | 227.55 | 228.108 | 6750914.0 |
| 2025-09-10 10:30:00 | AAPL | Stock | 228.11 | 228.3464 | 227.35 | 227.73 | 4646141.0 |
| 2025-09-10 11:00:00 | AAPL | Stock | 227.7399 | 228.1 | 227.02 | 227.04 | 4550510.0 |
| 2025-09-10 11:30:00 | AAPL | Stock | 227.04 | 227.3599 | 226.2401 | 227.26 | 4655918.0 |
| 2025-09-10 12:00:00 | AAPL | Stock | 227.255 | 228.055 | 226.985 | 227.7465 | 3388715.0 |
| 2025-09-10 12:30:00 | AAPL | Stock | 227.745 | 227.79 | 226.82 | 227.41 | 2317639.0 |
| 2025-09-10 13:00:00 | AAPL | Stock | 227.405 | 227.745 | 226.62 | 226.805 | 1894240.0 |
| 2025-09-10 13:30:00 | AAPL | Stock | 226.8 | 227.08 | 226.5886 | 226.685 | 2025668.0 |
| 2025-09-10 14:00:00 | AAPL | Stock | 226.675 | 227.085 | 226.35 | 227.0583 | 2003412.0 |
| 2025-09-10 14:30:00 | AAPL | Stock | 227.055 | 227.35 | 226.415 | 226.89 | 1977214.0 |
| 2025-09-10 15:00:00 | AAPL | Stock | 226.89 | 227.047 | 226.18 | 226.185 | 2396554.0 |
| 2025-09-10 15:30:00 | AAPL | Stock | 226.185 | 227.3 | 225.95 | 226.78 | 5804549.0 |
| 2025-09-10 16:00:00 | AAPL | Stock | 226.79 | 227.5 | 226.74 | 226.8003 | 11041812.0 |
| 2025-09-10 16:30:00 | AAPL | Stock | 226.7999 | 226.9992 | 226.7999 | 226.92 | 29281.0 |
| 2025-09-10 17:00:00 | AAPL | Stock | 226.9 | 227.1 | 226.79 | 227.1 | 85378.0 |
| 2025-09-10 17:30:00 | AAPL | Stock | 227.1 | 227.3 | 227.09 | 227.3 | 29767.0 |
| 2025-09-10 18:00:00 | AAPL | Stock | 227.27 | 227.36 | 227.22 | 227.36 | 20592.0 |
| 2025-09-10 18:30:00 | AAPL | Stock | 227.36 | 227.4 | 227.34 | 227.38 | 20980.0 |
| 2025-09-10 19:00:00 | AAPL | Stock | 227.38 | 227.38 | 227.09 | 227.14 | 26316.0 |
| 2025-09-10 19:30:00 | AAPL | Stock | 227.15 | 227.2 | 226.9 | 227.0212 | 26395.0 |
| 2025-09-10 04:00:00 | MSFT | Stock | 499.51 | 500.0 | 498.51 | 499.31 | 4169.0 |
| 2025-09-10 04:30:00 | MSFT | Stock | 499.47 | 499.47 | 497.7 | 497.8 | 8609.0 |
| 2025-09-10 05:00:00 | MSFT | Stock | 498.0 | 498.0 | 497.81 | 498.0 | 2817.0 |
| 2025-09-10 05:30:00 | MSFT | Stock | 498.0 | 498.5 | 497.9 | 498.43 | 3158.0 |
| 2025-09-10 06:00:00 | MSFT | Stock | 498.52 | 499.1 | 498.52 | 499.1 | 2867.0 |
| 2025-09-10 06:30:00 | MSFT | Stock | 499.48 | 502.19 | 499.32 | 501.75 | 22414.0 |
| 2025-09-10 07:00:00 | MSFT | Stock | 501.48 | 502.32 | 500.9 | 502.0 | 14555.0 |
| 2025-09-10 07:30:00 | MSFT | Stock | 501.6 | 504.37 | 501.25 | 504.3 | 28712.0 |
| 2025-09-10 08:00:00 | MSFT | Stock | 501.2 | 507.74 | 497.77 | 506.1903 | 115012.0 |
| 2025-09-10 08:30:00 | MSFT | Stock | 506.22 | 507.62 | 505.9 | 506.47 | 62550.0 |
| 2025-09-10 09:00:00 | MSFT | Stock | 506.34 | 506.53 | 501.93 | 503.0 | 98917.0 |
| 2025-09-10 09:30:00 | MSFT | Stock | 502.97 | 503.2299 | 496.72 | 500.58 | 2597189.0 |
| 2025-09-10 10:00:00 | MSFT | Stock | 500.52 | 502.61 | 500.35 | 501.49 | 1323392.0 |
| 2025-09-10 10:30:00 | MSFT | Stock | 501.47 | 502.94 | 499.66 | 499.805 | 969532.0 |
| 2025-09-10 11:00:00 | MSFT | Stock | 499.785 | 500.875 | 498.5 | 500.705 | 901837.0 |
| 2025-09-10 11:30:00 | MSFT | Stock | 500.705 | 501.5466 | 499.98 | 500.82 | 512954.0 |
| 2025-09-10 12:00:00 | MSFT | Stock | 500.8 | 500.83 | 499.1001 | 499.245 | 403956.0 |
| 2025-09-10 12:30:00 | MSFT | Stock | 499.24 | 499.79 | 498.84 | 499.5 | 319951.0 |
> showing 50 of 110,427 rows — these rows as CSV