PREVIEW / stock_30min / 2024-12-11
file: by_date/stock_30min/2024/2024-12-11.parquet size: 2.2 MB rows: 107,044 symbols: 684
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-11 04:00:00 | AAPL | Stock | 247.72 | 247.8 | 247.13 | 247.37 | 8031.0 |
| 2024-12-11 04:30:00 | AAPL | Stock | 247.42 | 247.56 | 247.42 | 247.53 | 2090.0 |
| 2024-12-11 05:00:00 | AAPL | Stock | 247.54 | 247.59 | 247.42 | 247.42 | 1805.0 |
| 2024-12-11 05:30:00 | AAPL | Stock | 247.49 | 247.49 | 247.42 | 247.48 | 7242.0 |
| 2024-12-11 06:00:00 | AAPL | Stock | 247.49 | 247.49 | 247.48 | 247.49 | 1343.0 |
| 2024-12-11 06:30:00 | AAPL | Stock | 247.49 | 247.49 | 247.45 | 247.45 | 4002.0 |
| 2024-12-11 07:00:00 | AAPL | Stock | 247.49 | 247.64 | 247.49 | 247.64 | 9686.0 |
| 2024-12-11 07:30:00 | AAPL | Stock | 247.62 | 247.65 | 247.47 | 247.47 | 3208.0 |
| 2024-12-11 08:00:00 | AAPL | Stock | 247.4892 | 248.48 | 247.12 | 248.16 | 74378.0 |
| 2024-12-11 08:30:00 | AAPL | Stock | 248.28 | 248.56 | 247.9079 | 248.06 | 59062.0 |
| 2024-12-11 09:00:00 | AAPL | Stock | 248.0 | 248.94 | 247.55 | 247.94 | 222356.0 |
| 2024-12-11 09:30:00 | AAPL | Stock | 247.94 | 249.8 | 247.65 | 249.305 | 4372819.0 |
| 2024-12-11 10:00:00 | AAPL | Stock | 249.305 | 249.99 | 249.13 | 249.43 | 1881578.0 |
| 2024-12-11 10:30:00 | AAPL | Stock | 249.43 | 250.2 | 249.395 | 250.1405 | 2644272.0 |
| 2024-12-11 11:00:00 | AAPL | Stock | 250.15 | 250.8 | 249.93 | 250.45 | 2239009.0 |
| 2024-12-11 11:30:00 | AAPL | Stock | 250.42 | 250.42 | 249.34 | 249.51 | 1174032.0 |
| 2024-12-11 12:00:00 | AAPL | Stock | 249.52 | 249.84 | 249.39 | 249.6814 | 947868.0 |
| 2024-12-11 12:30:00 | AAPL | Stock | 249.68 | 249.78 | 249.09 | 249.22 | 703972.0 |
| 2024-12-11 13:00:00 | AAPL | Stock | 249.225 | 249.48 | 248.97 | 249.1 | 802274.0 |
| 2024-12-11 13:30:00 | AAPL | Stock | 249.1 | 249.17 | 248.35 | 248.3711 | 1196804.0 |
| 2024-12-11 14:00:00 | AAPL | Stock | 248.375 | 248.5799 | 248.0863 | 248.28 | 1000114.0 |
| 2024-12-11 14:30:00 | AAPL | Stock | 248.2801 | 248.44 | 247.58 | 247.815 | 1269326.0 |
| 2024-12-11 15:00:00 | AAPL | Stock | 247.815 | 247.9199 | 247.05 | 247.14 | 1627303.0 |
| 2024-12-11 15:30:00 | AAPL | Stock | 247.14 | 247.16 | 246.2601 | 246.43 | 4252842.0 |
| 2024-12-11 16:00:00 | AAPL | Stock | 246.41 | 246.75 | 246.02 | 246.66 | 7035460.0 |
| 2024-12-11 16:30:00 | AAPL | Stock | 246.6117 | 247.12 | 246.49 | 246.49 | 67898.0 |
| 2024-12-11 17:00:00 | AAPL | Stock | 246.66 | 246.69 | 246.49 | 246.66 | 516763.0 |
| 2024-12-11 17:30:00 | AAPL | Stock | 246.63 | 246.88 | 246.63 | 246.79 | 12827.0 |
| 2024-12-11 18:00:00 | AAPL | Stock | 246.79 | 246.82 | 246.5697 | 246.5697 | 13044.0 |
| 2024-12-11 18:30:00 | AAPL | Stock | 246.6807 | 246.6851 | 246.31 | 246.42 | 9814.0 |
| 2024-12-11 19:00:00 | AAPL | Stock | 246.5648 | 246.5648 | 246.36 | 246.4 | 17454.0 |
| 2024-12-11 19:30:00 | AAPL | Stock | 246.38 | 246.42 | 246.36 | 246.41 | 6274.0 |
| 2024-12-11 04:00:00 | MSFT | Stock | 442.79 | 443.48 | 441.53 | 442.5 | 5228.0 |
| 2024-12-11 04:30:00 | MSFT | Stock | 442.55 | 442.56 | 441.6 | 442.0 | 3875.0 |
| 2024-12-11 05:00:00 | MSFT | Stock | 441.72 | 442.2 | 441.6 | 441.64 | 2456.0 |
| 2024-12-11 05:30:00 | MSFT | Stock | 442.07 | 442.07 | 441.24 | 441.34 | 1773.0 |
| 2024-12-11 06:00:00 | MSFT | Stock | 441.46 | 442.1 | 441.45 | 441.63 | 2880.0 |
| 2024-12-11 06:30:00 | MSFT | Stock | 441.81 | 442.08 | 441.81 | 441.87 | 1310.0 |
| 2024-12-11 07:00:00 | MSFT | Stock | 441.88 | 443.38 | 441.88 | 443.13 | 9513.0 |
| 2024-12-11 07:30:00 | MSFT | Stock | 443.02 | 443.26 | 443.0 | 443.05 | 1726.0 |
| 2024-12-11 08:00:00 | MSFT | Stock | 442.5 | 443.7 | 441.65 | 443.5 | 14379.0 |
| 2024-12-11 08:30:00 | MSFT | Stock | 444.45 | 445.24 | 443.99 | 444.3001 | 23195.0 |
| 2024-12-11 09:00:00 | MSFT | Stock | 444.18 | 444.79 | 443.34 | 444.07 | 27792.0 |
| 2024-12-11 09:30:00 | MSFT | Stock | 444.08 | 446.44 | 444.05 | 446.15 | 1133784.0 |
| 2024-12-11 10:00:00 | MSFT | Stock | 446.08 | 448.39 | 445.45 | 447.53 | 851766.0 |
| 2024-12-11 10:30:00 | MSFT | Stock | 447.59 | 449.39 | 447.59 | 448.44 | 661941.0 |
| 2024-12-11 11:00:00 | MSFT | Stock | 448.49 | 450.35 | 448.4 | 449.9 | 1056378.0 |
| 2024-12-11 11:30:00 | MSFT | Stock | 449.89 | 450.04 | 449.0001 | 449.24 | 369731.0 |
| 2024-12-11 12:00:00 | MSFT | Stock | 449.2781 | 450.0 | 449.16 | 449.49 | 314478.0 |
| 2024-12-11 12:30:00 | MSFT | Stock | 449.4648 | 449.6294 | 448.96 | 449.4167 | 233096.0 |
> showing 50 of 107,044 rows — these rows as CSV