PREVIEW / stock_1hour / 2025-10-21
file: by_date/stock_1hour/2025/2025-10-21.parquet size: 1.4 MB rows: 64,347 symbols: 227
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-21 04:00:00 | AAPL | Stock | 262.26 | 262.26 | 260.91 | 261.41 | 27554.0 |
| 2025-10-21 05:00:00 | AAPL | Stock | 261.6 | 261.89 | 261.43 | 261.78 | 18904.0 |
| 2025-10-21 06:00:00 | AAPL | Stock | 261.87 | 262.05 | 260.69 | 261.31 | 56131.0 |
| 2025-10-21 07:00:00 | AAPL | Stock | 261.35 | 262.029 | 261.35 | 261.809 | 78661.0 |
| 2025-10-21 08:00:00 | AAPL | Stock | 261.11 | 262.57 | 260.75 | 261.45 | 233913.0 |
| 2025-10-21 09:00:00 | AAPL | Stock | 261.44 | 265.29 | 261.3 | 263.805 | 9698529.0 |
| 2025-10-21 10:00:00 | AAPL | Stock | 263.79 | 264.64 | 262.53 | 263.0499 | 4876814.0 |
| 2025-10-21 11:00:00 | AAPL | Stock | 263.08 | 264.535 | 262.5 | 264.12 | 3408995.0 |
| 2025-10-21 12:00:00 | AAPL | Stock | 264.11 | 264.387 | 262.85 | 263.07 | 2392555.0 |
| 2025-10-21 13:00:00 | AAPL | Stock | 263.065 | 263.9 | 262.835 | 263.77 | 1796481.0 |
| 2025-10-21 14:00:00 | AAPL | Stock | 263.7783 | 264.055 | 262.15 | 263.42 | 2665994.0 |
| 2025-10-21 15:00:00 | AAPL | Stock | 263.43 | 263.57 | 262.47 | 262.84 | 4058709.0 |
| 2025-10-21 16:00:00 | AAPL | Stock | 262.77 | 263.15 | 262.57 | 262.98 | 4739242.0 |
| 2025-10-21 17:00:00 | AAPL | Stock | 262.8501 | 263.0 | 262.65 | 262.66 | 29677.0 |
| 2025-10-21 18:00:00 | AAPL | Stock | 262.73 | 262.73 | 262.5 | 262.66 | 10609.0 |
| 2025-10-21 19:00:00 | AAPL | Stock | 262.63 | 262.66 | 262.4 | 262.4 | 19725.0 |
| 2025-10-21 04:00:00 | MSFT | Stock | 517.13 | 517.13 | 516.8 | 516.93 | 635.0 |
| 2025-10-21 05:00:00 | MSFT | Stock | 516.8 | 517.08 | 516.8 | 517.08 | 651.0 |
| 2025-10-21 06:00:00 | MSFT | Stock | 516.94 | 517.49 | 516.94 | 517.48 | 753.0 |
| 2025-10-21 07:00:00 | MSFT | Stock | 517.12 | 517.39 | 517.0 | 517.1 | 1397.0 |
| 2025-10-21 08:00:00 | MSFT | Stock | 517.11 | 517.58 | 516.38 | 517.15 | 15023.0 |
| 2025-10-21 09:00:00 | MSFT | Stock | 517.5 | 518.69 | 516.23 | 517.88 | 974526.0 |
| 2025-10-21 10:00:00 | MSFT | Stock | 517.99 | 518.28 | 514.1 | 516.5125 | 1148942.0 |
| 2025-10-21 11:00:00 | MSFT | Stock | 516.515 | 517.56 | 515.6 | 515.7646 | 737173.0 |
| 2025-10-21 12:00:00 | MSFT | Stock | 515.765 | 516.14 | 514.34 | 514.45 | 678680.0 |
| 2025-10-21 13:00:00 | MSFT | Stock | 514.4 | 515.01 | 513.04 | 514.9 | 1074775.0 |
| 2025-10-21 14:00:00 | MSFT | Stock | 514.9 | 517.19 | 514.895 | 517.1027 | 817417.0 |
| 2025-10-21 15:00:00 | MSFT | Stock | 517.05 | 518.35 | 516.41 | 517.77 | 1343401.0 |
| 2025-10-21 16:00:00 | MSFT | Stock | 517.66 | 518.0 | 516.48 | 516.8 | 2704641.0 |
| 2025-10-21 17:00:00 | MSFT | Stock | 516.5 | 517.66 | 516.5 | 516.7 | 2819.0 |
| 2025-10-21 18:00:00 | MSFT | Stock | 516.87 | 517.25 | 516.5 | 516.88 | 1630.0 |
| 2025-10-21 19:00:00 | MSFT | Stock | 517.56 | 517.66 | 516.96 | 516.96 | 1655.0 |
| 2025-10-21 04:00:00 | NVDA | Stock | 182.45 | 182.93 | 182.14 | 182.28 | 168525.0 |
| 2025-10-21 05:00:00 | NVDA | Stock | 182.29 | 182.53 | 182.0 | 182.25 | 153990.0 |
| 2025-10-21 06:00:00 | NVDA | Stock | 182.22 | 182.52 | 182.22 | 182.52 | 72773.0 |
| 2025-10-21 07:00:00 | NVDA | Stock | 182.5 | 183.02 | 182.48 | 182.96 | 238047.0 |
| 2025-10-21 08:00:00 | NVDA | Stock | 182.95 | 183.2994 | 182.08 | 183.07 | 911285.0 |
| 2025-10-21 09:00:00 | NVDA | Stock | 183.05 | 183.15 | 180.66 | 180.94 | 15232440.0 |
| 2025-10-21 10:00:00 | NVDA | Stock | 180.955 | 181.41 | 179.8 | 181.315 | 21542864.0 |
| 2025-10-21 11:00:00 | NVDA | Stock | 181.32 | 182.305 | 181.14 | 182.185 | 12592419.0 |
| 2025-10-21 12:00:00 | NVDA | Stock | 182.18 | 182.651 | 181.365 | 181.41 | 9287426.0 |
| 2025-10-21 13:00:00 | NVDA | Stock | 181.43 | 181.6874 | 181.0601 | 181.6499 | 8275107.0 |
| 2025-10-21 14:00:00 | NVDA | Stock | 181.645 | 181.66 | 180.93 | 181.28 | 7345397.0 |
| 2025-10-21 15:00:00 | NVDA | Stock | 181.285 | 181.6199 | 181.02 | 181.16 | 9699173.0 |
| 2025-10-21 16:00:00 | NVDA | Stock | 181.16 | 181.2809 | 180.7 | 181.02 | 9989610.0 |
| 2025-10-21 17:00:00 | NVDA | Stock | 181.04 | 181.25 | 180.91 | 181.19 | 140606.0 |
| 2025-10-21 18:00:00 | NVDA | Stock | 181.21 | 181.24 | 181.01 | 181.0246 | 80638.0 |
| 2025-10-21 19:00:00 | NVDA | Stock | 181.0701 | 181.09 | 180.7 | 180.8065 | 191622.0 |
| 2025-10-21 04:00:00 | AMZN | Stock | 216.51 | 217.1 | 216.51 | 216.8 | 14320.0 |
| 2025-10-21 05:00:00 | AMZN | Stock | 216.8 | 217.35 | 216.8 | 217.3 | 10329.0 |
> showing 50 of 64,347 rows — these rows as CSV