PREVIEW / stock_1hour / 2024-10-01
file: by_date/stock_1hour/2024/2024-10-01.parquet size: 1.4 MB rows: 60,066 symbols: 774
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-10-01 04:00:00 | AAPL | Stock | 233.33 | 233.37 | 233.08 | 233.09 | 7707.0 |
| 2024-10-01 05:00:00 | AAPL | Stock | 233.23 | 233.42 | 233.23 | 233.42 | 3894.0 |
| 2024-10-01 06:00:00 | AAPL | Stock | 233.39 | 233.56 | 233.0 | 233.0 | 26550.0 |
| 2024-10-01 07:00:00 | AAPL | Stock | 233.0 | 233.1 | 229.44 | 230.32 | 506508.0 |
| 2024-10-01 08:00:00 | AAPL | Stock | 230.3 | 233.47 | 229.4 | 230.0 | 444904.0 |
| 2024-10-01 09:00:00 | AAPL | Stock | 230.0 | 230.39 | 225.61 | 226.125 | 9655570.0 |
| 2024-10-01 10:00:00 | AAPL | Stock | 226.13 | 226.3 | 224.53 | 225.32 | 6546314.0 |
| 2024-10-01 11:00:00 | AAPL | Stock | 225.29 | 225.94 | 224.52 | 225.22 | 3948674.0 |
| 2024-10-01 12:00:00 | AAPL | Stock | 225.21 | 225.83 | 224.2678 | 224.75 | 3130658.0 |
| 2024-10-01 13:00:00 | AAPL | Stock | 224.77 | 225.17 | 223.74 | 225.13 | 3393416.0 |
| 2024-10-01 14:00:00 | AAPL | Stock | 225.12 | 225.75 | 225.0626 | 225.604 | 2838462.0 |
| 2024-10-01 15:00:00 | AAPL | Stock | 225.61 | 226.34 | 225.51 | 226.26 | 5856363.0 |
| 2024-10-01 16:00:00 | AAPL | Stock | 226.23 | 226.289 | 225.6015 | 225.67 | 9805035.0 |
| 2024-10-01 17:00:00 | AAPL | Stock | 225.67 | 226.21 | 225.5 | 225.5665 | 181740.0 |
| 2024-10-01 18:00:00 | AAPL | Stock | 225.57 | 225.8 | 225.3 | 225.62 | 41249.0 |
| 2024-10-01 19:00:00 | AAPL | Stock | 225.68 | 225.8435 | 225.4 | 225.72 | 36662.0 |
| 2024-10-01 04:00:00 | MSFT | Stock | 429.51 | 429.51 | 429.0 | 429.0 | 3318.0 |
| 2024-10-01 05:00:00 | MSFT | Stock | 428.97 | 429.0 | 428.55 | 429.0 | 2441.0 |
| 2024-10-01 06:00:00 | MSFT | Stock | 428.92 | 429.35 | 428.91 | 429.25 | 2235.0 |
| 2024-10-01 07:00:00 | MSFT | Stock | 429.51 | 430.0 | 429.05 | 429.69 | 9763.0 |
| 2024-10-01 08:00:00 | MSFT | Stock | 429.6 | 430.3 | 428.8914 | 429.24 | 26992.0 |
| 2024-10-01 09:00:00 | MSFT | Stock | 429.4126 | 429.5837 | 421.18 | 422.365 | 1694226.0 |
| 2024-10-01 10:00:00 | MSFT | Stock | 422.385 | 422.9299 | 420.3504 | 421.42 | 1343090.0 |
| 2024-10-01 11:00:00 | MSFT | Stock | 421.45 | 422.2199 | 418.81 | 421.42 | 1325446.0 |
| 2024-10-01 12:00:00 | MSFT | Stock | 421.435 | 422.36 | 419.59 | 421.3 | 771601.0 |
| 2024-10-01 13:00:00 | MSFT | Stock | 421.3 | 422.96 | 419.765 | 422.93 | 737880.0 |
| 2024-10-01 14:00:00 | MSFT | Stock | 422.92 | 423.73 | 422.68 | 423.07 | 615902.0 |
| 2024-10-01 15:00:00 | MSFT | Stock | 423.08 | 423.1 | 420.295 | 420.73 | 1532638.0 |
| 2024-10-01 16:00:00 | MSFT | Stock | 420.69 | 421.48 | 420.31 | 420.595 | 4410979.0 |
| 2024-10-01 17:00:00 | MSFT | Stock | 420.58 | 420.69 | 420.27 | 420.35 | 24256.0 |
| 2024-10-01 18:00:00 | MSFT | Stock | 420.49 | 421.05 | 419.5306 | 420.1 | 17236.0 |
| 2024-10-01 19:00:00 | MSFT | Stock | 419.95 | 420.22 | 419.6 | 419.8 | 3899.0 |
| 2024-10-01 04:00:00 | NVDA | Stock | 121.52 | 121.61 | 121.17 | 121.36 | 178344.0 |
| 2024-10-01 05:00:00 | NVDA | Stock | 121.37 | 121.59 | 121.26 | 121.59 | 81440.0 |
| 2024-10-01 06:00:00 | NVDA | Stock | 121.59 | 122.08 | 121.59 | 122.04 | 219246.0 |
| 2024-10-01 07:00:00 | NVDA | Stock | 122.01 | 122.251 | 121.63 | 121.91 | 612683.0 |
| 2024-10-01 08:00:00 | NVDA | Stock | 121.88 | 122.27 | 121.13 | 122.071 | 1623182.0 |
| 2024-10-01 09:00:00 | NVDA | Stock | 122.09 | 122.4351 | 119.69 | 120.1899 | 29914246.0 |
| 2024-10-01 10:00:00 | NVDA | Stock | 120.19 | 120.68 | 117.13 | 118.27 | 50611511.0 |
| 2024-10-01 11:00:00 | NVDA | Stock | 118.2799 | 118.32 | 116.2 | 117.045 | 36653483.0 |
| 2024-10-01 12:00:00 | NVDA | Stock | 117.03 | 118.09 | 116.3701 | 116.9819 | 29813148.0 |
| 2024-10-01 13:00:00 | NVDA | Stock | 116.98 | 117.35 | 115.79 | 117.3338 | 30893815.0 |
| 2024-10-01 14:00:00 | NVDA | Stock | 117.335 | 118.06 | 117.24 | 117.7467 | 25527689.0 |
| 2024-10-01 15:00:00 | NVDA | Stock | 117.74 | 117.96 | 116.72 | 116.9499 | 29381653.0 |
| 2024-10-01 16:00:00 | NVDA | Stock | 116.94 | 117.05 | 116.46 | 116.68 | 23396068.0 |
| 2024-10-01 17:00:00 | NVDA | Stock | 116.68 | 117.0 | 116.25 | 116.43 | 4734167.0 |
| 2024-10-01 18:00:00 | NVDA | Stock | 116.44 | 116.57 | 116.01 | 116.08 | 612230.0 |
| 2024-10-01 19:00:00 | NVDA | Stock | 116.07 | 116.23 | 115.89 | 116.0 | 961279.0 |
| 2024-10-01 04:00:00 | AMZN | Stock | 186.0 | 186.2 | 185.85 | 186.05 | 7482.0 |
| 2024-10-01 05:00:00 | AMZN | Stock | 186.11 | 186.15 | 185.55 | 185.74 | 11546.0 |
> showing 50 of 60,066 rows — these rows as CSV