PREVIEW / stock_1hour / 2025-12-31
file: by_date/stock_1hour/2025/2025-12-31.parquet size: 1.4 MB rows: 59,173 symbols: 172
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-12-31 04:00:00 | AAPL | Stock | 272.41 | 272.41 | 272.18 | 272.24 | 764.0 |
| 2025-12-31 05:00:00 | AAPL | Stock | 272.15 | 272.26 | 272.13 | 272.26 | 503.0 |
| 2025-12-31 06:00:00 | AAPL | Stock | 272.12 | 272.12 | 272.12 | 272.12 | 100.0 |
| 2025-12-31 07:00:00 | AAPL | Stock | 272.24 | 272.57 | 272.24 | 272.53 | 6298.0 |
| 2025-12-31 08:00:00 | AAPL | Stock | 272.4 | 273.08 | 272.04 | 272.82 | 39102.0 |
| 2025-12-31 09:00:00 | AAPL | Stock | 272.8 | 273.68 | 272.2 | 273.06 | 1709614.0 |
| 2025-12-31 10:00:00 | AAPL | Stock | 273.07 | 273.11 | 271.76 | 271.89 | 1668862.0 |
| 2025-12-31 11:00:00 | AAPL | Stock | 271.92 | 272.77 | 271.9049 | 272.7614 | 1467065.0 |
| 2025-12-31 12:00:00 | AAPL | Stock | 272.76 | 272.88 | 272.305 | 272.77 | 1016824.0 |
| 2025-12-31 13:00:00 | AAPL | Stock | 272.766 | 273.33 | 272.55 | 273.295 | 1447277.0 |
| 2025-12-31 14:00:00 | AAPL | Stock | 273.28 | 273.43 | 272.6034 | 272.71 | 1169781.0 |
| 2025-12-31 15:00:00 | AAPL | Stock | 272.7 | 272.75 | 271.75 | 271.84 | 3183498.0 |
| 2025-12-31 16:00:00 | AAPL | Stock | 271.86 | 272.41 | 271.76 | 272.0897 | 7467627.0 |
| 2025-12-31 17:00:00 | AAPL | Stock | 272.1 | 272.25 | 272.04 | 272.1 | 4390.0 |
| 2025-12-31 18:00:00 | AAPL | Stock | 272.05 | 272.1 | 272.04 | 272.1 | 2857.0 |
| 2025-12-31 19:00:00 | AAPL | Stock | 272.14 | 272.2199 | 272.0 | 272.09 | 7015.0 |
| 2025-12-31 04:00:00 | MSFT | Stock | 486.0 | 487.83 | 486.0 | 486.8 | 2496.0 |
| 2025-12-31 05:00:00 | MSFT | Stock | 486.5 | 487.28 | 486.4 | 487.15 | 796.0 |
| 2025-12-31 06:00:00 | MSFT | Stock | 487.01 | 487.51 | 486.45 | 487.44 | 2274.0 |
| 2025-12-31 07:00:00 | MSFT | Stock | 487.7 | 487.7 | 487.04 | 487.31 | 2972.0 |
| 2025-12-31 08:00:00 | MSFT | Stock | 487.37 | 488.28 | 486.0 | 487.81 | 17030.0 |
| 2025-12-31 09:00:00 | MSFT | Stock | 488.0 | 488.35 | 485.23 | 486.08 | 884161.0 |
| 2025-12-31 10:00:00 | MSFT | Stock | 486.02 | 486.3 | 484.52 | 484.69 | 1133796.0 |
| 2025-12-31 11:00:00 | MSFT | Stock | 484.685 | 485.9 | 484.29 | 485.805 | 894706.0 |
| 2025-12-31 12:00:00 | MSFT | Stock | 485.8 | 485.89 | 484.92 | 485.495 | 494846.0 |
| 2025-12-31 13:00:00 | MSFT | Stock | 485.4828 | 486.57 | 485.4098 | 486.3197 | 558754.0 |
| 2025-12-31 14:00:00 | MSFT | Stock | 486.31 | 486.7 | 485.02 | 485.06 | 498236.0 |
| 2025-12-31 15:00:00 | MSFT | Stock | 485.06 | 485.08 | 483.3 | 483.65 | 1678425.0 |
| 2025-12-31 16:00:00 | MSFT | Stock | 483.65 | 484.0 | 483.2 | 483.67 | 3955075.0 |
| 2025-12-31 17:00:00 | MSFT | Stock | 483.42 | 483.5 | 483.24 | 483.4 | 7407.0 |
| 2025-12-31 18:00:00 | MSFT | Stock | 483.32 | 483.65 | 483.32 | 483.6 | 3060.0 |
| 2025-12-31 19:00:00 | MSFT | Stock | 483.62 | 483.68 | 483.3373 | 483.4 | 4681.0 |
| 2025-12-31 04:00:00 | NVDA | Stock | 187.07 | 187.72 | 186.66 | 186.69 | 44872.0 |
| 2025-12-31 05:00:00 | NVDA | Stock | 186.66 | 187.29 | 186.59 | 187.28 | 36186.0 |
| 2025-12-31 06:00:00 | NVDA | Stock | 187.3 | 187.89 | 187.29 | 187.72 | 79016.0 |
| 2025-12-31 07:00:00 | NVDA | Stock | 187.69 | 188.35 | 187.63 | 188.26 | 216579.0 |
| 2025-12-31 08:00:00 | NVDA | Stock | 187.72 | 190.2 | 186.5 | 189.65 | 1803005.0 |
| 2025-12-31 09:00:00 | NVDA | Stock | 189.65 | 190.56 | 188.09 | 188.6157 | 17029564.0 |
| 2025-12-31 10:00:00 | NVDA | Stock | 188.61 | 189.14 | 188.1582 | 188.3 | 13646112.0 |
| 2025-12-31 11:00:00 | NVDA | Stock | 188.3 | 189.065 | 188.215 | 189.015 | 10100989.0 |
| 2025-12-31 12:00:00 | NVDA | Stock | 189.0192 | 189.28 | 188.5 | 188.715 | 7722716.0 |
| 2025-12-31 13:00:00 | NVDA | Stock | 188.72 | 189.055 | 188.64 | 188.68 | 7178931.0 |
| 2025-12-31 14:00:00 | NVDA | Stock | 188.68 | 188.86 | 187.36 | 187.795 | 9798354.0 |
| 2025-12-31 15:00:00 | NVDA | Stock | 187.79 | 187.82 | 186.49 | 186.49 | 14645852.0 |
| 2025-12-31 16:00:00 | NVDA | Stock | 186.5 | 188.1427 | 186.25 | 186.53 | 14427437.0 |
| 2025-12-31 17:00:00 | NVDA | Stock | 186.55 | 186.6997 | 186.51 | 186.58 | 140528.0 |
| 2025-12-31 18:00:00 | NVDA | Stock | 186.6 | 186.61 | 186.51 | 186.54 | 132142.0 |
| 2025-12-31 19:00:00 | NVDA | Stock | 186.5398 | 186.55 | 186.35 | 186.4593 | 184591.0 |
| 2025-12-31 04:00:00 | AMZN | Stock | 231.7 | 232.37 | 231.7 | 232.36 | 13910.0 |
| 2025-12-31 05:00:00 | AMZN | Stock | 232.0 | 232.1 | 232.0 | 232.1 | 837.0 |
> showing 50 of 59,173 rows — these rows as CSV