CryptoLiontop airdrops and MIR
    Updated 2021-08-20
    SELECT
    block_timestamp,
    date_trunc('day', block_timestamp) as date,
    block_id,
    msg_value:execute_msg:claim:amount/1e6,
    msg_value:execute_msg:claim:stage,
    msg_value:sender::string
    FROM terra.msgs
    WHERE
    msg_value:contract::string = 'terra1kalp2knjm4cs3f59ukr4hdhuuncp648eqrgshw' -- MIR airdrop contract address
    AND msg_value:execute_msg:claim:stage = 34
    -- and msg_value:sender::string = 'terra1dp0taj85ruc299rkdvzp4z5pfg6z6swaed74e6'
    -- tx_id = '5902E5EA9324DD96735C354091A4F6EB0F4619D616496314A523464FF4E930B3' -- airdrop transaction
    ORDER BY block_timestamp DESC
    Run a query to Download Data