PREVIEW / stock_1hour / 2024-12-09
file: by_date/stock_1hour/2024/2024-12-09.parquet size: 1.5 MB rows: 65,144 symbols: 680
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 |
|---|---|---|---|---|---|---|---|
| 2024-12-09 04:00:00 | AAPL | Stock | 242.69 | 243.0 | 242.1 | 242.83 | 26371.0 |
| 2024-12-09 05:00:00 | AAPL | Stock | 242.85 | 242.85 | 242.51 | 242.76 | 5946.0 |
| 2024-12-09 06:00:00 | AAPL | Stock | 242.79 | 242.87 | 242.5 | 242.75 | 15551.0 |
| 2024-12-09 07:00:00 | AAPL | Stock | 242.67 | 242.67 | 242.24 | 242.46 | 20223.0 |
| 2024-12-09 08:00:00 | AAPL | Stock | 242.6314 | 242.76 | 242.19 | 242.57 | 47059.0 |
| 2024-12-09 09:00:00 | AAPL | Stock | 242.5779 | 244.1497 | 241.57 | 243.93 | 3357225.0 |
| 2024-12-09 10:00:00 | AAPL | Stock | 243.92 | 246.28 | 243.761 | 246.04 | 5026552.0 |
| 2024-12-09 11:00:00 | AAPL | Stock | 246.03 | 247.24 | 246.0 | 246.88 | 4656350.0 |
| 2024-12-09 12:00:00 | AAPL | Stock | 246.87 | 247.24 | 245.71 | 246.219 | 2704096.0 |
| 2024-12-09 13:00:00 | AAPL | Stock | 246.205 | 247.01 | 246.09 | 246.735 | 1812275.0 |
| 2024-12-09 14:00:00 | AAPL | Stock | 246.73 | 246.75 | 245.89 | 246.4266 | 1590816.0 |
| 2024-12-09 15:00:00 | AAPL | Stock | 246.425 | 247.09 | 246.1 | 246.82 | 5072286.0 |
| 2024-12-09 16:00:00 | AAPL | Stock | 246.86 | 247.2794 | 246.73 | 247.27 | 7492121.0 |
| 2024-12-09 17:00:00 | AAPL | Stock | 247.26 | 247.2887 | 246.75 | 247.25 | 34221.0 |
| 2024-12-09 18:00:00 | AAPL | Stock | 247.2 | 247.2 | 247.02 | 247.0345 | 11421.0 |
| 2024-12-09 19:00:00 | AAPL | Stock | 247.02 | 247.24 | 247.02 | 247.24 | 31824.0 |
| 2024-12-09 04:00:00 | MSFT | Stock | 442.95 | 442.95 | 440.66 | 440.89 | 20345.0 |
| 2024-12-09 05:00:00 | MSFT | Stock | 441.0 | 441.5 | 440.68 | 440.9 | 8519.0 |
| 2024-12-09 06:00:00 | MSFT | Stock | 440.97 | 441.4 | 440.6 | 441.27 | 5021.0 |
| 2024-12-09 07:00:00 | MSFT | Stock | 441.5 | 442.0 | 441.5 | 441.9 | 9760.0 |
| 2024-12-09 08:00:00 | MSFT | Stock | 441.82 | 442.72 | 441.05 | 442.21 | 31815.0 |
| 2024-12-09 09:00:00 | MSFT | Stock | 442.29 | 445.07 | 440.5 | 442.34 | 1265602.0 |
| 2024-12-09 10:00:00 | MSFT | Stock | 442.32 | 446.83 | 441.8601 | 445.1 | 1723162.0 |
| 2024-12-09 11:00:00 | MSFT | Stock | 445.07 | 448.33 | 444.945 | 446.705 | 1287202.0 |
| 2024-12-09 12:00:00 | MSFT | Stock | 446.75 | 447.57 | 446.12 | 446.28 | 703544.0 |
| 2024-12-09 13:00:00 | MSFT | Stock | 446.33 | 447.2 | 445.77 | 446.58 | 633883.0 |
| 2024-12-09 14:00:00 | MSFT | Stock | 446.56 | 446.56 | 445.07 | 446.11 | 626030.0 |
| 2024-12-09 15:00:00 | MSFT | Stock | 446.09 | 446.5 | 444.89 | 445.9 | 2133670.0 |
| 2024-12-09 16:00:00 | MSFT | Stock | 446.02 | 447.0 | 444.05 | 445.7 | 4140961.0 |
| 2024-12-09 17:00:00 | MSFT | Stock | 445.22 | 446.02 | 445.01 | 445.12 | 6407.0 |
| 2024-12-09 18:00:00 | MSFT | Stock | 444.7 | 445.2 | 444.7 | 445.09 | 3981.0 |
| 2024-12-09 19:00:00 | MSFT | Stock | 444.7071 | 445.0 | 444.7071 | 445.0 | 324.0 |
| 2024-12-09 04:00:00 | NVDA | Stock | 142.47 | 142.6 | 140.74 | 140.92 | 601082.0 |
| 2024-12-09 05:00:00 | NVDA | Stock | 140.93 | 141.29 | 140.61 | 140.85 | 538017.0 |
| 2024-12-09 06:00:00 | NVDA | Stock | 140.84 | 141.12 | 138.81 | 139.74 | 1116739.0 |
| 2024-12-09 07:00:00 | NVDA | Stock | 139.76 | 140.2 | 139.39 | 139.95 | 1558520.0 |
| 2024-12-09 08:00:00 | NVDA | Stock | 140.0 | 142.66 | 138.9 | 139.5289 | 3014206.0 |
| 2024-12-09 09:00:00 | NVDA | Stock | 139.5 | 139.95 | 137.42 | 139.67 | 30111810.0 |
| 2024-12-09 10:00:00 | NVDA | Stock | 139.68 | 139.93 | 137.59 | 137.835 | 26919617.0 |
| 2024-12-09 11:00:00 | NVDA | Stock | 137.835 | 138.49 | 137.13 | 138.33 | 18498356.0 |
| 2024-12-09 12:00:00 | NVDA | Stock | 138.375 | 139.72 | 138.22 | 139.35 | 13086259.0 |
| 2024-12-09 13:00:00 | NVDA | Stock | 139.35 | 139.84 | 139.055 | 139.119 | 10815727.0 |
| 2024-12-09 14:00:00 | NVDA | Stock | 139.115 | 139.16 | 138.05 | 138.44 | 10773643.0 |
| 2024-12-09 15:00:00 | NVDA | Stock | 138.44 | 139.18 | 138.13 | 138.805 | 14453211.0 |
| 2024-12-09 16:00:00 | NVDA | Stock | 138.83 | 139.29 | 138.45 | 138.46 | 15652183.0 |
| 2024-12-09 17:00:00 | NVDA | Stock | 138.47 | 138.81 | 138.31 | 138.4 | 247658.0 |
| 2024-12-09 18:00:00 | NVDA | Stock | 138.39 | 138.3975 | 138.0 | 138.14 | 267822.0 |
| 2024-12-09 19:00:00 | NVDA | Stock | 138.1106 | 138.14 | 137.87 | 137.93 | 355663.0 |
| 2024-12-09 04:00:00 | AMZN | Stock | 227.03 | 228.34 | 227.03 | 227.54 | 114121.0 |
| 2024-12-09 05:00:00 | AMZN | Stock | 227.42 | 227.77 | 227.26 | 227.36 | 25873.0 |
> showing 50 of 65,144 rows — these rows as CSV