PREVIEW / stock_1hour / 2024-01-31
file: by_date/stock_1hour/2024/2024-01-31.parquet size: 1.3 MB rows: 59,180 symbols: 1,184
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-01-31 04:00:00 | AAPL | Stock | 186.98 | 187.25 | 186.3 | 186.68 | 27824.0 |
| 2024-01-31 05:00:00 | AAPL | Stock | 186.7 | 186.95 | 186.7 | 186.78 | 10431.0 |
| 2024-01-31 06:00:00 | AAPL | Stock | 186.75 | 187.28 | 186.55 | 187.2 | 12363.0 |
| 2024-01-31 07:00:00 | AAPL | Stock | 187.21 | 187.84 | 187.14 | 187.84 | 40833.0 |
| 2024-01-31 08:00:00 | AAPL | Stock | 187.2108 | 187.9392 | 186.52 | 187.6 | 92197.0 |
| 2024-01-31 09:00:00 | AAPL | Stock | 187.64 | 187.64 | 184.79 | 185.195 | 6624839.0 |
| 2024-01-31 10:00:00 | AAPL | Stock | 185.19 | 185.78 | 184.9 | 185.29 | 5378657.0 |
| 2024-01-31 11:00:00 | AAPL | Stock | 185.3 | 185.87 | 185.295 | 185.685 | 3058492.0 |
| 2024-01-31 12:00:00 | AAPL | Stock | 185.685 | 186.34 | 185.6119 | 186.325 | 2649977.0 |
| 2024-01-31 13:00:00 | AAPL | Stock | 186.33 | 186.53 | 186.075 | 186.18 | 2560425.0 |
| 2024-01-31 14:00:00 | AAPL | Stock | 186.17 | 186.94 | 185.26 | 185.97 | 4576938.0 |
| 2024-01-31 15:00:00 | AAPL | Stock | 185.98 | 186.03 | 184.35 | 184.36 | 7841477.0 |
| 2024-01-31 16:00:00 | AAPL | Stock | 184.44 | 185.93 | 184.4 | 184.83 | 10726460.0 |
| 2024-01-31 17:00:00 | AAPL | Stock | 184.92 | 185.29 | 184.8 | 185.1 | 43189.0 |
| 2024-01-31 18:00:00 | AAPL | Stock | 185.2887 | 185.45 | 184.86 | 185.23 | 25462.0 |
| 2024-01-31 19:00:00 | AAPL | Stock | 185.37 | 185.75 | 185.22 | 185.7 | 27301.0 |
| 2024-01-31 04:00:00 | MSFT | Stock | 406.44 | 407.3 | 399.0 | 402.26 | 84140.0 |
| 2024-01-31 05:00:00 | MSFT | Stock | 402.02 | 403.7 | 401.78 | 403.3 | 21723.0 |
| 2024-01-31 06:00:00 | MSFT | Stock | 402.63 | 405.17 | 401.7 | 405.17 | 27038.0 |
| 2024-01-31 07:00:00 | MSFT | Stock | 405.42 | 407.5 | 404.5 | 407.35 | 110146.0 |
| 2024-01-31 08:00:00 | MSFT | Stock | 405.8 | 408.72 | 404.35 | 406.1 | 309468.0 |
| 2024-01-31 09:00:00 | MSFT | Stock | 406.04 | 415.32 | 405.17 | 406.545 | 7689446.0 |
| 2024-01-31 10:00:00 | MSFT | Stock | 406.59 | 406.74 | 402.55 | 403.34 | 4927711.0 |
| 2024-01-31 11:00:00 | MSFT | Stock | 403.3001 | 405.28 | 402.11 | 402.88 | 2833950.0 |
| 2024-01-31 12:00:00 | MSFT | Stock | 402.89 | 403.75 | 401.32 | 402.38 | 2045731.0 |
| 2024-01-31 13:00:00 | MSFT | Stock | 402.39 | 403.61 | 402.26 | 402.83 | 1953338.0 |
| 2024-01-31 14:00:00 | MSFT | Stock | 402.97 | 404.1999 | 400.51 | 402.665 | 3345009.0 |
| 2024-01-31 15:00:00 | MSFT | Stock | 402.7 | 402.75 | 397.21 | 397.45 | 5507608.0 |
| 2024-01-31 16:00:00 | MSFT | Stock | 397.58 | 397.58 | 396.36 | 396.9 | 5990721.0 |
| 2024-01-31 17:00:00 | MSFT | Stock | 396.95 | 397.04 | 396.3707 | 396.95 | 24329.0 |
| 2024-01-31 18:00:00 | MSFT | Stock | 396.97 | 398.44 | 396.8635 | 398.25 | 45579.0 |
| 2024-01-31 19:00:00 | MSFT | Stock | 398.15 | 398.51 | 397.97 | 398.49 | 31824.0 |
| 2024-01-31 04:00:00 | NVDA | Stock | 61.69 | 61.762 | 61.061 | 61.249 | 466160.0 |
| 2024-01-31 05:00:00 | NVDA | Stock | 61.23 | 61.236 | 60.916 | 60.916 | 362240.0 |
| 2024-01-31 06:00:00 | NVDA | Stock | 60.933 | 61.33 | 60.861 | 61.189 | 279530.0 |
| 2024-01-31 07:00:00 | NVDA | Stock | 61.286 | 61.885 | 61.234 | 61.786 | 1525430.0 |
| 2024-01-31 08:00:00 | NVDA | Stock | 61.25 | 61.896 | 61.23 | 61.45 | 2947900.0 |
| 2024-01-31 09:00:00 | NVDA | Stock | 61.442 | 62.075 | 61.3 | 61.671 | 52021560.0 |
| 2024-01-31 10:00:00 | NVDA | Stock | 61.659 | 61.812 | 60.7 | 60.939 | 64916030.0 |
| 2024-01-31 11:00:00 | NVDA | Stock | 60.9395 | 61.67 | 60.917 | 61.601 | 39635730.0 |
| 2024-01-31 12:00:00 | NVDA | Stock | 61.6039 | 61.794 | 61.358 | 61.5045 | 27968500.0 |
| 2024-01-31 13:00:00 | NVDA | Stock | 61.514 | 61.716 | 61.313 | 61.5085 | 24456220.0 |
| 2024-01-31 14:00:00 | NVDA | Stock | 61.523 | 62.269 | 61.133 | 61.921 | 55497790.0 |
| 2024-01-31 15:00:00 | NVDA | Stock | 61.917 | 62.0 | 61.255 | 61.501 | 51403030.0 |
| 2024-01-31 16:00:00 | NVDA | Stock | 61.527 | 61.775 | 61.5 | 61.601 | 24462070.0 |
| 2024-01-31 17:00:00 | NVDA | Stock | 61.588 | 61.6 | 61.35 | 61.5 | 435340.0 |
| 2024-01-31 18:00:00 | NVDA | Stock | 61.519 | 61.689 | 61.49 | 61.651 | 420020.0 |
| 2024-01-31 19:00:00 | NVDA | Stock | 61.693 | 61.825 | 61.665 | 61.823 | 547820.0 |
| 2024-01-31 04:00:00 | AMZN | Stock | 156.7 | 156.8 | 155.37 | 155.7 | 27938.0 |
| 2024-01-31 05:00:00 | AMZN | Stock | 155.46 | 155.46 | 154.76 | 154.76 | 31519.0 |
> showing 50 of 59,180 rows — these rows as CSV