PREVIEW / stock_1hour / 2025-04-21
file: by_date/stock_1hour/2025/2025-04-21.parquet size: 1.4 MB rows: 61,697 symbols: 429
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-04-21 04:00:00 | AAPL | Stock | 195.93 | 195.93 | 193.8 | 194.0 | 31165.0 |
| 2025-04-21 05:00:00 | AAPL | Stock | 193.94 | 194.45 | 193.4 | 194.45 | 16686.0 |
| 2025-04-21 06:00:00 | AAPL | Stock | 194.45 | 194.5 | 193.99 | 194.0 | 15441.0 |
| 2025-04-21 07:00:00 | AAPL | Stock | 194.29 | 194.45 | 191.75 | 191.94 | 83521.0 |
| 2025-04-21 08:00:00 | AAPL | Stock | 193.42 | 195.78 | 191.7 | 191.96 | 131752.0 |
| 2025-04-21 09:00:00 | AAPL | Stock | 191.9 | 193.8 | 191.52 | 192.4995 | 3744692.0 |
| 2025-04-21 10:00:00 | AAPL | Stock | 192.45 | 192.65 | 191.27 | 191.495 | 4247309.0 |
| 2025-04-21 11:00:00 | AAPL | Stock | 191.5 | 191.99 | 189.8112 | 190.25 | 3792390.0 |
| 2025-04-21 12:00:00 | AAPL | Stock | 190.24 | 191.75 | 190.23 | 190.765 | 2233044.0 |
| 2025-04-21 13:00:00 | AAPL | Stock | 190.765 | 191.02 | 190.13 | 190.51 | 2380832.0 |
| 2025-04-21 14:00:00 | AAPL | Stock | 190.51 | 191.14 | 190.18 | 190.27 | 2059229.0 |
| 2025-04-21 15:00:00 | AAPL | Stock | 190.27 | 193.43 | 190.24 | 193.09 | 5172616.0 |
| 2025-04-21 16:00:00 | AAPL | Stock | 193.03 | 193.38 | 191.5 | 193.1 | 8238871.0 |
| 2025-04-21 17:00:00 | AAPL | Stock | 193.09 | 193.16 | 192.61 | 192.85 | 20726.0 |
| 2025-04-21 18:00:00 | AAPL | Stock | 192.97 | 192.99 | 192.52 | 192.94 | 16164.0 |
| 2025-04-21 19:00:00 | AAPL | Stock | 192.644 | 194.0 | 192.56 | 194.0 | 42748.0 |
| 2025-04-21 04:00:00 | MSFT | Stock | 363.9 | 365.72 | 363.9 | 364.1 | 1998.0 |
| 2025-04-21 06:00:00 | MSFT | Stock | 364.1 | 365.5 | 364.1 | 365.5 | 2024.0 |
| 2025-04-21 07:00:00 | MSFT | Stock | 365.73 | 366.5 | 363.4 | 363.94 | 6513.0 |
| 2025-04-21 08:00:00 | MSFT | Stock | 366.0 | 369.067 | 363.5 | 364.13 | 17074.0 |
| 2025-04-21 09:00:00 | MSFT | Stock | 364.49 | 364.49 | 361.02 | 361.03 | 1192379.0 |
| 2025-04-21 10:00:00 | MSFT | Stock | 361.01 | 361.53 | 359.56 | 360.085 | 1614951.0 |
| 2025-04-21 11:00:00 | MSFT | Stock | 360.0925 | 361.33 | 357.75 | 358.23 | 1686338.0 |
| 2025-04-21 12:00:00 | MSFT | Stock | 358.235 | 359.69 | 357.9501 | 358.8 | 890722.0 |
| 2025-04-21 13:00:00 | MSFT | Stock | 358.82 | 359.33 | 357.27 | 357.3872 | 1011141.0 |
| 2025-04-21 14:00:00 | MSFT | Stock | 357.38 | 357.84 | 355.67 | 355.97 | 795126.0 |
| 2025-04-21 15:00:00 | MSFT | Stock | 355.9575 | 359.75 | 355.86 | 359.14 | 2175697.0 |
| 2025-04-21 16:00:00 | MSFT | Stock | 359.17 | 359.6 | 358.5073 | 358.9 | 4266748.0 |
| 2025-04-21 17:00:00 | MSFT | Stock | 358.77 | 359.25 | 358.77 | 359.02 | 2418.0 |
| 2025-04-21 18:00:00 | MSFT | Stock | 359.1 | 359.12 | 358.55 | 359.0 | 1811.0 |
| 2025-04-21 19:00:00 | MSFT | Stock | 358.9 | 361.12 | 358.9 | 361.12 | 3079.0 |
| 2025-04-21 04:00:00 | NVDA | Stock | 99.9 | 100.49 | 99.07 | 99.3 | 649916.0 |
| 2025-04-21 05:00:00 | NVDA | Stock | 99.3 | 99.44 | 98.77 | 99.06 | 559188.0 |
| 2025-04-21 06:00:00 | NVDA | Stock | 99.05 | 99.16 | 97.69 | 98.47 | 1056742.0 |
| 2025-04-21 07:00:00 | NVDA | Stock | 98.48 | 99.58 | 97.67 | 97.911 | 1595917.0 |
| 2025-04-21 08:00:00 | NVDA | Stock | 99.2 | 101.135 | 97.68 | 98.2499 | 2411091.0 |
| 2025-04-21 09:00:00 | NVDA | Stock | 98.2306 | 99.44 | 96.8 | 96.84 | 37875711.0 |
| 2025-04-21 10:00:00 | NVDA | Stock | 96.84 | 97.05 | 95.57 | 96.365 | 43966571.0 |
| 2025-04-21 11:00:00 | NVDA | Stock | 96.365 | 96.57 | 95.74 | 95.8374 | 22082411.0 |
| 2025-04-21 12:00:00 | NVDA | Stock | 95.83 | 96.39 | 95.68 | 95.7119 | 18999765.0 |
| 2025-04-21 13:00:00 | NVDA | Stock | 95.715 | 95.85 | 95.05 | 95.165 | 19526517.0 |
| 2025-04-21 14:00:00 | NVDA | Stock | 95.17 | 95.8099 | 95.04 | 95.295 | 17451639.0 |
| 2025-04-21 15:00:00 | NVDA | Stock | 95.295 | 97.2 | 95.205 | 96.8 | 37439270.0 |
| 2025-04-21 16:00:00 | NVDA | Stock | 96.8 | 97.06 | 96.2 | 96.2399 | 26706395.0 |
| 2025-04-21 17:00:00 | NVDA | Stock | 96.24 | 96.44 | 96.22 | 96.31 | 424281.0 |
| 2025-04-21 18:00:00 | NVDA | Stock | 96.34 | 96.38 | 95.9 | 96.03 | 640693.0 |
| 2025-04-21 19:00:00 | NVDA | Stock | 96.05 | 96.65 | 95.9913 | 96.65 | 565512.0 |
| 2025-04-21 04:00:00 | AMZN | Stock | 172.5 | 172.5 | 170.53 | 170.81 | 9973.0 |
| 2025-04-21 05:00:00 | AMZN | Stock | 171.02 | 171.02 | 170.6 | 170.9 | 4108.0 |
| 2025-04-21 06:00:00 | AMZN | Stock | 171.12 | 171.12 | 169.69 | 170.01 | 47956.0 |
> showing 50 of 61,697 rows — these rows as CSV