PREVIEW / stock_30min / 2025-06-09
file: by_date/stock_30min/2025/2025-06-09.parquet size: 2.2 MB rows: 106,856 symbols: 405
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-06-09 04:00:00 | AAPL | Stock | 205.0 | 205.08 | 204.65 | 204.69 | 12942.0 |
| 2025-06-09 04:30:00 | AAPL | Stock | 204.6 | 204.97 | 204.45 | 204.89 | 7512.0 |
| 2025-06-09 05:00:00 | AAPL | Stock | 204.82 | 204.86 | 204.69 | 204.71 | 4193.0 |
| 2025-06-09 05:30:00 | AAPL | Stock | 204.81 | 204.85 | 204.72 | 204.76 | 3220.0 |
| 2025-06-09 06:00:00 | AAPL | Stock | 204.77 | 204.9 | 204.53 | 204.53 | 7906.0 |
| 2025-06-09 06:30:00 | AAPL | Stock | 204.6 | 204.71 | 204.42 | 204.5 | 5658.0 |
| 2025-06-09 07:00:00 | AAPL | Stock | 204.53 | 205.31 | 204.5 | 205.2 | 22772.0 |
| 2025-06-09 07:30:00 | AAPL | Stock | 205.07 | 205.47 | 205.07 | 205.19 | 18787.0 |
| 2025-06-09 08:00:00 | AAPL | Stock | 204.57 | 205.4795 | 204.11 | 204.95 | 135365.0 |
| 2025-06-09 08:30:00 | AAPL | Stock | 205.0 | 205.0 | 204.7202 | 204.78 | 39169.0 |
| 2025-06-09 09:00:00 | AAPL | Stock | 204.75 | 204.9 | 204.29 | 204.44 | 71197.0 |
| 2025-06-09 09:30:00 | AAPL | Stock | 204.47 | 205.55 | 203.98 | 204.83 | 3954912.0 |
| 2025-06-09 10:00:00 | AAPL | Stock | 204.85 | 206.0 | 204.6 | 205.32 | 2641328.0 |
| 2025-06-09 10:30:00 | AAPL | Stock | 205.3 | 205.74 | 204.53 | 204.7199 | 2156400.0 |
| 2025-06-09 11:00:00 | AAPL | Stock | 204.72 | 204.94 | 204.51 | 204.53 | 1368570.0 |
| 2025-06-09 11:30:00 | AAPL | Stock | 204.5301 | 204.65 | 204.2612 | 204.46 | 1356752.0 |
| 2025-06-09 12:00:00 | AAPL | Stock | 204.47 | 204.91 | 203.73 | 203.9288 | 2247319.0 |
| 2025-06-09 12:30:00 | AAPL | Stock | 203.93 | 204.81 | 203.89 | 204.7 | 1744633.0 |
| 2025-06-09 13:00:00 | AAPL | Stock | 204.71 | 205.2999 | 200.02 | 200.72 | 10357271.0 |
| 2025-06-09 13:30:00 | AAPL | Stock | 200.71 | 202.57 | 200.03 | 202.465 | 6823639.0 |
| 2025-06-09 14:00:00 | AAPL | Stock | 202.45 | 202.6677 | 201.27 | 201.45 | 3597096.0 |
| 2025-06-09 14:30:00 | AAPL | Stock | 201.445 | 201.7 | 200.63 | 201.52 | 4140866.0 |
| 2025-06-09 15:00:00 | AAPL | Stock | 201.5399 | 201.58 | 200.84 | 201.24 | 2489054.0 |
| 2025-06-09 15:30:00 | AAPL | Stock | 201.23 | 202.355 | 200.89 | 201.44 | 5780692.0 |
| 2025-06-09 16:00:00 | AAPL | Stock | 201.435 | 201.45 | 201.1774 | 201.4 | 6856281.0 |
| 2025-06-09 16:30:00 | AAPL | Stock | 201.44 | 201.59 | 201.3 | 201.45 | 41192.0 |
| 2025-06-09 17:00:00 | AAPL | Stock | 201.55 | 201.55 | 201.336 | 201.461 | 45812.0 |
| 2025-06-09 17:30:00 | AAPL | Stock | 201.46 | 201.72 | 201.45 | 201.6285 | 52436.0 |
| 2025-06-09 18:00:00 | AAPL | Stock | 201.629 | 201.75 | 201.57 | 201.66 | 30998.0 |
| 2025-06-09 18:30:00 | AAPL | Stock | 201.641 | 201.66 | 201.5663 | 201.65 | 18052.0 |
| 2025-06-09 19:00:00 | AAPL | Stock | 201.66 | 201.77 | 201.6048 | 201.75 | 21145.0 |
| 2025-06-09 19:30:00 | AAPL | Stock | 201.75 | 201.79 | 201.7 | 201.75 | 36494.0 |
| 2025-06-09 04:00:00 | MSFT | Stock | 468.85 | 470.01 | 468.85 | 469.53 | 5181.0 |
| 2025-06-09 04:30:00 | MSFT | Stock | 469.46 | 470.2 | 469.36 | 470.07 | 2902.0 |
| 2025-06-09 05:00:00 | MSFT | Stock | 470.35 | 470.38 | 470.35 | 470.38 | 627.0 |
| 2025-06-09 05:30:00 | MSFT | Stock | 469.97 | 469.97 | 469.7 | 469.71 | 1991.0 |
| 2025-06-09 06:00:00 | MSFT | Stock | 469.77 | 469.77 | 469.6 | 469.6 | 200.0 |
| 2025-06-09 06:30:00 | MSFT | Stock | 469.66 | 469.66 | 469.2 | 469.2 | 2774.0 |
| 2025-06-09 07:00:00 | MSFT | Stock | 469.81 | 469.81 | 469.45 | 469.52 | 561.0 |
| 2025-06-09 07:30:00 | MSFT | Stock | 469.73 | 469.85 | 469.55 | 469.63 | 997.0 |
| 2025-06-09 08:00:00 | MSFT | Stock | 469.8797 | 469.9121 | 468.12 | 469.049 | 8243.0 |
| 2025-06-09 08:30:00 | MSFT | Stock | 469.18 | 469.29 | 468.77 | 468.86 | 8871.0 |
| 2025-06-09 09:00:00 | MSFT | Stock | 468.99 | 469.99 | 468.97 | 469.97 | 4976.0 |
| 2025-06-09 09:30:00 | MSFT | Stock | 469.7 | 471.225 | 468.62 | 469.405 | 996498.0 |
| 2025-06-09 10:00:00 | MSFT | Stock | 469.56 | 471.15 | 469.484 | 470.37 | 453154.0 |
| 2025-06-09 10:30:00 | MSFT | Stock | 470.42 | 471.15 | 469.83 | 470.05 | 398738.0 |
| 2025-06-09 11:00:00 | MSFT | Stock | 470.07 | 470.5 | 469.77 | 470.15 | 285896.0 |
| 2025-06-09 11:30:00 | MSFT | Stock | 470.14 | 471.2 | 469.75 | 470.63 | 373180.0 |
| 2025-06-09 12:00:00 | MSFT | Stock | 470.64 | 471.04 | 470.0 | 470.7 | 226926.0 |
| 2025-06-09 12:30:00 | MSFT | Stock | 470.72 | 472.46 | 470.62 | 471.91 | 394043.0 |
> showing 50 of 106,856 rows — these rows as CSV