PREVIEW / stock_1hour / 2025-05-28
file: by_date/stock_1hour/2025/2025-05-28.parquet size: 1.4 MB rows: 61,411 symbols: 411
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-05-28 04:00:00 | AAPL | Stock | 200.4 | 200.53 | 199.9 | 200.12 | 20873.0 |
| 2025-05-28 05:00:00 | AAPL | Stock | 200.08 | 200.36 | 199.94 | 200.1 | 9788.0 |
| 2025-05-28 06:00:00 | AAPL | Stock | 200.06 | 200.97 | 200.06 | 200.95 | 7366.0 |
| 2025-05-28 07:00:00 | AAPL | Stock | 200.9 | 200.95 | 200.65 | 200.76 | 16551.0 |
| 2025-05-28 08:00:00 | AAPL | Stock | 200.95 | 201.2271 | 200.0 | 201.13 | 132679.0 |
| 2025-05-28 09:00:00 | AAPL | Stock | 201.13 | 202.73 | 199.9 | 200.08 | 5845652.0 |
| 2025-05-28 10:00:00 | AAPL | Stock | 200.07 | 201.05 | 200.0 | 200.7956 | 4655214.0 |
| 2025-05-28 11:00:00 | AAPL | Stock | 200.79 | 201.31 | 200.58 | 200.9099 | 2659479.0 |
| 2025-05-28 12:00:00 | AAPL | Stock | 200.91 | 201.35 | 200.825 | 201.08 | 1874744.0 |
| 2025-05-28 13:00:00 | AAPL | Stock | 201.09 | 201.52 | 200.73 | 200.86 | 2072920.0 |
| 2025-05-28 14:00:00 | AAPL | Stock | 200.8592 | 201.25 | 200.32 | 200.885 | 1985994.0 |
| 2025-05-28 15:00:00 | AAPL | Stock | 200.88 | 201.5211 | 200.195 | 200.41 | 4982700.0 |
| 2025-05-28 16:00:00 | AAPL | Stock | 200.43 | 200.94 | 200.0 | 200.41 | 6758500.0 |
| 2025-05-28 17:00:00 | AAPL | Stock | 200.4 | 200.5 | 199.9 | 200.26 | 156569.0 |
| 2025-05-28 18:00:00 | AAPL | Stock | 200.1 | 201.25 | 199.93 | 201.25 | 84530.0 |
| 2025-05-28 19:00:00 | AAPL | Stock | 201.3 | 207.66 | 201.3 | 207.41 | 841320.0 |
| 2025-05-28 04:00:00 | MSFT | Stock | 459.25 | 459.42 | 458.8 | 459.39 | 4280.0 |
| 2025-05-28 05:00:00 | MSFT | Stock | 458.95 | 459.25 | 458.9 | 459.25 | 1226.0 |
| 2025-05-28 06:00:00 | MSFT | Stock | 459.16 | 460.43 | 459.15 | 460.43 | 4473.0 |
| 2025-05-28 07:00:00 | MSFT | Stock | 460.55 | 460.7 | 460.0 | 460.5 | 4791.0 |
| 2025-05-28 08:00:00 | MSFT | Stock | 460.6953 | 461.73 | 459.1 | 461.5 | 26286.0 |
| 2025-05-28 09:00:00 | MSFT | Stock | 461.7 | 462.52 | 460.35 | 460.6 | 1542459.0 |
| 2025-05-28 10:00:00 | MSFT | Stock | 460.6 | 460.89 | 459.16 | 459.34 | 1005979.0 |
| 2025-05-28 11:00:00 | MSFT | Stock | 459.345 | 459.91 | 458.2977 | 458.555 | 900519.0 |
| 2025-05-28 12:00:00 | MSFT | Stock | 458.565 | 459.03 | 457.8493 | 458.09 | 747899.0 |
| 2025-05-28 13:00:00 | MSFT | Stock | 458.09 | 458.225 | 457.1343 | 457.4 | 659528.0 |
| 2025-05-28 14:00:00 | MSFT | Stock | 457.42 | 458.73 | 456.93 | 458.25 | 550246.0 |
| 2025-05-28 15:00:00 | MSFT | Stock | 458.24 | 458.9 | 457.05 | 457.38 | 1328784.0 |
| 2025-05-28 16:00:00 | MSFT | Stock | 457.36 | 459.5 | 457.36 | 459.25 | 3031777.0 |
| 2025-05-28 17:00:00 | MSFT | Stock | 459.5 | 460.25 | 457.36 | 459.7 | 39062.0 |
| 2025-05-28 18:00:00 | MSFT | Stock | 459.6 | 462.0 | 458.651 | 461.84 | 6696.0 |
| 2025-05-28 19:00:00 | MSFT | Stock | 461.7863 | 463.0 | 460.25 | 461.7041 | 49226.0 |
| 2025-05-28 04:00:00 | NVDA | Stock | 135.8 | 136.28 | 135.02 | 135.11 | 401473.0 |
| 2025-05-28 05:00:00 | NVDA | Stock | 135.12 | 135.8 | 135.02 | 135.75 | 335522.0 |
| 2025-05-28 06:00:00 | NVDA | Stock | 135.74 | 136.48 | 135.73 | 136.41 | 504372.0 |
| 2025-05-28 07:00:00 | NVDA | Stock | 136.41 | 136.59 | 136.11 | 136.55 | 662427.0 |
| 2025-05-28 08:00:00 | NVDA | Stock | 136.43 | 136.77 | 135.0304 | 136.41 | 2888499.0 |
| 2025-05-28 09:00:00 | NVDA | Stock | 136.439 | 136.47 | 135.05 | 135.05 | 28319529.0 |
| 2025-05-28 10:00:00 | NVDA | Stock | 135.055 | 135.48 | 134.8 | 134.9917 | 24216936.0 |
| 2025-05-28 11:00:00 | NVDA | Stock | 134.995 | 135.91 | 134.98 | 135.5255 | 18648392.0 |
| 2025-05-28 12:00:00 | NVDA | Stock | 135.5217 | 136.115 | 135.52 | 135.765 | 17889725.0 |
| 2025-05-28 13:00:00 | NVDA | Stock | 135.76 | 136.68 | 135.75 | 136.66 | 21229105.0 |
| 2025-05-28 14:00:00 | NVDA | Stock | 136.6682 | 137.25 | 136.315 | 136.9015 | 27783277.0 |
| 2025-05-28 15:00:00 | NVDA | Stock | 136.9 | 137.19 | 134.79 | 134.81 | 43837649.0 |
| 2025-05-28 16:00:00 | NVDA | Stock | 134.815 | 141.8 | 133.25 | 141.77 | 47344172.0 |
| 2025-05-28 17:00:00 | NVDA | Stock | 141.75 | 143.17 | 139.82 | 140.5 | 18874475.0 |
| 2025-05-28 18:00:00 | NVDA | Stock | 140.51 | 141.2 | 140.2 | 140.76 | 4038929.0 |
| 2025-05-28 19:00:00 | NVDA | Stock | 140.78 | 142.0 | 140.6701 | 141.4 | 4948771.0 |
| 2025-05-28 04:00:00 | AMZN | Stock | 205.65 | 205.7 | 205.32 | 205.32 | 5258.0 |
| 2025-05-28 05:00:00 | AMZN | Stock | 205.38 | 205.42 | 205.17 | 205.42 | 1981.0 |
> showing 50 of 61,411 rows — these rows as CSV