PREVIEW / stock_1hour / 2025-01-02
file: by_date/stock_1hour/2025/2025-01-02.parquet size: 1.5 MB rows: 64,863 symbols: 599
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-02 04:00:00 | AAPL | Stock | 251.36 | 251.9 | 250.6 | 251.3 | 22834.0 |
| 2025-01-02 05:00:00 | AAPL | Stock | 251.26 | 251.29 | 250.45 | 250.55 | 34764.0 |
| 2025-01-02 06:00:00 | AAPL | Stock | 250.6 | 250.6 | 249.87 | 250.345 | 28898.0 |
| 2025-01-02 07:00:00 | AAPL | Stock | 250.35 | 251.07 | 250.22 | 250.5 | 66947.0 |
| 2025-01-02 08:00:00 | AAPL | Stock | 250.345 | 251.65 | 248.9 | 249.1 | 197679.0 |
| 2025-01-02 09:00:00 | AAPL | Stock | 249.1 | 249.25 | 244.8 | 246.8526 | 7508873.0 |
| 2025-01-02 10:00:00 | AAPL | Stock | 246.885 | 247.81 | 244.82 | 245.415 | 5857437.0 |
| 2025-01-02 11:00:00 | AAPL | Stock | 245.4175 | 245.485 | 244.1601 | 244.64 | 3651814.0 |
| 2025-01-02 12:00:00 | AAPL | Stock | 244.68 | 245.25 | 242.31 | 242.985 | 4496502.0 |
| 2025-01-02 13:00:00 | AAPL | Stock | 242.98 | 243.03 | 241.8201 | 242.23 | 3817944.0 |
| 2025-01-02 14:00:00 | AAPL | Stock | 242.24 | 242.84 | 241.8713 | 241.96 | 3638368.0 |
| 2025-01-02 15:00:00 | AAPL | Stock | 241.97 | 243.95 | 241.97 | 243.82 | 5705388.0 |
| 2025-01-02 16:00:00 | AAPL | Stock | 243.85 | 243.95 | 243.45 | 243.64 | 6215639.0 |
| 2025-01-02 17:00:00 | AAPL | Stock | 243.6 | 243.65 | 243.5 | 243.5504 | 12310.0 |
| 2025-01-02 18:00:00 | AAPL | Stock | 243.55 | 243.85 | 243.1159 | 243.24 | 33807.0 |
| 2025-01-02 19:00:00 | AAPL | Stock | 243.24 | 244.15 | 243.21 | 243.99 | 120130.0 |
| 2025-01-02 04:00:00 | MSFT | Stock | 424.5 | 425.47 | 423.91 | 425.21 | 6897.0 |
| 2025-01-02 05:00:00 | MSFT | Stock | 425.0 | 425.5 | 424.87 | 425.5 | 3612.0 |
| 2025-01-02 06:00:00 | MSFT | Stock | 425.32 | 428.3 | 425.26 | 428.13 | 11694.0 |
| 2025-01-02 07:00:00 | MSFT | Stock | 427.83 | 428.0 | 426.66 | 427.3 | 19790.0 |
| 2025-01-02 08:00:00 | MSFT | Stock | 427.24 | 428.0 | 423.76 | 425.8 | 48080.0 |
| 2025-01-02 09:00:00 | MSFT | Stock | 425.7 | 427.28 | 422.7 | 425.4 | 1334995.0 |
| 2025-01-02 10:00:00 | MSFT | Stock | 425.5 | 425.93 | 420.5 | 421.73 | 1379842.0 |
| 2025-01-02 11:00:00 | MSFT | Stock | 421.9 | 422.36 | 420.3 | 421.61 | 811785.0 |
| 2025-01-02 12:00:00 | MSFT | Stock | 421.6203 | 421.96 | 414.85 | 416.12 | 1337223.0 |
| 2025-01-02 13:00:00 | MSFT | Stock | 416.0 | 416.82 | 414.9 | 415.67 | 971758.0 |
| 2025-01-02 14:00:00 | MSFT | Stock | 415.74 | 417.9496 | 415.34 | 416.37 | 814451.0 |
| 2025-01-02 15:00:00 | MSFT | Stock | 416.43 | 418.95 | 416.43 | 418.69 | 1453039.0 |
| 2025-01-02 16:00:00 | MSFT | Stock | 418.58 | 419.24 | 418.55 | 418.94 | 2422244.0 |
| 2025-01-02 17:00:00 | MSFT | Stock | 418.86 | 418.86 | 418.61 | 418.67 | 1637.0 |
| 2025-01-02 18:00:00 | MSFT | Stock | 418.63 | 418.63 | 418.2 | 418.25 | 9621.0 |
| 2025-01-02 19:00:00 | MSFT | Stock | 418.42 | 420.0 | 418.42 | 419.81 | 12780.0 |
| 2025-01-02 04:00:00 | NVDA | Stock | 132.95 | 135.97 | 132.95 | 135.96 | 554268.0 |
| 2025-01-02 05:00:00 | NVDA | Stock | 135.96 | 136.11 | 135.6 | 136.0 | 117040.0 |
| 2025-01-02 06:00:00 | NVDA | Stock | 135.98 | 136.83 | 135.69 | 136.66 | 292363.0 |
| 2025-01-02 07:00:00 | NVDA | Stock | 136.65 | 136.71 | 136.21 | 136.54 | 591361.0 |
| 2025-01-02 08:00:00 | NVDA | Stock | 136.51 | 136.7086 | 134.78 | 136.21 | 1962041.0 |
| 2025-01-02 09:00:00 | NVDA | Stock | 136.2 | 137.88 | 134.63 | 137.27 | 27471271.0 |
| 2025-01-02 10:00:00 | NVDA | Stock | 137.285 | 138.37 | 136.41 | 137.375 | 27601672.0 |
| 2025-01-02 11:00:00 | NVDA | Stock | 137.38 | 138.8 | 136.64 | 138.67 | 19055559.0 |
| 2025-01-02 12:00:00 | NVDA | Stock | 138.67 | 138.88 | 135.16 | 136.19 | 22084538.0 |
| 2025-01-02 13:00:00 | NVDA | Stock | 136.21 | 136.42 | 135.2601 | 136.11 | 13686663.0 |
| 2025-01-02 14:00:00 | NVDA | Stock | 136.09 | 137.72 | 135.93 | 136.915 | 14225397.0 |
| 2025-01-02 15:00:00 | NVDA | Stock | 136.915 | 138.626 | 136.88 | 138.28 | 19912888.0 |
| 2025-01-02 16:00:00 | NVDA | Stock | 138.28 | 138.74 | 138.02 | 138.3 | 14560270.0 |
| 2025-01-02 17:00:00 | NVDA | Stock | 138.4 | 138.4 | 138.1 | 138.33 | 296907.0 |
| 2025-01-02 18:00:00 | NVDA | Stock | 138.33 | 138.4 | 137.8 | 137.9017 | 351730.0 |
| 2025-01-02 19:00:00 | NVDA | Stock | 137.9199 | 138.5336 | 137.8801 | 138.44 | 427251.0 |
| 2025-01-02 04:00:00 | AMZN | Stock | 220.44 | 221.56 | 220.25 | 221.45 | 21119.0 |
| 2025-01-02 05:00:00 | AMZN | Stock | 221.61 | 221.74 | 221.21 | 221.6 | 8477.0 |
> showing 50 of 64,863 rows — these rows as CSV