PREVIEW / stock_30min / 2025-09-22
file: by_date/stock_30min/2025/2025-09-22.parquet size: 2.4 MB rows: 113,162 symbols: 304
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-09-22 04:00:00 | AAPL | Stock | 246.13 | 246.82 | 245.08 | 246.35 | 47994.0 |
| 2025-09-22 04:30:00 | AAPL | Stock | 246.45 | 247.0 | 246.45 | 246.6 | 8761.0 |
| 2025-09-22 05:00:00 | AAPL | Stock | 246.87 | 247.11 | 246.12 | 246.52 | 23682.0 |
| 2025-09-22 05:30:00 | AAPL | Stock | 246.5 | 246.75 | 246.2 | 246.75 | 6430.0 |
| 2025-09-22 06:00:00 | AAPL | Stock | 246.88 | 247.42 | 246.56 | 247.33 | 25465.0 |
| 2025-09-22 06:30:00 | AAPL | Stock | 247.2 | 247.2 | 246.4 | 246.46 | 11287.0 |
| 2025-09-22 07:00:00 | AAPL | Stock | 246.42 | 246.66 | 246.1 | 246.59 | 30627.0 |
| 2025-09-22 07:30:00 | AAPL | Stock | 246.63 | 247.03 | 246.56 | 247.0 | 28330.0 |
| 2025-09-22 08:00:00 | AAPL | Stock | 246.34 | 247.42 | 244.39 | 247.25 | 264449.0 |
| 2025-09-22 08:30:00 | AAPL | Stock | 247.25 | 248.239 | 247.2 | 248.01 | 196378.0 |
| 2025-09-22 09:00:00 | AAPL | Stock | 248.0 | 248.77 | 247.75 | 248.3 | 306982.0 |
| 2025-09-22 09:30:00 | AAPL | Stock | 248.3 | 251.3443 | 248.12 | 251.095 | 13544036.0 |
| 2025-09-22 10:00:00 | AAPL | Stock | 251.11 | 252.735 | 250.78 | 252.6716 | 6393704.0 |
| 2025-09-22 10:30:00 | AAPL | Stock | 252.66 | 253.6898 | 252.08 | 253.6 | 4689619.0 |
| 2025-09-22 11:00:00 | AAPL | Stock | 253.62 | 256.08 | 253.385 | 255.79 | 8842060.0 |
| 2025-09-22 11:30:00 | AAPL | Stock | 255.77 | 256.64 | 254.7 | 256.0531 | 6485065.0 |
| 2025-09-22 12:00:00 | AAPL | Stock | 256.07 | 256.31 | 253.58 | 253.72 | 5871181.0 |
| 2025-09-22 12:30:00 | AAPL | Stock | 253.73 | 254.215 | 253.16 | 254.21 | 3746027.0 |
| 2025-09-22 13:00:00 | AAPL | Stock | 254.205 | 254.73 | 253.52 | 254.5929 | 2647416.0 |
| 2025-09-22 13:30:00 | AAPL | Stock | 254.58 | 254.94 | 253.9 | 254.1067 | 2009520.0 |
| 2025-09-22 14:00:00 | AAPL | Stock | 254.1 | 255.26 | 254.02 | 255.245 | 1913197.0 |
| 2025-09-22 14:30:00 | AAPL | Stock | 255.245 | 255.77 | 254.7337 | 255.4 | 2774113.0 |
| 2025-09-22 15:00:00 | AAPL | Stock | 255.4 | 256.06 | 255.31 | 255.79 | 3018937.0 |
| 2025-09-22 15:30:00 | AAPL | Stock | 255.8 | 256.26 | 255.32 | 256.09 | 7295211.0 |
| 2025-09-22 16:00:00 | AAPL | Stock | 256.13 | 256.49 | 256.01 | 256.18 | 10449871.0 |
| 2025-09-22 16:30:00 | AAPL | Stock | 256.12 | 256.6 | 256.08 | 256.4 | 72005.0 |
| 2025-09-22 17:00:00 | AAPL | Stock | 256.4 | 256.55 | 256.08 | 256.55 | 17132.0 |
| 2025-09-22 17:30:00 | AAPL | Stock | 256.55 | 256.55 | 256.08 | 256.4201 | 103548.0 |
| 2025-09-22 18:00:00 | AAPL | Stock | 256.42 | 256.42 | 256.25 | 256.31 | 36212.0 |
| 2025-09-22 18:30:00 | AAPL | Stock | 256.3 | 256.3 | 256.21 | 256.27 | 14487.0 |
| 2025-09-22 19:00:00 | AAPL | Stock | 256.23 | 256.29 | 256.23 | 256.28 | 7521.0 |
| 2025-09-22 19:30:00 | AAPL | Stock | 256.28 | 256.45 | 256.2799 | 256.45 | 39023.0 |
| 2025-09-22 04:00:00 | MSFT | Stock | 515.6 | 516.5 | 515.19 | 516.06 | 4561.0 |
| 2025-09-22 04:30:00 | MSFT | Stock | 516.0 | 516.0 | 515.74 | 515.8 | 1082.0 |
| 2025-09-22 05:00:00 | MSFT | Stock | 515.31 | 515.31 | 515.0 | 515.1 | 5759.0 |
| 2025-09-22 05:30:00 | MSFT | Stock | 515.1 | 515.1 | 514.89 | 515.06 | 2346.0 |
| 2025-09-22 06:00:00 | MSFT | Stock | 515.1 | 515.25 | 515.01 | 515.01 | 11980.0 |
| 2025-09-22 06:30:00 | MSFT | Stock | 515.09 | 515.1 | 514.8 | 514.8 | 6082.0 |
| 2025-09-22 07:00:00 | MSFT | Stock | 514.8 | 515.0 | 514.29 | 514.35 | 14509.0 |
| 2025-09-22 07:30:00 | MSFT | Stock | 514.35 | 514.75 | 513.9 | 514.75 | 11074.0 |
| 2025-09-22 08:00:00 | MSFT | Stock | 514.88 | 518.0 | 513.8026 | 514.47 | 39449.0 |
| 2025-09-22 08:30:00 | MSFT | Stock | 514.7366 | 515.1 | 514.0 | 515.1 | 14633.0 |
| 2025-09-22 09:00:00 | MSFT | Stock | 514.8219 | 516.2 | 514.82 | 515.85 | 41883.0 |
| 2025-09-22 09:30:00 | MSFT | Stock | 515.59 | 517.74 | 514.3 | 514.53 | 1529271.0 |
| 2025-09-22 10:00:00 | MSFT | Stock | 514.49 | 514.88 | 512.545 | 514.57 | 890936.0 |
| 2025-09-22 10:30:00 | MSFT | Stock | 514.59 | 516.6 | 514.54 | 515.925 | 650733.0 |
| 2025-09-22 11:00:00 | MSFT | Stock | 515.9 | 516.26 | 514.66 | 515.035 | 409027.0 |
| 2025-09-22 11:30:00 | MSFT | Stock | 515.12 | 515.5 | 513.75 | 513.87 | 358719.0 |
| 2025-09-22 12:00:00 | MSFT | Stock | 513.87 | 514.6852 | 512.58 | 514.5741 | 633406.0 |
| 2025-09-22 12:30:00 | MSFT | Stock | 514.6 | 515.955 | 514.44 | 515.005 | 468624.0 |
> showing 50 of 113,162 rows — these rows as CSV