PREVIEW / stock_1hour / 2025-06-16
file: by_date/stock_1hour/2025/2025-06-16.parquet size: 1.4 MB rows: 63,743 symbols: 401
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-16 04:00:00 | AAPL | Stock | 197.02 | 198.12 | 197.02 | 198.01 | 28301.0 |
| 2025-06-16 05:00:00 | AAPL | Stock | 198.0 | 198.0 | 197.54 | 197.62 | 7657.0 |
| 2025-06-16 06:00:00 | AAPL | Stock | 197.68 | 197.75 | 197.56 | 197.75 | 6227.0 |
| 2025-06-16 07:00:00 | AAPL | Stock | 197.69 | 197.75 | 197.3 | 197.74 | 26823.0 |
| 2025-06-16 08:00:00 | AAPL | Stock | 197.52 | 198.0 | 196.45 | 197.7 | 239875.0 |
| 2025-06-16 09:00:00 | AAPL | Stock | 197.66 | 198.35 | 196.5636 | 198.34 | 5105537.0 |
| 2025-06-16 10:00:00 | AAPL | Stock | 198.35 | 198.685 | 197.64 | 198.22 | 4468544.0 |
| 2025-06-16 11:00:00 | AAPL | Stock | 198.225 | 198.225 | 196.87 | 197.3699 | 3947360.0 |
| 2025-06-16 12:00:00 | AAPL | Stock | 197.37 | 197.63 | 197.02 | 197.52 | 1971761.0 |
| 2025-06-16 13:00:00 | AAPL | Stock | 197.51 | 198.19 | 197.33 | 197.85 | 2312204.0 |
| 2025-06-16 14:00:00 | AAPL | Stock | 197.86 | 198.3985 | 197.77 | 198.3201 | 1862650.0 |
| 2025-06-16 15:00:00 | AAPL | Stock | 198.32 | 198.49 | 197.66 | 198.37 | 5137935.0 |
| 2025-06-16 16:00:00 | AAPL | Stock | 198.42 | 198.42 | 197.65 | 198.07 | 6363726.0 |
| 2025-06-16 17:00:00 | AAPL | Stock | 198.05 | 198.16 | 197.89 | 198.15 | 23655.0 |
| 2025-06-16 18:00:00 | AAPL | Stock | 198.1102 | 198.12 | 197.31 | 197.6 | 42363.0 |
| 2025-06-16 19:00:00 | AAPL | Stock | 197.65 | 197.8 | 197.08 | 197.08 | 62608.0 |
| 2025-06-16 04:00:00 | MSFT | Stock | 476.12 | 476.6 | 475.43 | 476.32 | 5958.0 |
| 2025-06-16 05:00:00 | MSFT | Stock | 476.0 | 476.48 | 475.92 | 475.99 | 2764.0 |
| 2025-06-16 06:00:00 | MSFT | Stock | 475.99 | 476.02 | 475.67 | 476.02 | 3528.0 |
| 2025-06-16 07:00:00 | MSFT | Stock | 475.95 | 476.46 | 475.64 | 476.46 | 4284.0 |
| 2025-06-16 08:00:00 | MSFT | Stock | 475.5 | 477.19 | 473.773 | 476.6 | 18583.0 |
| 2025-06-16 09:00:00 | MSFT | Stock | 476.5 | 479.77 | 474.87 | 479.465 | 1374532.0 |
| 2025-06-16 10:00:00 | MSFT | Stock | 479.48 | 480.6943 | 479.36 | 479.53 | 1316670.0 |
| 2025-06-16 11:00:00 | MSFT | Stock | 479.55 | 480.67 | 479.19 | 480.26 | 894113.0 |
| 2025-06-16 12:00:00 | MSFT | Stock | 480.24 | 480.5704 | 479.555 | 479.75 | 458858.0 |
| 2025-06-16 13:00:00 | MSFT | Stock | 479.72 | 480.3192 | 478.78 | 478.8908 | 478239.0 |
| 2025-06-16 14:00:00 | MSFT | Stock | 478.935 | 479.11 | 477.7628 | 478.365 | 507232.0 |
| 2025-06-16 15:00:00 | MSFT | Stock | 478.32 | 479.4 | 477.86 | 479.14 | 1498141.0 |
| 2025-06-16 16:00:00 | MSFT | Stock | 479.14 | 479.14 | 477.1 | 477.3 | 3023037.0 |
| 2025-06-16 17:00:00 | MSFT | Stock | 477.3 | 479.14 | 477.2132 | 477.51 | 32195.0 |
| 2025-06-16 18:00:00 | MSFT | Stock | 478.0 | 478.0 | 475.9934 | 476.0 | 3875.0 |
| 2025-06-16 19:00:00 | MSFT | Stock | 476.5 | 477.0 | 475.0 | 475.299 | 20727.0 |
| 2025-06-16 04:00:00 | NVDA | Stock | 142.8 | 143.25 | 142.59 | 143.05 | 239900.0 |
| 2025-06-16 05:00:00 | NVDA | Stock | 143.06 | 143.08 | 142.64 | 142.89 | 187408.0 |
| 2025-06-16 06:00:00 | NVDA | Stock | 142.87 | 143.3 | 142.81 | 143.28 | 215716.0 |
| 2025-06-16 07:00:00 | NVDA | Stock | 143.25 | 143.3 | 143.0 | 143.29 | 422265.0 |
| 2025-06-16 08:00:00 | NVDA | Stock | 143.15 | 143.53 | 142.41 | 143.39 | 1523355.0 |
| 2025-06-16 09:00:00 | NVDA | Stock | 143.39 | 144.77 | 141.97 | 144.735 | 23058491.0 |
| 2025-06-16 10:00:00 | NVDA | Stock | 144.738 | 144.89 | 144.02 | 144.75 | 22933799.0 |
| 2025-06-16 11:00:00 | NVDA | Stock | 144.745 | 146.175 | 144.71 | 145.495 | 33748085.0 |
| 2025-06-16 12:00:00 | NVDA | Stock | 145.4993 | 146.06 | 145.4801 | 145.67 | 15001101.0 |
| 2025-06-16 13:00:00 | NVDA | Stock | 145.665 | 145.8 | 145.03 | 145.2 | 11627395.0 |
| 2025-06-16 14:00:00 | NVDA | Stock | 145.2 | 145.35 | 144.85 | 145.0028 | 9785573.0 |
| 2025-06-16 15:00:00 | NVDA | Stock | 145.0 | 145.25 | 144.27 | 144.68 | 20914678.0 |
| 2025-06-16 16:00:00 | NVDA | Stock | 144.69 | 144.69 | 144.38 | 144.52 | 14305335.0 |
| 2025-06-16 17:00:00 | NVDA | Stock | 144.52 | 144.8 | 144.44 | 144.63 | 311893.0 |
| 2025-06-16 18:00:00 | NVDA | Stock | 144.62 | 144.78 | 144.03 | 144.12 | 462469.0 |
| 2025-06-16 19:00:00 | NVDA | Stock | 144.12 | 144.37 | 143.65 | 143.66 | 577695.0 |
| 2025-06-16 04:00:00 | AMZN | Stock | 213.07 | 213.7 | 212.95 | 213.5 | 17715.0 |
| 2025-06-16 05:00:00 | AMZN | Stock | 213.54 | 213.54 | 213.05 | 213.35 | 2534.0 |
> showing 50 of 63,743 rows — these rows as CSV