PREVIEW / stock_1hour / 2025-10-17
file: by_date/stock_1hour/2025/2025-10-17.parquet size: 1.5 MB rows: 66,510 symbols: 231
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-10-17 04:00:00 | AAPL | Stock | 246.2 | 246.3 | 244.07 | 245.35 | 25877.0 |
| 2025-10-17 05:00:00 | AAPL | Stock | 245.3 | 245.69 | 244.98 | 245.25 | 9015.0 |
| 2025-10-17 06:00:00 | AAPL | Stock | 245.4 | 245.78 | 244.4 | 245.71 | 33759.0 |
| 2025-10-17 07:00:00 | AAPL | Stock | 245.97 | 247.5 | 245.77 | 247.22 | 48231.0 |
| 2025-10-17 08:00:00 | AAPL | Stock | 245.9 | 247.98 | 244.01 | 247.11 | 118816.0 |
| 2025-10-17 09:00:00 | AAPL | Stock | 247.18 | 249.19 | 246.75 | 248.41 | 5624188.0 |
| 2025-10-17 10:00:00 | AAPL | Stock | 248.41 | 250.32 | 248.26 | 248.874 | 3375527.0 |
| 2025-10-17 11:00:00 | AAPL | Stock | 248.91 | 249.78 | 248.0972 | 249.5775 | 2408208.0 |
| 2025-10-17 12:00:00 | AAPL | Stock | 249.54 | 251.36 | 249.4502 | 251.13 | 3632447.0 |
| 2025-10-17 13:00:00 | AAPL | Stock | 251.13 | 251.37 | 250.245 | 251.3 | 2322631.0 |
| 2025-10-17 14:00:00 | AAPL | Stock | 251.319 | 252.535 | 251.319 | 252.2735 | 2861385.0 |
| 2025-10-17 15:00:00 | AAPL | Stock | 252.28 | 253.38 | 252.1001 | 252.3 | 6005911.0 |
| 2025-10-17 16:00:00 | AAPL | Stock | 252.3 | 253.41 | 252.17 | 252.61 | 6043901.0 |
| 2025-10-17 17:00:00 | AAPL | Stock | 252.58 | 252.7 | 252.4 | 252.55 | 22360.0 |
| 2025-10-17 18:00:00 | AAPL | Stock | 252.65 | 252.7 | 252.26 | 252.26 | 17069.0 |
| 2025-10-17 19:00:00 | AAPL | Stock | 252.2 | 252.4932 | 251.8331 | 252.4001 | 16224.0 |
| 2025-10-17 04:00:00 | MSFT | Stock | 506.7 | 510.51 | 506.7 | 509.42 | 12185.0 |
| 2025-10-17 05:00:00 | MSFT | Stock | 509.6 | 509.62 | 507.11 | 507.74 | 4827.0 |
| 2025-10-17 06:00:00 | MSFT | Stock | 507.84 | 508.9 | 506.94 | 508.07 | 8967.0 |
| 2025-10-17 07:00:00 | MSFT | Stock | 508.29 | 509.96 | 508.2 | 509.79 | 9847.0 |
| 2025-10-17 08:00:00 | MSFT | Stock | 508.5 | 511.0 | 506.11 | 510.1 | 41835.0 |
| 2025-10-17 09:00:00 | MSFT | Stock | 510.0 | 511.89 | 507.31 | 510.0 | 2166201.0 |
| 2025-10-17 10:00:00 | MSFT | Stock | 509.94 | 512.655 | 509.025 | 509.5 | 819179.0 |
| 2025-10-17 11:00:00 | MSFT | Stock | 509.55 | 511.59 | 508.68 | 511.06 | 735866.0 |
| 2025-10-17 12:00:00 | MSFT | Stock | 511.12 | 514.3655 | 511.109 | 513.16 | 555452.0 |
| 2025-10-17 13:00:00 | MSFT | Stock | 513.14 | 513.3299 | 511.25 | 513.15 | 328901.0 |
| 2025-10-17 14:00:00 | MSFT | Stock | 513.19 | 515.298 | 513.19 | 514.341 | 521777.0 |
| 2025-10-17 15:00:00 | MSFT | Stock | 514.37 | 515.48 | 513.27 | 513.51 | 1268172.0 |
| 2025-10-17 16:00:00 | MSFT | Stock | 513.58 | 515.0 | 513.35 | 514.69 | 3163827.0 |
| 2025-10-17 17:00:00 | MSFT | Stock | 514.5 | 514.9 | 514.0 | 514.15 | 2445.0 |
| 2025-10-17 18:00:00 | MSFT | Stock | 514.89 | 514.89 | 513.82 | 514.1 | 4319.0 |
| 2025-10-17 19:00:00 | MSFT | Stock | 513.9852 | 514.6887 | 513.75 | 514.6887 | 2902.0 |
| 2025-10-17 04:00:00 | NVDA | Stock | 177.58 | 179.81 | 176.21 | 177.135 | 811769.0 |
| 2025-10-17 05:00:00 | NVDA | Stock | 177.1 | 177.92 | 176.99 | 177.22 | 360473.0 |
| 2025-10-17 06:00:00 | NVDA | Stock | 177.28 | 178.4 | 177.28 | 178.35 | 377534.0 |
| 2025-10-17 07:00:00 | NVDA | Stock | 178.38 | 179.97 | 178.07 | 179.95 | 737208.0 |
| 2025-10-17 08:00:00 | NVDA | Stock | 178.28 | 180.87 | 176.23 | 179.94 | 2709416.0 |
| 2025-10-17 09:00:00 | NVDA | Stock | 179.92 | 182.42 | 179.5339 | 181.8 | 21136405.0 |
| 2025-10-17 10:00:00 | NVDA | Stock | 181.79 | 183.53 | 181.07 | 181.25 | 24219340.0 |
| 2025-10-17 11:00:00 | NVDA | Stock | 181.24 | 182.32 | 180.02 | 182.065 | 17741275.0 |
| 2025-10-17 12:00:00 | NVDA | Stock | 182.065 | 182.97 | 182.055 | 182.44 | 12809851.0 |
| 2025-10-17 13:00:00 | NVDA | Stock | 182.44 | 183.01 | 181.93 | 182.8551 | 11437431.0 |
| 2025-10-17 14:00:00 | NVDA | Stock | 182.85 | 183.865 | 182.78 | 183.4799 | 12422173.0 |
| 2025-10-17 15:00:00 | NVDA | Stock | 183.48 | 184.1 | 182.84 | 183.235 | 15968949.0 |
| 2025-10-17 16:00:00 | NVDA | Stock | 183.24 | 183.3213 | 183.0585 | 183.26 | 10289686.0 |
| 2025-10-17 17:00:00 | NVDA | Stock | 183.25 | 183.25 | 183.05 | 183.16 | 125344.0 |
| 2025-10-17 18:00:00 | NVDA | Stock | 183.1503 | 183.18 | 183.04 | 183.09 | 88204.0 |
| 2025-10-17 19:00:00 | NVDA | Stock | 183.0801 | 183.39 | 183.01 | 183.37 | 181469.0 |
| 2025-10-17 04:00:00 | AMZN | Stock | 212.63 | 212.63 | 211.47 | 212.19 | 59902.0 |
| 2025-10-17 05:00:00 | AMZN | Stock | 212.01 | 213.0 | 212.01 | 212.85 | 26631.0 |
> showing 50 of 66,510 rows — these rows as CSV