PREVIEW / stock_1hour / 2025-10-22
file: by_date/stock_1hour/2025/2025-10-22.parquet size: 1.5 MB rows: 64,815 symbols: 225
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-22 04:00:00 | AAPL | Stock | 262.68 | 262.68 | 262.12 | 262.17 | 5643.0 |
| 2025-10-22 05:00:00 | AAPL | Stock | 262.1 | 262.15 | 259.8 | 261.19 | 56966.0 |
| 2025-10-22 06:00:00 | AAPL | Stock | 261.19 | 261.49 | 260.6 | 261.3 | 30360.0 |
| 2025-10-22 07:00:00 | AAPL | Stock | 261.25 | 261.76 | 260.7 | 260.9 | 53660.0 |
| 2025-10-22 08:00:00 | AAPL | Stock | 262.45 | 263.4 | 259.95 | 261.3296 | 154770.0 |
| 2025-10-22 09:00:00 | AAPL | Stock | 261.28 | 262.85 | 259.93 | 260.4 | 4083923.0 |
| 2025-10-22 10:00:00 | AAPL | Stock | 260.4125 | 261.37 | 259.72 | 260.74 | 4221330.0 |
| 2025-10-22 11:00:00 | AAPL | Stock | 260.75 | 260.76 | 257.6401 | 259.305 | 4421318.0 |
| 2025-10-22 12:00:00 | AAPL | Stock | 259.305 | 259.41 | 256.375 | 257.67 | 3228759.0 |
| 2025-10-22 13:00:00 | AAPL | Stock | 257.68 | 257.8204 | 255.43 | 256.33 | 3298725.0 |
| 2025-10-22 14:00:00 | AAPL | Stock | 256.31 | 257.0798 | 256.14 | 256.97 | 1985710.0 |
| 2025-10-22 15:00:00 | AAPL | Stock | 256.96 | 258.81 | 256.5 | 258.43 | 4306925.0 |
| 2025-10-22 16:00:00 | AAPL | Stock | 258.4 | 258.96 | 258.0 | 258.6436 | 6794998.0 |
| 2025-10-22 17:00:00 | AAPL | Stock | 258.55 | 258.64 | 258.45 | 258.62 | 69501.0 |
| 2025-10-22 18:00:00 | AAPL | Stock | 258.6 | 259.55 | 258.6 | 259.07 | 36939.0 |
| 2025-10-22 19:00:00 | AAPL | Stock | 259.31 | 259.5592 | 258.8237 | 258.89 | 20816.0 |
| 2025-10-22 04:00:00 | MSFT | Stock | 517.66 | 517.66 | 517.39 | 517.39 | 239.0 |
| 2025-10-22 05:00:00 | MSFT | Stock | 517.39 | 517.39 | 517.39 | 517.39 | 100.0 |
| 2025-10-22 06:00:00 | MSFT | Stock | 517.77 | 519.67 | 517.77 | 518.75 | 9405.0 |
| 2025-10-22 07:00:00 | MSFT | Stock | 518.65 | 519.0 | 518.3 | 518.99 | 8628.0 |
| 2025-10-22 08:00:00 | MSFT | Stock | 519.0 | 520.05 | 517.08 | 519.75 | 33978.0 |
| 2025-10-22 09:00:00 | MSFT | Stock | 519.65 | 523.54 | 519.07 | 522.44 | 1502005.0 |
| 2025-10-22 10:00:00 | MSFT | Stock | 522.4 | 524.91 | 521.2 | 524.91 | 1877691.0 |
| 2025-10-22 11:00:00 | MSFT | Stock | 524.91 | 525.23 | 522.02 | 523.65 | 1300365.0 |
| 2025-10-22 12:00:00 | MSFT | Stock | 523.6145 | 524.17 | 520.9866 | 522.91 | 1280150.0 |
| 2025-10-22 13:00:00 | MSFT | Stock | 522.89 | 523.1 | 517.71 | 518.805 | 703546.0 |
| 2025-10-22 14:00:00 | MSFT | Stock | 518.77 | 520.295 | 518.62 | 519.49 | 601821.0 |
| 2025-10-22 15:00:00 | MSFT | Stock | 519.505 | 520.9754 | 518.955 | 520.48 | 1130621.0 |
| 2025-10-22 16:00:00 | MSFT | Stock | 520.54 | 521.51 | 520.0 | 520.03 | 2635355.0 |
| 2025-10-22 17:00:00 | MSFT | Stock | 520.3 | 521.0 | 520.0106 | 520.25 | 8331.0 |
| 2025-10-22 18:00:00 | MSFT | Stock | 521.0 | 522.37 | 520.3399 | 521.0 | 7788.0 |
| 2025-10-22 19:00:00 | MSFT | Stock | 521.8428 | 521.85 | 520.8 | 520.8 | 2795.0 |
| 2025-10-22 04:00:00 | NVDA | Stock | 181.34 | 181.46 | 181.0 | 181.36 | 101405.0 |
| 2025-10-22 05:00:00 | NVDA | Stock | 181.32 | 181.93 | 180.96 | 181.81 | 131407.0 |
| 2025-10-22 06:00:00 | NVDA | Stock | 181.82 | 181.9 | 181.53 | 181.57 | 100220.0 |
| 2025-10-22 07:00:00 | NVDA | Stock | 181.62 | 181.7 | 180.98 | 181.01 | 196248.0 |
| 2025-10-22 08:00:00 | NVDA | Stock | 181.65 | 181.93 | 180.9 | 181.1389 | 728790.0 |
| 2025-10-22 09:00:00 | NVDA | Stock | 181.1398 | 183.44 | 180.29 | 182.65 | 15269075.0 |
| 2025-10-22 10:00:00 | NVDA | Stock | 182.6765 | 183.12 | 179.32 | 180.685 | 22872685.0 |
| 2025-10-22 11:00:00 | NVDA | Stock | 180.68 | 180.7259 | 177.9 | 179.48 | 17522308.0 |
| 2025-10-22 12:00:00 | NVDA | Stock | 179.47 | 179.96 | 177.76 | 178.79 | 13260720.0 |
| 2025-10-22 13:00:00 | NVDA | Stock | 178.77 | 179.0 | 176.76 | 177.557 | 12932741.0 |
| 2025-10-22 14:00:00 | NVDA | Stock | 177.555 | 178.9 | 176.93 | 178.8701 | 12133132.0 |
| 2025-10-22 15:00:00 | NVDA | Stock | 178.875 | 180.39 | 178.6301 | 180.29 | 15134217.0 |
| 2025-10-22 16:00:00 | NVDA | Stock | 180.29 | 180.58 | 179.4485 | 179.78 | 11532684.0 |
| 2025-10-22 17:00:00 | NVDA | Stock | 179.8 | 179.89 | 179.53 | 179.59 | 243343.0 |
| 2025-10-22 18:00:00 | NVDA | Stock | 179.59 | 180.1 | 179.5713 | 179.93 | 270507.0 |
| 2025-10-22 19:00:00 | NVDA | Stock | 179.92 | 180.2 | 179.62 | 179.7 | 183587.0 |
| 2025-10-22 04:00:00 | AMZN | Stock | 220.88 | 221.09 | 220.15 | 220.29 | 24031.0 |
| 2025-10-22 05:00:00 | AMZN | Stock | 220.32 | 220.32 | 219.5 | 219.59 | 45626.0 |
> showing 50 of 64,815 rows — these rows as CSV