By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
scdate | value1 | value2 |
---|---|---|
2021-11-10 17:00:00 | 1943.98 | 2943.98 |
2021-11-10 17:00:18 | 1957.13 | 2957.13 |
2021-11-10 17:00:36 | 1953.94 | 2953.94 |
2021-11-10 17:00:54 | 1946.28 | 2946.28 |
2021-11-10 17:01:12 | 1960.29 | 2960.29 |
2021-11-10 17:01:29 | 1950.39 | 2950.39 |
2021-11-10 17:01:47 | 1942.62 | 2942.62 |
2021-11-10 17:02:05 | 1954.64 | 2954.64 |
2021-11-10 17:02:23 | 1958.21 | 2958.21 |
2021-11-10 17:02:41 | 1950.26 | 2950.26 |
2021-11-10 17:02:58 | 1945.33 | 2945.33 |
2021-11-10 17:03:16 | 1960.35 | 2960.35 |
2021-11-10 17:04:33 | null | null |
scdate | value1 | avg_v1 | value2 | avg_v2 |
---|---|---|---|---|
2021-11-10 17:00:00 | 1943.98 | 1951.68 | 2943.98 | 2951.68 |
2021-11-10 17:00:18 | 1957.13 | 1952.45 | 2957.13 | 2952.45 |
2021-11-10 17:00:36 | 1953.94 | 1953.50 | 2953.94 | 2953.50 |
2021-11-10 17:00:54 | 1946.28 | 1952.32 | 2946.28 | 2952.32 |
2021-11-10 17:01:12 | 1960.29 | 1951.10 | 2960.29 | 2951.10 |
2021-11-10 17:01:29 | 1950.39 | 1949.22 | 2950.39 | 2949.22 |
2021-11-10 17:01:47 | 1942.62 | 1951.82 | 2942.62 | 2951.82 |
2021-11-10 17:02:05 | 1954.64 | 1954.37 | 2954.64 | 2954.37 |
2021-11-10 17:02:23 | 1958.21 | 1951.27 | 2958.21 | 2951.27 |
2021-11-10 17:02:41 | 1950.26 | 1951.98 | 2950.26 | 2951.98 |
2021-11-10 17:02:58 | 1945.33 | 1952.84 | 2945.33 | 2952.84 |
2021-11-10 17:03:16 | 1960.35 | 1960.35 | 2960.35 | 2960.35 |
2021-11-10 17:04:33 | null | null | null | null |