PREVIEW / stock_1hour / 2025-08-22
file: by_date/stock_1hour/2025/2025-08-22.parquet size: 1.4 MB rows: 61,953 symbols: 330
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-22 04:00:00 | AAPL | Stock | 225.16 | 225.68 | 225.16 | 225.68 | 5038.0 |
| 2025-08-22 05:00:00 | AAPL | Stock | 225.77 | 225.77 | 225.61 | 225.65 | 2915.0 |
| 2025-08-22 06:00:00 | AAPL | Stock | 225.67 | 226.02 | 225.67 | 226.02 | 8245.0 |
| 2025-08-22 07:00:00 | AAPL | Stock | 226.02 | 226.25 | 225.9 | 226.02 | 6145.0 |
| 2025-08-22 08:00:00 | AAPL | Stock | 226.2 | 226.28 | 223.93 | 225.88 | 62407.0 |
| 2025-08-22 09:00:00 | AAPL | Stock | 225.99 | 226.9855 | 225.41 | 225.98 | 2691425.0 |
| 2025-08-22 10:00:00 | AAPL | Stock | 226.01 | 228.67 | 225.97 | 228.225 | 5561745.0 |
| 2025-08-22 11:00:00 | AAPL | Stock | 228.22 | 228.72 | 227.31 | 227.355 | 2673522.0 |
| 2025-08-22 12:00:00 | AAPL | Stock | 227.35 | 227.48 | 226.925 | 227.24 | 1933732.0 |
| 2025-08-22 13:00:00 | AAPL | Stock | 227.23 | 229.09 | 227.165 | 227.885 | 4058303.0 |
| 2025-08-22 14:00:00 | AAPL | Stock | 227.9 | 228.52 | 227.79 | 228.2 | 2363905.0 |
| 2025-08-22 15:00:00 | AAPL | Stock | 228.2 | 228.375 | 227.44 | 227.75 | 4091563.0 |
| 2025-08-22 16:00:00 | AAPL | Stock | 227.7712 | 227.98 | 227.575 | 227.83 | 5113788.0 |
| 2025-08-22 17:00:00 | AAPL | Stock | 227.89 | 227.9 | 227.76 | 227.83 | 13027.0 |
| 2025-08-22 18:00:00 | AAPL | Stock | 227.9 | 228.0 | 227.8301 | 227.8999 | 15002.0 |
| 2025-08-22 19:00:00 | AAPL | Stock | 227.88 | 228.1799 | 227.83 | 228.08 | 15581.0 |
| 2025-08-22 04:00:00 | MSFT | Stock | 504.35 | 505.64 | 504.35 | 505.37 | 2616.0 |
| 2025-08-22 05:00:00 | MSFT | Stock | 505.61 | 506.2 | 505.61 | 505.88 | 1230.0 |
| 2025-08-22 06:00:00 | MSFT | Stock | 505.73 | 505.73 | 505.73 | 505.73 | 100.0 |
| 2025-08-22 07:00:00 | MSFT | Stock | 505.74 | 505.85 | 504.7 | 504.99 | 4758.0 |
| 2025-08-22 08:00:00 | MSFT | Stock | 505.75 | 505.92 | 501.77 | 504.66 | 20237.0 |
| 2025-08-22 09:00:00 | MSFT | Stock | 504.6623 | 506.47 | 502.41 | 503.86 | 1099303.0 |
| 2025-08-22 10:00:00 | MSFT | Stock | 503.9 | 510.73 | 503.87 | 509.82 | 2712306.0 |
| 2025-08-22 11:00:00 | MSFT | Stock | 509.8625 | 510.73 | 507.11 | 507.38 | 1814606.0 |
| 2025-08-22 12:00:00 | MSFT | Stock | 507.49 | 507.835 | 506.05 | 506.27 | 1126652.0 |
| 2025-08-22 13:00:00 | MSFT | Stock | 506.265 | 508.13 | 506.2 | 508.09 | 979004.0 |
| 2025-08-22 14:00:00 | MSFT | Stock | 508.1 | 508.56 | 507.6627 | 507.98 | 950146.0 |
| 2025-08-22 15:00:00 | MSFT | Stock | 507.975 | 508.04 | 505.76 | 507.1 | 2356861.0 |
| 2025-08-22 16:00:00 | MSFT | Stock | 507.0949 | 507.5889 | 506.86 | 507.55 | 2537384.0 |
| 2025-08-22 17:00:00 | MSFT | Stock | 507.59 | 507.6 | 507.454 | 507.46 | 12634.0 |
| 2025-08-22 18:00:00 | MSFT | Stock | 507.51 | 507.51 | 507.2 | 507.2649 | 5242.0 |
| 2025-08-22 19:00:00 | MSFT | Stock | 507.4 | 507.45 | 507.305 | 507.4101 | 5851.0 |
| 2025-08-22 04:00:00 | NVDA | Stock | 172.45 | 173.53 | 168.0 | 173.38 | 452244.0 |
| 2025-08-22 05:00:00 | NVDA | Stock | 173.36 | 173.42 | 172.23 | 172.92 | 302324.0 |
| 2025-08-22 06:00:00 | NVDA | Stock | 172.96 | 173.41 | 172.8 | 172.98 | 197319.0 |
| 2025-08-22 07:00:00 | NVDA | Stock | 173.0 | 173.4 | 172.83 | 172.96 | 279894.0 |
| 2025-08-22 08:00:00 | NVDA | Stock | 172.98 | 173.53 | 171.11 | 172.3996 | 1722106.0 |
| 2025-08-22 09:00:00 | NVDA | Stock | 172.4 | 175.05 | 171.2 | 173.79 | 22926344.0 |
| 2025-08-22 10:00:00 | NVDA | Stock | 173.775 | 177.86 | 173.775 | 177.4128 | 36566040.0 |
| 2025-08-22 11:00:00 | NVDA | Stock | 177.415 | 178.59 | 177.272 | 177.7999 | 19037056.0 |
| 2025-08-22 12:00:00 | NVDA | Stock | 177.8 | 178.0599 | 176.88 | 177.2199 | 13399901.0 |
| 2025-08-22 13:00:00 | NVDA | Stock | 177.21 | 178.42 | 177.19 | 178.045 | 11157571.0 |
| 2025-08-22 14:00:00 | NVDA | Stock | 178.05 | 178.54 | 177.75 | 177.87 | 9855974.0 |
| 2025-08-22 15:00:00 | NVDA | Stock | 177.88 | 178.5 | 177.64 | 178.02 | 15448961.0 |
| 2025-08-22 16:00:00 | NVDA | Stock | 178.02 | 178.1 | 177.55 | 178.04 | 13019361.0 |
| 2025-08-22 17:00:00 | NVDA | Stock | 178.04 | 178.1 | 178.01 | 178.04 | 192052.0 |
| 2025-08-22 18:00:00 | NVDA | Stock | 178.05 | 178.29 | 178.0 | 178.24 | 205841.0 |
| 2025-08-22 19:00:00 | NVDA | Stock | 178.25 | 178.45 | 178.2099 | 178.38 | 243064.0 |
| 2025-08-22 04:00:00 | AMZN | Stock | 222.1 | 222.66 | 222.1 | 222.6 | 8803.0 |
| 2025-08-22 05:00:00 | AMZN | Stock | 222.5 | 222.66 | 222.41 | 222.65 | 5667.0 |
> showing 50 of 61,953 rows — these rows as CSV