Terra — Airdrop summary metrics in the last 90 days

What is the Terra Airdrop summary metrics in the last 90 days? This article will summarize the following questions about airdrops being claimed by addresses in the Terra ecosystem: 1) how many airdrops total were claimed? 2) how much money overall was claimed? 3) how often were airdrops claimed? All the data, tool come from Flipside Crypto.

Introduction

About Airdrop: Airdrop is a way in Terra ecosystem to distribute the tokens to addresses, it is a special way in Terra. To analyze how the airdrop impact the token price, we need to focus on the Airdrop claimed amount in Mirror. The Mirror contract address for Airdrop is: terra1kalp2knjm4cs3f59ukr4hdhuuncp648eqrgshw

Analytics

In this analytical article, I am going to focus on the Airdrop claimed amount in Mirror, will use the data from the Mirror contract address and get the corresponding data and charts.

How many airdrops total were claimed?

The SQL query logic is to use msg table to get the claimed amount in the Mirror contract, and then devided it by the 1000000 to get the correct MIR units, join with price and multiple it, it can deliver the total claimed amount in USD.

Here is the chart for daily claimed amount in USD:

Here is the line chart to show the cumulative claimed amount in USD:

Until today (Oct/10th/2021), the total claimed amount is $56.29518M for the Airdrop in Terra.

How much money overall was claimed?

To compare the overall money claimed, we can do the rewards table in terra table folder and get the total claimed rewards in the Terra Ecosystem.

The chart is shown as the following, we can find a peak time around July/2021 when there were tons of money get claimed

How often were airdrops claimed?

Here the definition of the frequency of airdrops is defined as the unique count number of transactions.

We can find an overall increase trend for the airdrop claimed.

Thanks to Flipside Crypto for providing the tool and data.The link to all the queries is here.