PREVIEW / stock_1hour / 2025-10-24
file: by_date/stock_1hour/2025/2025-10-24.parquet size: 1.4 MB rows: 63,845 symbols: 222
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-24 04:00:00 | AAPL | Stock | 259.67 | 259.79 | 259.3 | 259.58 | 6140.0 |
| 2025-10-24 05:00:00 | AAPL | Stock | 259.29 | 259.66 | 259.25 | 259.44 | 5693.0 |
| 2025-10-24 06:00:00 | AAPL | Stock | 259.54 | 260.42 | 259.54 | 260.34 | 7997.0 |
| 2025-10-24 07:00:00 | AAPL | Stock | 260.3 | 260.57 | 260.12 | 260.5 | 12770.0 |
| 2025-10-24 08:00:00 | AAPL | Stock | 260.24 | 262.0 | 259.43 | 260.91 | 162224.0 |
| 2025-10-24 09:00:00 | AAPL | Stock | 260.98 | 261.68 | 259.18 | 260.16 | 3474308.0 |
| 2025-10-24 10:00:00 | AAPL | Stock | 260.2 | 262.35 | 259.88 | 261.831 | 3863865.0 |
| 2025-10-24 11:00:00 | AAPL | Stock | 261.85 | 263.785 | 261.76 | 263.3372 | 4030195.0 |
| 2025-10-24 12:00:00 | AAPL | Stock | 263.345 | 264.03 | 262.85 | 263.1099 | 2507113.0 |
| 2025-10-24 13:00:00 | AAPL | Stock | 263.1 | 264.09 | 263.09 | 263.9001 | 2222846.0 |
| 2025-10-24 14:00:00 | AAPL | Stock | 263.89 | 264.13 | 263.42 | 263.52 | 2258478.0 |
| 2025-10-24 15:00:00 | AAPL | Stock | 263.51 | 263.66 | 262.08 | 262.77 | 4814191.0 |
| 2025-10-24 16:00:00 | AAPL | Stock | 262.83 | 263.0 | 262.61 | 262.76 | 5952617.0 |
| 2025-10-24 17:00:00 | AAPL | Stock | 262.76 | 263.2 | 262.24 | 263.1 | 61228.0 |
| 2025-10-24 18:00:00 | AAPL | Stock | 263.1 | 263.17 | 262.94 | 262.94 | 13656.0 |
| 2025-10-24 19:00:00 | AAPL | Stock | 262.97 | 263.1644 | 262.8844 | 263.01 | 6623.0 |
| 2025-10-24 04:00:00 | MSFT | Stock | 521.5 | 522.24 | 520.67 | 521.53 | 15008.0 |
| 2025-10-24 05:00:00 | MSFT | Stock | 521.78 | 522.66 | 521.78 | 522.47 | 4015.0 |
| 2025-10-24 06:00:00 | MSFT | Stock | 522.5 | 524.49 | 520.9 | 521.1 | 29194.0 |
| 2025-10-24 07:00:00 | MSFT | Stock | 521.25 | 522.04 | 520.0 | 522.0 | 19775.0 |
| 2025-10-24 08:00:00 | MSFT | Stock | 522.0 | 524.5 | 520.0 | 523.1116 | 81060.0 |
| 2025-10-24 09:00:00 | MSFT | Stock | 523.17 | 525.05 | 520.71 | 523.0 | 1438347.0 |
| 2025-10-24 10:00:00 | MSFT | Stock | 523.02 | 523.78 | 522.0 | 522.975 | 784912.0 |
| 2025-10-24 11:00:00 | MSFT | Stock | 523.01 | 523.8 | 522.07 | 522.305 | 631745.0 |
| 2025-10-24 12:00:00 | MSFT | Stock | 522.34 | 525.02 | 522.3202 | 524.45 | 570181.0 |
| 2025-10-24 13:00:00 | MSFT | Stock | 524.4 | 524.89 | 523.35 | 524.36 | 571069.0 |
| 2025-10-24 14:00:00 | MSFT | Stock | 524.32 | 525.34 | 523.8306 | 525.04 | 638104.0 |
| 2025-10-24 15:00:00 | MSFT | Stock | 525.05 | 525.345 | 522.95 | 523.5 | 1810435.0 |
| 2025-10-24 16:00:00 | MSFT | Stock | 523.61 | 524.5 | 523.05 | 524.23 | 2974517.0 |
| 2025-10-24 17:00:00 | MSFT | Stock | 524.32 | 524.33 | 523.61 | 524.25 | 7033.0 |
| 2025-10-24 18:00:00 | MSFT | Stock | 524.13 | 524.3 | 523.7501 | 524.0 | 4094.0 |
| 2025-10-24 19:00:00 | MSFT | Stock | 524.05 | 524.3 | 523.8 | 524.2942 | 3350.0 |
| 2025-10-24 04:00:00 | NVDA | Stock | 182.72 | 183.3 | 182.6 | 183.13 | 163419.0 |
| 2025-10-24 05:00:00 | NVDA | Stock | 183.16 | 183.3 | 183.05 | 183.19 | 78239.0 |
| 2025-10-24 06:00:00 | NVDA | Stock | 183.22 | 183.45 | 182.99 | 183.02 | 111326.0 |
| 2025-10-24 07:00:00 | NVDA | Stock | 182.99 | 183.4 | 182.99 | 183.21 | 174897.0 |
| 2025-10-24 08:00:00 | NVDA | Stock | 183.07 | 184.49 | 182.46 | 183.95 | 1703943.0 |
| 2025-10-24 09:00:00 | NVDA | Stock | 183.96 | 186.03 | 183.5 | 185.54 | 18094441.0 |
| 2025-10-24 10:00:00 | NVDA | Stock | 185.56 | 185.7 | 184.2701 | 184.855 | 16423673.0 |
| 2025-10-24 11:00:00 | NVDA | Stock | 184.855 | 185.6 | 184.53 | 185.325 | 10357979.0 |
| 2025-10-24 12:00:00 | NVDA | Stock | 185.32 | 185.42 | 184.92 | 185.175 | 6689124.0 |
| 2025-10-24 13:00:00 | NVDA | Stock | 185.17 | 185.65 | 184.9 | 185.485 | 6510155.0 |
| 2025-10-24 14:00:00 | NVDA | Stock | 185.4801 | 185.8 | 185.015 | 185.8 | 7795221.0 |
| 2025-10-24 15:00:00 | NVDA | Stock | 185.8 | 187.47 | 185.7801 | 186.27 | 24677853.0 |
| 2025-10-24 16:00:00 | NVDA | Stock | 186.26 | 187.21 | 186.1833 | 186.81 | 11150185.0 |
| 2025-10-24 17:00:00 | NVDA | Stock | 186.8 | 186.83 | 186.45 | 186.59 | 165804.0 |
| 2025-10-24 18:00:00 | NVDA | Stock | 186.57 | 186.58 | 186.3 | 186.37 | 105386.0 |
| 2025-10-24 19:00:00 | NVDA | Stock | 186.36 | 186.5 | 186.32 | 186.45 | 202293.0 |
| 2025-10-24 04:00:00 | AMZN | Stock | 221.3 | 221.3 | 220.65 | 220.9 | 18031.0 |
| 2025-10-24 05:00:00 | AMZN | Stock | 221.05 | 221.26 | 220.83 | 221.03 | 14041.0 |
> showing 50 of 63,845 rows — these rows as CSV