PREVIEW / stock_30min / 2024-12-10
file: by_date/stock_30min/2024/2024-12-10.parquet size: 2.2 MB rows: 104,647 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-12-10 04:00:00 | AAPL | Stock | 246.6 | 247.3 | 246.53 | 247.06 | 12350.0 |
| 2024-12-10 04:30:00 | AAPL | Stock | 247.05 | 247.1 | 247.02 | 247.04 | 3774.0 |
| 2024-12-10 05:00:00 | AAPL | Stock | 247.04 | 247.17 | 247.02 | 247.17 | 3147.0 |
| 2024-12-10 05:30:00 | AAPL | Stock | 247.19 | 247.23 | 247.07 | 247.08 | 6790.0 |
| 2024-12-10 06:00:00 | AAPL | Stock | 247.09 | 247.19 | 247.09 | 247.17 | 3420.0 |
| 2024-12-10 06:30:00 | AAPL | Stock | 247.12 | 247.25 | 247.04 | 247.15 | 8996.0 |
| 2024-12-10 07:00:00 | AAPL | Stock | 247.22 | 247.51 | 247.13 | 247.51 | 19146.0 |
| 2024-12-10 07:30:00 | AAPL | Stock | 247.54 | 247.8 | 247.43 | 247.8 | 11728.0 |
| 2024-12-10 08:00:00 | AAPL | Stock | 247.2 | 248.0 | 246.134 | 247.65 | 94677.0 |
| 2024-12-10 08:30:00 | AAPL | Stock | 247.655 | 247.7299 | 247.0287 | 247.33 | 53352.0 |
| 2024-12-10 09:00:00 | AAPL | Stock | 247.38 | 247.49 | 246.7 | 246.93 | 69368.0 |
| 2024-12-10 09:30:00 | AAPL | Stock | 246.91 | 247.7871 | 245.81 | 247.655 | 3932831.0 |
| 2024-12-10 10:00:00 | AAPL | Stock | 247.64 | 247.68 | 246.6 | 246.73 | 1576701.0 |
| 2024-12-10 10:30:00 | AAPL | Stock | 246.735 | 246.92 | 245.83 | 245.8885 | 1532599.0 |
| 2024-12-10 11:00:00 | AAPL | Stock | 245.885 | 246.26 | 245.34 | 245.67 | 1286637.0 |
| 2024-12-10 11:30:00 | AAPL | Stock | 245.67 | 246.54 | 245.61 | 246.4 | 989801.0 |
| 2024-12-10 12:00:00 | AAPL | Stock | 246.41 | 247.18 | 246.4 | 247.07 | 961111.0 |
| 2024-12-10 12:30:00 | AAPL | Stock | 247.06 | 247.32 | 246.77 | 246.85 | 659661.0 |
| 2024-12-10 13:00:00 | AAPL | Stock | 246.8513 | 247.4784 | 246.72 | 247.4066 | 944361.0 |
| 2024-12-10 13:30:00 | AAPL | Stock | 247.405 | 247.78 | 247.35 | 247.6117 | 806223.0 |
| 2024-12-10 14:00:00 | AAPL | Stock | 247.62 | 247.8 | 247.37 | 247.44 | 904877.0 |
| 2024-12-10 14:30:00 | AAPL | Stock | 247.45 | 248.095 | 247.41 | 248.03 | 1405128.0 |
| 2024-12-10 15:00:00 | AAPL | Stock | 248.03 | 248.21 | 247.5 | 247.72 | 1764798.0 |
| 2024-12-10 15:30:00 | AAPL | Stock | 247.725 | 248.07 | 247.33 | 247.8 | 2582248.0 |
| 2024-12-10 16:00:00 | AAPL | Stock | 247.81 | 248.0 | 247.2994 | 247.9201 | 7513672.0 |
| 2024-12-10 16:30:00 | AAPL | Stock | 247.97 | 247.98 | 247.77 | 247.895 | 29109.0 |
| 2024-12-10 17:00:00 | AAPL | Stock | 247.9 | 247.9 | 247.7965 | 247.8692 | 8760.0 |
| 2024-12-10 17:30:00 | AAPL | Stock | 247.84 | 247.86 | 247.76 | 247.82 | 4660.0 |
| 2024-12-10 18:00:00 | AAPL | Stock | 247.82 | 247.87 | 247.69 | 247.69 | 6909.0 |
| 2024-12-10 18:30:00 | AAPL | Stock | 247.7 | 247.8 | 247.62 | 247.77 | 8237.0 |
| 2024-12-10 19:00:00 | AAPL | Stock | 247.77 | 247.77 | 247.61 | 247.62 | 2783.0 |
| 2024-12-10 19:30:00 | AAPL | Stock | 247.68 | 247.72 | 247.556 | 247.7 | 9757.0 |
| 2024-12-10 04:00:00 | MSFT | Stock | 444.32 | 444.32 | 442.84 | 443.42 | 3259.0 |
| 2024-12-10 04:30:00 | MSFT | Stock | 443.18 | 443.35 | 443.11 | 443.11 | 1600.0 |
| 2024-12-10 05:00:00 | MSFT | Stock | 443.51 | 443.75 | 443.5 | 443.74 | 1009.0 |
| 2024-12-10 05:30:00 | MSFT | Stock | 443.78 | 443.89 | 443.4 | 443.45 | 4375.0 |
| 2024-12-10 06:00:00 | MSFT | Stock | 443.52 | 443.87 | 443.52 | 443.81 | 1156.0 |
| 2024-12-10 06:30:00 | MSFT | Stock | 443.84 | 444.23 | 443.79 | 443.86 | 2815.0 |
| 2024-12-10 07:00:00 | MSFT | Stock | 444.0 | 444.67 | 443.85 | 444.54 | 5210.0 |
| 2024-12-10 07:30:00 | MSFT | Stock | 444.5 | 444.5 | 444.2 | 444.2 | 2033.0 |
| 2024-12-10 08:00:00 | MSFT | Stock | 444.7 | 444.905 | 443.0119 | 444.22 | 28920.0 |
| 2024-12-10 08:30:00 | MSFT | Stock | 443.92 | 444.2 | 442.53 | 442.71 | 16774.0 |
| 2024-12-10 09:00:00 | MSFT | Stock | 442.98 | 444.69 | 442.46 | 444.6 | 51487.0 |
| 2024-12-10 09:30:00 | MSFT | Stock | 444.39 | 448.35 | 443.87 | 448.11 | 1364848.0 |
| 2024-12-10 10:00:00 | MSFT | Stock | 448.21 | 449.62 | 447.92 | 448.2101 | 692959.0 |
| 2024-12-10 10:30:00 | MSFT | Stock | 448.21 | 449.3 | 447.49 | 447.9982 | 498171.0 |
| 2024-12-10 11:00:00 | MSFT | Stock | 447.975 | 447.98 | 446.05 | 446.46 | 493358.0 |
| 2024-12-10 11:30:00 | MSFT | Stock | 446.455 | 447.71 | 445.55 | 446.39 | 464941.0 |
| 2024-12-10 12:00:00 | MSFT | Stock | 446.38 | 447.69 | 445.72 | 447.025 | 351886.0 |
| 2024-12-10 12:30:00 | MSFT | Stock | 447.025 | 447.5 | 445.51 | 445.86 | 215120.0 |
> showing 50 of 104,647 rows — these rows as CSV