PREVIEW / stock_30min / 2024-12-09
file: by_date/stock_30min/2024/2024-12-09.parquet size: 2.3 MB rows: 109,812 symbols: 680
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 |
|---|---|---|---|---|---|---|---|
| 2024-12-09 04:00:00 | AAPL | Stock | 242.69 | 242.84 | 242.1 | 242.3 | 16829.0 |
| 2024-12-09 04:30:00 | AAPL | Stock | 242.34 | 243.0 | 242.34 | 242.83 | 9542.0 |
| 2024-12-09 05:00:00 | AAPL | Stock | 242.85 | 242.85 | 242.51 | 242.62 | 4006.0 |
| 2024-12-09 05:30:00 | AAPL | Stock | 242.55 | 242.84 | 242.55 | 242.76 | 1940.0 |
| 2024-12-09 06:00:00 | AAPL | Stock | 242.79 | 242.79 | 242.55 | 242.6 | 8368.0 |
| 2024-12-09 06:30:00 | AAPL | Stock | 242.59 | 242.87 | 242.5 | 242.75 | 7183.0 |
| 2024-12-09 07:00:00 | AAPL | Stock | 242.67 | 242.67 | 242.34 | 242.39 | 13369.0 |
| 2024-12-09 07:30:00 | AAPL | Stock | 242.45 | 242.49 | 242.24 | 242.46 | 6854.0 |
| 2024-12-09 08:00:00 | AAPL | Stock | 242.6314 | 242.76 | 242.19 | 242.56 | 40508.0 |
| 2024-12-09 08:30:00 | AAPL | Stock | 242.48 | 242.59 | 242.3827 | 242.57 | 6551.0 |
| 2024-12-09 09:00:00 | AAPL | Stock | 242.5779 | 242.58 | 241.57 | 241.83 | 78411.0 |
| 2024-12-09 09:30:00 | AAPL | Stock | 241.9 | 244.1497 | 241.75 | 243.93 | 3278814.0 |
| 2024-12-09 10:00:00 | AAPL | Stock | 243.92 | 244.72 | 243.761 | 244.51 | 1793211.0 |
| 2024-12-09 10:30:00 | AAPL | Stock | 244.48 | 246.28 | 244.42 | 246.04 | 3233341.0 |
| 2024-12-09 11:00:00 | AAPL | Stock | 246.03 | 247.24 | 246.0 | 246.48 | 3062270.0 |
| 2024-12-09 11:30:00 | AAPL | Stock | 246.485 | 247.11 | 246.31 | 246.88 | 1594080.0 |
| 2024-12-09 12:00:00 | AAPL | Stock | 246.87 | 247.24 | 246.5674 | 246.83 | 1237160.0 |
| 2024-12-09 12:30:00 | AAPL | Stock | 246.825 | 247.02 | 245.71 | 246.219 | 1466936.0 |
| 2024-12-09 13:00:00 | AAPL | Stock | 246.205 | 247.01 | 246.09 | 246.9054 | 997124.0 |
| 2024-12-09 13:30:00 | AAPL | Stock | 246.9 | 246.9 | 246.38 | 246.735 | 815151.0 |
| 2024-12-09 14:00:00 | AAPL | Stock | 246.73 | 246.75 | 246.06 | 246.1 | 702919.0 |
| 2024-12-09 14:30:00 | AAPL | Stock | 246.095 | 246.48 | 245.89 | 246.4266 | 887897.0 |
| 2024-12-09 15:00:00 | AAPL | Stock | 246.425 | 246.78 | 246.21 | 246.76 | 1025401.0 |
| 2024-12-09 15:30:00 | AAPL | Stock | 246.78 | 247.09 | 246.1 | 246.82 | 4046885.0 |
| 2024-12-09 16:00:00 | AAPL | Stock | 246.86 | 247.0 | 246.73 | 246.99 | 7382308.0 |
| 2024-12-09 16:30:00 | AAPL | Stock | 246.97 | 247.2794 | 246.75 | 247.27 | 109813.0 |
| 2024-12-09 17:00:00 | AAPL | Stock | 247.26 | 247.2887 | 247.0501 | 247.14 | 20312.0 |
| 2024-12-09 17:30:00 | AAPL | Stock | 247.13 | 247.27 | 246.75 | 247.25 | 13909.0 |
| 2024-12-09 18:00:00 | AAPL | Stock | 247.2 | 247.2 | 247.02 | 247.03 | 7954.0 |
| 2024-12-09 18:30:00 | AAPL | Stock | 247.04 | 247.09 | 247.02 | 247.0345 | 3467.0 |
| 2024-12-09 19:00:00 | AAPL | Stock | 247.02 | 247.1 | 247.02 | 247.0987 | 11335.0 |
| 2024-12-09 19:30:00 | AAPL | Stock | 247.08 | 247.24 | 247.0699 | 247.24 | 20489.0 |
| 2024-12-09 04:00:00 | MSFT | Stock | 442.95 | 442.95 | 440.89 | 441.2 | 14662.0 |
| 2024-12-09 04:30:00 | MSFT | Stock | 441.04 | 441.04 | 440.66 | 440.89 | 5683.0 |
| 2024-12-09 05:00:00 | MSFT | Stock | 441.0 | 441.17 | 440.68 | 441.01 | 3663.0 |
| 2024-12-09 05:30:00 | MSFT | Stock | 441.07 | 441.5 | 440.77 | 440.9 | 4856.0 |
| 2024-12-09 06:00:00 | MSFT | Stock | 440.97 | 441.4 | 440.9 | 441.06 | 1575.0 |
| 2024-12-09 06:30:00 | MSFT | Stock | 441.17 | 441.28 | 440.6 | 441.27 | 3446.0 |
| 2024-12-09 07:00:00 | MSFT | Stock | 441.5 | 441.9 | 441.5 | 441.72 | 3554.0 |
| 2024-12-09 07:30:00 | MSFT | Stock | 441.75 | 442.0 | 441.59 | 441.9 | 6206.0 |
| 2024-12-09 08:00:00 | MSFT | Stock | 441.82 | 442.72 | 441.05 | 441.8 | 24472.0 |
| 2024-12-09 08:30:00 | MSFT | Stock | 441.7038 | 442.44 | 441.68 | 442.21 | 7343.0 |
| 2024-12-09 09:00:00 | MSFT | Stock | 442.29 | 442.8 | 441.68 | 442.8 | 12634.0 |
| 2024-12-09 09:30:00 | MSFT | Stock | 442.71 | 445.07 | 440.5 | 442.34 | 1252968.0 |
| 2024-12-09 10:00:00 | MSFT | Stock | 442.32 | 445.13 | 441.8601 | 443.735 | 823783.0 |
| 2024-12-09 10:30:00 | MSFT | Stock | 443.67 | 446.83 | 443.54 | 445.1 | 899379.0 |
| 2024-12-09 11:00:00 | MSFT | Stock | 445.07 | 447.59 | 444.945 | 447.065 | 653831.0 |
| 2024-12-09 11:30:00 | MSFT | Stock | 447.04 | 448.33 | 445.5549 | 446.705 | 633371.0 |
| 2024-12-09 12:00:00 | MSFT | Stock | 446.75 | 447.57 | 446.12 | 447.27 | 421506.0 |
| 2024-12-09 12:30:00 | MSFT | Stock | 447.265 | 447.28 | 446.1695 | 446.28 | 282038.0 |
> showing 50 of 109,812 rows — these rows as CSV