DATE_TRUNC('day', block_timestamp) as dt,

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

from terra.msgs

where msg_value:contract = 'terra134m8n2epp0n40qr08qsvvrzycn2zq4zcpmue48'

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

group by 1