PREVIEW / stock_1hour / 2025-10-27
file: by_date/stock_1hour/2025/2025-10-27.parquet size: 1.5 MB rows: 66,693 symbols: 223
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-27 04:00:00 | AAPL | Stock | 264.27 | 265.66 | 264.26 | 264.44 | 29096.0 |
| 2025-10-27 05:00:00 | AAPL | Stock | 264.55 | 265.34 | 264.32 | 264.75 | 14518.0 |
| 2025-10-27 06:00:00 | AAPL | Stock | 264.65 | 265.14 | 264.6 | 264.83 | 17013.0 |
| 2025-10-27 07:00:00 | AAPL | Stock | 264.71 | 265.26 | 264.5 | 264.9 | 53498.0 |
| 2025-10-27 08:00:00 | AAPL | Stock | 265.0 | 265.88 | 264.35 | 265.19 | 207522.0 |
| 2025-10-27 09:00:00 | AAPL | Stock | 265.12 | 266.66 | 264.07 | 266.25 | 4624468.0 |
| 2025-10-27 10:00:00 | AAPL | Stock | 266.24 | 267.05 | 265.2 | 265.4 | 3842670.0 |
| 2025-10-27 11:00:00 | AAPL | Stock | 265.4 | 266.11 | 265.05 | 265.4102 | 2685669.0 |
| 2025-10-27 12:00:00 | AAPL | Stock | 265.42 | 266.125 | 265.24 | 265.59 | 2220066.0 |
| 2025-10-27 13:00:00 | AAPL | Stock | 265.59 | 266.02 | 265.5 | 265.8601 | 1609268.0 |
| 2025-10-27 14:00:00 | AAPL | Stock | 265.86 | 266.33 | 265.47 | 266.235 | 1846635.0 |
| 2025-10-27 15:00:00 | AAPL | Stock | 266.235 | 269.12 | 266.03 | 268.74 | 7628871.0 |
| 2025-10-27 16:00:00 | AAPL | Stock | 268.75 | 268.9752 | 266.7636 | 268.72 | 8001814.0 |
| 2025-10-27 17:00:00 | AAPL | Stock | 268.7 | 268.82 | 268.56 | 268.79 | 48171.0 |
| 2025-10-27 18:00:00 | AAPL | Stock | 268.75 | 269.15 | 268.69 | 269.06 | 93947.0 |
| 2025-10-27 19:00:00 | AAPL | Stock | 269.01 | 269.3027 | 268.85 | 269.07 | 72435.0 |
| 2025-10-27 04:00:00 | MSFT | Stock | 529.77 | 530.01 | 528.0 | 529.25 | 9122.0 |
| 2025-10-27 05:00:00 | MSFT | Stock | 529.25 | 530.58 | 528.5 | 530.12 | 9151.0 |
| 2025-10-27 06:00:00 | MSFT | Stock | 529.99 | 530.13 | 529.12 | 529.89 | 12047.0 |
| 2025-10-27 07:00:00 | MSFT | Stock | 529.7 | 530.75 | 528.2 | 530.12 | 29705.0 |
| 2025-10-27 08:00:00 | MSFT | Stock | 529.69 | 531.73 | 527.36 | 531.05 | 98216.0 |
| 2025-10-27 09:00:00 | MSFT | Stock | 531.07 | 532.4 | 529.01 | 531.565 | 1800109.0 |
| 2025-10-27 10:00:00 | MSFT | Stock | 531.55 | 534.58 | 531.52 | 532.72 | 1785936.0 |
| 2025-10-27 11:00:00 | MSFT | Stock | 532.745 | 533.44 | 531.92 | 532.53 | 904448.0 |
| 2025-10-27 12:00:00 | MSFT | Stock | 532.5 | 532.78 | 530.9101 | 531.37 | 607817.0 |
| 2025-10-27 13:00:00 | MSFT | Stock | 531.35 | 531.95 | 530.445 | 531.885 | 605113.0 |
| 2025-10-27 14:00:00 | MSFT | Stock | 531.86 | 533.63 | 531.1001 | 533.57 | 722383.0 |
| 2025-10-27 15:00:00 | MSFT | Stock | 533.52 | 533.62 | 531.17 | 531.41 | 1544804.0 |
| 2025-10-27 16:00:00 | MSFT | Stock | 531.41 | 532.87 | 531.375 | 532.8 | 3560567.0 |
| 2025-10-27 17:00:00 | MSFT | Stock | 532.86 | 533.3999 | 532.86 | 533.1967 | 17380.0 |
| 2025-10-27 18:00:00 | MSFT | Stock | 533.0 | 533.25 | 531.52 | 533.2 | 20101.0 |
| 2025-10-27 19:00:00 | MSFT | Stock | 533.1 | 534.0 | 533.1 | 533.25 | 8861.0 |
| 2025-10-27 04:00:00 | NVDA | Stock | 189.0 | 190.19 | 188.12 | 190.17 | 550224.0 |
| 2025-10-27 05:00:00 | NVDA | Stock | 190.2 | 190.94 | 190.16 | 190.88 | 398459.0 |
| 2025-10-27 06:00:00 | NVDA | Stock | 190.87 | 191.16 | 190.52 | 190.8 | 424428.0 |
| 2025-10-27 07:00:00 | NVDA | Stock | 190.81 | 190.99 | 190.58 | 190.65 | 506474.0 |
| 2025-10-27 08:00:00 | NVDA | Stock | 190.63 | 191.14 | 189.4 | 190.4799 | 1594755.0 |
| 2025-10-27 09:00:00 | NVDA | Stock | 190.4797 | 191.27 | 189.75 | 191.055 | 18977990.0 |
| 2025-10-27 10:00:00 | NVDA | Stock | 191.055 | 191.11 | 188.4318 | 190.3045 | 23335520.0 |
| 2025-10-27 11:00:00 | NVDA | Stock | 190.31 | 191.47 | 190.24 | 190.875 | 13317089.0 |
| 2025-10-27 12:00:00 | NVDA | Stock | 190.88 | 191.49 | 190.78 | 191.4742 | 8048673.0 |
| 2025-10-27 13:00:00 | NVDA | Stock | 191.4701 | 191.775 | 191.0 | 191.095 | 10172629.0 |
| 2025-10-27 14:00:00 | NVDA | Stock | 191.1 | 191.24 | 190.27 | 190.767 | 9814141.0 |
| 2025-10-27 15:00:00 | NVDA | Stock | 190.76 | 192.0 | 190.28 | 191.43 | 18028939.0 |
| 2025-10-27 16:00:00 | NVDA | Stock | 191.43 | 191.77 | 191.42 | 191.64 | 16345737.0 |
| 2025-10-27 17:00:00 | NVDA | Stock | 191.6497 | 191.68 | 191.49 | 191.59 | 154542.0 |
| 2025-10-27 18:00:00 | NVDA | Stock | 191.57 | 191.58 | 191.31 | 191.4 | 164999.0 |
| 2025-10-27 19:00:00 | NVDA | Stock | 191.4 | 191.69 | 191.4 | 191.5678 | 208135.0 |
| 2025-10-27 04:00:00 | AMZN | Stock | 226.24 | 228.14 | 226.24 | 227.9 | 52503.0 |
| 2025-10-27 05:00:00 | AMZN | Stock | 227.9 | 228.6 | 227.78 | 228.6 | 45636.0 |
> showing 50 of 66,693 rows — these rows as CSV