PREVIEW / stock_30min / 2025-03-11
file: by_date/stock_30min/2025/2025-03-11.parquet size: 2.2 MB rows: 104,177 symbols: 488
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-03-11 04:00:00 | AAPL | Stock | 225.84 | 228.21 | 225.84 | 227.97 | 47724.0 |
| 2025-03-11 04:30:00 | AAPL | Stock | 227.8 | 227.8 | 227.11 | 227.3 | 7279.0 |
| 2025-03-11 05:00:00 | AAPL | Stock | 227.27 | 227.45 | 226.8 | 227.34 | 19859.0 |
| 2025-03-11 05:30:00 | AAPL | Stock | 227.32 | 227.32 | 226.9 | 227.16 | 11309.0 |
| 2025-03-11 06:00:00 | AAPL | Stock | 227.16 | 227.17 | 226.86 | 226.9 | 15327.0 |
| 2025-03-11 06:30:00 | AAPL | Stock | 226.87 | 226.89 | 226.48 | 226.67 | 8351.0 |
| 2025-03-11 07:00:00 | AAPL | Stock | 226.65 | 226.8 | 226.33 | 226.7 | 14786.0 |
| 2025-03-11 07:30:00 | AAPL | Stock | 226.64 | 226.94 | 226.45 | 226.63 | 6089.0 |
| 2025-03-11 08:00:00 | AAPL | Stock | 226.33 | 227.7843 | 225.87 | 226.35 | 79054.0 |
| 2025-03-11 08:30:00 | AAPL | Stock | 226.25 | 226.34 | 225.4 | 225.49 | 49044.0 |
| 2025-03-11 09:00:00 | AAPL | Stock | 227.48 | 227.48 | 222.75 | 223.85 | 222747.0 |
| 2025-03-11 09:30:00 | AAPL | Stock | 223.82 | 225.8399 | 221.76 | 222.0524 | 7470461.0 |
| 2025-03-11 10:00:00 | AAPL | Stock | 222.02 | 223.5 | 220.01 | 222.52 | 5273349.0 |
| 2025-03-11 10:30:00 | AAPL | Stock | 222.47 | 222.95 | 220.8903 | 221.055 | 3059847.0 |
| 2025-03-11 11:00:00 | AAPL | Stock | 221.055 | 222.14 | 220.59 | 221.0032 | 2992237.0 |
| 2025-03-11 11:30:00 | AAPL | Stock | 220.98 | 221.74 | 220.26 | 221.1398 | 2196007.0 |
| 2025-03-11 12:00:00 | AAPL | Stock | 221.1 | 221.11 | 218.5 | 218.55 | 4224406.0 |
| 2025-03-11 12:30:00 | AAPL | Stock | 218.54 | 219.88 | 218.44 | 219.0 | 2665841.0 |
| 2025-03-11 13:00:00 | AAPL | Stock | 218.97 | 219.06 | 217.45 | 217.73 | 2864734.0 |
| 2025-03-11 13:30:00 | AAPL | Stock | 217.73 | 219.53 | 217.68 | 218.29 | 2439508.0 |
| 2025-03-11 14:00:00 | AAPL | Stock | 218.3 | 220.98 | 218.26 | 220.545 | 2467797.0 |
| 2025-03-11 14:30:00 | AAPL | Stock | 220.55 | 222.7 | 220.09 | 222.165 | 2662646.0 |
| 2025-03-11 15:00:00 | AAPL | Stock | 222.18 | 223.31 | 221.37 | 221.8 | 2395243.0 |
| 2025-03-11 15:30:00 | AAPL | Stock | 221.82 | 222.07 | 220.58 | 220.73 | 4675401.0 |
| 2025-03-11 16:00:00 | AAPL | Stock | 220.73 | 220.86 | 220.5 | 220.86 | 8157934.0 |
| 2025-03-11 16:30:00 | AAPL | Stock | 220.8489 | 220.8489 | 220.2119 | 220.27 | 214998.0 |
| 2025-03-11 17:00:00 | AAPL | Stock | 220.39 | 220.61 | 220.3033 | 220.53 | 11646.0 |
| 2025-03-11 17:30:00 | AAPL | Stock | 220.5299 | 220.64 | 220.2669 | 220.3426 | 12075.0 |
| 2025-03-11 18:00:00 | AAPL | Stock | 220.56 | 221.244 | 220.38 | 220.7009 | 12672.0 |
| 2025-03-11 18:30:00 | AAPL | Stock | 220.7171 | 221.21 | 220.7 | 221.2 | 7590.0 |
| 2025-03-11 19:00:00 | AAPL | Stock | 221.21 | 221.21 | 220.5 | 220.51 | 13371.0 |
| 2025-03-11 19:30:00 | AAPL | Stock | 220.51 | 221.0699 | 220.51 | 221.0623 | 7046.0 |
| 2025-03-11 04:00:00 | MSFT | Stock | 378.56 | 381.0 | 377.99 | 381.0 | 10366.0 |
| 2025-03-11 04:30:00 | MSFT | Stock | 381.01 | 381.3 | 380.5 | 380.74 | 3845.0 |
| 2025-03-11 05:00:00 | MSFT | Stock | 380.8 | 381.39 | 380.49 | 380.89 | 11703.0 |
| 2025-03-11 05:30:00 | MSFT | Stock | 380.66 | 380.95 | 380.14 | 380.25 | 4682.0 |
| 2025-03-11 06:00:00 | MSFT | Stock | 380.08 | 381.01 | 379.78 | 380.61 | 6853.0 |
| 2025-03-11 06:30:00 | MSFT | Stock | 380.95 | 381.04 | 380.67 | 380.67 | 2402.0 |
| 2025-03-11 07:00:00 | MSFT | Stock | 380.86 | 380.86 | 379.82 | 380.41 | 3631.0 |
| 2025-03-11 07:30:00 | MSFT | Stock | 380.35 | 381.47 | 380.35 | 381.26 | 9188.0 |
| 2025-03-11 08:00:00 | MSFT | Stock | 380.25 | 381.48 | 377.1 | 380.79 | 29940.0 |
| 2025-03-11 08:30:00 | MSFT | Stock | 380.35 | 380.5 | 379.6 | 379.8 | 8889.0 |
| 2025-03-11 09:00:00 | MSFT | Stock | 380.16 | 380.2 | 377.5 | 379.0 | 52282.0 |
| 2025-03-11 09:30:00 | MSFT | Stock | 378.91 | 382.66 | 378.6505 | 381.51 | 2068114.0 |
| 2025-03-11 10:00:00 | MSFT | Stock | 381.5 | 383.89 | 380.2118 | 383.0 | 1771453.0 |
| 2025-03-11 10:30:00 | MSFT | Stock | 382.96 | 384.42 | 381.6801 | 382.13 | 1318098.0 |
| 2025-03-11 11:00:00 | MSFT | Stock | 382.1 | 386.0 | 381.76 | 382.9408 | 954676.0 |
| 2025-03-11 11:30:00 | MSFT | Stock | 382.95 | 383.8989 | 381.785 | 382.0 | 660154.0 |
| 2025-03-11 12:00:00 | MSFT | Stock | 381.94 | 381.94 | 379.5646 | 381.175 | 680138.0 |
| 2025-03-11 12:30:00 | MSFT | Stock | 381.27 | 381.79 | 378.78 | 379.4271 | 453251.0 |
> showing 50 of 104,177 rows — these rows as CSV