PREVIEW / stock_1hour / 2022-11-23
file: by_date/stock_1hour/2022/2022-11-23.parquet size: 1.3 MB rows: 59,693 symbols: 2,057
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-23 04:00:00 | AAPL | Stock | 149.75 | 150.26 | 149.68 | 150.18 | 32386.0 |
| 2022-11-23 05:00:00 | AAPL | Stock | 150.08 | 150.09 | 149.75 | 149.8 | 14298.0 |
| 2022-11-23 06:00:00 | AAPL | Stock | 149.89 | 149.91 | 149.54 | 149.8 | 26011.0 |
| 2022-11-23 07:00:00 | AAPL | Stock | 149.82 | 150.0 | 149.62 | 149.87 | 86719.0 |
| 2022-11-23 08:00:00 | AAPL | Stock | 149.7 | 150.0 | 148.78 | 149.32 | 394169.0 |
| 2022-11-23 09:00:00 | AAPL | Stock | 149.32 | 151.4296 | 149.1 | 151.09 | 6746741.0 |
| 2022-11-23 10:00:00 | AAPL | Stock | 151.11 | 151.83 | 150.63 | 151.5811 | 7645315.0 |
| 2022-11-23 11:00:00 | AAPL | Stock | 151.59 | 151.76 | 149.79 | 150.1 | 6515500.0 |
| 2022-11-23 12:00:00 | AAPL | Stock | 150.09 | 150.42 | 149.34 | 149.645 | 4451307.0 |
| 2022-11-23 13:00:00 | AAPL | Stock | 149.64 | 150.46 | 149.53 | 150.304 | 3804863.0 |
| 2022-11-23 14:00:00 | AAPL | Stock | 150.29 | 151.31 | 149.76 | 150.98 | 6913628.0 |
| 2022-11-23 15:00:00 | AAPL | Stock | 150.99 | 151.42 | 150.63 | 151.14 | 8592410.0 |
| 2022-11-23 16:00:00 | AAPL | Stock | 151.14 | 151.19 | 151.0327 | 151.12 | 5945475.0 |
| 2022-11-23 17:00:00 | AAPL | Stock | 151.12 | 151.17 | 151.1 | 151.1601 | 30266.0 |
| 2022-11-23 18:00:00 | AAPL | Stock | 151.16 | 151.2 | 151.09 | 151.17 | 23160.0 |
| 2022-11-23 19:00:00 | AAPL | Stock | 151.17 | 151.21 | 151.11 | 151.15 | 30678.0 |
| 2022-11-23 04:00:00 | MSFT | Stock | 245.18 | 246.0 | 245.18 | 246.0 | 5213.0 |
| 2022-11-23 05:00:00 | MSFT | Stock | 246.0 | 246.03 | 245.49 | 245.49 | 21563.0 |
| 2022-11-23 06:00:00 | MSFT | Stock | 245.36 | 246.0 | 245.25 | 246.0 | 1615.0 |
| 2022-11-23 07:00:00 | MSFT | Stock | 246.0 | 246.0 | 245.5 | 245.75 | 7219.0 |
| 2022-11-23 08:00:00 | MSFT | Stock | 245.51 | 245.89 | 245.07 | 245.48 | 14279.0 |
| 2022-11-23 09:00:00 | MSFT | Stock | 245.63 | 246.789 | 244.27 | 246.41 | 2023149.0 |
| 2022-11-23 10:00:00 | MSFT | Stock | 246.44 | 247.64 | 245.8809 | 247.4 | 1827059.0 |
| 2022-11-23 11:00:00 | MSFT | Stock | 247.4 | 247.73 | 245.09 | 245.6443 | 1412650.0 |
| 2022-11-23 12:00:00 | MSFT | Stock | 245.62 | 246.415 | 245.02 | 245.33 | 1038914.0 |
| 2022-11-23 13:00:00 | MSFT | Stock | 245.32 | 247.09 | 245.17 | 246.675 | 755832.0 |
| 2022-11-23 14:00:00 | MSFT | Stock | 246.67 | 248.2302 | 246.02 | 247.735 | 1684209.0 |
| 2022-11-23 15:00:00 | MSFT | Stock | 247.73 | 248.28 | 247.145 | 247.76 | 1928477.0 |
| 2022-11-23 16:00:00 | MSFT | Stock | 247.58 | 247.79 | 247.49 | 247.7 | 3036086.0 |
| 2022-11-23 17:00:00 | MSFT | Stock | 247.9 | 247.9 | 247.58 | 247.85 | 3368.0 |
| 2022-11-23 18:00:00 | MSFT | Stock | 247.84 | 247.91 | 247.75 | 247.83 | 4059.0 |
| 2022-11-23 19:00:00 | MSFT | Stock | 248.09 | 248.3799 | 248.09 | 248.25 | 10345.0 |
| 2022-11-23 04:00:00 | NVDA | Stock | 16.055 | 16.199 | 16.055 | 16.197 | 174710.0 |
| 2022-11-23 05:00:00 | NVDA | Stock | 16.179 | 16.179 | 16.15 | 16.176 | 30750.0 |
| 2022-11-23 06:00:00 | NVDA | Stock | 16.185 | 16.185 | 16.142 | 16.178 | 70460.0 |
| 2022-11-23 07:00:00 | NVDA | Stock | 16.19 | 16.24 | 16.171 | 16.221 | 353810.0 |
| 2022-11-23 08:00:00 | NVDA | Stock | 16.175 | 16.246 | 15.967 | 16.125 | 1143170.0 |
| 2022-11-23 09:00:00 | NVDA | Stock | 16.115 | 16.357 | 16.048 | 16.34 | 55483630.0 |
| 2022-11-23 10:00:00 | NVDA | Stock | 16.345 | 16.453 | 16.256 | 16.43 | 62936090.0 |
| 2022-11-23 11:00:00 | NVDA | Stock | 16.43 | 16.511 | 16.2302 | 16.267 | 67651520.0 |
| 2022-11-23 12:00:00 | NVDA | Stock | 16.265 | 16.3316 | 16.1201 | 16.157 | 32521990.0 |
| 2022-11-23 13:00:00 | NVDA | Stock | 16.1578 | 16.3 | 16.13 | 16.293 | 23647270.0 |
| 2022-11-23 14:00:00 | NVDA | Stock | 16.293 | 16.475 | 16.203 | 16.449 | 53067320.0 |
| 2022-11-23 15:00:00 | NVDA | Stock | 16.45 | 16.527 | 16.425 | 16.526 | 48219370.0 |
| 2022-11-23 16:00:00 | NVDA | Stock | 16.519 | 16.551 | 16.519 | 16.55 | 16370060.0 |
| 2022-11-23 17:00:00 | NVDA | Stock | 16.551 | 16.569 | 16.535 | 16.569 | 301520.0 |
| 2022-11-23 18:00:00 | NVDA | Stock | 16.566 | 16.575 | 16.553 | 16.574 | 141260.0 |
| 2022-11-23 19:00:00 | NVDA | Stock | 16.575 | 16.589 | 16.56 | 16.589 | 176900.0 |
| 2022-11-23 04:00:00 | AMZN | Stock | 93.69 | 93.72 | 93.38 | 93.7 | 13982.0 |
| 2022-11-23 05:00:00 | AMZN | Stock | 93.65 | 93.67 | 93.48 | 93.48 | 7131.0 |
> showing 50 of 59,693 rows — these rows as CSV