PREVIEW / stock_1hour / 2025-01-29
file: by_date/stock_1hour/2025/2025-01-29.parquet size: 1.4 MB rows: 62,832 symbols: 563
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 |
|---|---|---|---|---|---|---|---|
| 2025-01-29 04:00:00 | AAPL | Stock | 238.56 | 238.56 | 237.05 | 237.2 | 48412.0 |
| 2025-01-29 05:00:00 | AAPL | Stock | 237.21 | 237.47 | 237.02 | 237.15 | 21656.0 |
| 2025-01-29 06:00:00 | AAPL | Stock | 237.12 | 237.56 | 237.07 | 237.47 | 14831.0 |
| 2025-01-29 07:00:00 | AAPL | Stock | 237.43 | 237.81 | 234.75 | 235.65 | 289637.0 |
| 2025-01-29 08:00:00 | AAPL | Stock | 237.58 | 239.56 | 232.98 | 234.58 | 595868.0 |
| 2025-01-29 09:00:00 | AAPL | Stock | 234.57 | 236.29 | 233.91 | 235.79 | 5070768.0 |
| 2025-01-29 10:00:00 | AAPL | Stock | 235.805 | 238.0 | 235.52 | 237.7894 | 4674962.0 |
| 2025-01-29 11:00:00 | AAPL | Stock | 237.78 | 237.95 | 236.13 | 236.54 | 2994213.0 |
| 2025-01-29 12:00:00 | AAPL | Stock | 236.54 | 237.19 | 235.945 | 236.03 | 2408322.0 |
| 2025-01-29 13:00:00 | AAPL | Stock | 236.04 | 237.66 | 235.45 | 237.0 | 2532074.0 |
| 2025-01-29 14:00:00 | AAPL | Stock | 236.97 | 238.29 | 236.31 | 238.08 | 2896466.0 |
| 2025-01-29 15:00:00 | AAPL | Stock | 238.07 | 239.855 | 237.69 | 239.35 | 6020863.0 |
| 2025-01-29 16:00:00 | AAPL | Stock | 239.36 | 239.98 | 238.7106 | 239.25 | 6719943.0 |
| 2025-01-29 17:00:00 | AAPL | Stock | 239.22 | 239.22 | 238.51 | 238.6209 | 51917.0 |
| 2025-01-29 18:00:00 | AAPL | Stock | 238.8 | 239.25 | 238.5013 | 238.8001 | 70219.0 |
| 2025-01-29 19:00:00 | AAPL | Stock | 238.85 | 239.5 | 238.85 | 239.2015 | 31813.0 |
| 2025-01-29 04:00:00 | MSFT | Stock | 446.59 | 446.99 | 444.93 | 446.5 | 16297.0 |
| 2025-01-29 05:00:00 | MSFT | Stock | 446.55 | 446.83 | 446.47 | 446.83 | 1984.0 |
| 2025-01-29 06:00:00 | MSFT | Stock | 446.59 | 446.72 | 445.61 | 446.72 | 3135.0 |
| 2025-01-29 07:00:00 | MSFT | Stock | 446.3 | 447.2 | 446.08 | 446.48 | 19280.0 |
| 2025-01-29 08:00:00 | MSFT | Stock | 446.5 | 447.95 | 440.0 | 446.0 | 70078.0 |
| 2025-01-29 09:00:00 | MSFT | Stock | 446.32 | 446.89 | 440.4 | 441.39 | 1638872.0 |
| 2025-01-29 10:00:00 | MSFT | Stock | 441.425 | 443.391 | 440.8158 | 442.715 | 1129170.0 |
| 2025-01-29 11:00:00 | MSFT | Stock | 442.715 | 444.4786 | 442.257 | 443.86 | 853266.0 |
| 2025-01-29 12:00:00 | MSFT | Stock | 443.84 | 445.09 | 442.7 | 442.8892 | 838980.0 |
| 2025-01-29 13:00:00 | MSFT | Stock | 442.85 | 443.24 | 440.9 | 442.59 | 801734.0 |
| 2025-01-29 14:00:00 | MSFT | Stock | 442.52 | 445.0 | 441.51 | 444.82 | 1481089.0 |
| 2025-01-29 15:00:00 | MSFT | Stock | 444.79 | 445.5 | 441.63 | 441.77 | 2316393.0 |
| 2025-01-29 16:00:00 | MSFT | Stock | 441.58 | 443.25 | 417.8 | 435.7875 | 4927205.0 |
| 2025-01-29 17:00:00 | MSFT | Stock | 435.3076 | 436.0 | 416.0 | 418.99 | 605271.0 |
| 2025-01-29 18:00:00 | MSFT | Stock | 418.99 | 425.0 | 414.11 | 419.0 | 867852.0 |
| 2025-01-29 19:00:00 | MSFT | Stock | 419.0 | 422.8992 | 418.7721 | 421.85 | 237363.0 |
| 2025-01-29 04:00:00 | NVDA | Stock | 129.94 | 130.3 | 128.1 | 129.42 | 1703629.0 |
| 2025-01-29 05:00:00 | NVDA | Stock | 129.45 | 129.46 | 128.26 | 128.75 | 639111.0 |
| 2025-01-29 06:00:00 | NVDA | Stock | 128.72 | 128.74 | 127.57 | 128.31 | 958897.0 |
| 2025-01-29 07:00:00 | NVDA | Stock | 128.31 | 128.41 | 127.16 | 127.46 | 1413395.0 |
| 2025-01-29 08:00:00 | NVDA | Stock | 127.88 | 131.99 | 125.6 | 126.15 | 7693615.0 |
| 2025-01-29 09:00:00 | NVDA | Stock | 126.11 | 126.89 | 124.5 | 125.255 | 41157647.0 |
| 2025-01-29 10:00:00 | NVDA | Stock | 125.27 | 126.07 | 121.72 | 122.6799 | 59462350.0 |
| 2025-01-29 11:00:00 | NVDA | Stock | 122.68 | 123.4 | 121.88 | 122.17 | 39712224.0 |
| 2025-01-29 12:00:00 | NVDA | Stock | 122.17 | 123.4899 | 122.09 | 122.965 | 25106471.0 |
| 2025-01-29 13:00:00 | NVDA | Stock | 122.96 | 122.995 | 120.05 | 120.95 | 47721118.0 |
| 2025-01-29 14:00:00 | NVDA | Stock | 120.95 | 122.8 | 120.3 | 122.09 | 40465197.0 |
| 2025-01-29 15:00:00 | NVDA | Stock | 122.101 | 123.81 | 121.52 | 123.81 | 48035753.0 |
| 2025-01-29 16:00:00 | NVDA | Stock | 123.8 | 126.5 | 122.24 | 126.0 | 51141940.0 |
| 2025-01-29 17:00:00 | NVDA | Stock | 126.0003 | 127.34 | 124.92 | 125.07 | 6306300.0 |
| 2025-01-29 18:00:00 | NVDA | Stock | 125.11 | 125.2 | 121.55 | 121.8697 | 5291206.0 |
| 2025-01-29 19:00:00 | NVDA | Stock | 121.79 | 123.32 | 121.79 | 123.2601 | 1723154.0 |
| 2025-01-29 04:00:00 | AMZN | Stock | 238.61 | 239.29 | 238.44 | 239.21 | 31390.0 |
| 2025-01-29 05:00:00 | AMZN | Stock | 239.28 | 239.78 | 239.27 | 239.5 | 16223.0 |
> showing 50 of 62,832 rows — these rows as CSV