PREVIEW / stock_1hour / 2025-06-06
file: by_date/stock_1hour/2025/2025-06-06.parquet size: 1.4 MB rows: 60,747 symbols: 402
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-06-06 04:00:00 | AAPL | Stock | 201.5 | 201.88 | 201.5 | 201.83 | 8600.0 |
| 2025-06-06 05:00:00 | AAPL | Stock | 201.88 | 201.98 | 201.7 | 201.98 | 6065.0 |
| 2025-06-06 06:00:00 | AAPL | Stock | 201.9 | 201.98 | 201.5 | 201.61 | 16654.0 |
| 2025-06-06 07:00:00 | AAPL | Stock | 201.56 | 201.65 | 201.38 | 201.51 | 12605.0 |
| 2025-06-06 08:00:00 | AAPL | Stock | 201.68 | 202.57 | 201.2 | 202.43 | 159149.0 |
| 2025-06-06 09:00:00 | AAPL | Stock | 202.4306 | 205.7 | 202.08 | 204.54 | 6031610.0 |
| 2025-06-06 10:00:00 | AAPL | Stock | 204.57 | 204.7446 | 203.12 | 203.15 | 3878053.0 |
| 2025-06-06 11:00:00 | AAPL | Stock | 203.14 | 204.06 | 202.86 | 203.045 | 3047343.0 |
| 2025-06-06 12:00:00 | AAPL | Stock | 203.05 | 203.1808 | 202.05 | 202.695 | 2652033.0 |
| 2025-06-06 13:00:00 | AAPL | Stock | 202.69 | 204.15 | 202.61 | 204.055 | 2541982.0 |
| 2025-06-06 14:00:00 | AAPL | Stock | 204.06 | 205.47 | 204.0401 | 205.265 | 3461938.0 |
| 2025-06-06 15:00:00 | AAPL | Stock | 205.25 | 205.3 | 203.895 | 203.93 | 5912657.0 |
| 2025-06-06 16:00:00 | AAPL | Stock | 203.97 | 204.2 | 203.64 | 204.03 | 6431014.0 |
| 2025-06-06 17:00:00 | AAPL | Stock | 204.0201 | 204.2 | 203.9 | 204.0 | 49726.0 |
| 2025-06-06 18:00:00 | AAPL | Stock | 204.05 | 204.5 | 204.03 | 204.48 | 26903.0 |
| 2025-06-06 19:00:00 | AAPL | Stock | 204.5 | 204.67 | 204.36 | 204.47 | 32796.0 |
| 2025-06-06 04:00:00 | MSFT | Stock | 469.05 | 469.9 | 469.0 | 469.9 | 4430.0 |
| 2025-06-06 05:00:00 | MSFT | Stock | 469.34 | 469.45 | 469.34 | 469.45 | 238.0 |
| 2025-06-06 06:00:00 | MSFT | Stock | 469.37 | 469.65 | 469.14 | 469.14 | 2829.0 |
| 2025-06-06 07:00:00 | MSFT | Stock | 469.11 | 469.4 | 469.0 | 469.4 | 1639.0 |
| 2025-06-06 08:00:00 | MSFT | Stock | 469.22 | 470.8 | 467.68 | 470.8 | 41132.0 |
| 2025-06-06 09:00:00 | MSFT | Stock | 470.7 | 472.7099 | 468.53 | 472.16 | 1933478.0 |
| 2025-06-06 10:00:00 | MSFT | Stock | 472.19 | 473.335 | 471.06 | 471.0824 | 1301569.0 |
| 2025-06-06 11:00:00 | MSFT | Stock | 471.07 | 471.95 | 469.58 | 470.77 | 673529.0 |
| 2025-06-06 12:00:00 | MSFT | Stock | 470.77 | 471.01 | 468.78 | 469.5 | 508196.0 |
| 2025-06-06 13:00:00 | MSFT | Stock | 469.47 | 471.25 | 469.32 | 470.94 | 590473.0 |
| 2025-06-06 14:00:00 | MSFT | Stock | 470.93 | 471.85 | 470.905 | 471.095 | 567144.0 |
| 2025-06-06 15:00:00 | MSFT | Stock | 471.07 | 471.43 | 470.07 | 470.16 | 1234862.0 |
| 2025-06-06 16:00:00 | MSFT | Stock | 470.2139 | 470.98 | 470.21 | 470.4 | 2028898.0 |
| 2025-06-06 17:00:00 | MSFT | Stock | 470.56 | 470.56 | 470.3803 | 470.3803 | 207.0 |
| 2025-06-06 18:00:00 | MSFT | Stock | 470.01 | 470.2 | 470.0 | 470.2 | 1755.0 |
| 2025-06-06 19:00:00 | MSFT | Stock | 470.32 | 470.57 | 470.32 | 470.38 | 971.0 |
| 2025-06-06 04:00:00 | NVDA | Stock | 140.49 | 140.49 | 139.77 | 140.35 | 263359.0 |
| 2025-06-06 05:00:00 | NVDA | Stock | 140.38 | 140.93 | 140.24 | 140.88 | 174435.0 |
| 2025-06-06 06:00:00 | NVDA | Stock | 140.89 | 140.92 | 140.35 | 140.42 | 140257.0 |
| 2025-06-06 07:00:00 | NVDA | Stock | 140.41 | 140.68 | 140.23 | 140.5 | 275834.0 |
| 2025-06-06 08:00:00 | NVDA | Stock | 140.5 | 141.97 | 139.91 | 141.8499 | 2843525.0 |
| 2025-06-06 09:00:00 | NVDA | Stock | 141.83 | 143.27 | 141.8 | 142.365 | 25153370.0 |
| 2025-06-06 10:00:00 | NVDA | Stock | 142.3689 | 142.6499 | 141.51 | 142.39 | 20624222.0 |
| 2025-06-06 11:00:00 | NVDA | Stock | 142.395 | 142.83 | 141.56 | 142.11 | 15300337.0 |
| 2025-06-06 12:00:00 | NVDA | Stock | 142.115 | 142.88 | 141.54 | 141.881 | 13097668.0 |
| 2025-06-06 13:00:00 | NVDA | Stock | 141.885 | 142.49 | 141.75 | 142.44 | 8712341.0 |
| 2025-06-06 14:00:00 | NVDA | Stock | 142.45 | 142.86 | 142.21 | 142.2455 | 11661294.0 |
| 2025-06-06 15:00:00 | NVDA | Stock | 142.24 | 142.34 | 141.64 | 141.69 | 17629028.0 |
| 2025-06-06 16:00:00 | NVDA | Stock | 141.69 | 142.04 | 141.5 | 141.97 | 10750114.0 |
| 2025-06-06 17:00:00 | NVDA | Stock | 141.95 | 142.0 | 141.62 | 141.68 | 281108.0 |
| 2025-06-06 18:00:00 | NVDA | Stock | 141.69 | 141.84 | 141.68 | 141.76 | 112438.0 |
| 2025-06-06 19:00:00 | NVDA | Stock | 141.77 | 141.9 | 141.7 | 141.8997 | 227356.0 |
| 2025-06-06 04:00:00 | AMZN | Stock | 209.15 | 209.49 | 209.15 | 209.34 | 7492.0 |
| 2025-06-06 05:00:00 | AMZN | Stock | 209.4 | 209.88 | 209.28 | 209.85 | 10808.0 |
> showing 50 of 60,747 rows — these rows as CSV