PREVIEW / stock_1hour / 2025-01-28
file: by_date/stock_1hour/2025/2025-01-28.parquet size: 1.4 MB rows: 63,369 symbols: 569
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-01-28 04:00:00 | AAPL | Stock | 230.23 | 230.74 | 228.52 | 229.27 | 44075.0 |
| 2025-01-28 05:00:00 | AAPL | Stock | 229.31 | 231.78 | 229.0 | 231.67 | 130890.0 |
| 2025-01-28 06:00:00 | AAPL | Stock | 231.69 | 231.84 | 230.54 | 230.93 | 46027.0 |
| 2025-01-28 07:00:00 | AAPL | Stock | 231.05 | 231.05 | 229.53 | 230.66 | 106501.0 |
| 2025-01-28 08:00:00 | AAPL | Stock | 230.25 | 231.0 | 229.0768 | 230.3 | 223693.0 |
| 2025-01-28 09:00:00 | AAPL | Stock | 230.32 | 235.59 | 230.12 | 234.69 | 10072651.0 |
| 2025-01-28 10:00:00 | AAPL | Stock | 234.67 | 239.25 | 234.38 | 238.84 | 11401094.0 |
| 2025-01-28 11:00:00 | AAPL | Stock | 238.84 | 240.19 | 238.17 | 239.72 | 7814337.0 |
| 2025-01-28 12:00:00 | AAPL | Stock | 239.705 | 240.17 | 238.16 | 238.73 | 4199706.0 |
| 2025-01-28 13:00:00 | AAPL | Stock | 238.71 | 239.25 | 238.47 | 238.81 | 2420263.0 |
| 2025-01-28 14:00:00 | AAPL | Stock | 238.81 | 239.48 | 238.59 | 239.165 | 2782626.0 |
| 2025-01-28 15:00:00 | AAPL | Stock | 239.155 | 239.25 | 237.76 | 238.24 | 5941554.0 |
| 2025-01-28 16:00:00 | AAPL | Stock | 238.24 | 238.97 | 238.11 | 238.15 | 11480943.0 |
| 2025-01-28 17:00:00 | AAPL | Stock | 238.16 | 238.16 | 237.25 | 237.5 | 115039.0 |
| 2025-01-28 18:00:00 | AAPL | Stock | 237.41 | 237.77 | 237.366 | 237.6 | 13846.0 |
| 2025-01-28 19:00:00 | AAPL | Stock | 237.69 | 238.35 | 237.63 | 238.35 | 43759.0 |
| 2025-01-28 04:00:00 | MSFT | Stock | 437.31 | 437.87 | 436.43 | 437.87 | 15287.0 |
| 2025-01-28 05:00:00 | MSFT | Stock | 437.85 | 438.2 | 437.5 | 437.5 | 9546.0 |
| 2025-01-28 06:00:00 | MSFT | Stock | 437.38 | 437.56 | 435.2 | 436.0 | 9364.0 |
| 2025-01-28 07:00:00 | MSFT | Stock | 436.0 | 437.0 | 434.47 | 435.3 | 16062.0 |
| 2025-01-28 08:00:00 | MSFT | Stock | 436.26 | 441.5 | 433.87 | 435.8001 | 64886.0 |
| 2025-01-28 09:00:00 | MSFT | Stock | 435.8 | 436.3381 | 431.38 | 435.27 | 1988640.0 |
| 2025-01-28 10:00:00 | MSFT | Stock | 435.165 | 443.01 | 434.53 | 441.56 | 2273357.0 |
| 2025-01-28 11:00:00 | MSFT | Stock | 441.545 | 443.39 | 440.41 | 443.05 | 1165470.0 |
| 2025-01-28 12:00:00 | MSFT | Stock | 443.2 | 445.3 | 442.48 | 445.0458 | 1062932.0 |
| 2025-01-28 13:00:00 | MSFT | Stock | 445.01 | 446.63 | 444.93 | 445.4607 | 1294862.0 |
| 2025-01-28 14:00:00 | MSFT | Stock | 445.48 | 448.12 | 445.0701 | 447.925 | 1169655.0 |
| 2025-01-28 15:00:00 | MSFT | Stock | 447.92 | 448.38 | 445.68 | 447.02 | 2718699.0 |
| 2025-01-28 16:00:00 | MSFT | Stock | 447.02 | 448.0 | 446.0 | 446.8 | 3661866.0 |
| 2025-01-28 17:00:00 | MSFT | Stock | 446.77 | 447.2 | 446.093 | 446.5868 | 134597.0 |
| 2025-01-28 18:00:00 | MSFT | Stock | 446.07 | 446.87 | 446.002 | 446.61 | 5299.0 |
| 2025-01-28 19:00:00 | MSFT | Stock | 446.7 | 446.9 | 446.6 | 446.6 | 4062.0 |
| 2025-01-28 04:00:00 | NVDA | Stock | 124.29 | 124.65 | 122.82 | 124.63 | 2559094.0 |
| 2025-01-28 05:00:00 | NVDA | Stock | 124.64 | 125.1 | 124.16 | 124.4 | 1930448.0 |
| 2025-01-28 06:00:00 | NVDA | Stock | 124.4 | 125.03 | 123.06 | 123.19 | 1890458.0 |
| 2025-01-28 07:00:00 | NVDA | Stock | 123.18 | 123.5 | 120.62 | 121.31 | 5254876.0 |
| 2025-01-28 08:00:00 | NVDA | Stock | 121.86 | 124.9796 | 120.63 | 121.91 | 8979418.0 |
| 2025-01-28 09:00:00 | NVDA | Stock | 121.91 | 123.05 | 116.25 | 119.73 | 87789021.0 |
| 2025-01-28 10:00:00 | NVDA | Stock | 119.725 | 121.91 | 118.79 | 120.695 | 75003388.0 |
| 2025-01-28 11:00:00 | NVDA | Stock | 120.7 | 123.49 | 120.32 | 123.445 | 55535992.0 |
| 2025-01-28 12:00:00 | NVDA | Stock | 123.4438 | 126.64 | 123.2 | 125.7901 | 78669195.0 |
| 2025-01-28 13:00:00 | NVDA | Stock | 125.8 | 126.92 | 125.4524 | 126.65 | 43730511.0 |
| 2025-01-28 14:00:00 | NVDA | Stock | 126.66 | 127.87 | 126.13 | 127.46 | 38706293.0 |
| 2025-01-28 15:00:00 | NVDA | Stock | 127.4601 | 129.0 | 126.64 | 128.9801 | 63916696.0 |
| 2025-01-28 16:00:00 | NVDA | Stock | 128.99 | 129.06 | 127.61 | 127.6602 | 35725778.0 |
| 2025-01-28 17:00:00 | NVDA | Stock | 127.67 | 127.95 | 127.22 | 127.57 | 1652877.0 |
| 2025-01-28 18:00:00 | NVDA | Stock | 127.59 | 128.18 | 127.57 | 127.67 | 786953.0 |
| 2025-01-28 19:00:00 | NVDA | Stock | 127.63 | 127.76 | 127.4 | 127.64 | 919091.0 |
| 2025-01-28 04:00:00 | AMZN | Stock | 235.13 | 235.26 | 234.42 | 234.78 | 19710.0 |
| 2025-01-28 05:00:00 | AMZN | Stock | 235.0 | 235.33 | 234.32 | 234.5 | 13763.0 |
> showing 50 of 63,369 rows — these rows as CSV