PREVIEW / stock_30min / 2025-04-23
file: by_date/stock_30min/2025/2025-04-23.parquet size: 2.2 MB rows: 106,058 symbols: 428
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-04-23 04:00:00 | AAPL | Stock | 205.0 | 205.35 | 204.0 | 204.61 | 30779.0 |
| 2025-04-23 04:30:00 | AAPL | Stock | 204.91 | 205.77 | 204.91 | 205.37 | 24242.0 |
| 2025-04-23 05:00:00 | AAPL | Stock | 205.44 | 205.72 | 205.3 | 205.31 | 17609.0 |
| 2025-04-23 05:30:00 | AAPL | Stock | 205.28 | 205.5 | 204.7 | 205.15 | 21714.0 |
| 2025-04-23 06:00:00 | AAPL | Stock | 205.18 | 205.67 | 205.18 | 205.56 | 19361.0 |
| 2025-04-23 06:30:00 | AAPL | Stock | 205.6 | 206.45 | 205.59 | 206.26 | 44981.0 |
| 2025-04-23 07:00:00 | AAPL | Stock | 206.3 | 206.65 | 205.74 | 205.91 | 47213.0 |
| 2025-04-23 07:30:00 | AAPL | Stock | 205.98 | 206.13 | 205.5 | 205.77 | 38770.0 |
| 2025-04-23 08:00:00 | AAPL | Stock | 206.36 | 206.72 | 204.22 | 206.0999 | 192423.0 |
| 2025-04-23 08:30:00 | AAPL | Stock | 206.0005 | 207.0 | 206.0005 | 206.8042 | 86678.0 |
| 2025-04-23 09:00:00 | AAPL | Stock | 206.95 | 207.1 | 206.0 | 206.0 | 227206.0 |
| 2025-04-23 09:30:00 | AAPL | Stock | 205.99 | 207.63 | 204.6301 | 207.38 | 7916326.0 |
| 2025-04-23 10:00:00 | AAPL | Stock | 207.3234 | 208.0 | 205.62 | 206.8162 | 2605403.0 |
| 2025-04-23 10:30:00 | AAPL | Stock | 206.81 | 207.95 | 206.66 | 206.9 | 2152082.0 |
| 2025-04-23 11:00:00 | AAPL | Stock | 206.93 | 207.57 | 204.06 | 204.63 | 2938216.0 |
| 2025-04-23 11:30:00 | AAPL | Stock | 204.625 | 205.42 | 203.6501 | 204.27 | 2061328.0 |
| 2025-04-23 12:00:00 | AAPL | Stock | 204.27 | 204.36 | 202.799 | 204.11 | 1580193.0 |
| 2025-04-23 12:30:00 | AAPL | Stock | 204.125 | 204.955 | 203.5184 | 204.76 | 1176292.0 |
| 2025-04-23 13:00:00 | AAPL | Stock | 204.75 | 205.45 | 203.83 | 204.94 | 1193858.0 |
| 2025-04-23 13:30:00 | AAPL | Stock | 204.99 | 205.65 | 204.2118 | 205.3901 | 1071574.0 |
| 2025-04-23 14:00:00 | AAPL | Stock | 205.39 | 205.54 | 204.25 | 204.4824 | 1186360.0 |
| 2025-04-23 14:30:00 | AAPL | Stock | 204.47 | 205.1 | 204.24 | 204.74 | 1006868.0 |
| 2025-04-23 15:00:00 | AAPL | Stock | 204.72 | 205.17 | 203.6567 | 204.01 | 1590622.0 |
| 2025-04-23 15:30:00 | AAPL | Stock | 204.0309 | 205.75 | 203.61 | 204.36 | 4079849.0 |
| 2025-04-23 16:00:00 | AAPL | Stock | 204.32 | 205.7299 | 203.9 | 205.2 | 6924755.0 |
| 2025-04-23 16:30:00 | AAPL | Stock | 205.2 | 205.5 | 204.2196 | 204.5 | 66021.0 |
| 2025-04-23 17:00:00 | AAPL | Stock | 204.351 | 204.75 | 204.2552 | 204.2552 | 16532.0 |
| 2025-04-23 17:30:00 | AAPL | Stock | 204.2512 | 204.3421 | 204.0 | 204.0001 | 12583.0 |
| 2025-04-23 18:00:00 | AAPL | Stock | 204.0 | 204.0 | 203.33 | 203.61 | 13746.0 |
| 2025-04-23 18:30:00 | AAPL | Stock | 203.6147 | 204.0 | 203.61 | 203.808 | 18793.0 |
| 2025-04-23 19:00:00 | AAPL | Stock | 203.94 | 204.3998 | 203.8 | 204.09 | 17697.0 |
| 2025-04-23 19:30:00 | AAPL | Stock | 204.37 | 204.46 | 203.79 | 204.4594 | 10833.0 |
| 2025-04-23 04:00:00 | MSFT | Stock | 373.01 | 374.64 | 372.82 | 373.7 | 10759.0 |
| 2025-04-23 04:30:00 | MSFT | Stock | 373.8 | 375.01 | 373.79 | 374.5 | 5688.0 |
| 2025-04-23 05:00:00 | MSFT | Stock | 374.51 | 375.65 | 374.48 | 375.0 | 5616.0 |
| 2025-04-23 05:30:00 | MSFT | Stock | 374.85 | 376.31 | 374.85 | 376.15 | 5751.0 |
| 2025-04-23 06:00:00 | MSFT | Stock | 376.0 | 376.68 | 376.0 | 376.62 | 4056.0 |
| 2025-04-23 06:30:00 | MSFT | Stock | 376.34 | 376.83 | 376.21 | 376.8 | 4818.0 |
| 2025-04-23 07:00:00 | MSFT | Stock | 376.53 | 377.2 | 376.5 | 376.8 | 20671.0 |
| 2025-04-23 07:30:00 | MSFT | Stock | 376.8 | 377.01 | 375.33 | 375.42 | 13045.0 |
| 2025-04-23 08:00:00 | MSFT | Stock | 376.9 | 377.37 | 371.5 | 375.95 | 35854.0 |
| 2025-04-23 08:30:00 | MSFT | Stock | 376.06 | 376.9526 | 375.6503 | 376.72 | 17383.0 |
| 2025-04-23 09:00:00 | MSFT | Stock | 376.59 | 377.25 | 374.72 | 375.65 | 19483.0 |
| 2025-04-23 09:30:00 | MSFT | Stock | 375.92 | 379.98 | 375.26 | 379.05 | 2293732.0 |
| 2025-04-23 10:00:00 | MSFT | Stock | 379.23 | 379.9 | 376.81 | 378.92 | 818916.0 |
| 2025-04-23 10:30:00 | MSFT | Stock | 378.82 | 380.39 | 378.81 | 379.36 | 658775.0 |
| 2025-04-23 11:00:00 | MSFT | Stock | 379.37 | 380.14 | 376.0 | 376.84 | 752257.0 |
| 2025-04-23 11:30:00 | MSFT | Stock | 376.84 | 377.2 | 374.41 | 376.1052 | 536521.0 |
| 2025-04-23 12:00:00 | MSFT | Stock | 375.97 | 376.12 | 373.2 | 375.08 | 357043.0 |
| 2025-04-23 12:30:00 | MSFT | Stock | 375.11 | 377.27 | 374.72 | 376.86 | 445963.0 |
> showing 50 of 106,058 rows — these rows as CSV