DATE_TRUNC('day', block_timestamp) as dt,

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

from terra.msgs

where msg_value:contract = 'terra1p44kn7l233p7gcj0v3mzury8k7cwf4zt6gsxs5'

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

group by 1