PREVIEW / stock_1hour / 2025-07-29
file: by_date/stock_1hour/2025/2025-07-29.parquet size: 1.4 MB rows: 62,492 symbols: 356
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-29 04:00:00 | AAPL | Stock | 214.06 | 214.19 | 213.91 | 214.05 | 5579.0 |
| 2025-07-29 05:00:00 | AAPL | Stock | 214.03 | 214.14 | 213.99 | 214.1 | 6064.0 |
| 2025-07-29 06:00:00 | AAPL | Stock | 214.1 | 214.1 | 213.8 | 213.81 | 7480.0 |
| 2025-07-29 07:00:00 | AAPL | Stock | 213.82 | 214.04 | 213.75 | 214.0 | 24514.0 |
| 2025-07-29 08:00:00 | AAPL | Stock | 213.84 | 214.1496 | 213.75 | 214.12 | 76618.0 |
| 2025-07-29 09:00:00 | AAPL | Stock | 214.04 | 214.81 | 211.5 | 212.54 | 5450635.0 |
| 2025-07-29 10:00:00 | AAPL | Stock | 212.56 | 213.39 | 212.07 | 212.6 | 5232325.0 |
| 2025-07-29 11:00:00 | AAPL | Stock | 212.605 | 212.7695 | 211.69 | 212.51 | 3760873.0 |
| 2025-07-29 12:00:00 | AAPL | Stock | 212.51 | 212.93 | 211.84 | 212.1761 | 2979901.0 |
| 2025-07-29 13:00:00 | AAPL | Stock | 212.16 | 212.39 | 210.82 | 212.075 | 3480414.0 |
| 2025-07-29 14:00:00 | AAPL | Stock | 212.065 | 212.44 | 211.81 | 211.98 | 2236268.0 |
| 2025-07-29 15:00:00 | AAPL | Stock | 211.97 | 212.05 | 211.0545 | 211.35 | 5389951.0 |
| 2025-07-29 16:00:00 | AAPL | Stock | 211.36 | 211.7 | 211.08 | 211.3 | 7232848.0 |
| 2025-07-29 17:00:00 | AAPL | Stock | 211.344 | 211.5 | 211.2004 | 211.45 | 31366.0 |
| 2025-07-29 18:00:00 | AAPL | Stock | 211.4482 | 211.49 | 211.35 | 211.402 | 10178.0 |
| 2025-07-29 19:00:00 | AAPL | Stock | 211.42 | 211.46 | 211.255 | 211.29 | 26920.0 |
| 2025-07-29 04:00:00 | MSFT | Stock | 513.77 | 514.02 | 513.45 | 513.45 | 3072.0 |
| 2025-07-29 05:00:00 | MSFT | Stock | 513.89 | 513.89 | 513.65 | 513.65 | 518.0 |
| 2025-07-29 06:00:00 | MSFT | Stock | 513.71 | 513.71 | 513.4 | 513.52 | 1755.0 |
| 2025-07-29 07:00:00 | MSFT | Stock | 513.69 | 514.54 | 513.0 | 513.02 | 14764.0 |
| 2025-07-29 08:00:00 | MSFT | Stock | 514.0 | 514.55 | 511.219 | 513.5 | 16033.0 |
| 2025-07-29 09:00:00 | MSFT | Stock | 513.51 | 517.62 | 513.5 | 515.35 | 1367482.0 |
| 2025-07-29 10:00:00 | MSFT | Stock | 515.395 | 515.5 | 512.7 | 513.07 | 1312387.0 |
| 2025-07-29 11:00:00 | MSFT | Stock | 513.05 | 514.73 | 512.88 | 514.0 | 947139.0 |
| 2025-07-29 12:00:00 | MSFT | Stock | 513.99 | 514.1 | 512.15 | 513.372 | 676617.0 |
| 2025-07-29 13:00:00 | MSFT | Stock | 513.39 | 513.89 | 511.68 | 512.27 | 557560.0 |
| 2025-07-29 14:00:00 | MSFT | Stock | 512.26 | 512.53 | 511.56 | 512.2 | 631754.0 |
| 2025-07-29 15:00:00 | MSFT | Stock | 512.18 | 512.95 | 511.71 | 512.95 | 1733285.0 |
| 2025-07-29 16:00:00 | MSFT | Stock | 512.57 | 513.9322 | 512.5 | 513.438 | 3118279.0 |
| 2025-07-29 17:00:00 | MSFT | Stock | 513.41 | 513.51 | 513.2517 | 513.39 | 18415.0 |
| 2025-07-29 18:00:00 | MSFT | Stock | 513.41 | 514.0 | 513.4001 | 513.87 | 9881.0 |
| 2025-07-29 19:00:00 | MSFT | Stock | 513.93 | 514.35 | 513.5655 | 513.75 | 7287.0 |
| 2025-07-29 04:00:00 | NVDA | Stock | 179.0 | 179.31 | 178.0 | 179.15 | 368983.0 |
| 2025-07-29 05:00:00 | NVDA | Stock | 179.16 | 179.62 | 179.15 | 179.44 | 304712.0 |
| 2025-07-29 06:00:00 | NVDA | Stock | 179.48 | 179.58 | 179.11 | 179.3 | 276593.0 |
| 2025-07-29 07:00:00 | NVDA | Stock | 179.3 | 179.52 | 178.881 | 179.18 | 587722.0 |
| 2025-07-29 08:00:00 | NVDA | Stock | 179.07 | 179.5894 | 177.58 | 179.0 | 2184490.0 |
| 2025-07-29 09:00:00 | NVDA | Stock | 178.99 | 179.38 | 176.75 | 179.28 | 24467092.0 |
| 2025-07-29 10:00:00 | NVDA | Stock | 179.29 | 179.35 | 177.1721 | 177.485 | 20994896.0 |
| 2025-07-29 11:00:00 | NVDA | Stock | 177.485 | 177.6684 | 175.17 | 176.515 | 24153083.0 |
| 2025-07-29 12:00:00 | NVDA | Stock | 176.51 | 176.735 | 175.8317 | 176.485 | 9330383.0 |
| 2025-07-29 13:00:00 | NVDA | Stock | 176.48 | 176.66 | 175.8 | 176.3401 | 8696406.0 |
| 2025-07-29 14:00:00 | NVDA | Stock | 176.345 | 176.63 | 175.98 | 176.11 | 7744398.0 |
| 2025-07-29 15:00:00 | NVDA | Stock | 176.1 | 176.5 | 175.02 | 175.51 | 15558124.0 |
| 2025-07-29 16:00:00 | NVDA | Stock | 175.56 | 176.725 | 175.43 | 175.8101 | 10367160.0 |
| 2025-07-29 17:00:00 | NVDA | Stock | 175.85 | 176.09 | 175.75 | 175.95 | 245625.0 |
| 2025-07-29 18:00:00 | NVDA | Stock | 175.98 | 176.1 | 175.78 | 176.02 | 154633.0 |
| 2025-07-29 19:00:00 | NVDA | Stock | 176.0 | 176.1 | 175.95 | 176.08 | 197177.0 |
| 2025-07-29 04:00:00 | AMZN | Stock | 233.51 | 233.66 | 233.24 | 233.45 | 10064.0 |
| 2025-07-29 05:00:00 | AMZN | Stock | 233.55 | 233.64 | 233.44 | 233.5 | 2966.0 |
> showing 50 of 62,492 rows — these rows as CSV