date_trunc('day' ,BLOCK_TIMESTAMP) as dayz,

MSG_VALUE:coins[0]:amount::string / pow(10,6) 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 dayz, sum(amount) as deposit_sum, count(distinct(sender)) as distinct_depositers from lunax_deposits

where amount is not null

group by dayz

order by dayz desc