-- *

date_trunc('day', block_timestamp) as block_day,

-- tx_id,

sum(msg_value:coins[0]:amount/1000000) as amount_donated

-- msg_value:sender::string as donator

from terra.msgs

where msg_value:contract = 'terra19cevhng6nunl7gmc90sph0syuqyvtqn7mlhwz0' and msg_value:execute_msg:deposit:fund_id in ('6', '7')

group by block_day

order by block_day desc