PREVIEW / stock_1hour / 2024-12-04
file: by_date/stock_1hour/2024/2024-12-04.parquet size: 1.4 MB rows: 62,502 symbols: 683
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-04 04:00:00 | AAPL | Stock | 242.76 | 243.69 | 242.76 | 243.24 | 15940.0 |
| 2024-12-04 05:00:00 | AAPL | Stock | 243.2 | 243.35 | 243.08 | 243.35 | 4929.0 |
| 2024-12-04 06:00:00 | AAPL | Stock | 243.42 | 243.6 | 242.97 | 243.0 | 19183.0 |
| 2024-12-04 07:00:00 | AAPL | Stock | 243.01 | 243.35 | 242.94 | 243.08 | 23349.0 |
| 2024-12-04 08:00:00 | AAPL | Stock | 242.99 | 243.35 | 242.044 | 243.28 | 249817.0 |
| 2024-12-04 09:00:00 | AAPL | Stock | 243.28 | 243.88 | 242.51 | 243.555 | 3652523.0 |
| 2024-12-04 10:00:00 | AAPL | Stock | 243.54 | 244.11 | 243.15 | 243.465 | 4112228.0 |
| 2024-12-04 11:00:00 | AAPL | Stock | 243.47 | 243.83 | 242.11 | 242.5 | 2840537.0 |
| 2024-12-04 12:00:00 | AAPL | Stock | 242.48 | 242.5 | 241.25 | 242.3687 | 2587048.0 |
| 2024-12-04 13:00:00 | AAPL | Stock | 242.365 | 242.88 | 241.92 | 242.51 | 1645818.0 |
| 2024-12-04 14:00:00 | AAPL | Stock | 242.525 | 243.1764 | 242.39 | 242.9101 | 1710835.0 |
| 2024-12-04 15:00:00 | AAPL | Stock | 242.91 | 243.54 | 242.82 | 243.02 | 3822151.0 |
| 2024-12-04 16:00:00 | AAPL | Stock | 243.01 | 243.02 | 242.71 | 243.0081 | 8183212.0 |
| 2024-12-04 17:00:00 | AAPL | Stock | 242.9608 | 243.0299 | 242.9 | 242.9 | 11746.0 |
| 2024-12-04 18:00:00 | AAPL | Stock | 242.95 | 243.02 | 242.8258 | 242.92 | 8850.0 |
| 2024-12-04 19:00:00 | AAPL | Stock | 242.91 | 242.93 | 242.75 | 242.75 | 15909.0 |
| 2024-12-04 04:00:00 | MSFT | Stock | 433.05 | 434.31 | 432.99 | 434.3 | 9056.0 |
| 2024-12-04 05:00:00 | MSFT | Stock | 434.38 | 435.25 | 434.38 | 434.76 | 5451.0 |
| 2024-12-04 06:00:00 | MSFT | Stock | 434.89 | 435.47 | 434.89 | 435.33 | 5411.0 |
| 2024-12-04 07:00:00 | MSFT | Stock | 435.01 | 435.29 | 434.55 | 434.79 | 24359.0 |
| 2024-12-04 08:00:00 | MSFT | Stock | 435.19 | 435.31 | 430.122 | 434.72 | 49935.0 |
| 2024-12-04 09:00:00 | MSFT | Stock | 434.6 | 439.545 | 432.61 | 438.05 | 3115950.0 |
| 2024-12-04 10:00:00 | MSFT | Stock | 437.96 | 439.08 | 436.06 | 438.9701 | 2081045.0 |
| 2024-12-04 11:00:00 | MSFT | Stock | 438.9601 | 439.67 | 436.4 | 436.97 | 1216679.0 |
| 2024-12-04 12:00:00 | MSFT | Stock | 436.96 | 437.72 | 436.32 | 437.04 | 781699.0 |
| 2024-12-04 13:00:00 | MSFT | Stock | 437.04 | 437.7 | 436.09 | 436.93 | 627808.0 |
| 2024-12-04 14:00:00 | MSFT | Stock | 436.83 | 438.2899 | 436.7 | 438.1303 | 816078.0 |
| 2024-12-04 15:00:00 | MSFT | Stock | 438.12 | 438.62 | 436.85 | 437.33 | 1894220.0 |
| 2024-12-04 16:00:00 | MSFT | Stock | 437.42 | 437.45 | 436.67 | 437.0048 | 4582115.0 |
| 2024-12-04 17:00:00 | MSFT | Stock | 437.08 | 437.38 | 436.8 | 437.07 | 3347.0 |
| 2024-12-04 18:00:00 | MSFT | Stock | 437.0 | 437.46 | 436.9 | 437.42 | 24964.0 |
| 2024-12-04 19:00:00 | MSFT | Stock | 437.3441 | 437.6512 | 437.16 | 437.16 | 5224.0 |
| 2024-12-04 04:00:00 | NVDA | Stock | 141.3 | 141.74 | 140.84 | 141.63 | 367720.0 |
| 2024-12-04 05:00:00 | NVDA | Stock | 141.64 | 141.67 | 141.26 | 141.45 | 157262.0 |
| 2024-12-04 06:00:00 | NVDA | Stock | 141.45 | 141.68 | 141.29 | 141.51 | 137252.0 |
| 2024-12-04 07:00:00 | NVDA | Stock | 141.52 | 141.93 | 141.35 | 141.78 | 645626.0 |
| 2024-12-04 08:00:00 | NVDA | Stock | 141.51 | 142.09 | 141.06 | 142.06 | 1782586.0 |
| 2024-12-04 09:00:00 | NVDA | Stock | 142.05 | 142.63 | 140.38 | 140.65 | 24870427.0 |
| 2024-12-04 10:00:00 | NVDA | Stock | 140.63 | 142.38 | 140.29 | 141.9876 | 26674536.0 |
| 2024-12-04 11:00:00 | NVDA | Stock | 141.99 | 143.66 | 141.85 | 143.6 | 25296089.0 |
| 2024-12-04 12:00:00 | NVDA | Stock | 143.59 | 144.59 | 143.57 | 144.34 | 23766175.0 |
| 2024-12-04 13:00:00 | NVDA | Stock | 144.34 | 144.62 | 143.753 | 144.29 | 16820967.0 |
| 2024-12-04 14:00:00 | NVDA | Stock | 144.295 | 145.79 | 144.22 | 145.5314 | 25557122.0 |
| 2024-12-04 15:00:00 | NVDA | Stock | 145.53 | 145.68 | 144.58 | 145.14 | 28475767.0 |
| 2024-12-04 16:00:00 | NVDA | Stock | 145.13 | 145.15 | 144.51 | 144.84 | 18465583.0 |
| 2024-12-04 17:00:00 | NVDA | Stock | 144.83 | 144.88 | 144.68 | 144.8 | 368234.0 |
| 2024-12-04 18:00:00 | NVDA | Stock | 144.77 | 144.83 | 144.44 | 144.5106 | 443958.0 |
| 2024-12-04 19:00:00 | NVDA | Stock | 144.5204 | 144.65 | 144.5 | 144.6299 | 407434.0 |
| 2024-12-04 04:00:00 | AMZN | Stock | 214.0 | 214.4 | 214.0 | 214.37 | 11370.0 |
| 2024-12-04 05:00:00 | AMZN | Stock | 214.38 | 214.9 | 214.34 | 214.8 | 18137.0 |
> showing 50 of 62,502 rows — these rows as CSV