PREVIEW / stock_1hour / 2025-01-17
file: by_date/stock_1hour/2025/2025-01-17.parquet size: 1.4 MB rows: 63,659 symbols: 572
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-17 04:00:00 | AAPL | Stock | 229.02 | 229.79 | 229.01 | 229.75 | 37018.0 |
| 2025-01-17 05:00:00 | AAPL | Stock | 229.81 | 229.81 | 229.01 | 229.36 | 22602.0 |
| 2025-01-17 06:00:00 | AAPL | Stock | 229.36 | 230.45 | 229.06 | 229.87 | 98638.0 |
| 2025-01-17 07:00:00 | AAPL | Stock | 229.87 | 230.28 | 229.4 | 230.06 | 96213.0 |
| 2025-01-17 08:00:00 | AAPL | Stock | 230.0 | 231.32 | 228.76 | 231.1707 | 463275.0 |
| 2025-01-17 09:00:00 | AAPL | Stock | 231.21 | 232.3 | 229.72 | 230.79 | 16745196.0 |
| 2025-01-17 10:00:00 | AAPL | Stock | 230.77 | 231.65 | 230.0 | 231.33 | 5437072.0 |
| 2025-01-17 11:00:00 | AAPL | Stock | 231.3376 | 231.51 | 229.55 | 229.6611 | 4243559.0 |
| 2025-01-17 12:00:00 | AAPL | Stock | 229.66 | 230.44 | 229.49 | 230.16 | 3171462.0 |
| 2025-01-17 13:00:00 | AAPL | Stock | 230.15 | 230.35 | 229.12 | 229.28 | 2767509.0 |
| 2025-01-17 14:00:00 | AAPL | Stock | 229.285 | 229.6088 | 228.48 | 229.2057 | 3234103.0 |
| 2025-01-17 15:00:00 | AAPL | Stock | 229.2 | 230.07 | 229.08 | 229.96 | 6014801.0 |
| 2025-01-17 16:00:00 | AAPL | Stock | 229.99 | 230.12 | 229.6037 | 229.9235 | 7898299.0 |
| 2025-01-17 17:00:00 | AAPL | Stock | 229.93 | 230.0485 | 229.9 | 229.96 | 30943.0 |
| 2025-01-17 18:00:00 | AAPL | Stock | 229.9012 | 229.95 | 229.71 | 229.8226 | 15348.0 |
| 2025-01-17 19:00:00 | AAPL | Stock | 229.8 | 230.0 | 229.2742 | 229.499 | 205612.0 |
| 2025-01-17 04:00:00 | MSFT | Stock | 425.15 | 426.4 | 425.15 | 426.4 | 8546.0 |
| 2025-01-17 05:00:00 | MSFT | Stock | 426.6 | 426.6 | 425.56 | 425.93 | 3157.0 |
| 2025-01-17 06:00:00 | MSFT | Stock | 426.14 | 426.42 | 425.2 | 425.92 | 2354.0 |
| 2025-01-17 07:00:00 | MSFT | Stock | 425.51 | 426.0 | 425.51 | 426.0 | 3451.0 |
| 2025-01-17 08:00:00 | MSFT | Stock | 425.3 | 428.989 | 425.1427 | 428.62 | 43698.0 |
| 2025-01-17 09:00:00 | MSFT | Stock | 428.8 | 434.87 | 428.17 | 428.875 | 6429282.0 |
| 2025-01-17 10:00:00 | MSFT | Stock | 428.875 | 430.3626 | 428.33 | 429.03 | 1264228.0 |
| 2025-01-17 11:00:00 | MSFT | Stock | 429.03 | 430.13 | 428.54 | 429.29 | 923398.0 |
| 2025-01-17 12:00:00 | MSFT | Stock | 429.29 | 432.0 | 428.9001 | 431.6982 | 763977.0 |
| 2025-01-17 13:00:00 | MSFT | Stock | 431.63 | 432.205 | 430.9 | 431.16 | 560823.0 |
| 2025-01-17 14:00:00 | MSFT | Stock | 431.18 | 431.35 | 428.81 | 429.9201 | 874468.0 |
| 2025-01-17 15:00:00 | MSFT | Stock | 429.995 | 431.19 | 428.39 | 428.91 | 2255318.0 |
| 2025-01-17 16:00:00 | MSFT | Stock | 429.03 | 430.19 | 428.62 | 429.34 | 3754595.0 |
| 2025-01-17 17:00:00 | MSFT | Stock | 429.75 | 429.75 | 429.6012 | 429.7 | 4138.0 |
| 2025-01-17 18:00:00 | MSFT | Stock | 429.75 | 429.85 | 429.75 | 429.8 | 5274.0 |
| 2025-01-17 19:00:00 | MSFT | Stock | 429.03 | 429.988 | 429.03 | 429.5 | 33006.0 |
| 2025-01-17 04:00:00 | NVDA | Stock | 134.86 | 135.74 | 134.29 | 135.26 | 313759.0 |
| 2025-01-17 05:00:00 | NVDA | Stock | 135.25 | 135.34 | 134.87 | 135.06 | 130431.0 |
| 2025-01-17 06:00:00 | NVDA | Stock | 135.09 | 135.42 | 134.81 | 134.91 | 158070.0 |
| 2025-01-17 07:00:00 | NVDA | Stock | 134.91 | 135.0 | 134.54 | 134.82 | 396298.0 |
| 2025-01-17 08:00:00 | NVDA | Stock | 134.65 | 135.6 | 134.15 | 135.53 | 1856874.0 |
| 2025-01-17 09:00:00 | NVDA | Stock | 135.54 | 137.1966 | 135.4649 | 136.67 | 38369055.0 |
| 2025-01-17 10:00:00 | NVDA | Stock | 136.68 | 138.09 | 136.23 | 138.075 | 29326208.0 |
| 2025-01-17 11:00:00 | NVDA | Stock | 138.07 | 138.24 | 137.36 | 137.99 | 14779903.0 |
| 2025-01-17 12:00:00 | NVDA | Stock | 137.98 | 138.09 | 137.63 | 137.76 | 9735386.0 |
| 2025-01-17 13:00:00 | NVDA | Stock | 137.755 | 138.5 | 137.58 | 137.805 | 12088926.0 |
| 2025-01-17 14:00:00 | NVDA | Stock | 137.8057 | 138.165 | 137.47 | 137.856 | 9832680.0 |
| 2025-01-17 15:00:00 | NVDA | Stock | 137.855 | 138.2 | 137.31 | 137.75 | 18366487.0 |
| 2025-01-17 16:00:00 | NVDA | Stock | 137.74 | 138.02 | 137.6 | 137.9794 | 23239052.0 |
| 2025-01-17 17:00:00 | NVDA | Stock | 137.97 | 138.03 | 137.69 | 137.6999 | 372969.0 |
| 2025-01-17 18:00:00 | NVDA | Stock | 137.69 | 137.9399 | 137.6107 | 137.68 | 278543.0 |
| 2025-01-17 19:00:00 | NVDA | Stock | 137.67 | 137.7 | 137.5 | 137.631 | 345783.0 |
| 2025-01-17 04:00:00 | AMZN | Stock | 221.4 | 222.24 | 221.4 | 221.99 | 9038.0 |
| 2025-01-17 05:00:00 | AMZN | Stock | 221.99 | 221.99 | 221.73 | 221.94 | 8315.0 |
> showing 50 of 63,659 rows — these rows as CSV