PREVIEW / stock_1hour / 2025-07-31
file: by_date/stock_1hour/2025/2025-07-31.parquet size: 1.5 MB rows: 64,249 symbols: 358
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-07-31 04:00:00 | AAPL | Stock | 209.49 | 209.8 | 208.85 | 209.21 | 59631.0 |
| 2025-07-31 05:00:00 | AAPL | Stock | 209.25 | 209.3 | 208.9 | 209.07 | 20671.0 |
| 2025-07-31 06:00:00 | AAPL | Stock | 209.1 | 209.59 | 209.08 | 209.38 | 30454.0 |
| 2025-07-31 07:00:00 | AAPL | Stock | 209.25 | 209.39 | 208.9 | 209.1 | 57168.0 |
| 2025-07-31 08:00:00 | AAPL | Stock | 209.07 | 209.61 | 208.82 | 209.5 | 330678.0 |
| 2025-07-31 09:00:00 | AAPL | Stock | 209.51 | 209.89 | 207.82 | 208.47 | 5531345.0 |
| 2025-07-31 10:00:00 | AAPL | Stock | 208.44 | 209.6815 | 208.37 | 208.99 | 5753879.0 |
| 2025-07-31 11:00:00 | AAPL | Stock | 208.98 | 209.24 | 208.07 | 208.615 | 4114025.0 |
| 2025-07-31 12:00:00 | AAPL | Stock | 208.61 | 209.3799 | 208.61 | 209.0672 | 2988493.0 |
| 2025-07-31 13:00:00 | AAPL | Stock | 209.0682 | 209.84 | 208.14 | 208.31 | 3905198.0 |
| 2025-07-31 14:00:00 | AAPL | Stock | 208.3 | 209.25 | 207.58 | 208.94 | 4181241.0 |
| 2025-07-31 15:00:00 | AAPL | Stock | 208.96 | 209.3843 | 207.16 | 207.61 | 9159619.0 |
| 2025-07-31 16:00:00 | AAPL | Stock | 207.61 | 214.95 | 207.57 | 210.4 | 18866812.0 |
| 2025-07-31 17:00:00 | AAPL | Stock | 210.32 | 217.0 | 208.5 | 212.65 | 4262444.0 |
| 2025-07-31 18:00:00 | AAPL | Stock | 212.6 | 214.2353 | 211.55 | 212.25 | 797321.0 |
| 2025-07-31 19:00:00 | AAPL | Stock | 212.25 | 212.9 | 211.01 | 212.59 | 402242.0 |
| 2025-07-31 04:00:00 | MSFT | Stock | 557.44 | 560.0 | 556.12 | 556.4 | 52945.0 |
| 2025-07-31 05:00:00 | MSFT | Stock | 556.5 | 557.2 | 555.49 | 555.52 | 55722.0 |
| 2025-07-31 06:00:00 | MSFT | Stock | 555.52 | 558.85 | 555.52 | 556.91 | 57712.0 |
| 2025-07-31 07:00:00 | MSFT | Stock | 556.65 | 558.7 | 554.37 | 554.5 | 120363.0 |
| 2025-07-31 08:00:00 | MSFT | Stock | 557.37 | 562.0 | 554.26 | 557.7 | 420641.0 |
| 2025-07-31 09:00:00 | MSFT | Stock | 557.9999 | 561.4 | 536.09 | 536.155 | 9843611.0 |
| 2025-07-31 10:00:00 | MSFT | Stock | 536.275 | 540.14 | 534.35 | 535.095 | 6155328.0 |
| 2025-07-31 11:00:00 | MSFT | Stock | 535.05 | 537.71 | 535.04 | 536.73 | 2694005.0 |
| 2025-07-31 12:00:00 | MSFT | Stock | 536.66 | 537.23 | 535.14 | 536.455 | 1822484.0 |
| 2025-07-31 13:00:00 | MSFT | Stock | 536.455 | 536.78 | 532.85 | 533.42 | 1787043.0 |
| 2025-07-31 14:00:00 | MSFT | Stock | 533.375 | 534.9 | 532.5401 | 533.56 | 1777809.0 |
| 2025-07-31 15:00:00 | MSFT | Stock | 533.6 | 535.22 | 531.9 | 533.565 | 4384580.0 |
| 2025-07-31 16:00:00 | MSFT | Stock | 533.5 | 537.5 | 533.5 | 536.2 | 5778777.0 |
| 2025-07-31 17:00:00 | MSFT | Stock | 536.05 | 539.5 | 535.7824 | 539.49 | 61501.0 |
| 2025-07-31 18:00:00 | MSFT | Stock | 539.4995 | 540.32 | 537.5 | 538.94 | 78445.0 |
| 2025-07-31 19:00:00 | MSFT | Stock | 538.8 | 539.0 | 537.5 | 537.54 | 18924.0 |
| 2025-07-31 04:00:00 | NVDA | Stock | 182.86 | 183.88 | 182.3 | 182.72 | 533956.0 |
| 2025-07-31 05:00:00 | NVDA | Stock | 182.75 | 182.79 | 181.8 | 182.01 | 291454.0 |
| 2025-07-31 06:00:00 | NVDA | Stock | 182.01 | 182.88 | 181.8 | 182.53 | 403380.0 |
| 2025-07-31 07:00:00 | NVDA | Stock | 182.55 | 183.75 | 182.34 | 183.09 | 896126.0 |
| 2025-07-31 08:00:00 | NVDA | Stock | 182.62 | 185.22 | 181.85 | 183.32 | 2941385.0 |
| 2025-07-31 09:00:00 | NVDA | Stock | 183.3 | 183.33 | 180.4 | 181.9 | 31622289.0 |
| 2025-07-31 10:00:00 | NVDA | Stock | 181.91 | 182.25 | 179.45 | 179.805 | 27270385.0 |
| 2025-07-31 11:00:00 | NVDA | Stock | 179.8 | 180.63 | 178.68 | 180.595 | 20759359.0 |
| 2025-07-31 12:00:00 | NVDA | Stock | 180.59 | 181.495 | 180.49 | 180.655 | 12976051.0 |
| 2025-07-31 13:00:00 | NVDA | Stock | 180.66 | 180.81 | 177.26 | 177.595 | 20619038.0 |
| 2025-07-31 14:00:00 | NVDA | Stock | 177.59 | 178.18 | 175.93 | 177.645 | 20017248.0 |
| 2025-07-31 15:00:00 | NVDA | Stock | 177.645 | 178.17 | 177.0 | 177.85 | 21258477.0 |
| 2025-07-31 16:00:00 | NVDA | Stock | 177.87 | 178.59 | 176.91 | 177.7 | 21765079.0 |
| 2025-07-31 17:00:00 | NVDA | Stock | 177.69 | 177.79 | 175.63 | 176.02 | 810588.0 |
| 2025-07-31 18:00:00 | NVDA | Stock | 176.08 | 176.8938 | 175.9 | 175.955 | 496059.0 |
| 2025-07-31 19:00:00 | NVDA | Stock | 175.97 | 176.8 | 175.77 | 176.6899 | 532018.0 |
| 2025-07-31 04:00:00 | AMZN | Stock | 238.15 | 238.55 | 237.51 | 237.73 | 86545.0 |
| 2025-07-31 05:00:00 | AMZN | Stock | 237.8 | 237.97 | 237.26 | 237.92 | 43736.0 |
> showing 50 of 64,249 rows — these rows as CSV