PREVIEW / stock_1hour / 2025-10-31
file: by_date/stock_1hour/2025/2025-10-31.parquet size: 1.4 MB rows: 63,666 symbols: 219
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-10-31 04:00:00 | AAPL | Stock | 278.12 | 278.75 | 275.0 | 276.23 | 90962.0 |
| 2025-10-31 05:00:00 | AAPL | Stock | 276.45 | 277.0 | 275.56 | 276.17 | 41361.0 |
| 2025-10-31 06:00:00 | AAPL | Stock | 276.44 | 277.02 | 275.82 | 276.75 | 31617.0 |
| 2025-10-31 07:00:00 | AAPL | Stock | 276.75 | 278.0 | 276.31 | 277.11 | 200061.0 |
| 2025-10-31 08:00:00 | AAPL | Stock | 278.2 | 279.5 | 275.6 | 276.9 | 508151.0 |
| 2025-10-31 09:00:00 | AAPL | Stock | 276.91 | 277.69 | 269.16 | 270.437 | 12280150.0 |
| 2025-10-31 10:00:00 | AAPL | Stock | 270.435 | 271.5599 | 269.16 | 270.59 | 6323035.0 |
| 2025-10-31 11:00:00 | AAPL | Stock | 270.6 | 271.55 | 270.22 | 271.45 | 4088339.0 |
| 2025-10-31 12:00:00 | AAPL | Stock | 271.44 | 273.17 | 270.73 | 271.62 | 4749440.0 |
| 2025-10-31 13:00:00 | AAPL | Stock | 271.64 | 271.79 | 270.11 | 271.37 | 2925300.0 |
| 2025-10-31 14:00:00 | AAPL | Stock | 271.36 | 272.12 | 271.2205 | 271.67 | 2367559.0 |
| 2025-10-31 15:00:00 | AAPL | Stock | 271.7 | 272.65 | 269.96 | 270.25 | 8379671.0 |
| 2025-10-31 16:00:00 | AAPL | Stock | 270.25 | 271.32 | 270.24 | 270.404 | 11631564.0 |
| 2025-10-31 17:00:00 | AAPL | Stock | 270.4001 | 270.45 | 270.0 | 270.25 | 45506.0 |
| 2025-10-31 18:00:00 | AAPL | Stock | 270.26 | 270.26 | 270.01 | 270.0106 | 29321.0 |
| 2025-10-31 19:00:00 | AAPL | Stock | 270.1 | 270.14 | 269.9 | 270.04 | 27137.0 |
| 2025-10-31 04:00:00 | MSFT | Stock | 527.53 | 527.85 | 525.85 | 527.8 | 8977.0 |
| 2025-10-31 05:00:00 | MSFT | Stock | 527.4 | 528.08 | 527.3 | 527.95 | 25475.0 |
| 2025-10-31 06:00:00 | MSFT | Stock | 527.76 | 528.11 | 527.44 | 527.44 | 9668.0 |
| 2025-10-31 07:00:00 | MSFT | Stock | 527.64 | 528.45 | 527.26 | 528.28 | 22541.0 |
| 2025-10-31 08:00:00 | MSFT | Stock | 527.53 | 530.5146 | 526.01 | 529.41 | 106527.0 |
| 2025-10-31 09:00:00 | MSFT | Stock | 529.3 | 530.8802 | 517.82 | 519.24 | 2830639.0 |
| 2025-10-31 10:00:00 | MSFT | Stock | 519.27 | 521.0 | 515.1 | 520.94 | 3662284.0 |
| 2025-10-31 11:00:00 | MSFT | Stock | 520.9175 | 522.0 | 516.46 | 516.644 | 2210564.0 |
| 2025-10-31 12:00:00 | MSFT | Stock | 516.59 | 518.6396 | 515.9 | 517.265 | 1312367.0 |
| 2025-10-31 13:00:00 | MSFT | Stock | 517.29 | 517.5 | 515.9201 | 516.685 | 1071438.0 |
| 2025-10-31 14:00:00 | MSFT | Stock | 516.67 | 518.42 | 516.08 | 517.29 | 1124881.0 |
| 2025-10-31 15:00:00 | MSFT | Stock | 517.26 | 519.62 | 516.87 | 517.82 | 2953363.0 |
| 2025-10-31 16:00:00 | MSFT | Stock | 517.82 | 518.49 | 517.22 | 517.6 | 5027564.0 |
| 2025-10-31 17:00:00 | MSFT | Stock | 517.7 | 518.09 | 517.25 | 517.55 | 24470.0 |
| 2025-10-31 18:00:00 | MSFT | Stock | 517.53 | 517.8647 | 517.51 | 517.7 | 7494.0 |
| 2025-10-31 19:00:00 | MSFT | Stock | 517.7299 | 517.8889 | 517.69 | 517.71 | 4034.0 |
| 2025-10-31 04:00:00 | NVDA | Stock | 205.89 | 207.03 | 205.39 | 206.61 | 430936.0 |
| 2025-10-31 05:00:00 | NVDA | Stock | 206.61 | 207.12 | 206.41 | 207.12 | 213278.0 |
| 2025-10-31 06:00:00 | NVDA | Stock | 207.15 | 207.44 | 206.72 | 206.75 | 406910.0 |
| 2025-10-31 07:00:00 | NVDA | Stock | 206.72 | 207.23 | 206.19 | 207.12 | 476088.0 |
| 2025-10-31 08:00:00 | NVDA | Stock | 206.8 | 207.5 | 204.51 | 206.7968 | 1889902.0 |
| 2025-10-31 09:00:00 | NVDA | Stock | 206.75 | 207.97 | 205.1 | 205.22 | 16976820.0 |
| 2025-10-31 10:00:00 | NVDA | Stock | 205.225 | 206.62 | 204.62 | 206.4751 | 17903472.0 |
| 2025-10-31 11:00:00 | NVDA | Stock | 206.47 | 206.6 | 203.76 | 203.775 | 14531051.0 |
| 2025-10-31 12:00:00 | NVDA | Stock | 203.77 | 204.38 | 202.5601 | 202.755 | 14789843.0 |
| 2025-10-31 13:00:00 | NVDA | Stock | 202.75 | 203.95 | 202.07 | 203.255 | 11974134.0 |
| 2025-10-31 14:00:00 | NVDA | Stock | 203.26 | 204.38 | 203.2401 | 203.76 | 9614959.0 |
| 2025-10-31 15:00:00 | NVDA | Stock | 203.76 | 204.77 | 202.381 | 202.41 | 18758978.0 |
| 2025-10-31 16:00:00 | NVDA | Stock | 202.41 | 202.93 | 202.289 | 202.5 | 18047118.0 |
| 2025-10-31 17:00:00 | NVDA | Stock | 202.49 | 202.88 | 202.45 | 202.8503 | 298231.0 |
| 2025-10-31 18:00:00 | NVDA | Stock | 202.85 | 202.86 | 202.65 | 202.76 | 79642.0 |
| 2025-10-31 19:00:00 | NVDA | Stock | 202.77 | 202.8 | 202.52 | 202.62 | 149984.0 |
| 2025-10-31 04:00:00 | AMZN | Stock | 249.9 | 251.37 | 248.16 | 250.5 | 664575.0 |
| 2025-10-31 05:00:00 | AMZN | Stock | 250.48 | 251.88 | 250.17 | 251.0 | 325167.0 |
> showing 50 of 63,666 rows — these rows as CSV