PREVIEW / stock_1hour / 2024-12-13
file: by_date/stock_1hour/2024/2024-12-13.parquet size: 1.4 MB rows: 62,323 symbols: 667
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-13 04:00:00 | AAPL | Stock | 247.12 | 247.17 | 246.5 | 246.8 | 30820.0 |
| 2024-12-13 05:00:00 | AAPL | Stock | 246.77 | 247.44 | 246.69 | 247.39 | 8112.0 |
| 2024-12-13 06:00:00 | AAPL | Stock | 247.21 | 248.5 | 247.21 | 248.25 | 51009.0 |
| 2024-12-13 07:00:00 | AAPL | Stock | 248.25 | 249.52 | 248.0 | 249.5 | 77313.0 |
| 2024-12-13 08:00:00 | AAPL | Stock | 248.49 | 249.5681 | 246.7 | 248.88 | 167686.0 |
| 2024-12-13 09:00:00 | AAPL | Stock | 248.71 | 249.2902 | 247.53 | 248.37 | 3107466.0 |
| 2024-12-13 10:00:00 | AAPL | Stock | 248.37 | 248.39 | 246.96 | 247.22 | 3144680.0 |
| 2024-12-13 11:00:00 | AAPL | Stock | 247.24 | 247.32 | 246.41 | 246.715 | 2698449.0 |
| 2024-12-13 12:00:00 | AAPL | Stock | 246.71 | 246.88 | 246.24 | 246.58 | 1419946.0 |
| 2024-12-13 13:00:00 | AAPL | Stock | 246.585 | 247.88 | 246.56 | 247.85 | 1516756.0 |
| 2024-12-13 14:00:00 | AAPL | Stock | 247.845 | 248.03 | 247.58 | 247.87 | 1484627.0 |
| 2024-12-13 15:00:00 | AAPL | Stock | 247.87 | 248.2987 | 247.78 | 248.11 | 2708926.0 |
| 2024-12-13 16:00:00 | AAPL | Stock | 248.1 | 248.28 | 247.5 | 247.65 | 7643129.0 |
| 2024-12-13 17:00:00 | AAPL | Stock | 247.67 | 248.05 | 247.63 | 247.79 | 13703.0 |
| 2024-12-13 18:00:00 | AAPL | Stock | 247.8 | 247.86 | 247.73 | 247.8 | 3756.0 |
| 2024-12-13 19:00:00 | AAPL | Stock | 247.77 | 248.13 | 247.76 | 248.0 | 13283.0 |
| 2024-12-13 04:00:00 | MSFT | Stock | 448.78 | 450.48 | 448.78 | 449.79 | 9667.0 |
| 2024-12-13 05:00:00 | MSFT | Stock | 450.24 | 450.51 | 450.12 | 450.23 | 2394.0 |
| 2024-12-13 06:00:00 | MSFT | Stock | 450.25 | 451.27 | 449.71 | 451.0 | 9077.0 |
| 2024-12-13 07:00:00 | MSFT | Stock | 450.29 | 450.49 | 448.75 | 450.2 | 17676.0 |
| 2024-12-13 08:00:00 | MSFT | Stock | 449.3 | 450.79 | 448.35 | 448.68 | 32026.0 |
| 2024-12-13 09:00:00 | MSFT | Stock | 448.77 | 451.43 | 447.81 | 449.8 | 1097451.0 |
| 2024-12-13 10:00:00 | MSFT | Stock | 449.9 | 450.1614 | 447.31 | 447.8417 | 1270685.0 |
| 2024-12-13 11:00:00 | MSFT | Stock | 447.79 | 448.63 | 446.4 | 446.955 | 918862.0 |
| 2024-12-13 12:00:00 | MSFT | Stock | 446.95 | 447.1666 | 445.76 | 445.76 | 776111.0 |
| 2024-12-13 13:00:00 | MSFT | Stock | 445.8 | 447.98 | 445.58 | 447.7201 | 715158.0 |
| 2024-12-13 14:00:00 | MSFT | Stock | 447.7922 | 447.92 | 447.01 | 447.19 | 452775.0 |
| 2024-12-13 15:00:00 | MSFT | Stock | 447.19 | 448.2499 | 446.92 | 447.26 | 978765.0 |
| 2024-12-13 16:00:00 | MSFT | Stock | 447.27 | 448.32 | 446.15 | 447.1 | 4981821.0 |
| 2024-12-13 17:00:00 | MSFT | Stock | 447.1 | 447.27 | 447.1 | 447.15 | 7397.0 |
| 2024-12-13 18:00:00 | MSFT | Stock | 447.0 | 447.1696 | 446.71 | 447.1696 | 1700.0 |
| 2024-12-13 19:00:00 | MSFT | Stock | 447.17 | 447.24 | 447.17 | 447.24 | 530.0 |
| 2024-12-13 04:00:00 | NVDA | Stock | 139.0 | 139.8 | 138.0 | 138.85 | 266660.0 |
| 2024-12-13 05:00:00 | NVDA | Stock | 138.87 | 138.99 | 138.69 | 138.85 | 139422.0 |
| 2024-12-13 06:00:00 | NVDA | Stock | 138.87 | 138.91 | 138.48 | 138.57 | 134305.0 |
| 2024-12-13 07:00:00 | NVDA | Stock | 138.55 | 139.4 | 138.53 | 139.32 | 611308.0 |
| 2024-12-13 08:00:00 | NVDA | Stock | 138.74 | 139.98 | 138.36 | 139.88 | 2136390.0 |
| 2024-12-13 09:00:00 | NVDA | Stock | 139.87 | 139.88 | 137.485 | 138.87 | 23857113.0 |
| 2024-12-13 10:00:00 | NVDA | Stock | 138.87 | 139.1 | 134.02 | 134.17 | 37444053.0 |
| 2024-12-13 11:00:00 | NVDA | Stock | 134.16 | 134.28 | 132.54 | 133.526 | 42087299.0 |
| 2024-12-13 12:00:00 | NVDA | Stock | 133.52 | 134.15 | 132.85 | 133.5201 | 20360762.0 |
| 2024-12-13 13:00:00 | NVDA | Stock | 133.53 | 134.62 | 133.5 | 134.3264 | 13044062.0 |
| 2024-12-13 14:00:00 | NVDA | Stock | 134.32 | 134.92 | 133.65 | 133.72 | 13795789.0 |
| 2024-12-13 15:00:00 | NVDA | Stock | 133.71 | 134.31 | 133.68 | 134.22 | 19245768.0 |
| 2024-12-13 16:00:00 | NVDA | Stock | 134.21 | 134.39 | 133.82 | 133.99 | 15964900.0 |
| 2024-12-13 17:00:00 | NVDA | Stock | 134.0 | 134.17 | 133.9997 | 134.07 | 273854.0 |
| 2024-12-13 18:00:00 | NVDA | Stock | 134.1 | 134.1 | 134.0 | 134.01 | 207956.0 |
| 2024-12-13 19:00:00 | NVDA | Stock | 134.02 | 134.04 | 133.9 | 133.91 | 251488.0 |
| 2024-12-13 04:00:00 | AMZN | Stock | 229.0 | 229.39 | 228.48 | 229.14 | 16681.0 |
| 2024-12-13 05:00:00 | AMZN | Stock | 229.11 | 229.14 | 228.64 | 228.8 | 3123.0 |
> showing 50 of 62,323 rows — these rows as CSV