PREVIEW / stock_1hour / 2024-10-11
file: by_date/stock_1hour/2024/2024-10-11.parquet size: 1.3 MB rows: 58,267 symbols: 769
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-11 04:00:00 | AAPL | Stock | 228.5 | 229.09 | 228.32 | 229.09 | 4946.0 |
| 2024-10-11 05:00:00 | AAPL | Stock | 228.65 | 228.84 | 228.63 | 228.71 | 1486.0 |
| 2024-10-11 06:00:00 | AAPL | Stock | 228.73 | 228.75 | 228.73 | 228.75 | 436.0 |
| 2024-10-11 07:00:00 | AAPL | Stock | 228.8 | 229.15 | 228.8 | 229.12 | 14907.0 |
| 2024-10-11 08:00:00 | AAPL | Stock | 228.85 | 229.5 | 228.8 | 228.96 | 68411.0 |
| 2024-10-11 09:00:00 | AAPL | Stock | 228.97 | 229.55 | 227.34 | 227.96 | 2992485.0 |
| 2024-10-11 10:00:00 | AAPL | Stock | 227.965 | 229.19 | 227.62 | 228.09 | 3199752.0 |
| 2024-10-11 11:00:00 | AAPL | Stock | 228.08 | 228.4 | 227.685 | 228.0699 | 1984097.0 |
| 2024-10-11 12:00:00 | AAPL | Stock | 228.065 | 228.09 | 227.41 | 227.87 | 1665381.0 |
| 2024-10-11 13:00:00 | AAPL | Stock | 227.87 | 228.075 | 227.495 | 227.8342 | 1536486.0 |
| 2024-10-11 14:00:00 | AAPL | Stock | 227.83 | 228.63 | 227.82 | 228.585 | 1821775.0 |
| 2024-10-11 15:00:00 | AAPL | Stock | 228.57 | 228.97 | 227.5 | 227.51 | 4191322.0 |
| 2024-10-11 16:00:00 | AAPL | Stock | 227.55 | 228.65 | 227.42 | 227.45 | 5972281.0 |
| 2024-10-11 17:00:00 | AAPL | Stock | 227.461 | 227.55 | 227.45 | 227.49 | 10463.0 |
| 2024-10-11 18:00:00 | AAPL | Stock | 227.45 | 227.49 | 227.2 | 227.3533 | 13411.0 |
| 2024-10-11 19:00:00 | AAPL | Stock | 227.35 | 227.41 | 227.34 | 227.4 | 7608.0 |
| 2024-10-11 04:00:00 | MSFT | Stock | 416.07 | 416.35 | 415.85 | 415.95 | 1072.0 |
| 2024-10-11 05:00:00 | MSFT | Stock | 416.12 | 416.12 | 416.12 | 416.12 | 117.0 |
| 2024-10-11 06:00:00 | MSFT | Stock | 416.2 | 416.33 | 416.2 | 416.2 | 683.0 |
| 2024-10-11 07:00:00 | MSFT | Stock | 415.99 | 415.99 | 415.65 | 415.82 | 3288.0 |
| 2024-10-11 08:00:00 | MSFT | Stock | 416.2 | 416.45 | 415.55 | 415.67 | 15883.0 |
| 2024-10-11 09:00:00 | MSFT | Stock | 415.7 | 416.16 | 413.25 | 414.965 | 1107600.0 |
| 2024-10-11 10:00:00 | MSFT | Stock | 414.965 | 417.13 | 414.5 | 415.385 | 1273013.0 |
| 2024-10-11 11:00:00 | MSFT | Stock | 415.39 | 415.99 | 414.93 | 415.48 | 691395.0 |
| 2024-10-11 12:00:00 | MSFT | Stock | 415.48 | 415.505 | 413.32 | 414.335 | 966770.0 |
| 2024-10-11 13:00:00 | MSFT | Stock | 414.36 | 414.98 | 414.17 | 414.445 | 442112.0 |
| 2024-10-11 14:00:00 | MSFT | Stock | 414.44 | 415.74 | 414.435 | 415.73 | 420737.0 |
| 2024-10-11 15:00:00 | MSFT | Stock | 415.7477 | 416.51 | 415.63 | 416.39 | 1496833.0 |
| 2024-10-11 16:00:00 | MSFT | Stock | 416.32 | 416.32 | 415.25 | 415.7 | 2589233.0 |
| 2024-10-11 17:00:00 | MSFT | Stock | 415.59 | 415.64 | 415.3999 | 415.5 | 3002.0 |
| 2024-10-11 18:00:00 | MSFT | Stock | 415.62 | 415.87 | 415.41 | 415.4234 | 4576.0 |
| 2024-10-11 19:00:00 | MSFT | Stock | 415.7 | 415.81 | 415.6363 | 415.76 | 2202.0 |
| 2024-10-11 04:00:00 | NVDA | Stock | 134.7 | 134.97 | 133.9 | 134.03 | 349414.0 |
| 2024-10-11 05:00:00 | NVDA | Stock | 134.07 | 134.54 | 134.03 | 134.47 | 123517.0 |
| 2024-10-11 06:00:00 | NVDA | Stock | 134.46 | 134.85 | 134.33 | 134.72 | 151055.0 |
| 2024-10-11 07:00:00 | NVDA | Stock | 134.71 | 134.99 | 134.55 | 134.77 | 642075.0 |
| 2024-10-11 08:00:00 | NVDA | Stock | 134.75 | 134.99 | 134.1048 | 134.38 | 2630076.0 |
| 2024-10-11 09:00:00 | NVDA | Stock | 134.38 | 135.0 | 133.66 | 134.54 | 27863587.0 |
| 2024-10-11 10:00:00 | NVDA | Stock | 134.54 | 135.78 | 134.18 | 134.73 | 39991466.0 |
| 2024-10-11 11:00:00 | NVDA | Stock | 134.735 | 135.33 | 134.64 | 135.035 | 19196428.0 |
| 2024-10-11 12:00:00 | NVDA | Stock | 135.035 | 135.25 | 134.67 | 134.995 | 13968651.0 |
| 2024-10-11 13:00:00 | NVDA | Stock | 134.995 | 135.03 | 134.73 | 134.85 | 8664643.0 |
| 2024-10-11 14:00:00 | NVDA | Stock | 134.8598 | 135.1499 | 134.56 | 134.83 | 11498635.0 |
| 2024-10-11 15:00:00 | NVDA | Stock | 134.83 | 134.97 | 134.685 | 134.75 | 15183407.0 |
| 2024-10-11 16:00:00 | NVDA | Stock | 134.73 | 134.8045 | 134.4801 | 134.57 | 11109832.0 |
| 2024-10-11 17:00:00 | NVDA | Stock | 134.56 | 134.7 | 134.5 | 134.52 | 243557.0 |
| 2024-10-11 18:00:00 | NVDA | Stock | 134.51 | 134.55 | 134.4 | 134.41 | 141064.0 |
| 2024-10-11 19:00:00 | NVDA | Stock | 134.42 | 134.45 | 134.28 | 134.38 | 265761.0 |
| 2024-10-11 04:00:00 | AMZN | Stock | 186.65 | 186.65 | 186.22 | 186.4 | 8392.0 |
| 2024-10-11 05:00:00 | AMZN | Stock | 186.39 | 186.66 | 186.39 | 186.64 | 8944.0 |
> showing 50 of 58,267 rows — these rows as CSV