PREVIEW / stock_1hour / 2025-10-07
file: by_date/stock_1hour/2025/2025-10-07.parquet size: 1.5 MB rows: 65,187 symbols: 237
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-10-07 04:00:00 | AAPL | Stock | 255.79 | 255.99 | 255.5 | 255.99 | 8867.0 |
| 2025-10-07 05:00:00 | AAPL | Stock | 255.98 | 256.09 | 255.5 | 255.5 | 2967.0 |
| 2025-10-07 06:00:00 | AAPL | Stock | 255.67 | 255.77 | 255.5 | 255.5 | 6193.0 |
| 2025-10-07 07:00:00 | AAPL | Stock | 255.6 | 255.9 | 255.51 | 255.78 | 8682.0 |
| 2025-10-07 08:00:00 | AAPL | Stock | 255.64 | 256.41 | 255.5 | 256.32 | 92491.0 |
| 2025-10-07 09:00:00 | AAPL | Stock | 256.32 | 257.4 | 255.87 | 257.1635 | 2990292.0 |
| 2025-10-07 10:00:00 | AAPL | Stock | 257.16 | 257.2405 | 255.6 | 255.925 | 3723851.0 |
| 2025-10-07 11:00:00 | AAPL | Stock | 255.89 | 257.1079 | 255.89 | 256.3 | 2871159.0 |
| 2025-10-07 12:00:00 | AAPL | Stock | 256.294 | 256.66 | 255.89 | 256.08 | 2169049.0 |
| 2025-10-07 13:00:00 | AAPL | Stock | 256.085 | 256.22 | 255.43 | 255.84 | 1614998.0 |
| 2025-10-07 14:00:00 | AAPL | Stock | 255.84 | 256.21 | 255.565 | 256.155 | 1671984.0 |
| 2025-10-07 15:00:00 | AAPL | Stock | 256.15 | 256.62 | 255.91 | 256.48 | 4020233.0 |
| 2025-10-07 16:00:00 | AAPL | Stock | 256.49 | 256.7 | 256.2868 | 256.48 | 4555626.0 |
| 2025-10-07 17:00:00 | AAPL | Stock | 256.47 | 256.47 | 256.2505 | 256.2505 | 8108.0 |
| 2025-10-07 18:00:00 | AAPL | Stock | 256.36 | 256.46 | 256.0 | 256.4 | 9890.0 |
| 2025-10-07 19:00:00 | AAPL | Stock | 256.29 | 256.29 | 255.9 | 255.95 | 20566.0 |
| 2025-10-07 04:00:00 | MSFT | Stock | 526.77 | 528.05 | 526.62 | 528.04 | 2015.0 |
| 2025-10-07 05:00:00 | MSFT | Stock | 527.99 | 527.99 | 527.69 | 527.9 | 912.0 |
| 2025-10-07 06:00:00 | MSFT | Stock | 527.93 | 528.09 | 527.75 | 528.09 | 5194.0 |
| 2025-10-07 07:00:00 | MSFT | Stock | 527.76 | 528.37 | 527.19 | 527.49 | 3887.0 |
| 2025-10-07 08:00:00 | MSFT | Stock | 527.26 | 528.57 | 526.52 | 528.5 | 18978.0 |
| 2025-10-07 09:00:00 | MSFT | Stock | 528.45 | 529.8 | 524.06 | 525.0485 | 1462279.0 |
| 2025-10-07 10:00:00 | MSFT | Stock | 525.075 | 527.5 | 524.92 | 526.01 | 928182.0 |
| 2025-10-07 11:00:00 | MSFT | Stock | 526.1 | 526.24 | 522.4701 | 522.855 | 1351931.0 |
| 2025-10-07 12:00:00 | MSFT | Stock | 522.81 | 524.45 | 521.92 | 522.46 | 788761.0 |
| 2025-10-07 13:00:00 | MSFT | Stock | 522.478 | 522.97 | 521.85 | 522.041 | 455949.0 |
| 2025-10-07 14:00:00 | MSFT | Stock | 522.09 | 523.13 | 521.44 | 523.05 | 348882.0 |
| 2025-10-07 15:00:00 | MSFT | Stock | 522.99 | 524.54 | 522.53 | 523.97 | 956447.0 |
| 2025-10-07 16:00:00 | MSFT | Stock | 523.98 | 523.98 | 522.76 | 523.98 | 2559720.0 |
| 2025-10-07 17:00:00 | MSFT | Stock | 523.92 | 523.98 | 523.84 | 523.89 | 2865.0 |
| 2025-10-07 18:00:00 | MSFT | Stock | 523.89 | 524.1 | 523.75 | 524.06 | 1805.0 |
| 2025-10-07 19:00:00 | MSFT | Stock | 523.75 | 523.95 | 522.64 | 523.44 | 4300.0 |
| 2025-10-07 04:00:00 | NVDA | Stock | 186.04 | 186.49 | 185.92 | 186.03 | 145800.0 |
| 2025-10-07 05:00:00 | NVDA | Stock | 186.02 | 186.92 | 185.91 | 186.46 | 200791.0 |
| 2025-10-07 06:00:00 | NVDA | Stock | 186.5 | 186.55 | 185.92 | 186.08 | 148476.0 |
| 2025-10-07 07:00:00 | NVDA | Stock | 186.11 | 186.37 | 185.9 | 186.27 | 156430.0 |
| 2025-10-07 08:00:00 | NVDA | Stock | 186.27 | 186.84 | 185.7 | 186.6799 | 1002708.0 |
| 2025-10-07 09:00:00 | NVDA | Stock | 186.66 | 188.96 | 186.18 | 188.825 | 17766827.0 |
| 2025-10-07 10:00:00 | NVDA | Stock | 188.8218 | 189.06 | 187.565 | 187.83 | 17174091.0 |
| 2025-10-07 11:00:00 | NVDA | Stock | 187.83 | 187.87 | 184.405 | 185.465 | 28201129.0 |
| 2025-10-07 12:00:00 | NVDA | Stock | 185.47 | 186.415 | 185.0783 | 185.75 | 12768373.0 |
| 2025-10-07 13:00:00 | NVDA | Stock | 185.75 | 186.19 | 185.32 | 185.36 | 7434900.0 |
| 2025-10-07 14:00:00 | NVDA | Stock | 185.36 | 186.04 | 185.15 | 185.63 | 6387959.0 |
| 2025-10-07 15:00:00 | NVDA | Stock | 185.62 | 185.8 | 184.0 | 184.95 | 11031486.0 |
| 2025-10-07 16:00:00 | NVDA | Stock | 184.96 | 185.29 | 184.68 | 185.1894 | 8794082.0 |
| 2025-10-07 17:00:00 | NVDA | Stock | 185.19 | 185.4809 | 185.19 | 185.31 | 224509.0 |
| 2025-10-07 18:00:00 | NVDA | Stock | 185.33 | 185.539 | 185.24 | 185.3802 | 149827.0 |
| 2025-10-07 19:00:00 | NVDA | Stock | 185.4026 | 186.18 | 184.8891 | 184.9868 | 418365.0 |
| 2025-10-07 04:00:00 | AMZN | Stock | 220.9 | 220.9 | 220.5 | 220.86 | 1877.0 |
| 2025-10-07 05:00:00 | AMZN | Stock | 220.89 | 221.36 | 220.89 | 221.09 | 7181.0 |
> showing 50 of 65,187 rows — these rows as CSV