PREVIEW / stock_1hour / 2025-05-09
file: by_date/stock_1hour/2025/2025-05-09.parquet size: 1.4 MB rows: 60,384 symbols: 424
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-05-09 04:00:00 | AAPL | Stock | 197.71 | 198.34 | 197.71 | 197.94 | 23363.0 |
| 2025-05-09 05:00:00 | AAPL | Stock | 198.03 | 198.33 | 198.03 | 198.33 | 9971.0 |
| 2025-05-09 06:00:00 | AAPL | Stock | 198.36 | 198.72 | 198.32 | 198.61 | 14731.0 |
| 2025-05-09 07:00:00 | AAPL | Stock | 198.48 | 198.87 | 197.0 | 198.05 | 77017.0 |
| 2025-05-09 08:00:00 | AAPL | Stock | 198.68 | 198.7 | 197.13 | 198.59 | 101301.0 |
| 2025-05-09 09:00:00 | AAPL | Stock | 198.6001 | 200.5399 | 198.395 | 199.75 | 3816345.0 |
| 2025-05-09 10:00:00 | AAPL | Stock | 199.75 | 200.24 | 197.535 | 198.38 | 4641857.0 |
| 2025-05-09 11:00:00 | AAPL | Stock | 198.38 | 199.18 | 198.14 | 198.7585 | 2710236.0 |
| 2025-05-09 12:00:00 | AAPL | Stock | 198.72 | 198.7597 | 197.75 | 197.97 | 2237312.0 |
| 2025-05-09 13:00:00 | AAPL | Stock | 197.96 | 198.815 | 197.6 | 198.7057 | 2233673.0 |
| 2025-05-09 14:00:00 | AAPL | Stock | 198.71 | 199.14 | 198.47 | 198.93 | 1913477.0 |
| 2025-05-09 15:00:00 | AAPL | Stock | 198.93 | 199.43 | 198.3401 | 198.54 | 4190613.0 |
| 2025-05-09 16:00:00 | AAPL | Stock | 198.47 | 198.65 | 198.23 | 198.64 | 4727719.0 |
| 2025-05-09 17:00:00 | AAPL | Stock | 198.6 | 198.7 | 198.376 | 198.53 | 23467.0 |
| 2025-05-09 18:00:00 | AAPL | Stock | 198.5 | 198.59 | 198.5 | 198.55 | 7979.0 |
| 2025-05-09 19:00:00 | AAPL | Stock | 198.55 | 198.59 | 198.51 | 198.5244 | 22046.0 |
| 2025-05-09 04:00:00 | MSFT | Stock | 438.69 | 439.71 | 438.66 | 438.66 | 12919.0 |
| 2025-05-09 05:00:00 | MSFT | Stock | 438.85 | 438.85 | 438.58 | 438.61 | 852.0 |
| 2025-05-09 06:00:00 | MSFT | Stock | 438.82 | 439.54 | 438.82 | 439.16 | 2037.0 |
| 2025-05-09 07:00:00 | MSFT | Stock | 439.15 | 440.25 | 437.89 | 438.62 | 25784.0 |
| 2025-05-09 08:00:00 | MSFT | Stock | 439.25 | 439.88 | 438.16 | 439.4018 | 45349.0 |
| 2025-05-09 09:00:00 | MSFT | Stock | 439.9966 | 440.74 | 437.7691 | 439.1 | 925813.0 |
| 2025-05-09 10:00:00 | MSFT | Stock | 439.095 | 439.24 | 436.24 | 437.475 | 953653.0 |
| 2025-05-09 11:00:00 | MSFT | Stock | 437.42 | 437.93 | 436.465 | 437.75 | 710783.0 |
| 2025-05-09 12:00:00 | MSFT | Stock | 437.72 | 437.75 | 435.88 | 436.82 | 512511.0 |
| 2025-05-09 13:00:00 | MSFT | Stock | 436.805 | 438.0 | 436.13 | 437.91 | 541684.0 |
| 2025-05-09 14:00:00 | MSFT | Stock | 437.9 | 439.11 | 437.38 | 438.765 | 725429.0 |
| 2025-05-09 15:00:00 | MSFT | Stock | 438.81 | 439.72 | 438.43 | 438.85 | 1350799.0 |
| 2025-05-09 16:00:00 | MSFT | Stock | 438.73 | 439.03 | 438.13 | 438.4 | 2255917.0 |
| 2025-05-09 17:00:00 | MSFT | Stock | 438.1603 | 438.73 | 438.1264 | 438.144 | 889.0 |
| 2025-05-09 18:00:00 | MSFT | Stock | 438.14 | 438.3497 | 438.14 | 438.3497 | 3699.0 |
| 2025-05-09 19:00:00 | MSFT | Stock | 438.35 | 438.5923 | 438.28 | 438.28 | 2883.0 |
| 2025-05-09 04:00:00 | NVDA | Stock | 118.0 | 118.2 | 117.64 | 117.8 | 262104.0 |
| 2025-05-09 05:00:00 | NVDA | Stock | 117.79 | 118.1 | 117.79 | 118.05 | 106321.0 |
| 2025-05-09 06:00:00 | NVDA | Stock | 118.05 | 118.19 | 117.95 | 117.98 | 135690.0 |
| 2025-05-09 07:00:00 | NVDA | Stock | 117.98 | 118.19 | 117.23 | 117.55 | 751458.0 |
| 2025-05-09 08:00:00 | NVDA | Stock | 118.03 | 118.2 | 117.23 | 117.7695 | 1584487.0 |
| 2025-05-09 09:00:00 | NVDA | Stock | 117.77 | 118.23 | 117.13 | 117.75 | 18012736.0 |
| 2025-05-09 10:00:00 | NVDA | Stock | 117.74 | 117.88 | 115.21 | 116.275 | 30855015.0 |
| 2025-05-09 11:00:00 | NVDA | Stock | 116.27 | 116.77 | 116.01 | 116.72 | 14582420.0 |
| 2025-05-09 12:00:00 | NVDA | Stock | 116.72 | 116.7599 | 115.98 | 116.345 | 9131993.0 |
| 2025-05-09 13:00:00 | NVDA | Stock | 116.35 | 116.81 | 116.11 | 116.77 | 8785707.0 |
| 2025-05-09 14:00:00 | NVDA | Stock | 116.76 | 116.92 | 116.5 | 116.6124 | 6851577.0 |
| 2025-05-09 15:00:00 | NVDA | Stock | 116.61 | 116.865 | 116.43 | 116.61 | 14687498.0 |
| 2025-05-09 16:00:00 | NVDA | Stock | 116.61 | 116.65 | 116.33 | 116.4 | 8423423.0 |
| 2025-05-09 17:00:00 | NVDA | Stock | 116.4 | 116.43 | 116.3 | 116.39 | 146927.0 |
| 2025-05-09 18:00:00 | NVDA | Stock | 116.37 | 116.41 | 116.33 | 116.35 | 80504.0 |
| 2025-05-09 19:00:00 | NVDA | Stock | 116.37 | 116.4 | 116.34 | 116.3898 | 178854.0 |
| 2025-05-09 04:00:00 | AMZN | Stock | 192.79 | 193.0 | 192.4 | 192.7 | 43456.0 |
| 2025-05-09 05:00:00 | AMZN | Stock | 192.7 | 192.93 | 192.7 | 192.89 | 6667.0 |
> showing 50 of 60,384 rows — these rows as CSV