PREVIEW / stock_1hour / 2024-05-28
file: by_date/stock_1hour/2024/2024-05-28.parquet size: 1.4 MB rows: 60,303 symbols: 968
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-28 04:00:00 | AAPL | Stock | 190.8 | 194.29 | 190.59 | 194.29 | 188250.0 |
| 2024-05-28 05:00:00 | AAPL | Stock | 194.2 | 194.81 | 194.0 | 194.5 | 74357.0 |
| 2024-05-28 06:00:00 | AAPL | Stock | 194.6 | 194.62 | 193.66 | 193.7 | 67023.0 |
| 2024-05-28 07:00:00 | AAPL | Stock | 193.69 | 193.96 | 193.45 | 193.5 | 142295.0 |
| 2024-05-28 08:00:00 | AAPL | Stock | 193.56 | 194.5202 | 190.69 | 192.98 | 325641.0 |
| 2024-05-28 09:00:00 | AAPL | Stock | 192.96 | 193.0 | 190.33 | 191.05 | 8180134.0 |
| 2024-05-28 10:00:00 | AAPL | Stock | 191.05 | 192.1 | 191.0 | 191.645 | 5711227.0 |
| 2024-05-28 11:00:00 | AAPL | Stock | 191.66 | 191.95 | 191.31 | 191.475 | 3388748.0 |
| 2024-05-28 12:00:00 | AAPL | Stock | 191.47 | 191.76 | 191.06 | 191.3057 | 3077945.0 |
| 2024-05-28 13:00:00 | AAPL | Stock | 191.305 | 191.35 | 190.19 | 190.3222 | 2964991.0 |
| 2024-05-28 14:00:00 | AAPL | Stock | 190.33 | 190.49 | 189.1 | 189.72 | 4437526.0 |
| 2024-05-28 15:00:00 | AAPL | Stock | 189.72 | 190.11 | 189.33 | 190.1 | 6069369.0 |
| 2024-05-28 16:00:00 | AAPL | Stock | 190.13 | 190.24 | 189.91 | 190.03 | 7600017.0 |
| 2024-05-28 17:00:00 | AAPL | Stock | 190.0399 | 190.13 | 189.99 | 190.02 | 29979.0 |
| 2024-05-28 18:00:00 | AAPL | Stock | 190.03 | 190.13 | 189.97 | 190.02 | 24869.0 |
| 2024-05-28 19:00:00 | AAPL | Stock | 190.0 | 190.23 | 189.99 | 190.15 | 46773.0 |
| 2024-05-28 04:00:00 | MSFT | Stock | 430.84 | 430.84 | 430.31 | 430.6 | 5763.0 |
| 2024-05-28 05:00:00 | MSFT | Stock | 430.81 | 430.81 | 430.37 | 430.5 | 1964.0 |
| 2024-05-28 06:00:00 | MSFT | Stock | 430.3 | 430.3 | 428.08 | 428.08 | 8292.0 |
| 2024-05-28 07:00:00 | MSFT | Stock | 428.67 | 430.0 | 428.5 | 430.0 | 14367.0 |
| 2024-05-28 08:00:00 | MSFT | Stock | 428.79 | 431.54 | 428.45 | 429.7458 | 42587.0 |
| 2024-05-28 09:00:00 | MSFT | Stock | 429.7738 | 430.82 | 426.6 | 428.005 | 1867638.0 |
| 2024-05-28 10:00:00 | MSFT | Stock | 427.96 | 429.91 | 427.6201 | 428.59 | 1327718.0 |
| 2024-05-28 11:00:00 | MSFT | Stock | 428.6205 | 429.32 | 427.98 | 428.425 | 693854.0 |
| 2024-05-28 12:00:00 | MSFT | Stock | 428.48 | 429.15 | 428.34 | 428.79 | 531563.0 |
| 2024-05-28 13:00:00 | MSFT | Stock | 428.81 | 429.35 | 428.41 | 428.7301 | 500683.0 |
| 2024-05-28 14:00:00 | MSFT | Stock | 428.74 | 429.34 | 427.92 | 428.82 | 749085.0 |
| 2024-05-28 15:00:00 | MSFT | Stock | 428.81 | 430.46 | 428.52 | 430.33 | 1493599.0 |
| 2024-05-28 16:00:00 | MSFT | Stock | 430.3 | 430.32 | 429.35 | 429.7 | 2755850.0 |
| 2024-05-28 17:00:00 | MSFT | Stock | 429.7 | 430.08 | 429.7 | 430.04 | 6181.0 |
| 2024-05-28 18:00:00 | MSFT | Stock | 429.82 | 430.32 | 429.55 | 429.7 | 8040.0 |
| 2024-05-28 19:00:00 | MSFT | Stock | 429.79 | 429.79 | 429.5 | 429.5 | 748.0 |
| 2024-05-28 04:00:00 | NVDA | Stock | 109.568 | 110.0 | 109.0 | 109.496 | 803440.0 |
| 2024-05-28 05:00:00 | NVDA | Stock | 109.463 | 109.463 | 109.0 | 109.35 | 199040.0 |
| 2024-05-28 06:00:00 | NVDA | Stock | 109.25 | 109.277 | 108.563 | 108.563 | 224120.0 |
| 2024-05-28 07:00:00 | NVDA | Stock | 108.563 | 109.727 | 108.523 | 109.56 | 1808270.0 |
| 2024-05-28 08:00:00 | NVDA | Stock | 108.642 | 110.5 | 108.52 | 109.6707 | 3666730.0 |
| 2024-05-28 09:00:00 | NVDA | Stock | 109.671 | 112.162 | 109.46 | 111.6555 | 82520950.0 |
| 2024-05-28 10:00:00 | NVDA | Stock | 111.656 | 112.4 | 110.878 | 112.145 | 57285920.0 |
| 2024-05-28 11:00:00 | NVDA | Stock | 112.159 | 112.588 | 111.547 | 112.55 | 39686780.0 |
| 2024-05-28 12:00:00 | NVDA | Stock | 112.536 | 114.077 | 112.458 | 113.8566 | 49751340.0 |
| 2024-05-28 13:00:00 | NVDA | Stock | 113.8782 | 114.939 | 113.304 | 113.304 | 51127170.0 |
| 2024-05-28 14:00:00 | NVDA | Stock | 113.3154 | 114.059 | 112.4 | 113.4852 | 47941410.0 |
| 2024-05-28 15:00:00 | NVDA | Stock | 113.465 | 114.447 | 112.9312 | 113.914 | 59691580.0 |
| 2024-05-28 16:00:00 | NVDA | Stock | 113.887 | 114.688 | 113.811 | 114.375 | 21714960.0 |
| 2024-05-28 17:00:00 | NVDA | Stock | 114.375 | 114.755 | 113.901 | 114.664 | 11848980.0 |
| 2024-05-28 18:00:00 | NVDA | Stock | 114.673 | 114.8595 | 113.901 | 114.82 | 934960.0 |
| 2024-05-28 19:00:00 | NVDA | Stock | 114.826 | 115.0 | 114.725 | 115.0 | 1199240.0 |
| 2024-05-28 04:00:00 | AMZN | Stock | 181.13 | 181.76 | 181.05 | 181.62 | 14774.0 |
| 2024-05-28 05:00:00 | AMZN | Stock | 181.61 | 181.64 | 181.2 | 181.56 | 9551.0 |
> showing 50 of 60,303 rows — these rows as CSV