PREVIEW / stock_30min / 2025-02-27
file: by_date/stock_30min/2025/2025-02-27.parquet size: 2.2 MB rows: 104,497 symbols: 517
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-02-27 04:00:00 | AAPL | Stock | 240.12 | 241.65 | 240.12 | 241.31 | 14567.0 |
| 2025-02-27 04:30:00 | AAPL | Stock | 241.21 | 241.26 | 240.79 | 240.91 | 4918.0 |
| 2025-02-27 05:00:00 | AAPL | Stock | 240.91 | 240.91 | 240.65 | 240.65 | 4472.0 |
| 2025-02-27 05:30:00 | AAPL | Stock | 240.55 | 240.59 | 240.38 | 240.38 | 4960.0 |
| 2025-02-27 06:00:00 | AAPL | Stock | 240.4 | 240.56 | 240.19 | 240.19 | 6282.0 |
| 2025-02-27 06:30:00 | AAPL | Stock | 240.26 | 240.37 | 240.25 | 240.34 | 2963.0 |
| 2025-02-27 07:00:00 | AAPL | Stock | 240.32 | 240.36 | 239.54 | 239.7 | 17264.0 |
| 2025-02-27 07:30:00 | AAPL | Stock | 239.86 | 239.95 | 239.1 | 239.16 | 12866.0 |
| 2025-02-27 08:00:00 | AAPL | Stock | 239.95 | 241.34 | 238.7699 | 239.1975 | 82645.0 |
| 2025-02-27 08:30:00 | AAPL | Stock | 239.1 | 239.55 | 238.65 | 239.0 | 60765.0 |
| 2025-02-27 09:00:00 | AAPL | Stock | 238.95 | 239.7999 | 238.79 | 239.66 | 106549.0 |
| 2025-02-27 09:30:00 | AAPL | Stock | 239.61 | 242.284 | 238.92 | 240.58 | 3612459.0 |
| 2025-02-27 10:00:00 | AAPL | Stock | 240.62 | 241.68 | 238.47 | 241.375 | 2203912.0 |
| 2025-02-27 10:30:00 | AAPL | Stock | 241.36 | 241.8 | 240.64 | 241.24 | 1142392.0 |
| 2025-02-27 11:00:00 | AAPL | Stock | 241.23 | 242.46 | 240.9 | 241.52 | 1339108.0 |
| 2025-02-27 11:30:00 | AAPL | Stock | 241.52 | 241.7848 | 240.2501 | 240.435 | 917358.0 |
| 2025-02-27 12:00:00 | AAPL | Stock | 240.46 | 241.06 | 239.585 | 241.058 | 878886.0 |
| 2025-02-27 12:30:00 | AAPL | Stock | 241.07 | 241.345 | 240.35 | 240.775 | 655236.0 |
| 2025-02-27 13:00:00 | AAPL | Stock | 240.82 | 242.19 | 240.76 | 241.9 | 833112.0 |
| 2025-02-27 13:30:00 | AAPL | Stock | 241.93 | 242.05 | 241.56 | 241.61 | 582545.0 |
| 2025-02-27 14:00:00 | AAPL | Stock | 241.6001 | 241.76 | 240.52 | 240.63 | 800462.0 |
| 2025-02-27 14:30:00 | AAPL | Stock | 240.645 | 240.66 | 239.54 | 239.71 | 1249104.0 |
| 2025-02-27 15:00:00 | AAPL | Stock | 239.71 | 239.93 | 238.7703 | 238.92 | 1802594.0 |
| 2025-02-27 15:30:00 | AAPL | Stock | 238.96 | 239.3695 | 237.06 | 237.39 | 4523668.0 |
| 2025-02-27 16:00:00 | AAPL | Stock | 237.38 | 237.74 | 236.96 | 237.06 | 5693486.0 |
| 2025-02-27 16:30:00 | AAPL | Stock | 237.0144 | 237.61 | 237.0131 | 237.312 | 97809.0 |
| 2025-02-27 17:00:00 | AAPL | Stock | 237.36 | 237.44 | 237.16 | 237.22 | 7500.0 |
| 2025-02-27 17:30:00 | AAPL | Stock | 237.22 | 237.23 | 236.75 | 236.8283 | 12018.0 |
| 2025-02-27 18:00:00 | AAPL | Stock | 236.98 | 238.5 | 236.98 | 237.45 | 23321.0 |
| 2025-02-27 18:30:00 | AAPL | Stock | 237.47 | 237.7 | 237.1292 | 237.7 | 13203.0 |
| 2025-02-27 19:00:00 | AAPL | Stock | 238.0 | 238.2375 | 237.31 | 237.3145 | 8397.0 |
| 2025-02-27 19:30:00 | AAPL | Stock | 237.3697 | 237.7294 | 237.3 | 237.3 | 5593.0 |
| 2025-02-27 04:00:00 | MSFT | Stock | 401.93 | 402.1 | 401.86 | 402.1 | 3132.0 |
| 2025-02-27 04:30:00 | MSFT | Stock | 401.76 | 401.76 | 401.36 | 401.41 | 700.0 |
| 2025-02-27 05:00:00 | MSFT | Stock | 401.3 | 401.41 | 401.3 | 401.4 | 1708.0 |
| 2025-02-27 05:30:00 | MSFT | Stock | 400.92 | 401.36 | 400.92 | 401.11 | 2639.0 |
| 2025-02-27 06:00:00 | MSFT | Stock | 401.23 | 401.29 | 400.88 | 401.2 | 2105.0 |
| 2025-02-27 06:30:00 | MSFT | Stock | 401.0 | 401.0 | 400.9 | 400.9 | 1427.0 |
| 2025-02-27 07:00:00 | MSFT | Stock | 401.0 | 402.15 | 401.0 | 401.13 | 8294.0 |
| 2025-02-27 07:30:00 | MSFT | Stock | 401.25 | 401.5 | 400.53 | 400.9 | 9597.0 |
| 2025-02-27 08:00:00 | MSFT | Stock | 401.47 | 402.07 | 400.09 | 401.2 | 31992.0 |
| 2025-02-27 08:30:00 | MSFT | Stock | 401.15 | 401.6 | 400.61 | 401.2 | 16408.0 |
| 2025-02-27 09:00:00 | MSFT | Stock | 401.15 | 401.87 | 400.72 | 401.2 | 20761.0 |
| 2025-02-27 09:30:00 | MSFT | Stock | 401.2 | 405.74 | 399.36 | 399.9 | 1721984.0 |
| 2025-02-27 10:00:00 | MSFT | Stock | 399.85 | 400.39 | 397.9301 | 399.485 | 758181.0 |
| 2025-02-27 10:30:00 | MSFT | Stock | 399.44 | 400.3999 | 397.7 | 397.8208 | 565054.0 |
| 2025-02-27 11:00:00 | MSFT | Stock | 397.8 | 399.6299 | 397.63 | 398.13 | 393327.0 |
| 2025-02-27 11:30:00 | MSFT | Stock | 398.13 | 398.6 | 396.98 | 397.21 | 458139.0 |
| 2025-02-27 12:00:00 | MSFT | Stock | 397.22 | 397.91 | 396.63 | 397.84 | 455463.0 |
| 2025-02-27 12:30:00 | MSFT | Stock | 397.82 | 398.48 | 396.8 | 397.0801 | 322740.0 |
> showing 50 of 104,497 rows — these rows as CSV