DATE_TRUNC('day', block_timestamp) as dt,

avg(msg_value:execute_msg:swap:belief_price) as AAUSD

from terra.msgs

where msg_value:contract = 'terra1z50zu7j39s2dls8k9xqyxc89305up0w7f7ec3n'

and msg_value:execute_msg:swap is not null and tx_status='SUCCEEDED' and block_timestamp >= '2022-01-01'

group by 1