PREVIEW / stock_1hour / 2025-08-29
file: by_date/stock_1hour/2025/2025-08-29.parquet size: 1.4 MB rows: 61,360 symbols: 328
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-08-29 04:00:00 | AAPL | Stock | 232.01 | 232.13 | 231.5 | 231.5 | 8604.0 |
| 2025-08-29 05:00:00 | AAPL | Stock | 231.39 | 231.49 | 231.26 | 231.42 | 2997.0 |
| 2025-08-29 06:00:00 | AAPL | Stock | 231.41 | 231.61 | 231.29 | 231.3 | 12291.0 |
| 2025-08-29 07:00:00 | AAPL | Stock | 231.6 | 232.24 | 231.6 | 232.15 | 8654.0 |
| 2025-08-29 08:00:00 | AAPL | Stock | 231.94 | 232.88 | 231.3 | 232.75 | 81377.0 |
| 2025-08-29 09:00:00 | AAPL | Stock | 232.87 | 233.38 | 231.83 | 232.56 | 3202883.0 |
| 2025-08-29 10:00:00 | AAPL | Stock | 232.58 | 233.16 | 231.37 | 232.875 | 4141278.0 |
| 2025-08-29 11:00:00 | AAPL | Stock | 232.86 | 233.11 | 231.4 | 231.7732 | 3527312.0 |
| 2025-08-29 12:00:00 | AAPL | Stock | 231.75 | 232.96 | 231.73 | 232.86 | 2087875.0 |
| 2025-08-29 13:00:00 | AAPL | Stock | 232.85 | 232.86 | 231.98 | 232.33 | 1858085.0 |
| 2025-08-29 14:00:00 | AAPL | Stock | 232.33 | 232.47 | 231.97 | 232.15 | 1715209.0 |
| 2025-08-29 15:00:00 | AAPL | Stock | 232.1499 | 232.8377 | 231.48 | 232.27 | 4614754.0 |
| 2025-08-29 16:00:00 | AAPL | Stock | 232.27 | 232.86 | 231.89 | 232.0001 | 6958898.0 |
| 2025-08-29 17:00:00 | AAPL | Stock | 232.09 | 232.14 | 232.0 | 232.1 | 21680.0 |
| 2025-08-29 18:00:00 | AAPL | Stock | 232.1001 | 232.19 | 232.0 | 232.1 | 11047.0 |
| 2025-08-29 19:00:00 | AAPL | Stock | 232.1 | 232.15 | 231.91 | 232.01 | 15514.0 |
| 2025-08-29 04:00:00 | MSFT | Stock | 509.56 | 509.56 | 508.31 | 508.31 | 1392.0 |
| 2025-08-29 05:00:00 | MSFT | Stock | 508.71 | 508.93 | 508.71 | 508.88 | 325.0 |
| 2025-08-29 06:00:00 | MSFT | Stock | 508.76 | 509.01 | 508.5 | 508.5 | 1357.0 |
| 2025-08-29 07:00:00 | MSFT | Stock | 509.0 | 509.125 | 508.6 | 508.6 | 1995.0 |
| 2025-08-29 08:00:00 | MSFT | Stock | 509.0 | 509.65 | 508.23 | 508.51 | 17486.0 |
| 2025-08-29 09:00:00 | MSFT | Stock | 509.25 | 509.6 | 504.68 | 504.74 | 1060180.0 |
| 2025-08-29 10:00:00 | MSFT | Stock | 504.93 | 506.96 | 504.4915 | 506.825 | 1062945.0 |
| 2025-08-29 11:00:00 | MSFT | Stock | 506.77 | 508.36 | 506.45 | 507.25 | 853855.0 |
| 2025-08-29 12:00:00 | MSFT | Stock | 507.265 | 508.81 | 507.2281 | 508.67 | 836556.0 |
| 2025-08-29 13:00:00 | MSFT | Stock | 508.63 | 508.95 | 507.27 | 508.64 | 598840.0 |
| 2025-08-29 14:00:00 | MSFT | Stock | 508.6 | 509.01 | 507.65 | 508.4899 | 635229.0 |
| 2025-08-29 15:00:00 | MSFT | Stock | 508.45 | 509.0 | 505.59 | 506.92 | 1648481.0 |
| 2025-08-29 16:00:00 | MSFT | Stock | 506.69 | 507.09 | 506.02 | 507.09 | 3805214.0 |
| 2025-08-29 17:00:00 | MSFT | Stock | 506.9 | 506.9 | 506.0 | 506.41 | 17153.0 |
| 2025-08-29 18:00:00 | MSFT | Stock | 506.41 | 506.41 | 506.4 | 506.41 | 440.0 |
| 2025-08-29 19:00:00 | MSFT | Stock | 506.45 | 506.8 | 506.41 | 506.7 | 4064.0 |
| 2025-08-29 04:00:00 | NVDA | Stock | 179.45 | 179.71 | 177.84 | 178.13 | 517944.0 |
| 2025-08-29 05:00:00 | NVDA | Stock | 178.16 | 178.58 | 177.45 | 178.13 | 381340.0 |
| 2025-08-29 06:00:00 | NVDA | Stock | 178.14 | 178.37 | 177.61 | 178.0 | 250163.0 |
| 2025-08-29 07:00:00 | NVDA | Stock | 178.03 | 178.53 | 177.93 | 178.25 | 391476.0 |
| 2025-08-29 08:00:00 | NVDA | Stock | 178.25 | 179.99 | 177.5 | 178.37 | 1947030.0 |
| 2025-08-29 09:00:00 | NVDA | Stock | 178.41 | 178.65 | 173.76 | 174.78 | 42701496.0 |
| 2025-08-29 10:00:00 | NVDA | Stock | 174.79 | 175.49 | 173.37 | 173.665 | 36684709.0 |
| 2025-08-29 11:00:00 | NVDA | Stock | 173.65 | 175.1399 | 173.51 | 173.7651 | 23040065.0 |
| 2025-08-29 12:00:00 | NVDA | Stock | 173.77 | 174.77 | 173.72 | 174.445 | 13626472.0 |
| 2025-08-29 13:00:00 | NVDA | Stock | 174.445 | 174.445 | 173.145 | 174.07 | 18431724.0 |
| 2025-08-29 14:00:00 | NVDA | Stock | 174.0701 | 174.24 | 173.48 | 174.215 | 12503473.0 |
| 2025-08-29 15:00:00 | NVDA | Stock | 174.215 | 174.51 | 173.25 | 174.28 | 26409415.0 |
| 2025-08-29 16:00:00 | NVDA | Stock | 174.27 | 174.34 | 173.6 | 173.83 | 22765077.0 |
| 2025-08-29 17:00:00 | NVDA | Stock | 173.8099 | 174.18 | 173.74 | 173.88 | 257002.0 |
| 2025-08-29 18:00:00 | NVDA | Stock | 173.88 | 173.99 | 173.8 | 173.8601 | 212849.0 |
| 2025-08-29 19:00:00 | NVDA | Stock | 173.87 | 173.89 | 173.67 | 173.6705 | 221525.0 |
| 2025-08-29 04:00:00 | AMZN | Stock | 230.95 | 230.95 | 230.37 | 230.37 | 12903.0 |
| 2025-08-29 05:00:00 | AMZN | Stock | 230.4 | 230.58 | 230.27 | 230.52 | 6930.0 |
> showing 50 of 61,360 rows — these rows as CSV