date_trunc('day' ,BLOCK_TIMESTAMP) as dt,

MSG_VALUE:coins[0]:amount::string /1e6 as amount,

MSG_VALUE:coins[0]:denom::string as denom,

MSG_VALUE:contract::string as contract,

MSG_VALUE:sender::string as sender

from terra.msgs where contract = 'terra1xacqx447msqp46qmv8k2sq6v5jh9fdj37az898'

)

select sum(amount) as total_lunaX, count(distinct sender) as total_address

from deposit