PREVIEW / stock_1hour / 2024-01-08
file: by_date/stock_1hour/2024/2024-01-08.parquet size: 1.4 MB rows: 59,978 symbols: 1,181
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-01-08 04:00:00 | AAPL | Stock | 180.81 | 180.81 | 179.96 | 180.55 | 36385.0 |
| 2024-01-08 05:00:00 | AAPL | Stock | 180.59 | 180.73 | 180.22 | 180.43 | 20666.0 |
| 2024-01-08 06:00:00 | AAPL | Stock | 180.4 | 181.64 | 180.34 | 181.64 | 36022.0 |
| 2024-01-08 07:00:00 | AAPL | Stock | 181.62 | 181.91 | 180.85 | 181.91 | 79128.0 |
| 2024-01-08 08:00:00 | AAPL | Stock | 181.15 | 181.9 | 179.68 | 181.37 | 167224.0 |
| 2024-01-08 09:00:00 | AAPL | Stock | 181.3996 | 183.505 | 181.3996 | 183.4141 | 7337184.0 |
| 2024-01-08 10:00:00 | AAPL | Stock | 183.41 | 183.885 | 183.3 | 183.585 | 5517308.0 |
| 2024-01-08 11:00:00 | AAPL | Stock | 183.59 | 183.85 | 183.21 | 183.835 | 3835295.0 |
| 2024-01-08 12:00:00 | AAPL | Stock | 183.84 | 184.57 | 183.83 | 184.2546 | 4310692.0 |
| 2024-01-08 13:00:00 | AAPL | Stock | 184.251 | 184.72 | 184.01 | 184.7101 | 2571904.0 |
| 2024-01-08 14:00:00 | AAPL | Stock | 184.72 | 185.321 | 184.55 | 185.1714 | 3937675.0 |
| 2024-01-08 15:00:00 | AAPL | Stock | 185.1777 | 185.6 | 184.91 | 185.55 | 8113087.0 |
| 2024-01-08 16:00:00 | AAPL | Stock | 185.56 | 185.59 | 185.31 | 185.46 | 12403528.0 |
| 2024-01-08 17:00:00 | AAPL | Stock | 185.44 | 185.56 | 185.2 | 185.25 | 60128.0 |
| 2024-01-08 18:00:00 | AAPL | Stock | 185.25 | 185.35 | 185.15 | 185.34 | 17363.0 |
| 2024-01-08 19:00:00 | AAPL | Stock | 185.31 | 185.39 | 185.08 | 185.22 | 23180.0 |
| 2024-01-08 04:00:00 | MSFT | Stock | 367.99 | 367.99 | 366.75 | 367.5 | 4014.0 |
| 2024-01-08 05:00:00 | MSFT | Stock | 367.74 | 368.52 | 367.74 | 368.52 | 893.0 |
| 2024-01-08 06:00:00 | MSFT | Stock | 368.47 | 369.22 | 368.47 | 369.0 | 2371.0 |
| 2024-01-08 07:00:00 | MSFT | Stock | 369.01 | 369.16 | 368.4 | 368.96 | 9134.0 |
| 2024-01-08 08:00:00 | MSFT | Stock | 369.0 | 369.5 | 367.66 | 368.5315 | 132661.0 |
| 2024-01-08 09:00:00 | MSFT | Stock | 368.75 | 370.96 | 368.73 | 370.56 | 1664083.0 |
| 2024-01-08 10:00:00 | MSFT | Stock | 370.56 | 370.97 | 369.77 | 370.28 | 1563986.0 |
| 2024-01-08 11:00:00 | MSFT | Stock | 370.305 | 371.3961 | 369.95 | 371.22 | 1387563.0 |
| 2024-01-08 12:00:00 | MSFT | Stock | 371.24 | 372.035 | 370.76 | 371.83 | 973686.0 |
| 2024-01-08 13:00:00 | MSFT | Stock | 371.83 | 372.46 | 371.6 | 372.45 | 1017209.0 |
| 2024-01-08 14:00:00 | MSFT | Stock | 372.467 | 374.78 | 372.1567 | 374.55 | 1370769.0 |
| 2024-01-08 15:00:00 | MSFT | Stock | 374.53 | 375.2 | 374.0 | 374.67 | 3534718.0 |
| 2024-01-08 16:00:00 | MSFT | Stock | 374.6 | 374.8 | 373.72 | 373.92 | 5178316.0 |
| 2024-01-08 17:00:00 | MSFT | Stock | 373.85 | 374.69 | 373.51 | 373.711 | 19188.0 |
| 2024-01-08 18:00:00 | MSFT | Stock | 373.5 | 373.8 | 373.41 | 373.7 | 8857.0 |
| 2024-01-08 19:00:00 | MSFT | Stock | 373.79 | 374.15 | 373.65 | 374.08 | 12571.0 |
| 2024-01-08 04:00:00 | NVDA | Stock | 49.0 | 49.0 | 48.68 | 48.846 | 266030.0 |
| 2024-01-08 05:00:00 | NVDA | Stock | 48.858 | 48.96 | 48.848 | 48.876 | 62360.0 |
| 2024-01-08 06:00:00 | NVDA | Stock | 48.865 | 49.165 | 48.83 | 49.136 | 113590.0 |
| 2024-01-08 07:00:00 | NVDA | Stock | 49.148 | 49.48 | 49.112 | 49.468 | 672910.0 |
| 2024-01-08 08:00:00 | NVDA | Stock | 49.198 | 49.655 | 48.94 | 49.65 | 2550830.0 |
| 2024-01-08 09:00:00 | NVDA | Stock | 49.653 | 51.254 | 49.479 | 51.072 | 112915490.0 |
| 2024-01-08 10:00:00 | NVDA | Stock | 51.075 | 51.573 | 50.9 | 51.418 | 90571910.0 |
| 2024-01-08 11:00:00 | NVDA | Stock | 51.419 | 51.547 | 51.062 | 51.3802 | 64862890.0 |
| 2024-01-08 12:00:00 | NVDA | Stock | 51.3724 | 51.435 | 51.103 | 51.427 | 34807110.0 |
| 2024-01-08 13:00:00 | NVDA | Stock | 51.4252 | 51.663 | 51.351 | 51.627 | 39843650.0 |
| 2024-01-08 14:00:00 | NVDA | Stock | 51.6298 | 51.82 | 51.5631 | 51.6872 | 44995560.0 |
| 2024-01-08 15:00:00 | NVDA | Stock | 51.686 | 52.275 | 51.6065 | 52.255 | 73713310.0 |
| 2024-01-08 16:00:00 | NVDA | Stock | 52.253 | 52.483 | 52.2064 | 52.405 | 30153910.0 |
| 2024-01-08 17:00:00 | NVDA | Stock | 52.395 | 52.488 | 52.253 | 52.475 | 849260.0 |
| 2024-01-08 18:00:00 | NVDA | Stock | 52.475 | 52.6 | 52.44 | 52.577 | 1195850.0 |
| 2024-01-08 19:00:00 | NVDA | Stock | 52.579 | 52.7 | 52.574 | 52.7 | 1725620.0 |
| 2024-01-08 04:00:00 | AMZN | Stock | 145.03 | 145.03 | 144.4 | 144.95 | 7324.0 |
| 2024-01-08 05:00:00 | AMZN | Stock | 144.99 | 145.24 | 144.92 | 144.92 | 3992.0 |
> showing 50 of 59,978 rows — these rows as CSV