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 dt, sum(amount) as LUNA_deposited, count(distinct(sender)) as depositor_count from deposit

where amount is not null

group by 1

order by 1 desc