PREVIEW / stock_1hour / 2025-06-12
file: by_date/stock_1hour/2025/2025-06-12.parquet size: 1.4 MB rows: 62,170 symbols: 397
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-06-12 04:00:00 | AAPL | Stock | 199.2 | 199.44 | 198.45 | 199.3 | 35400.0 |
| 2025-06-12 05:00:00 | AAPL | Stock | 199.25 | 199.6 | 199.12 | 199.14 | 18022.0 |
| 2025-06-12 06:00:00 | AAPL | Stock | 199.26 | 199.54 | 198.98 | 199.3 | 12161.0 |
| 2025-06-12 07:00:00 | AAPL | Stock | 199.29 | 199.29 | 198.66 | 198.74 | 20122.0 |
| 2025-06-12 08:00:00 | AAPL | Stock | 199.1 | 199.52 | 198.65 | 199.4684 | 189466.0 |
| 2025-06-12 09:00:00 | AAPL | Stock | 199.45 | 199.6073 | 197.7396 | 197.94 | 5026514.0 |
| 2025-06-12 10:00:00 | AAPL | Stock | 197.94 | 198.58 | 197.3601 | 198.2788 | 4781141.0 |
| 2025-06-12 11:00:00 | AAPL | Stock | 198.26 | 198.925 | 197.755 | 198.3098 | 3807857.0 |
| 2025-06-12 12:00:00 | AAPL | Stock | 198.295 | 198.97 | 198.08 | 198.5625 | 2922254.0 |
| 2025-06-12 13:00:00 | AAPL | Stock | 198.561 | 199.68 | 198.46 | 198.9404 | 2966987.0 |
| 2025-06-12 14:00:00 | AAPL | Stock | 198.96 | 199.19 | 198.545 | 198.985 | 2465113.0 |
| 2025-06-12 15:00:00 | AAPL | Stock | 198.98 | 199.2 | 198.4 | 199.2 | 3979122.0 |
| 2025-06-12 16:00:00 | AAPL | Stock | 199.19 | 199.45 | 198.66 | 199.0101 | 6240684.0 |
| 2025-06-12 17:00:00 | AAPL | Stock | 199.13 | 199.2 | 198.9 | 198.9 | 31288.0 |
| 2025-06-12 18:00:00 | AAPL | Stock | 198.95 | 198.9772 | 198.5 | 198.75 | 24333.0 |
| 2025-06-12 19:00:00 | AAPL | Stock | 198.71 | 198.75 | 198.01 | 198.5795 | 20036.0 |
| 2025-06-12 04:00:00 | MSFT | Stock | 471.01 | 472.12 | 470.17 | 472.11 | 2211.0 |
| 2025-06-12 05:00:00 | MSFT | Stock | 472.49 | 473.56 | 472.49 | 473.07 | 2165.0 |
| 2025-06-12 06:00:00 | MSFT | Stock | 473.12 | 475.1 | 473.12 | 474.56 | 7858.0 |
| 2025-06-12 07:00:00 | MSFT | Stock | 474.33 | 474.77 | 473.67 | 473.8 | 9736.0 |
| 2025-06-12 08:00:00 | MSFT | Stock | 474.5 | 476.2 | 472.5 | 476.13 | 57243.0 |
| 2025-06-12 09:00:00 | MSFT | Stock | 476.0 | 476.63 | 473.52 | 475.1 | 1509120.0 |
| 2025-06-12 10:00:00 | MSFT | Stock | 475.04 | 477.02 | 474.77 | 476.67 | 1396960.0 |
| 2025-06-12 11:00:00 | MSFT | Stock | 476.67 | 478.0836 | 476.34 | 477.74 | 995807.0 |
| 2025-06-12 12:00:00 | MSFT | Stock | 477.73 | 479.33 | 477.44 | 478.69 | 1175300.0 |
| 2025-06-12 13:00:00 | MSFT | Stock | 478.64 | 479.99 | 478.509 | 479.4 | 1006786.0 |
| 2025-06-12 14:00:00 | MSFT | Stock | 479.37 | 480.15 | 478.97 | 479.85 | 1023859.0 |
| 2025-06-12 15:00:00 | MSFT | Stock | 479.82 | 480.415 | 477.99 | 479.03 | 2034352.0 |
| 2025-06-12 16:00:00 | MSFT | Stock | 478.87 | 480.0 | 478.3 | 478.43 | 3427976.0 |
| 2025-06-12 17:00:00 | MSFT | Stock | 478.78 | 479.05 | 478.5 | 479.05 | 43827.0 |
| 2025-06-12 18:00:00 | MSFT | Stock | 478.74 | 478.8059 | 478.0442 | 478.0442 | 1985.0 |
| 2025-06-12 19:00:00 | MSFT | Stock | 478.08 | 478.5 | 475.2 | 475.2 | 7860.0 |
| 2025-06-12 04:00:00 | NVDA | Stock | 142.0 | 142.47 | 141.0 | 141.87 | 427090.0 |
| 2025-06-12 05:00:00 | NVDA | Stock | 141.85 | 142.01 | 141.41 | 141.55 | 248349.0 |
| 2025-06-12 06:00:00 | NVDA | Stock | 141.53 | 141.73 | 140.92 | 141.28 | 414795.0 |
| 2025-06-12 07:00:00 | NVDA | Stock | 141.3 | 141.41 | 140.46 | 140.57 | 592830.0 |
| 2025-06-12 08:00:00 | NVDA | Stock | 141.29 | 142.5 | 140.46 | 141.6899 | 2242134.0 |
| 2025-06-12 09:00:00 | NVDA | Stock | 141.69 | 143.94 | 141.5 | 143.26 | 20851451.0 |
| 2025-06-12 10:00:00 | NVDA | Stock | 143.26 | 145.0 | 143.1718 | 144.7102 | 28746330.0 |
| 2025-06-12 11:00:00 | NVDA | Stock | 144.72 | 145.0 | 144.11 | 144.26 | 19017879.0 |
| 2025-06-12 12:00:00 | NVDA | Stock | 144.2519 | 144.6 | 143.97 | 144.195 | 11501011.0 |
| 2025-06-12 13:00:00 | NVDA | Stock | 144.2 | 144.67 | 144.03 | 144.485 | 8675147.0 |
| 2025-06-12 14:00:00 | NVDA | Stock | 144.49 | 144.835 | 144.25 | 144.63 | 11034093.0 |
| 2025-06-12 15:00:00 | NVDA | Stock | 144.62 | 145.0 | 144.5 | 145.0 | 19439473.0 |
| 2025-06-12 16:00:00 | NVDA | Stock | 144.995 | 145.0 | 144.63 | 144.8199 | 11783052.0 |
| 2025-06-12 17:00:00 | NVDA | Stock | 144.82 | 145.0 | 144.78 | 144.88 | 473962.0 |
| 2025-06-12 18:00:00 | NVDA | Stock | 144.87 | 144.8897 | 144.5 | 144.52 | 277352.0 |
| 2025-06-12 19:00:00 | NVDA | Stock | 144.53 | 144.8 | 144.36 | 144.5 | 327763.0 |
| 2025-06-12 04:00:00 | AMZN | Stock | 212.24 | 212.47 | 211.05 | 212.3 | 22620.0 |
| 2025-06-12 05:00:00 | AMZN | Stock | 212.31 | 212.95 | 212.31 | 212.59 | 11249.0 |
> showing 50 of 62,170 rows — these rows as CSV