PREVIEW / stock_1hour / 2025-11-20
file: by_date/stock_1hour/2025/2025-11-20.parquet size: 1.4 MB rows: 61,728 symbols: 210
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-20 04:00:00 | AAPL | Stock | 269.55 | 269.8 | 268.8 | 269.26 | 7824.0 |
| 2025-11-20 05:00:00 | AAPL | Stock | 269.18 | 269.8 | 268.97 | 269.71 | 5911.0 |
| 2025-11-20 06:00:00 | AAPL | Stock | 269.5 | 269.98 | 269.3 | 269.35 | 8246.0 |
| 2025-11-20 07:00:00 | AAPL | Stock | 269.4 | 270.0 | 269.4 | 270.0 | 11758.0 |
| 2025-11-20 08:00:00 | AAPL | Stock | 269.5 | 270.9 | 269.1006 | 270.4 | 119025.0 |
| 2025-11-20 09:00:00 | AAPL | Stock | 270.2487 | 275.43 | 269.8 | 275.0 | 6561487.0 |
| 2025-11-20 10:00:00 | AAPL | Stock | 274.955 | 275.1 | 273.095 | 273.54 | 3124833.0 |
| 2025-11-20 11:00:00 | AAPL | Stock | 273.6 | 273.6 | 268.98 | 269.349 | 2862665.0 |
| 2025-11-20 12:00:00 | AAPL | Stock | 269.32 | 270.0 | 267.0201 | 267.48 | 3599169.0 |
| 2025-11-20 13:00:00 | AAPL | Stock | 267.51 | 269.21 | 266.52 | 266.94 | 2397063.0 |
| 2025-11-20 14:00:00 | AAPL | Stock | 266.96 | 268.07 | 266.36 | 267.805 | 1794932.0 |
| 2025-11-20 15:00:00 | AAPL | Stock | 267.81 | 267.88 | 265.92 | 266.38 | 4513117.0 |
| 2025-11-20 16:00:00 | AAPL | Stock | 266.25 | 266.25 | 265.25 | 265.25 | 6216668.0 |
| 2025-11-20 17:00:00 | AAPL | Stock | 265.21 | 266.2 | 265.0 | 266.2 | 46657.0 |
| 2025-11-20 18:00:00 | AAPL | Stock | 266.2 | 267.27 | 265.5 | 266.25 | 48189.0 |
| 2025-11-20 19:00:00 | AAPL | Stock | 266.45 | 267.28 | 266.45 | 266.9 | 10859.0 |
| 2025-11-20 04:00:00 | MSFT | Stock | 492.99 | 493.48 | 489.52 | 490.06 | 21950.0 |
| 2025-11-20 05:00:00 | MSFT | Stock | 490.31 | 491.28 | 490.12 | 491.25 | 12113.0 |
| 2025-11-20 06:00:00 | MSFT | Stock | 491.19 | 491.61 | 490.1 | 491.5 | 13715.0 |
| 2025-11-20 07:00:00 | MSFT | Stock | 491.56 | 493.81 | 491.0 | 493.4 | 17894.0 |
| 2025-11-20 08:00:00 | MSFT | Stock | 492.0 | 494.4111 | 490.03 | 493.01 | 152855.0 |
| 2025-11-20 09:00:00 | MSFT | Stock | 492.97 | 493.48 | 489.8 | 492.93 | 2559603.0 |
| 2025-11-20 10:00:00 | MSFT | Stock | 492.93 | 493.57 | 490.52 | 490.72 | 1889819.0 |
| 2025-11-20 11:00:00 | MSFT | Stock | 490.73 | 490.78 | 482.22 | 482.415 | 2074729.0 |
| 2025-11-20 12:00:00 | MSFT | Stock | 482.36 | 483.3029 | 479.19 | 480.445 | 2638467.0 |
| 2025-11-20 13:00:00 | MSFT | Stock | 480.42 | 483.37 | 478.28 | 479.25 | 1566596.0 |
| 2025-11-20 14:00:00 | MSFT | Stock | 479.295 | 480.48 | 478.52 | 480.1924 | 1345022.0 |
| 2025-11-20 15:00:00 | MSFT | Stock | 480.18 | 480.6 | 475.5 | 478.26 | 3427110.0 |
| 2025-11-20 16:00:00 | MSFT | Stock | 478.21 | 481.6221 | 476.25 | 477.1 | 3926446.0 |
| 2025-11-20 17:00:00 | MSFT | Stock | 477.0753 | 477.53 | 476.21 | 476.377 | 30905.0 |
| 2025-11-20 18:00:00 | MSFT | Stock | 476.66 | 478.43 | 475.91 | 476.6 | 47567.0 |
| 2025-11-20 19:00:00 | MSFT | Stock | 477.0 | 477.4 | 476.51 | 476.89 | 23576.0 |
| 2025-11-20 04:00:00 | NVDA | Stock | 196.06 | 198.0 | 195.7 | 195.93 | 779967.0 |
| 2025-11-20 05:00:00 | NVDA | Stock | 195.95 | 196.3 | 194.5 | 196.0 | 707874.0 |
| 2025-11-20 06:00:00 | NVDA | Stock | 196.02 | 196.2 | 194.83 | 195.73 | 372247.0 |
| 2025-11-20 07:00:00 | NVDA | Stock | 195.76 | 196.0 | 195.13 | 195.91 | 810445.0 |
| 2025-11-20 08:00:00 | NVDA | Stock | 195.93 | 198.49 | 194.6 | 196.01 | 5302881.0 |
| 2025-11-20 09:00:00 | NVDA | Stock | 196.01 | 196.7 | 192.29 | 195.29 | 42001441.0 |
| 2025-11-20 10:00:00 | NVDA | Stock | 195.29 | 195.59 | 192.01 | 192.3572 | 31860643.0 |
| 2025-11-20 11:00:00 | NVDA | Stock | 192.36 | 192.38 | 184.41 | 185.2635 | 47069336.0 |
| 2025-11-20 12:00:00 | NVDA | Stock | 185.24 | 186.842 | 181.72 | 183.7002 | 36321986.0 |
| 2025-11-20 13:00:00 | NVDA | Stock | 183.71 | 185.89 | 181.5 | 182.2 | 25243105.0 |
| 2025-11-20 14:00:00 | NVDA | Stock | 182.18 | 183.75 | 180.94 | 183.6104 | 21899060.0 |
| 2025-11-20 15:00:00 | NVDA | Stock | 183.615 | 183.69 | 179.85 | 180.91 | 29685604.0 |
| 2025-11-20 16:00:00 | NVDA | Stock | 180.94 | 185.697 | 179.17 | 179.9157 | 17072788.0 |
| 2025-11-20 17:00:00 | NVDA | Stock | 179.87 | 180.0999 | 178.41 | 178.9703 | 1885663.0 |
| 2025-11-20 18:00:00 | NVDA | Stock | 179.0 | 180.95 | 178.63 | 180.64 | 1438006.0 |
| 2025-11-20 19:00:00 | NVDA | Stock | 180.6422 | 181.3 | 180.15 | 181.1 | 966943.0 |
| 2025-11-20 04:00:00 | AMZN | Stock | 227.36 | 227.63 | 225.71 | 225.91 | 29720.0 |
| 2025-11-20 05:00:00 | AMZN | Stock | 226.03 | 226.69 | 225.73 | 226.61 | 27134.0 |
> showing 50 of 61,728 rows — these rows as CSV