PREVIEW / stock_1hour / 2024-06-20
file: by_date/stock_1hour/2024/2024-06-20.parquet size: 1.4 MB rows: 60,110 symbols: 957
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-20 04:00:00 | AAPL | Stock | 215.31 | 215.31 | 214.19 | 214.62 | 47822.0 |
| 2024-06-20 05:00:00 | AAPL | Stock | 214.66 | 214.75 | 214.5 | 214.65 | 14055.0 |
| 2024-06-20 06:00:00 | AAPL | Stock | 214.69 | 214.75 | 213.91 | 214.37 | 20580.0 |
| 2024-06-20 07:00:00 | AAPL | Stock | 214.36 | 214.5 | 213.5 | 213.65 | 55543.0 |
| 2024-06-20 08:00:00 | AAPL | Stock | 214.3 | 214.7755 | 213.2 | 213.7 | 254575.0 |
| 2024-06-20 09:00:00 | AAPL | Stock | 213.67 | 214.24 | 212.27 | 212.8168 | 8778452.0 |
| 2024-06-20 10:00:00 | AAPL | Stock | 212.82 | 213.15 | 210.1 | 211.21 | 11175110.0 |
| 2024-06-20 11:00:00 | AAPL | Stock | 211.22 | 211.33 | 209.42 | 210.8738 | 9247329.0 |
| 2024-06-20 12:00:00 | AAPL | Stock | 210.88 | 211.04 | 209.3205 | 209.895 | 5834270.0 |
| 2024-06-20 13:00:00 | AAPL | Stock | 209.895 | 210.35 | 209.13 | 209.8 | 5037237.0 |
| 2024-06-20 14:00:00 | AAPL | Stock | 209.79 | 210.61 | 209.43 | 210.022 | 5394080.0 |
| 2024-06-20 15:00:00 | AAPL | Stock | 210.02 | 210.05 | 208.85 | 209.56 | 11022556.0 |
| 2024-06-20 16:00:00 | AAPL | Stock | 209.56 | 210.05 | 209.56 | 209.95 | 9909275.0 |
| 2024-06-20 17:00:00 | AAPL | Stock | 209.95 | 209.96 | 209.5 | 209.5 | 66897.0 |
| 2024-06-20 18:00:00 | AAPL | Stock | 209.69 | 210.18 | 209.51 | 210.02 | 32727.0 |
| 2024-06-20 19:00:00 | AAPL | Stock | 210.04 | 210.1 | 209.75 | 210.0 | 28263.0 |
| 2024-06-20 04:00:00 | MSFT | Stock | 448.0 | 448.58 | 447.2 | 448.2 | 5010.0 |
| 2024-06-20 05:00:00 | MSFT | Stock | 448.09 | 448.64 | 448.0 | 448.6 | 4228.0 |
| 2024-06-20 06:00:00 | MSFT | Stock | 448.54 | 449.3 | 448.54 | 449.05 | 2061.0 |
| 2024-06-20 07:00:00 | MSFT | Stock | 448.63 | 448.87 | 446.81 | 447.22 | 15445.0 |
| 2024-06-20 08:00:00 | MSFT | Stock | 448.61 | 449.115 | 445.5 | 446.62 | 67232.0 |
| 2024-06-20 09:00:00 | MSFT | Stock | 446.62 | 446.62 | 441.27 | 442.47 | 2055594.0 |
| 2024-06-20 10:00:00 | MSFT | Stock | 442.3814 | 444.13 | 441.89 | 443.55 | 1811005.0 |
| 2024-06-20 11:00:00 | MSFT | Stock | 443.55 | 445.82 | 443.05 | 444.29 | 1341079.0 |
| 2024-06-20 12:00:00 | MSFT | Stock | 444.31 | 445.47 | 442.96 | 444.4577 | 869671.0 |
| 2024-06-20 13:00:00 | MSFT | Stock | 444.44 | 445.15 | 443.85 | 444.44 | 818791.0 |
| 2024-06-20 14:00:00 | MSFT | Stock | 444.44 | 445.22 | 444.37 | 444.61 | 964315.0 |
| 2024-06-20 15:00:00 | MSFT | Stock | 444.66 | 446.06 | 443.8 | 445.785 | 1788448.0 |
| 2024-06-20 16:00:00 | MSFT | Stock | 445.7 | 446.3 | 445.4 | 445.7027 | 3976610.0 |
| 2024-06-20 17:00:00 | MSFT | Stock | 445.85 | 445.85 | 445.0264 | 445.45 | 7624.0 |
| 2024-06-20 18:00:00 | MSFT | Stock | 445.48 | 446.56 | 445.45 | 445.7 | 16034.0 |
| 2024-06-20 19:00:00 | MSFT | Stock | 446.47 | 446.51 | 446.06 | 446.12 | 4229.0 |
| 2024-06-20 04:00:00 | NVDA | Stock | 141.09 | 141.09 | 139.46 | 140.35 | 1469963.0 |
| 2024-06-20 05:00:00 | NVDA | Stock | 140.39 | 140.4 | 139.1 | 139.34 | 909767.0 |
| 2024-06-20 06:00:00 | NVDA | Stock | 139.36 | 139.49 | 138.55 | 139.29 | 995144.0 |
| 2024-06-20 07:00:00 | NVDA | Stock | 139.25 | 140.5 | 139.0 | 140.0 | 3083783.0 |
| 2024-06-20 08:00:00 | NVDA | Stock | 139.27 | 141.6 | 138.5712 | 140.56 | 8187837.0 |
| 2024-06-20 09:00:00 | NVDA | Stock | 140.56 | 140.76 | 138.59 | 139.9999 | 65649654.0 |
| 2024-06-20 10:00:00 | NVDA | Stock | 140.0 | 140.25 | 136.13 | 139.0 | 71862125.0 |
| 2024-06-20 11:00:00 | NVDA | Stock | 139.0 | 139.53 | 137.36 | 137.405 | 33940499.0 |
| 2024-06-20 12:00:00 | NVDA | Stock | 137.41 | 137.47 | 130.49 | 133.484 | 74823792.0 |
| 2024-06-20 13:00:00 | NVDA | Stock | 133.49 | 133.5 | 129.52 | 131.9905 | 64152525.0 |
| 2024-06-20 14:00:00 | NVDA | Stock | 132.0 | 133.3 | 131.09 | 131.12 | 38086426.0 |
| 2024-06-20 15:00:00 | NVDA | Stock | 131.12 | 132.55 | 129.82 | 130.72 | 54357074.0 |
| 2024-06-20 16:00:00 | NVDA | Stock | 130.75 | 131.18 | 129.69 | 130.69 | 28003960.0 |
| 2024-06-20 17:00:00 | NVDA | Stock | 130.69 | 130.78 | 129.73 | 129.95 | 4380200.0 |
| 2024-06-20 18:00:00 | NVDA | Stock | 129.94 | 130.78 | 129.86 | 130.19 | 959658.0 |
| 2024-06-20 19:00:00 | NVDA | Stock | 130.17 | 130.44 | 130.0516 | 130.2 | 1087864.0 |
| 2024-06-20 04:00:00 | AMZN | Stock | 182.94 | 183.48 | 182.94 | 183.45 | 18607.0 |
| 2024-06-20 05:00:00 | AMZN | Stock | 183.37 | 183.47 | 183.34 | 183.45 | 4981.0 |
> showing 50 of 60,110 rows — these rows as CSV