PREVIEW / stock_1hour / 2024-12-06
file: by_date/stock_1hour/2024/2024-12-06.parquet size: 1.4 MB rows: 61,934 symbols: 689
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-06 04:00:00 | AAPL | Stock | 242.97 | 243.1 | 242.81 | 242.89 | 4026.0 |
| 2024-12-06 05:00:00 | AAPL | Stock | 242.73 | 242.78 | 242.69 | 242.72 | 1700.0 |
| 2024-12-06 06:00:00 | AAPL | Stock | 242.69 | 242.69 | 242.52 | 242.53 | 2231.0 |
| 2024-12-06 07:00:00 | AAPL | Stock | 242.62 | 242.95 | 242.62 | 242.85 | 11670.0 |
| 2024-12-06 08:00:00 | AAPL | Stock | 242.79 | 243.18 | 242.41 | 242.87 | 75078.0 |
| 2024-12-06 09:00:00 | AAPL | Stock | 242.86 | 244.2 | 242.08 | 243.64 | 3724429.0 |
| 2024-12-06 10:00:00 | AAPL | Stock | 243.67 | 244.63 | 243.0 | 243.5986 | 3395864.0 |
| 2024-12-06 11:00:00 | AAPL | Stock | 243.6 | 244.1 | 243.51 | 243.65 | 2036911.0 |
| 2024-12-06 12:00:00 | AAPL | Stock | 243.66 | 243.73 | 242.94 | 243.06 | 2177476.0 |
| 2024-12-06 13:00:00 | AAPL | Stock | 243.05 | 243.64 | 242.94 | 243.63 | 1390336.0 |
| 2024-12-06 14:00:00 | AAPL | Stock | 243.62 | 243.63 | 242.912 | 242.9601 | 2007392.0 |
| 2024-12-06 15:00:00 | AAPL | Stock | 242.95 | 243.4 | 242.2 | 242.86 | 4549791.0 |
| 2024-12-06 16:00:00 | AAPL | Stock | 242.84 | 242.84 | 242.28 | 242.55 | 7609908.0 |
| 2024-12-06 17:00:00 | AAPL | Stock | 242.58 | 242.6 | 242.3 | 242.37 | 13951.0 |
| 2024-12-06 18:00:00 | AAPL | Stock | 242.37 | 242.44 | 242.31 | 242.41 | 5024.0 |
| 2024-12-06 19:00:00 | AAPL | Stock | 242.4 | 242.4055 | 242.3025 | 242.3025 | 6377.0 |
| 2024-12-06 04:00:00 | MSFT | Stock | 442.0 | 442.0 | 440.64 | 440.89 | 10652.0 |
| 2024-12-06 05:00:00 | MSFT | Stock | 440.85 | 441.11 | 440.5 | 440.5 | 5237.0 |
| 2024-12-06 06:00:00 | MSFT | Stock | 440.66 | 441.91 | 440.6 | 441.83 | 7222.0 |
| 2024-12-06 07:00:00 | MSFT | Stock | 441.97 | 445.05 | 441.97 | 443.43 | 44034.0 |
| 2024-12-06 08:00:00 | MSFT | Stock | 444.2 | 445.61 | 440.49 | 444.6 | 80071.0 |
| 2024-12-06 09:00:00 | MSFT | Stock | 444.39 | 446.1 | 441.5 | 445.31 | 1358003.0 |
| 2024-12-06 10:00:00 | MSFT | Stock | 445.345 | 445.65 | 442.8 | 443.34 | 1190709.0 |
| 2024-12-06 11:00:00 | MSFT | Stock | 443.37 | 444.67 | 442.65 | 442.805 | 882198.0 |
| 2024-12-06 12:00:00 | MSFT | Stock | 442.87 | 443.7 | 441.7703 | 442.4 | 776882.0 |
| 2024-12-06 13:00:00 | MSFT | Stock | 442.37 | 443.8799 | 442.21 | 443.5899 | 612724.0 |
| 2024-12-06 14:00:00 | MSFT | Stock | 443.5646 | 444.0799 | 442.94 | 443.765 | 524027.0 |
| 2024-12-06 15:00:00 | MSFT | Stock | 443.76 | 444.77 | 443.33 | 443.52 | 1739644.0 |
| 2024-12-06 16:00:00 | MSFT | Stock | 443.57 | 444.46 | 442.81 | 443.3 | 4029663.0 |
| 2024-12-06 17:00:00 | MSFT | Stock | 443.26 | 443.6797 | 443.2 | 443.6797 | 1223.0 |
| 2024-12-06 18:00:00 | MSFT | Stock | 443.41 | 443.41 | 442.7543 | 442.7543 | 1622.0 |
| 2024-12-06 19:00:00 | MSFT | Stock | 442.8 | 443.47 | 442.8 | 443.0002 | 1511.0 |
| 2024-12-06 04:00:00 | NVDA | Stock | 145.07 | 145.14 | 144.68 | 144.83 | 195751.0 |
| 2024-12-06 05:00:00 | NVDA | Stock | 144.87 | 144.87 | 144.52 | 144.58 | 107294.0 |
| 2024-12-06 06:00:00 | NVDA | Stock | 144.61 | 144.77 | 144.51 | 144.71 | 87123.0 |
| 2024-12-06 07:00:00 | NVDA | Stock | 144.68 | 144.9 | 144.51 | 144.58 | 319656.0 |
| 2024-12-06 08:00:00 | NVDA | Stock | 144.58 | 145.2 | 144.11 | 144.64 | 1599658.0 |
| 2024-12-06 09:00:00 | NVDA | Stock | 144.63 | 145.65 | 144.175 | 145.495 | 17223143.0 |
| 2024-12-06 10:00:00 | NVDA | Stock | 145.49 | 145.7 | 143.45 | 143.7306 | 23233783.0 |
| 2024-12-06 11:00:00 | NVDA | Stock | 143.74 | 143.82 | 141.31 | 142.0 | 32199018.0 |
| 2024-12-06 12:00:00 | NVDA | Stock | 142.0012 | 143.23 | 141.94 | 142.425 | 19634805.0 |
| 2024-12-06 13:00:00 | NVDA | Stock | 142.42 | 142.91 | 142.3 | 142.615 | 9995215.0 |
| 2024-12-06 14:00:00 | NVDA | Stock | 142.615 | 142.71 | 142.18 | 142.27 | 9080378.0 |
| 2024-12-06 15:00:00 | NVDA | Stock | 142.265 | 142.5 | 141.79 | 142.4 | 19484288.0 |
| 2024-12-06 16:00:00 | NVDA | Stock | 142.4 | 142.48 | 142.04 | 142.1137 | 14885924.0 |
| 2024-12-06 17:00:00 | NVDA | Stock | 142.16 | 142.19 | 141.9 | 141.92 | 380197.0 |
| 2024-12-06 18:00:00 | NVDA | Stock | 141.9108 | 142.05 | 141.81 | 141.94 | 256278.0 |
| 2024-12-06 19:00:00 | NVDA | Stock | 141.94 | 141.94 | 141.8 | 141.93 | 235469.0 |
| 2024-12-06 04:00:00 | AMZN | Stock | 220.87 | 221.11 | 220.7 | 221.1 | 13583.0 |
| 2024-12-06 05:00:00 | AMZN | Stock | 221.1 | 221.1 | 220.68 | 220.8 | 4997.0 |
> showing 50 of 61,934 rows — these rows as CSV