iboo-jbj2MVlota price
    Updated 2022-03-17
    select
    DATE_TRUNC('day', block_timestamp) as day,
    avg(msg_value:execute_msg:swap:belief_price) as LOTA_price
    from terra.msgs
    where msg_value:contract = 'terra1pn20mcwnmeyxf68vpt3cyel3n57qm9mp289jta'
    and msg_value:execute_msg:swap is not null and tx_status='SUCCEEDED' and block_timestamp >= CURRENT_DATE-60
    group by 1