PREVIEW / stock_1hour / 2024-01-10
file: by_date/stock_1hour/2024/2024-01-10.parquet size: 1.3 MB rows: 59,009 symbols: 1,173
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-10 04:00:00 | AAPL | Stock | 184.88 | 185.35 | 184.8 | 185.3 | 21289.0 |
| 2024-01-10 05:00:00 | AAPL | Stock | 185.28 | 185.35 | 185.2 | 185.35 | 14126.0 |
| 2024-01-10 06:00:00 | AAPL | Stock | 185.41 | 185.41 | 184.71 | 184.88 | 19818.0 |
| 2024-01-10 07:00:00 | AAPL | Stock | 184.88 | 185.14 | 184.69 | 184.7 | 45613.0 |
| 2024-01-10 08:00:00 | AAPL | Stock | 184.949 | 185.55 | 184.26 | 184.37 | 163342.0 |
| 2024-01-10 09:00:00 | AAPL | Stock | 184.4 | 184.96 | 183.97 | 184.265 | 4384519.0 |
| 2024-01-10 10:00:00 | AAPL | Stock | 184.26 | 184.8 | 183.92 | 184.773 | 4325850.0 |
| 2024-01-10 11:00:00 | AAPL | Stock | 184.7784 | 185.01 | 184.05 | 184.27 | 4050570.0 |
| 2024-01-10 12:00:00 | AAPL | Stock | 184.2913 | 184.395 | 184.08 | 184.32 | 2204638.0 |
| 2024-01-10 13:00:00 | AAPL | Stock | 184.325 | 184.85 | 184.13 | 184.78 | 2623505.0 |
| 2024-01-10 14:00:00 | AAPL | Stock | 184.7894 | 186.13 | 184.77 | 186.1176 | 4497861.0 |
| 2024-01-10 15:00:00 | AAPL | Stock | 186.12 | 186.4 | 185.27 | 186.15 | 7835519.0 |
| 2024-01-10 16:00:00 | AAPL | Stock | 186.14 | 186.73 | 186.13 | 186.68 | 7111462.0 |
| 2024-01-10 17:00:00 | AAPL | Stock | 186.68 | 186.78 | 186.19 | 186.61 | 92833.0 |
| 2024-01-10 18:00:00 | AAPL | Stock | 186.6 | 186.65 | 186.5 | 186.6 | 27333.0 |
| 2024-01-10 19:00:00 | AAPL | Stock | 186.59 | 186.7 | 186.4 | 186.7 | 26427.0 |
| 2024-01-10 04:00:00 | MSFT | Stock | 376.5 | 377.5 | 376.5 | 377.25 | 4495.0 |
| 2024-01-10 05:00:00 | MSFT | Stock | 377.2 | 377.8 | 377.13 | 377.69 | 6590.0 |
| 2024-01-10 06:00:00 | MSFT | Stock | 377.85 | 378.2 | 377.2 | 377.22 | 6474.0 |
| 2024-01-10 07:00:00 | MSFT | Stock | 377.37 | 377.49 | 377.0 | 377.0 | 26266.0 |
| 2024-01-10 08:00:00 | MSFT | Stock | 377.4 | 377.5 | 376.05 | 376.54 | 53346.0 |
| 2024-01-10 09:00:00 | MSFT | Stock | 376.39 | 380.45 | 376.08 | 379.92 | 2930640.0 |
| 2024-01-10 10:00:00 | MSFT | Stock | 379.92 | 382.29 | 379.13 | 381.4699 | 2862229.0 |
| 2024-01-10 11:00:00 | MSFT | Stock | 381.47 | 381.88 | 380.47 | 381.09 | 1480866.0 |
| 2024-01-10 12:00:00 | MSFT | Stock | 381.08 | 382.45 | 380.7969 | 382.38 | 1333176.0 |
| 2024-01-10 13:00:00 | MSFT | Stock | 382.39 | 382.81 | 381.623 | 382.53 | 1036701.0 |
| 2024-01-10 14:00:00 | MSFT | Stock | 382.55 | 384.1299 | 382.47 | 384.1299 | 1461855.0 |
| 2024-01-10 15:00:00 | MSFT | Stock | 384.13 | 384.17 | 381.32 | 382.77 | 2720757.0 |
| 2024-01-10 16:00:00 | MSFT | Stock | 382.77 | 383.2 | 382.64 | 383.2 | 3761739.0 |
| 2024-01-10 17:00:00 | MSFT | Stock | 383.2 | 383.63 | 383.1738 | 383.419 | 17183.0 |
| 2024-01-10 18:00:00 | MSFT | Stock | 383.31 | 383.83 | 382.77 | 383.4 | 13308.0 |
| 2024-01-10 19:00:00 | MSFT | Stock | 383.5 | 384.24 | 383.14 | 384.2299 | 11705.0 |
| 2024-01-10 04:00:00 | NVDA | Stock | 53.41 | 53.8 | 53.41 | 53.753 | 304990.0 |
| 2024-01-10 05:00:00 | NVDA | Stock | 53.745 | 53.773 | 53.652 | 53.75 | 152230.0 |
| 2024-01-10 06:00:00 | NVDA | Stock | 53.733 | 53.774 | 53.448 | 53.599 | 257620.0 |
| 2024-01-10 07:00:00 | NVDA | Stock | 53.6 | 53.933 | 53.567 | 53.654 | 1599560.0 |
| 2024-01-10 08:00:00 | NVDA | Stock | 53.924 | 53.936 | 53.072 | 53.523 | 3081200.0 |
| 2024-01-10 09:00:00 | NVDA | Stock | 53.507 | 54.186 | 53.4 | 53.964 | 78343060.0 |
| 2024-01-10 10:00:00 | NVDA | Stock | 53.967 | 54.6 | 53.737 | 54.569 | 95842740.0 |
| 2024-01-10 11:00:00 | NVDA | Stock | 54.567 | 54.6 | 54.142 | 54.1792 | 52092640.0 |
| 2024-01-10 12:00:00 | NVDA | Stock | 54.185 | 54.48 | 53.985 | 54.3134 | 40563080.0 |
| 2024-01-10 13:00:00 | NVDA | Stock | 54.32 | 54.414 | 54.14 | 54.299 | 29845140.0 |
| 2024-01-10 14:00:00 | NVDA | Stock | 54.3 | 54.48 | 54.04 | 54.3425 | 43268190.0 |
| 2024-01-10 15:00:00 | NVDA | Stock | 54.346 | 54.366 | 53.952 | 54.3495 | 53607470.0 |
| 2024-01-10 16:00:00 | NVDA | Stock | 54.35 | 54.545 | 54.325 | 54.502 | 18775630.0 |
| 2024-01-10 17:00:00 | NVDA | Stock | 54.511 | 54.626 | 54.35 | 54.585 | 1593260.0 |
| 2024-01-10 18:00:00 | NVDA | Stock | 54.58 | 54.608 | 54.35 | 54.531 | 571270.0 |
| 2024-01-10 19:00:00 | NVDA | Stock | 54.545 | 54.597 | 54.5 | 54.527 | 598930.0 |
| 2024-01-10 04:00:00 | AMZN | Stock | 151.71 | 152.22 | 151.7 | 152.2 | 10138.0 |
| 2024-01-10 05:00:00 | AMZN | Stock | 152.18 | 152.21 | 152.0 | 152.04 | 11021.0 |
> showing 50 of 59,009 rows — these rows as CSV