PREVIEW / stock_30min / 2024-12-05
file: by_date/stock_30min/2024/2024-12-05.parquet size: 2.2 MB rows: 105,950 symbols: 688
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-05 04:00:00 | AAPL | Stock | 242.53 | 242.75 | 242.1 | 242.75 | 10699.0 |
| 2024-12-05 04:30:00 | AAPL | Stock | 242.93 | 243.0 | 242.78 | 242.95 | 8457.0 |
| 2024-12-05 05:00:00 | AAPL | Stock | 242.99 | 243.17 | 242.99 | 243.17 | 2922.0 |
| 2024-12-05 05:30:00 | AAPL | Stock | 243.09 | 243.15 | 243.0 | 243.0 | 3932.0 |
| 2024-12-05 06:00:00 | AAPL | Stock | 243.0 | 243.05 | 242.99 | 243.05 | 3120.0 |
| 2024-12-05 06:30:00 | AAPL | Stock | 243.01 | 243.01 | 243.0 | 243.0 | 3236.0 |
| 2024-12-05 07:00:00 | AAPL | Stock | 243.03 | 243.2 | 243.03 | 243.1 | 4708.0 |
| 2024-12-05 07:30:00 | AAPL | Stock | 243.11 | 243.17 | 243.03 | 243.14 | 3525.0 |
| 2024-12-05 08:00:00 | AAPL | Stock | 243.08 | 243.2651 | 242.15 | 243.0 | 39798.0 |
| 2024-12-05 08:30:00 | AAPL | Stock | 243.0 | 243.2 | 243.0 | 243.01 | 14887.0 |
| 2024-12-05 09:00:00 | AAPL | Stock | 243.05 | 244.2767 | 243.04 | 244.04 | 111587.0 |
| 2024-12-05 09:30:00 | AAPL | Stock | 243.99 | 244.54 | 242.7128 | 243.47 | 3720099.0 |
| 2024-12-05 10:00:00 | AAPL | Stock | 243.455 | 243.57 | 242.76 | 242.92 | 2074796.0 |
| 2024-12-05 10:30:00 | AAPL | Stock | 242.93 | 243.08 | 242.24 | 242.35 | 1484750.0 |
| 2024-12-05 11:00:00 | AAPL | Stock | 242.37 | 242.77 | 242.21 | 242.55 | 1058756.0 |
| 2024-12-05 11:30:00 | AAPL | Stock | 242.54 | 242.6699 | 242.31 | 242.63 | 897872.0 |
| 2024-12-05 12:00:00 | AAPL | Stock | 242.625 | 243.4099 | 242.46 | 243.36 | 1310552.0 |
| 2024-12-05 12:30:00 | AAPL | Stock | 243.3583 | 243.37 | 242.79 | 242.89 | 914360.0 |
| 2024-12-05 13:00:00 | AAPL | Stock | 242.89 | 243.25 | 242.61 | 242.885 | 915944.0 |
| 2024-12-05 13:30:00 | AAPL | Stock | 242.89 | 243.3227 | 242.84 | 243.215 | 690697.0 |
| 2024-12-05 14:00:00 | AAPL | Stock | 243.2299 | 243.69 | 243.0 | 243.28 | 899133.0 |
| 2024-12-05 14:30:00 | AAPL | Stock | 243.285 | 243.36 | 242.96 | 243.115 | 711285.0 |
| 2024-12-05 15:00:00 | AAPL | Stock | 243.12 | 243.27 | 242.745 | 242.9058 | 1210864.0 |
| 2024-12-05 15:30:00 | AAPL | Stock | 242.905 | 243.09 | 242.13 | 243.08 | 2854154.0 |
| 2024-12-05 16:00:00 | AAPL | Stock | 243.04 | 243.06 | 242.65 | 242.9517 | 6100612.0 |
| 2024-12-05 16:30:00 | AAPL | Stock | 242.83 | 243.04 | 242.7814 | 242.9 | 28682.0 |
| 2024-12-05 17:00:00 | AAPL | Stock | 242.8247 | 243.04 | 242.7 | 242.7 | 17626.0 |
| 2024-12-05 17:30:00 | AAPL | Stock | 242.76 | 242.86 | 242.71 | 242.86 | 3321.0 |
| 2024-12-05 18:00:00 | AAPL | Stock | 242.86 | 242.96 | 242.34 | 242.85 | 7450.0 |
| 2024-12-05 18:30:00 | AAPL | Stock | 242.82 | 243.04 | 242.8 | 242.95 | 7157.0 |
| 2024-12-05 19:00:00 | AAPL | Stock | 242.92 | 242.92 | 242.92 | 242.92 | 102.0 |
| 2024-12-05 19:30:00 | AAPL | Stock | 242.87 | 242.96 | 242.8395 | 242.93 | 1339.0 |
| 2024-12-05 04:00:00 | MSFT | Stock | 438.47 | 438.53 | 437.5 | 438.5 | 6209.0 |
| 2024-12-05 04:30:00 | MSFT | Stock | 438.47 | 438.63 | 438.47 | 438.48 | 1910.0 |
| 2024-12-05 05:00:00 | MSFT | Stock | 438.65 | 438.93 | 438.65 | 438.92 | 534.0 |
| 2024-12-05 05:30:00 | MSFT | Stock | 438.89 | 439.0 | 438.45 | 438.45 | 2349.0 |
| 2024-12-05 06:00:00 | MSFT | Stock | 438.35 | 438.36 | 437.5 | 437.61 | 6629.0 |
| 2024-12-05 06:30:00 | MSFT | Stock | 437.88 | 437.9 | 437.67 | 437.9 | 2385.0 |
| 2024-12-05 07:00:00 | MSFT | Stock | 437.8 | 438.4 | 437.8 | 438.21 | 4536.0 |
| 2024-12-05 07:30:00 | MSFT | Stock | 438.22 | 438.43 | 438.08 | 438.43 | 1767.0 |
| 2024-12-05 08:00:00 | MSFT | Stock | 438.0 | 438.48 | 437.2 | 438.12 | 14645.0 |
| 2024-12-05 08:30:00 | MSFT | Stock | 438.08 | 438.24 | 437.5 | 437.87 | 5884.0 |
| 2024-12-05 09:00:00 | MSFT | Stock | 437.87 | 438.27 | 437.75 | 437.76 | 4484.0 |
| 2024-12-05 09:30:00 | MSFT | Stock | 438.3 | 439.94 | 436.3 | 437.29 | 1423860.0 |
| 2024-12-05 10:00:00 | MSFT | Stock | 437.245 | 438.29 | 436.171 | 438.0 | 573203.0 |
| 2024-12-05 10:30:00 | MSFT | Stock | 438.11 | 439.19 | 437.8646 | 438.62 | 541412.0 |
| 2024-12-05 11:00:00 | MSFT | Stock | 438.66 | 439.88 | 438.2737 | 439.64 | 497815.0 |
| 2024-12-05 11:30:00 | MSFT | Stock | 439.665 | 441.58 | 439.29 | 441.4 | 863416.0 |
| 2024-12-05 12:00:00 | MSFT | Stock | 441.37 | 443.81 | 441.19 | 442.845 | 900336.0 |
| 2024-12-05 12:30:00 | MSFT | Stock | 442.84 | 444.06 | 442.36 | 443.945 | 578419.0 |
> showing 50 of 105,950 rows — these rows as CSV