PREVIEW / stock_1hour / 2025-01-21
file: by_date/stock_1hour/2025/2025-01-21.parquet size: 1.5 MB rows: 67,391 symbols: 593
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-21 04:00:00 | AAPL | Stock | 227.33 | 228.27 | 226.5 | 227.03 | 81447.0 |
| 2025-01-21 05:00:00 | AAPL | Stock | 227.14 | 227.51 | 226.8 | 226.8 | 23731.0 |
| 2025-01-21 06:00:00 | AAPL | Stock | 226.96 | 227.14 | 225.34 | 225.45 | 110986.0 |
| 2025-01-21 07:00:00 | AAPL | Stock | 225.49 | 226.1 | 224.82 | 225.87 | 264627.0 |
| 2025-01-21 08:00:00 | AAPL | Stock | 225.25 | 227.75 | 224.7 | 226.0517 | 590911.0 |
| 2025-01-21 09:00:00 | AAPL | Stock | 226.06 | 226.09 | 220.8 | 221.86 | 14477520.0 |
| 2025-01-21 10:00:00 | AAPL | Stock | 221.867 | 222.3 | 220.6 | 221.31 | 9493603.0 |
| 2025-01-21 11:00:00 | AAPL | Stock | 221.3 | 221.44 | 219.38 | 220.17 | 9799204.0 |
| 2025-01-21 12:00:00 | AAPL | Stock | 220.1757 | 221.07 | 219.82 | 220.235 | 6124824.0 |
| 2025-01-21 13:00:00 | AAPL | Stock | 220.23 | 221.28 | 220.0 | 221.21 | 4823164.0 |
| 2025-01-21 14:00:00 | AAPL | Stock | 221.21 | 221.69 | 220.38 | 221.1203 | 4823888.0 |
| 2025-01-21 15:00:00 | AAPL | Stock | 221.125 | 222.79 | 220.31 | 222.66 | 8652244.0 |
| 2025-01-21 16:00:00 | AAPL | Stock | 222.63 | 222.76 | 221.68 | 221.8988 | 13022363.0 |
| 2025-01-21 17:00:00 | AAPL | Stock | 221.8995 | 222.64 | 221.7 | 222.64 | 127099.0 |
| 2025-01-21 18:00:00 | AAPL | Stock | 221.89 | 222.64 | 221.28 | 221.921 | 144168.0 |
| 2025-01-21 19:00:00 | AAPL | Stock | 221.92 | 222.17 | 221.8 | 222.0501 | 72350.0 |
| 2025-01-21 04:00:00 | MSFT | Stock | 430.26 | 431.27 | 430.18 | 431.27 | 8971.0 |
| 2025-01-21 05:00:00 | MSFT | Stock | 431.37 | 431.65 | 431.35 | 431.35 | 2484.0 |
| 2025-01-21 06:00:00 | MSFT | Stock | 431.2 | 431.47 | 431.0 | 431.02 | 3169.0 |
| 2025-01-21 07:00:00 | MSFT | Stock | 431.2 | 431.78 | 430.88 | 431.69 | 11972.0 |
| 2025-01-21 08:00:00 | MSFT | Stock | 431.0 | 431.7 | 429.94 | 431.54 | 22966.0 |
| 2025-01-21 09:00:00 | MSFT | Stock | 431.58 | 431.71 | 425.595 | 426.48 | 1812828.0 |
| 2025-01-21 10:00:00 | MSFT | Stock | 426.48 | 428.71 | 425.76 | 427.59 | 1056366.0 |
| 2025-01-21 11:00:00 | MSFT | Stock | 427.56 | 428.942 | 427.01 | 428.91 | 841196.0 |
| 2025-01-21 12:00:00 | MSFT | Stock | 428.902 | 429.99 | 427.91 | 429.87 | 868251.0 |
| 2025-01-21 13:00:00 | MSFT | Stock | 429.86 | 430.8999 | 427.6201 | 428.04 | 1256670.0 |
| 2025-01-21 14:00:00 | MSFT | Stock | 428.03 | 429.29 | 427.42 | 428.338 | 1161127.0 |
| 2025-01-21 15:00:00 | MSFT | Stock | 428.33 | 429.13 | 427.86 | 428.62 | 1576100.0 |
| 2025-01-21 16:00:00 | MSFT | Stock | 428.5 | 428.71 | 427.77 | 428.03 | 7293521.0 |
| 2025-01-21 17:00:00 | MSFT | Stock | 427.98 | 440.27 | 427.5 | 435.11 | 197056.0 |
| 2025-01-21 18:00:00 | MSFT | Stock | 433.72 | 436.0 | 428.5 | 433.85 | 100347.0 |
| 2025-01-21 19:00:00 | MSFT | Stock | 433.82 | 434.85 | 433.2075 | 434.7 | 22367.0 |
| 2025-01-21 04:00:00 | NVDA | Stock | 138.63 | 139.27 | 138.1 | 138.89 | 350847.0 |
| 2025-01-21 05:00:00 | NVDA | Stock | 138.88 | 139.0 | 138.76 | 138.76 | 162362.0 |
| 2025-01-21 06:00:00 | NVDA | Stock | 138.76 | 138.93 | 138.76 | 138.83 | 132171.0 |
| 2025-01-21 07:00:00 | NVDA | Stock | 138.83 | 138.87 | 138.13 | 138.42 | 864665.0 |
| 2025-01-21 08:00:00 | NVDA | Stock | 138.54 | 139.244 | 138.13 | 139.0591 | 1932154.0 |
| 2025-01-21 09:00:00 | NVDA | Stock | 139.05 | 140.21 | 137.72 | 139.085 | 27481465.0 |
| 2025-01-21 10:00:00 | NVDA | Stock | 139.09 | 139.14 | 137.09 | 138.9 | 20857960.0 |
| 2025-01-21 11:00:00 | NVDA | Stock | 138.91 | 139.49 | 138.33 | 139.26 | 12358753.0 |
| 2025-01-21 12:00:00 | NVDA | Stock | 139.245 | 140.94 | 138.83 | 140.91 | 15087381.0 |
| 2025-01-21 13:00:00 | NVDA | Stock | 140.92 | 141.83 | 140.67 | 141.2502 | 19880269.0 |
| 2025-01-21 14:00:00 | NVDA | Stock | 141.255 | 141.73 | 140.7626 | 141.3047 | 13288478.0 |
| 2025-01-21 15:00:00 | NVDA | Stock | 141.305 | 141.72 | 140.58 | 140.83 | 16768886.0 |
| 2025-01-21 16:00:00 | NVDA | Stock | 140.83 | 141.37 | 140.6 | 141.3088 | 26278313.0 |
| 2025-01-21 17:00:00 | NVDA | Stock | 141.26 | 143.9 | 140.83 | 143.02 | 3067172.0 |
| 2025-01-21 18:00:00 | NVDA | Stock | 143.02 | 143.21 | 140.83 | 142.85 | 1318740.0 |
| 2025-01-21 19:00:00 | NVDA | Stock | 142.83 | 143.48 | 142.75 | 143.15 | 940542.0 |
| 2025-01-21 04:00:00 | AMZN | Stock | 226.56 | 228.22 | 226.23 | 228.09 | 30546.0 |
| 2025-01-21 05:00:00 | AMZN | Stock | 228.2 | 228.99 | 228.18 | 228.51 | 36154.0 |
> showing 50 of 67,391 rows — these rows as CSV