PREVIEW / stock_30min / 2025-08-08
file: by_date/stock_30min/2025/2025-08-08.parquet size: 2.2 MB rows: 105,127 symbols: 352
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-08-08 04:00:00 | AAPL | Stock | 221.38 | 221.5 | 221.12 | 221.29 | 19516.0 |
| 2025-08-08 04:30:00 | AAPL | Stock | 221.26 | 221.26 | 220.94 | 220.96 | 15071.0 |
| 2025-08-08 05:00:00 | AAPL | Stock | 220.9 | 221.17 | 220.8 | 220.94 | 8633.0 |
| 2025-08-08 05:30:00 | AAPL | Stock | 220.99 | 221.12 | 220.9 | 221.0 | 5038.0 |
| 2025-08-08 06:00:00 | AAPL | Stock | 221.05 | 221.05 | 220.89 | 220.95 | 1949.0 |
| 2025-08-08 06:30:00 | AAPL | Stock | 220.99 | 221.0 | 220.92 | 220.99 | 4938.0 |
| 2025-08-08 07:00:00 | AAPL | Stock | 220.99 | 221.45 | 220.98 | 221.45 | 43772.0 |
| 2025-08-08 07:30:00 | AAPL | Stock | 221.4 | 221.47 | 221.3 | 221.36 | 11859.0 |
| 2025-08-08 08:00:00 | AAPL | Stock | 221.16 | 221.89 | 220.8 | 221.0 | 236071.0 |
| 2025-08-08 08:30:00 | AAPL | Stock | 221.01 | 221.1999 | 220.89 | 221.02 | 30237.0 |
| 2025-08-08 09:00:00 | AAPL | Stock | 221.02 | 221.15 | 220.28 | 220.9 | 90528.0 |
| 2025-08-08 09:30:00 | AAPL | Stock | 220.86 | 222.2998 | 219.25 | 222.175 | 6613621.0 |
| 2025-08-08 10:00:00 | AAPL | Stock | 222.19 | 223.1 | 221.82 | 222.7817 | 5641024.0 |
| 2025-08-08 10:30:00 | AAPL | Stock | 222.78 | 223.57 | 222.63 | 222.955 | 4408416.0 |
| 2025-08-08 11:00:00 | AAPL | Stock | 222.94 | 224.6348 | 222.9 | 224.36 | 4002748.0 |
| 2025-08-08 11:30:00 | AAPL | Stock | 224.355 | 226.3299 | 224.31 | 225.99 | 6683036.0 |
| 2025-08-08 12:00:00 | AAPL | Stock | 226.0006 | 228.23 | 225.89 | 228.2 | 7445623.0 |
| 2025-08-08 12:30:00 | AAPL | Stock | 228.2098 | 230.56 | 227.94 | 229.79 | 14181353.0 |
| 2025-08-08 13:00:00 | AAPL | Stock | 229.7846 | 230.93 | 228.66 | 228.675 | 7640285.0 |
| 2025-08-08 13:30:00 | AAPL | Stock | 228.67 | 230.5 | 228.55 | 230.25 | 5437353.0 |
| 2025-08-08 14:00:00 | AAPL | Stock | 230.245 | 231.0 | 229.17 | 229.29 | 4763592.0 |
| 2025-08-08 14:30:00 | AAPL | Stock | 229.2916 | 229.8799 | 229.07 | 229.11 | 3272093.0 |
| 2025-08-08 15:00:00 | AAPL | Stock | 229.12 | 229.62 | 228.51 | 228.81 | 4545645.0 |
| 2025-08-08 15:30:00 | AAPL | Stock | 228.82 | 229.69 | 228.46 | 229.365 | 7688667.0 |
| 2025-08-08 16:00:00 | AAPL | Stock | 229.35 | 229.9 | 229.2302 | 229.64 | 6428766.0 |
| 2025-08-08 16:30:00 | AAPL | Stock | 229.64 | 229.99 | 229.35 | 229.98 | 76885.0 |
| 2025-08-08 17:00:00 | AAPL | Stock | 229.99 | 230.07 | 229.85 | 229.9 | 94876.0 |
| 2025-08-08 17:30:00 | AAPL | Stock | 229.95 | 230.0 | 229.85 | 229.9 | 20579.0 |
| 2025-08-08 18:00:00 | AAPL | Stock | 229.9 | 229.94 | 229.724 | 229.76 | 28092.0 |
| 2025-08-08 18:30:00 | AAPL | Stock | 229.76 | 229.8185 | 229.55 | 229.7303 | 25654.0 |
| 2025-08-08 19:00:00 | AAPL | Stock | 229.67 | 229.7 | 229.5799 | 229.67 | 18267.0 |
| 2025-08-08 19:30:00 | AAPL | Stock | 229.66 | 230.0 | 229.66 | 229.9578 | 57676.0 |
| 2025-08-08 04:00:00 | MSFT | Stock | 522.78 | 522.78 | 521.3 | 521.3 | 3496.0 |
| 2025-08-08 04:30:00 | MSFT | Stock | 521.03 | 521.59 | 521.02 | 521.5 | 931.0 |
| 2025-08-08 05:00:00 | MSFT | Stock | 521.6 | 522.59 | 521.6 | 522.59 | 1984.0 |
| 2025-08-08 05:30:00 | MSFT | Stock | 522.57 | 522.57 | 522.42 | 522.54 | 517.0 |
| 2025-08-08 06:00:00 | MSFT | Stock | 522.5 | 522.56 | 522.5 | 522.5 | 500.0 |
| 2025-08-08 06:30:00 | MSFT | Stock | 522.5 | 522.58 | 522.5 | 522.58 | 400.0 |
| 2025-08-08 07:00:00 | MSFT | Stock | 522.5 | 522.5 | 522.4 | 522.45 | 2197.0 |
| 2025-08-08 07:30:00 | MSFT | Stock | 522.46 | 522.61 | 522.2 | 522.2 | 1227.0 |
| 2025-08-08 08:00:00 | MSFT | Stock | 522.92 | 522.92 | 520.04 | 520.34 | 26166.0 |
| 2025-08-08 08:30:00 | MSFT | Stock | 520.0572 | 521.0 | 520.0572 | 520.65 | 11431.0 |
| 2025-08-08 09:00:00 | MSFT | Stock | 520.85 | 522.2821 | 520.8 | 522.25 | 13992.0 |
| 2025-08-08 09:30:00 | MSFT | Stock | 522.25 | 524.66 | 522.25 | 523.245 | 1114827.0 |
| 2025-08-08 10:00:00 | MSFT | Stock | 523.195 | 523.5 | 522.12 | 522.955 | 675521.0 |
| 2025-08-08 10:30:00 | MSFT | Stock | 522.955 | 523.08 | 520.8 | 520.9092 | 525206.0 |
| 2025-08-08 11:00:00 | MSFT | Stock | 520.9 | 521.82 | 520.69 | 521.33 | 798454.0 |
| 2025-08-08 11:30:00 | MSFT | Stock | 521.31 | 521.3614 | 519.41 | 521.31 | 480697.0 |
| 2025-08-08 12:00:00 | MSFT | Stock | 521.29 | 521.69 | 521.0 | 521.08 | 360068.0 |
| 2025-08-08 12:30:00 | MSFT | Stock | 521.0636 | 521.89 | 520.94 | 521.63 | 265004.0 |
> showing 50 of 105,127 rows — these rows as CSV