PREVIEW / stock_1hour / 2025-10-09
file: by_date/stock_1hour/2025/2025-10-09.parquet size: 1.5 MB rows: 65,442 symbols: 235
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-09 04:00:00 | AAPL | Stock | 257.07 | 257.65 | 257.01 | 257.65 | 14740.0 |
| 2025-10-09 05:00:00 | AAPL | Stock | 257.62 | 257.86 | 257.51 | 257.61 | 5715.0 |
| 2025-10-09 06:00:00 | AAPL | Stock | 257.6 | 257.7 | 257.15 | 257.25 | 4797.0 |
| 2025-10-09 07:00:00 | AAPL | Stock | 257.44 | 257.87 | 257.37 | 257.37 | 19931.0 |
| 2025-10-09 08:00:00 | AAPL | Stock | 257.4787 | 257.87 | 257.0 | 257.07 | 72278.0 |
| 2025-10-09 09:00:00 | AAPL | Stock | 257.08 | 258.0 | 254.77 | 255.16 | 4353405.0 |
| 2025-10-09 10:00:00 | AAPL | Stock | 255.165 | 255.83 | 254.57 | 254.94 | 3685406.0 |
| 2025-10-09 11:00:00 | AAPL | Stock | 254.95 | 255.223 | 253.81 | 254.1 | 3152669.0 |
| 2025-10-09 12:00:00 | AAPL | Stock | 254.1 | 254.76 | 253.525 | 253.785 | 2341333.0 |
| 2025-10-09 13:00:00 | AAPL | Stock | 253.77 | 253.9 | 253.14 | 253.63 | 1809796.0 |
| 2025-10-09 14:00:00 | AAPL | Stock | 253.625 | 253.86 | 253.32 | 253.8077 | 1659786.0 |
| 2025-10-09 15:00:00 | AAPL | Stock | 253.8 | 254.5 | 253.56 | 254.03 | 4582340.0 |
| 2025-10-09 16:00:00 | AAPL | Stock | 254.02 | 254.23 | 253.74 | 254.0151 | 5755098.0 |
| 2025-10-09 17:00:00 | AAPL | Stock | 254.0 | 254.0885 | 253.8607 | 253.97 | 14729.0 |
| 2025-10-09 18:00:00 | AAPL | Stock | 254.04 | 254.22 | 254.04 | 254.16 | 21091.0 |
| 2025-10-09 19:00:00 | AAPL | Stock | 254.2 | 254.29 | 254.1 | 254.29 | 23615.0 |
| 2025-10-09 04:00:00 | MSFT | Stock | 523.0 | 524.2 | 523.0 | 524.09 | 1241.0 |
| 2025-10-09 05:00:00 | MSFT | Stock | 524.36 | 525.8 | 524.36 | 525.41 | 4266.0 |
| 2025-10-09 06:00:00 | MSFT | Stock | 525.31 | 525.31 | 524.55 | 524.85 | 2036.0 |
| 2025-10-09 07:00:00 | MSFT | Stock | 525.0 | 525.0 | 524.33 | 524.48 | 11196.0 |
| 2025-10-09 08:00:00 | MSFT | Stock | 524.86 | 525.06 | 521.0025 | 523.9 | 52392.0 |
| 2025-10-09 09:00:00 | MSFT | Stock | 524.3 | 524.325 | 519.85 | 521.77 | 1381272.0 |
| 2025-10-09 10:00:00 | MSFT | Stock | 521.81 | 522.67 | 521.16 | 521.705 | 1070914.0 |
| 2025-10-09 11:00:00 | MSFT | Stock | 521.735 | 521.96 | 518.125 | 519.59 | 1403150.0 |
| 2025-10-09 12:00:00 | MSFT | Stock | 519.65 | 520.25 | 517.66 | 518.08 | 979058.0 |
| 2025-10-09 13:00:00 | MSFT | Stock | 518.06 | 519.64 | 518.05 | 519.5389 | 533735.0 |
| 2025-10-09 14:00:00 | MSFT | Stock | 519.54 | 520.365 | 519.25 | 520.18 | 544668.0 |
| 2025-10-09 15:00:00 | MSFT | Stock | 520.19 | 522.48 | 517.4 | 522.24 | 2498330.0 |
| 2025-10-09 16:00:00 | MSFT | Stock | 522.4 | 522.7 | 520.9091 | 521.75 | 2922745.0 |
| 2025-10-09 17:00:00 | MSFT | Stock | 522.0 | 522.23 | 521.758 | 522.1 | 5716.0 |
| 2025-10-09 18:00:00 | MSFT | Stock | 522.27 | 522.41 | 522.1 | 522.41 | 3835.0 |
| 2025-10-09 19:00:00 | MSFT | Stock | 522.41 | 522.9 | 522.21 | 522.9 | 6744.0 |
| 2025-10-09 04:00:00 | NVDA | Stock | 191.25 | 192.0 | 190.33 | 190.44 | 459182.0 |
| 2025-10-09 05:00:00 | NVDA | Stock | 190.37 | 190.93 | 190.2 | 190.74 | 179526.0 |
| 2025-10-09 06:00:00 | NVDA | Stock | 190.73 | 192.05 | 190.67 | 191.36 | 502483.0 |
| 2025-10-09 07:00:00 | NVDA | Stock | 191.33 | 192.49 | 191.0 | 192.3 | 959408.0 |
| 2025-10-09 08:00:00 | NVDA | Stock | 191.19 | 193.0 | 190.18 | 192.84 | 3431562.0 |
| 2025-10-09 09:00:00 | NVDA | Stock | 192.82 | 195.3 | 191.06 | 194.4 | 36516326.0 |
| 2025-10-09 10:00:00 | NVDA | Stock | 194.38 | 194.59 | 192.185 | 194.075 | 26177056.0 |
| 2025-10-09 11:00:00 | NVDA | Stock | 194.08 | 194.72 | 193.365 | 194.18 | 17202310.0 |
| 2025-10-09 12:00:00 | NVDA | Stock | 194.17 | 194.58 | 192.7 | 192.75 | 12286660.0 |
| 2025-10-09 13:00:00 | NVDA | Stock | 192.73 | 193.28 | 192.27 | 193.005 | 10980869.0 |
| 2025-10-09 14:00:00 | NVDA | Stock | 193.005 | 193.17 | 192.13 | 192.56 | 10575213.0 |
| 2025-10-09 15:00:00 | NVDA | Stock | 192.56 | 193.54 | 191.61 | 192.54 | 15754297.0 |
| 2025-10-09 16:00:00 | NVDA | Stock | 192.57 | 193.27 | 192.04 | 192.26 | 9905399.0 |
| 2025-10-09 17:00:00 | NVDA | Stock | 192.31 | 192.33 | 192.07 | 192.27 | 301124.0 |
| 2025-10-09 18:00:00 | NVDA | Stock | 192.27 | 192.78 | 192.24 | 192.7 | 290402.0 |
| 2025-10-09 19:00:00 | NVDA | Stock | 192.72 | 192.9 | 192.7 | 192.8994 | 186672.0 |
| 2025-10-09 04:00:00 | AMZN | Stock | 225.46 | 225.64 | 222.69 | 223.36 | 54519.0 |
| 2025-10-09 05:00:00 | AMZN | Stock | 223.38 | 224.59 | 223.29 | 224.51 | 22612.0 |
> showing 50 of 65,442 rows — these rows as CSV