PREVIEW / stock_30min / 2024-12-06
file: by_date/stock_30min/2024/2024-12-06.parquet size: 2.2 MB rows: 104,856 symbols: 689
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-06 04:00:00 | AAPL | Stock | 242.97 | 243.1 | 242.81 | 242.89 | 4026.0 |
| 2024-12-06 05:00:00 | AAPL | Stock | 242.73 | 242.73 | 242.69 | 242.7 | 1300.0 |
| 2024-12-06 05:30:00 | AAPL | Stock | 242.78 | 242.78 | 242.72 | 242.72 | 400.0 |
| 2024-12-06 06:00:00 | AAPL | Stock | 242.69 | 242.69 | 242.55 | 242.57 | 1208.0 |
| 2024-12-06 06:30:00 | AAPL | Stock | 242.63 | 242.64 | 242.52 | 242.53 | 1023.0 |
| 2024-12-06 07:00:00 | AAPL | Stock | 242.62 | 242.95 | 242.62 | 242.87 | 7740.0 |
| 2024-12-06 07:30:00 | AAPL | Stock | 242.78 | 242.9 | 242.75 | 242.85 | 3930.0 |
| 2024-12-06 08:00:00 | AAPL | Stock | 242.79 | 243.04 | 242.41 | 242.65 | 28130.0 |
| 2024-12-06 08:30:00 | AAPL | Stock | 242.92 | 243.18 | 242.65 | 242.87 | 46948.0 |
| 2024-12-06 09:00:00 | AAPL | Stock | 242.86 | 243.23 | 242.65 | 242.9258 | 74980.0 |
| 2024-12-06 09:30:00 | AAPL | Stock | 242.905 | 244.2 | 242.08 | 243.64 | 3649449.0 |
| 2024-12-06 10:00:00 | AAPL | Stock | 243.67 | 244.63 | 243.0 | 243.44 | 2256044.0 |
| 2024-12-06 10:30:00 | AAPL | Stock | 243.45 | 243.74 | 243.275 | 243.5986 | 1139820.0 |
| 2024-12-06 11:00:00 | AAPL | Stock | 243.6 | 244.1 | 243.51 | 243.582 | 1126335.0 |
| 2024-12-06 11:30:00 | AAPL | Stock | 243.58 | 243.84 | 243.57 | 243.65 | 910576.0 |
| 2024-12-06 12:00:00 | AAPL | Stock | 243.66 | 243.73 | 243.21 | 243.6 | 1077652.0 |
| 2024-12-06 12:30:00 | AAPL | Stock | 243.6 | 243.615 | 242.94 | 243.06 | 1099824.0 |
| 2024-12-06 13:00:00 | AAPL | Stock | 243.05 | 243.355 | 242.94 | 243.26 | 659961.0 |
| 2024-12-06 13:30:00 | AAPL | Stock | 243.26 | 243.64 | 243.04 | 243.63 | 730375.0 |
| 2024-12-06 14:00:00 | AAPL | Stock | 243.62 | 243.63 | 243.1 | 243.1627 | 1076901.0 |
| 2024-12-06 14:30:00 | AAPL | Stock | 243.16 | 243.28 | 242.912 | 242.9601 | 930491.0 |
| 2024-12-06 15:00:00 | AAPL | Stock | 242.95 | 243.4 | 242.87 | 243.05 | 1007622.0 |
| 2024-12-06 15:30:00 | AAPL | Stock | 243.05 | 243.16 | 242.2 | 242.86 | 3542169.0 |
| 2024-12-06 16:00:00 | AAPL | Stock | 242.84 | 242.84 | 242.28 | 242.52 | 7570895.0 |
| 2024-12-06 16:30:00 | AAPL | Stock | 242.51 | 242.84 | 242.4 | 242.55 | 39013.0 |
| 2024-12-06 17:00:00 | AAPL | Stock | 242.58 | 242.6 | 242.41 | 242.46 | 6436.0 |
| 2024-12-06 17:30:00 | AAPL | Stock | 242.43 | 242.44 | 242.3 | 242.37 | 7515.0 |
| 2024-12-06 18:00:00 | AAPL | Stock | 242.37 | 242.44 | 242.31 | 242.44 | 3410.0 |
| 2024-12-06 18:30:00 | AAPL | Stock | 242.44 | 242.44 | 242.4 | 242.41 | 1614.0 |
| 2024-12-06 19:00:00 | AAPL | Stock | 242.4 | 242.4 | 242.31 | 242.3999 | 2686.0 |
| 2024-12-06 19:30:00 | AAPL | Stock | 242.32 | 242.4055 | 242.3025 | 242.3025 | 3691.0 |
| 2024-12-06 04:00:00 | MSFT | Stock | 442.0 | 442.0 | 440.75 | 440.79 | 4900.0 |
| 2024-12-06 04:30:00 | MSFT | Stock | 440.75 | 441.33 | 440.64 | 440.89 | 5752.0 |
| 2024-12-06 05:00:00 | MSFT | Stock | 440.85 | 441.11 | 440.7 | 440.9 | 4054.0 |
| 2024-12-06 05:30:00 | MSFT | Stock | 441.06 | 441.06 | 440.5 | 440.5 | 1183.0 |
| 2024-12-06 06:00:00 | MSFT | Stock | 440.66 | 441.17 | 440.6 | 441.0 | 5632.0 |
| 2024-12-06 06:30:00 | MSFT | Stock | 441.58 | 441.91 | 441.3 | 441.83 | 1590.0 |
| 2024-12-06 07:00:00 | MSFT | Stock | 441.97 | 443.55 | 441.97 | 443.37 | 24738.0 |
| 2024-12-06 07:30:00 | MSFT | Stock | 443.56 | 445.05 | 443.43 | 443.43 | 19296.0 |
| 2024-12-06 08:00:00 | MSFT | Stock | 444.2 | 445.2 | 440.49 | 444.28 | 25219.0 |
| 2024-12-06 08:30:00 | MSFT | Stock | 444.55 | 445.61 | 444.0152 | 444.6 | 54852.0 |
| 2024-12-06 09:00:00 | MSFT | Stock | 444.39 | 444.9 | 441.5 | 442.25 | 30768.0 |
| 2024-12-06 09:30:00 | MSFT | Stock | 442.24 | 446.1 | 442.0 | 445.31 | 1327235.0 |
| 2024-12-06 10:00:00 | MSFT | Stock | 445.345 | 445.65 | 443.26 | 444.84 | 768327.0 |
| 2024-12-06 10:30:00 | MSFT | Stock | 444.855 | 444.855 | 442.8 | 443.34 | 422382.0 |
| 2024-12-06 11:00:00 | MSFT | Stock | 443.37 | 444.614 | 442.65 | 444.315 | 527011.0 |
| 2024-12-06 11:30:00 | MSFT | Stock | 444.325 | 444.67 | 442.6807 | 442.805 | 355187.0 |
| 2024-12-06 12:00:00 | MSFT | Stock | 442.87 | 443.7 | 441.7703 | 442.97 | 519568.0 |
| 2024-12-06 12:30:00 | MSFT | Stock | 443.01 | 443.59 | 442.37 | 442.4 | 257314.0 |
| 2024-12-06 13:00:00 | MSFT | Stock | 442.37 | 443.8799 | 442.21 | 443.3 | 305198.0 |
> showing 50 of 104,856 rows — these rows as CSV