PREVIEW / stock_30min / 2025-01-02
file: by_date/stock_30min/2025/2025-01-02.parquet size: 2.3 MB rows: 109,179 symbols: 599
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-02 04:00:00 | AAPL | Stock | 251.36 | 251.9 | 250.6 | 251.7 | 16192.0 |
| 2025-01-02 04:30:00 | AAPL | Stock | 251.75 | 251.83 | 251.3 | 251.3 | 6642.0 |
| 2025-01-02 05:00:00 | AAPL | Stock | 251.26 | 251.29 | 250.45 | 250.85 | 21148.0 |
| 2025-01-02 05:30:00 | AAPL | Stock | 250.79 | 250.91 | 250.51 | 250.55 | 13616.0 |
| 2025-01-02 06:00:00 | AAPL | Stock | 250.6 | 250.6 | 250.24 | 250.32 | 6205.0 |
| 2025-01-02 06:30:00 | AAPL | Stock | 250.32 | 250.38 | 249.87 | 250.345 | 22693.0 |
| 2025-01-02 07:00:00 | AAPL | Stock | 250.35 | 251.07 | 250.25 | 251.0 | 37187.0 |
| 2025-01-02 07:30:00 | AAPL | Stock | 251.01 | 251.01 | 250.22 | 250.5 | 29760.0 |
| 2025-01-02 08:00:00 | AAPL | Stock | 250.345 | 251.65 | 250.27 | 250.4081 | 67331.0 |
| 2025-01-02 08:30:00 | AAPL | Stock | 250.46 | 250.56 | 248.9 | 249.1 | 130348.0 |
| 2025-01-02 09:00:00 | AAPL | Stock | 249.1 | 249.25 | 248.17 | 248.9 | 160030.0 |
| 2025-01-02 09:30:00 | AAPL | Stock | 248.93 | 249.1 | 244.8 | 246.8526 | 7348843.0 |
| 2025-01-02 10:00:00 | AAPL | Stock | 246.885 | 247.81 | 245.29 | 245.68 | 3034790.0 |
| 2025-01-02 10:30:00 | AAPL | Stock | 245.66 | 245.88 | 244.82 | 245.415 | 2822647.0 |
| 2025-01-02 11:00:00 | AAPL | Stock | 245.4175 | 245.485 | 244.1601 | 244.895 | 2253710.0 |
| 2025-01-02 11:30:00 | AAPL | Stock | 244.9099 | 245.25 | 244.52 | 244.64 | 1398104.0 |
| 2025-01-02 12:00:00 | AAPL | Stock | 244.68 | 245.25 | 243.31 | 243.4286 | 1997946.0 |
| 2025-01-02 12:30:00 | AAPL | Stock | 243.42 | 243.42 | 242.31 | 242.985 | 2498556.0 |
| 2025-01-02 13:00:00 | AAPL | Stock | 242.98 | 243.03 | 242.31 | 242.6862 | 1644297.0 |
| 2025-01-02 13:30:00 | AAPL | Stock | 242.67 | 242.7 | 241.8201 | 242.23 | 2173647.0 |
| 2025-01-02 14:00:00 | AAPL | Stock | 242.24 | 242.84 | 242.03 | 242.4884 | 1897465.0 |
| 2025-01-02 14:30:00 | AAPL | Stock | 242.48 | 242.639 | 241.8713 | 241.96 | 1740903.0 |
| 2025-01-02 15:00:00 | AAPL | Stock | 241.97 | 243.44 | 241.97 | 243.2311 | 2110984.0 |
| 2025-01-02 15:30:00 | AAPL | Stock | 243.25 | 243.95 | 243.01 | 243.82 | 3594404.0 |
| 2025-01-02 16:00:00 | AAPL | Stock | 243.85 | 243.95 | 243.45 | 243.62 | 6109314.0 |
| 2025-01-02 16:30:00 | AAPL | Stock | 243.62 | 243.85 | 243.55 | 243.64 | 106325.0 |
| 2025-01-02 17:00:00 | AAPL | Stock | 243.6 | 243.61 | 243.5 | 243.61 | 8476.0 |
| 2025-01-02 17:30:00 | AAPL | Stock | 243.6499 | 243.65 | 243.55 | 243.5504 | 3834.0 |
| 2025-01-02 18:00:00 | AAPL | Stock | 243.55 | 243.85 | 243.19 | 243.3 | 28170.0 |
| 2025-01-02 18:30:00 | AAPL | Stock | 243.27 | 243.3 | 243.1159 | 243.24 | 5637.0 |
| 2025-01-02 19:00:00 | AAPL | Stock | 243.24 | 243.5 | 243.21 | 243.42 | 65728.0 |
| 2025-01-02 19:30:00 | AAPL | Stock | 243.46 | 244.15 | 243.45 | 243.99 | 54402.0 |
| 2025-01-02 04:00:00 | MSFT | Stock | 424.5 | 424.9 | 423.91 | 424.71 | 4814.0 |
| 2025-01-02 04:30:00 | MSFT | Stock | 424.67 | 425.47 | 424.25 | 425.21 | 2083.0 |
| 2025-01-02 05:00:00 | MSFT | Stock | 425.0 | 425.24 | 424.87 | 425.24 | 2258.0 |
| 2025-01-02 05:30:00 | MSFT | Stock | 425.23 | 425.5 | 425.18 | 425.5 | 1354.0 |
| 2025-01-02 06:00:00 | MSFT | Stock | 425.32 | 426.56 | 425.26 | 425.94 | 1825.0 |
| 2025-01-02 06:30:00 | MSFT | Stock | 425.72 | 428.3 | 425.7 | 428.13 | 9869.0 |
| 2025-01-02 07:00:00 | MSFT | Stock | 427.83 | 428.0 | 427.25 | 427.72 | 11637.0 |
| 2025-01-02 07:30:00 | MSFT | Stock | 427.72 | 427.72 | 426.66 | 427.3 | 8153.0 |
| 2025-01-02 08:00:00 | MSFT | Stock | 427.24 | 428.0 | 423.76 | 425.67 | 31134.0 |
| 2025-01-02 08:30:00 | MSFT | Stock | 425.86 | 426.7 | 425.8 | 425.8 | 16946.0 |
| 2025-01-02 09:00:00 | MSFT | Stock | 425.7 | 427.28 | 425.1 | 425.71 | 19331.0 |
| 2025-01-02 09:30:00 | MSFT | Stock | 425.53 | 426.07 | 422.7 | 425.4 | 1315664.0 |
| 2025-01-02 10:00:00 | MSFT | Stock | 425.5 | 425.93 | 422.25 | 423.19 | 781465.0 |
| 2025-01-02 10:30:00 | MSFT | Stock | 423.12 | 423.365 | 420.5 | 421.73 | 598377.0 |
| 2025-01-02 11:00:00 | MSFT | Stock | 421.9 | 421.96 | 420.3 | 421.48 | 387211.0 |
| 2025-01-02 11:30:00 | MSFT | Stock | 421.49 | 422.36 | 421.095 | 421.61 | 424574.0 |
| 2025-01-02 12:00:00 | MSFT | Stock | 421.6203 | 421.96 | 418.06 | 418.34 | 656319.0 |
| 2025-01-02 12:30:00 | MSFT | Stock | 418.25 | 418.3188 | 414.85 | 416.12 | 680904.0 |
> showing 50 of 109,179 rows — these rows as CSV