CryptoLionMIR airdrops
    Updated 2021-08-16
    SELECT
    block_timestamp,
    date_trunc('day', block_timestamp) as date,
    msg_value,
    msg_value:execute_msg:claim:amount/POW(10,6) as amount,
    msg_value:execute_msg:claim:stage,
    msg_value:sender::string as recipient
    FROM terra.msgs
    WHERE
    msg_value:contract::string = 'terra1kalp2knjm4cs3f59ukr4hdhuuncp648eqrgshw' -- MIR airdrop contract address
    -- tx_id = '5902E5EA9324DD96735C354091A4F6EB0F4619D616496314A523464FF4E930B3' -- airdrop transaction
    ORDER BY block_timestamp DESC
    LIMIT 100