PREVIEW / stock_1hour / 2024-06-25
file: by_date/stock_1hour/2024/2024-06-25.parquet size: 1.3 MB rows: 58,376 symbols: 931
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-25 04:00:00 | AAPL | Stock | 208.92 | 209.5 | 208.51 | 209.15 | 25361.0 |
| 2024-06-25 05:00:00 | AAPL | Stock | 208.91 | 209.39 | 208.6 | 209.01 | 26378.0 |
| 2024-06-25 06:00:00 | AAPL | Stock | 209.0 | 209.75 | 209.0 | 209.71 | 20389.0 |
| 2024-06-25 07:00:00 | AAPL | Stock | 209.8 | 209.85 | 209.5 | 209.7 | 29084.0 |
| 2024-06-25 08:00:00 | AAPL | Stock | 209.7 | 210.03 | 208.8262 | 209.7997 | 196728.0 |
| 2024-06-25 09:00:00 | AAPL | Stock | 209.71 | 211.38 | 208.61 | 210.1096 | 8150263.0 |
| 2024-06-25 10:00:00 | AAPL | Stock | 210.11 | 210.72 | 209.2001 | 209.3 | 5488931.0 |
| 2024-06-25 11:00:00 | AAPL | Stock | 209.29 | 210.48 | 209.29 | 210.33 | 3547394.0 |
| 2024-06-25 12:00:00 | AAPL | Stock | 210.32 | 210.485 | 209.535 | 209.7166 | 2446754.0 |
| 2024-06-25 13:00:00 | AAPL | Stock | 209.715 | 210.39 | 209.38 | 210.28 | 2934317.0 |
| 2024-06-25 14:00:00 | AAPL | Stock | 210.2801 | 210.6701 | 209.89 | 210.46 | 2885635.0 |
| 2024-06-25 15:00:00 | AAPL | Stock | 210.45 | 210.45 | 208.82 | 209.07 | 5740156.0 |
| 2024-06-25 16:00:00 | AAPL | Stock | 209.07 | 209.69 | 208.9 | 209.1608 | 13031541.0 |
| 2024-06-25 17:00:00 | AAPL | Stock | 209.14 | 209.33 | 209.09 | 209.26 | 33305.0 |
| 2024-06-25 18:00:00 | AAPL | Stock | 209.26 | 209.3 | 209.07 | 209.19 | 23535.0 |
| 2024-06-25 19:00:00 | AAPL | Stock | 209.13 | 209.27 | 209.08 | 209.14 | 36152.0 |
| 2024-06-25 04:00:00 | MSFT | Stock | 446.06 | 447.29 | 446.06 | 446.78 | 2506.0 |
| 2024-06-25 05:00:00 | MSFT | Stock | 447.0 | 447.01 | 446.0 | 446.0 | 3810.0 |
| 2024-06-25 06:00:00 | MSFT | Stock | 446.2 | 446.27 | 446.15 | 446.2 | 1213.0 |
| 2024-06-25 07:00:00 | MSFT | Stock | 446.4 | 447.5 | 446.4 | 447.1 | 3831.0 |
| 2024-06-25 08:00:00 | MSFT | Stock | 446.39 | 449.4 | 446.39 | 448.5793 | 34873.0 |
| 2024-06-25 09:00:00 | MSFT | Stock | 448.58 | 449.0 | 446.75 | 447.645 | 1185560.0 |
| 2024-06-25 10:00:00 | MSFT | Stock | 447.645 | 450.12 | 446.93 | 449.0 | 1173693.0 |
| 2024-06-25 11:00:00 | MSFT | Stock | 449.035 | 450.07 | 448.54 | 449.94 | 730753.0 |
| 2024-06-25 12:00:00 | MSFT | Stock | 449.91 | 450.3 | 448.81 | 449.2 | 589472.0 |
| 2024-06-25 13:00:00 | MSFT | Stock | 449.06 | 449.93 | 448.71 | 449.835 | 394245.0 |
| 2024-06-25 14:00:00 | MSFT | Stock | 449.85 | 450.35 | 449.56 | 450.24 | 534666.0 |
| 2024-06-25 15:00:00 | MSFT | Stock | 450.22 | 451.42 | 450.03 | 450.93 | 1087691.0 |
| 2024-06-25 16:00:00 | MSFT | Stock | 450.97 | 451.54 | 450.9 | 451.0 | 5243590.0 |
| 2024-06-25 17:00:00 | MSFT | Stock | 450.73 | 451.19 | 450.73 | 451.19 | 8537.0 |
| 2024-06-25 18:00:00 | MSFT | Stock | 450.85 | 450.95 | 450.53 | 450.53 | 4396.0 |
| 2024-06-25 19:00:00 | MSFT | Stock | 450.51 | 450.94 | 450.0 | 450.65 | 8783.0 |
| 2024-06-25 04:00:00 | NVDA | Stock | 115.26 | 120.13 | 115.25 | 120.07 | 2609490.0 |
| 2024-06-25 05:00:00 | NVDA | Stock | 120.08 | 122.2 | 120.0 | 122.15 | 2290490.0 |
| 2024-06-25 06:00:00 | NVDA | Stock | 122.18 | 122.21 | 120.63 | 120.7 | 1451890.0 |
| 2024-06-25 07:00:00 | NVDA | Stock | 120.7 | 121.44 | 120.15 | 120.8 | 2243495.0 |
| 2024-06-25 08:00:00 | NVDA | Stock | 120.4 | 122.0776 | 115.0 | 121.74 | 7545452.0 |
| 2024-06-25 09:00:00 | NVDA | Stock | 121.73 | 122.44 | 119.32 | 121.86 | 63618819.0 |
| 2024-06-25 10:00:00 | NVDA | Stock | 121.82 | 122.62 | 120.83 | 121.95 | 50430442.0 |
| 2024-06-25 11:00:00 | NVDA | Stock | 121.945 | 125.38 | 121.94 | 125.36 | 58975330.0 |
| 2024-06-25 12:00:00 | NVDA | Stock | 125.355 | 125.59 | 123.51 | 123.855 | 41080652.0 |
| 2024-06-25 13:00:00 | NVDA | Stock | 123.86 | 125.17 | 123.0401 | 124.965 | 30325051.0 |
| 2024-06-25 14:00:00 | NVDA | Stock | 124.95 | 125.31 | 124.33 | 125.105 | 24938449.0 |
| 2024-06-25 15:00:00 | NVDA | Stock | 125.1 | 126.5 | 124.78 | 126.24 | 47265798.0 |
| 2024-06-25 16:00:00 | NVDA | Stock | 126.24 | 127.17 | 121.3584 | 127.08 | 28671008.0 |
| 2024-06-25 17:00:00 | NVDA | Stock | 127.07 | 127.61 | 127.05 | 127.61 | 1362550.0 |
| 2024-06-25 18:00:00 | NVDA | Stock | 127.6 | 127.83 | 126.09 | 127.6397 | 1208430.0 |
| 2024-06-25 19:00:00 | NVDA | Stock | 127.63 | 127.66 | 126.8 | 127.24 | 1150696.0 |
| 2024-06-25 04:00:00 | AMZN | Stock | 185.86 | 186.0 | 185.5 | 185.91 | 4715.0 |
| 2024-06-25 05:00:00 | AMZN | Stock | 185.9 | 186.36 | 185.76 | 186.22 | 7403.0 |
> showing 50 of 58,376 rows — these rows as CSV