PREVIEW / stock_30min / 2024-11-29
file: by_date/stock_30min/2024/2024-11-29.parquet size: 1.5 MB rows: 68,778 symbols: 682
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-11-29 04:00:00 | AAPL | Stock | 235.37 | 235.37 | 234.96 | 235.2 | 4128.0 |
| 2024-11-29 04:30:00 | AAPL | Stock | 235.08 | 235.08 | 235.04 | 235.07 | 507.0 |
| 2024-11-29 05:00:00 | AAPL | Stock | 234.94 | 235.0 | 234.84 | 234.9 | 903.0 |
| 2024-11-29 05:30:00 | AAPL | Stock | 234.8 | 234.8 | 234.78 | 234.8 | 1749.0 |
| 2024-11-29 06:00:00 | AAPL | Stock | 234.63 | 234.63 | 234.63 | 234.63 | 303.0 |
| 2024-11-29 06:30:00 | AAPL | Stock | 234.59 | 234.6 | 234.4 | 234.42 | 3962.0 |
| 2024-11-29 07:00:00 | AAPL | Stock | 234.41 | 234.66 | 234.4 | 234.66 | 8947.0 |
| 2024-11-29 07:30:00 | AAPL | Stock | 234.75 | 234.8 | 234.52 | 234.58 | 8434.0 |
| 2024-11-29 08:00:00 | AAPL | Stock | 234.56 | 235.49 | 234.4001 | 234.56 | 41607.0 |
| 2024-11-29 08:30:00 | AAPL | Stock | 234.58 | 234.59 | 234.3 | 234.31 | 21444.0 |
| 2024-11-29 09:00:00 | AAPL | Stock | 234.39 | 234.91 | 234.13 | 234.85 | 70126.0 |
| 2024-11-29 09:30:00 | AAPL | Stock | 234.84 | 235.69 | 233.97 | 235.64 | 2753716.0 |
| 2024-11-29 10:00:00 | AAPL | Stock | 235.63 | 235.89 | 235.14 | 235.345 | 1421469.0 |
| 2024-11-29 10:30:00 | AAPL | Stock | 235.35 | 235.84 | 235.34 | 235.81 | 1170651.0 |
| 2024-11-29 11:00:00 | AAPL | Stock | 235.82 | 236.5999 | 235.75 | 236.4 | 1785021.0 |
| 2024-11-29 11:30:00 | AAPL | Stock | 236.38 | 237.14 | 236.29 | 237.06 | 1569339.0 |
| 2024-11-29 12:00:00 | AAPL | Stock | 237.06 | 237.15 | 236.36 | 236.36 | 1395205.0 |
| 2024-11-29 12:30:00 | AAPL | Stock | 236.37 | 237.81 | 236.37 | 237.34 | 3622613.0 |
| 2024-11-29 13:00:00 | AAPL | Stock | 237.33 | 237.9 | 237.29 | 237.49 | 6433264.0 |
| 2024-11-29 13:30:00 | AAPL | Stock | 237.49 | 237.52 | 237.33 | 237.52 | 57841.0 |
| 2024-11-29 14:00:00 | AAPL | Stock | 237.49 | 237.57 | 237.48 | 237.49 | 30964.0 |
| 2024-11-29 14:30:00 | AAPL | Stock | 237.45 | 237.5583 | 237.33 | 237.41 | 16606.0 |
| 2024-11-29 15:00:00 | AAPL | Stock | 237.4 | 237.47 | 237.4 | 237.47 | 2725.0 |
| 2024-11-29 15:30:00 | AAPL | Stock | 237.3634 | 237.5 | 237.22 | 237.5 | 25542.0 |
| 2024-11-29 16:00:00 | AAPL | Stock | 237.4 | 237.43 | 237.33 | 237.4 | 8075.0 |
| 2024-11-29 16:30:00 | AAPL | Stock | 237.39 | 237.5 | 237.32 | 237.4897 | 19374.0 |
| 2024-11-29 04:00:00 | MSFT | Stock | 421.63 | 421.63 | 420.22 | 420.3 | 3939.0 |
| 2024-11-29 04:30:00 | MSFT | Stock | 420.54 | 421.5 | 420.5 | 420.67 | 3857.0 |
| 2024-11-29 05:00:00 | MSFT | Stock | 421.0 | 421.0 | 420.9 | 420.95 | 1633.0 |
| 2024-11-29 05:30:00 | MSFT | Stock | 420.95 | 420.95 | 420.9 | 420.9 | 1236.0 |
| 2024-11-29 06:00:00 | MSFT | Stock | 420.64 | 420.64 | 420.64 | 420.64 | 100.0 |
| 2024-11-29 06:30:00 | MSFT | Stock | 420.78 | 420.84 | 420.41 | 420.5 | 1494.0 |
| 2024-11-29 07:00:00 | MSFT | Stock | 420.6 | 421.75 | 420.6 | 421.22 | 17378.0 |
| 2024-11-29 07:30:00 | MSFT | Stock | 421.28 | 421.28 | 420.78 | 420.83 | 4393.0 |
| 2024-11-29 08:00:00 | MSFT | Stock | 420.8241 | 422.25 | 420.68 | 421.11 | 13439.0 |
| 2024-11-29 08:30:00 | MSFT | Stock | 421.13 | 421.13 | 420.5 | 420.9995 | 5738.0 |
| 2024-11-29 09:00:00 | MSFT | Stock | 421.18 | 422.1352 | 419.59 | 420.19 | 34943.0 |
| 2024-11-29 09:30:00 | MSFT | Stock | 420.1 | 421.12 | 417.8 | 419.94 | 2033166.0 |
| 2024-11-29 10:00:00 | MSFT | Stock | 419.92 | 421.65 | 418.82 | 421.5334 | 961983.0 |
| 2024-11-29 10:30:00 | MSFT | Stock | 421.56 | 422.86 | 421.45 | 421.97 | 534722.0 |
| 2024-11-29 11:00:00 | MSFT | Stock | 421.93 | 423.54 | 421.93 | 423.04 | 478527.0 |
| 2024-11-29 11:30:00 | MSFT | Stock | 423.11 | 423.96 | 422.725 | 423.89 | 424346.0 |
| 2024-11-29 12:00:00 | MSFT | Stock | 423.83 | 424.7831 | 423.42 | 424.28 | 488820.0 |
| 2024-11-29 12:30:00 | MSFT | Stock | 424.24 | 424.8849 | 423.36 | 423.46 | 1186734.0 |
| 2024-11-29 13:00:00 | MSFT | Stock | 423.46 | 424.38 | 423.1745 | 423.6 | 3072041.0 |
| 2024-11-29 13:30:00 | MSFT | Stock | 423.5 | 423.55 | 423.17 | 423.17 | 2327.0 |
| 2024-11-29 14:00:00 | MSFT | Stock | 423.27 | 423.46 | 423.01 | 423.09 | 2028.0 |
| 2024-11-29 14:30:00 | MSFT | Stock | 423.09 | 423.09 | 423.0 | 423.08 | 2158.0 |
| 2024-11-29 15:00:00 | MSFT | Stock | 423.2 | 423.3129 | 423.0 | 423.0 | 1521.0 |
| 2024-11-29 15:30:00 | MSFT | Stock | 423.3081 | 423.3081 | 423.0 | 423.0 | 880.0 |
> showing 50 of 68,778 rows — these rows as CSV