date_trunc('day', block_timestamp) as days,

sum(msg_value:coins[0]:amount)/pow(10, 6) as ANC_deposit

from terra.msgs

where msg_value

and tx_status = 'SUCCEEDED'

group by 1