DATE_TRUNC('day', block_timestamp) AS block_day,

sum(msg_value:execute_msg:send:amount /1e6) as Deposit

FROM terra.msgs

WHERE msg_value:execute_msg:send:msg:deposit_collateral IS NOT NULL

and msg_value:contract::string = 'terra1dzhzukyezv0etz22ud940z7adyv7xgcjkahuun'

and tx_status = 'SUCCEEDED'

and block_timestamp >= CURRENT_DATE - 30

group by 1