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.

--

--

--

On-chain analyst, passionate to deliver nimble self explanatory visualized blockchain analytics. Wishing a world without any type of hierarchical contempt.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Top Digital Asset Trends to Watch in 2021

First off, I could go on and start writing about the tokenomic of this project but the aim of this…

Welcome to GoldFinch Protocol!

State of the Cryptoeconomy: Ethereum

Cosmos ⚛️ October 2019 Network Analysis

ICO for Dummies

A Guide to Crypto Events in H2 2022

Terraformer IDO Quick Guide for Defiato Lottery Winners

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Cryptwizards

Cryptwizards

On-chain analyst, passionate to deliver nimble self explanatory visualized blockchain analytics. Wishing a world without any type of hierarchical contempt.

More from Medium

Navigating the Terra ecosystem: A closer look at the cutting edge of DeFi

SwapSpace- How to swap your tokens easily

Gods unchained

Oasis comes to Wormhole!