Introduction

What is Luna?

Luna 2.0 is the brand new token of the new Terra blockchain intended to rescue the Terra Luna ecosystem following the stablecoin collapse.

Dubbed the Luna rebirth, TerraForm Labs founder Do Kwon's proposal saw new chain replace the existing Terra network. Alongside this, Luna 2.0 replaced the existing version of Luna. It has severed ties to the UST stablecoin that saw the crash happen in the first place.

Alongside the new chain, most of the dApps will also migrate to the new chain. Most other features will transfer over, according to Terra.

What is contract address?

Digital wallets usually generate a new address for each transaction. A contract address is a unique address allocated when a smart contract is deployed.

question

Construct a dashboard that displays the number of new contracts deployed and the total number of contracts deployed each week over the past several months. Your dashboard should also chart the development of stablecoins, including any supply trends.

\n

Section 2: stable coins supplies

In this section we explore stable coins supplies. there is 4 type of stable coin in Luna 2 blockchain USDT, USDC, axlUSDC and UST. also the daily changes of stable coins have been explored.

Technical methodology

• terra.core.fact_transactions, terra.core.fact_msg_attributes, terra.core.ez_transfers have been used for this analysis.
• for finding creation date of contract we use min() as below:

select contract address, min(block_timestamp) from 
table 
group by 1

• For finding smart contract address the terra.core.dim_address_labels and terra.core.fact_transactions tables have been used. so that the count of distinct tx['body']['messages'][0]['contract'] is the number of smart contracts.
• For finding stable coins the tables terra.core.ez_swaps so that we suppose the stable coin out flow of sawapping pools as stable coin supplies.
• the inflow-outflow of swapping pools determines supplies of every tokens.

Section 1 :

In this section we are going to explore deploying of contract addresses. both users contract address and smart have been explored. the daily and cumulative daily new contract have been brought.

Result

• The most popular stable coin on Luna 2 blockchain is USDC. there is 125M supply of USDC on Luna 2 blockchain. it means 56% of total stable coins of Luna 2 is USDC.
• After that axlUSDT are popular. there are 61M of axlUSDC on Luna 2 blockchain. 27.5% of all stable coins of Luna 2 are axlUSDC.
• UST and USDT supplies consist respectively 37K and 49. means that on the Luna 2 blockchain these two stable coins are rarely used
• The supply of axlUSDC was negative on Jun 2022. means the axlUSDC were going to swapping pools. after that the trend began goes reverse and after a while axlUSDC supplies was become positive. also we can see axlUSDC is older than others.
• There is a spike on 1 August 2022 for all stable coins so that USDC went from 38M to 110M and axlUSDC went from -112M to -46M.
• All supplies trends are ascend on all time.
• Inflow of USDC and USDT are positive for all times.
• for all stable coin supplies there is a spike on Jun.
• at the beginning all net flows were big but in time the volumes got smaller so that the net flows have their minimums amount last week.
• It seems the top destinations of axlUSDT are smaller than others. it means axlUSDT are more popular for small users.

There is no swapping-from transactions for USDC and UST.

References

thanks to @flipsidecrypto

Results

• Total contact number is 210 K and there are 273 smart contract addresses.
• Majority of contract addresses are operator and token contract addresses. there are few Defi and dapp means Luna 2 block chain does not expand enough and there is not many app.
• Also for NFTs there is just 1 smart contract means there is no NFT develop for Luna 2 blockchain.
• Majority of contracts were crated at the 10 days of starting of Luna 2 blockchain so that 145 smart contract addresses just create at first day of Luna lunching and 141K contract were crate at the 10 days of starting. after that there is a spike in September 2022 so that 20K contract were created.

Section 2-2: Weekly netflow

In this section we are going to find how are daily net flow for four stable coin USDC, UST, axlUSDC, axlUSDT

Section 2-3:

In this section we are going to find 10 top destination and origin of stable coins. destination means where tokens go from swapping pools and origin means from where tokens come to swapping pools.

destination means where tokens go from swapping pools and origin means from where tokens come to swapping pools.