PREVIEW / stock_1hour / 2025-09-18
file: by_date/stock_1hour/2025/2025-09-18.parquet size: 1.5 MB rows: 65,690 symbols: 311
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-09-18 04:00:00 | AAPL | Stock | 240.7 | 240.98 | 240.0 | 240.9 | 28755.0 |
| 2025-09-18 05:00:00 | AAPL | Stock | 240.9 | 240.93 | 240.11 | 240.33 | 18927.0 |
| 2025-09-18 06:00:00 | AAPL | Stock | 240.33 | 240.33 | 239.81 | 240.2 | 13988.0 |
| 2025-09-18 07:00:00 | AAPL | Stock | 240.11 | 240.28 | 239.07 | 239.4 | 36824.0 |
| 2025-09-18 08:00:00 | AAPL | Stock | 240.05 | 240.97 | 239.0109 | 239.22 | 209880.0 |
| 2025-09-18 09:00:00 | AAPL | Stock | 239.22 | 241.2 | 237.63 | 238.445 | 5137696.0 |
| 2025-09-18 10:00:00 | AAPL | Stock | 238.43 | 238.43 | 236.65 | 238.235 | 5499409.0 |
| 2025-09-18 11:00:00 | AAPL | Stock | 238.25 | 238.795 | 237.35 | 237.61 | 3012581.0 |
| 2025-09-18 12:00:00 | AAPL | Stock | 237.59 | 238.18 | 237.445 | 237.955 | 2246951.0 |
| 2025-09-18 13:00:00 | AAPL | Stock | 237.95 | 238.21 | 237.2102 | 237.39 | 2231065.0 |
| 2025-09-18 14:00:00 | AAPL | Stock | 237.38 | 238.02 | 237.313 | 237.69 | 2255931.0 |
| 2025-09-18 15:00:00 | AAPL | Stock | 237.69 | 238.11 | 237.2501 | 237.85 | 4613306.0 |
| 2025-09-18 16:00:00 | AAPL | Stock | 237.88 | 238.15 | 237.86 | 238.03 | 8768352.0 |
| 2025-09-18 17:00:00 | AAPL | Stock | 238.02 | 238.15 | 237.88 | 238.13 | 26129.0 |
| 2025-09-18 18:00:00 | AAPL | Stock | 238.1 | 238.18 | 238.07 | 238.18 | 15637.0 |
| 2025-09-18 19:00:00 | AAPL | Stock | 238.1197 | 238.2 | 238.1 | 238.15 | 16319.0 |
| 2025-09-18 04:00:00 | MSFT | Stock | 510.88 | 514.49 | 510.88 | 514.3 | 15881.0 |
| 2025-09-18 05:00:00 | MSFT | Stock | 514.0 | 514.0 | 513.4 | 513.5 | 7076.0 |
| 2025-09-18 06:00:00 | MSFT | Stock | 513.5 | 513.7 | 512.31 | 512.91 | 4868.0 |
| 2025-09-18 07:00:00 | MSFT | Stock | 512.46 | 512.7 | 511.41 | 512.6 | 13358.0 |
| 2025-09-18 08:00:00 | MSFT | Stock | 513.5 | 514.14 | 511.5 | 511.5 | 50033.0 |
| 2025-09-18 09:00:00 | MSFT | Stock | 511.26 | 511.52 | 507.66 | 510.07 | 1612600.0 |
| 2025-09-18 10:00:00 | MSFT | Stock | 510.025 | 513.07 | 509.22 | 511.175 | 1350211.0 |
| 2025-09-18 11:00:00 | MSFT | Stock | 511.23 | 511.52 | 508.155 | 508.155 | 834422.0 |
| 2025-09-18 12:00:00 | MSFT | Stock | 508.13 | 509.66 | 507.875 | 509.505 | 889936.0 |
| 2025-09-18 13:00:00 | MSFT | Stock | 509.53 | 510.09 | 508.37 | 508.4 | 477596.0 |
| 2025-09-18 14:00:00 | MSFT | Stock | 508.38 | 508.93 | 507.875 | 508.82 | 925872.0 |
| 2025-09-18 15:00:00 | MSFT | Stock | 508.8004 | 509.66 | 508.08 | 508.27 | 1578387.0 |
| 2025-09-18 16:00:00 | MSFT | Stock | 508.45 | 509.47 | 508.428 | 508.45 | 3223641.0 |
| 2025-09-18 17:00:00 | MSFT | Stock | 508.6 | 509.05 | 508.45 | 509.0 | 7895.0 |
| 2025-09-18 18:00:00 | MSFT | Stock | 509.15 | 509.15 | 508.831 | 508.95 | 1696.0 |
| 2025-09-18 19:00:00 | MSFT | Stock | 508.89 | 509.1 | 508.89 | 509.05 | 3816.0 |
| 2025-09-18 04:00:00 | NVDA | Stock | 172.03 | 173.38 | 171.92 | 173.27 | 505422.0 |
| 2025-09-18 05:00:00 | NVDA | Stock | 173.27 | 174.65 | 173.23 | 174.21 | 497012.0 |
| 2025-09-18 06:00:00 | NVDA | Stock | 174.24 | 174.58 | 174.0 | 174.32 | 472203.0 |
| 2025-09-18 07:00:00 | NVDA | Stock | 174.34 | 176.169 | 174.05 | 175.5 | 2533379.0 |
| 2025-09-18 08:00:00 | NVDA | Stock | 174.23 | 176.1675 | 171.54 | 174.69 | 3575960.0 |
| 2025-09-18 09:00:00 | NVDA | Stock | 174.71 | 175.38 | 172.96 | 173.535 | 26796219.0 |
| 2025-09-18 10:00:00 | NVDA | Stock | 173.535 | 176.24 | 173.5 | 175.2743 | 29463844.0 |
| 2025-09-18 11:00:00 | NVDA | Stock | 175.28 | 176.57 | 175.255 | 176.0051 | 18729943.0 |
| 2025-09-18 12:00:00 | NVDA | Stock | 176.0 | 176.71 | 175.805 | 176.5857 | 11366784.0 |
| 2025-09-18 13:00:00 | NVDA | Stock | 176.585 | 176.93 | 176.1 | 176.285 | 11607750.0 |
| 2025-09-18 14:00:00 | NVDA | Stock | 176.28 | 177.09 | 176.0 | 176.855 | 12977393.0 |
| 2025-09-18 15:00:00 | NVDA | Stock | 176.855 | 177.1 | 174.21 | 176.28 | 19358056.0 |
| 2025-09-18 16:00:00 | NVDA | Stock | 176.24 | 176.42 | 175.8 | 176.24 | 16593825.0 |
| 2025-09-18 17:00:00 | NVDA | Stock | 176.2301 | 176.31 | 176.0 | 176.17 | 166776.0 |
| 2025-09-18 18:00:00 | NVDA | Stock | 176.19 | 176.44 | 176.1005 | 176.3501 | 169882.0 |
| 2025-09-18 19:00:00 | NVDA | Stock | 176.3236 | 176.4 | 176.25 | 176.39 | 167575.0 |
| 2025-09-18 04:00:00 | AMZN | Stock | 233.2 | 233.5 | 232.8 | 233.42 | 27705.0 |
| 2025-09-18 05:00:00 | AMZN | Stock | 233.45 | 233.48 | 232.68 | 232.99 | 19076.0 |
> showing 50 of 65,690 rows — these rows as CSV