PREVIEW / stock_1hour / 2024-05-20
file: by_date/stock_1hour/2024/2024-05-20.parquet size: 1.4 MB rows: 59,683 symbols: 969
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-05-20 04:00:00 | AAPL | Stock | 189.84 | 190.1 | 189.72 | 189.9 | 7209.0 |
| 2024-05-20 05:00:00 | AAPL | Stock | 189.79 | 189.79 | 188.53 | 188.66 | 31269.0 |
| 2024-05-20 06:00:00 | AAPL | Stock | 188.66 | 188.88 | 188.27 | 188.72 | 13879.0 |
| 2024-05-20 07:00:00 | AAPL | Stock | 188.75 | 189.2 | 188.75 | 189.02 | 29152.0 |
| 2024-05-20 08:00:00 | AAPL | Stock | 188.98 | 190.35 | 188.8 | 189.26 | 125069.0 |
| 2024-05-20 09:00:00 | AAPL | Stock | 189.3 | 190.905 | 188.87 | 190.9 | 4831095.0 |
| 2024-05-20 10:00:00 | AAPL | Stock | 190.91 | 191.9199 | 190.81 | 191.48 | 6971020.0 |
| 2024-05-20 11:00:00 | AAPL | Stock | 191.4798 | 191.67 | 191.08 | 191.275 | 2761315.0 |
| 2024-05-20 12:00:00 | AAPL | Stock | 191.27 | 191.68 | 191.02 | 191.615 | 2530841.0 |
| 2024-05-20 13:00:00 | AAPL | Stock | 191.615 | 191.81 | 191.38 | 191.51 | 2261943.0 |
| 2024-05-20 14:00:00 | AAPL | Stock | 191.51 | 191.53 | 191.13 | 191.1794 | 2162256.0 |
| 2024-05-20 15:00:00 | AAPL | Stock | 191.185 | 191.39 | 190.81 | 191.08 | 5339982.0 |
| 2024-05-20 16:00:00 | AAPL | Stock | 191.04 | 191.23 | 191.04 | 191.2 | 8615223.0 |
| 2024-05-20 17:00:00 | AAPL | Stock | 191.2 | 191.25 | 191.15 | 191.17 | 15151.0 |
| 2024-05-20 18:00:00 | AAPL | Stock | 191.17 | 191.33 | 191.04 | 191.12 | 23541.0 |
| 2024-05-20 19:00:00 | AAPL | Stock | 191.25 | 191.29 | 191.1 | 191.19 | 10230.0 |
| 2024-05-20 04:00:00 | MSFT | Stock | 420.46 | 421.61 | 420.46 | 420.6 | 2476.0 |
| 2024-05-20 05:00:00 | MSFT | Stock | 421.4 | 421.57 | 421.4 | 421.57 | 574.0 |
| 2024-05-20 06:00:00 | MSFT | Stock | 421.53 | 421.53 | 421.53 | 421.53 | 330.0 |
| 2024-05-20 07:00:00 | MSFT | Stock | 421.57 | 421.57 | 421.35 | 421.4 | 2135.0 |
| 2024-05-20 08:00:00 | MSFT | Stock | 421.3 | 421.67 | 420.56 | 421.0 | 29595.0 |
| 2024-05-20 09:00:00 | MSFT | Stock | 421.0 | 426.77 | 419.38 | 426.32 | 1775062.0 |
| 2024-05-20 10:00:00 | MSFT | Stock | 426.265 | 426.32 | 423.76 | 423.85 | 1227747.0 |
| 2024-05-20 11:00:00 | MSFT | Stock | 423.8 | 425.12 | 423.72 | 424.62 | 692829.0 |
| 2024-05-20 12:00:00 | MSFT | Stock | 424.64 | 425.72 | 424.64 | 425.66 | 564956.0 |
| 2024-05-20 13:00:00 | MSFT | Stock | 425.68 | 425.84 | 424.39 | 424.98 | 699438.0 |
| 2024-05-20 14:00:00 | MSFT | Stock | 424.97 | 425.1 | 423.85 | 424.45 | 458814.0 |
| 2024-05-20 15:00:00 | MSFT | Stock | 424.46 | 425.51 | 424.21 | 425.43 | 1257943.0 |
| 2024-05-20 16:00:00 | MSFT | Stock | 425.34 | 425.5 | 424.9202 | 425.09 | 1800568.0 |
| 2024-05-20 17:00:00 | MSFT | Stock | 425.06 | 425.1971 | 425.01 | 425.13 | 2640.0 |
| 2024-05-20 18:00:00 | MSFT | Stock | 425.227 | 425.34 | 425.01 | 425.01 | 10337.0 |
| 2024-05-20 19:00:00 | MSFT | Stock | 425.27 | 425.6 | 425.27 | 425.45 | 5046.0 |
| 2024-05-20 04:00:00 | NVDA | Stock | 93.38 | 93.637 | 92.71 | 93.5 | 244120.0 |
| 2024-05-20 05:00:00 | NVDA | Stock | 93.6 | 93.975 | 93.545 | 93.903 | 180280.0 |
| 2024-05-20 06:00:00 | NVDA | Stock | 93.91 | 93.91 | 93.681 | 93.77 | 85080.0 |
| 2024-05-20 07:00:00 | NVDA | Stock | 93.751 | 93.848 | 93.53 | 93.81 | 659800.0 |
| 2024-05-20 08:00:00 | NVDA | Stock | 93.8 | 93.835 | 93.05 | 93.7 | 2000400.0 |
| 2024-05-20 09:00:00 | NVDA | Stock | 93.7 | 95.088 | 93.44 | 94.954 | 47100890.0 |
| 2024-05-20 10:00:00 | NVDA | Stock | 94.968 | 95.2 | 94.418 | 94.6475 | 34886000.0 |
| 2024-05-20 11:00:00 | NVDA | Stock | 94.645 | 94.66 | 94.029 | 94.185 | 28740720.0 |
| 2024-05-20 12:00:00 | NVDA | Stock | 94.195 | 95.163 | 94.166 | 95.0571 | 27873860.0 |
| 2024-05-20 13:00:00 | NVDA | Stock | 95.041 | 95.142 | 94.636 | 94.745 | 21976510.0 |
| 2024-05-20 14:00:00 | NVDA | Stock | 94.74 | 95.194 | 94.5492 | 94.981 | 22279030.0 |
| 2024-05-20 15:00:00 | NVDA | Stock | 94.98 | 95.193 | 94.506 | 94.834 | 27747220.0 |
| 2024-05-20 16:00:00 | NVDA | Stock | 94.78 | 94.922 | 94.6742 | 94.863 | 11253210.0 |
| 2024-05-20 17:00:00 | NVDA | Stock | 94.884 | 94.975 | 94.806 | 94.806 | 295710.0 |
| 2024-05-20 18:00:00 | NVDA | Stock | 94.807 | 94.94 | 94.78 | 94.94 | 222580.0 |
| 2024-05-20 19:00:00 | NVDA | Stock | 94.941 | 95.058 | 94.941 | 95.035 | 362170.0 |
| 2024-05-20 04:00:00 | AMZN | Stock | 183.89 | 185.2 | 183.89 | 185.12 | 4890.0 |
| 2024-05-20 05:00:00 | AMZN | Stock | 185.08 | 185.3 | 185.08 | 185.3 | 5053.0 |
> showing 50 of 59,683 rows — these rows as CSV