PREVIEW / stock_1hour / 2024-01-02
file: by_date/stock_1hour/2024/2024-01-02.parquet size: 1.4 MB rows: 61,107 symbols: 1,187
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-02 04:00:00 | AAPL | Stock | 191.52 | 191.52 | 189.8 | 189.95 | 46097.0 |
| 2024-01-02 05:00:00 | AAPL | Stock | 190.0 | 190.24 | 189.7 | 189.76 | 18261.0 |
| 2024-01-02 06:00:00 | AAPL | Stock | 189.68 | 189.68 | 188.8 | 188.94 | 81495.0 |
| 2024-01-02 07:00:00 | AAPL | Stock | 189.02 | 189.65 | 188.4 | 188.4 | 106617.0 |
| 2024-01-02 08:00:00 | AAPL | Stock | 189.03 | 192.53 | 187.78 | 188.1 | 394882.0 |
| 2024-01-02 09:00:00 | AAPL | Stock | 188.1 | 188.54 | 186.01 | 186.52 | 12391901.0 |
| 2024-01-02 10:00:00 | AAPL | Stock | 186.52 | 186.97 | 185.1843 | 185.89 | 8133379.0 |
| 2024-01-02 11:00:00 | AAPL | Stock | 185.88 | 187.35 | 185.87 | 186.7443 | 5844105.0 |
| 2024-01-02 12:00:00 | AAPL | Stock | 186.75 | 187.04 | 185.8401 | 185.878 | 4879924.0 |
| 2024-01-02 13:00:00 | AAPL | Stock | 185.885 | 185.9576 | 184.745 | 184.9083 | 5229931.0 |
| 2024-01-02 14:00:00 | AAPL | Stock | 184.9025 | 184.98 | 184.01 | 184.05 | 5688115.0 |
| 2024-01-02 15:00:00 | AAPL | Stock | 184.045 | 185.64 | 183.885 | 185.525 | 12103059.0 |
| 2024-01-02 16:00:00 | AAPL | Stock | 185.51 | 185.93 | 185.42 | 185.43 | 10994718.0 |
| 2024-01-02 17:00:00 | AAPL | Stock | 185.43 | 185.64 | 185.3 | 185.57 | 76969.0 |
| 2024-01-02 18:00:00 | AAPL | Stock | 185.58 | 185.6 | 185.22 | 185.3081 | 52101.0 |
| 2024-01-02 19:00:00 | AAPL | Stock | 185.31 | 185.31 | 185.15 | 185.2 | 36170.0 |
| 2024-01-02 04:00:00 | MSFT | Stock | 376.73 | 376.81 | 376.29 | 376.29 | 921.0 |
| 2024-01-02 05:00:00 | MSFT | Stock | 376.04 | 376.04 | 375.0 | 375.0 | 900.0 |
| 2024-01-02 06:00:00 | MSFT | Stock | 375.08 | 375.11 | 373.0 | 373.25 | 24385.0 |
| 2024-01-02 07:00:00 | MSFT | Stock | 373.31 | 373.83 | 372.7 | 372.71 | 17364.0 |
| 2024-01-02 08:00:00 | MSFT | Stock | 373.53 | 376.66 | 372.71 | 373.3007 | 48089.0 |
| 2024-01-02 09:00:00 | MSFT | Stock | 373.56 | 376.04 | 366.771 | 367.6927 | 3010122.0 |
| 2024-01-02 10:00:00 | MSFT | Stock | 367.695 | 369.05 | 367.0 | 368.3 | 2190986.0 |
| 2024-01-02 11:00:00 | MSFT | Stock | 368.27 | 371.12 | 368.2449 | 370.8826 | 1390184.0 |
| 2024-01-02 12:00:00 | MSFT | Stock | 370.92 | 371.36 | 369.26 | 369.3528 | 1062185.0 |
| 2024-01-02 13:00:00 | MSFT | Stock | 369.37 | 370.2 | 369.14 | 369.51 | 757517.0 |
| 2024-01-02 14:00:00 | MSFT | Stock | 369.53 | 369.76 | 368.3375 | 368.38 | 956788.0 |
| 2024-01-02 15:00:00 | MSFT | Stock | 368.34 | 371.2 | 368.285 | 370.73 | 2869892.0 |
| 2024-01-02 16:00:00 | MSFT | Stock | 370.85 | 372.09 | 370.38 | 370.83 | 5358627.0 |
| 2024-01-02 17:00:00 | MSFT | Stock | 370.85 | 370.87 | 370.65 | 370.65 | 5163.0 |
| 2024-01-02 18:00:00 | MSFT | Stock | 370.86 | 370.86 | 369.56 | 369.99 | 8407.0 |
| 2024-01-02 19:00:00 | MSFT | Stock | 369.8 | 369.96 | 369.5 | 369.57 | 5640.0 |
| 2024-01-02 04:00:00 | NVDA | Stock | 49.374 | 49.535 | 49.374 | 49.483 | 72260.0 |
| 2024-01-02 05:00:00 | NVDA | Stock | 49.5 | 49.5 | 49.38 | 49.381 | 68560.0 |
| 2024-01-02 06:00:00 | NVDA | Stock | 49.376 | 49.381 | 48.83 | 48.985 | 312790.0 |
| 2024-01-02 07:00:00 | NVDA | Stock | 48.999 | 49.074 | 48.849 | 48.91 | 545530.0 |
| 2024-01-02 08:00:00 | NVDA | Stock | 49.012 | 49.608 | 48.836 | 49.33 | 2529650.0 |
| 2024-01-02 09:00:00 | NVDA | Stock | 49.3035 | 49.385 | 47.595 | 47.897 | 72788360.0 |
| 2024-01-02 10:00:00 | NVDA | Stock | 47.888 | 47.975 | 47.601 | 47.727 | 55112060.0 |
| 2024-01-02 11:00:00 | NVDA | Stock | 47.727 | 48.263 | 47.7131 | 48.232 | 41752160.0 |
| 2024-01-02 12:00:00 | NVDA | Stock | 48.235 | 48.348 | 48.04 | 48.09 | 27937080.0 |
| 2024-01-02 13:00:00 | NVDA | Stock | 48.0905 | 48.238 | 47.88 | 48.1719 | 28140860.0 |
| 2024-01-02 14:00:00 | NVDA | Stock | 48.175 | 48.24 | 48.0049 | 48.031 | 21898700.0 |
| 2024-01-02 15:00:00 | NVDA | Stock | 48.031 | 48.208 | 47.777 | 48.185 | 40107170.0 |
| 2024-01-02 16:00:00 | NVDA | Stock | 48.168 | 48.21 | 48.061 | 48.116 | 19487380.0 |
| 2024-01-02 17:00:00 | NVDA | Stock | 48.116 | 48.168 | 48.099 | 48.107 | 178760.0 |
| 2024-01-02 18:00:00 | NVDA | Stock | 48.1159 | 48.117 | 48.0 | 48.0 | 242220.0 |
| 2024-01-02 19:00:00 | NVDA | Stock | 47.987 | 48.0 | 47.89 | 47.932 | 350390.0 |
| 2024-01-02 04:00:00 | AMZN | Stock | 152.45 | 152.65 | 151.98 | 152.16 | 11822.0 |
| 2024-01-02 05:00:00 | AMZN | Stock | 152.1 | 152.1 | 151.84 | 151.84 | 12646.0 |
> showing 50 of 61,107 rows — these rows as CSV