PREVIEW / stock_1hour / 2025-08-04
file: by_date/stock_1hour/2025/2025-08-04.parquet size: 1.4 MB rows: 63,449 symbols: 354
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-04 04:00:00 | AAPL | Stock | 203.02 | 204.12 | 203.02 | 204.12 | 53875.0 |
| 2025-08-04 05:00:00 | AAPL | Stock | 204.12 | 204.36 | 203.9 | 203.95 | 19660.0 |
| 2025-08-04 06:00:00 | AAPL | Stock | 203.88 | 204.13 | 203.82 | 203.88 | 29983.0 |
| 2025-08-04 07:00:00 | AAPL | Stock | 203.83 | 203.98 | 203.4 | 203.89 | 39888.0 |
| 2025-08-04 08:00:00 | AAPL | Stock | 203.7 | 204.43 | 202.92 | 203.8244 | 209079.0 |
| 2025-08-04 09:00:00 | AAPL | Stock | 203.92 | 206.31 | 203.57 | 206.17 | 6780517.0 |
| 2025-08-04 10:00:00 | AAPL | Stock | 206.195 | 207.88 | 205.93 | 207.195 | 7633466.0 |
| 2025-08-04 11:00:00 | AAPL | Stock | 207.195 | 207.4145 | 205.265 | 205.29 | 4282299.0 |
| 2025-08-04 12:00:00 | AAPL | Stock | 205.3 | 205.5099 | 203.865 | 204.13 | 4938662.0 |
| 2025-08-04 13:00:00 | AAPL | Stock | 204.1434 | 204.48 | 203.57 | 203.7114 | 3337409.0 |
| 2025-08-04 14:00:00 | AAPL | Stock | 203.72 | 204.22 | 202.07 | 202.59 | 4998193.0 |
| 2025-08-04 15:00:00 | AAPL | Stock | 202.59 | 203.45 | 201.675 | 203.34 | 9860509.0 |
| 2025-08-04 16:00:00 | AAPL | Stock | 203.35 | 204.0842 | 202.88 | 203.49 | 6083858.0 |
| 2025-08-04 17:00:00 | AAPL | Stock | 203.43 | 203.49 | 203.35 | 203.36 | 50025.0 |
| 2025-08-04 18:00:00 | AAPL | Stock | 203.42 | 203.45 | 203.2601 | 203.35 | 23882.0 |
| 2025-08-04 19:00:00 | AAPL | Stock | 203.36 | 203.45 | 203.14 | 203.25 | 46686.0 |
| 2025-08-04 04:00:00 | MSFT | Stock | 528.52 | 528.61 | 527.99 | 528.4 | 16084.0 |
| 2025-08-04 05:00:00 | MSFT | Stock | 528.39 | 528.5 | 528.1 | 528.1 | 8190.0 |
| 2025-08-04 06:00:00 | MSFT | Stock | 528.15 | 528.31 | 527.67 | 528.0 | 8345.0 |
| 2025-08-04 07:00:00 | MSFT | Stock | 528.04 | 528.05 | 527.5 | 527.87 | 15206.0 |
| 2025-08-04 08:00:00 | MSFT | Stock | 528.0 | 529.5 | 522.8 | 528.0999 | 32397.0 |
| 2025-08-04 09:00:00 | MSFT | Stock | 528.1 | 536.4 | 526.54 | 536.2525 | 2660630.0 |
| 2025-08-04 10:00:00 | MSFT | Stock | 536.2 | 536.9 | 533.97 | 534.6065 | 1950018.0 |
| 2025-08-04 11:00:00 | MSFT | Stock | 534.61 | 535.56 | 533.19 | 535.39 | 1342686.0 |
| 2025-08-04 12:00:00 | MSFT | Stock | 535.395 | 537.39 | 535.26 | 537.09 | 1190530.0 |
| 2025-08-04 13:00:00 | MSFT | Stock | 537.1 | 538.25 | 536.84 | 537.81 | 1070877.0 |
| 2025-08-04 14:00:00 | MSFT | Stock | 537.81 | 538.02 | 535.7 | 535.875 | 1633053.0 |
| 2025-08-04 15:00:00 | MSFT | Stock | 535.87 | 536.78 | 534.08 | 535.47 | 3183238.0 |
| 2025-08-04 16:00:00 | MSFT | Stock | 535.64 | 537.5 | 535.0 | 537.3 | 3872971.0 |
| 2025-08-04 17:00:00 | MSFT | Stock | 537.0792 | 537.96 | 535.64 | 537.96 | 16417.0 |
| 2025-08-04 18:00:00 | MSFT | Stock | 537.75 | 537.92 | 537.18 | 537.743 | 7436.0 |
| 2025-08-04 19:00:00 | MSFT | Stock | 537.69 | 537.69 | 537.1 | 537.29 | 5785.0 |
| 2025-08-04 04:00:00 | NVDA | Stock | 174.8 | 175.63 | 174.0 | 175.32 | 464569.0 |
| 2025-08-04 05:00:00 | NVDA | Stock | 175.3 | 175.67 | 175.22 | 175.57 | 189340.0 |
| 2025-08-04 06:00:00 | NVDA | Stock | 175.57 | 176.15 | 175.52 | 175.81 | 275722.0 |
| 2025-08-04 07:00:00 | NVDA | Stock | 175.8 | 175.83 | 175.14 | 175.27 | 362965.0 |
| 2025-08-04 08:00:00 | NVDA | Stock | 175.81 | 176.1 | 173.23 | 175.62 | 1361583.0 |
| 2025-08-04 09:00:00 | NVDA | Stock | 175.64 | 177.27 | 174.52 | 177.07 | 19653425.0 |
| 2025-08-04 10:00:00 | NVDA | Stock | 177.09 | 178.1 | 176.6061 | 177.63 | 19166256.0 |
| 2025-08-04 11:00:00 | NVDA | Stock | 177.63 | 178.5499 | 176.93 | 178.4752 | 13275248.0 |
| 2025-08-04 12:00:00 | NVDA | Stock | 178.475 | 179.1 | 178.37 | 178.845 | 10378294.0 |
| 2025-08-04 13:00:00 | NVDA | Stock | 178.832 | 179.47 | 178.69 | 179.4204 | 9683514.0 |
| 2025-08-04 14:00:00 | NVDA | Stock | 179.43 | 179.815 | 178.94 | 179.0384 | 10972818.0 |
| 2025-08-04 15:00:00 | NVDA | Stock | 179.03 | 180.2 | 178.94 | 179.97 | 17778081.0 |
| 2025-08-04 16:00:00 | NVDA | Stock | 179.98 | 180.85 | 178.8583 | 180.85 | 16701489.0 |
| 2025-08-04 17:00:00 | NVDA | Stock | 180.8018 | 180.98 | 180.0 | 180.75 | 407740.0 |
| 2025-08-04 18:00:00 | NVDA | Stock | 180.78 | 180.78 | 180.55 | 180.76 | 198245.0 |
| 2025-08-04 19:00:00 | NVDA | Stock | 180.75 | 180.8 | 180.48 | 180.6702 | 290306.0 |
| 2025-08-04 04:00:00 | AMZN | Stock | 216.2 | 218.08 | 216.12 | 218.08 | 99866.0 |
| 2025-08-04 05:00:00 | AMZN | Stock | 218.15 | 218.7 | 217.9 | 218.19 | 121471.0 |
> showing 50 of 63,449 rows — these rows as CSV