PREVIEW / stock_1hour / 2024-12-12
file: by_date/stock_1hour/2024/2024-12-12.parquet size: 1.4 MB rows: 62,490 symbols: 675
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-12 04:00:00 | AAPL | Stock | 247.5 | 247.65 | 246.52 | 247.0 | 17358.0 |
| 2024-12-12 05:00:00 | AAPL | Stock | 247.01 | 248.16 | 246.93 | 247.78 | 33671.0 |
| 2024-12-12 06:00:00 | AAPL | Stock | 247.64 | 247.64 | 247.07 | 247.19 | 15348.0 |
| 2024-12-12 07:00:00 | AAPL | Stock | 247.2 | 247.2 | 246.57 | 246.64 | 33722.0 |
| 2024-12-12 08:00:00 | AAPL | Stock | 247.05 | 247.62 | 246.35 | 246.65 | 129203.0 |
| 2024-12-12 09:00:00 | AAPL | Stock | 246.7 | 247.58 | 245.68 | 246.56 | 3068248.0 |
| 2024-12-12 10:00:00 | AAPL | Stock | 246.58 | 248.57 | 245.99 | 248.04 | 3603332.0 |
| 2024-12-12 11:00:00 | AAPL | Stock | 248.05 | 248.5996 | 247.66 | 248.1903 | 1608045.0 |
| 2024-12-12 12:00:00 | AAPL | Stock | 248.19 | 248.55 | 247.63 | 248.55 | 1585510.0 |
| 2024-12-12 13:00:00 | AAPL | Stock | 248.54 | 248.74 | 248.34 | 248.5236 | 1370477.0 |
| 2024-12-12 14:00:00 | AAPL | Stock | 248.5209 | 248.74 | 247.8 | 247.93 | 1365404.0 |
| 2024-12-12 15:00:00 | AAPL | Stock | 247.92 | 248.2 | 247.45 | 247.94 | 2809531.0 |
| 2024-12-12 16:00:00 | AAPL | Stock | 247.96 | 248.47 | 247.61 | 248.05 | 5607570.0 |
| 2024-12-12 17:00:00 | AAPL | Stock | 248.12 | 248.12 | 247.0 | 247.58 | 64180.0 |
| 2024-12-12 18:00:00 | AAPL | Stock | 247.45 | 247.45 | 246.51 | 246.8552 | 52586.0 |
| 2024-12-12 19:00:00 | AAPL | Stock | 246.7801 | 247.3528 | 246.7 | 247.15 | 13646.0 |
| 2024-12-12 04:00:00 | MSFT | Stock | 446.99 | 447.68 | 446.96 | 446.96 | 3096.0 |
| 2024-12-12 05:00:00 | MSFT | Stock | 446.8 | 447.21 | 446.8 | 447.14 | 4040.0 |
| 2024-12-12 06:00:00 | MSFT | Stock | 447.14 | 447.14 | 446.55 | 446.9 | 5099.0 |
| 2024-12-12 07:00:00 | MSFT | Stock | 446.89 | 448.19 | 446.89 | 447.87 | 13625.0 |
| 2024-12-12 08:00:00 | MSFT | Stock | 446.96 | 449.17 | 446.96 | 447.58 | 52634.0 |
| 2024-12-12 09:00:00 | MSFT | Stock | 447.78 | 453.6 | 446.9 | 452.215 | 2271534.0 |
| 2024-12-12 10:00:00 | MSFT | Stock | 452.32 | 455.7699 | 450.5 | 455.37 | 2272313.0 |
| 2024-12-12 11:00:00 | MSFT | Stock | 455.325 | 456.1648 | 452.85 | 453.425 | 1140969.0 |
| 2024-12-12 12:00:00 | MSFT | Stock | 453.4 | 455.24 | 453.32 | 454.45 | 799483.0 |
| 2024-12-12 13:00:00 | MSFT | Stock | 454.45 | 454.75 | 453.07 | 453.155 | 539757.0 |
| 2024-12-12 14:00:00 | MSFT | Stock | 453.2 | 453.57 | 451.75 | 451.92 | 584594.0 |
| 2024-12-12 15:00:00 | MSFT | Stock | 451.85 | 452.18 | 449.13 | 449.38 | 1985794.0 |
| 2024-12-12 16:00:00 | MSFT | Stock | 449.56 | 449.96 | 448.6 | 448.81 | 3844035.0 |
| 2024-12-12 17:00:00 | MSFT | Stock | 448.5689 | 449.56 | 446.99 | 447.8 | 24776.0 |
| 2024-12-12 18:00:00 | MSFT | Stock | 447.5 | 448.0 | 447.1 | 448.0 | 20333.0 |
| 2024-12-12 19:00:00 | MSFT | Stock | 448.05 | 448.464 | 447.8283 | 448.0 | 3338.0 |
| 2024-12-12 04:00:00 | NVDA | Stock | 139.0 | 139.53 | 138.37 | 138.6 | 223235.0 |
| 2024-12-12 05:00:00 | NVDA | Stock | 138.6 | 139.07 | 138.51 | 139.06 | 90197.0 |
| 2024-12-12 06:00:00 | NVDA | Stock | 139.07 | 139.2 | 138.64 | 138.98 | 194647.0 |
| 2024-12-12 07:00:00 | NVDA | Stock | 139.0 | 139.0 | 138.46 | 138.55 | 328287.0 |
| 2024-12-12 08:00:00 | NVDA | Stock | 138.93 | 139.29 | 137.45 | 137.74 | 1943368.0 |
| 2024-12-12 09:00:00 | NVDA | Stock | 137.71 | 138.07 | 135.88 | 136.9 | 24654851.0 |
| 2024-12-12 10:00:00 | NVDA | Stock | 136.9 | 137.53 | 135.8 | 137.07 | 25291075.0 |
| 2024-12-12 11:00:00 | NVDA | Stock | 137.07 | 137.39 | 136.09 | 136.245 | 12121534.0 |
| 2024-12-12 12:00:00 | NVDA | Stock | 136.24 | 138.0 | 136.15 | 137.9099 | 13070369.0 |
| 2024-12-12 13:00:00 | NVDA | Stock | 137.9 | 138.44 | 137.32 | 137.49 | 13689574.0 |
| 2024-12-12 14:00:00 | NVDA | Stock | 137.49 | 138.12 | 137.38 | 138.0598 | 9843725.0 |
| 2024-12-12 15:00:00 | NVDA | Stock | 138.05 | 138.05 | 137.0 | 137.3 | 13140845.0 |
| 2024-12-12 16:00:00 | NVDA | Stock | 137.34 | 137.82 | 136.95 | 137.2499 | 13888114.0 |
| 2024-12-12 17:00:00 | NVDA | Stock | 137.27 | 139.0 | 137.125 | 138.96 | 1391599.0 |
| 2024-12-12 18:00:00 | NVDA | Stock | 138.95 | 139.41 | 138.5 | 138.79 | 895934.0 |
| 2024-12-12 19:00:00 | NVDA | Stock | 138.8 | 139.23 | 138.74 | 139.0 | 563855.0 |
| 2024-12-12 04:00:00 | AMZN | Stock | 229.5 | 230.0 | 229.46 | 229.81 | 8590.0 |
| 2024-12-12 05:00:00 | AMZN | Stock | 229.93 | 230.0 | 229.5 | 229.7 | 7593.0 |
> showing 50 of 62,490 rows — these rows as CSV