PREVIEW / stock_1hour / 2022-11-11
file: by_date/stock_1hour/2022/2022-11-11.parquet size: 1.4 MB rows: 62,014 symbols: 2,071
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-11-11 04:00:00 | AAPL | Stock | 148.06 | 148.74 | 147.74 | 147.97 | 88289.0 |
| 2022-11-11 05:00:00 | AAPL | Stock | 147.97 | 147.99 | 147.4 | 147.52 | 107806.0 |
| 2022-11-11 06:00:00 | AAPL | Stock | 147.5 | 147.64 | 147.29 | 147.39 | 75071.0 |
| 2022-11-11 07:00:00 | AAPL | Stock | 147.43 | 147.52 | 146.9 | 147.43 | 182846.0 |
| 2022-11-11 08:00:00 | AAPL | Stock | 147.35 | 148.33 | 146.91 | 147.25 | 407592.0 |
| 2022-11-11 09:00:00 | AAPL | Stock | 147.22 | 147.22 | 144.37 | 145.44 | 10915261.0 |
| 2022-11-11 10:00:00 | AAPL | Stock | 145.42 | 148.57 | 144.7501 | 148.115 | 13220174.0 |
| 2022-11-11 11:00:00 | AAPL | Stock | 148.12 | 148.75 | 146.43 | 147.38 | 9820326.0 |
| 2022-11-11 12:00:00 | AAPL | Stock | 147.38 | 148.52 | 147.17 | 148.2501 | 6752448.0 |
| 2022-11-11 13:00:00 | AAPL | Stock | 148.255 | 149.74 | 148.22 | 149.605 | 7871843.0 |
| 2022-11-11 14:00:00 | AAPL | Stock | 149.6039 | 150.01 | 149.44 | 149.98 | 7717471.0 |
| 2022-11-11 15:00:00 | AAPL | Stock | 149.99 | 150.0 | 148.7603 | 149.7 | 14418727.0 |
| 2022-11-11 16:00:00 | AAPL | Stock | 149.63 | 149.7 | 149.37 | 149.42 | 11637646.0 |
| 2022-11-11 17:00:00 | AAPL | Stock | 149.39 | 149.7 | 149.39 | 149.43 | 72459.0 |
| 2022-11-11 18:00:00 | AAPL | Stock | 149.48 | 149.48 | 149.37 | 149.37 | 34672.0 |
| 2022-11-11 19:00:00 | AAPL | Stock | 149.3999 | 149.45 | 149.37 | 149.44 | 34633.0 |
| 2022-11-11 04:00:00 | MSFT | Stock | 244.86 | 245.5 | 244.61 | 244.7 | 4235.0 |
| 2022-11-11 05:00:00 | MSFT | Stock | 244.71 | 244.85 | 244.01 | 244.01 | 4194.0 |
| 2022-11-11 06:00:00 | MSFT | Stock | 244.03 | 244.2 | 243.35 | 243.4 | 7047.0 |
| 2022-11-11 07:00:00 | MSFT | Stock | 243.7 | 244.21 | 243.4 | 244.2 | 23477.0 |
| 2022-11-11 08:00:00 | MSFT | Stock | 243.5198 | 244.47 | 243.2103 | 243.5 | 67090.0 |
| 2022-11-11 09:00:00 | MSFT | Stock | 243.5 | 244.98 | 241.18 | 243.675 | 2857170.0 |
| 2022-11-11 10:00:00 | MSFT | Stock | 243.62 | 246.62 | 242.4705 | 245.695 | 3335652.0 |
| 2022-11-11 11:00:00 | MSFT | Stock | 245.7 | 246.09 | 242.42 | 244.505 | 3025615.0 |
| 2022-11-11 12:00:00 | MSFT | Stock | 244.49 | 247.08 | 243.9 | 246.4655 | 2251875.0 |
| 2022-11-11 13:00:00 | MSFT | Stock | 246.47 | 247.99 | 246.43 | 247.55 | 1826651.0 |
| 2022-11-11 14:00:00 | MSFT | Stock | 247.56 | 247.67 | 246.52 | 247.19 | 2119981.0 |
| 2022-11-11 15:00:00 | MSFT | Stock | 247.2 | 247.89 | 245.95 | 247.32 | 4474750.0 |
| 2022-11-11 16:00:00 | MSFT | Stock | 247.19 | 247.19 | 246.53 | 246.8495 | 4618476.0 |
| 2022-11-11 17:00:00 | MSFT | Stock | 246.8408 | 246.9999 | 246.8408 | 246.88 | 3976.0 |
| 2022-11-11 18:00:00 | MSFT | Stock | 246.99 | 247.09 | 246.86 | 247.0 | 3457.0 |
| 2022-11-11 19:00:00 | MSFT | Stock | 247.07 | 247.11 | 246.8901 | 247.0 | 9553.0 |
| 2022-11-11 04:00:00 | NVDA | Stock | 15.862 | 16.039 | 15.862 | 15.968 | 467660.0 |
| 2022-11-11 05:00:00 | NVDA | Stock | 15.968 | 15.989 | 15.92 | 15.944 | 91670.0 |
| 2022-11-11 06:00:00 | NVDA | Stock | 15.932 | 16.035 | 15.9 | 15.94 | 454020.0 |
| 2022-11-11 07:00:00 | NVDA | Stock | 15.944 | 15.985 | 15.885 | 15.966 | 695510.0 |
| 2022-11-11 08:00:00 | NVDA | Stock | 15.91 | 16.044 | 15.7 | 16.0 | 2753590.0 |
| 2022-11-11 09:00:00 | NVDA | Stock | 15.986 | 16.059 | 15.482 | 15.857 | 102927750.0 |
| 2022-11-11 10:00:00 | NVDA | Stock | 15.855 | 16.126 | 15.7258 | 16.039 | 84939670.0 |
| 2022-11-11 11:00:00 | NVDA | Stock | 16.04 | 16.124 | 15.763 | 16.019 | 71843480.0 |
| 2022-11-11 12:00:00 | NVDA | Stock | 16.02 | 16.095 | 15.9326 | 16.07 | 47559210.0 |
| 2022-11-11 13:00:00 | NVDA | Stock | 16.07 | 16.304 | 16.069 | 16.196 | 59938860.0 |
| 2022-11-11 14:00:00 | NVDA | Stock | 16.196 | 16.389 | 16.14 | 16.358 | 60767840.0 |
| 2022-11-11 15:00:00 | NVDA | Stock | 16.361 | 16.373 | 16.117 | 16.331 | 83399500.0 |
| 2022-11-11 16:00:00 | NVDA | Stock | 16.33 | 16.34 | 16.294 | 16.327 | 31203340.0 |
| 2022-11-11 17:00:00 | NVDA | Stock | 16.308 | 16.33 | 16.285 | 16.33 | 823080.0 |
| 2022-11-11 18:00:00 | NVDA | Stock | 16.326 | 16.335 | 16.321 | 16.321 | 160920.0 |
| 2022-11-11 19:00:00 | NVDA | Stock | 16.312 | 16.33 | 16.31 | 16.312 | 209820.0 |
| 2022-11-11 04:00:00 | AMZN | Stock | 98.62 | 98.62 | 97.56 | 98.15 | 108577.0 |
| 2022-11-11 05:00:00 | AMZN | Stock | 98.17 | 98.3 | 97.6 | 97.89 | 112298.0 |
> showing 50 of 62,014 rows — these rows as CSV