SELECT
TRUNC(block_timestamp, 'day') as date,
COALESCE(l.label, v.address) as validator,
AVG(voting_power) as voting_power
FROM
terra.validator_voting_power v
LEFT JOIN
terra.validator_labels l
ON
l.operator_address = v.address
WHERE
block_timestamp >= '2022-03-01'
GROUP BY
date,
validator