PREVIEW / stock_1hour / 2024-06-07
file: by_date/stock_1hour/2024/2024-06-07.parquet size: 1.3 MB rows: 59,044 symbols: 963
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-06-07 04:00:00 | AAPL | Stock | 195.02 | 195.03 | 194.7 | 194.73 | 11656.0 |
| 2024-06-07 05:00:00 | AAPL | Stock | 194.7 | 194.92 | 194.7 | 194.89 | 1658.0 |
| 2024-06-07 06:00:00 | AAPL | Stock | 194.88 | 194.94 | 194.84 | 194.9 | 2659.0 |
| 2024-06-07 07:00:00 | AAPL | Stock | 194.97 | 195.12 | 194.73 | 195.12 | 31243.0 |
| 2024-06-07 08:00:00 | AAPL | Stock | 195.0 | 195.51 | 193.45 | 193.72 | 427112.0 |
| 2024-06-07 09:00:00 | AAPL | Stock | 193.65 | 195.75 | 193.6 | 194.68 | 5193146.0 |
| 2024-06-07 10:00:00 | AAPL | Stock | 194.69 | 195.97 | 194.58 | 195.63 | 5416723.0 |
| 2024-06-07 11:00:00 | AAPL | Stock | 195.64 | 195.94 | 194.91 | 195.85 | 4883254.0 |
| 2024-06-07 12:00:00 | AAPL | Stock | 195.86 | 196.41 | 195.63 | 196.32 | 4486318.0 |
| 2024-06-07 13:00:00 | AAPL | Stock | 196.32 | 196.58 | 195.96 | 196.505 | 3542805.0 |
| 2024-06-07 14:00:00 | AAPL | Stock | 196.5 | 196.52 | 195.58 | 195.86 | 4406083.0 |
| 2024-06-07 15:00:00 | AAPL | Stock | 195.87 | 196.94 | 195.77 | 196.9 | 8713604.0 |
| 2024-06-07 16:00:00 | AAPL | Stock | 196.86 | 196.95 | 196.7703 | 196.95 | 5669060.0 |
| 2024-06-07 17:00:00 | AAPL | Stock | 196.9501 | 196.97 | 196.53 | 196.74 | 76385.0 |
| 2024-06-07 18:00:00 | AAPL | Stock | 196.8266 | 196.8266 | 196.6569 | 196.78 | 20022.0 |
| 2024-06-07 19:00:00 | AAPL | Stock | 196.79 | 196.9 | 196.7 | 196.9 | 29123.0 |
| 2024-06-07 04:00:00 | MSFT | Stock | 424.89 | 424.89 | 424.0 | 424.0 | 1289.0 |
| 2024-06-07 05:00:00 | MSFT | Stock | 423.96 | 424.23 | 423.96 | 424.23 | 693.0 |
| 2024-06-07 06:00:00 | MSFT | Stock | 424.24 | 424.33 | 424.1 | 424.1 | 725.0 |
| 2024-06-07 07:00:00 | MSFT | Stock | 424.38 | 425.11 | 424.14 | 425.0 | 3202.0 |
| 2024-06-07 08:00:00 | MSFT | Stock | 424.4 | 426.25 | 423.05 | 424.2 | 37889.0 |
| 2024-06-07 09:00:00 | MSFT | Stock | 424.29 | 426.2 | 423.77 | 425.08 | 1110612.0 |
| 2024-06-07 10:00:00 | MSFT | Stock | 425.06 | 425.88 | 423.72 | 425.06 | 852836.0 |
| 2024-06-07 11:00:00 | MSFT | Stock | 425.1 | 425.53 | 423.66 | 425.21 | 695059.0 |
| 2024-06-07 12:00:00 | MSFT | Stock | 425.19 | 426.16 | 424.55 | 425.9401 | 589376.0 |
| 2024-06-07 13:00:00 | MSFT | Stock | 425.94 | 426.28 | 425.38 | 425.87 | 485123.0 |
| 2024-06-07 14:00:00 | MSFT | Stock | 425.8 | 425.86 | 423.72 | 424.8319 | 540533.0 |
| 2024-06-07 15:00:00 | MSFT | Stock | 424.82 | 425.06 | 423.0 | 423.82 | 1305481.0 |
| 2024-06-07 16:00:00 | MSFT | Stock | 423.85 | 424.05 | 423.51 | 424.05 | 3560072.0 |
| 2024-06-07 17:00:00 | MSFT | Stock | 424.0438 | 424.0438 | 423.3 | 423.3 | 569635.0 |
| 2024-06-07 18:00:00 | MSFT | Stock | 423.55 | 423.7819 | 423.3 | 423.3 | 3757.0 |
| 2024-06-07 19:00:00 | MSFT | Stock | 423.45 | 423.84 | 423.42 | 423.81 | 3573.0 |
| 2024-06-07 04:00:00 | NVDA | Stock | 121.1 | 121.9 | 120.516 | 121.52 | 356020.0 |
| 2024-06-07 05:00:00 | NVDA | Stock | 121.6 | 121.642 | 120.998 | 121.32 | 149010.0 |
| 2024-06-07 06:00:00 | NVDA | Stock | 121.3 | 121.35 | 120.855 | 120.855 | 122080.0 |
| 2024-06-07 07:00:00 | NVDA | Stock | 120.835 | 121.0 | 120.244 | 120.759 | 630490.0 |
| 2024-06-07 08:00:00 | NVDA | Stock | 120.66 | 121.667 | 117.71 | 118.96 | 6894720.0 |
| 2024-06-07 09:00:00 | NVDA | Stock | 118.84 | 119.84 | 118.022 | 119.124 | 46714960.0 |
| 2024-06-07 10:00:00 | NVDA | Stock | 119.127 | 119.484 | 118.6494 | 119.213 | 35170840.0 |
| 2024-06-07 11:00:00 | NVDA | Stock | 119.209 | 119.37 | 118.71 | 119.293 | 21927020.0 |
| 2024-06-07 12:00:00 | NVDA | Stock | 119.315 | 121.292 | 119.126 | 121.274 | 38430290.0 |
| 2024-06-07 13:00:00 | NVDA | Stock | 121.282 | 121.6917 | 120.835 | 121.0622 | 28305400.0 |
| 2024-06-07 14:00:00 | NVDA | Stock | 121.046 | 121.046 | 119.405 | 120.625 | 31800430.0 |
| 2024-06-07 15:00:00 | NVDA | Stock | 120.625 | 121.5 | 120.035 | 120.865 | 40710690.0 |
| 2024-06-07 16:00:00 | NVDA | Stock | 120.888 | 121.171 | 120.801 | 120.831 | 13110720.0 |
| 2024-06-07 17:00:00 | NVDA | Stock | 120.806 | 120.888 | 120.22 | 120.71 | 2217730.0 |
| 2024-06-07 18:00:00 | NVDA | Stock | 120.662 | 120.698 | 120.401 | 120.5603 | 274800.0 |
| 2024-06-07 19:00:00 | NVDA | Stock | 120.526 | 120.955 | 120.521 | 120.775 | 423820.0 |
| 2024-06-07 04:00:00 | AMZN | Stock | 184.84 | 184.84 | 184.63 | 184.63 | 4051.0 |
| 2024-06-07 05:00:00 | AMZN | Stock | 184.72 | 184.98 | 184.72 | 184.9 | 1934.0 |
> showing 50 of 59,044 rows — these rows as CSV