PREVIEW / stock_30min / 2025-01-24
file: by_date/stock_30min/2025/2025-01-24.parquet size: 2.2 MB rows: 106,961 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-24 04:00:00 | AAPL | Stock | 223.2 | 223.6 | 223.12 | 223.6 | 9760.0 |
| 2025-01-24 04:30:00 | AAPL | Stock | 223.62 | 224.32 | 223.43 | 223.72 | 21284.0 |
| 2025-01-24 05:00:00 | AAPL | Stock | 223.65 | 223.99 | 223.65 | 223.83 | 5656.0 |
| 2025-01-24 05:30:00 | AAPL | Stock | 223.81 | 224.06 | 223.71 | 224.06 | 7583.0 |
| 2025-01-24 06:00:00 | AAPL | Stock | 224.18 | 224.2 | 224.01 | 224.05 | 6221.0 |
| 2025-01-24 06:30:00 | AAPL | Stock | 224.07 | 225.5 | 224.06 | 225.25 | 80370.0 |
| 2025-01-24 07:00:00 | AAPL | Stock | 225.15 | 225.42 | 224.66 | 225.29 | 81195.0 |
| 2025-01-24 07:30:00 | AAPL | Stock | 225.29 | 225.29 | 224.86 | 225.09 | 49870.0 |
| 2025-01-24 08:00:00 | AAPL | Stock | 225.125 | 225.5482 | 223.25 | 225.5 | 231563.0 |
| 2025-01-24 08:30:00 | AAPL | Stock | 225.5199 | 225.846 | 225.41 | 225.76 | 101548.0 |
| 2025-01-24 09:00:00 | AAPL | Stock | 225.76 | 226.29 | 224.56 | 224.78 | 559491.0 |
| 2025-01-24 09:30:00 | AAPL | Stock | 224.78 | 225.63 | 224.31 | 224.51 | 6237211.0 |
| 2025-01-24 10:00:00 | AAPL | Stock | 224.525 | 224.59 | 222.5301 | 222.73 | 4219361.0 |
| 2025-01-24 10:30:00 | AAPL | Stock | 222.735 | 223.37 | 222.66 | 223.065 | 2268349.0 |
| 2025-01-24 11:00:00 | AAPL | Stock | 223.065 | 223.1 | 222.3501 | 222.76 | 2473806.0 |
| 2025-01-24 11:30:00 | AAPL | Stock | 222.765 | 223.49 | 222.6 | 222.73 | 2182733.0 |
| 2025-01-24 12:00:00 | AAPL | Stock | 222.7399 | 223.27 | 222.14 | 222.28 | 1629583.0 |
| 2025-01-24 12:30:00 | AAPL | Stock | 222.28 | 222.7245 | 221.94 | 222.4 | 1721620.0 |
| 2025-01-24 13:00:00 | AAPL | Stock | 222.4099 | 222.56 | 222.0201 | 222.16 | 1082157.0 |
| 2025-01-24 13:30:00 | AAPL | Stock | 222.14 | 222.55 | 221.92 | 222.05 | 1134474.0 |
| 2025-01-24 14:00:00 | AAPL | Stock | 222.06 | 222.4 | 222.02 | 222.365 | 1068329.0 |
| 2025-01-24 14:30:00 | AAPL | Stock | 222.35 | 222.88 | 222.32 | 222.56 | 1475018.0 |
| 2025-01-24 15:00:00 | AAPL | Stock | 222.5517 | 222.93 | 221.41 | 222.32 | 2265257.0 |
| 2025-01-24 15:30:00 | AAPL | Stock | 222.315 | 223.045 | 222.2 | 222.79 | 4223510.0 |
| 2025-01-24 16:00:00 | AAPL | Stock | 222.79 | 222.9 | 222.47 | 222.65 | 8842112.0 |
| 2025-01-24 16:30:00 | AAPL | Stock | 222.6602 | 222.85 | 222.5122 | 222.56 | 64026.0 |
| 2025-01-24 17:00:00 | AAPL | Stock | 222.56 | 222.56 | 222.45 | 222.4899 | 18027.0 |
| 2025-01-24 17:30:00 | AAPL | Stock | 222.49 | 222.5 | 222.3 | 222.47 | 13948.0 |
| 2025-01-24 18:00:00 | AAPL | Stock | 222.35 | 222.45 | 222.31 | 222.31 | 5753.0 |
| 2025-01-24 18:30:00 | AAPL | Stock | 222.35 | 222.3599 | 222.0 | 222.15 | 24767.0 |
| 2025-01-24 19:00:00 | AAPL | Stock | 222.2 | 222.34 | 222.1263 | 222.2142 | 10800.0 |
| 2025-01-24 19:30:00 | AAPL | Stock | 222.3 | 222.3399 | 222.03 | 222.17 | 17841.0 |
| 2025-01-24 04:00:00 | MSFT | Stock | 445.8 | 446.76 | 445.8 | 446.51 | 4124.0 |
| 2025-01-24 04:30:00 | MSFT | Stock | 446.7 | 446.71 | 446.2 | 446.21 | 500.0 |
| 2025-01-24 05:00:00 | MSFT | Stock | 446.28 | 446.28 | 446.06 | 446.18 | 407.0 |
| 2025-01-24 05:30:00 | MSFT | Stock | 446.14 | 446.14 | 446.14 | 446.14 | 100.0 |
| 2025-01-24 06:00:00 | MSFT | Stock | 446.31 | 446.31 | 446.31 | 446.31 | 100.0 |
| 2025-01-24 06:30:00 | MSFT | Stock | 446.3 | 446.3 | 445.0 | 445.34 | 8900.0 |
| 2025-01-24 07:00:00 | MSFT | Stock | 445.7 | 447.0 | 445.7 | 447.0 | 6409.0 |
| 2025-01-24 07:30:00 | MSFT | Stock | 447.1 | 447.14 | 446.74 | 446.8 | 1395.0 |
| 2025-01-24 08:00:00 | MSFT | Stock | 446.54 | 447.0 | 445.7 | 445.95 | 15999.0 |
| 2025-01-24 08:30:00 | MSFT | Stock | 445.89 | 446.68 | 445.53 | 446.58 | 9208.0 |
| 2025-01-24 09:00:00 | MSFT | Stock | 446.58 | 446.71 | 444.3 | 445.16 | 28403.0 |
| 2025-01-24 09:30:00 | MSFT | Stock | 445.35 | 445.9356 | 441.4 | 444.655 | 1605279.0 |
| 2025-01-24 10:00:00 | MSFT | Stock | 444.69 | 445.29 | 443.38 | 443.7318 | 684023.0 |
| 2025-01-24 10:30:00 | MSFT | Stock | 443.7 | 445.49 | 443.66 | 445.1211 | 451458.0 |
| 2025-01-24 11:00:00 | MSFT | Stock | 445.055 | 446.3218 | 444.632 | 446.295 | 342802.0 |
| 2025-01-24 11:30:00 | MSFT | Stock | 446.295 | 446.65 | 445.642 | 445.83 | 323002.0 |
| 2025-01-24 12:00:00 | MSFT | Stock | 445.81 | 445.93 | 444.48 | 444.82 | 457492.0 |
| 2025-01-24 12:30:00 | MSFT | Stock | 444.8532 | 445.12 | 444.06 | 444.22 | 245935.0 |
> showing 50 of 106,961 rows — these rows as CSV