PREVIEW / stock_1hour / 2025-07-28
file: by_date/stock_1hour/2025/2025-07-28.parquet size: 1.5 MB rows: 64,291 symbols: 364
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-28 04:00:00 | AAPL | Stock | 214.72 | 214.75 | 214.3 | 214.5 | 18753.0 |
| 2025-07-28 05:00:00 | AAPL | Stock | 214.5 | 214.54 | 214.33 | 214.48 | 6490.0 |
| 2025-07-28 06:00:00 | AAPL | Stock | 214.51 | 214.7 | 214.3 | 214.3 | 11053.0 |
| 2025-07-28 07:00:00 | AAPL | Stock | 214.39 | 214.5 | 214.27 | 214.32 | 31656.0 |
| 2025-07-28 08:00:00 | AAPL | Stock | 214.44 | 214.93 | 213.346 | 214.3588 | 106104.0 |
| 2025-07-28 09:00:00 | AAPL | Stock | 214.34 | 214.67 | 213.58 | 213.9 | 3626881.0 |
| 2025-07-28 10:00:00 | AAPL | Stock | 213.93 | 214.845 | 213.86 | 214.42 | 3942943.0 |
| 2025-07-28 11:00:00 | AAPL | Stock | 214.435 | 214.6 | 214.12 | 214.43 | 2382422.0 |
| 2025-07-28 12:00:00 | AAPL | Stock | 214.435 | 214.75 | 214.225 | 214.33 | 1790746.0 |
| 2025-07-28 13:00:00 | AAPL | Stock | 214.34 | 214.45 | 213.415 | 213.735 | 2259697.0 |
| 2025-07-28 14:00:00 | AAPL | Stock | 213.735 | 213.983 | 213.06 | 213.12 | 2302456.0 |
| 2025-07-28 15:00:00 | AAPL | Stock | 213.14 | 214.1 | 213.06 | 214.04 | 4766700.0 |
| 2025-07-28 16:00:00 | AAPL | Stock | 214.03 | 214.1 | 213.85 | 213.9 | 4506955.0 |
| 2025-07-28 17:00:00 | AAPL | Stock | 214.0 | 214.05 | 213.9 | 213.9 | 20934.0 |
| 2025-07-28 18:00:00 | AAPL | Stock | 213.92 | 214.28 | 213.92 | 214.27 | 21463.0 |
| 2025-07-28 19:00:00 | AAPL | Stock | 214.1301 | 214.2 | 214.11 | 214.1106 | 23470.0 |
| 2025-07-28 04:00:00 | MSFT | Stock | 516.51 | 516.51 | 515.11 | 515.49 | 6230.0 |
| 2025-07-28 05:00:00 | MSFT | Stock | 515.75 | 515.8 | 515.48 | 515.48 | 1462.0 |
| 2025-07-28 06:00:00 | MSFT | Stock | 515.2 | 515.2 | 514.4 | 514.4 | 11896.0 |
| 2025-07-28 07:00:00 | MSFT | Stock | 514.34 | 515.0 | 514.17 | 515.0 | 14082.0 |
| 2025-07-28 08:00:00 | MSFT | Stock | 514.34 | 516.55 | 512.426 | 515.56 | 50967.0 |
| 2025-07-28 09:00:00 | MSFT | Stock | 515.5 | 515.6 | 512.36 | 514.69 | 1212967.0 |
| 2025-07-28 10:00:00 | MSFT | Stock | 514.695 | 515.0 | 512.21 | 512.775 | 1037307.0 |
| 2025-07-28 11:00:00 | MSFT | Stock | 512.73 | 512.84 | 511.555 | 512.36 | 700011.0 |
| 2025-07-28 12:00:00 | MSFT | Stock | 512.365 | 512.4893 | 511.72 | 512.16 | 483010.0 |
| 2025-07-28 13:00:00 | MSFT | Stock | 512.16 | 512.41 | 511.11 | 511.64 | 503645.0 |
| 2025-07-28 14:00:00 | MSFT | Stock | 511.6 | 511.71 | 510.12 | 510.18 | 797374.0 |
| 2025-07-28 15:00:00 | MSFT | Stock | 510.19 | 512.52 | 510.165 | 512.51 | 1410150.0 |
| 2025-07-28 16:00:00 | MSFT | Stock | 512.5 | 512.95 | 512.0 | 512.66 | 2181190.0 |
| 2025-07-28 17:00:00 | MSFT | Stock | 512.85 | 513.19 | 512.85 | 513.1304 | 10379.0 |
| 2025-07-28 18:00:00 | MSFT | Stock | 513.29 | 513.71 | 513.29 | 513.33 | 3955.0 |
| 2025-07-28 19:00:00 | MSFT | Stock | 513.29 | 513.71 | 513.29 | 513.41 | 2865.0 |
| 2025-07-28 04:00:00 | NVDA | Stock | 174.75 | 174.98 | 174.01 | 174.7 | 266989.0 |
| 2025-07-28 05:00:00 | NVDA | Stock | 174.73 | 174.79 | 174.59 | 174.64 | 72392.0 |
| 2025-07-28 06:00:00 | NVDA | Stock | 174.63 | 174.79 | 174.38 | 174.45 | 128480.0 |
| 2025-07-28 07:00:00 | NVDA | Stock | 174.44 | 174.64 | 174.37 | 174.58 | 195002.0 |
| 2025-07-28 08:00:00 | NVDA | Stock | 174.38 | 174.96 | 173.067 | 174.64 | 944553.0 |
| 2025-07-28 09:00:00 | NVDA | Stock | 174.64 | 175.46 | 173.97 | 175.42 | 21473483.0 |
| 2025-07-28 10:00:00 | NVDA | Stock | 175.41 | 175.57 | 174.57 | 175.005 | 15920457.0 |
| 2025-07-28 11:00:00 | NVDA | Stock | 175.01 | 175.19 | 174.255 | 174.955 | 11065168.0 |
| 2025-07-28 12:00:00 | NVDA | Stock | 174.955 | 175.14 | 174.68 | 174.8829 | 6765525.0 |
| 2025-07-28 13:00:00 | NVDA | Stock | 174.8801 | 175.6951 | 174.84 | 175.5 | 9935093.0 |
| 2025-07-28 14:00:00 | NVDA | Stock | 175.495 | 175.92 | 175.21 | 175.8499 | 9354696.0 |
| 2025-07-28 15:00:00 | NVDA | Stock | 175.85 | 177.0 | 175.75 | 176.75 | 21443014.0 |
| 2025-07-28 16:00:00 | NVDA | Stock | 176.74 | 176.99 | 176.5 | 176.85 | 15598509.0 |
| 2025-07-28 17:00:00 | NVDA | Stock | 176.8301 | 177.0 | 176.82 | 176.88 | 200610.0 |
| 2025-07-28 18:00:00 | NVDA | Stock | 176.85 | 176.93 | 176.76 | 176.93 | 159152.0 |
| 2025-07-28 19:00:00 | NVDA | Stock | 176.93 | 177.166 | 176.85 | 177.1499 | 300078.0 |
| 2025-07-28 04:00:00 | AMZN | Stock | 233.06 | 233.06 | 232.6 | 232.75 | 11336.0 |
| 2025-07-28 05:00:00 | AMZN | Stock | 232.71 | 232.89 | 232.61 | 232.75 | 11247.0 |
> showing 50 of 64,291 rows — these rows as CSV