PREVIEW / stock_1hour / 2024-11-25
file: by_date/stock_1hour/2024/2024-11-25.parquet size: 1.5 MB rows: 64,635 symbols: 705
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 |
|---|---|---|---|---|---|---|---|
| 2024-11-25 04:00:00 | AAPL | Stock | 229.88 | 230.44 | 229.88 | 230.12 | 15661.0 |
| 2024-11-25 05:00:00 | AAPL | Stock | 230.25 | 230.75 | 230.15 | 230.7 | 10139.0 |
| 2024-11-25 06:00:00 | AAPL | Stock | 230.6 | 230.68 | 230.43 | 230.5 | 5666.0 |
| 2024-11-25 07:00:00 | AAPL | Stock | 230.5 | 231.37 | 230.12 | 231.33 | 50610.0 |
| 2024-11-25 08:00:00 | AAPL | Stock | 230.46 | 231.6845 | 229.296 | 231.51 | 107913.0 |
| 2024-11-25 09:00:00 | AAPL | Stock | 231.55 | 233.245 | 231.03 | 232.6 | 4990312.0 |
| 2024-11-25 10:00:00 | AAPL | Stock | 232.56 | 232.801 | 231.6199 | 231.895 | 3399846.0 |
| 2024-11-25 11:00:00 | AAPL | Stock | 231.89 | 232.32 | 230.89 | 230.9 | 2551320.0 |
| 2024-11-25 12:00:00 | AAPL | Stock | 230.89 | 231.03 | 229.74 | 230.11 | 2593118.0 |
| 2024-11-25 13:00:00 | AAPL | Stock | 230.105 | 230.61 | 230.07 | 230.285 | 1473007.0 |
| 2024-11-25 14:00:00 | AAPL | Stock | 230.28 | 230.85 | 230.24 | 230.68 | 1594853.0 |
| 2024-11-25 15:00:00 | AAPL | Stock | 230.68 | 233.17 | 229.845 | 232.88 | 10477156.0 |
| 2024-11-25 16:00:00 | AAPL | Stock | 232.88 | 232.89 | 232.1 | 232.2 | 40175114.0 |
| 2024-11-25 17:00:00 | AAPL | Stock | 232.2 | 232.4386 | 232.0251 | 232.25 | 49299.0 |
| 2024-11-25 18:00:00 | AAPL | Stock | 232.21 | 232.67 | 230.61 | 231.3 | 71361.0 |
| 2024-11-25 19:00:00 | AAPL | Stock | 231.3 | 231.7417 | 231.01 | 231.06 | 72152.0 |
| 2024-11-25 04:00:00 | MSFT | Stock | 418.51 | 418.51 | 417.69 | 417.69 | 3144.0 |
| 2024-11-25 05:00:00 | MSFT | Stock | 417.8 | 418.15 | 417.67 | 417.97 | 2705.0 |
| 2024-11-25 06:00:00 | MSFT | Stock | 417.77 | 418.08 | 417.5 | 417.65 | 2702.0 |
| 2024-11-25 07:00:00 | MSFT | Stock | 417.73 | 419.0 | 417.73 | 418.72 | 19811.0 |
| 2024-11-25 08:00:00 | MSFT | Stock | 417.84 | 419.02 | 415.958 | 418.65 | 44383.0 |
| 2024-11-25 09:00:00 | MSFT | Stock | 418.61 | 421.08 | 416.21 | 416.52 | 2096634.0 |
| 2024-11-25 10:00:00 | MSFT | Stock | 416.42 | 416.75 | 414.89 | 415.695 | 1275395.0 |
| 2024-11-25 11:00:00 | MSFT | Stock | 415.785 | 417.31 | 415.33 | 415.84 | 861933.0 |
| 2024-11-25 12:00:00 | MSFT | Stock | 415.81 | 416.1799 | 414.85 | 416.0 | 550477.0 |
| 2024-11-25 13:00:00 | MSFT | Stock | 416.02 | 417.17 | 415.95 | 416.46 | 581932.0 |
| 2024-11-25 14:00:00 | MSFT | Stock | 416.46 | 416.88 | 415.95 | 416.74 | 473449.0 |
| 2024-11-25 15:00:00 | MSFT | Stock | 416.7 | 419.35 | 416.38 | 418.78 | 1511251.0 |
| 2024-11-25 16:00:00 | MSFT | Stock | 418.79 | 419.88 | 418.39 | 418.55 | 8455399.0 |
| 2024-11-25 17:00:00 | MSFT | Stock | 418.44 | 418.56 | 418.1 | 418.56 | 10475.0 |
| 2024-11-25 18:00:00 | MSFT | Stock | 418.7304 | 419.5 | 416.0 | 416.35 | 12945.0 |
| 2024-11-25 19:00:00 | MSFT | Stock | 416.88 | 417.0 | 415.7547 | 417.0 | 11369.0 |
| 2024-11-25 04:00:00 | NVDA | Stock | 143.4 | 143.5 | 140.04 | 142.39 | 752686.0 |
| 2024-11-25 05:00:00 | NVDA | Stock | 142.4 | 142.4 | 141.67 | 142.23 | 364110.0 |
| 2024-11-25 06:00:00 | NVDA | Stock | 142.2 | 142.25 | 141.88 | 142.07 | 213082.0 |
| 2024-11-25 07:00:00 | NVDA | Stock | 142.06 | 142.25 | 141.07 | 141.08 | 1120377.0 |
| 2024-11-25 08:00:00 | NVDA | Stock | 141.09 | 143.4 | 141.01 | 141.98 | 3273656.0 |
| 2024-11-25 09:00:00 | NVDA | Stock | 141.98 | 142.17 | 136.63 | 137.71 | 50765536.0 |
| 2024-11-25 10:00:00 | NVDA | Stock | 137.7299 | 138.33 | 136.22 | 137.4021 | 42937307.0 |
| 2024-11-25 11:00:00 | NVDA | Stock | 137.39 | 138.66 | 136.97 | 137.54 | 23060190.0 |
| 2024-11-25 12:00:00 | NVDA | Stock | 137.555 | 137.62 | 136.45 | 137.4855 | 20847510.0 |
| 2024-11-25 13:00:00 | NVDA | Stock | 137.48 | 137.89 | 136.375 | 136.5801 | 17727270.0 |
| 2024-11-25 14:00:00 | NVDA | Stock | 136.58 | 137.415 | 136.3 | 136.7999 | 16170408.0 |
| 2024-11-25 15:00:00 | NVDA | Stock | 136.8 | 137.1483 | 135.82 | 135.94 | 31699639.0 |
| 2024-11-25 16:00:00 | NVDA | Stock | 135.93 | 137.0 | 135.38 | 136.26 | 53379631.0 |
| 2024-11-25 17:00:00 | NVDA | Stock | 136.26 | 136.43 | 136.13 | 136.43 | 462733.0 |
| 2024-11-25 18:00:00 | NVDA | Stock | 136.42 | 136.74 | 136.05 | 136.1 | 637209.0 |
| 2024-11-25 19:00:00 | NVDA | Stock | 136.07 | 136.1 | 135.0 | 135.0 | 1679005.0 |
| 2024-11-25 04:00:00 | AMZN | Stock | 197.76 | 198.73 | 197.76 | 198.73 | 14136.0 |
| 2024-11-25 05:00:00 | AMZN | Stock | 198.51 | 198.99 | 198.47 | 198.76 | 16872.0 |
> showing 50 of 64,635 rows — these rows as CSV