PREVIEW / stock_1hour / 2024-01-16
file: by_date/stock_1hour/2024/2024-01-16.parquet size: 1.3 MB rows: 60,051 symbols: 1,200
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-16 04:00:00 | AAPL | Stock | 183.53 | 184.38 | 182.76 | 183.0 | 41063.0 |
| 2024-01-16 05:00:00 | AAPL | Stock | 183.06 | 183.12 | 182.56 | 182.56 | 12041.0 |
| 2024-01-16 06:00:00 | AAPL | Stock | 182.6 | 182.94 | 182.6 | 182.85 | 21193.0 |
| 2024-01-16 07:00:00 | AAPL | Stock | 182.89 | 183.45 | 182.8 | 183.05 | 95157.0 |
| 2024-01-16 08:00:00 | AAPL | Stock | 182.9 | 185.0 | 182.39 | 182.46 | 275952.0 |
| 2024-01-16 09:00:00 | AAPL | Stock | 182.48 | 182.66 | 180.934 | 181.34 | 8418920.0 |
| 2024-01-16 10:00:00 | AAPL | Stock | 181.36 | 183.9 | 181.03 | 183.78 | 8943502.0 |
| 2024-01-16 11:00:00 | AAPL | Stock | 183.78 | 184.26 | 182.77 | 182.9 | 6473284.0 |
| 2024-01-16 12:00:00 | AAPL | Stock | 182.89 | 182.95 | 182.22 | 182.255 | 4070476.0 |
| 2024-01-16 13:00:00 | AAPL | Stock | 182.26 | 182.9499 | 182.21 | 182.395 | 3363969.0 |
| 2024-01-16 14:00:00 | AAPL | Stock | 182.4 | 182.94 | 182.14 | 182.9 | 3451873.0 |
| 2024-01-16 15:00:00 | AAPL | Stock | 182.9 | 183.63 | 182.835 | 183.61 | 5471227.0 |
| 2024-01-16 16:00:00 | AAPL | Stock | 183.61 | 183.69 | 183.37 | 183.46 | 8963755.0 |
| 2024-01-16 17:00:00 | AAPL | Stock | 183.43 | 183.63 | 183.14 | 183.2501 | 74972.0 |
| 2024-01-16 18:00:00 | AAPL | Stock | 183.29 | 183.33 | 183.12 | 183.2 | 13531.0 |
| 2024-01-16 19:00:00 | AAPL | Stock | 183.15 | 183.35 | 183.0 | 183.04 | 16935.0 |
| 2024-01-16 04:00:00 | MSFT | Stock | 388.44 | 389.28 | 387.67 | 389.28 | 7493.0 |
| 2024-01-16 05:00:00 | MSFT | Stock | 389.42 | 389.89 | 389.08 | 389.41 | 4418.0 |
| 2024-01-16 06:00:00 | MSFT | Stock | 389.35 | 390.65 | 389.35 | 390.6 | 3660.0 |
| 2024-01-16 07:00:00 | MSFT | Stock | 390.7 | 392.0 | 389.99 | 392.0 | 61308.0 |
| 2024-01-16 08:00:00 | MSFT | Stock | 390.4 | 393.8 | 386.76 | 393.7561 | 212974.0 |
| 2024-01-16 09:00:00 | MSFT | Stock | 393.75 | 394.03 | 389.47 | 391.93 | 3907008.0 |
| 2024-01-16 10:00:00 | MSFT | Stock | 391.96 | 393.22 | 390.78 | 392.81 | 2913296.0 |
| 2024-01-16 11:00:00 | MSFT | Stock | 392.86 | 393.04 | 390.23 | 390.58 | 1798610.0 |
| 2024-01-16 12:00:00 | MSFT | Stock | 390.56 | 390.991 | 388.31 | 388.38 | 1375947.0 |
| 2024-01-16 13:00:00 | MSFT | Stock | 388.39 | 389.75 | 387.6229 | 388.86 | 1355985.0 |
| 2024-01-16 14:00:00 | MSFT | Stock | 388.87 | 389.83 | 388.0 | 389.7193 | 1144689.0 |
| 2024-01-16 15:00:00 | MSFT | Stock | 389.7 | 390.38 | 389.3651 | 390.27 | 1770146.0 |
| 2024-01-16 16:00:00 | MSFT | Stock | 390.27 | 390.46 | 390.22 | 390.39 | 4220267.0 |
| 2024-01-16 17:00:00 | MSFT | Stock | 390.41 | 390.8 | 390.41 | 390.74 | 15851.0 |
| 2024-01-16 18:00:00 | MSFT | Stock | 390.6 | 390.79 | 390.27 | 390.57 | 18486.0 |
| 2024-01-16 19:00:00 | MSFT | Stock | 390.6 | 390.6 | 390.12 | 390.34 | 11683.0 |
| 2024-01-16 04:00:00 | NVDA | Stock | 54.39 | 54.67 | 54.169 | 54.539 | 259570.0 |
| 2024-01-16 05:00:00 | NVDA | Stock | 54.535 | 54.568 | 54.429 | 54.497 | 100420.0 |
| 2024-01-16 06:00:00 | NVDA | Stock | 54.519 | 54.689 | 54.49 | 54.645 | 163240.0 |
| 2024-01-16 07:00:00 | NVDA | Stock | 54.65 | 54.9 | 54.65 | 54.89 | 898630.0 |
| 2024-01-16 08:00:00 | NVDA | Stock | 54.768 | 55.136 | 54.081 | 55.05 | 3049380.0 |
| 2024-01-16 09:00:00 | NVDA | Stock | 55.057 | 55.798 | 54.84 | 55.731 | 60351150.0 |
| 2024-01-16 10:00:00 | NVDA | Stock | 55.7213 | 56.7 | 55.539 | 56.553 | 77892400.0 |
| 2024-01-16 11:00:00 | NVDA | Stock | 56.558 | 56.835 | 56.206 | 56.436 | 57165890.0 |
| 2024-01-16 12:00:00 | NVDA | Stock | 56.433 | 56.48 | 56.05 | 56.109 | 33035620.0 |
| 2024-01-16 13:00:00 | NVDA | Stock | 56.091 | 56.408 | 56.0576 | 56.1878 | 25968560.0 |
| 2024-01-16 14:00:00 | NVDA | Stock | 56.176 | 56.36 | 56.025 | 56.2765 | 24411040.0 |
| 2024-01-16 15:00:00 | NVDA | Stock | 56.272 | 56.403 | 56.03 | 56.402 | 36223240.0 |
| 2024-01-16 16:00:00 | NVDA | Stock | 56.382 | 56.625 | 56.364 | 56.578 | 17542220.0 |
| 2024-01-16 17:00:00 | NVDA | Stock | 56.57 | 56.797 | 56.567 | 56.643 | 1520990.0 |
| 2024-01-16 18:00:00 | NVDA | Stock | 56.643 | 56.7 | 56.519 | 56.57 | 465190.0 |
| 2024-01-16 19:00:00 | NVDA | Stock | 56.57 | 56.59 | 56.513 | 56.55 | 500810.0 |
| 2024-01-16 04:00:00 | AMZN | Stock | 153.85 | 153.85 | 152.91 | 153.13 | 22853.0 |
| 2024-01-16 05:00:00 | AMZN | Stock | 152.93 | 153.1 | 152.55 | 152.87 | 11801.0 |
> showing 50 of 60,051 rows — these rows as CSV