PREVIEW / stock_1hour / 2024-12-05
file: by_date/stock_1hour/2024/2024-12-05.parquet size: 1.4 MB rows: 62,613 symbols: 688
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-05 04:00:00 | AAPL | Stock | 242.53 | 243.0 | 242.1 | 242.95 | 19156.0 |
| 2024-12-05 05:00:00 | AAPL | Stock | 242.99 | 243.17 | 242.99 | 243.0 | 6854.0 |
| 2024-12-05 06:00:00 | AAPL | Stock | 243.0 | 243.05 | 242.99 | 243.0 | 6356.0 |
| 2024-12-05 07:00:00 | AAPL | Stock | 243.03 | 243.2 | 243.03 | 243.14 | 8233.0 |
| 2024-12-05 08:00:00 | AAPL | Stock | 243.08 | 243.2651 | 242.15 | 243.01 | 54685.0 |
| 2024-12-05 09:00:00 | AAPL | Stock | 243.05 | 244.54 | 242.7128 | 243.47 | 3831686.0 |
| 2024-12-05 10:00:00 | AAPL | Stock | 243.455 | 243.57 | 242.24 | 242.35 | 3559546.0 |
| 2024-12-05 11:00:00 | AAPL | Stock | 242.37 | 242.77 | 242.21 | 242.63 | 1956628.0 |
| 2024-12-05 12:00:00 | AAPL | Stock | 242.625 | 243.4099 | 242.46 | 242.89 | 2224912.0 |
| 2024-12-05 13:00:00 | AAPL | Stock | 242.89 | 243.3227 | 242.61 | 243.215 | 1606641.0 |
| 2024-12-05 14:00:00 | AAPL | Stock | 243.2299 | 243.69 | 242.96 | 243.115 | 1610418.0 |
| 2024-12-05 15:00:00 | AAPL | Stock | 243.12 | 243.27 | 242.13 | 243.08 | 4065018.0 |
| 2024-12-05 16:00:00 | AAPL | Stock | 243.04 | 243.06 | 242.65 | 242.9 | 6129294.0 |
| 2024-12-05 17:00:00 | AAPL | Stock | 242.8247 | 243.04 | 242.7 | 242.86 | 20947.0 |
| 2024-12-05 18:00:00 | AAPL | Stock | 242.86 | 243.04 | 242.34 | 242.95 | 14607.0 |
| 2024-12-05 19:00:00 | AAPL | Stock | 242.92 | 242.96 | 242.8395 | 242.93 | 1441.0 |
| 2024-12-05 04:00:00 | MSFT | Stock | 438.47 | 438.63 | 437.5 | 438.48 | 8119.0 |
| 2024-12-05 05:00:00 | MSFT | Stock | 438.65 | 439.0 | 438.45 | 438.45 | 2883.0 |
| 2024-12-05 06:00:00 | MSFT | Stock | 438.35 | 438.36 | 437.5 | 437.9 | 9014.0 |
| 2024-12-05 07:00:00 | MSFT | Stock | 437.8 | 438.43 | 437.8 | 438.43 | 6303.0 |
| 2024-12-05 08:00:00 | MSFT | Stock | 438.0 | 438.48 | 437.2 | 437.87 | 20529.0 |
| 2024-12-05 09:00:00 | MSFT | Stock | 437.87 | 439.94 | 436.3 | 437.29 | 1428344.0 |
| 2024-12-05 10:00:00 | MSFT | Stock | 437.245 | 439.19 | 436.171 | 438.62 | 1114615.0 |
| 2024-12-05 11:00:00 | MSFT | Stock | 438.66 | 441.58 | 438.2737 | 441.4 | 1361231.0 |
| 2024-12-05 12:00:00 | MSFT | Stock | 441.37 | 444.06 | 441.19 | 443.945 | 1478755.0 |
| 2024-12-05 13:00:00 | MSFT | Stock | 443.945 | 444.66 | 442.71 | 442.81 | 1117523.0 |
| 2024-12-05 14:00:00 | MSFT | Stock | 442.82 | 443.55 | 442.3401 | 443.025 | 803111.0 |
| 2024-12-05 15:00:00 | MSFT | Stock | 443.025 | 443.8 | 441.99 | 442.63 | 1682962.0 |
| 2024-12-05 16:00:00 | MSFT | Stock | 442.71 | 442.77 | 441.86 | 442.33 | 3906364.0 |
| 2024-12-05 17:00:00 | MSFT | Stock | 442.25 | 442.62 | 442.0 | 442.4 | 17059.0 |
| 2024-12-05 18:00:00 | MSFT | Stock | 442.4 | 442.4 | 441.81 | 442.4 | 4197.0 |
| 2024-12-05 19:00:00 | MSFT | Stock | 442.08 | 442.45 | 442.08 | 442.31 | 957.0 |
| 2024-12-05 04:00:00 | NVDA | Stock | 144.65 | 144.66 | 144.17 | 144.44 | 279945.0 |
| 2024-12-05 05:00:00 | NVDA | Stock | 144.44 | 144.9 | 144.37 | 144.76 | 171984.0 |
| 2024-12-05 06:00:00 | NVDA | Stock | 144.76 | 145.32 | 144.66 | 145.09 | 239226.0 |
| 2024-12-05 07:00:00 | NVDA | Stock | 145.08 | 145.49 | 144.92 | 145.32 | 525726.0 |
| 2024-12-05 08:00:00 | NVDA | Stock | 144.96 | 145.49 | 144.38 | 144.89 | 1661562.0 |
| 2024-12-05 09:00:00 | NVDA | Stock | 144.91 | 146.07 | 144.18 | 144.69 | 24920684.0 |
| 2024-12-05 10:00:00 | NVDA | Stock | 144.7 | 145.45 | 143.95 | 145.33 | 24743588.0 |
| 2024-12-05 11:00:00 | NVDA | Stock | 145.34 | 146.54 | 145.25 | 146.075 | 19559470.0 |
| 2024-12-05 12:00:00 | NVDA | Stock | 146.08 | 146.35 | 145.76 | 145.9499 | 11212193.0 |
| 2024-12-05 13:00:00 | NVDA | Stock | 145.95 | 146.0099 | 144.31 | 144.51 | 15035813.0 |
| 2024-12-05 14:00:00 | NVDA | Stock | 144.515 | 145.251 | 144.35 | 145.1812 | 11282977.0 |
| 2024-12-05 15:00:00 | NVDA | Stock | 145.18 | 145.5 | 144.88 | 145.01 | 15895258.0 |
| 2024-12-05 16:00:00 | NVDA | Stock | 145.06 | 145.17 | 144.67 | 144.8001 | 19316735.0 |
| 2024-12-05 17:00:00 | NVDA | Stock | 144.8 | 145.06 | 144.49 | 144.53 | 248989.0 |
| 2024-12-05 18:00:00 | NVDA | Stock | 144.52 | 144.6 | 144.36 | 144.45 | 212749.0 |
| 2024-12-05 19:00:00 | NVDA | Stock | 144.47 | 144.5 | 144.4 | 144.42 | 164242.0 |
| 2024-12-05 04:00:00 | AMZN | Stock | 219.02 | 219.02 | 217.59 | 217.83 | 7328.0 |
| 2024-12-05 05:00:00 | AMZN | Stock | 217.85 | 218.09 | 217.7 | 218.04 | 4924.0 |
> showing 50 of 62,613 rows — these rows as CSV