PREVIEW / stock_1hour / 2024-07-05
file: by_date/stock_1hour/2024/2024-07-05.parquet size: 1.3 MB rows: 57,694 symbols: 874
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-07-05 04:00:00 | AAPL | Stock | 221.86 | 221.86 | 221.31 | 221.31 | 13989.0 |
| 2024-07-05 05:00:00 | AAPL | Stock | 221.34 | 221.69 | 221.34 | 221.5 | 2556.0 |
| 2024-07-05 06:00:00 | AAPL | Stock | 221.46 | 221.46 | 221.3 | 221.46 | 4133.0 |
| 2024-07-05 07:00:00 | AAPL | Stock | 221.38 | 221.73 | 221.1 | 221.73 | 27688.0 |
| 2024-07-05 08:00:00 | AAPL | Stock | 221.15 | 221.99 | 220.8 | 221.3 | 129623.0 |
| 2024-07-05 09:00:00 | AAPL | Stock | 221.4628 | 224.54 | 221.2 | 224.1052 | 8006128.0 |
| 2024-07-05 10:00:00 | AAPL | Stock | 224.11 | 225.44 | 223.83 | 224.26 | 9527420.0 |
| 2024-07-05 11:00:00 | AAPL | Stock | 224.25 | 225.4191 | 224.155 | 225.3 | 4530930.0 |
| 2024-07-05 12:00:00 | AAPL | Stock | 225.3 | 225.42 | 224.73 | 225.07 | 3389612.0 |
| 2024-07-05 13:00:00 | AAPL | Stock | 225.065 | 225.64 | 224.89 | 225.135 | 3799881.0 |
| 2024-07-05 14:00:00 | AAPL | Stock | 225.1399 | 225.54 | 224.98 | 225.23 | 2994768.0 |
| 2024-07-05 15:00:00 | AAPL | Stock | 225.23 | 226.45 | 225.22 | 226.32 | 8212575.0 |
| 2024-07-05 16:00:00 | AAPL | Stock | 226.32 | 226.85 | 226.2 | 226.2 | 9128867.0 |
| 2024-07-05 17:00:00 | AAPL | Stock | 226.2 | 226.46 | 226.2 | 226.3116 | 28793.0 |
| 2024-07-05 18:00:00 | AAPL | Stock | 226.32 | 226.39 | 226.3 | 226.35 | 16020.0 |
| 2024-07-05 19:00:00 | AAPL | Stock | 226.35 | 226.51 | 226.31 | 226.5092 | 48653.0 |
| 2024-07-05 04:00:00 | MSFT | Stock | 461.72 | 461.8 | 460.76 | 461.26 | 2853.0 |
| 2024-07-05 05:00:00 | MSFT | Stock | 461.0 | 461.1 | 461.0 | 461.1 | 1170.0 |
| 2024-07-05 06:00:00 | MSFT | Stock | 461.07 | 461.47 | 461.0 | 461.45 | 3890.0 |
| 2024-07-05 07:00:00 | MSFT | Stock | 461.25 | 461.3 | 460.95 | 460.95 | 1357.0 |
| 2024-07-05 08:00:00 | MSFT | Stock | 461.02 | 463.0 | 459.6 | 460.6 | 22089.0 |
| 2024-07-05 09:00:00 | MSFT | Stock | 460.5 | 466.04 | 458.965 | 466.04 | 1572236.0 |
| 2024-07-05 10:00:00 | MSFT | Stock | 466.05 | 467.07 | 464.6 | 464.7299 | 1384205.0 |
| 2024-07-05 11:00:00 | MSFT | Stock | 464.75 | 466.77 | 464.17 | 466.455 | 985091.0 |
| 2024-07-05 12:00:00 | MSFT | Stock | 466.49 | 467.03 | 466.19 | 466.48 | 672671.0 |
| 2024-07-05 13:00:00 | MSFT | Stock | 466.42 | 468.35 | 466.39 | 467.04 | 727869.0 |
| 2024-07-05 14:00:00 | MSFT | Stock | 467.05 | 467.5 | 466.75 | 467.16 | 509263.0 |
| 2024-07-05 15:00:00 | MSFT | Stock | 467.117 | 467.98 | 466.97 | 467.39 | 1077089.0 |
| 2024-07-05 16:00:00 | MSFT | Stock | 467.56 | 467.56 | 466.0 | 467.33 | 3560544.0 |
| 2024-07-05 17:00:00 | MSFT | Stock | 467.0869 | 467.5 | 467.0869 | 467.5 | 15202.0 |
| 2024-07-05 18:00:00 | MSFT | Stock | 467.47 | 467.5 | 467.0758 | 467.5 | 11858.0 |
| 2024-07-05 19:00:00 | MSFT | Stock | 467.4101 | 467.48 | 467.2267 | 467.48 | 4950.0 |
| 2024-07-05 04:00:00 | NVDA | Stock | 128.4 | 129.2 | 127.12 | 128.09 | 639863.0 |
| 2024-07-05 05:00:00 | NVDA | Stock | 128.06 | 128.17 | 127.57 | 127.63 | 247722.0 |
| 2024-07-05 06:00:00 | NVDA | Stock | 127.62 | 128.49 | 127.57 | 128.07 | 250711.0 |
| 2024-07-05 07:00:00 | NVDA | Stock | 128.07 | 128.62 | 127.69 | 128.37 | 945783.0 |
| 2024-07-05 08:00:00 | NVDA | Stock | 127.94 | 128.74 | 127.01 | 127.26 | 3780563.0 |
| 2024-07-05 09:00:00 | NVDA | Stock | 127.26 | 128.85 | 125.68 | 127.34 | 37951286.0 |
| 2024-07-05 10:00:00 | NVDA | Stock | 127.315 | 127.64 | 126.19 | 126.625 | 29594071.0 |
| 2024-07-05 11:00:00 | NVDA | Stock | 126.63 | 127.33 | 126.21 | 127.24 | 19756260.0 |
| 2024-07-05 12:00:00 | NVDA | Stock | 127.2499 | 128.4696 | 127.14 | 127.3001 | 22617150.0 |
| 2024-07-05 13:00:00 | NVDA | Stock | 127.3011 | 127.74 | 126.8705 | 127.6696 | 14407081.0 |
| 2024-07-05 14:00:00 | NVDA | Stock | 127.67 | 127.73 | 126.69 | 127.1 | 14829702.0 |
| 2024-07-05 15:00:00 | NVDA | Stock | 127.1 | 127.24 | 125.79 | 125.81 | 22212589.0 |
| 2024-07-05 16:00:00 | NVDA | Stock | 125.82 | 126.6407 | 125.49 | 125.94 | 18359561.0 |
| 2024-07-05 17:00:00 | NVDA | Stock | 125.9359 | 126.0 | 125.67 | 125.69 | 426854.0 |
| 2024-07-05 18:00:00 | NVDA | Stock | 125.69 | 125.7 | 125.46 | 125.51 | 351502.0 |
| 2024-07-05 19:00:00 | NVDA | Stock | 125.49 | 125.5 | 125.1 | 125.38 | 499928.0 |
| 2024-07-05 04:00:00 | AMZN | Stock | 198.0 | 198.2 | 197.65 | 198.0 | 13759.0 |
| 2024-07-05 05:00:00 | AMZN | Stock | 198.0 | 198.1 | 197.95 | 198.03 | 3823.0 |
> showing 50 of 57,694 rows — these rows as CSV