PREVIEW / stock_1hour / 2024-07-11
file: by_date/stock_1hour/2024/2024-07-11.parquet size: 1.4 MB rows: 60,482 symbols: 902
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-07-11 04:00:00 | AAPL | Stock | 232.81 | 232.84 | 232.37 | 232.7 | 18815.0 |
| 2024-07-11 05:00:00 | AAPL | Stock | 232.68 | 232.8 | 232.68 | 232.7 | 9390.0 |
| 2024-07-11 06:00:00 | AAPL | Stock | 232.69 | 232.69 | 232.59 | 232.63 | 5522.0 |
| 2024-07-11 07:00:00 | AAPL | Stock | 232.62 | 232.7 | 232.14 | 232.14 | 35424.0 |
| 2024-07-11 08:00:00 | AAPL | Stock | 232.58 | 233.48 | 231.75 | 232.06 | 538291.0 |
| 2024-07-11 09:00:00 | AAPL | Stock | 232.0 | 232.98 | 230.14 | 231.83 | 7141629.0 |
| 2024-07-11 10:00:00 | AAPL | Stock | 231.83 | 232.15 | 226.64 | 226.66 | 10118690.0 |
| 2024-07-11 11:00:00 | AAPL | Stock | 226.66 | 227.7 | 225.77 | 226.86 | 7360797.0 |
| 2024-07-11 12:00:00 | AAPL | Stock | 226.864 | 228.72 | 226.7 | 227.72 | 5108497.0 |
| 2024-07-11 13:00:00 | AAPL | Stock | 227.72 | 228.2646 | 226.58 | 226.82 | 2730350.0 |
| 2024-07-11 14:00:00 | AAPL | Stock | 226.82 | 228.02 | 226.74 | 227.87 | 2706845.0 |
| 2024-07-11 15:00:00 | AAPL | Stock | 227.88 | 228.7 | 227.55 | 227.55 | 6821097.0 |
| 2024-07-11 16:00:00 | AAPL | Stock | 227.58 | 228.22 | 227.25 | 227.71 | 9024885.0 |
| 2024-07-11 17:00:00 | AAPL | Stock | 227.7 | 228.0 | 227.57 | 227.9 | 51959.0 |
| 2024-07-11 18:00:00 | AAPL | Stock | 227.85 | 228.5841 | 227.8 | 228.34 | 71134.0 |
| 2024-07-11 19:00:00 | AAPL | Stock | 228.42 | 229.0 | 227.82 | 228.05 | 104500.0 |
| 2024-07-11 04:00:00 | MSFT | Stock | 465.96 | 466.1 | 465.96 | 466.06 | 1559.0 |
| 2024-07-11 05:00:00 | MSFT | Stock | 465.34 | 465.8 | 465.23 | 465.77 | 1125.0 |
| 2024-07-11 06:00:00 | MSFT | Stock | 465.81 | 465.81 | 465.58 | 465.72 | 407.0 |
| 2024-07-11 07:00:00 | MSFT | Stock | 466.0 | 466.11 | 465.75 | 465.9 | 1369.0 |
| 2024-07-11 08:00:00 | MSFT | Stock | 465.8 | 467.75 | 465.0 | 465.18 | 68656.0 |
| 2024-07-11 09:00:00 | MSFT | Stock | 465.19 | 466.25 | 460.9 | 461.16 | 1445343.0 |
| 2024-07-11 10:00:00 | MSFT | Stock | 461.24 | 461.9 | 453.3 | 454.945 | 3010678.0 |
| 2024-07-11 11:00:00 | MSFT | Stock | 454.98 | 455.46 | 451.55 | 453.23 | 1898506.0 |
| 2024-07-11 12:00:00 | MSFT | Stock | 453.24 | 456.28 | 452.79 | 454.53 | 1234539.0 |
| 2024-07-11 13:00:00 | MSFT | Stock | 454.65 | 455.57 | 452.48 | 452.8659 | 758363.0 |
| 2024-07-11 14:00:00 | MSFT | Stock | 452.88 | 455.0899 | 452.87 | 454.33 | 796200.0 |
| 2024-07-11 15:00:00 | MSFT | Stock | 454.335 | 455.9 | 454.09 | 454.71 | 1669907.0 |
| 2024-07-11 16:00:00 | MSFT | Stock | 454.73 | 456.3865 | 454.63 | 455.7214 | 4615047.0 |
| 2024-07-11 17:00:00 | MSFT | Stock | 455.7 | 455.75 | 454.41 | 455.2 | 22717.0 |
| 2024-07-11 18:00:00 | MSFT | Stock | 455.81 | 456.35 | 455.2 | 455.9968 | 14275.0 |
| 2024-07-11 19:00:00 | MSFT | Stock | 455.98 | 456.25 | 454.7 | 454.7 | 14714.0 |
| 2024-07-11 04:00:00 | NVDA | Stock | 135.88 | 136.42 | 135.5 | 136.03 | 425897.0 |
| 2024-07-11 05:00:00 | NVDA | Stock | 135.98 | 136.16 | 135.68 | 135.96 | 232649.0 |
| 2024-07-11 06:00:00 | NVDA | Stock | 135.98 | 136.0 | 135.65 | 135.68 | 156684.0 |
| 2024-07-11 07:00:00 | NVDA | Stock | 135.69 | 135.96 | 135.25 | 135.49 | 813333.0 |
| 2024-07-11 08:00:00 | NVDA | Stock | 135.56 | 137.32 | 134.0 | 136.27 | 8904472.0 |
| 2024-07-11 09:00:00 | NVDA | Stock | 136.29 | 136.41 | 133.1 | 134.19 | 41915575.0 |
| 2024-07-11 10:00:00 | NVDA | Stock | 134.19 | 134.26 | 129.68 | 129.68 | 62631221.0 |
| 2024-07-11 11:00:00 | NVDA | Stock | 129.68 | 130.7296 | 127.6 | 128.37 | 53977856.0 |
| 2024-07-11 12:00:00 | NVDA | Stock | 128.38 | 130.34 | 128.12 | 128.19 | 35454891.0 |
| 2024-07-11 13:00:00 | NVDA | Stock | 128.21 | 128.96 | 127.42 | 127.4326 | 23021724.0 |
| 2024-07-11 14:00:00 | NVDA | Stock | 127.47 | 129.45 | 127.05 | 129.225 | 25790596.0 |
| 2024-07-11 15:00:00 | NVDA | Stock | 129.23 | 129.73 | 127.15 | 127.46 | 40099073.0 |
| 2024-07-11 16:00:00 | NVDA | Stock | 127.44 | 132.427 | 126.81 | 127.04 | 25175819.0 |
| 2024-07-11 17:00:00 | NVDA | Stock | 127.04 | 127.478 | 126.1 | 126.46 | 1842460.0 |
| 2024-07-11 18:00:00 | NVDA | Stock | 126.47 | 126.74 | 126.19 | 126.3 | 897875.0 |
| 2024-07-11 19:00:00 | NVDA | Stock | 126.3 | 126.5 | 126.21 | 126.21 | 947298.0 |
| 2024-07-11 04:00:00 | AMZN | Stock | 199.79 | 199.99 | 199.61 | 199.98 | 8334.0 |
| 2024-07-11 05:00:00 | AMZN | Stock | 199.97 | 199.97 | 199.83 | 199.84 | 3340.0 |
> showing 50 of 60,482 rows — these rows as CSV