PREVIEW / stock_1hour / 2022-12-08
file: by_date/stock_1hour/2022/2022-12-08.parquet size: 1.4 MB rows: 60,505 symbols: 2,060
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 |
|---|---|---|---|---|---|---|---|
| 2022-12-08 04:00:00 | AAPL | Stock | 141.46 | 141.58 | 141.02 | 141.41 | 13715.0 |
| 2022-12-08 05:00:00 | AAPL | Stock | 141.41 | 141.5 | 141.22 | 141.3 | 13366.0 |
| 2022-12-08 06:00:00 | AAPL | Stock | 141.24 | 141.64 | 141.11 | 141.61 | 12338.0 |
| 2022-12-08 07:00:00 | AAPL | Stock | 141.5 | 142.21 | 141.39 | 142.05 | 87577.0 |
| 2022-12-08 08:00:00 | AAPL | Stock | 141.34 | 142.75 | 140.5 | 142.57 | 298195.0 |
| 2022-12-08 09:00:00 | AAPL | Stock | 142.58 | 142.78 | 141.1 | 142.46 | 6823263.0 |
| 2022-12-08 10:00:00 | AAPL | Stock | 142.47 | 143.52 | 142.17 | 142.99 | 8648514.0 |
| 2022-12-08 11:00:00 | AAPL | Stock | 143.01 | 143.24 | 142.15 | 142.8041 | 6068277.0 |
| 2022-12-08 12:00:00 | AAPL | Stock | 142.8026 | 143.05 | 141.88 | 142.43 | 4586748.0 |
| 2022-12-08 13:00:00 | AAPL | Stock | 142.425 | 143.27 | 142.19 | 142.6101 | 4194723.0 |
| 2022-12-08 14:00:00 | AAPL | Stock | 142.6145 | 142.73 | 141.55 | 142.42 | 6120754.0 |
| 2022-12-08 15:00:00 | AAPL | Stock | 142.42 | 142.9999 | 142.07 | 142.67 | 7993330.0 |
| 2022-12-08 16:00:00 | AAPL | Stock | 142.66 | 143.02 | 142.52 | 142.71 | 8845436.0 |
| 2022-12-08 17:00:00 | AAPL | Stock | 142.7 | 142.79 | 142.6 | 142.68 | 14029.0 |
| 2022-12-08 18:00:00 | AAPL | Stock | 142.7 | 142.9 | 142.62 | 142.73 | 28362.0 |
| 2022-12-08 19:00:00 | AAPL | Stock | 142.73 | 142.73 | 142.37 | 142.7 | 18586.0 |
| 2022-12-08 04:00:00 | MSFT | Stock | 244.53 | 244.6 | 244.45 | 244.45 | 3623.0 |
| 2022-12-08 05:00:00 | MSFT | Stock | 244.43 | 244.66 | 244.29 | 244.29 | 652.0 |
| 2022-12-08 06:00:00 | MSFT | Stock | 244.4 | 244.64 | 244.03 | 244.6 | 1561.0 |
| 2022-12-08 07:00:00 | MSFT | Stock | 244.4 | 244.86 | 244.06 | 244.85 | 8036.0 |
| 2022-12-08 08:00:00 | MSFT | Stock | 244.31 | 245.78 | 244.25 | 244.9102 | 34958.0 |
| 2022-12-08 09:00:00 | MSFT | Stock | 245.25 | 245.99 | 243.06 | 245.93 | 2145024.0 |
| 2022-12-08 10:00:00 | MSFT | Stock | 245.925 | 247.3 | 245.7087 | 246.905 | 2383080.0 |
| 2022-12-08 11:00:00 | MSFT | Stock | 246.92 | 247.75 | 245.84 | 247.29 | 1551854.0 |
| 2022-12-08 12:00:00 | MSFT | Stock | 247.27 | 247.66 | 246.7 | 247.5216 | 1232482.0 |
| 2022-12-08 13:00:00 | MSFT | Stock | 247.53 | 248.74 | 247.24 | 248.1767 | 1460878.0 |
| 2022-12-08 14:00:00 | MSFT | Stock | 248.16 | 248.16 | 246.09 | 246.83 | 2301673.0 |
| 2022-12-08 15:00:00 | MSFT | Stock | 246.81 | 247.93 | 246.08 | 247.4 | 3037692.0 |
| 2022-12-08 16:00:00 | MSFT | Stock | 247.4 | 247.46 | 246.51 | 246.8 | 4404734.0 |
| 2022-12-08 17:00:00 | MSFT | Stock | 246.94 | 247.1499 | 246.88 | 247.1499 | 3452.0 |
| 2022-12-08 18:00:00 | MSFT | Stock | 247.0 | 247.28 | 246.81 | 246.96 | 2026.0 |
| 2022-12-08 19:00:00 | MSFT | Stock | 246.5 | 246.73 | 246.25 | 246.4 | 6341.0 |
| 2022-12-08 04:00:00 | NVDA | Stock | 16.174 | 16.199 | 16.155 | 16.173 | 44150.0 |
| 2022-12-08 05:00:00 | NVDA | Stock | 16.17 | 16.17 | 16.13 | 16.13 | 64790.0 |
| 2022-12-08 06:00:00 | NVDA | Stock | 16.136 | 16.144 | 16.117 | 16.136 | 25300.0 |
| 2022-12-08 07:00:00 | NVDA | Stock | 16.138 | 16.23 | 16.13 | 16.215 | 206090.0 |
| 2022-12-08 08:00:00 | NVDA | Stock | 16.162 | 16.285 | 16.1323 | 16.275 | 791910.0 |
| 2022-12-08 09:00:00 | NVDA | Stock | 16.272 | 16.328 | 15.959 | 16.3 | 54633590.0 |
| 2022-12-08 10:00:00 | NVDA | Stock | 16.3 | 16.89 | 16.278 | 16.749 | 101794600.0 |
| 2022-12-08 11:00:00 | NVDA | Stock | 16.7495 | 16.8259 | 16.627 | 16.788 | 48540810.0 |
| 2022-12-08 12:00:00 | NVDA | Stock | 16.789 | 16.838 | 16.698 | 16.835 | 31585730.0 |
| 2022-12-08 13:00:00 | NVDA | Stock | 16.837 | 16.947 | 16.8 | 16.907 | 40465880.0 |
| 2022-12-08 14:00:00 | NVDA | Stock | 16.9077 | 17.058 | 16.8038 | 17.024 | 48293330.0 |
| 2022-12-08 15:00:00 | NVDA | Stock | 17.024 | 17.179 | 16.961 | 17.178 | 71288640.0 |
| 2022-12-08 16:00:00 | NVDA | Stock | 17.179 | 17.192 | 17.135 | 17.153 | 29329790.0 |
| 2022-12-08 17:00:00 | NVDA | Stock | 17.15 | 17.164 | 17.15 | 17.153 | 224180.0 |
| 2022-12-08 18:00:00 | NVDA | Stock | 17.159 | 17.2 | 17.156 | 17.195 | 314260.0 |
| 2022-12-08 19:00:00 | NVDA | Stock | 17.19 | 17.193 | 17.16 | 17.175 | 242580.0 |
| 2022-12-08 04:00:00 | AMZN | Stock | 88.92 | 89.25 | 88.92 | 89.04 | 12494.0 |
| 2022-12-08 05:00:00 | AMZN | Stock | 89.13 | 89.28 | 88.99 | 89.1 | 13435.0 |
> showing 50 of 60,505 rows — these rows as CSV