PREVIEW / stock_1hour / 2024-12-16
file: by_date/stock_1hour/2024/2024-12-16.parquet size: 1.5 MB rows: 64,729 symbols: 673
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-16 04:00:00 | AAPL | Stock | 248.23 | 248.9 | 248.23 | 248.5 | 3672.0 |
| 2024-12-16 05:00:00 | AAPL | Stock | 248.57 | 248.97 | 248.57 | 248.72 | 7594.0 |
| 2024-12-16 06:00:00 | AAPL | Stock | 248.69 | 248.74 | 248.6 | 248.74 | 4317.0 |
| 2024-12-16 07:00:00 | AAPL | Stock | 248.7 | 248.97 | 248.48 | 248.73 | 16629.0 |
| 2024-12-16 08:00:00 | AAPL | Stock | 248.7 | 248.99 | 247.51 | 248.19 | 76725.0 |
| 2024-12-16 09:00:00 | AAPL | Stock | 248.21 | 250.0 | 247.23 | 248.605 | 3748132.0 |
| 2024-12-16 10:00:00 | AAPL | Stock | 248.615 | 249.49 | 248.49 | 249.31 | 2458474.0 |
| 2024-12-16 11:00:00 | AAPL | Stock | 249.3 | 250.29 | 249.13 | 250.275 | 3413987.0 |
| 2024-12-16 12:00:00 | AAPL | Stock | 250.275 | 251.38 | 249.7705 | 251.2859 | 2694403.0 |
| 2024-12-16 13:00:00 | AAPL | Stock | 251.2863 | 251.2863 | 250.58 | 250.86 | 1931856.0 |
| 2024-12-16 14:00:00 | AAPL | Stock | 250.86 | 251.21 | 250.68 | 250.81 | 2084137.0 |
| 2024-12-16 15:00:00 | AAPL | Stock | 250.81 | 251.1 | 249.95 | 251.04 | 3903847.0 |
| 2024-12-16 16:00:00 | AAPL | Stock | 251.05 | 251.2 | 250.7065 | 251.2 | 17231654.0 |
| 2024-12-16 17:00:00 | AAPL | Stock | 251.17 | 251.2 | 251.04 | 251.07 | 41922.0 |
| 2024-12-16 18:00:00 | AAPL | Stock | 251.08 | 251.08 | 250.62 | 250.87 | 26482.0 |
| 2024-12-16 19:00:00 | AAPL | Stock | 250.81 | 251.04 | 250.8 | 251.0 | 9205.0 |
| 2024-12-16 04:00:00 | MSFT | Stock | 447.27 | 447.85 | 447.27 | 447.49 | 1978.0 |
| 2024-12-16 05:00:00 | MSFT | Stock | 447.66 | 448.57 | 447.59 | 448.39 | 3301.0 |
| 2024-12-16 06:00:00 | MSFT | Stock | 448.12 | 448.16 | 448.0 | 448.16 | 800.0 |
| 2024-12-16 07:00:00 | MSFT | Stock | 448.08 | 448.57 | 447.61 | 447.91 | 14496.0 |
| 2024-12-16 08:00:00 | MSFT | Stock | 448.0 | 448.5678 | 446.152 | 447.51 | 34694.0 |
| 2024-12-16 09:00:00 | MSFT | Stock | 447.6 | 449.15 | 445.7 | 447.05 | 1858984.0 |
| 2024-12-16 10:00:00 | MSFT | Stock | 447.02 | 447.28 | 445.28 | 447.05 | 1187286.0 |
| 2024-12-16 11:00:00 | MSFT | Stock | 447.04 | 448.64 | 446.84 | 448.2597 | 1085743.0 |
| 2024-12-16 12:00:00 | MSFT | Stock | 448.3399 | 448.54 | 446.55 | 448.1699 | 895589.0 |
| 2024-12-16 13:00:00 | MSFT | Stock | 448.06 | 449.61 | 447.75 | 448.95 | 684458.0 |
| 2024-12-16 14:00:00 | MSFT | Stock | 448.9473 | 450.67 | 448.55 | 450.3305 | 857790.0 |
| 2024-12-16 15:00:00 | MSFT | Stock | 450.42 | 452.18 | 450.0714 | 451.71 | 1973657.0 |
| 2024-12-16 16:00:00 | MSFT | Stock | 451.71 | 451.76 | 450.4006 | 450.6543 | 7075987.0 |
| 2024-12-16 17:00:00 | MSFT | Stock | 451.0 | 451.01 | 450.6 | 451.01 | 930.0 |
| 2024-12-16 18:00:00 | MSFT | Stock | 451.06 | 451.59 | 450.0 | 450.3201 | 4881.0 |
| 2024-12-16 19:00:00 | MSFT | Stock | 450.7 | 450.99 | 450.7 | 450.7469 | 2346.0 |
| 2024-12-16 04:00:00 | NVDA | Stock | 134.21 | 134.75 | 133.19 | 133.21 | 444082.0 |
| 2024-12-16 05:00:00 | NVDA | Stock | 133.22 | 133.59 | 133.05 | 133.46 | 271836.0 |
| 2024-12-16 06:00:00 | NVDA | Stock | 133.47 | 133.76 | 133.38 | 133.72 | 192014.0 |
| 2024-12-16 07:00:00 | NVDA | Stock | 133.72 | 133.87 | 133.33 | 133.59 | 596879.0 |
| 2024-12-16 08:00:00 | NVDA | Stock | 133.59 | 134.8 | 133.2024 | 134.77 | 1983659.0 |
| 2024-12-16 09:00:00 | NVDA | Stock | 134.77 | 134.89 | 130.45 | 132.5199 | 37999129.0 |
| 2024-12-16 10:00:00 | NVDA | Stock | 132.51 | 132.86 | 130.42 | 131.56 | 32640160.0 |
| 2024-12-16 11:00:00 | NVDA | Stock | 131.5505 | 132.17 | 130.69 | 131.3801 | 21395337.0 |
| 2024-12-16 12:00:00 | NVDA | Stock | 131.39 | 131.57 | 130.44 | 131.47 | 18006958.0 |
| 2024-12-16 13:00:00 | NVDA | Stock | 131.462 | 132.04 | 130.71 | 131.1172 | 17256388.0 |
| 2024-12-16 14:00:00 | NVDA | Stock | 131.12 | 132.78 | 131.05 | 131.91 | 19177631.0 |
| 2024-12-16 15:00:00 | NVDA | Stock | 131.92 | 132.7399 | 131.52 | 131.97 | 21186717.0 |
| 2024-12-16 16:00:00 | NVDA | Stock | 132.0 | 132.15 | 131.55 | 131.6294 | 19671136.0 |
| 2024-12-16 17:00:00 | NVDA | Stock | 131.62 | 131.63 | 131.21 | 131.4 | 452847.0 |
| 2024-12-16 18:00:00 | NVDA | Stock | 131.39 | 132.0 | 131.0 | 131.0899 | 530618.0 |
| 2024-12-16 19:00:00 | NVDA | Stock | 131.09 | 131.15 | 130.91 | 130.95 | 523543.0 |
| 2024-12-16 04:00:00 | AMZN | Stock | 228.11 | 229.0 | 227.7 | 229.0 | 13253.0 |
| 2024-12-16 05:00:00 | AMZN | Stock | 229.1 | 229.4 | 228.99 | 229.05 | 11682.0 |
> showing 50 of 64,729 rows — these rows as CSV