PREVIEW / stock_1hour / 2024-10-22
file: by_date/stock_1hour/2024/2024-10-22.parquet size: 1.4 MB rows: 60,257 symbols: 734
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-10-22 04:00:00 | AAPL | Stock | 235.61 | 235.97 | 235.41 | 235.61 | 10030.0 |
| 2024-10-22 05:00:00 | AAPL | Stock | 235.6 | 235.61 | 234.88 | 234.91 | 20020.0 |
| 2024-10-22 06:00:00 | AAPL | Stock | 234.88 | 235.09 | 234.83 | 234.89 | 10458.0 |
| 2024-10-22 07:00:00 | AAPL | Stock | 234.96 | 235.39 | 234.86 | 234.9 | 51692.0 |
| 2024-10-22 08:00:00 | AAPL | Stock | 235.1 | 236.01 | 233.7 | 234.1801 | 255563.0 |
| 2024-10-22 09:00:00 | AAPL | Stock | 234.2001 | 234.24 | 232.6 | 233.16 | 4529873.0 |
| 2024-10-22 10:00:00 | AAPL | Stock | 233.1646 | 234.29 | 233.0 | 234.225 | 3398065.0 |
| 2024-10-22 11:00:00 | AAPL | Stock | 234.23 | 234.9099 | 233.95 | 234.4903 | 1884986.0 |
| 2024-10-22 12:00:00 | AAPL | Stock | 234.495 | 234.94 | 234.13 | 234.94 | 1443527.0 |
| 2024-10-22 13:00:00 | AAPL | Stock | 234.935 | 235.7499 | 234.74 | 235.68 | 2227352.0 |
| 2024-10-22 14:00:00 | AAPL | Stock | 235.675 | 236.01 | 235.18 | 235.37 | 1737233.0 |
| 2024-10-22 15:00:00 | AAPL | Stock | 235.37 | 236.22 | 235.26 | 235.86 | 2875660.0 |
| 2024-10-22 16:00:00 | AAPL | Stock | 235.83 | 236.08 | 235.6 | 235.89 | 6107386.0 |
| 2024-10-22 17:00:00 | AAPL | Stock | 235.9 | 235.95 | 235.6998 | 235.7 | 272277.0 |
| 2024-10-22 18:00:00 | AAPL | Stock | 235.66 | 235.79 | 235.25 | 235.45 | 17046.0 |
| 2024-10-22 19:00:00 | AAPL | Stock | 235.45 | 235.78 | 235.45 | 235.6 | 5590.0 |
| 2024-10-22 04:00:00 | MSFT | Stock | 418.0 | 418.3 | 417.59 | 417.67 | 3054.0 |
| 2024-10-22 05:00:00 | MSFT | Stock | 417.42 | 417.42 | 416.41 | 416.41 | 1653.0 |
| 2024-10-22 06:00:00 | MSFT | Stock | 416.6 | 417.7 | 416.6 | 416.98 | 2971.0 |
| 2024-10-22 07:00:00 | MSFT | Stock | 417.25 | 418.78 | 417.25 | 418.15 | 11095.0 |
| 2024-10-22 08:00:00 | MSFT | Stock | 417.99 | 419.33 | 417.2 | 419.0 | 37357.0 |
| 2024-10-22 09:00:00 | MSFT | Stock | 419.0 | 426.64 | 417.5 | 426.33 | 2716793.0 |
| 2024-10-22 10:00:00 | MSFT | Stock | 426.31 | 429.42 | 425.34 | 427.0475 | 3497362.0 |
| 2024-10-22 11:00:00 | MSFT | Stock | 427.08 | 427.54 | 426.05 | 426.835 | 1130900.0 |
| 2024-10-22 12:00:00 | MSFT | Stock | 426.81 | 427.73 | 425.73 | 427.52 | 827198.0 |
| 2024-10-22 13:00:00 | MSFT | Stock | 427.54 | 429.38 | 427.08 | 429.3201 | 750098.0 |
| 2024-10-22 14:00:00 | MSFT | Stock | 429.32 | 430.5793 | 428.65 | 428.93 | 1177048.0 |
| 2024-10-22 15:00:00 | MSFT | Stock | 428.9 | 429.905 | 427.4 | 427.46 | 1855244.0 |
| 2024-10-22 16:00:00 | MSFT | Stock | 427.51 | 427.785 | 427.2301 | 427.35 | 4271679.0 |
| 2024-10-22 17:00:00 | MSFT | Stock | 427.3 | 427.51 | 426.85 | 426.94 | 14701.0 |
| 2024-10-22 18:00:00 | MSFT | Stock | 426.8041 | 427.2 | 426.1975 | 427.2 | 8213.0 |
| 2024-10-22 19:00:00 | MSFT | Stock | 426.9 | 427.25 | 426.73 | 426.74 | 7728.0 |
| 2024-10-22 04:00:00 | NVDA | Stock | 143.1 | 143.98 | 142.83 | 142.97 | 498734.0 |
| 2024-10-22 05:00:00 | NVDA | Stock | 142.92 | 143.4 | 142.66 | 143.16 | 550463.0 |
| 2024-10-22 06:00:00 | NVDA | Stock | 143.15 | 143.32 | 142.91 | 143.19 | 290073.0 |
| 2024-10-22 07:00:00 | NVDA | Stock | 143.2 | 144.12 | 143.16 | 143.99 | 1602986.0 |
| 2024-10-22 08:00:00 | NVDA | Stock | 143.3 | 144.37 | 142.52 | 143.53 | 3981372.0 |
| 2024-10-22 09:00:00 | NVDA | Stock | 143.52 | 144.18 | 141.78 | 143.34 | 41643329.0 |
| 2024-10-22 10:00:00 | NVDA | Stock | 143.3391 | 144.42 | 142.33 | 143.255 | 39589190.0 |
| 2024-10-22 11:00:00 | NVDA | Stock | 143.27 | 143.7 | 142.8 | 143.27 | 19363193.0 |
| 2024-10-22 12:00:00 | NVDA | Stock | 143.26 | 143.29 | 141.96 | 142.825 | 19838249.0 |
| 2024-10-22 13:00:00 | NVDA | Stock | 142.82 | 143.96 | 142.71 | 143.825 | 18780086.0 |
| 2024-10-22 14:00:00 | NVDA | Stock | 143.8207 | 144.0599 | 143.1115 | 143.305 | 16716311.0 |
| 2024-10-22 15:00:00 | NVDA | Stock | 143.3 | 143.86 | 143.21 | 143.57 | 19685080.0 |
| 2024-10-22 16:00:00 | NVDA | Stock | 143.57 | 143.62 | 143.12 | 143.56 | 16168832.0 |
| 2024-10-22 17:00:00 | NVDA | Stock | 143.56 | 143.59 | 143.24 | 143.34 | 2281292.0 |
| 2024-10-22 18:00:00 | NVDA | Stock | 143.33 | 143.37 | 143.1 | 143.2 | 296548.0 |
| 2024-10-22 19:00:00 | NVDA | Stock | 143.18 | 143.47 | 143.18 | 143.33 | 321853.0 |
| 2024-10-22 04:00:00 | AMZN | Stock | 188.55 | 188.6 | 188.19 | 188.39 | 4016.0 |
| 2024-10-22 05:00:00 | AMZN | Stock | 188.3 | 188.3 | 187.62 | 187.86 | 10629.0 |
> showing 50 of 60,257 rows — these rows as CSV