block_timestamp as date,

-- msg_value :execute_msg :send :amount / pow(10, 6) as tokens_claimed,

msg_value: sender :: string as airdrop_recipient,

*

from

terra.msgs

where

msg_value: execute_msg: claim is not null

and tx_status = 'SUCCEEDED'

and msg_value :contract = 'terra1kcthelkax4j9x8d3ny6sdag0qmxxynl3qtcrpy' -- MINE TOKEN

limit 10