Cryptowriter - Last 90 Days of Transactions - Terra
Last 90 Days of Transactions - TerraTerra Ecosystem - Let's take a look at the transactions for the last 90 days on Terra. Contracts, volume, etc.MethodologyAll of my data was created via Flipside Crypto infrastructure. First, it is important to document my definitions. For this analysis, I first explored all of the transactions with msg_type = 'wasm/MsgExecuteContract' (I decided to look at only transactions with msg_type = 'wasm/MsgExecuteContract' because it represents the things that matter the most on Terra. Smart contracts! Protocols! Dapps!) I used terra.msgs for my queries. No other data was needed. Let's get into it! Transaction/AddressesFirst, let's look at a summary of all transactions (with msg_type = 'wasm/MsgExecuteContract') Total Transactions - Last 90 Days You can see here, there have been 11,835,212 transactions for the last 90 days. Here is a running total to get an idea of the rate of these transactions. Total Transactions - Last 90 Days Now who are the people making these transactions? How many addresses were there? After querying, I found that of these 11,835,212 transactions - there were only 191,146 addresses signing those transaction. Total Addresses (senders) - Last 90 days Of those 191,146 addresses, who are the folks signing the MOST transactions? Let's look at the top 20. Top 20 Active Addresses - Last 90 days The top 20 addresses range from 490k to 30k transactions. Wow! It is interesting to see the total transactions that these addresses can handle, but the information that I find more interesting is WHAT they are transacting WITH/FOR. What protocols, contracts, dapps? Let's take a look. Contracts/protocols/dappsWe've given a summary of the total number of transactions, addresses, and the high activity addresses. Now let's find out what contracts they are interacting with! This might get tricky, fast. First, how many contracts have been interacted with in the past 90 days? Total Contract Addresses - Last 90 days Let's break down our numbers so far:
Lots of transactions, lots of addresses, and lots of contracts. What are the most active contracts? Let's take a look at the top 30 by the number of total transactions. Not USD volume. (I want to calculate this sometime) Top 30 Active Contracts - Last 90 days The top 30 most active contracts range from 977k transaction to 86k transactions. This great, but what/who are these contracts?? What protocols/dapps are being used? Let's look at all top 30. (I pulled all 30 of these manually from https://finder.extraterrestrial.money/ ) Top 30 Active Contracts (transactions) - Last 90 days
How about over time? I created a massive CASE statement that renamed all of these contracts to their names, because who wants to look at contract addresses? Top 30 Active Contracts (transactions) - Last 90 days Top 30 Active Contracts (transactions) - Last 90 days - stacked As you scroll through the interactive chart - it is super interesting to see the new protocols introduced with Columbus 5 become more active than the older contracts. Top 30 Active Contracts (transactions) Running Totals - Last 90 days Top 30 Active Contracts (transactions) Running Totals - Last 90 days - stacked Insights/ConclusionWow! Some incredible numbers/metrics showing the volume of transactions with the contracts/protocols involved. We mentioned before, for the last 90 days:
Then we looked at which contracts these addresses were interacting with. The part that I find most interesting, is the activity and number of protocols post-Columbus 5. When we look at the charts above, notice the difference between August/September and October/November. It is super interesting to see how quickly RandomEarth has become the most active contract in the recent months. During Columbus 4, it was almost ALWAYS the Anchor Price Oracle and Mirror Relay! During Columbus 5, it seems to be much more widespread. RandomEarth is definitely #1 most days, but the #2-#5 spots seem to jump around. Mirror Relay remains a high activity contract, but Valkyrie Token, Nexus Token, and others seem to be throwing in a few high activity days as well! Super cool to see the volume when RandomEarth first went live with Galactic Punks! We haven't been able to recreate that yet! 😉 Thanks for reading! -Brian brian_#3619 on Discord Comment & Earn!Share your thoughts and opinions on the topics covered within this blog in the comments below for your chance to win yourself an NFT. Click here for more information on our engagement rewards. If you liked this post from Cryptowriter, why not share it? |
Older messages
Total Volume on Terra NFTs
Friday, November 26, 2021
Terra NFT - Let's take a look at the total volume for the most active NFT marketplaces on Terra!
Hilary Clinton Sees Bitcoin as a Threat to the US Dollar – That’s the Plan Hilary
Friday, November 26, 2021
Bitcoin is a fairer system that will end America's endless wars to protect the dominance of its American dollar.
Cosmos SDK Club: Juno
Tuesday, November 23, 2021
Smart-Contracts
Art of the Chart - TAking Requests!
Tuesday, November 23, 2021
Happy Thanksgiving / Holiday season, everyone! Hope you're all well, and doubling down on peace & gratitude as we enter the Holidays. Trading wise, lets check out the Total Crypto MC first.
Why Terra ($LUNA) is unique and should not be compared to other blockchains like Ethereum, Solana and BSC
Tuesday, November 23, 2021
A fundamental overview of Terra, $LUNA and $UST.
You Might Also Like
You’re Not Going to Believe This
Tuesday, April 23, 2024
Massive Surprise Inside
New Quests: increase AirDrop eligibility
Tuesday, April 23, 2024
New Flipside Quests just dropped. Claim $AVAX and $APT while you increase your chain score and build your reputation, helping with airdrops. Flipside Crypto Hey there, Claim $APT and $AVAX when you
Robert F. Kennedy, Jr. wants to put US budget on blockchain for 24/7 transparency
Tuesday, April 23, 2024
The public could inspect government spending 24/7 under the plan. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Layer-1 Landscape
Tuesday, April 23, 2024
A data-driven look across Layer-1 ecosystems ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Cathie Wood Iinterview In HK: Bitcoin Price Prediction for 2030, HK Is a Leading Crypto Policy Pioneer
Tuesday, April 23, 2024
Editor | Wublockchain Here is the full transcript of the Hong Kong Web3 Festival: Please welcome the head of HashKey Singapore and CEO of HashKey Capital, Mr. DC, and the CEO and CIO of ARK Invest, Ms.
100k signatures can trigger Swiss national referendum on adding Bitcoin to country reserves
Monday, April 22, 2024
If the Bitcoin advocates' plan succeeds, Switzerland could become the first country in the West to embrace the flagship crypto asset. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Crypto Market Pulse Weekly - ₿ Bitcoin Halving Sparks Frenzy as Runes Protocol Launches
Monday, April 22, 2024
Bitcoin completed the fourth halving on 20 April. Runes protocol launched on Bitcoin causing record fees. $7.5bn. SingularityNet, Fetch.ai, and Ocean Protocol AI merger approved. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Impressions of the Hong Kong Web3 Conference: Exchanges fade, few excellent projects, KOL influence strengthens
Monday, April 22, 2024
Author | @tmel0211 Editor | Wublockchain Original link:https://x.com/tmel0211/status/1777871689092923636 After spending three days at the Hong Kong Web3 Conference, I have many thoughts that words
The 2024 Bitcoin Halving Has Successfully Been Completed
Monday, April 22, 2024
We bring you the top stories in crypto every week! Stories like... Monday April 22, 2024 Sign Up Your Weekly Update On All Things Crypto TL;DR The 2024 Bitcoin Halving Has Successfully Been Completed
From 2012 to 2024: Analyzing market conditions before each Bitcoin halving
Sunday, April 21, 2024
As the fourth Bitcoin halving approaches, an in-depth look at past events offers insights into potential market impacts. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏