PREVIEW / stock_1hour / 2025-11-06
file: by_date/stock_1hour/2025/2025-11-06.parquet size: 1.4 MB rows: 63,861 symbols: 216
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 |
|---|---|---|---|---|---|---|---|
| 2025-11-06 04:00:00 | AAPL | Stock | 269.05 | 269.79 | 269.04 | 269.44 | 8349.0 |
| 2025-11-06 05:00:00 | AAPL | Stock | 269.34 | 269.76 | 269.23 | 269.27 | 8036.0 |
| 2025-11-06 06:00:00 | AAPL | Stock | 269.24 | 269.7 | 269.2 | 269.33 | 5749.0 |
| 2025-11-06 07:00:00 | AAPL | Stock | 269.25 | 269.52 | 269.11 | 269.44 | 6705.0 |
| 2025-11-06 08:00:00 | AAPL | Stock | 269.26 | 270.45 | 268.5 | 269.7 | 73812.0 |
| 2025-11-06 09:00:00 | AAPL | Stock | 269.701 | 270.01 | 267.89 | 269.941 | 3443000.0 |
| 2025-11-06 10:00:00 | AAPL | Stock | 269.94 | 273.4 | 269.0914 | 272.28 | 6931661.0 |
| 2025-11-06 11:00:00 | AAPL | Stock | 272.285 | 272.6593 | 270.54 | 270.58 | 3666058.0 |
| 2025-11-06 12:00:00 | AAPL | Stock | 270.6 | 272.565 | 270.39 | 272.275 | 2764524.0 |
| 2025-11-06 13:00:00 | AAPL | Stock | 272.275 | 272.46 | 270.92 | 271.3954 | 2186967.0 |
| 2025-11-06 14:00:00 | AAPL | Stock | 271.41 | 272.2 | 270.735 | 271.2356 | 2096557.0 |
| 2025-11-06 15:00:00 | AAPL | Stock | 271.25 | 271.67 | 269.56 | 269.66 | 4578010.0 |
| 2025-11-06 16:00:00 | AAPL | Stock | 269.8 | 270.37 | 269.631 | 270.21 | 9323684.0 |
| 2025-11-06 17:00:00 | AAPL | Stock | 270.2 | 270.3389 | 269.846 | 269.87 | 16930.0 |
| 2025-11-06 18:00:00 | AAPL | Stock | 269.96 | 270.27 | 269.6321 | 270.15 | 16606.0 |
| 2025-11-06 19:00:00 | AAPL | Stock | 270.01 | 270.5 | 269.8 | 270.15 | 19319.0 |
| 2025-11-06 04:00:00 | MSFT | Stock | 505.3 | 506.3 | 505.21 | 505.9 | 9084.0 |
| 2025-11-06 05:00:00 | MSFT | Stock | 506.0 | 506.6 | 505.28 | 505.81 | 4042.0 |
| 2025-11-06 06:00:00 | MSFT | Stock | 505.77 | 506.54 | 505.67 | 506.2 | 7693.0 |
| 2025-11-06 07:00:00 | MSFT | Stock | 506.11 | 506.45 | 506.1 | 506.45 | 8569.0 |
| 2025-11-06 08:00:00 | MSFT | Stock | 506.29 | 507.6 | 505.0 | 506.6 | 75584.0 |
| 2025-11-06 09:00:00 | MSFT | Stock | 506.5 | 506.89 | 498.5 | 499.2005 | 3024435.0 |
| 2025-11-06 10:00:00 | MSFT | Stock | 499.15 | 501.945 | 495.81 | 496.23 | 3261954.0 |
| 2025-11-06 11:00:00 | MSFT | Stock | 496.295 | 498.55 | 496.05 | 497.93 | 1715002.0 |
| 2025-11-06 12:00:00 | MSFT | Stock | 497.94 | 498.53 | 496.92 | 498.02 | 1219983.0 |
| 2025-11-06 13:00:00 | MSFT | Stock | 498.01 | 499.4792 | 496.45 | 498.62 | 1186787.0 |
| 2025-11-06 14:00:00 | MSFT | Stock | 498.61 | 500.68 | 498.11 | 500.17 | 1309096.0 |
| 2025-11-06 15:00:00 | MSFT | Stock | 500.17 | 500.32 | 496.15 | 497.36 | 3602064.0 |
| 2025-11-06 16:00:00 | MSFT | Stock | 497.38 | 497.85 | 496.5 | 497.73 | 3795732.0 |
| 2025-11-06 17:00:00 | MSFT | Stock | 497.6 | 497.85 | 497.15 | 497.36 | 17820.0 |
| 2025-11-06 18:00:00 | MSFT | Stock | 497.3901 | 497.8 | 497.12 | 497.6 | 12298.0 |
| 2025-11-06 19:00:00 | MSFT | Stock | 497.58 | 498.22 | 497.32 | 497.52 | 12588.0 |
| 2025-11-06 04:00:00 | NVDA | Stock | 196.94 | 197.96 | 196.92 | 197.5 | 253743.0 |
| 2025-11-06 05:00:00 | NVDA | Stock | 197.52 | 198.3 | 197.36 | 197.87 | 173832.0 |
| 2025-11-06 06:00:00 | NVDA | Stock | 197.85 | 198.33 | 197.83 | 198.08 | 164776.0 |
| 2025-11-06 07:00:00 | NVDA | Stock | 198.0 | 198.54 | 197.84 | 197.92 | 366502.0 |
| 2025-11-06 08:00:00 | NVDA | Stock | 197.78 | 198.52 | 195.21 | 196.71 | 1789281.0 |
| 2025-11-06 09:00:00 | NVDA | Stock | 196.72 | 197.62 | 193.165 | 193.6159 | 21175305.0 |
| 2025-11-06 10:00:00 | NVDA | Stock | 193.61 | 193.75 | 189.0 | 190.36 | 30725623.0 |
| 2025-11-06 11:00:00 | NVDA | Stock | 190.36 | 191.44 | 187.94 | 189.01 | 23350952.0 |
| 2025-11-06 12:00:00 | NVDA | Stock | 189.02 | 189.76 | 186.38 | 189.1701 | 22855740.0 |
| 2025-11-06 13:00:00 | NVDA | Stock | 189.17 | 189.97 | 187.85 | 188.758 | 15045434.0 |
| 2025-11-06 14:00:00 | NVDA | Stock | 188.76 | 190.69 | 188.5 | 190.39 | 15663085.0 |
| 2025-11-06 15:00:00 | NVDA | Stock | 190.37 | 190.5094 | 187.07 | 188.17 | 21927077.0 |
| 2025-11-06 16:00:00 | NVDA | Stock | 188.08 | 189.31 | 187.96 | 189.25 | 16292292.0 |
| 2025-11-06 17:00:00 | NVDA | Stock | 189.25 | 189.33 | 188.5 | 188.5234 | 343635.0 |
| 2025-11-06 18:00:00 | NVDA | Stock | 188.55 | 189.05 | 188.48 | 188.9697 | 266295.0 |
| 2025-11-06 19:00:00 | NVDA | Stock | 188.9503 | 189.89 | 188.7 | 189.6792 | 430219.0 |
| 2025-11-06 04:00:00 | AMZN | Stock | 249.55 | 249.9 | 249.3 | 249.9 | 6157.0 |
| 2025-11-06 05:00:00 | AMZN | Stock | 249.88 | 250.22 | 249.75 | 250.22 | 8098.0 |
> showing 50 of 63,861 rows — these rows as CSV