PREVIEW / stock_1hour / 2025-08-15
file: by_date/stock_1hour/2025/2025-08-15.parquet size: 1.4 MB rows: 62,305 symbols: 336
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-15 04:00:00 | AAPL | Stock | 232.45 | 233.19 | 232.45 | 232.73 | 17410.0 |
| 2025-08-15 05:00:00 | AAPL | Stock | 232.66 | 233.18 | 232.66 | 233.11 | 4953.0 |
| 2025-08-15 06:00:00 | AAPL | Stock | 232.95 | 232.95 | 232.66 | 232.73 | 4437.0 |
| 2025-08-15 07:00:00 | AAPL | Stock | 232.8 | 233.3 | 232.73 | 233.12 | 7837.0 |
| 2025-08-15 08:00:00 | AAPL | Stock | 232.74 | 233.43 | 232.09 | 233.0799 | 106678.0 |
| 2025-08-15 09:00:00 | AAPL | Stock | 233.03 | 234.28 | 231.8 | 232.06 | 7141113.0 |
| 2025-08-15 10:00:00 | AAPL | Stock | 232.0 | 232.685 | 230.75 | 230.87 | 4439829.0 |
| 2025-08-15 11:00:00 | AAPL | Stock | 230.87 | 231.555 | 230.47 | 231.025 | 3876245.0 |
| 2025-08-15 12:00:00 | AAPL | Stock | 231.02 | 231.36 | 230.4737 | 230.9 | 2456507.0 |
| 2025-08-15 13:00:00 | AAPL | Stock | 230.91 | 231.225 | 230.23 | 230.89 | 2411631.0 |
| 2025-08-15 14:00:00 | AAPL | Stock | 230.885 | 231.2899 | 229.335 | 230.7697 | 3306864.0 |
| 2025-08-15 15:00:00 | AAPL | Stock | 230.77 | 231.77 | 230.59 | 231.65 | 4756546.0 |
| 2025-08-15 16:00:00 | AAPL | Stock | 231.65 | 231.77 | 230.88 | 231.16 | 9600549.0 |
| 2025-08-15 17:00:00 | AAPL | Stock | 231.21 | 231.59 | 231.1005 | 231.26 | 27246.0 |
| 2025-08-15 18:00:00 | AAPL | Stock | 231.19 | 231.5994 | 231.19 | 231.24 | 8670.0 |
| 2025-08-15 19:00:00 | AAPL | Stock | 231.28 | 231.4462 | 231.19 | 231.19 | 12253.0 |
| 2025-08-15 04:00:00 | MSFT | Stock | 524.15 | 524.47 | 523.01 | 523.35 | 10014.0 |
| 2025-08-15 05:00:00 | MSFT | Stock | 523.42 | 523.43 | 523.42 | 523.43 | 262.0 |
| 2025-08-15 06:00:00 | MSFT | Stock | 523.54 | 523.8 | 523.54 | 523.62 | 706.0 |
| 2025-08-15 07:00:00 | MSFT | Stock | 523.57 | 523.82 | 523.2 | 523.73 | 3899.0 |
| 2025-08-15 08:00:00 | MSFT | Stock | 523.5 | 525.0 | 522.92 | 523.07 | 27603.0 |
| 2025-08-15 09:00:00 | MSFT | Stock | 523.25 | 524.25 | 520.86 | 522.24 | 2655100.0 |
| 2025-08-15 10:00:00 | MSFT | Stock | 522.22 | 524.51 | 521.2 | 521.7458 | 1232895.0 |
| 2025-08-15 11:00:00 | MSFT | Stock | 521.72 | 524.88 | 521.7 | 523.895 | 903077.0 |
| 2025-08-15 12:00:00 | MSFT | Stock | 523.88 | 525.16 | 523.48 | 524.9 | 697224.0 |
| 2025-08-15 13:00:00 | MSFT | Stock | 524.9 | 525.91 | 524.52 | 525.83 | 514782.0 |
| 2025-08-15 14:00:00 | MSFT | Stock | 525.82 | 526.1 | 522.75 | 523.1612 | 1249092.0 |
| 2025-08-15 15:00:00 | MSFT | Stock | 523.135 | 523.4 | 519.08 | 520.04 | 3174606.0 |
| 2025-08-15 16:00:00 | MSFT | Stock | 520.04 | 520.31 | 519.6 | 519.97 | 4662467.0 |
| 2025-08-15 17:00:00 | MSFT | Stock | 519.97 | 520.48 | 519.97 | 520.48 | 183020.0 |
| 2025-08-15 18:00:00 | MSFT | Stock | 520.6 | 520.7 | 520.38 | 520.5786 | 6120.0 |
| 2025-08-15 19:00:00 | MSFT | Stock | 520.6899 | 520.6899 | 520.2 | 520.35 | 8603.0 |
| 2025-08-15 04:00:00 | NVDA | Stock | 182.14 | 182.23 | 181.53 | 181.65 | 120481.0 |
| 2025-08-15 05:00:00 | NVDA | Stock | 181.68 | 181.8 | 181.55 | 181.55 | 79856.0 |
| 2025-08-15 06:00:00 | NVDA | Stock | 181.56 | 181.83 | 181.45 | 181.64 | 66174.0 |
| 2025-08-15 07:00:00 | NVDA | Stock | 181.66 | 182.09 | 181.59 | 182.0 | 152134.0 |
| 2025-08-15 08:00:00 | NVDA | Stock | 181.98 | 182.25 | 181.5 | 182.12 | 893319.0 |
| 2025-08-15 09:00:00 | NVDA | Stock | 182.12 | 182.27 | 178.0417 | 179.0226 | 29641386.0 |
| 2025-08-15 10:00:00 | NVDA | Stock | 179.01 | 180.58 | 178.66 | 178.965 | 23202184.0 |
| 2025-08-15 11:00:00 | NVDA | Stock | 178.965 | 179.76 | 178.41 | 179.3501 | 14894755.0 |
| 2025-08-15 12:00:00 | NVDA | Stock | 179.355 | 179.66 | 178.83 | 179.5599 | 9769706.0 |
| 2025-08-15 13:00:00 | NVDA | Stock | 179.555 | 180.3 | 179.29 | 180.1857 | 8170843.0 |
| 2025-08-15 14:00:00 | NVDA | Stock | 180.18 | 180.31 | 179.66 | 179.86 | 7678730.0 |
| 2025-08-15 15:00:00 | NVDA | Stock | 179.845 | 181.0 | 179.485 | 180.4401 | 15935486.0 |
| 2025-08-15 16:00:00 | NVDA | Stock | 180.44 | 180.48 | 180.2 | 180.2 | 11910094.0 |
| 2025-08-15 17:00:00 | NVDA | Stock | 180.2001 | 180.45 | 180.13 | 180.19 | 174782.0 |
| 2025-08-15 18:00:00 | NVDA | Stock | 180.18 | 180.28 | 180.15 | 180.25 | 92993.0 |
| 2025-08-15 19:00:00 | NVDA | Stock | 180.2693 | 180.33 | 179.74 | 179.74 | 205689.0 |
| 2025-08-15 04:00:00 | AMZN | Stock | 231.02 | 231.78 | 230.98 | 231.39 | 10686.0 |
| 2025-08-15 05:00:00 | AMZN | Stock | 231.43 | 231.69 | 231.4 | 231.46 | 3343.0 |
> showing 50 of 62,305 rows — these rows as CSV