PREVIEW / stock_1hour / 2024-12-10
file: by_date/stock_1hour/2024/2024-12-10.parquet size: 1.4 MB rows: 61,904 symbols: 682
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-12-10 04:00:00 | AAPL | Stock | 246.6 | 247.3 | 246.53 | 247.04 | 16124.0 |
| 2024-12-10 05:00:00 | AAPL | Stock | 247.04 | 247.23 | 247.02 | 247.08 | 9937.0 |
| 2024-12-10 06:00:00 | AAPL | Stock | 247.09 | 247.25 | 247.04 | 247.15 | 12416.0 |
| 2024-12-10 07:00:00 | AAPL | Stock | 247.22 | 247.8 | 247.13 | 247.8 | 30874.0 |
| 2024-12-10 08:00:00 | AAPL | Stock | 247.2 | 248.0 | 246.134 | 247.33 | 148029.0 |
| 2024-12-10 09:00:00 | AAPL | Stock | 247.38 | 247.7871 | 245.81 | 247.655 | 4002199.0 |
| 2024-12-10 10:00:00 | AAPL | Stock | 247.64 | 247.68 | 245.83 | 245.8885 | 3109300.0 |
| 2024-12-10 11:00:00 | AAPL | Stock | 245.885 | 246.54 | 245.34 | 246.4 | 2276438.0 |
| 2024-12-10 12:00:00 | AAPL | Stock | 246.41 | 247.32 | 246.4 | 246.85 | 1620772.0 |
| 2024-12-10 13:00:00 | AAPL | Stock | 246.8513 | 247.78 | 246.72 | 247.6117 | 1750584.0 |
| 2024-12-10 14:00:00 | AAPL | Stock | 247.62 | 248.095 | 247.37 | 248.03 | 2310005.0 |
| 2024-12-10 15:00:00 | AAPL | Stock | 248.03 | 248.21 | 247.33 | 247.8 | 4347046.0 |
| 2024-12-10 16:00:00 | AAPL | Stock | 247.81 | 248.0 | 247.2994 | 247.895 | 7542781.0 |
| 2024-12-10 17:00:00 | AAPL | Stock | 247.9 | 247.9 | 247.76 | 247.82 | 13420.0 |
| 2024-12-10 18:00:00 | AAPL | Stock | 247.82 | 247.87 | 247.62 | 247.77 | 15146.0 |
| 2024-12-10 19:00:00 | AAPL | Stock | 247.77 | 247.77 | 247.556 | 247.7 | 12540.0 |
| 2024-12-10 04:00:00 | MSFT | Stock | 444.32 | 444.32 | 442.84 | 443.11 | 4859.0 |
| 2024-12-10 05:00:00 | MSFT | Stock | 443.51 | 443.89 | 443.4 | 443.45 | 5384.0 |
| 2024-12-10 06:00:00 | MSFT | Stock | 443.52 | 444.23 | 443.52 | 443.86 | 3971.0 |
| 2024-12-10 07:00:00 | MSFT | Stock | 444.0 | 444.67 | 443.85 | 444.2 | 7243.0 |
| 2024-12-10 08:00:00 | MSFT | Stock | 444.7 | 444.905 | 442.53 | 442.71 | 45694.0 |
| 2024-12-10 09:00:00 | MSFT | Stock | 442.98 | 448.35 | 442.46 | 448.11 | 1416335.0 |
| 2024-12-10 10:00:00 | MSFT | Stock | 448.21 | 449.62 | 447.49 | 447.9982 | 1191130.0 |
| 2024-12-10 11:00:00 | MSFT | Stock | 447.975 | 447.98 | 445.55 | 446.39 | 958299.0 |
| 2024-12-10 12:00:00 | MSFT | Stock | 446.38 | 447.69 | 445.51 | 445.86 | 567006.0 |
| 2024-12-10 13:00:00 | MSFT | Stock | 445.895 | 446.09 | 444.17 | 444.6438 | 670901.0 |
| 2024-12-10 14:00:00 | MSFT | Stock | 444.685 | 444.81 | 441.6 | 442.445 | 989582.0 |
| 2024-12-10 15:00:00 | MSFT | Stock | 442.42 | 443.6 | 441.673 | 443.48 | 1493078.0 |
| 2024-12-10 16:00:00 | MSFT | Stock | 443.33 | 444.5818 | 443.071 | 443.5 | 5122016.0 |
| 2024-12-10 17:00:00 | MSFT | Stock | 443.53 | 443.9815 | 443.51 | 443.9815 | 1647.0 |
| 2024-12-10 18:00:00 | MSFT | Stock | 443.99 | 443.99 | 443.45 | 443.68 | 5415.0 |
| 2024-12-10 19:00:00 | MSFT | Stock | 443.45 | 443.59 | 443.2 | 443.59 | 1332.0 |
| 2024-12-10 04:00:00 | NVDA | Stock | 138.0 | 138.1 | 137.08 | 137.22 | 302664.0 |
| 2024-12-10 05:00:00 | NVDA | Stock | 137.23 | 137.7 | 137.02 | 137.64 | 221579.0 |
| 2024-12-10 06:00:00 | NVDA | Stock | 137.64 | 138.38 | 137.64 | 138.03 | 260534.0 |
| 2024-12-10 07:00:00 | NVDA | Stock | 138.03 | 138.83 | 138.0 | 138.599 | 491010.0 |
| 2024-12-10 08:00:00 | NVDA | Stock | 138.25 | 139.14 | 137.1371 | 138.74 | 1495847.0 |
| 2024-12-10 09:00:00 | NVDA | Stock | 138.75 | 141.82 | 138.6 | 140.93 | 25052881.0 |
| 2024-12-10 10:00:00 | NVDA | Stock | 140.925 | 141.28 | 138.1 | 138.145 | 24014844.0 |
| 2024-12-10 11:00:00 | NVDA | Stock | 138.15 | 138.28 | 136.18 | 136.98 | 27244024.0 |
| 2024-12-10 12:00:00 | NVDA | Stock | 136.97 | 136.99 | 135.76 | 136.4799 | 15397124.0 |
| 2024-12-10 13:00:00 | NVDA | Stock | 136.475 | 136.65 | 135.67 | 135.71 | 12852715.0 |
| 2024-12-10 14:00:00 | NVDA | Stock | 135.703 | 136.15 | 134.69 | 134.7 | 17337194.0 |
| 2024-12-10 15:00:00 | NVDA | Stock | 134.7 | 135.4 | 133.79 | 135.08 | 27763188.0 |
| 2024-12-10 16:00:00 | NVDA | Stock | 135.08 | 136.9948 | 134.5 | 135.46 | 22854661.0 |
| 2024-12-10 17:00:00 | NVDA | Stock | 135.47 | 135.48 | 135.26 | 135.3898 | 286287.0 |
| 2024-12-10 18:00:00 | NVDA | Stock | 135.39 | 135.75 | 135.36 | 135.6 | 279412.0 |
| 2024-12-10 19:00:00 | NVDA | Stock | 135.6 | 135.7 | 135.3 | 135.3 | 250365.0 |
| 2024-12-10 04:00:00 | AMZN | Stock | 226.77 | 227.0 | 226.46 | 226.6 | 12225.0 |
| 2024-12-10 05:00:00 | AMZN | Stock | 226.59 | 227.02 | 226.3 | 226.85 | 22283.0 |
> showing 50 of 61,904 rows — these rows as CSV