PREVIEW / stock_1hour / 2024-10-28
file: by_date/stock_1hour/2024/2024-10-28.parquet size: 1.4 MB rows: 60,995 symbols: 741
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-10-28 04:00:00 | AAPL | Stock | 232.91 | 233.1 | 232.35 | 233.04 | 22405.0 |
| 2024-10-28 05:00:00 | AAPL | Stock | 233.04 | 233.11 | 232.82 | 232.92 | 15298.0 |
| 2024-10-28 06:00:00 | AAPL | Stock | 233.0 | 233.0 | 232.2 | 232.2 | 40762.0 |
| 2024-10-28 07:00:00 | AAPL | Stock | 232.21 | 232.37 | 231.72 | 232.37 | 47698.0 |
| 2024-10-28 08:00:00 | AAPL | Stock | 232.14 | 232.99 | 230.832 | 232.634 | 99938.0 |
| 2024-10-28 09:00:00 | AAPL | Stock | 232.69 | 234.55 | 232.37 | 233.18 | 3356931.0 |
| 2024-10-28 10:00:00 | AAPL | Stock | 233.18 | 234.33 | 232.9 | 233.93 | 2805979.0 |
| 2024-10-28 11:00:00 | AAPL | Stock | 233.935 | 234.18 | 233.22 | 233.57 | 2227336.0 |
| 2024-10-28 12:00:00 | AAPL | Stock | 233.545 | 234.73 | 233.15 | 234.31 | 2467436.0 |
| 2024-10-28 13:00:00 | AAPL | Stock | 234.3053 | 234.68 | 234.065 | 234.395 | 1460771.0 |
| 2024-10-28 14:00:00 | AAPL | Stock | 234.395 | 234.4 | 233.57 | 233.76 | 1368898.0 |
| 2024-10-28 15:00:00 | AAPL | Stock | 233.76 | 234.01 | 232.92 | 233.49 | 3731457.0 |
| 2024-10-28 16:00:00 | AAPL | Stock | 233.14 | 233.57 | 232.9 | 232.9 | 6846300.0 |
| 2024-10-28 17:00:00 | AAPL | Stock | 232.89 | 233.4 | 232.6527 | 232.9398 | 54988.0 |
| 2024-10-28 18:00:00 | AAPL | Stock | 232.95 | 232.95 | 232.55 | 232.65 | 25525.0 |
| 2024-10-28 19:00:00 | AAPL | Stock | 232.6778 | 232.75 | 232.43 | 232.5 | 21961.0 |
| 2024-10-28 04:00:00 | MSFT | Stock | 430.7 | 432.3 | 430.2 | 432.28 | 18387.0 |
| 2024-10-28 05:00:00 | MSFT | Stock | 432.3 | 432.5 | 432.11 | 432.11 | 9877.0 |
| 2024-10-28 06:00:00 | MSFT | Stock | 432.02 | 432.79 | 431.97 | 431.99 | 8918.0 |
| 2024-10-28 07:00:00 | MSFT | Stock | 432.0 | 432.0 | 430.92 | 431.11 | 13831.0 |
| 2024-10-28 08:00:00 | MSFT | Stock | 431.94 | 432.1 | 427.08 | 431.65 | 53525.0 |
| 2024-10-28 09:00:00 | MSFT | Stock | 431.71 | 432.0 | 428.13 | 428.94 | 1158301.0 |
| 2024-10-28 10:00:00 | MSFT | Stock | 428.98 | 430.84 | 428.935 | 429.36 | 842759.0 |
| 2024-10-28 11:00:00 | MSFT | Stock | 429.31 | 429.6 | 428.02 | 428.7 | 762115.0 |
| 2024-10-28 12:00:00 | MSFT | Stock | 428.67 | 428.73 | 428.0 | 428.1 | 748591.0 |
| 2024-10-28 13:00:00 | MSFT | Stock | 428.12 | 428.21 | 427.0105 | 427.9 | 638379.0 |
| 2024-10-28 14:00:00 | MSFT | Stock | 427.89 | 428.0923 | 426.85 | 426.9625 | 602515.0 |
| 2024-10-28 15:00:00 | MSFT | Stock | 426.96 | 427.44 | 426.3 | 426.71 | 1524923.0 |
| 2024-10-28 16:00:00 | MSFT | Stock | 426.59 | 427.0 | 426.54 | 426.78 | 2161893.0 |
| 2024-10-28 17:00:00 | MSFT | Stock | 426.8895 | 427.0 | 426.7601 | 426.9103 | 5426.0 |
| 2024-10-28 18:00:00 | MSFT | Stock | 427.0 | 427.0 | 426.69 | 426.8 | 5224.0 |
| 2024-10-28 19:00:00 | MSFT | Stock | 426.8 | 426.9 | 426.702 | 426.8987 | 5517.0 |
| 2024-10-28 04:00:00 | NVDA | Stock | 142.8 | 143.3 | 141.99 | 143.2 | 390211.0 |
| 2024-10-28 05:00:00 | NVDA | Stock | 143.18 | 143.47 | 143.06 | 143.18 | 190902.0 |
| 2024-10-28 06:00:00 | NVDA | Stock | 143.18 | 143.35 | 142.86 | 142.87 | 224849.0 |
| 2024-10-28 07:00:00 | NVDA | Stock | 142.89 | 143.22 | 142.75 | 143.19 | 635292.0 |
| 2024-10-28 08:00:00 | NVDA | Stock | 142.83 | 143.39 | 141.187 | 143.1 | 1693911.0 |
| 2024-10-28 09:00:00 | NVDA | Stock | 143.1 | 143.21 | 140.89 | 141.3284 | 28439460.0 |
| 2024-10-28 10:00:00 | NVDA | Stock | 141.32 | 142.08 | 140.93 | 141.34 | 24690781.0 |
| 2024-10-28 11:00:00 | NVDA | Stock | 141.33 | 141.45 | 140.05 | 140.3199 | 22885115.0 |
| 2024-10-28 12:00:00 | NVDA | Stock | 140.315 | 140.77 | 140.18 | 140.56 | 13492576.0 |
| 2024-10-28 13:00:00 | NVDA | Stock | 140.56 | 141.42 | 140.41 | 141.385 | 13758465.0 |
| 2024-10-28 14:00:00 | NVDA | Stock | 141.3898 | 141.49 | 140.73 | 140.99 | 12035529.0 |
| 2024-10-28 15:00:00 | NVDA | Stock | 140.99 | 141.33 | 140.25 | 140.62 | 15952434.0 |
| 2024-10-28 16:00:00 | NVDA | Stock | 140.52 | 141.5 | 140.27 | 140.47 | 11654764.0 |
| 2024-10-28 17:00:00 | NVDA | Stock | 140.48 | 140.5 | 140.32 | 140.43 | 230520.0 |
| 2024-10-28 18:00:00 | NVDA | Stock | 140.42 | 140.42 | 140.2597 | 140.4 | 236092.0 |
| 2024-10-28 19:00:00 | NVDA | Stock | 140.4099 | 140.43 | 140.2008 | 140.2201 | 288504.0 |
| 2024-10-28 04:00:00 | AMZN | Stock | 189.2 | 189.94 | 189.0 | 189.8 | 25389.0 |
| 2024-10-28 05:00:00 | AMZN | Stock | 189.8 | 189.8 | 189.55 | 189.55 | 8229.0 |
> showing 50 of 60,995 rows — these rows as CSV