PREVIEW / stock_30min / 2025-08-01
file: by_date/stock_30min/2025/2025-08-01.parquet size: 2.2 MB rows: 108,417 symbols: 349
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-01 04:00:00 | AAPL | Stock | 211.4 | 211.93 | 211.01 | 211.01 | 74312.0 |
| 2025-08-01 04:30:00 | AAPL | Stock | 211.02 | 211.16 | 209.41 | 210.72 | 59707.0 |
| 2025-08-01 05:00:00 | AAPL | Stock | 210.69 | 211.71 | 210.64 | 211.7 | 48155.0 |
| 2025-08-01 05:30:00 | AAPL | Stock | 211.7 | 212.09 | 211.55 | 211.66 | 29300.0 |
| 2025-08-01 06:00:00 | AAPL | Stock | 211.61 | 211.67 | 211.0 | 211.1 | 32815.0 |
| 2025-08-01 06:30:00 | AAPL | Stock | 211.02 | 211.05 | 210.5 | 210.73 | 45395.0 |
| 2025-08-01 07:00:00 | AAPL | Stock | 210.73 | 211.25 | 210.51 | 211.18 | 64383.0 |
| 2025-08-01 07:30:00 | AAPL | Stock | 211.18 | 211.5 | 211.081 | 211.081 | 57059.0 |
| 2025-08-01 08:00:00 | AAPL | Stock | 211.0 | 212.35 | 210.0 | 211.1991 | 348731.0 |
| 2025-08-01 08:30:00 | AAPL | Stock | 211.1 | 211.48 | 210.32 | 211.2055 | 272004.0 |
| 2025-08-01 09:00:00 | AAPL | Stock | 211.1 | 212.64 | 210.27 | 210.8 | 540102.0 |
| 2025-08-01 09:30:00 | AAPL | Stock | 210.95 | 213.58 | 206.27 | 207.045 | 13270389.0 |
| 2025-08-01 10:00:00 | AAPL | Stock | 207.04 | 207.47 | 204.37 | 205.36 | 7721444.0 |
| 2025-08-01 10:30:00 | AAPL | Stock | 205.33 | 205.73 | 203.62 | 204.0399 | 5194528.0 |
| 2025-08-01 11:00:00 | AAPL | Stock | 204.03 | 204.585 | 203.07 | 203.44 | 4165676.0 |
| 2025-08-01 11:30:00 | AAPL | Stock | 203.42 | 204.6 | 203.225 | 203.73 | 3475304.0 |
| 2025-08-01 12:00:00 | AAPL | Stock | 203.71 | 204.01 | 202.65 | 202.75 | 3657815.0 |
| 2025-08-01 12:30:00 | AAPL | Stock | 202.76 | 203.2895 | 201.9601 | 202.085 | 3166536.0 |
| 2025-08-01 13:00:00 | AAPL | Stock | 202.07 | 202.365 | 201.5 | 201.9825 | 3022571.0 |
| 2025-08-01 13:30:00 | AAPL | Stock | 201.9801 | 202.55 | 201.6301 | 202.218 | 2960594.0 |
| 2025-08-01 14:00:00 | AAPL | Stock | 202.2171 | 203.73 | 202.19 | 203.55 | 2889293.0 |
| 2025-08-01 14:30:00 | AAPL | Stock | 203.55 | 204.3212 | 203.37 | 203.81 | 2776876.0 |
| 2025-08-01 15:00:00 | AAPL | Stock | 203.81 | 204.02 | 202.9 | 203.19 | 2853815.0 |
| 2025-08-01 15:30:00 | AAPL | Stock | 203.18 | 203.55 | 202.17 | 202.27 | 6370154.0 |
| 2025-08-01 16:00:00 | AAPL | Stock | 202.27 | 202.6 | 202.26 | 202.45 | 7270371.0 |
| 2025-08-01 16:30:00 | AAPL | Stock | 202.45 | 202.75 | 202.38 | 202.55 | 58413.0 |
| 2025-08-01 17:00:00 | AAPL | Stock | 202.5 | 202.55 | 202.41 | 202.51 | 45771.0 |
| 2025-08-01 17:30:00 | AAPL | Stock | 202.5 | 202.68 | 202.38 | 202.68 | 172231.0 |
| 2025-08-01 18:00:00 | AAPL | Stock | 202.6784 | 202.75 | 202.5536 | 202.56 | 18577.0 |
| 2025-08-01 18:30:00 | AAPL | Stock | 202.63 | 202.69 | 202.5 | 202.54 | 24481.0 |
| 2025-08-01 19:00:00 | AAPL | Stock | 202.51 | 202.51 | 202.38 | 202.38 | 29115.0 |
| 2025-08-01 19:30:00 | AAPL | Stock | 202.38 | 202.3801 | 202.25 | 202.25 | 33636.0 |
| 2025-08-01 04:00:00 | MSFT | Stock | 536.35 | 539.25 | 536.35 | 537.81 | 16154.0 |
| 2025-08-01 04:30:00 | MSFT | Stock | 538.0 | 538.68 | 537.0 | 537.0 | 9344.0 |
| 2025-08-01 05:00:00 | MSFT | Stock | 538.38 | 538.5 | 537.2 | 537.2 | 2441.0 |
| 2025-08-01 05:30:00 | MSFT | Stock | 537.17 | 538.01 | 537.1 | 538.01 | 3525.0 |
| 2025-08-01 06:00:00 | MSFT | Stock | 537.07 | 537.12 | 537.07 | 537.12 | 200.0 |
| 2025-08-01 06:30:00 | MSFT | Stock | 537.0 | 537.0 | 536.1 | 536.36 | 1873.0 |
| 2025-08-01 07:00:00 | MSFT | Stock | 536.67 | 536.99 | 536.1 | 536.81 | 7655.0 |
| 2025-08-01 07:30:00 | MSFT | Stock | 537.0 | 538.35 | 536.64 | 538.34 | 6426.0 |
| 2025-08-01 08:00:00 | MSFT | Stock | 536.02 | 538.5 | 534.75 | 536.73 | 51614.0 |
| 2025-08-01 08:30:00 | MSFT | Stock | 536.55 | 537.0 | 532.72 | 533.1 | 46389.0 |
| 2025-08-01 09:00:00 | MSFT | Stock | 533.5 | 536.0 | 530.9 | 535.13 | 73653.0 |
| 2025-08-01 09:30:00 | MSFT | Stock | 535.0 | 535.89 | 528.31 | 529.475 | 2770332.0 |
| 2025-08-01 10:00:00 | MSFT | Stock | 529.45 | 530.4 | 526.83 | 527.95 | 1658374.0 |
| 2025-08-01 10:30:00 | MSFT | Stock | 528.0 | 529.25 | 525.163 | 525.46 | 1212372.0 |
| 2025-08-01 11:00:00 | MSFT | Stock | 525.585 | 525.64 | 523.3001 | 523.625 | 1100042.0 |
| 2025-08-01 11:30:00 | MSFT | Stock | 523.625 | 524.81 | 522.64 | 524.27 | 973259.0 |
| 2025-08-01 12:00:00 | MSFT | Stock | 524.27 | 524.85 | 523.62 | 524.28 | 892617.0 |
| 2025-08-01 12:30:00 | MSFT | Stock | 524.22 | 524.2594 | 520.89 | 521.045 | 1003870.0 |
> showing 50 of 108,417 rows — these rows as CSV