PREVIEW / stock_1hour / 2025-09-04
file: by_date/stock_1hour/2025/2025-09-04.parquet size: 1.4 MB rows: 61,851 symbols: 318
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-09-04 04:00:00 | AAPL | Stock | 238.77 | 238.77 | 238.19 | 238.22 | 10404.0 |
| 2025-09-04 05:00:00 | AAPL | Stock | 238.28 | 238.29 | 238.03 | 238.1 | 8373.0 |
| 2025-09-04 06:00:00 | AAPL | Stock | 238.05 | 238.81 | 237.76 | 238.11 | 39967.0 |
| 2025-09-04 07:00:00 | AAPL | Stock | 238.11 | 238.18 | 237.5 | 237.5 | 37663.0 |
| 2025-09-04 08:00:00 | AAPL | Stock | 238.0 | 238.54 | 237.0 | 237.59 | 155503.0 |
| 2025-09-04 09:00:00 | AAPL | Stock | 237.55 | 239.8932 | 237.03 | 239.5 | 6174718.0 |
| 2025-09-04 10:00:00 | AAPL | Stock | 239.54 | 239.59 | 237.16 | 237.4716 | 4979554.0 |
| 2025-09-04 11:00:00 | AAPL | Stock | 237.47 | 238.1 | 236.74 | 237.41 | 3595156.0 |
| 2025-09-04 12:00:00 | AAPL | Stock | 237.4184 | 237.6746 | 236.97 | 237.51 | 2244627.0 |
| 2025-09-04 13:00:00 | AAPL | Stock | 237.515 | 238.22 | 237.5 | 238.145 | 2237525.0 |
| 2025-09-04 14:00:00 | AAPL | Stock | 238.15 | 238.7115 | 237.88 | 238.475 | 2397441.0 |
| 2025-09-04 15:00:00 | AAPL | Stock | 238.48 | 239.8999 | 238.33 | 239.71 | 5887785.0 |
| 2025-09-04 16:00:00 | AAPL | Stock | 239.7 | 239.92 | 238.0902 | 239.78 | 5400698.0 |
| 2025-09-04 17:00:00 | AAPL | Stock | 239.54 | 239.6 | 239.22 | 239.33 | 37456.0 |
| 2025-09-04 18:00:00 | AAPL | Stock | 239.31 | 239.45 | 239.19 | 239.35 | 15915.0 |
| 2025-09-04 19:00:00 | AAPL | Stock | 239.3 | 239.48 | 239.1304 | 239.1999 | 24545.0 |
| 2025-09-04 04:00:00 | MSFT | Stock | 504.5 | 504.5 | 504.18 | 504.18 | 1100.0 |
| 2025-09-04 05:00:00 | MSFT | Stock | 504.42 | 504.42 | 504.28 | 504.4 | 902.0 |
| 2025-09-04 06:00:00 | MSFT | Stock | 505.0 | 505.18 | 504.73 | 504.75 | 1204.0 |
| 2025-09-04 07:00:00 | MSFT | Stock | 504.5 | 504.7 | 504.34 | 504.51 | 3002.0 |
| 2025-09-04 08:00:00 | MSFT | Stock | 504.77 | 505.0 | 503.6 | 504.35 | 23445.0 |
| 2025-09-04 09:00:00 | MSFT | Stock | 504.1 | 506.91 | 503.25 | 503.9 | 1120852.0 |
| 2025-09-04 10:00:00 | MSFT | Stock | 503.9 | 507.65 | 503.15 | 507.55 | 1153313.0 |
| 2025-09-04 11:00:00 | MSFT | Stock | 507.4964 | 508.05 | 506.13 | 506.89 | 945792.0 |
| 2025-09-04 12:00:00 | MSFT | Stock | 506.8975 | 507.09 | 505.8344 | 506.365 | 622136.0 |
| 2025-09-04 13:00:00 | MSFT | Stock | 506.3706 | 507.673 | 506.15 | 507.316 | 538450.0 |
| 2025-09-04 14:00:00 | MSFT | Stock | 507.28 | 508.15 | 506.93 | 507.53 | 643865.0 |
| 2025-09-04 15:00:00 | MSFT | Stock | 507.57 | 507.98 | 506.31 | 507.98 | 1744882.0 |
| 2025-09-04 16:00:00 | MSFT | Stock | 507.97 | 508.85 | 507.51 | 508.31 | 2568410.0 |
| 2025-09-04 17:00:00 | MSFT | Stock | 508.27 | 508.6 | 507.97 | 508.6 | 13586.0 |
| 2025-09-04 18:00:00 | MSFT | Stock | 508.68 | 508.68 | 508.11 | 508.25 | 1837.0 |
| 2025-09-04 19:00:00 | MSFT | Stock | 508.3 | 508.5 | 508.1087 | 508.5 | 5036.0 |
| 2025-09-04 04:00:00 | NVDA | Stock | 171.0 | 172.0 | 170.53 | 171.62 | 277819.0 |
| 2025-09-04 05:00:00 | NVDA | Stock | 171.67 | 171.77 | 171.46 | 171.72 | 74081.0 |
| 2025-09-04 06:00:00 | NVDA | Stock | 171.71 | 171.83 | 171.49 | 171.49 | 106261.0 |
| 2025-09-04 07:00:00 | NVDA | Stock | 171.47 | 171.5 | 170.3 | 171.23 | 348205.0 |
| 2025-09-04 08:00:00 | NVDA | Stock | 171.33 | 171.95 | 170.05 | 170.85 | 1297940.0 |
| 2025-09-04 09:00:00 | NVDA | Stock | 170.85 | 171.86 | 169.5 | 170.1 | 17935219.0 |
| 2025-09-04 10:00:00 | NVDA | Stock | 170.03 | 171.3083 | 169.41 | 170.835 | 18852551.0 |
| 2025-09-04 11:00:00 | NVDA | Stock | 170.84 | 171.07 | 170.08 | 170.55 | 12718629.0 |
| 2025-09-04 12:00:00 | NVDA | Stock | 170.55 | 171.19 | 170.3935 | 170.52 | 9290616.0 |
| 2025-09-04 13:00:00 | NVDA | Stock | 170.515 | 170.88 | 170.35 | 170.625 | 8262295.0 |
| 2025-09-04 14:00:00 | NVDA | Stock | 170.625 | 170.9 | 170.39 | 170.835 | 7882216.0 |
| 2025-09-04 15:00:00 | NVDA | Stock | 170.835 | 171.74 | 170.67 | 171.64 | 16864013.0 |
| 2025-09-04 16:00:00 | NVDA | Stock | 171.65 | 172.0 | 171.25 | 171.55 | 11277107.0 |
| 2025-09-04 17:00:00 | NVDA | Stock | 171.5312 | 171.99 | 171.15 | 171.18 | 753106.0 |
| 2025-09-04 18:00:00 | NVDA | Stock | 171.18 | 171.4783 | 171.01 | 171.37 | 272852.0 |
| 2025-09-04 19:00:00 | NVDA | Stock | 171.3501 | 171.57 | 171.25 | 171.3 | 219788.0 |
| 2025-09-04 04:00:00 | AMZN | Stock | 228.23 | 229.15 | 228.2 | 229.15 | 19765.0 |
| 2025-09-04 05:00:00 | AMZN | Stock | 229.0 | 229.12 | 228.77 | 229.0 | 8684.0 |
> showing 50 of 61,851 rows — these rows as CSV