PREVIEW / stock_30min / 2025-01-27
file: by_date/stock_30min/2025/2025-01-27.parquet size: 2.3 MB rows: 113,174 symbols: 584
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-27 04:00:00 | AAPL | Stock | 219.9 | 220.3 | 218.2 | 220.2 | 98219.0 |
| 2025-01-27 04:30:00 | AAPL | Stock | 220.02 | 220.94 | 219.75 | 220.89 | 34955.0 |
| 2025-01-27 05:00:00 | AAPL | Stock | 220.88 | 220.99 | 220.21 | 220.79 | 76709.0 |
| 2025-01-27 05:30:00 | AAPL | Stock | 220.79 | 221.84 | 220.08 | 221.51 | 96739.0 |
| 2025-01-27 06:00:00 | AAPL | Stock | 221.51 | 222.59 | 220.45 | 222.12 | 112506.0 |
| 2025-01-27 06:30:00 | AAPL | Stock | 222.13 | 223.0 | 221.73 | 221.8 | 131857.0 |
| 2025-01-27 07:00:00 | AAPL | Stock | 221.81 | 221.92 | 220.88 | 221.55 | 102567.0 |
| 2025-01-27 07:30:00 | AAPL | Stock | 221.48 | 222.06 | 220.77 | 222.04 | 222024.0 |
| 2025-01-27 08:00:00 | AAPL | Stock | 221.26 | 223.62 | 218.06 | 223.007 | 519995.0 |
| 2025-01-27 08:30:00 | AAPL | Stock | 223.02 | 223.26 | 222.0 | 223.26 | 267082.0 |
| 2025-01-27 09:00:00 | AAPL | Stock | 223.21 | 224.24 | 222.01 | 224.12 | 497215.0 |
| 2025-01-27 09:30:00 | AAPL | Stock | 224.02 | 227.7 | 223.98 | 225.66 | 11469105.0 |
| 2025-01-27 10:00:00 | AAPL | Stock | 225.65 | 227.2923 | 224.82 | 227.2923 | 3681868.0 |
| 2025-01-27 10:30:00 | AAPL | Stock | 227.3 | 228.5876 | 227.09 | 227.79 | 4168390.0 |
| 2025-01-27 11:00:00 | AAPL | Stock | 227.76 | 228.83 | 227.51 | 228.4938 | 3207107.0 |
| 2025-01-27 11:30:00 | AAPL | Stock | 228.485 | 229.78 | 228.18 | 228.445 | 4142201.0 |
| 2025-01-27 12:00:00 | AAPL | Stock | 228.4661 | 230.14 | 228.29 | 230.09 | 2406683.0 |
| 2025-01-27 12:30:00 | AAPL | Stock | 230.09 | 230.48 | 229.8105 | 230.15 | 2583778.0 |
| 2025-01-27 13:00:00 | AAPL | Stock | 230.18 | 231.38 | 230.07 | 231.32 | 2519098.0 |
| 2025-01-27 13:30:00 | AAPL | Stock | 231.3 | 231.79 | 231.01 | 231.435 | 2512794.0 |
| 2025-01-27 14:00:00 | AAPL | Stock | 231.431 | 232.15 | 230.99 | 232.03 | 2355833.0 |
| 2025-01-27 14:30:00 | AAPL | Stock | 232.03 | 232.03 | 230.14 | 231.58 | 2515359.0 |
| 2025-01-27 15:00:00 | AAPL | Stock | 231.57 | 231.91 | 230.18 | 230.68 | 4617605.0 |
| 2025-01-27 15:30:00 | AAPL | Stock | 230.68 | 231.38 | 228.48 | 229.94 | 8483798.0 |
| 2025-01-27 16:00:00 | AAPL | Stock | 229.86 | 231.0 | 229.1 | 230.19 | 14715601.0 |
| 2025-01-27 16:30:00 | AAPL | Stock | 230.198 | 230.49 | 229.86 | 230.04 | 66462.0 |
| 2025-01-27 17:00:00 | AAPL | Stock | 230.08 | 230.08 | 229.4 | 229.7 | 28126.0 |
| 2025-01-27 17:30:00 | AAPL | Stock | 229.7005 | 229.8393 | 229.03 | 229.8 | 26386.0 |
| 2025-01-27 18:00:00 | AAPL | Stock | 229.8 | 230.0 | 228.66 | 228.66 | 39645.0 |
| 2025-01-27 18:30:00 | AAPL | Stock | 228.895 | 229.784 | 228.6075 | 229.7745 | 12800.0 |
| 2025-01-27 19:00:00 | AAPL | Stock | 229.77 | 229.78 | 229.4 | 229.5 | 7851.0 |
| 2025-01-27 19:30:00 | AAPL | Stock | 229.33 | 229.79 | 229.02 | 229.79 | 6796.0 |
| 2025-01-27 04:00:00 | MSFT | Stock | 427.57 | 435.65 | 427.25 | 427.88 | 76487.0 |
| 2025-01-27 04:30:00 | MSFT | Stock | 427.55 | 427.55 | 423.46 | 423.51 | 111281.0 |
| 2025-01-27 05:00:00 | MSFT | Stock | 423.24 | 423.24 | 416.08 | 417.93 | 161539.0 |
| 2025-01-27 05:30:00 | MSFT | Stock | 417.3 | 418.0 | 412.98 | 415.0 | 91453.0 |
| 2025-01-27 06:00:00 | MSFT | Stock | 414.77 | 418.0 | 410.05 | 416.0 | 226764.0 |
| 2025-01-27 06:30:00 | MSFT | Stock | 415.75 | 418.84 | 415.5 | 416.66 | 87550.0 |
| 2025-01-27 07:00:00 | MSFT | Stock | 416.81 | 419.0 | 416.1 | 417.76 | 179297.0 |
| 2025-01-27 07:30:00 | MSFT | Stock | 417.75 | 423.0 | 417.73 | 422.56 | 158947.0 |
| 2025-01-27 08:00:00 | MSFT | Stock | 417.75 | 435.0 | 416.06 | 427.22 | 252198.0 |
| 2025-01-27 08:30:00 | MSFT | Stock | 427.0172 | 427.6072 | 422.5 | 426.79 | 132423.0 |
| 2025-01-27 09:00:00 | MSFT | Stock | 426.22 | 426.8877 | 422.25 | 424.0 | 291842.0 |
| 2025-01-27 09:30:00 | MSFT | Stock | 424.0 | 429.98 | 423.5 | 429.83 | 4925085.0 |
| 2025-01-27 10:00:00 | MSFT | Stock | 429.82 | 431.21 | 426.7 | 431.15 | 1644528.0 |
| 2025-01-27 10:30:00 | MSFT | Stock | 431.15 | 433.96 | 429.05 | 429.406 | 1354622.0 |
| 2025-01-27 11:00:00 | MSFT | Stock | 429.365 | 429.79 | 426.59 | 427.4 | 1001505.0 |
| 2025-01-27 11:30:00 | MSFT | Stock | 427.27 | 428.48 | 426.66 | 427.4633 | 984621.0 |
| 2025-01-27 12:00:00 | MSFT | Stock | 427.4413 | 428.05 | 426.25 | 427.38 | 525384.0 |
| 2025-01-27 12:30:00 | MSFT | Stock | 427.38 | 428.0989 | 426.75 | 427.94 | 515069.0 |
> showing 50 of 113,174 rows — these rows as CSV