PREVIEW / stock_30min / 2025-08-14
file: by_date/stock_30min/2025/2025-08-14.parquet size: 2.3 MB rows: 107,959 symbols: 333
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-14 04:00:00 | AAPL | Stock | 233.0 | 233.22 | 232.88 | 233.0 | 7490.0 |
| 2025-08-14 04:30:00 | AAPL | Stock | 233.05 | 233.05 | 232.75 | 232.77 | 5305.0 |
| 2025-08-14 05:00:00 | AAPL | Stock | 232.72 | 232.73 | 232.58 | 232.68 | 5951.0 |
| 2025-08-14 05:30:00 | AAPL | Stock | 232.75 | 232.75 | 232.7 | 232.7 | 745.0 |
| 2025-08-14 06:00:00 | AAPL | Stock | 232.67 | 232.67 | 232.56 | 232.56 | 1266.0 |
| 2025-08-14 06:30:00 | AAPL | Stock | 232.7 | 232.71 | 232.59 | 232.59 | 3033.0 |
| 2025-08-14 07:00:00 | AAPL | Stock | 232.75 | 233.71 | 232.75 | 233.67 | 20096.0 |
| 2025-08-14 07:30:00 | AAPL | Stock | 233.81 | 234.99 | 233.77 | 234.27 | 38617.0 |
| 2025-08-14 08:00:00 | AAPL | Stock | 234.2 | 234.9 | 232.6 | 233.88 | 108810.0 |
| 2025-08-14 08:30:00 | AAPL | Stock | 233.75 | 233.75 | 232.21 | 232.9452 | 178869.0 |
| 2025-08-14 09:00:00 | AAPL | Stock | 232.84 | 234.23 | 232.2 | 234.01 | 202396.0 |
| 2025-08-14 09:30:00 | AAPL | Stock | 234.01 | 235.12 | 232.89 | 233.41 | 6532490.0 |
| 2025-08-14 10:00:00 | AAPL | Stock | 233.395 | 233.42 | 231.6702 | 232.21 | 3326723.0 |
| 2025-08-14 10:30:00 | AAPL | Stock | 232.205 | 232.46 | 231.54 | 231.65 | 2333643.0 |
| 2025-08-14 11:00:00 | AAPL | Stock | 231.655 | 231.84 | 230.85 | 231.7402 | 2834893.0 |
| 2025-08-14 11:30:00 | AAPL | Stock | 231.75 | 232.295 | 230.91 | 231.32 | 1932930.0 |
| 2025-08-14 12:00:00 | AAPL | Stock | 231.325 | 232.1496 | 231.31 | 232.01 | 1459488.0 |
| 2025-08-14 12:30:00 | AAPL | Stock | 232.02 | 232.545 | 231.9688 | 232.4906 | 1014894.0 |
| 2025-08-14 13:00:00 | AAPL | Stock | 232.495 | 233.14 | 232.48 | 232.9273 | 1430418.0 |
| 2025-08-14 13:30:00 | AAPL | Stock | 232.93 | 233.13 | 232.4584 | 232.705 | 1046209.0 |
| 2025-08-14 14:00:00 | AAPL | Stock | 232.72 | 232.8 | 232.32 | 232.71 | 1084966.0 |
| 2025-08-14 14:30:00 | AAPL | Stock | 232.71 | 233.37 | 232.44 | 232.99 | 1507030.0 |
| 2025-08-14 15:00:00 | AAPL | Stock | 232.99 | 233.49 | 232.87 | 232.945 | 1901818.0 |
| 2025-08-14 15:30:00 | AAPL | Stock | 232.94 | 233.59 | 232.69 | 232.83 | 3170941.0 |
| 2025-08-14 16:00:00 | AAPL | Stock | 232.78 | 232.85 | 232.43 | 232.5 | 7198746.0 |
| 2025-08-14 16:30:00 | AAPL | Stock | 232.51 | 232.9077 | 232.45 | 232.78 | 17115.0 |
| 2025-08-14 17:00:00 | AAPL | Stock | 232.7801 | 233.0 | 232.7072 | 232.8 | 19444.0 |
| 2025-08-14 17:30:00 | AAPL | Stock | 232.77 | 232.78 | 232.55 | 232.57 | 13852.0 |
| 2025-08-14 18:00:00 | AAPL | Stock | 232.6 | 232.7 | 232.45 | 232.54 | 10628.0 |
| 2025-08-14 18:30:00 | AAPL | Stock | 232.51 | 232.55 | 232.3 | 232.5204 | 11010.0 |
| 2025-08-14 19:00:00 | AAPL | Stock | 232.63 | 232.77 | 232.61 | 232.61 | 10140.0 |
| 2025-08-14 19:30:00 | AAPL | Stock | 232.5017 | 232.52 | 232.23 | 232.3999 | 13867.0 |
| 2025-08-14 04:00:00 | MSFT | Stock | 522.0 | 522.2 | 521.85 | 521.85 | 2378.0 |
| 2025-08-14 04:30:00 | MSFT | Stock | 521.89 | 522.18 | 521.89 | 522.09 | 1387.0 |
| 2025-08-14 05:00:00 | MSFT | Stock | 522.04 | 522.38 | 522.03 | 522.38 | 4856.0 |
| 2025-08-14 05:30:00 | MSFT | Stock | 522.73 | 522.9 | 522.52 | 522.69 | 930.0 |
| 2025-08-14 06:00:00 | MSFT | Stock | 522.6 | 522.65 | 522.45 | 522.45 | 2445.0 |
| 2025-08-14 06:30:00 | MSFT | Stock | 522.52 | 522.7 | 522.41 | 522.55 | 1624.0 |
| 2025-08-14 07:00:00 | MSFT | Stock | 522.55 | 522.55 | 522.13 | 522.24 | 3976.0 |
| 2025-08-14 07:30:00 | MSFT | Stock | 522.3 | 522.9 | 522.2 | 522.4 | 3406.0 |
| 2025-08-14 08:00:00 | MSFT | Stock | 522.29 | 522.73 | 520.55 | 522.55 | 20083.0 |
| 2025-08-14 08:30:00 | MSFT | Stock | 522.55 | 522.55 | 520.38 | 521.59 | 52170.0 |
| 2025-08-14 09:00:00 | MSFT | Stock | 521.71 | 523.0 | 521.5 | 522.5 | 33885.0 |
| 2025-08-14 09:30:00 | MSFT | Stock | 522.5 | 524.3698 | 520.15 | 523.24 | 1506186.0 |
| 2025-08-14 10:00:00 | MSFT | Stock | 523.28 | 523.92 | 521.8202 | 523.43 | 766551.0 |
| 2025-08-14 10:30:00 | MSFT | Stock | 523.43 | 525.9499 | 523.3883 | 524.26 | 668559.0 |
| 2025-08-14 11:00:00 | MSFT | Stock | 524.26 | 524.8099 | 523.1001 | 523.1001 | 514947.0 |
| 2025-08-14 11:30:00 | MSFT | Stock | 523.13 | 523.69 | 521.8 | 523.405 | 540676.0 |
| 2025-08-14 12:00:00 | MSFT | Stock | 523.41 | 524.51 | 522.54 | 524.35 | 374370.0 |
| 2025-08-14 12:30:00 | MSFT | Stock | 524.4 | 525.07 | 523.82 | 523.91 | 668343.0 |
> showing 50 of 107,959 rows — these rows as CSV