select
date_trunc('month', block_timestamp) as month,
sum(msg_value:execute_msg:claim:amount / pow(10,6))as Anc_claims
from terra.msgs
where msg_value:contract = 'terra146ahqn6d3qgdvmj8cj96hh03dzmeedhsf0kxqm' -- anc airdrop claim contract
and tx_status = 'SUCCEEDED'
group by month