AndyCoolApollo
    Updated 2021-12-07
    select
    date_trunc('day', block_timestamp) as date,
    sum(msg_value:coins[0]:amount/POW(10,6)) as volume_uusd
    From terra.msgs
    where msg_value:contract = 'terra1leadedadm2fguezmd4e445h6fe337yzq8n2dxf'
    and tx_status = 'SUCCEEDED'
    and msg_value:execute_msg:zap_into_strategy is not null
    and block_timestamp > CURRENT_DATE - 30

    group by 1
    order by 1 asc
    Run a query to Download Data