PREVIEW / stock_30min / 2025-06-24
file: by_date/stock_30min/2025/2025-06-24.parquet size: 2.2 MB rows: 107,167 symbols: 398
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-24 04:00:00 | AAPL | Stock | 202.62 | 203.44 | 202.62 | 203.29 | 16580.0 |
| 2025-06-24 04:30:00 | AAPL | Stock | 203.34 | 203.34 | 203.2 | 203.29 | 3729.0 |
| 2025-06-24 05:00:00 | AAPL | Stock | 203.32 | 204.11 | 203.32 | 204.1 | 27713.0 |
| 2025-06-24 05:30:00 | AAPL | Stock | 204.1 | 204.97 | 204.1 | 204.44 | 35447.0 |
| 2025-06-24 06:00:00 | AAPL | Stock | 204.31 | 204.58 | 204.26 | 204.42 | 17447.0 |
| 2025-06-24 06:30:00 | AAPL | Stock | 204.32 | 204.32 | 203.7 | 203.7 | 18669.0 |
| 2025-06-24 07:00:00 | AAPL | Stock | 203.68 | 204.0 | 203.48 | 203.89 | 41756.0 |
| 2025-06-24 07:30:00 | AAPL | Stock | 203.8 | 203.9 | 203.53 | 203.62 | 29645.0 |
| 2025-06-24 08:00:00 | AAPL | Stock | 203.61 | 204.95 | 202.4 | 203.9107 | 213586.0 |
| 2025-06-24 08:30:00 | AAPL | Stock | 203.9 | 203.9852 | 203.68 | 203.8 | 34601.0 |
| 2025-06-24 09:00:00 | AAPL | Stock | 203.7892 | 203.8 | 202.4 | 202.55 | 149177.0 |
| 2025-06-24 09:30:00 | AAPL | Stock | 202.59 | 202.78 | 200.22 | 200.43 | 6151661.0 |
| 2025-06-24 10:00:00 | AAPL | Stock | 200.43 | 201.33 | 200.2 | 200.9823 | 2811192.0 |
| 2025-06-24 10:30:00 | AAPL | Stock | 200.99 | 201.58 | 200.75 | 200.98 | 1845336.0 |
| 2025-06-24 11:00:00 | AAPL | Stock | 200.98 | 201.455 | 200.73 | 201.44 | 1491961.0 |
| 2025-06-24 11:30:00 | AAPL | Stock | 201.44 | 202.09 | 201.2 | 201.905 | 1724399.0 |
| 2025-06-24 12:00:00 | AAPL | Stock | 201.905 | 202.565 | 201.81 | 202.45 | 1865014.0 |
| 2025-06-24 12:30:00 | AAPL | Stock | 202.4515 | 203.44 | 202.29 | 202.435 | 3379656.0 |
| 2025-06-24 13:00:00 | AAPL | Stock | 202.42 | 202.54 | 201.94 | 201.96 | 1771697.0 |
| 2025-06-24 13:30:00 | AAPL | Stock | 201.96 | 202.33 | 201.84 | 202.205 | 1453324.0 |
| 2025-06-24 14:00:00 | AAPL | Stock | 202.21 | 202.265 | 201.31 | 201.57 | 1945620.0 |
| 2025-06-24 14:30:00 | AAPL | Stock | 201.58 | 201.84 | 201.305 | 201.4453 | 1522619.0 |
| 2025-06-24 15:00:00 | AAPL | Stock | 201.449 | 202.015 | 201.425 | 201.53 | 2149794.0 |
| 2025-06-24 15:30:00 | AAPL | Stock | 201.535 | 201.5999 | 200.27 | 200.29 | 5514659.0 |
| 2025-06-24 16:00:00 | AAPL | Stock | 200.3 | 200.69 | 200.25 | 200.58 | 6431306.0 |
| 2025-06-24 16:30:00 | AAPL | Stock | 200.6 | 200.7988 | 200.3 | 200.75 | 45026.0 |
| 2025-06-24 17:00:00 | AAPL | Stock | 200.7965 | 200.8 | 200.4 | 200.659 | 31574.0 |
| 2025-06-24 17:30:00 | AAPL | Stock | 200.59 | 200.7 | 200.59 | 200.7 | 11709.0 |
| 2025-06-24 18:00:00 | AAPL | Stock | 200.66 | 200.68 | 200.5 | 200.5988 | 16469.0 |
| 2025-06-24 18:30:00 | AAPL | Stock | 200.6 | 200.7 | 200.5 | 200.6 | 22586.0 |
| 2025-06-24 19:00:00 | AAPL | Stock | 200.6 | 200.78 | 200.6 | 200.7 | 11307.0 |
| 2025-06-24 19:30:00 | AAPL | Stock | 200.72 | 200.8 | 200.7 | 200.7901 | 25227.0 |
| 2025-06-24 04:00:00 | MSFT | Stock | 491.52 | 491.52 | 490.0 | 490.22 | 4598.0 |
| 2025-06-24 04:30:00 | MSFT | Stock | 490.0 | 490.0 | 490.0 | 490.0 | 200.0 |
| 2025-06-24 05:00:00 | MSFT | Stock | 489.91 | 490.26 | 489.91 | 490.26 | 503.0 |
| 2025-06-24 05:30:00 | MSFT | Stock | 490.29 | 490.41 | 489.9 | 489.9 | 1939.0 |
| 2025-06-24 06:00:00 | MSFT | Stock | 489.78 | 489.78 | 488.28 | 488.57 | 1000.0 |
| 2025-06-24 06:30:00 | MSFT | Stock | 488.5 | 488.94 | 488.44 | 488.94 | 800.0 |
| 2025-06-24 07:00:00 | MSFT | Stock | 488.5 | 488.7 | 487.05 | 488.56 | 6325.0 |
| 2025-06-24 07:30:00 | MSFT | Stock | 488.8 | 488.84 | 488.27 | 488.75 | 2406.0 |
| 2025-06-24 08:00:00 | MSFT | Stock | 488.84 | 491.76 | 487.5501 | 488.5 | 17895.0 |
| 2025-06-24 08:30:00 | MSFT | Stock | 488.5 | 488.62 | 487.505 | 487.7 | 6866.0 |
| 2025-06-24 09:00:00 | MSFT | Stock | 487.8 | 489.45 | 487.6095 | 488.97 | 25109.0 |
| 2025-06-24 09:30:00 | MSFT | Stock | 488.95 | 489.66 | 486.795 | 487.525 | 1402512.0 |
| 2025-06-24 10:00:00 | MSFT | Stock | 487.625 | 488.188 | 487.1 | 487.545 | 607980.0 |
| 2025-06-24 10:30:00 | MSFT | Stock | 487.57 | 489.53 | 487.46 | 489.0 | 875917.0 |
| 2025-06-24 11:00:00 | MSFT | Stock | 489.02 | 490.58 | 488.99 | 490.57 | 837912.0 |
| 2025-06-24 11:30:00 | MSFT | Stock | 490.545 | 491.49 | 489.7701 | 491.21 | 957770.0 |
| 2025-06-24 12:00:00 | MSFT | Stock | 491.183 | 491.183 | 490.18 | 490.705 | 437802.0 |
| 2025-06-24 12:30:00 | MSFT | Stock | 490.7 | 491.41 | 490.07 | 490.28 | 533378.0 |
> showing 50 of 107,167 rows — these rows as CSV