PREVIEW / stock_1hour / 2025-08-06
file: by_date/stock_1hour/2025/2025-08-06.parquet size: 1.4 MB rows: 62,629 symbols: 353
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-08-06 04:00:00 | AAPL | Stock | 203.33 | 203.91 | 203.33 | 203.81 | 17781.0 |
| 2025-08-06 05:00:00 | AAPL | Stock | 203.84 | 203.95 | 203.69 | 203.69 | 5092.0 |
| 2025-08-06 06:00:00 | AAPL | Stock | 203.75 | 203.98 | 203.61 | 203.98 | 6022.0 |
| 2025-08-06 07:00:00 | AAPL | Stock | 203.92 | 203.99 | 203.73 | 203.73 | 21883.0 |
| 2025-08-06 08:00:00 | AAPL | Stock | 203.88 | 206.91 | 203.35 | 206.46 | 847974.0 |
| 2025-08-06 09:00:00 | AAPL | Stock | 206.4701 | 210.32 | 205.5003 | 209.545 | 12151779.0 |
| 2025-08-06 10:00:00 | AAPL | Stock | 209.545 | 212.27 | 209.5 | 211.075 | 12101648.0 |
| 2025-08-06 11:00:00 | AAPL | Stock | 211.08 | 214.9 | 210.66 | 214.63 | 14287226.0 |
| 2025-08-06 12:00:00 | AAPL | Stock | 214.635 | 214.99 | 213.869 | 214.485 | 8844864.0 |
| 2025-08-06 13:00:00 | AAPL | Stock | 214.485 | 215.38 | 214.04 | 214.385 | 6729396.0 |
| 2025-08-06 14:00:00 | AAPL | Stock | 214.38 | 214.93 | 214.13 | 214.3999 | 4962990.0 |
| 2025-08-06 15:00:00 | AAPL | Stock | 214.395 | 214.55 | 212.81 | 213.25 | 10876047.0 |
| 2025-08-06 16:00:00 | AAPL | Stock | 213.264 | 213.38 | 211.32 | 211.5999 | 10660395.0 |
| 2025-08-06 17:00:00 | AAPL | Stock | 211.57 | 220.7 | 211.4501 | 220.7 | 1983286.0 |
| 2025-08-06 18:00:00 | AAPL | Stock | 220.54 | 221.0 | 217.26 | 219.2 | 1753285.0 |
| 2025-08-06 19:00:00 | AAPL | Stock | 219.2 | 220.2 | 219.1 | 219.26 | 513617.0 |
| 2025-08-06 04:00:00 | MSFT | Stock | 533.15 | 533.15 | 531.43 | 532.0 | 8290.0 |
| 2025-08-06 05:00:00 | MSFT | Stock | 532.4 | 532.4 | 531.75 | 531.8 | 1940.0 |
| 2025-08-06 06:00:00 | MSFT | Stock | 531.51 | 531.94 | 531.3 | 531.3 | 1536.0 |
| 2025-08-06 07:00:00 | MSFT | Stock | 532.09 | 532.28 | 531.32 | 531.32 | 11304.0 |
| 2025-08-06 08:00:00 | MSFT | Stock | 531.75 | 533.06 | 529.77 | 530.36 | 45402.0 |
| 2025-08-06 09:00:00 | MSFT | Stock | 530.4784 | 531.7 | 526.22 | 526.49 | 1748476.0 |
| 2025-08-06 10:00:00 | MSFT | Stock | 526.49 | 527.74 | 524.595 | 525.985 | 2203313.0 |
| 2025-08-06 11:00:00 | MSFT | Stock | 526.01 | 526.8 | 525.25 | 526.55 | 1448368.0 |
| 2025-08-06 12:00:00 | MSFT | Stock | 526.54 | 527.2 | 525.8227 | 526.17 | 887611.0 |
| 2025-08-06 13:00:00 | MSFT | Stock | 526.18 | 526.34 | 525.23 | 525.868 | 781360.0 |
| 2025-08-06 14:00:00 | MSFT | Stock | 525.835 | 526.74 | 525.32 | 525.975 | 1013817.0 |
| 2025-08-06 15:00:00 | MSFT | Stock | 525.97 | 526.14 | 524.03 | 524.84 | 2525638.0 |
| 2025-08-06 16:00:00 | MSFT | Stock | 524.84 | 526.3 | 524.74 | 526.2 | 3330532.0 |
| 2025-08-06 17:00:00 | MSFT | Stock | 526.2 | 526.39 | 524.94 | 525.35 | 19769.0 |
| 2025-08-06 18:00:00 | MSFT | Stock | 525.05 | 525.6 | 524.0 | 525.3 | 14720.0 |
| 2025-08-06 19:00:00 | MSFT | Stock | 525.6193 | 525.9814 | 525.01 | 525.13 | 9174.0 |
| 2025-08-06 04:00:00 | NVDA | Stock | 178.4 | 178.85 | 177.31 | 177.58 | 323868.0 |
| 2025-08-06 05:00:00 | NVDA | Stock | 177.6 | 177.7 | 176.71 | 177.0 | 222610.0 |
| 2025-08-06 06:00:00 | NVDA | Stock | 177.0 | 177.02 | 175.68 | 176.25 | 416064.0 |
| 2025-08-06 07:00:00 | NVDA | Stock | 176.24 | 177.19 | 175.82 | 176.86 | 527152.0 |
| 2025-08-06 08:00:00 | NVDA | Stock | 176.87 | 178.85 | 175.7 | 176.9302 | 1338780.0 |
| 2025-08-06 09:00:00 | NVDA | Stock | 176.9201 | 178.83 | 176.18 | 178.4981 | 16889176.0 |
| 2025-08-06 10:00:00 | NVDA | Stock | 178.5 | 179.43 | 176.8019 | 177.845 | 21085381.0 |
| 2025-08-06 11:00:00 | NVDA | Stock | 177.85 | 179.1373 | 177.3 | 179.025 | 14248382.0 |
| 2025-08-06 12:00:00 | NVDA | Stock | 179.025 | 179.38 | 177.6581 | 177.925 | 11323900.0 |
| 2025-08-06 13:00:00 | NVDA | Stock | 177.9251 | 178.67 | 177.925 | 178.55 | 7041688.0 |
| 2025-08-06 14:00:00 | NVDA | Stock | 178.55 | 179.47 | 178.5319 | 179.08 | 9881481.0 |
| 2025-08-06 15:00:00 | NVDA | Stock | 179.08 | 179.9 | 179.03 | 179.41 | 14249419.0 |
| 2025-08-06 16:00:00 | NVDA | Stock | 179.41 | 179.44 | 178.94 | 179.43 | 10507748.0 |
| 2025-08-06 17:00:00 | NVDA | Stock | 179.44 | 179.89 | 176.76 | 179.86 | 1838228.0 |
| 2025-08-06 18:00:00 | NVDA | Stock | 179.85 | 181.0 | 179.41 | 180.55 | 1214691.0 |
| 2025-08-06 19:00:00 | NVDA | Stock | 180.54 | 180.65 | 180.2414 | 180.48 | 388462.0 |
| 2025-08-06 04:00:00 | AMZN | Stock | 215.0 | 215.52 | 214.94 | 215.18 | 16297.0 |
| 2025-08-06 05:00:00 | AMZN | Stock | 215.27 | 215.35 | 214.99 | 215.1 | 10931.0 |
> showing 50 of 62,629 rows — these rows as CSV