PREVIEW / stock_1hour / 2024-09-17
file: by_date/stock_1hour/2024/2024-09-17.parquet size: 1.3 MB rows: 58,466 symbols: 799
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 |
|---|---|---|---|---|---|---|---|
| 2024-09-17 04:00:00 | AAPL | Stock | 216.37 | 216.99 | 216.22 | 216.52 | 21758.0 |
| 2024-09-17 05:00:00 | AAPL | Stock | 216.62 | 216.97 | 216.6 | 216.89 | 6079.0 |
| 2024-09-17 06:00:00 | AAPL | Stock | 216.85 | 216.92 | 216.65 | 216.65 | 7915.0 |
| 2024-09-17 07:00:00 | AAPL | Stock | 216.6 | 216.7 | 215.02 | 216.26 | 98913.0 |
| 2024-09-17 08:00:00 | AAPL | Stock | 216.53 | 216.7 | 215.1494 | 216.07 | 172260.0 |
| 2024-09-17 09:00:00 | AAPL | Stock | 216.1 | 216.5899 | 214.5 | 216.22 | 6023031.0 |
| 2024-09-17 10:00:00 | AAPL | Stock | 216.24 | 216.9 | 215.53 | 216.1299 | 5024367.0 |
| 2024-09-17 11:00:00 | AAPL | Stock | 216.105 | 216.84 | 215.96 | 216.6 | 2770833.0 |
| 2024-09-17 12:00:00 | AAPL | Stock | 216.6 | 216.63 | 215.23 | 215.795 | 3789137.0 |
| 2024-09-17 13:00:00 | AAPL | Stock | 215.81 | 216.39 | 215.05 | 216.1301 | 2299366.0 |
| 2024-09-17 14:00:00 | AAPL | Stock | 216.14 | 216.39 | 215.3 | 215.84 | 2104389.0 |
| 2024-09-17 15:00:00 | AAPL | Stock | 215.84 | 216.85 | 215.7201 | 216.85 | 5212681.0 |
| 2024-09-17 16:00:00 | AAPL | Stock | 216.79 | 216.84 | 216.5625 | 216.6205 | 5606280.0 |
| 2024-09-17 17:00:00 | AAPL | Stock | 216.62 | 216.65 | 216.1 | 216.595 | 13163.0 |
| 2024-09-17 18:00:00 | AAPL | Stock | 216.56 | 216.7 | 216.5022 | 216.6 | 12454.0 |
| 2024-09-17 19:00:00 | AAPL | Stock | 216.595 | 216.9 | 216.595 | 216.9 | 21158.0 |
| 2024-09-17 04:00:00 | MSFT | Stock | 436.1 | 438.3 | 436.1 | 438.16 | 13274.0 |
| 2024-09-17 05:00:00 | MSFT | Stock | 438.74 | 439.9 | 438.65 | 439.48 | 18919.0 |
| 2024-09-17 06:00:00 | MSFT | Stock | 439.49 | 440.33 | 437.25 | 437.25 | 19297.0 |
| 2024-09-17 07:00:00 | MSFT | Stock | 437.12 | 439.5 | 437.12 | 438.7 | 39300.0 |
| 2024-09-17 08:00:00 | MSFT | Stock | 437.81 | 440.31 | 434.24 | 438.4 | 164276.0 |
| 2024-09-17 09:00:00 | MSFT | Stock | 438.51 | 441.85 | 436.812 | 439.11 | 2830135.0 |
| 2024-09-17 10:00:00 | MSFT | Stock | 439.2 | 440.2279 | 436.33 | 436.9 | 1809306.0 |
| 2024-09-17 11:00:00 | MSFT | Stock | 436.94 | 437.465 | 434.63 | 435.98 | 1355027.0 |
| 2024-09-17 12:00:00 | MSFT | Stock | 436.0 | 436.15 | 432.27 | 433.65 | 1159491.0 |
| 2024-09-17 13:00:00 | MSFT | Stock | 433.69 | 435.4 | 433.15 | 435.3 | 867209.0 |
| 2024-09-17 14:00:00 | MSFT | Stock | 435.29 | 435.65 | 434.1201 | 434.71 | 539347.0 |
| 2024-09-17 15:00:00 | MSFT | Stock | 434.695 | 435.22 | 434.0638 | 435.16 | 1276765.0 |
| 2024-09-17 16:00:00 | MSFT | Stock | 435.15 | 436.337 | 435.07 | 435.7 | 3167617.0 |
| 2024-09-17 17:00:00 | MSFT | Stock | 435.85 | 435.94 | 435.15 | 435.45 | 5431.0 |
| 2024-09-17 18:00:00 | MSFT | Stock | 435.4 | 435.6635 | 435.4 | 435.58 | 1581.0 |
| 2024-09-17 19:00:00 | MSFT | Stock | 435.4 | 436.4 | 435.4 | 436.33 | 4779.0 |
| 2024-09-17 04:00:00 | NVDA | Stock | 117.0 | 117.29 | 116.5 | 116.99 | 531712.0 |
| 2024-09-17 05:00:00 | NVDA | Stock | 117.01 | 117.83 | 117.0 | 117.66 | 306967.0 |
| 2024-09-17 06:00:00 | NVDA | Stock | 117.67 | 117.9 | 117.38 | 117.47 | 185587.0 |
| 2024-09-17 07:00:00 | NVDA | Stock | 117.45 | 117.89 | 117.36 | 117.76 | 599245.0 |
| 2024-09-17 08:00:00 | NVDA | Stock | 117.47 | 118.4 | 116.09 | 118.27 | 2869625.0 |
| 2024-09-17 09:00:00 | NVDA | Stock | 118.28 | 118.8 | 116.54 | 117.28 | 34005485.0 |
| 2024-09-17 10:00:00 | NVDA | Stock | 117.32 | 118.2706 | 117.0 | 117.5052 | 34459094.0 |
| 2024-09-17 11:00:00 | NVDA | Stock | 117.52 | 117.75 | 116.92 | 117.325 | 20460799.0 |
| 2024-09-17 12:00:00 | NVDA | Stock | 117.325 | 117.52 | 115.67 | 116.01 | 27465874.0 |
| 2024-09-17 13:00:00 | NVDA | Stock | 116.02 | 116.39 | 114.83 | 115.5199 | 23541030.0 |
| 2024-09-17 14:00:00 | NVDA | Stock | 115.505 | 115.7 | 114.855 | 115.12 | 17570590.0 |
| 2024-09-17 15:00:00 | NVDA | Stock | 115.1201 | 115.65 | 114.98 | 115.585 | 26322991.0 |
| 2024-09-17 16:00:00 | NVDA | Stock | 115.59 | 115.63 | 115.35 | 115.43 | 15272773.0 |
| 2024-09-17 17:00:00 | NVDA | Stock | 115.44 | 115.5 | 115.39 | 115.45 | 225875.0 |
| 2024-09-17 18:00:00 | NVDA | Stock | 115.44 | 115.55 | 115.4 | 115.48 | 231525.0 |
| 2024-09-17 19:00:00 | NVDA | Stock | 115.47 | 115.53 | 115.36 | 115.4476 | 296249.0 |
| 2024-09-17 04:00:00 | AMZN | Stock | 184.55 | 185.66 | 184.55 | 185.66 | 7407.0 |
| 2024-09-17 05:00:00 | AMZN | Stock | 185.78 | 186.27 | 185.78 | 186.27 | 6586.0 |
> showing 50 of 58,466 rows — these rows as CSV