PREVIEW / stock_1hour / 2024-06-24
file: by_date/stock_1hour/2024/2024-06-24.parquet size: 1.3 MB rows: 59,045 symbols: 926
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-24 04:00:00 | AAPL | Stock | 207.4 | 208.2 | 207.4 | 207.78 | 35775.0 |
| 2024-06-24 05:00:00 | AAPL | Stock | 207.73 | 207.75 | 206.91 | 207.06 | 32770.0 |
| 2024-06-24 06:00:00 | AAPL | Stock | 207.1 | 207.97 | 207.1 | 207.8 | 39305.0 |
| 2024-06-24 07:00:00 | AAPL | Stock | 207.84 | 208.14 | 207.4 | 207.75 | 145410.0 |
| 2024-06-24 08:00:00 | AAPL | Stock | 207.7504 | 208.1 | 207.31 | 207.976 | 238833.0 |
| 2024-06-24 09:00:00 | AAPL | Stock | 207.96 | 208.77 | 206.59 | 208.7 | 7744876.0 |
| 2024-06-24 10:00:00 | AAPL | Stock | 208.7 | 210.79 | 208.5 | 210.57 | 8830504.0 |
| 2024-06-24 11:00:00 | AAPL | Stock | 210.562 | 212.7 | 210.562 | 211.8499 | 10521632.0 |
| 2024-06-24 12:00:00 | AAPL | Stock | 211.83 | 211.85 | 209.54 | 209.7699 | 6085734.0 |
| 2024-06-24 13:00:00 | AAPL | Stock | 209.765 | 210.18 | 209.1801 | 209.26 | 4617379.0 |
| 2024-06-24 14:00:00 | AAPL | Stock | 209.25 | 209.51 | 208.52 | 208.85 | 4789559.0 |
| 2024-06-24 15:00:00 | AAPL | Stock | 208.845 | 209.1 | 207.8446 | 208.15 | 8963158.0 |
| 2024-06-24 16:00:00 | AAPL | Stock | 208.15 | 208.94 | 208.14 | 208.84 | 11424402.0 |
| 2024-06-24 17:00:00 | AAPL | Stock | 208.9 | 209.0 | 208.55 | 208.75 | 51318.0 |
| 2024-06-24 18:00:00 | AAPL | Stock | 208.75 | 209.04 | 208.14 | 208.9571 | 44201.0 |
| 2024-06-24 19:00:00 | AAPL | Stock | 208.95 | 209.1599 | 208.81 | 209.12 | 46350.0 |
| 2024-06-24 04:00:00 | MSFT | Stock | 449.82 | 449.99 | 449.5 | 449.9 | 2217.0 |
| 2024-06-24 05:00:00 | MSFT | Stock | 449.98 | 450.5 | 449.97 | 450.5 | 2356.0 |
| 2024-06-24 06:00:00 | MSFT | Stock | 450.78 | 450.78 | 450.3 | 450.3 | 1561.0 |
| 2024-06-24 07:00:00 | MSFT | Stock | 450.35 | 450.41 | 449.55 | 449.7 | 10003.0 |
| 2024-06-24 08:00:00 | MSFT | Stock | 450.14 | 450.904 | 449.0767 | 449.55 | 26741.0 |
| 2024-06-24 09:00:00 | MSFT | Stock | 449.5 | 450.13 | 446.41 | 449.63 | 1366775.0 |
| 2024-06-24 10:00:00 | MSFT | Stock | 449.595 | 452.75 | 448.17 | 450.18 | 1790108.0 |
| 2024-06-24 11:00:00 | MSFT | Stock | 450.19 | 450.49 | 449.32 | 450.23 | 694549.0 |
| 2024-06-24 12:00:00 | MSFT | Stock | 450.2 | 450.27 | 448.9001 | 449.38 | 542393.0 |
| 2024-06-24 13:00:00 | MSFT | Stock | 449.345 | 449.52 | 447.95 | 448.4 | 594229.0 |
| 2024-06-24 14:00:00 | MSFT | Stock | 448.42 | 448.595 | 447.72 | 448.12 | 596561.0 |
| 2024-06-24 15:00:00 | MSFT | Stock | 448.13 | 448.7 | 447.33 | 447.78 | 1380105.0 |
| 2024-06-24 16:00:00 | MSFT | Stock | 447.67 | 447.7699 | 446.51 | 447.23 | 3458824.0 |
| 2024-06-24 17:00:00 | MSFT | Stock | 447.39 | 447.67 | 447.22 | 447.57 | 8356.0 |
| 2024-06-24 18:00:00 | MSFT | Stock | 447.67 | 447.94 | 447.0 | 447.67 | 8460.0 |
| 2024-06-24 19:00:00 | MSFT | Stock | 447.2101 | 448.4958 | 447.15 | 448.33 | 7503.0 |
| 2024-06-24 04:00:00 | NVDA | Stock | 126.7 | 127.2 | 125.51 | 125.79 | 481001.0 |
| 2024-06-24 05:00:00 | NVDA | Stock | 125.77 | 125.77 | 122.54 | 123.15 | 1582326.0 |
| 2024-06-24 06:00:00 | NVDA | Stock | 123.18 | 124.25 | 122.94 | 123.96 | 879855.0 |
| 2024-06-24 07:00:00 | NVDA | Stock | 123.94 | 124.68 | 123.76 | 123.9 | 1966931.0 |
| 2024-06-24 08:00:00 | NVDA | Stock | 124.36 | 126.89 | 123.4 | 123.6 | 3498620.0 |
| 2024-06-24 09:00:00 | NVDA | Stock | 123.61 | 124.46 | 121.47 | 122.61 | 60517663.0 |
| 2024-06-24 10:00:00 | NVDA | Stock | 122.61 | 123.9 | 118.29 | 120.43 | 92865089.0 |
| 2024-06-24 11:00:00 | NVDA | Stock | 120.43 | 120.95 | 118.82 | 120.94 | 49658744.0 |
| 2024-06-24 12:00:00 | NVDA | Stock | 120.94 | 121.32 | 119.77 | 119.875 | 36324751.0 |
| 2024-06-24 13:00:00 | NVDA | Stock | 119.875 | 120.34 | 119.0 | 119.6005 | 30062305.0 |
| 2024-06-24 14:00:00 | NVDA | Stock | 119.62 | 119.79 | 118.35 | 119.6863 | 38182839.0 |
| 2024-06-24 15:00:00 | NVDA | Stock | 119.685 | 120.9 | 118.04 | 118.06 | 54920585.0 |
| 2024-06-24 16:00:00 | NVDA | Stock | 118.07 | 122.7115 | 116.68 | 116.72 | 34137453.0 |
| 2024-06-24 17:00:00 | NVDA | Stock | 116.7 | 117.2456 | 116.68 | 116.96 | 2123600.0 |
| 2024-06-24 18:00:00 | NVDA | Stock | 116.97 | 118.11 | 116.75 | 116.87 | 962345.0 |
| 2024-06-24 19:00:00 | NVDA | Stock | 116.87 | 116.96 | 116.4501 | 116.55 | 1540217.0 |
| 2024-06-24 04:00:00 | AMZN | Stock | 188.6 | 189.46 | 188.6 | 189.14 | 9032.0 |
| 2024-06-24 05:00:00 | AMZN | Stock | 189.02 | 189.07 | 188.15 | 188.45 | 8794.0 |
> showing 50 of 59,045 rows — these rows as CSV