PREVIEW / stock_1hour / 2025-11-19
file: by_date/stock_1hour/2025/2025-11-19.parquet size: 1.4 MB rows: 60,443 symbols: 209
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-11-19 04:00:00 | AAPL | Stock | 267.19 | 267.29 | 266.43 | 267.29 | 6059.0 |
| 2025-11-19 05:00:00 | AAPL | Stock | 267.3 | 267.55 | 267.27 | 267.46 | 2802.0 |
| 2025-11-19 06:00:00 | AAPL | Stock | 267.48 | 267.89 | 267.31 | 267.51 | 7851.0 |
| 2025-11-19 07:00:00 | AAPL | Stock | 267.56 | 267.6 | 267.11 | 267.24 | 6053.0 |
| 2025-11-19 08:00:00 | AAPL | Stock | 267.48 | 268.0 | 266.16 | 266.7499 | 38614.0 |
| 2025-11-19 09:00:00 | AAPL | Stock | 266.69 | 270.91 | 264.65 | 270.885 | 4338053.0 |
| 2025-11-19 10:00:00 | AAPL | Stock | 270.92 | 272.21 | 270.0585 | 270.272 | 3569825.0 |
| 2025-11-19 11:00:00 | AAPL | Stock | 270.25 | 270.59 | 269.3201 | 270.56 | 2119944.0 |
| 2025-11-19 12:00:00 | AAPL | Stock | 270.5618 | 271.0 | 269.62 | 270.845 | 1877970.0 |
| 2025-11-19 13:00:00 | AAPL | Stock | 270.845 | 271.31 | 269.95 | 270.8 | 1827597.0 |
| 2025-11-19 14:00:00 | AAPL | Stock | 270.88 | 270.95 | 269.17 | 269.73 | 1587034.0 |
| 2025-11-19 15:00:00 | AAPL | Stock | 269.72 | 270.735 | 268.14 | 268.5201 | 5183800.0 |
| 2025-11-19 16:00:00 | AAPL | Stock | 268.62 | 269.8999 | 267.7 | 268.5 | 7637395.0 |
| 2025-11-19 17:00:00 | AAPL | Stock | 268.09 | 268.28 | 266.27 | 267.77 | 68722.0 |
| 2025-11-19 18:00:00 | AAPL | Stock | 267.99 | 269.18 | 267.99 | 269.0 | 34166.0 |
| 2025-11-19 19:00:00 | AAPL | Stock | 269.11 | 270.0 | 268.91 | 269.65 | 25169.0 |
| 2025-11-19 04:00:00 | MSFT | Stock | 492.6 | 494.27 | 492.06 | 494.0 | 6370.0 |
| 2025-11-19 05:00:00 | MSFT | Stock | 494.17 | 494.4 | 493.83 | 494.05 | 6243.0 |
| 2025-11-19 06:00:00 | MSFT | Stock | 494.0 | 495.45 | 494.0 | 494.16 | 9986.0 |
| 2025-11-19 07:00:00 | MSFT | Stock | 494.15 | 494.28 | 492.82 | 492.93 | 16661.0 |
| 2025-11-19 08:00:00 | MSFT | Stock | 492.95 | 495.22 | 491.7 | 492.5 | 49587.0 |
| 2025-11-19 09:00:00 | MSFT | Stock | 492.37 | 494.87 | 488.34 | 494.67 | 2120363.0 |
| 2025-11-19 10:00:00 | MSFT | Stock | 494.73 | 495.1872 | 487.83 | 488.25 | 1955275.0 |
| 2025-11-19 11:00:00 | MSFT | Stock | 488.23 | 489.73 | 487.625 | 488.85 | 1316688.0 |
| 2025-11-19 12:00:00 | MSFT | Stock | 488.82 | 489.1613 | 484.18 | 485.755 | 2083705.0 |
| 2025-11-19 13:00:00 | MSFT | Stock | 485.72 | 487.37 | 485.23 | 486.1875 | 1479167.0 |
| 2025-11-19 14:00:00 | MSFT | Stock | 486.1875 | 486.27 | 482.83 | 485.09 | 1482926.0 |
| 2025-11-19 15:00:00 | MSFT | Stock | 485.09 | 488.63 | 484.96 | 486.979 | 2804157.0 |
| 2025-11-19 16:00:00 | MSFT | Stock | 487.03 | 491.0 | 485.68 | 489.88 | 3975528.0 |
| 2025-11-19 17:00:00 | MSFT | Stock | 489.72 | 491.5381 | 487.12 | 489.95 | 83446.0 |
| 2025-11-19 18:00:00 | MSFT | Stock | 490.0 | 492.0 | 490.0 | 491.87 | 34235.0 |
| 2025-11-19 19:00:00 | MSFT | Stock | 491.86 | 494.245 | 491.86 | 493.7099 | 42440.0 |
| 2025-11-19 04:00:00 | NVDA | Stock | 181.52 | 182.41 | 181.2 | 182.37 | 213096.0 |
| 2025-11-19 05:00:00 | NVDA | Stock | 182.44 | 182.9 | 182.0 | 182.83 | 157439.0 |
| 2025-11-19 06:00:00 | NVDA | Stock | 182.8 | 183.77 | 182.6 | 183.28 | 373535.0 |
| 2025-11-19 07:00:00 | NVDA | Stock | 183.26 | 184.81 | 183.17 | 184.19 | 845517.0 |
| 2025-11-19 08:00:00 | NVDA | Stock | 183.54 | 184.85 | 180.88 | 184.66 | 2957595.0 |
| 2025-11-19 09:00:00 | NVDA | Stock | 184.66 | 187.6951 | 183.28 | 187.58 | 23720939.0 |
| 2025-11-19 10:00:00 | NVDA | Stock | 187.6 | 187.855 | 185.5 | 185.86 | 21716871.0 |
| 2025-11-19 11:00:00 | NVDA | Stock | 185.87 | 186.4748 | 184.5989 | 185.145 | 18160039.0 |
| 2025-11-19 12:00:00 | NVDA | Stock | 185.14 | 185.21 | 182.8301 | 184.81 | 16509298.0 |
| 2025-11-19 13:00:00 | NVDA | Stock | 184.8 | 185.9 | 184.12 | 185.425 | 14652823.0 |
| 2025-11-19 14:00:00 | NVDA | Stock | 185.42 | 186.105 | 184.36 | 185.4323 | 13888626.0 |
| 2025-11-19 15:00:00 | NVDA | Stock | 185.41 | 187.3459 | 185.37 | 186.775 | 25621964.0 |
| 2025-11-19 16:00:00 | NVDA | Stock | 186.79 | 195.83 | 185.7171 | 194.7 | 32060966.0 |
| 2025-11-19 17:00:00 | NVDA | Stock | 194.59 | 198.6 | 186.52 | 194.3 | 14018523.0 |
| 2025-11-19 18:00:00 | NVDA | Stock | 194.4555 | 196.99 | 194.3002 | 196.2 | 3439596.0 |
| 2025-11-19 19:00:00 | NVDA | Stock | 196.16 | 197.0 | 195.69 | 195.9997 | 2062955.0 |
| 2025-11-19 04:00:00 | AMZN | Stock | 223.05 | 224.19 | 222.66 | 223.75 | 24836.0 |
| 2025-11-19 05:00:00 | AMZN | Stock | 223.77 | 224.27 | 223.77 | 223.93 | 13114.0 |
> showing 50 of 60,443 rows — these rows as CSV