WITH airdrop_claimers AS (
select
distinct date_trunc('week', m.block_timestamp) as date,
m.msg_value : sender :: string AS airdrop_recipient,
m.msg_value : execute_msg : claim : amount / POW(10, 6) AS token_amount
from
terra.msgs m
where
m.msg_value : execute_msg : claim is not null
and m.tx_status = 'SUCCEEDED'
and m.msg_value : contract :: string = 'terra1atch4d5t25csx7ranccl48udq94k57js6yh0vk' -- LOOP Airdrop
)
select
date,
sum(token_amount) as total_tokens_claimed
from airdrop_claimers
group by date