with terra_airdrops as

select

distinct date_trunc('week', m.block_timestamp) as date,

m.tx_id,

m.msg_value : contract :: string AS contract,

m.msg_value : sender :: string AS sender,

m.msg_value : execute_msg : claim : amount / POW(10, 6) AS token_amount,

m.msg_value : execute_msg : claim : stage AS stage

from

terra.msgs m

where

m.msg_value : execute_msg : claim is not null

and m.tx_status = 'SUCCEEDED'

and stage = 1

-- and m.msg_value : contract :: string = 'terra1kalp2knjm4cs3f59ukr4hdhuuncp648eqrgshw'

select contract,address,token_amount

from terra_airdrops