PREVIEW / stock_30min / 2025-08-15
file: by_date/stock_30min/2025/2025-08-15.parquet size: 2.2 MB rows: 105,464 symbols: 336
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-15 04:00:00 | AAPL | Stock | 232.45 | 233.19 | 232.45 | 233.05 | 8824.0 |
| 2025-08-15 04:30:00 | AAPL | Stock | 233.03 | 233.19 | 232.73 | 232.73 | 8586.0 |
| 2025-08-15 05:00:00 | AAPL | Stock | 232.66 | 232.97 | 232.66 | 232.97 | 1904.0 |
| 2025-08-15 05:30:00 | AAPL | Stock | 232.96 | 233.18 | 232.83 | 233.11 | 3049.0 |
| 2025-08-15 06:00:00 | AAPL | Stock | 232.95 | 232.95 | 232.79 | 232.79 | 1640.0 |
| 2025-08-15 06:30:00 | AAPL | Stock | 232.8 | 232.91 | 232.66 | 232.73 | 2797.0 |
| 2025-08-15 07:00:00 | AAPL | Stock | 232.8 | 233.19 | 232.73 | 233.15 | 4880.0 |
| 2025-08-15 07:30:00 | AAPL | Stock | 233.06 | 233.3 | 233.02 | 233.12 | 2957.0 |
| 2025-08-15 08:00:00 | AAPL | Stock | 232.74 | 233.43 | 232.09 | 232.99 | 81496.0 |
| 2025-08-15 08:30:00 | AAPL | Stock | 232.79 | 233.1113 | 232.79 | 233.0799 | 25182.0 |
| 2025-08-15 09:00:00 | AAPL | Stock | 233.03 | 234.14 | 232.54 | 233.56 | 237282.0 |
| 2025-08-15 09:30:00 | AAPL | Stock | 234.0 | 234.28 | 231.8 | 232.06 | 6903831.0 |
| 2025-08-15 10:00:00 | AAPL | Stock | 232.0 | 232.685 | 231.5501 | 232.17 | 2402940.0 |
| 2025-08-15 10:30:00 | AAPL | Stock | 232.17 | 232.29 | 230.75 | 230.87 | 2036889.0 |
| 2025-08-15 11:00:00 | AAPL | Stock | 230.87 | 231.555 | 230.47 | 231.07 | 2087142.0 |
| 2025-08-15 11:30:00 | AAPL | Stock | 231.07 | 231.46 | 230.6197 | 231.025 | 1789103.0 |
| 2025-08-15 12:00:00 | AAPL | Stock | 231.02 | 231.36 | 230.7301 | 230.74 | 1222159.0 |
| 2025-08-15 12:30:00 | AAPL | Stock | 230.7442 | 231.08 | 230.4737 | 230.9 | 1234348.0 |
| 2025-08-15 13:00:00 | AAPL | Stock | 230.91 | 231.225 | 230.23 | 230.57 | 1259217.0 |
| 2025-08-15 13:30:00 | AAPL | Stock | 230.56 | 230.91 | 230.49 | 230.89 | 1152414.0 |
| 2025-08-15 14:00:00 | AAPL | Stock | 230.885 | 231.2899 | 229.335 | 230.85 | 2302320.0 |
| 2025-08-15 14:30:00 | AAPL | Stock | 230.86 | 230.98 | 230.48 | 230.7697 | 1004544.0 |
| 2025-08-15 15:00:00 | AAPL | Stock | 230.77 | 231.5 | 230.59 | 231.3556 | 1171435.0 |
| 2025-08-15 15:30:00 | AAPL | Stock | 231.37 | 231.77 | 231.0 | 231.65 | 3585111.0 |
| 2025-08-15 16:00:00 | AAPL | Stock | 231.65 | 231.77 | 230.88 | 231.27 | 9581924.0 |
| 2025-08-15 16:30:00 | AAPL | Stock | 231.44 | 231.59 | 231.16 | 231.16 | 18625.0 |
| 2025-08-15 17:00:00 | AAPL | Stock | 231.21 | 231.3872 | 231.1005 | 231.3 | 6965.0 |
| 2025-08-15 17:30:00 | AAPL | Stock | 231.15 | 231.59 | 231.15 | 231.26 | 20281.0 |
| 2025-08-15 18:00:00 | AAPL | Stock | 231.19 | 231.5994 | 231.19 | 231.3 | 5455.0 |
| 2025-08-15 18:30:00 | AAPL | Stock | 231.33 | 231.34 | 231.24 | 231.24 | 3215.0 |
| 2025-08-15 19:00:00 | AAPL | Stock | 231.28 | 231.4462 | 231.28 | 231.34 | 5613.0 |
| 2025-08-15 19:30:00 | AAPL | Stock | 231.34 | 231.41 | 231.19 | 231.19 | 6640.0 |
| 2025-08-15 04:00:00 | MSFT | Stock | 524.15 | 524.47 | 524.15 | 524.38 | 3416.0 |
| 2025-08-15 04:30:00 | MSFT | Stock | 524.38 | 524.38 | 523.01 | 523.35 | 6598.0 |
| 2025-08-15 05:00:00 | MSFT | Stock | 523.42 | 523.42 | 523.42 | 523.42 | 162.0 |
| 2025-08-15 05:30:00 | MSFT | Stock | 523.43 | 523.43 | 523.43 | 523.43 | 100.0 |
| 2025-08-15 06:00:00 | MSFT | Stock | 523.54 | 523.54 | 523.54 | 523.54 | 106.0 |
| 2025-08-15 06:30:00 | MSFT | Stock | 523.7 | 523.8 | 523.62 | 523.62 | 600.0 |
| 2025-08-15 07:00:00 | MSFT | Stock | 523.57 | 523.57 | 523.2 | 523.34 | 1637.0 |
| 2025-08-15 07:30:00 | MSFT | Stock | 523.29 | 523.82 | 523.29 | 523.73 | 2262.0 |
| 2025-08-15 08:00:00 | MSFT | Stock | 523.5 | 525.0 | 522.92 | 523.1101 | 13195.0 |
| 2025-08-15 08:30:00 | MSFT | Stock | 523.28 | 523.75 | 523.0 | 523.07 | 14408.0 |
| 2025-08-15 09:00:00 | MSFT | Stock | 523.25 | 524.25 | 521.7 | 523.01 | 60717.0 |
| 2025-08-15 09:30:00 | MSFT | Stock | 522.68 | 523.19 | 520.86 | 522.24 | 2594383.0 |
| 2025-08-15 10:00:00 | MSFT | Stock | 522.22 | 524.51 | 521.2 | 523.145 | 829062.0 |
| 2025-08-15 10:30:00 | MSFT | Stock | 523.09 | 523.3535 | 521.33 | 521.7458 | 403833.0 |
| 2025-08-15 11:00:00 | MSFT | Stock | 521.72 | 523.47 | 521.7 | 522.93 | 403046.0 |
| 2025-08-15 11:30:00 | MSFT | Stock | 522.92 | 524.88 | 522.06 | 523.895 | 500031.0 |
| 2025-08-15 12:00:00 | MSFT | Stock | 523.88 | 524.83 | 523.48 | 523.905 | 338220.0 |
| 2025-08-15 12:30:00 | MSFT | Stock | 523.88 | 525.16 | 523.85 | 524.9 | 359004.0 |
> showing 50 of 105,464 rows — these rows as CSV