bmorkaianchor airdrop claims
    Updated 2021-09-15
    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
    Run a query to Download Data