PREVIEW / stock_30min / 2025-08-06
file: by_date/stock_30min/2025/2025-08-06.parquet size: 2.2 MB rows: 106,293 symbols: 353
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-06 04:00:00 | AAPL | Stock | 203.33 | 203.88 | 203.33 | 203.82 | 8616.0 |
| 2025-08-06 04:30:00 | AAPL | Stock | 203.82 | 203.91 | 203.7 | 203.81 | 9165.0 |
| 2025-08-06 05:00:00 | AAPL | Stock | 203.84 | 203.95 | 203.83 | 203.86 | 3671.0 |
| 2025-08-06 05:30:00 | AAPL | Stock | 203.7 | 203.8 | 203.69 | 203.69 | 1421.0 |
| 2025-08-06 06:00:00 | AAPL | Stock | 203.75 | 203.81 | 203.63 | 203.72 | 3289.0 |
| 2025-08-06 06:30:00 | AAPL | Stock | 203.74 | 203.98 | 203.61 | 203.98 | 2733.0 |
| 2025-08-06 07:00:00 | AAPL | Stock | 203.92 | 203.98 | 203.8 | 203.86 | 15649.0 |
| 2025-08-06 07:30:00 | AAPL | Stock | 203.93 | 203.99 | 203.73 | 203.73 | 6234.0 |
| 2025-08-06 08:00:00 | AAPL | Stock | 203.88 | 206.0 | 203.35 | 205.35 | 323286.0 |
| 2025-08-06 08:30:00 | AAPL | Stock | 205.39 | 206.91 | 205.32 | 206.46 | 524688.0 |
| 2025-08-06 09:00:00 | AAPL | Stock | 206.4701 | 206.63 | 205.5003 | 205.6 | 417040.0 |
| 2025-08-06 09:30:00 | AAPL | Stock | 205.63 | 210.32 | 205.59 | 209.545 | 11734739.0 |
| 2025-08-06 10:00:00 | AAPL | Stock | 209.545 | 211.15 | 209.5 | 210.747 | 6346148.0 |
| 2025-08-06 10:30:00 | AAPL | Stock | 210.76 | 212.27 | 210.63 | 211.075 | 5755500.0 |
| 2025-08-06 11:00:00 | AAPL | Stock | 211.08 | 214.34 | 210.66 | 214.225 | 7175860.0 |
| 2025-08-06 11:30:00 | AAPL | Stock | 214.225 | 214.9 | 213.67 | 214.63 | 7111366.0 |
| 2025-08-06 12:00:00 | AAPL | Stock | 214.635 | 214.99 | 214.18 | 214.5 | 5604702.0 |
| 2025-08-06 12:30:00 | AAPL | Stock | 214.5197 | 214.75 | 213.869 | 214.485 | 3240162.0 |
| 2025-08-06 13:00:00 | AAPL | Stock | 214.485 | 214.8899 | 214.04 | 214.54 | 2659984.0 |
| 2025-08-06 13:30:00 | AAPL | Stock | 214.515 | 215.38 | 214.09 | 214.385 | 4069412.0 |
| 2025-08-06 14:00:00 | AAPL | Stock | 214.38 | 214.93 | 214.13 | 214.6025 | 2679804.0 |
| 2025-08-06 14:30:00 | AAPL | Stock | 214.61 | 214.795 | 214.38 | 214.3999 | 2283186.0 |
| 2025-08-06 15:00:00 | AAPL | Stock | 214.395 | 214.55 | 213.75 | 213.88 | 3521523.0 |
| 2025-08-06 15:30:00 | AAPL | Stock | 213.885 | 214.42 | 212.81 | 213.25 | 7354524.0 |
| 2025-08-06 16:00:00 | AAPL | Stock | 213.264 | 213.38 | 212.81 | 212.81 | 10143020.0 |
| 2025-08-06 16:30:00 | AAPL | Stock | 212.865 | 213.25 | 211.32 | 211.5999 | 517375.0 |
| 2025-08-06 17:00:00 | AAPL | Stock | 211.57 | 213.23 | 211.4501 | 211.819 | 473102.0 |
| 2025-08-06 17:30:00 | AAPL | Stock | 211.8 | 220.7 | 211.7 | 220.7 | 1510184.0 |
| 2025-08-06 18:00:00 | AAPL | Stock | 220.54 | 220.85 | 217.26 | 220.16 | 1139758.0 |
| 2025-08-06 18:30:00 | AAPL | Stock | 220.11 | 221.0 | 218.85 | 219.2 | 613527.0 |
| 2025-08-06 19:00:00 | AAPL | Stock | 219.2 | 220.2 | 219.2 | 219.82 | 264018.0 |
| 2025-08-06 19:30:00 | AAPL | Stock | 219.89 | 220.0 | 219.1 | 219.26 | 249599.0 |
| 2025-08-06 04:00:00 | MSFT | Stock | 533.15 | 533.15 | 532.01 | 532.01 | 2565.0 |
| 2025-08-06 04:30:00 | MSFT | Stock | 532.15 | 532.45 | 531.43 | 532.0 | 5725.0 |
| 2025-08-06 05:00:00 | MSFT | Stock | 532.4 | 532.4 | 532.4 | 532.4 | 100.0 |
| 2025-08-06 05:30:00 | MSFT | Stock | 532.0 | 532.0 | 531.75 | 531.8 | 1840.0 |
| 2025-08-06 06:00:00 | MSFT | Stock | 531.51 | 531.94 | 531.5 | 531.79 | 953.0 |
| 2025-08-06 06:30:00 | MSFT | Stock | 531.54 | 531.54 | 531.3 | 531.3 | 583.0 |
| 2025-08-06 07:00:00 | MSFT | Stock | 532.09 | 532.28 | 531.42 | 531.8 | 6289.0 |
| 2025-08-06 07:30:00 | MSFT | Stock | 531.9 | 532.2 | 531.32 | 531.32 | 5015.0 |
| 2025-08-06 08:00:00 | MSFT | Stock | 531.75 | 533.06 | 530.0 | 530.0 | 37280.0 |
| 2025-08-06 08:30:00 | MSFT | Stock | 529.77 | 530.56 | 529.77 | 530.36 | 8122.0 |
| 2025-08-06 09:00:00 | MSFT | Stock | 530.4784 | 531.7 | 528.63 | 530.5702 | 13933.0 |
| 2025-08-06 09:30:00 | MSFT | Stock | 530.9 | 531.7 | 526.22 | 526.49 | 1734543.0 |
| 2025-08-06 10:00:00 | MSFT | Stock | 526.49 | 527.74 | 525.1 | 526.32 | 1139714.0 |
| 2025-08-06 10:30:00 | MSFT | Stock | 526.3036 | 526.345 | 524.595 | 525.985 | 1063599.0 |
| 2025-08-06 11:00:00 | MSFT | Stock | 526.01 | 526.79 | 525.37 | 525.665 | 829511.0 |
| 2025-08-06 11:30:00 | MSFT | Stock | 525.65 | 526.8 | 525.25 | 526.55 | 618857.0 |
| 2025-08-06 12:00:00 | MSFT | Stock | 526.54 | 527.2 | 525.85 | 526.79 | 441179.0 |
| 2025-08-06 12:30:00 | MSFT | Stock | 526.7932 | 526.8175 | 525.8227 | 526.17 | 446432.0 |
> showing 50 of 106,293 rows — these rows as CSV