PREVIEW / stock_30min / 2025-09-02
file: by_date/stock_30min/2025/2025-09-02.parquet size: 2.3 MB rows: 109,256 symbols: 323
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-02 04:00:00 | AAPL | Stock | 231.88 | 231.88 | 230.7 | 231.12 | 8877.0 |
| 2025-09-02 04:30:00 | AAPL | Stock | 231.02 | 231.2 | 231.02 | 231.2 | 761.0 |
| 2025-09-02 05:00:00 | AAPL | Stock | 231.06 | 231.2 | 231.01 | 231.15 | 2019.0 |
| 2025-09-02 05:30:00 | AAPL | Stock | 231.04 | 231.05 | 230.92 | 230.92 | 3632.0 |
| 2025-09-02 06:00:00 | AAPL | Stock | 230.89 | 231.0 | 230.5 | 230.5 | 7101.0 |
| 2025-09-02 06:30:00 | AAPL | Stock | 230.3 | 230.6 | 230.28 | 230.42 | 4220.0 |
| 2025-09-02 07:00:00 | AAPL | Stock | 230.49 | 230.77 | 230.35 | 230.76 | 18173.0 |
| 2025-09-02 07:30:00 | AAPL | Stock | 230.61 | 230.66 | 230.47 | 230.63 | 6082.0 |
| 2025-09-02 08:00:00 | AAPL | Stock | 230.27 | 231.81 | 230.2643 | 230.41 | 126604.0 |
| 2025-09-02 08:30:00 | AAPL | Stock | 230.4 | 230.5 | 229.41 | 229.53 | 71120.0 |
| 2025-09-02 09:00:00 | AAPL | Stock | 229.38 | 229.9125 | 229.14 | 229.46 | 79532.0 |
| 2025-09-02 09:30:00 | AAPL | Stock | 229.25 | 230.455 | 227.68 | 230.19 | 4875156.0 |
| 2025-09-02 10:00:00 | AAPL | Stock | 230.13 | 230.78 | 229.99 | 230.6 | 2132535.0 |
| 2025-09-02 10:30:00 | AAPL | Stock | 230.6 | 230.75 | 228.0 | 228.09 | 2074520.0 |
| 2025-09-02 11:00:00 | AAPL | Stock | 228.095 | 228.4374 | 227.5284 | 227.829 | 1785490.0 |
| 2025-09-02 11:30:00 | AAPL | Stock | 227.82 | 228.01 | 227.17 | 227.4154 | 1400271.0 |
| 2025-09-02 12:00:00 | AAPL | Stock | 227.41 | 228.1469 | 227.38 | 227.85 | 950510.0 |
| 2025-09-02 12:30:00 | AAPL | Stock | 227.8437 | 228.15 | 227.65 | 228.0172 | 872731.0 |
| 2025-09-02 13:00:00 | AAPL | Stock | 228.02 | 228.5454 | 227.85 | 228.41 | 834435.0 |
| 2025-09-02 13:30:00 | AAPL | Stock | 228.42 | 229.34 | 228.38 | 228.61 | 976180.0 |
| 2025-09-02 14:00:00 | AAPL | Stock | 228.6 | 228.78 | 228.33 | 228.4 | 739888.0 |
| 2025-09-02 14:30:00 | AAPL | Stock | 228.4 | 228.9 | 228.35 | 228.5715 | 806761.0 |
| 2025-09-02 15:00:00 | AAPL | Stock | 228.57 | 229.09 | 226.97 | 228.94 | 1795872.0 |
| 2025-09-02 15:30:00 | AAPL | Stock | 228.9247 | 230.85 | 228.895 | 229.73 | 3586847.0 |
| 2025-09-02 16:00:00 | AAPL | Stock | 229.72 | 239.32 | 228.81 | 239.1001 | 7399797.0 |
| 2025-09-02 16:30:00 | AAPL | Stock | 239.17 | 239.5 | 229.72 | 238.04 | 1763280.0 |
| 2025-09-02 17:00:00 | AAPL | Stock | 238.11 | 238.6 | 237.28 | 237.47 | 375219.0 |
| 2025-09-02 17:30:00 | AAPL | Stock | 237.47 | 237.88 | 236.8 | 236.8 | 163985.0 |
| 2025-09-02 18:00:00 | AAPL | Stock | 236.93 | 237.0212 | 236.36 | 236.42 | 70326.0 |
| 2025-09-02 18:30:00 | AAPL | Stock | 236.4 | 236.6595 | 235.5 | 235.56 | 72842.0 |
| 2025-09-02 19:00:00 | AAPL | Stock | 235.67 | 236.26 | 235.5 | 235.7 | 33842.0 |
| 2025-09-02 19:30:00 | AAPL | Stock | 235.74 | 236.97 | 235.65 | 236.532 | 77776.0 |
| 2025-09-02 04:00:00 | MSFT | Stock | 505.24 | 505.24 | 504.2 | 504.85 | 4027.0 |
| 2025-09-02 04:30:00 | MSFT | Stock | 504.5 | 504.5 | 504.43 | 504.5 | 1192.0 |
| 2025-09-02 05:00:00 | MSFT | Stock | 504.76 | 504.76 | 504.5 | 504.56 | 787.0 |
| 2025-09-02 05:30:00 | MSFT | Stock | 504.91 | 504.91 | 504.32 | 504.32 | 210.0 |
| 2025-09-02 06:00:00 | MSFT | Stock | 504.34 | 504.34 | 504.34 | 504.34 | 250.0 |
| 2025-09-02 06:30:00 | MSFT | Stock | 503.49 | 503.49 | 503.05 | 503.3 | 707.0 |
| 2025-09-02 07:00:00 | MSFT | Stock | 503.48 | 503.48 | 502.88 | 503.01 | 2331.0 |
| 2025-09-02 07:30:00 | MSFT | Stock | 502.81 | 503.46 | 502.81 | 503.46 | 1852.0 |
| 2025-09-02 08:00:00 | MSFT | Stock | 502.8 | 506.24 | 502.42 | 502.5 | 30051.0 |
| 2025-09-02 08:30:00 | MSFT | Stock | 502.5 | 502.5 | 501.1 | 501.28 | 18518.0 |
| 2025-09-02 09:00:00 | MSFT | Stock | 501.2 | 501.5387 | 499.5 | 500.0 | 40274.0 |
| 2025-09-02 09:30:00 | MSFT | Stock | 500.28 | 504.365 | 496.81 | 503.59 | 1845675.0 |
| 2025-09-02 10:00:00 | MSFT | Stock | 503.61 | 505.35 | 502.465 | 505.25 | 612001.0 |
| 2025-09-02 10:30:00 | MSFT | Stock | 505.29 | 505.4292 | 502.66 | 502.875 | 630112.0 |
| 2025-09-02 11:00:00 | MSFT | Stock | 502.862 | 503.3065 | 500.5 | 501.03 | 604494.0 |
| 2025-09-02 11:30:00 | MSFT | Stock | 501.03 | 501.14 | 500.31 | 500.72 | 436445.0 |
| 2025-09-02 12:00:00 | MSFT | Stock | 500.7 | 501.67 | 500.62 | 500.96 | 359219.0 |
| 2025-09-02 12:30:00 | MSFT | Stock | 500.965 | 501.8 | 500.81 | 501.53 | 311008.0 |
> showing 50 of 109,256 rows — these rows as CSV