The purpose of this article is to demonstrate the NFT Marketplaces of Avalanche by Flipside Crypto. Introducing the Avalanche by exploring various charts and providing a good explanation of what it is and how it works if you are new to it. The Avalanche’s blockchain is also displayed here so that we can understand how the blockchain works, its benefits, and different major NFT marketplaces in this blockchain , the approach, and the insights.

Approach  

Our goal in this dashboard was to understand how the blockchain works by analyzing the Avalanche NFT Marketplaces. As part of that process, we are taking few key metrics from major Avalanche NFT marketplaces (for example, Camfire, Chikn, JoePegs, Kalao, NFTKey, NFTrade and OpenSea). Listed below are all metrics taken on a weekly basis. NFT Price and volume are expressed as AVAX.

• Trades – NFT Marketplaces
• Volume(AVAX) – NFT Marketplaces
• Unique Buyers – NFT Marketplaces
• Maximum and Average Prices – NFT Marketplaces

Avalanche: What Does It Mean And How it Works ?

Ava Labs launched the blockchain platform Avalanche in 2020. It is capable of executing smart contracts. In addition to maintaining decentralization and security, Avalanche focuses on rapidly transferring funds, lowering costs, and being environmentally friendly. Users can customize and interoperate an unlimited number of blockchains using Avalanche. There is a subscription fee for operating a blockchain on AVAX, the Avalanche coin.

To avoid not having Avalanche follows a unique approach to scalability and usability by using three separate blockchains internally, resulting in solve problems with interoperability. They are as follows ,
X-Chain: An asset management blockchain. In order to achieve consensus, it uses the Avalanche protocol.
C-Chain: The C-Chain is used to create smart contracts. Consensus protocol Snowman is used.
P-Chain: This blockchain coordinates validators. Furthermore, it uses Snowman’s consensus protocol.

There are two blockchains (P-Chain and C-Chain) that leverage “Snowman” consensus, enabling high-throughput secure smart contracts, and the X-Chain uses the “Avalanche” consensus, which is secure and scalable.

What is its role in cryptocurrency? Why Does It Need to Be Introduced?

As well as serving as a staking tool for AVAX, it also provides network security. As a reward, stakers receive more AVAX. It is common for users of AVAX to stake the network in order to earn passive income. As a utility token, AVAX is native. In the AVAX network, the AVAX Token is used for a wide variety of purposes, including transaction fees, incentive programs, and many more. 

Today, Ethereum apps typically use layer-2 scaling solutions to improve transaction speed and address scalability  issues. Layer 2 separates transactions from the main chain. As a result, the transaction is then packaged in neat “bundles” and is then sent back to the Ethereum chain, relieving Ethereum of some of its burden. Although it works effectively in many cases, it can also complicate security in some cases. As a result, avalanche has been designed to solve these problems and maintain scalability, transaction speed, and security in a single layer.

What are the benefits of using Avalanche ?

Avalanche addresses two major issues:

Traffic congestion: Scalability was a deliberate design goal of Avalanche. Avalanche is as fast as PayPal and VISA when it comes to processing transactions. In addition to its tremendous power and efficiency, Avalanche is extremely fast, able to process up to 6,500 transactions per second with a time resolution of less than a minute. As compared to Ethereum’s limitations, this is a huge improvement.

Low fees : Although many consider Avalanche to be a competitor of Ethereum, it also has a lower gas fee than Ethereum. There is a large difference between the cost of Avalanche and Ethereum.

Comparing it to other blockchains, how popular is it?

In order to overcome many of the problems faced by most blockchain networks, Avalanche was built. Avalanche, a platform similar to Ethereum, works to combat centralization in the crypto space by offering an alternative. * As compared to other Blockchains, the Avalanche Blockchain has the following advantages. 
Compatibility: Data and coins are exchanged between two platforms through interoperability. The Avalanche blockchain provides interoperability with other blockchains, allowing users to trade coins with other platforms.
Adaptability: It takes an enormous amount of energy and computing power to mine Bitcoin (BTC), for example. There is a limit of 15 transactions per second for Ethereum. These blockchains are powerful and highly valuable, but they are not scalable. Meanwhile, Avalanche’s processing capacity is incredible and its transaction times are sub-second.  
Convenience: Avalanche is becoming more popular in the cryptocurrency community faster than Ethereum. It become very popular with many users by its ease of implementing and using any technology, regardless of its application.

Here from the below tweet we can see different Defi applications which are built on the Avalanche Blockchain .

4/ In November 2021, Avalanche had 650k monthly active wallets on the C-Chain.

Just over halfway through December, and Avalanche has over 537k monthly active wallets on the C-Chain. pic.twitter.com/Mi4shunJ5D

— Avalanche (@avalancheavax) December 17, 2021

Avalanche: Major NFT Marketplaces

NFT marketplaces offered by Avalanche are a great option for users who wish to buy, sell, or trade NFTs. It is easy and affordable to use these marketplaces, which offer a user-friendly interface, a wide selection of NFTs, and affordable fees.

• Joepegs NFT (Trader Joe NFT Marketplace) : There are the most users on Trader Joe’s DeFi and NFT applications on the AVAX Network. Joepegs, Avalanche’s NFT platform, was launched in early 2022 and quickly became the company’s most popular marketplace. With a wide variety of AVAX NFTs, including Smol Joes, Smol Land, Satoverse, Avax Party Animals, Hoppers Game, Particle (Banksy), and more, it is one of the most popular places to get Avax NFTs.
• Kalao : This NFT marketplace is just for Avalanche (AVAX) and hosts top-tier collections like AVAX Warriors, Firats, and AvaxApes. On the NFT Marketplace, Kalao (KLO) is a native token that allows users to share revenue. In Kalao’s application, staking interest is currently more than 70%. As a result, Kalao is a great place to invest in AVAX NFTs and stake for rewards.
• NFTrade : Featuring native Avalanche NFT support, NFTrade provides a multi-chain NFT marketplace. Avalanche, Harmony, Solana and Avalanche are popular collections with their platform. In addition, AVAX releases new NFT drops through the NFT Launchpad.
• Chikn : It is a non-fungible token collection based on NFTs (Non-fungible Tokens). On the blockchain, there is a collection of digital artwork.
• OpenSea : OpenSea, the world’s leading peer-to-peer marketplace for NFTs, has launched natively on Avalanche to provide producers, collectors, and collaborators with the best selection of NFTs.

Trades – NFT Marketplaces

Graphs below show the weekly number of trades that were made on various NFT marketplaces in Avalanche Blockchian. In terms of trades, the lowest number is 26.01 (NFTKey) and the highest number is 18.95K (Chikn). The maximum number of trades was 4.69K in W18, 2022, while the minimum number of trades was 191.6 in W50, 2021. Trends show that trades are increasing. From May 2022 onwards on Chikn NFT marketplace we can see a huge number of trades .

If we look at the percentage of number of trades on different marketplaces , initially we can see there are only Kalao, NFTKey and NFtrade trades . But from April 2nd week 2022 onwards we can see almost more than 85% of traded are from Chikn marketplace. And also in this marketplace we can see an increasing trend of trades .

The following graph shows NFT marketplaces in the Avalanche blockchain and their percentage of trades over time. Eighty-two percent of total trades were conducted on Chikn Markets. In terms of total trades, OpenSea has the lowest total trades and Chikn has the highest total trades. Second place goes to Kalao marketplace after Chikn marketplace in terms of trades.

In comparison with the previous week, the total number of trades on different marketplaces suddenly peaked on May 2022 when we look at the week over week growth. It is specifically made by Chikn.

Volume(AVAX) – NFT Marketplaces

In this section, we can see the weekly volume of various NFT marketplaces. The lowest average volume is 4.07 (NFTKey), and the highest average volume is 1,575.66 (NFTrade). The maximum volume of 3,683.57 was observed in W1, 2022, and the minimum volume of 90.11 was observed in W50, 2021.Initially, the volume (AVAX) is high on NFTrade marketplace. Later, the volume is reduced.

According to the below graph, the percentage of NFTtrade volume has drastically decreased from the beginning to the end of our analysis. There is an increasing trend in the Kalao volume.

When we look at the volume of all NFT marketplaces, NFTrade contributes half the volume. Among all the NFT marketplaces here, Kalao has the second highest volume after NFTrade.

In the graph below, we can see how the volume on different NFT marketplaces on Avalanche blockchain has grown week over week. When we compare Oct 9-15 2022 week with previous week, we can see that Opensea marketplace volume has increased by a huge percentage suddenly.

Unique Buyers – NFT Marketplaces

We can see in this section how many unique buyers have been registered on Avalanche blockchain each week on the different NFT marketplaces. The lowest number of buyers is from NFTKey, and the highest number is from JoePegs. The average number of buyers in W1, 2022 and W15, 2022 is higher than usual.

We can see from the below graph that buyer numbers on Kalao, Chikn, Campfire, and NFTrade NFT marketplaces are declining. There is an increasing trend in unique buyers on JoePegs.

JoePegs NFT marketplace’s unique buyers suddenly increased in May 2022 when compared to its previous week, as illustrated in the graph below. Additionally, the number of buyers on Opensea marketplace increased suddenly from last week to this week on October (9-15) 2022.

Maximum and Average Prices Of NFT – NFT Marketplaces

Here is a graph showing the average price of NFTs on different marketplaces. We can see that the average NFT price of NFTrade is more initially, but later we can see it is decreasing. Also, we can see a sudden increase in the average NFT price of Kalao NFT marketplace from Nov 1st week 2022 onwards. In terms of average NFT price, the lowest is 0.11 (Chikn) and the highest is 2.41 (NFTrade). There was a maximum average NFT price of 3.12 observed in W47, 2022, and a minimum average NFT price of 0.26 observed in W51, 2021.

The graph below shows the maximum price of NFTs on different marketplaces. In NFTrade and Kalao, we can see that the maximum price initially is higher, but later on, it decreases. JoePegs, Chikn, and OpenSea NFT marketplaces all experienced sudden increases in their maximum NFT pricing in early September 2022. NFTKey has the lowest Max NFT Price of 1.53, while JoePegs has the highest Max NFT Price of 77.37. The highest NFT prices were observed in W5, 2022, and the lowest NFT prices were observed in W50, 2021. Prices of NFT are lower than normal in W38, 2022 and W9, 2022

Observations

From the above analysis,

• NFT marketplaces in the Avalanche blockchain are shown in the following graph, along with the percentage of trades they have made over time. It is estimated that Chikn Markets accounted for 82 percent of total trades. Total trades of OpenSea are the lowest, while those of Chikn are the highest. In terms of trades, Kalao marketplace takes second place behind Chikn marketplace.
• Compared to the previous week, the total number of trades on different marketplaces suddenly peaked on May 2022. It is specifically made by Chikn.
• Compared to the beginning of our analysis, the percentage of NFTtrade volume has drastically decreased over time. As the Kalao volume increases, there is an upward trend.
• Based on all NFT marketplaces combined, NFTrade contributes half the volume. The second most popular NFT marketplace in this list is Kalao, followed by NFTrade.
• As we compare the Oct 9-15 2022 week to the previous week, Opensea’s market volume has increased by a huge percentage.
• Based on the above analysis, we can see that Kalao, Chikn, Campfire, and NFTrade NFT marketplaces are experiencing declining buyer numbers. JoePegs has an increasing trend in unique buyers. Also, we can see that NFTKey has the lowest number of buyers, and JoePegs has the highest number.
• As a result of the above analysis, JoePegs NFT marketplace’s unique buyers suddenly increased in May 2022. Moreover, there has been an increase in buyers on Opensea marketplace from last week to this week (9-15 October 2022).
• Based on the above analysis, we can see that the average NFT price of NFTrade was initially higher, but later decreased. From Nov 1st week 2022 onwards, we can also see a sudden increase in the average NFT price on Kalao NFT marketplace. 
• Based on average NFT price, Chikn is the lowest at 0.11 and NFTTrade is the highest at 2.41.
• The maximum price initially appears to be higher in NFTrade and Kalao, but it decreases later on. NFT marketplaces JoePegs, Chikn, and OpenSea all experienced sudden increases in maximum NFT pricing in early September 2022. 
• As of today, NFTKey has the lowest Max NFT Price (1.53), while JoePegs has the highest Max NFT Price (77.37).

Reference Query

WITH marketplaces as (
	SELECT lower('0xc28f1550160478a7fb3b085f25d4b179e08e649a') as contract, 'NFTrade' as market
    UNION 
  	SELECT lower('0xbf6bfe5d6b86308cf3b7f147dd03ef11f80bfde3') as contract, 'NFTrade' as market
  	UNION
    SELECT lower('0x11ac3118309a7215c6d87c7c396e2df333ae3a9c'), 'Kalao'
    UNION 
    SELECT lower('0xeff2357c9e40103ac4d268b32de478e4fbbfc4f0'), 'Kalao'
    UNION 
    SELECT lower('0xcf91b99548b1c17dd1095c0680e20de380635e20'), 'Chikn'
    UNION 
    SELECT lower('0xae079eda901f7727d0715aff8f82ba8295719977'), 'JoePegs'
    UNION 
    SELECT lower('0xbcb09cdb2011fea0591b52e52085bb102e4a082a'), 'Campfire'
    UNION 
    SELECT lower('0x00000000006c3852cbEf3e08E8dF289169EdE581'), 'OpenSea'
  	UNION 
	SELECT lower('0x1A7d6ed890b6C284271AD27E7AbE8Fb5211D0739'), 'NFTKey'

),
nft_txns as (
	SELECT 
   		tx_hash,
		block_timestamp,
  		block_timestamp::date as date, 
  		avax_value as amount,
  		from_address as wallet,
  		market
	FROM avalanche.core.fact_traces
  	INNER JOIN marketplaces ON to_address = contract 
    WHERE TX_STATUS = 'SUCCESS'
  	 	and date >= CURRENT_DATE - 360
)
SELECT 
	date, 
  	market,
	count(tx_hash) as trades,
	sum(amount) as volume,
	count(distinct wallet) as wallets,
  	min(amount) as nft_floor_price,
  	avg(amount) as avg_nft_price,
  	max(amount) as max_nft_price
FROM nft_txns 
GROUP BY date, market

Bounty: Who is holding the most FLOW? Build a list of rankings to help us find the address with the most FLOW tokens. Identify any trends or outliers you see in this collection of whales. Bonus points if you can identify the wallet holders.

Introduction

Flow is designed for Web3 applications that need great user experience, whether NFTs, gaming, Metaverse, or even decentralized finance. Dapper Labs has launched one of the most popular NFT gaming collections ever named CryptoKitties, which choked the Ethereum blockchain. There is no need to A NFT project called Cryptokitties crippled the Ethereum blockchain during the first major public cryptocurrency hype in 2018. Dapper Labs, a Canadian company, built the cryptokitties project and realized the popularity of cryptokitties, so they focused on scaling and improving their blockchain related projects. However, Ethereum did not go so smoothly since their NFT projects were competing for scarce resources with the DeFi dapps. In response, they created a new blockchain called Flow.

Flow is a fast, decentralized, and developer-friendly blockchain designed for high transaction throughput for gaming networks, digital assets, and mobile apps that require millions of transactions. Flow’s blockchain architecture follows a totally different route than Ethereum, with a multi-role architecture built on top of a unique architecture that handles scalability without sharding. That means , we can say Flow blockchain was launched by Dapper Labs in response to Ethereum’s high gas fees and low transaction capabilities. Flow has a unique consensus process. Here we can see from the below diagram .

Approach

The purpose of this dashboard is to analyze how $FLOW is distributed among holders and to see what wallets hold the most $FLOW and how it has changed over time. The top 20 Account holders are analysed here, and by providing rankings to the top addresses, we can discuss what kind of actions they are taking in the following sections. In addition, we discussed the top 20 wrapped Flow account holders on the Ethereum blockchain. In this analysis, I started as follows:

• Let’s look at the number of unique users for the past 6 months per day first
• The number of transactions per day on Flow blockchain over the last six months
• Failure rate of transactions over time
• We can also see the total fees collected from users each day
• In the past six months, what has been the average fee per transaction
• Next, we can see the 20 top account holders on Flow Blockchain.
• Take a look at the ‘Top 20 Account Holders – What are they doing?’
• Also, here are the top 20 Wrapped Flow Account Holders on the Ethereum Blockchain

From the below tweet we can see , Mattel (@Mattel) is launching their NFT Marketplace on Flow, starting with the Hot Wheels Collection. May be by this new launch active accounts on Flow naturally followed a similar pattern to transactions as there was a record-breaking number for the number of monthly active $FLOW wallets.

Welcome Hot Wheels (@Hot_Wheels) to Flow Blockchain and the Flowverse

Mattel (@Mattel) is launching their NFT Marketplace on Flow, starting with the Hot Wheels Collection

From WAX to FLOW… here are all the details you need to know https://t.co/aEkJhG8Wwt pic.twitter.com/UXiKjc4CGq

— Flowverse – Discover Flow Blockchain (@flowverse_) November 23, 2022

From the below graphs we can see a active wallets and transaction in Flow blockchain for the past 6 months period. Total Active Users between June 1, 2022 to November 28, 2022 was 14.51M. Maximum Active Users of 605.54K was observed in November 25, 2022 and minimum Active Users of 9.87K was observed in November 13, 2022. Initially we can see a active user participation in the blockchain . Later from the graph we can see it has been reduced . But again, from Nov second week 2022 onwards we can see a continuous growth of active users on the flow blockchain. And also we can see a sudden changes of total Active Users in November 12, 2022 and November 9, 2022 is lower than normal and higher than normal in October 14, 2022 and November 7, 2022.

Comparing the Nov (20-26) 2022 week with the previous week, there is a clear increase in the active wallet percentage. It may have happened as a result of Hot Wheels’ new collection launch during that timeframe.

Flow Blockchain transactions on a daily basis for the past six months are shown in the graph below. A maximum of $2.32M was observed in transactions on November 25, 2022. It might be because of the Mattel is launching their NFT Marketplace on Flow, starting with the Hot Wheels Collection. From June 1, 2022 to November 28, 2022, the total Transactions increased by 9% to $735.13K.

Comparing the Nov (20-26) 2022 week with the previous week, there is a sudden increase in the number of transactions percentage. It may have happened as a result of Hot Wheels’ new collection launch during that timeframe.

Based on the graph below, we can see a trend of increasing failed transactions on Flow. A maximum of 48.55 failed transfers were observed on November 15, 2022, and a minimum of 0.95 failed transfers were observed on September 3, 2022.

As a result of the market volatility, we can see that the fees collected by users on a daily basis have been decreasing for the past 6 months.

We can see from this that the average fee per transaction has been reduced drastically. If we compare the gas fee with Ethereum, we can conclude that Dapper Labs has achieved its goal since Flow’s blockchain finally solves the issue of Ethereum’s high gas fees and low transaction capabilities.

Top 20 Account Holders

In the below graph, we can see a list of the top 20 account holders in Flow blockchain. Based on the top 20 wallets and their total balance across all wallets, we can see that the balance is 412.24M. There were two top wallets that contributed 38.8% of the total balance, and four top wallets that contributed 59.69%. In this example, the lowest total Balance is 2.89M (0x9cb6a8f3d0d6a568) and the highest is 99.82M (0x8f77d48caf93fd93).

In the following picture, we can see what the top 20 account holders are doing on the Flow blockchain. Here is a graph showing the top 20 account holders and their actions on the blockchain over time. According to the below graph, the majority of the top 20 account holders transfer tokens. From all top 20 account holders, we can see a total of 307.58K transactions. There are 3 Actions, but Action Token Transfers is the most significant contributor (98.47%) to the total Transactions. The lowest number of Transactions is 1 (0x51d9a80d3cb94ff7) and the highest number is 76.51K (0x21dc51d454d46f49). Among the total Transactions, the lowest is 3 (Bridge Transactions) and the highest is 302.88K (Token Transfers). 15 Account holders have relatively even Transactions for all Actions with a variation of 0%

There are 3 Actions, but Action Token Transfers is the most significant contributor (98.47%) to the total Transactions. 15 Account holders have relatively even Transactions for all Actions with a variation of 0%

According to the top 20 wrapped Flow account holders, the total Balance is $2.99M. Uniswap: Pool Names contributed 35.43% and Top 2 Names contributed 53.79% to total Balance. The top 2 wrapped account holders accounted for 40.71% of the total balance and the top 3 wrapped account holders accounted for 57.02%. Among the top 20 wallets, the lowest is 12.22K (0x39ad1f0c72cefc97d193ed7501f6edbae30a198d) and the highest is 1.06M (uniswap: pool). In total, the lowest Balance is 12.22K (0x39ad1f0c72cefc97d193ed7501f6edbae30a198d) and the highest Balance is 669.06K (0x7316b2515940a8573e34f45900e82763ad34a34a). The total balance for all Wrapped Account Holders for 18 Names is relatively even with 0% variation.

Observations

• Taking a look at the past 6 months data, we see that Active users are on the rise. In particular, we can see a sudden rise in recent active users in November 2022. Assume that it was caused by the launch of a new Hot Wheels collection. 
• When comparing the Nov (20-26) 2022 week to the previous week, we can clearly see the huge increase in the active wallet percentage. It may have been caused by the launch of the Hot Wheels collection during that time period.
• Based on this, we can see that the average fee per transaction has been drastically reduced. Based on the gas fee comparison with Ethereum, Dapper Lab’s blockchain finally solves the problem of Ethereum’s high gas fees and low transaction capabilities.
• As we can see from the above analysis, a total of 38.8% of the total balance was contributed by two top wallets, and 59.69% by four top wallets.  The highest balance in this example is 99.82M, which came from the wallet “0x8f77d48caf93fd93”.
• A total of 307.58K transactions were recorded among the top 20 account holders.  The highest is 302.88K (Token Transfers), which is done through token transfers.  This wallet (0x21dc51d454d46f49) performed the most transactions with 76.51K.
• According to the analysis, there are three Actions, but Action Token Transfers contribute the most to the total Transactions (98.47%). There is no variation in Transactions for 15 Account holders across all Actions.
• When we look at the top 20 wrapped flow account holders, Uniswap: Pool Names contributed 35.43%, which is the highest account holder. The amount is 1.06M from uniswap: pool.  We can conclude that Uniswap pool has the most Wrapped $FLOW balances of all Ethereum pools.
• Based on the above analysis, the wrapped account holder with the highest balance is 669.06K (0x7316b2515940a8573e34f45900e82763ad34a34a). Wrapped Account Holders’ total balances for 18 Names are relatively even, with 0% variation.
• The analysis also shows that wrapped flow accounts accumulate on the Ethereum chain despite the Flow blockchain.

Reference Query

1.
 with flow_daily_price AS (
   select 
   	date_trunc(day, timestamp) as date,
   	avg(price_usd) as flow_price
   FROM flow.core.fact_prices
   WHERE token = 'Flow'
   and timestamp >= CURRENT_DATE -{{days}}
   GROUP BY date
),
flow_data as (
  select 
    	to_date(block_timestamp) as date,
  		count(distinct proposer) as flow_active_wallets, 
  		avg(0.00001 * flow_price) as flow_avg_fee,
  		sum(0.00001 * flow_price) as flow_total_fee,
     	count(distinct case when tx_succeeded  then tx_id end) as flow_success_txns,
    	count(distinct case when tx_succeeded = false  then tx_id end) as flow_failed_txns,
    	flow_success_txns + flow_failed_txns as flow_total_txns,
    	flow_failed_txns / flow_total_txns * 100 as flow_failex_txn_perc
  from flow.core.fact_events
  INNER JOIN flow.core.fact_transactions  using (tx_id)
  INNER JOIN flow_daily_price ON date = to_date(block_timestamp) 
  where block_timestamp >= CURRENT_DATE -{{days}}
  group by 1
)

select * from flow_data
------------
2.
WITH balances as (
	SELECT 
  		wallet,
  		sum(amount) as balance
  	FROM (

        SELECT 
          	event_data:to as wallet,
          	event_data:amount as amount
        FROM flow.core.fact_events
        WHERE tx_succeeded
          AND event_data:to IS NOT NULL
          AND event_data:amount IS NOT NULL 
          AND event_contract = 'A.1654653399040a61.FlowToken'  
          and event_type = 'TokensDeposited'  
        UNION 
        SELECT 
          	event_data:from as wallet,
          	-1 * event_data:amount as amount
        FROM flow.core.fact_events
        WHERE tx_succeeded
          AND event_data:from IS NOT NULL
          AND event_data:amount IS NOT NULL 
          AND event_contract = 'A.1654653399040a61.FlowToken'  
          and event_type In ('TokensWithdrawn', 'MoveToken') 
	)
  WHERE (wallet is not  null OR wallet !='null')
  GROUP BY wallet
  QUALIFY row_number() over (order by balance desc )<=21
)
SELECT * FROM balances
WHERE wallet is not null or wallet !='null'
ORDER BY balance desc 
---------
3. 
WITH balances as (
	SELECT 
  		wallet,
  		sum(amount) as balance
  	FROM (

        SELECT 
          	event_data:to as wallet,
          	event_data:amount as amount
        FROM flow.core.fact_events
        WHERE tx_succeeded
          AND event_data:to IS NOT NULL
          AND event_data:amount IS NOT NULL 
          AND event_contract = 'A.1654653399040a61.FlowToken'  
          and event_type = 'TokensDeposited'  
        UNION 
        SELECT 
          	event_data:from as wallet,
          	-1 * event_data:amount as amount
        FROM flow.core.fact_events
        WHERE tx_succeeded
          AND event_data:from IS NOT NULL
          AND event_data:amount IS NOT NULL 
          AND event_contract = 'A.1654653399040a61.FlowToken'  
          and event_type In ('TokensWithdrawn', 'MoveToken') 
	)
  WHERE (wallet is not  null OR wallet !='null')
  GROUP BY wallet
  QUALIFY row_number() over (order by balance desc )<=21
),
top_wallets as (
	SELECT * FROM balances
	WHERE wallet is not null or wallet !='null'
  	ORDER BY balance desc
),
bridge_txns as (
  
	select 
  		flow_wallet_address as wallet, 
  		'Bride Transaction' as action,
  		count(tx_id) as txns
	FROM flow.core.ez_bridge_transactions
	WHERE FLOW_WALLET_ADDRESS IN (SELECT wallet from top_wallets)
  	GROUP BY wallet 
),
dex_txns as (
  
	select 
  		TRADER as wallet, 
  		'DEX Swap' as action,
  		count(tx_id) as txns
	FROM flow.core.ez_swaps
	WHERE TRADER IN (SELECT wallet from top_wallets)
  	GROUP BY wallet 
),
token_transfers as (
  
	select 
  		SENDER as wallet, 
  		'Token Transfers' as action,
  		count(tx_id) as txns
	FROM flow.core.ez_token_transfers
	WHERE SENDER IN (SELECT wallet from top_wallets)
  	GROUP BY wallet 
),
staking as (
  
	select 
  		DELEGATOR as wallet, 
  		'Staking Actions' as action,
  		count(tx_id) as txns
	FROM  flow.core.ez_staking_actions
	WHERE DELEGATOR IN (SELECT wallet from top_wallets)
  	GROUP BY wallet 
)
SELECT  * FROM staking
UNION 
SELECT  * FROM token_transfers
UNION 
SELECT * FROM dex_txns
UNION 
SELECT * FROM bridge_txns

------------

4. 

with balances as (
	select 
		USER_ADDRESS as wallet,
  		CURRENT_BAL as balance,
  		COALESCE(ctr.name, lbl.address_name, USER_ADDRESS) as name
	from ethereum.core.ez_current_balances bal 
  	LEFT JOIN ethereum.core.dim_contracts ctr ON bal.user_address = ctr.address 
  	LEFT JOIN ethereum.core.dim_labels lbl ON lbl.address = bal.user_address
	WHERE contract_address = lower('0x5c147e74D63B1D31AA3Fd78Eb229B65161983B2b')
  	qualify row_number() over(order by current_bal desc) <= 20
)
SELECT * FROM balances
WHERE wallet is not null or wallet !='null'
ORDER BY balance desc 

The purpose of this article is to discuss the Lido Protocol as it has developed over the past six months. On Lido, we can also see how user inflow and transactions have changed over time. The total number of ethereum stakes in Lido and the top most stakeholder of Lido should also be discussed.

Introduction : Overview About Lido

Lido is another application that also offers ETH2 liquid staking. Here we can see how does it works. In essence, Lido is an Ethereum smart contract that allows ETH holders with less than 32 ETH to pool their funds and earn rewards. Pooled funds are distributed among selected operators of Ethereum validators that are required for staking operations.

Lido also solves the liquidity problem of ETH stakers by issuing a special ERC20 token, stETH, at a 1:1 ratio when users deposit their ETH for staking. StETH tokens can be traded, transferred, and used in major Defi protocols, just like ETH. If a user wishes to unstake their ETH, they can sell stETH on Curve for ETH and use it however pleases them.

What is Lido and what problems does Lido solve?

Ethereum’s transition to proof of stake (PoS) began on December 1st, 2020, with the launch of the Beacon Chain. As a result, holders of Ethereum tokens were able to earn rewards by staking their tokens to protect the Ethereum network. However, staking is not something a typical ETH cryptocurreny holder can do because it requires extensive technical knowledge to make it work. Here are some issues associated with staking ETH tokens.

1. Technical expertise: It is important for a person to have the ability to install and update software all the time so as to stay current with the latest release of the stake module. The failure to run the software due to power outages or other issues results in a loss of rewards and in the worst case, staked Ethereum.

2. No unstaking: Due to the fact that Ethereum 2.0 has not yet been launched and no deadline has been set, once ETH tokens have been staked they cannot be withdrawn until Ethereum 2.0 is launched. Because there is no deadline for Ethereum 2.0 network launch, no one knows when they will be able to withdraw their funds. Probably by the end of 2023, maybe even earlier. All depends on how quickly Ethereum core developers complete the transition from Proof of Work to Proof of Stake.   

3. ETH Token requirements: In order to serve as a validator and stake tokens, one must have ETH tokens worth 32 ETH. At today’s ETH price it is more than 100,000 USD investment one must make to start earning staking rewards. 

Lido tackles all these problems head on and solves them elegantly. With LIDO, anyone can stake ETH tokens even if they only have a fraction of them. Lido’s liquid staking solution for Ethereum is backed by the biggest providers.

Approach

Our dashboard discusses the Lido Protocol and its growth for the past six months, in which we followed these steps:

• Lido: Users, Transactions, and Ethereum Inflow
  • Total users Inflow
  • Week over week growth of users inflow
  • number of Transactions
  • Week over week growth of transactions
  • Total Ethereum inflow
  • Week Over Week Growth Of Total Inflow Ethereum
• Lido’s To 10 Stakeholders
  • Top 10 Stakers Using Lido
  • Top 10 Stakers Staked Ethereum On WeeklyBasis
  • Top 10 Stakers Staked Ethereum On MonthlyBasis

Lido: Users, Transactions and Ethereum Inflow

Based on the below graph, we can see the number of users who have accessed Lido finance in the past six months. The total number of users between June 25, 2022 and November 25, 2022 was 50.44K. A maximum of 837 users was observed on November 17, 2022, and a minimum of 74 users was observed on June 29, 2022. Total Users are on an upward trend. On November 25, 2022 and August 15, 2022, the number of users is lower than normal, while on September 11, 2022 and September 15, 2022, the number of users is higher than normal. We can therefore conclude that the number of users has increased since Ethereum merged. As a result, users are attracted to the Ethereum Merge.

We can see from the tweet below that Ethereum Merge was launched on September 15, 2022.

And we finalized!

Happy merge all. This is a big moment for the Ethereum ecosystem. Everyone who helped make the merge happen should feel very proud today.

— vitalik.eth (@VitalikButerin) September 15, 2022

We can see from the graph below that user percentage increased suddenly in the week of Sept 11-17 2022 when compared to the previous week. It is this huge change in percentage that is responsible for the Ethereum Merge.

From the graph below, we can see how many transactions took place in Lido over the past six months. In this period, we can see that the trend of transactions has been increasing. Especially from Sept 2022 onwards, we can see the number of transactions has increased most. The reason for Ethereum’s merger might be related to that. From June 25, 2022 to November 25, 2022, 54.38K transactions were recorded. The total number of transactions in November 25, 2022 and August 15, 2022 is lower than normal, while in September 15, 2022 and September 11, 2022 it is higher than normal.

We can see from the graph below that transactions percentage increased suddenly in the week of Sept 11-17 2022 when compared to the previous week. It is this huge change in percentage that is responsible for the Ethereum Merge.

From the below graph we can see the ethereum staked in Lido for the past 6 months period. The Total Eth staked between June 25, 2022 to November 25, 2022 was $434.69K. Maximum Total Eth of $36.3K was observed in October 29, 2022 and minimum Total Eth of $69.38 was observed in July 6, 2022. The Ethereum staked in Lido is showing increasing trend when we compare with the initial dates in the above analysis. Total Total Eth in October 22, 2022 and July 22, 2022 is lower than normal and higher than normal in October 21, 2022 and July 21, 2022. There is a possibility that Lido is now on L2, which may explain the sudden rise in Ethereum stakes in October 2022.

A tweet below shows that the Lido has now been upgraded to L2. This can be seen as a benefit of lower gas fees, which may result in an increase in Ethereum stakes in Lido by October 2022.

Lido is now on L2

Bridge your staked ETH to Layer 2 protocols at the click of a button to benefit from lower gas fees and exciting DeFi opportunities.

— Lido (@LidoFinance) October 6, 2022

Between June 25, 2022 and November 25, 2022, the average Eth was 1.04K. October 25, 2022 had the highest average Eth of 73.28 and September 3, 2022 had the lowest average Eth of 0.34. Between June 25, 2022 and November 25, 2022, the average Eth increased by 10% from 1.83 to 2.02. The average Eth on October 22, 2022 and July 22, 2022 were lower than normal, respectively, and on October 21, 2022 and July 21, 2022 were higher than normal.

 Lido’s Top 10 Stakeholders

Staking and mining are two different phenomena related to cryptocurrency that are used for creating new coins and circulating them on the market. In mining, a miner solves computational equations to mine new coins and get rewarded. As part of staking, a staker deposits money into a cryptocurrency wallet to support the security and operation of a blockchain network. In its simplest form, staking is the process of locking cryptocurrencies to receive rewards for holding them.

Staking is a term used to refer to the delegating of a certain number of tokens to the governance model of the blockchain and thus locking them out of circulation for a specified length of time

Nicole DeCicco

The following graphs show the top 10 stakeholder entities using LIDO.  To identify the top stakers using Lido stake providers to stake Ethereum, we are using Lido stake providers. A total of 1.25M Ethereum stakes are held by the top 10 stakers. Only the top 3 stakers contributed more than 50% of Ethereum by using Lido of these top 10 stakers. In addition, we can see that more than quarter of the ethereum is staked by one staker, the “1inch.exchange: aggregation executor”.

Here from the below graph we can see how they are these top 10 stakers staked ethereum on weekly basis.

We can see from the graph below how these top 10 stakers staked Ethereum on a monthly basis. Over half (52.04%) of Staked Eth came from top three Stakers. During March 2022, the top user staked his entire ethereum portfolio in one attempt. Total staked by “ 1inch.exchange: aggregation executor” is in the top spot of all the top ten stakers. Moreover, the amount staked by this is the highest during April 2022. 

Observations

• The above analysis indicates that the number of transactions and number of users using Lido protocol have been increasing over the last 6 months. Especially, we can see that the number of users and transactions reached a peak on Sept 15th, 2022. As a result, we can conclude that the number of users and transactions has increased since Ethereum merged. Users are therefore attracted to the Ethereum Merge because of this we can say.
• Moreover, based on the above analysis, we can see that Ethereum stakes are increasingly entering Lido. October 2022 was the month when it happened more frequently. It is possible that Lido is now on L2, which would explain the sudden spike in Ethereum stakes in October 2022. Lido may benefit from lower gas fees, which could lead to an increase in Ethereum stakes during Oct 2022.
• The above analysis shows that during March 2022, the second highest staker staked his entire ethereum portfolio. In terms of staked, out of all the top ten shareholders, “1inch.exchange: aggregation executor ” has the most staked. The amount staked by this user is the highest during April 2022. As a result, we can say that most of the stakes by top 2 occurred between March and April of 2022. Considering that the release date of Ethereum Merge is very near, we may assume that all of this has already taken place. Later, when the announcement of the postponement of Ethereum merge was made, we might think that staking of Ethereum has perhaps fallen down as we can see from all other top stakers. As a result of the bear market, we have not seen top stakeholder performance after the merger.
• Based on the above analysis, it can be concluded that Lido stakers have decreased due to the bear market. However, we hope that the overall performance in terms of inflows of users, transactions, and stakes remains at the top when compared to the other staking system. As a result, Lido can be defined as Ethereum’s first and foremost liquid staking system.

Reference Query

WITH rp_events as (
  SELECT 
      	block_timestamp,
    	event_name,
  		tx_hash,
    	event_inputs:ethAmount/1e18  as eth_amount,  		
    	case event_name
    		when 'TokensMinted' then eth_amount
    		when 'TokensBurned' then -1 * eth_amount
    	end  as eth_amount_sign,
  		case event_name
    		when 'TokensMinted' then event_inputs:to::string
    		when 'TokensBurned' then event_inputs:from::string
    	end  as wallet,
  		event_inputs
  from ethereum_core.fact_event_logs  
  where contract_address = '0xae78736cd615f374d3085123a210448e74fc6393'
  and event_name IN ('TokensMinted','TokensBurned')
  and event_removed = false   
),
rp_daily_by_type as (
  select 
    to_date(block_timestamp) as date,
    case event_name
    		when 'TokensMinted' then 'Inflow'
      	when 'TokensBurned' then 'Outflow'
    end as direction,
    count(case event_name when 'TokensMinted' then tx_hash end) as Inflow_txns_count,
    count(case event_name when 'TokensBurned' then tx_hash end) as Outflow_txns_count,    
    sum(case event_name when 'TokensMinted' then eth_amount end ) as inflow_eth_total,
    sum(case event_name when 'TokensBurned' then eth_amount end ) as outflow_eth_total,
  	avg(case event_name when 'TokensMinted' then eth_amount end ) as inflow_eth_avg,
    avg(case event_name when 'TokensBurned' then eth_amount end ) as outflow_eth_avg,
  	count(distinct case event_name when 'TokensMinted' then wallet end) as inflow_wallet_count,
    count(distinct case event_name when 'TokensBurned' then wallet end) as outflow_wallet_count
  from rp_events
  GROUP BY 1,2
),
rp_results as (
  SELECT 
  		date, 
    	sum(Inflow_txns_count) as inflow_txns,
    	sum(Outflow_txns_count) as outflow_txns,
    	sum(inflow_eth_total) as total_inflow_eth,
    	sum(outflow_eth_total) as total_outflow_eth,
    	avg(inflow_eth_avg) as avg_inflow_eth,
    	avg(outflow_eth_avg) as avg_outflow_eth,  	
    	total_inflow_eth - total_outflow_eth as net_eth_flow,
    	sum(inflow_wallet_count) as inflow_wallets,
    	sum(outflow_wallet_count) as outflow_wallets
  FROM rp_daily_by_type 
  GROUP BY date
),
lido_stakers  as (
  SELECT 
    block_timestamp,
  	to_date(block_timestamp) as date,
    tx_hash,
    event_inputs:amount/1e18 as staked_amount,
    event_inputs:sender::string as wallet    
  from ethereum_core.fact_event_logs
  where contract_address = lower('0xae7ab96520de3a18e5e111b5eaab095312d7fe84')
    and event_name = 'Submitted'
    and event_removed = false 
),
lido_daily as (
  SELECT 
  	date, 
  	count(tx_hash) as inflow_txns,
  	sum(staked_amount) as total_inflow_eth,
  	avg(staked_amount) as avg_inflow_eth,
  	count(distinct wallet) as inflow_wallets  
  FROM lido_stakers
  GROUP BY date
)
SELECT 
	'Lido' as app, 
	date, 
	inflow_txns,
	total_inflow_eth,
	avg_inflow_eth,
	inflow_wallets
FROM lido_daily
UNION 
SELECT 
	'RocketPool' as app,
	date, 
	inflow_txns,
	total_inflow_eth,
	avg_inflow_eth,
	inflow_wallets
from rp_results

-------------------
2. 
with lido_stakers  as (
  SELECT 
    block_timestamp,
  	to_date(block_timestamp) as date,
    tx_hash,
    event_inputs:amount/1e18 as staked_amount,
    event_inputs:sender::string as wallet    
  from ethereum_core.fact_event_logs
  where contract_address = lower('0xae7ab96520de3a18e5e111b5eaab095312d7fe84')
     -- AND block_timestamp > CURRENT_DATE - 7
    and event_name = 'Submitted'
    and event_removed = false 
),
top_stakers as (
  SELECT 
  	wallet,
  	sum(staked_amount) as staked_eth
  FROM lido_stakers 
  GROUP BY wallet
  ORDER BY staked_eth DESC 
  LIMIT 10
)
SELECT 
	date,
  	NVL(address_name, wallet) as staker,
  	sum(staked_amount) as staked_eth   	
FROM lido_stakers
LEFT JOIN ethereum_core.dim_labels ON address = wallet
where wallet IN (SELECT wallet from top_stakers)
GROUP BY 1,2

As part of this article, we focus on NFT activities in Solana since January 2022. Additionally, here is a comparison of NFT activity between Solana and Ethereum.

We have different NFT marketplaces in Solana. Forexample, Solport and MagicEden are more popular NFT marketplaces .Here lets discuss a small introduction about them .

Magic Eden

Magic Eden NFT is the most popular market on Solana. Known as Magic Eden, it facilitates buying, selling, and minting of NFTs on the Solana Network.The goal is to become the source for finding, trading, and creating NFTs of all types online. Magic Eden, the number one NFT platform on Solana, has done an impressive $2 billion in trading volume in its first two months following its launch.

Solport

The Solport Marketplace is the leading marketplace for trading Solana NFTs. Using the NFT marketplace on Solana App, Solport launched V2 on March 12th, which includes a variety of new features for marketplaces and mobile apps. Solport is simple to use. You can connect your wallet by clicking “Connect Wallet” in the top right of the website. Your wallet address appears once you log in. Afterward, click again to navigate to “Your Account,” where you can see and list your verified NFTs for sale. Click “Collections” on the website header to explore! Here, Solport charges 2% commission to sellers. There is no fee for submitting, unsubmitting, or canceling an offer..

Approach

With this dashboard, we can see how NFTs are performing their sale activities in Solana since January 2022. We can also see the comparison of NFT activity between Solana and Ethereum. As part of this, we track the following metrics with Solana NFTs.

• The total number of mints since January 2022 and their growth rates
• The total amount of NFT sales and growth rates since January 2022
• The total number of wallets that have minted or purchased a Solana NFT, as well as the growth rate since January 2022
• As a next step, we can look at the NFT Sales Transactions between Solana and Ethereum
• Next, we can take a look at the growth of new users buying and mining NFTs – Solana vs Ethereum
• Here are the week over week changes in new users purchasing / minting NFTs – Solana and Ethereum

Based on the graph below, we can see how many NFTs have been minted in Solana since January 2022. As we can see here, Solana’s NFT production suddenly hit an all-time high in early September 2022. A downtrend in the minted rate was observed in Solana blockchain later on.  As the y00ts project opened on Sept 7th 2022, Solana had its best day in a long time with more than 200K SOL (4K ETH) in volumes. As a result, various SOL projects saw massive spikes in daily volume.

Note : Here the y00ts is a generative art project of 15,000 NFTs. We are writing it as a love letter to the Web3 community. Designed with aesthetics in mind. Functionality is engineered into the design. An online community of builders and creators curated to contain the best talent. As a result, the Solana blockchain is attracted by a larger number of users.

The graph below shows that initially, there weren’t many NFT mints in Solana. From May 2022 onward, we see an increasing trend, and in early September 2022, we observe a sudden rise. Maximum Transactions of 323.23K was observed in September 7, 2022 . As a result of the introduction of the y00ts project, this has happened.

As we can see from the tweet below,

Pinning this tweet so we can start focusing on memes/supporting the community.

If you’re on the waitlist, please wait for an official announcement for when that opens up.

If you have already have a spot, you can still mint your t00b on our website. https://t.co/iU9IucifRF

— y00ts (@y00tsNFT) September 6, 2022

According to the graph below, NFT sales transactions have been occurring in Solana since January 2022. During the period of January 1, 2022 to November 23, 2022, NFTs sales transactions totaled $17.34 million. The maximum Sales Transactions of $255.32K were observed on September 7, 2022, and the minimum Sales Transactions of $19.53K were observed on May 1, 2022. Sales transactions decreased between January 2022 and November 2022. Nevertheless, we can see a sudden spike in NFT sales transactions on Sept 7 2022. Our suspicions could be that the Y00TS project is responsible for what happened.

From the below graph we can see the active users which are minting in Solana . Assuming that the active users are minting on Solana, the total number of active users was 4.19M from January 1, 2022 to November 23, 2022. The maximum number of users was 32.09K on August 13, 2022. The number of active users is declining in cases of minting. There might be a reason for this due to the crypto volatility. In the current bear market situation in crypto, users minting has decreased.

There were 5 million buyers of NFTs on Solana between January 1, 2022 and November 23, 2022. The maximum number of buyers was 27.45K on September 7, 2022. In the period of Jan 2022 to Nov 2022, the total number of buyers of NFTs decreased. That means there is a downward trend for NFT buyers. It may be due to the volatility of the market and crypto’s bear market that buying NFTs has decreased.

From the below heat map we can see a clear view of new users which are buying/minting NFTs in Solana Since Jan 2022.

Based on the below graph, we can see that a new user has been buying/minting NFTs since Jan 2022. There were 1.45M new users between January 1, 2022 and November 23, 2022. August 13, 2022, was the day of maximum new users of 21.61K, while November 17, 2022 was the day of minimum new users of 629. There were 3,39K new users in January 1, 2022, but there were only 2.4K by November 23, 2022, a 29% decrease. It appears that there is an increasing trend of new users purchasing / minting NFTs in Solana. In the near future, we can expect this to be a positive sign that the market will resume its boom.

In the period of January 1, 2022 to November 23, 2022, the total sales volume (sol) was $35.35M. A maximum Sales Volume (sol) of $417.96K was observed on May 24, 2022, and a minimum Sales Volume (sol) of $37.22K was observed on August 15, 2022. Compared to the initial days, sales volume (sol) increased almost three times from $40.01K to $123.64K in November 23, 2022. During the period January 1, 2022 to November 23, 2022, there was a total of 16.45 million mints. A maximum of 978.42K mints volumes were observed in August 11, 2022, and a minimum of 1.02K were observed in November 9, 2022. The total number of mints (sol) decreased from 9.3K on January 1, 2022 to 6.63K on November 23, 2022. Cryptocurrency’s bear market is responsible for all of this.

NFTs Sales In Solana Vs Ethereum

In this section , we can see the comparison of NFTs sales transaction in both Solana and Ethereum blockchains . The total number of Ethereum sales transactions between W52, 2021 and W44, 2022 was 16.72M. W5-2022 observed the maximum Ethereum sales transaction number of 541.93K, and W52-2021 witnessed the lowest transaction number of 56.66K. There were 16.57M in sales transactions between W52, 2021 and W44, 2022 for Solana. The maximum number of Solana sales transactions was 991.72K in W36, 2022, and the minimum number was 22.86K in W52, 2021. There was a decrease in the overall sales transactions of Ethereum and Solana.

Below is a graph showing the percent of NFT sales transactions between Solana and Ethereum since Jan 2022. The total percentage of Ethereum sales transaction between January 1, 2022 and October 31, 2022 decreased. The sales transaction percentage for Solana has been rising from January 1, 2022 to October 31, 2022.

Based on the total number of new users minting / buying NFTs on both platforms, Ethereum contributes the most (68.97%) to the total new users of the two platforms. On Solana, we can see that new users are increasing over time when we compare the growth there with the growth in the beginning. Additionally, we notice that the number of new Ethereum users has decreased since the beginning. The maximum number of new users was observed on September 15, 2022, which is due to the Ethereum merge. There may have been a high minting on that specific day as a result of this merge attracting a lot of new users.

Below is a graph showing the comparison of new users buying/minting NFTs in both the Solana and Ethereum blockchains. When compared with the previous week, the growth of Solana new users buying/minting NFTs almost reached 98% during the week of Aug 07-13 2022.

Observations

• Initially, we didn’t see a lot of NFT mints in Solana, as shown in the above analysis. Nevertheless, we can see an increasing trend from May 2022 onwards, and we also observed a sudden spike in early September of 2022. During September 7, 2022, a maximum of 323.23K transactions were recorded. As a result of the introduction of the y00ts project.
• In cases of minting in Solana, the number of active users is declining. Because of the volatility of cryptos, this might be the reason. Crypto markets are currently in a bear market situation, which has reduced users minting.
• According to the above analysis, NFT buyers are declining in Solana. NFT buying may have decreased because of market volatility and crypto’s bear market.
• During the period January 1, 2022 to November 23, 2022, the total number of mints (sol) decreased from 9.3K to 6.63K. The bear market in cryptocurrency is to blame for all of this.
• It is evident from the above analysis that NFT sales transactions of Ethereum and Solana decreased.
• According to the above analysis, Ethereum sales transactions decreased between January 1, 2022 and October 31, 2022. The number of sales transactions for Solana has increased from January 1, 2022 to October 31, 2022. As we can see, sales transactions were increased in Solana due to the y00ts project in early September 2022.
• When we compare Solana’s growth with its growth at the beginning, we can see that new users are increasing over time. Additionally, we observe a decrease in new Ethereum users since the beginning of the analysis. As a result of the Ethereum merge, the most number of new users was observed on September 15, 2022.
• During the week of Aug 07-13 2022, the number of new Solana users buying/minting NFTs almost reached 98% compared to the previous week.
• We can see from the above analysis that there is an increase in NFT mints in Solana in September early releases. Afterwards, we can also see a significant increase in sales transactions on Solana. We can assume that these changes were made by the y00ts project. Therefore, we cannot say whether the y00ts will have staying power, but there’s definitely more excitement over on SOL right now. There are also many people who are attracted to this y00ts NFT. Hope this will continue to increase this ecosystem’s growth, as well as this should continue in the near future. Let’s hope the best!

Reference Query

WITH sol_mints as (
	select 
		mint.block_timestamp, 
  		mint.tx_id,
  		mint.mint_price,
  		purchaser
	from solana.fact_nft_mints as mint  
  	where succeeded
  	and mint_currency ='So11111111111111111111111111111111111111111'
),
sol_mint_metrics as (
  select 
  	date_trunc('day', block_timestamp) as date,  	
  	count(tx_id) as sol_mint_txns,
  	sum(mint_price) as sol_total_min_vol,
  	count(distinct purchaser) as sol_mint_purchasers  
  from sol_mints
  group by date 
),
sol_sales as (
	select 
		block_timestamp, 
  		tx_id,
  		sales_amount,
  		purchaser
	from solana.fact_nft_sales  
  	where succeeded   	
),
sol_sales_metrics as (
  select 
  	date_trunc('day', block_timestamp) as date,  	
  	count(tx_id) as sol_sale_txns,
  	sum(sales_amount) as sol_total_sale_vol,
  	count(distinct purchaser) as sol_sale_purchasers  
  from sol_sales  
  group by date 
),

sol_users as (
  	select 
  		block_timestamp,
  		purchaser 
  	from solana.fact_nft_sales 
  	where succeeded
  	UNION 
  	select 
  		block_timestamp,
  		purchaser 
  	from solana.fact_nft_mints
  	where succeeded
),
sol_user_first_tx as (
  	select 
  		block_timestamp,
  		purchaser
  	from sol_users
  	QUALIFY row_number() over(partition by purchaser order by block_timestamp) = 1
),
sol_user_growth as (
  	select 
  		date_trunc('day', block_timestamp) as date,
  		count(purchaser) as new_users  	
  	from sol_user_first_tx
  	group by 1
),

sol_mav_mints as (
  SELECT 
   	block_timestamp,
    	date_trunc('day', block_timestamp) as date,
    	tx_id,
    	purchaser,
    	mint_price,
    	mint,
    	case when program_id = 'cndyAnrLdpjq1Ssp1z8xxDsB8dxe7u4HL5Nxi2K5WXZ' then 'Candy Machine v1' else 'Candy Machine v2' end as cm_version 
  FROM solana.fact_nft_mints
  WHERE program_id IN ('cndy3Z4yapfJBmL3ShUp5exZKqR3z33thTzeNMm2gRZ', 'cndyAnrLdpjq1Ssp1z8xxDsB8dxe7u4HL5Nxi2K5WXZ')
  AND succeeded  
  and mint_currency ='So11111111111111111111111111111111111111111'
),
candy_by_version as (
	select 
		date,   		
  		cm_version,
		count(distinct purchaser) as purchasers,
  		count(tx_id) as total_mints,
  		avg(mint_price) as avg_mint_price_sol,
  		sum(mint_price) as total_mint_volume_sol  	
	from sol_mav_mints   		
	group by date, cm_version 
),
candy_v1 as (
  	select 
  		date,
  		purchasers as cv1_purchasers,
  		total_mints as cv1_total_mints,
  		total_mint_volume_sol as cv1_tot_mint_volume_sol
  	from candy_by_version
  	where cm_version = 'Candy Machine v1'
),
candy_v2 as (
  	select 
  		date,
  		purchasers as cv2_purchasers,
  		total_mints as cv2_total_mints,
  		total_mint_volume_sol as cv2_tot_mint_volume_sol
  	from candy_by_version
  	where cm_version = 'Candy Machine v2'
),
eth_sales as (
  select   	
  	to_date(block_timestamp) as date,
  	count(distinct buyer_address) as eth_nft_users,
    count(distinct tx_hash) as eth_nft_sales  	
  from ethereum.core.ez_nft_sales
  where block_timestamp >=  '2021-12-01'
  	and event_type = 'sale'
  GROUP BY date 
),
sol_metrics as (
  select 
  	sol_sales_metrics.*,
  	sol_mint_metrics.sol_mint_txns,
  	sol_mint_metrics.sol_total_min_vol,
  	sol_mint_metrics.sol_mint_purchasers,
  	sol_user_growth.new_users as sol_new_users,
  	candy_v1.cv1_total_mints,
  	candy_v1.cv1_purchasers,
  	candy_v1.cv1_tot_mint_volume_sol,
  	candy_v2.cv2_total_mints,
  	candy_v2.cv2_purchasers,
  	candy_v2.cv2_tot_mint_volume_sol,
  	eth_sales.eth_nft_users,
  	eth_sales.eth_nft_sales
  from sol_sales_metrics
  inner join sol_mint_metrics using (date)
  inner join sol_user_growth using(date)
  left join candy_v1 using (date)
  left join candy_v2 using (date)
  left join eth_sales using (date)
)
SELECT 
  * 
FROM sol_metrics

On the Ethereum Mainnet, Thorswap x Sushi Onsen Farm has been launched. The Dashboard explores how users stake their liquidity on this new farm.

• What is the amount of funds that have been transferred from the old contract to the new contract? Is there any remaining in the old one?
• Has the liquidity of many unique wallets already been moved over? What is the number of people who still have to switch?

The Onsen Farm: An Overview 

There are a number of cryptocurrency yield farming pairs available through Onsen. Investing in this is an excellent way to gain an income from idle tokens you’ve been hoarding. Liquidity providers who decide to farm their liquidity are rewarded with $SUSHI tokens.

The Onsen service offered by Sushiswap aims to provide liquidity to certain pools by incentivizing participation.  A special feature of Onsen Menus is that Liquidity Providers can stake their existing LP tokens for bonus rewards. Therefore, depositing and staking tokens to the platform is an effective way to earn rewards and fees. SushiSwap’s THOR-ETH liquidity providers can stake their SLP tokens in THORSwap’s Onsen farm to receive additional liquidity mining rewards – including both $SUSHI and $THOR.There is no due date for THORSwap’s Onsen farm, which rewards both $SUSHI and $THOR. Transaction volume and pool TVL will determine rewards size.We are increasing rewards for LP’ers by launching the THOR/ETH Onsen Farm and decreasing slippage on SushiSwap when trading $THOR.  

On July 26th, Thorswap x Sushi Onsen Farm was launched on Ethereum mainnet for the $THOR token, according to the tweet below.

Great news! @THORSwap has partnered with @SushiSwap to launch an Onsen farm for $THOR!

THOR-ETH Liquidity Providers can now stake their SLP tokens to receive additional liquidity mining rewards :  in the form of BOTH $SUSHI & $THOR

https://t.co/7eVjmvnz13

1/ Threadpic.twitter.com/2YyucN5tqd

— THORSwap for $vTHOR (@THORSwap) July 26, 2022

How does SushiSwap provide liquidity between $THOR and $ETH?

In addition to earning token rewards, LPs can improve $THOR market efficiency by providing pool liquidity on SushiSwap. Each liquidity provider receives a share of the trading fees. The $THOR rewards were obtained via our own LP farming contract previously. We will deprecate this and replace it with the new $THOR Onsen Farm, where LPers can earn additional $THOR and $SUSHI staking rewards.

After $THOR listing on SushiSwap (3rd phase), Staking will be enabled immediately for 3 reward pools.

– Stake $THOR
– Stake THOR-ETH LP
– Provide Liquidity on THORChain (no need to stake, just provide liquidity for THOR pool)

Starting APY will be triple or four figures.

— THORSwap for $vTHOR (@THORSwap) October 30, 2021

Approach

This dashboard shows how Thorswap x Sushi Onsen Farm has performed since it was launched on the Ethereum Mainnet, as well as the way users have staked their liquidity. In that process,

• We can see here the growth of users which are interacting with WETH/THOR Liquidity pool by comparing with Legacy pool vs Onsen pool
• WETH/THOR Pool – Interactions With Legacy Contract vs Onsen Contract
• ETH/THOR Legacy Pool – Net Balance and Daily Change Overtime
• ETH/THOR Onsen Pool – Net Balance and Daily Change Overtime
• ETH/THOR Wallets Transferred Liquidity From Legacy Pool to Onsen Pool

In the below graph, we can see how users are interacting with WETH/THOR Liquidity Pool by comparing it with Legacy pool and  Onsen pool. We considered the legacy pool of Sushiswap, initially there was not much growth with new users, but later it appears that growth is increasing. Nevertheless, here we can see that the legacy pool has been trimmed of the complete growth in users after July 2022. The number of users has been increasing on the Onsen pool since July. 

WETH/THOR pool interaction numbers with Legacy contract and Onsen contract, shown in the graph below, and also here we can see that the full legacy contracts were not there from July 2022. We can therefore consider that this happened after the Onsen pool was launched. While initially we can see that there were more interactions on Legacy pool, we can see that they are trending downwards. Due to the volatility of the crypto market, not many users interact with the pools. From July 2022 on, ‘THOR-ETH Liquidity Providers can stake their SLP tokens into a liquidity mining pool to receive both $SUSHI and $THOR’. The interactions have increased again since the launch of Onsen Farm.

On the following graph, we can see the Net balance and daily changes of the ETH/THOR legacy pool over time.  Observed maximum Daily Change of 11,130.07 in November 7, 2021, and minimum Daily Change of -5,845.46 in May 6, 2022. From 11,130.07 in November 7, 2021 to 12.78 in July 29, 2022, the total daily change decreased by 100%. Maybe it’s because of the volatility of the crypto market. 

We can see the Net balance and daily changes of the ETH/THOR Onsen pool in the graph below.   From July 26, 2022 to August 27, 2022, there was a total daily change of 1.87K. Initially, we can see the maximum daily change, then it went down, and then it is again becoming an increasing trend. The total Net Balance between July 26, 2022 and August 27, 2022 was 7.81K. July 26, 2022, had a minimum Net Balance of 981.67 and August 27, 2022, had a maximum Net Balance of 1.87K. Between July 26, 2022 and August 27, 2022, the total net balance increased. 

As you can see in the graph below, ETH/THOR has only one wallet that has moved its liquidity from Legacy pool to Onsen pool. The following graph shows from Legacy pool on 27th July 2022 at 7:01:12 the wallet ‘0xbe61359a90eea3be6b8169ac2a098b0945e1d55’ withdrew an amount of 12.70 and again on 27th July 2022 at 7:02:08 the same wallet has deposited 12.78 amount into Onsen pool. That means from this analysis we can say a single account transfers was happened from Legacy pool to Onsen pool . Since crypto volatility is causing a reduced number of stakes, we can presume that staking wasn’t happening much on the market. 

Observations

• If we look at the new user growth on Sushiswap’s legacy pool, initially there wasn’t much growth with new users, but later it appears that growth has increased. Nonetheless, we can see in this screenshot that the legacy pool has been trimmed of the entire growth in users after July 2022. The number of users at the Onsen pool has increased since July.
• We can see from the above analysis that Sushiswap Legacy Pool’s wallet growth stopped after the launch of the Onsen pool. 
• The number of interactions on Legacy pool initially appeared to be higher, but they are trending downward. Cryptomarket volatility has resulted in few users interacting with pools.
• Furthermore, we can see that the number of interactions has increased again since the launch of Onsen Farm. In this Onsen farm, we are able to see this growing number of interactions due to the advantage of ‘THOR-ETH Liquidity Providers can stake their SLP tokens into a liquidity mining pool to receive both $SUSHI and $THOR’. 
• The total daily change on Sushiswap legacy pool has also decreased by almost 100%, which may be a result of the volatility in the crypto market. 
• At first, we could see the maximum daily change, then it fell, and then it began to increase again on Sushiswap Onsen pool. Stakeholders might be exploiting this opportunity because if they mine into this pool, they will receive both $SUSHI and $THOR. 
•  In this analysis, we find that from Legacy pool, in a time frame of 7:01:12 on 27th July 2022, the wallet ‘0xbe61359a90eea3be6b8169ac2a098b0945e1d55’ withdrew an amount of 12.70, and again in a time frame of 7:02:08 on 27th July 2022, the wallet has deposited 12:78 into Onsen pool. Based on this information, we can conclude that only one account was transferred from Legacy pool to Onsen pool. Crypto volatility has caused a reduced number of stakes, so we can assume staking was not happening much. 

Reference Query

WITH onsen as (
SELECT 
  tx_hash,
  block_timestamp,
  FROM_ADDRESS as wallet
FROM ethereum.core.fact_transactions 
WHERE tx_hash IN (
	SELECT 
		tx_hash
	from ethereum.core.fact_event_logs
	WHERE origin_to_address = '0xef0881ec094552b2e128cf945ef17a6752b4ec5d'
    	and contract_address = '0x3d3f13f2529ec3c84b2940155effbf9b39a8f3ec'
)
AND STATUS = 'SUCCESS'
QUALIFY row_number() over(partition by FROM_ADDRESS order by block_timestamp asc) = 1
),
onsen_growth as (
  SELECT 
  	'Sushiswap Onsen Pool' as pool,
  	date_trunc(day, block_timestamp) as date, 
  	count(wallet) as new_users
  FROM onsen
  GROUP BY date 
),
staking as (
SELECT 
  tx_hash,
  block_timestamp,
  FROM_ADDRESS as wallet
FROM ethereum.core.fact_transactions 
WHERE tx_hash IN (
	SELECT 
		tx_hash
	from ethereum.core.fact_event_logs
	WHERE origin_to_address = '0xae1fc3947ee83aeb3b7fec237bcc1d194c88bc24'
    	and contract_address = '0x3d3f13f2529ec3c84b2940155effbf9b39a8f3ec'
)
AND STATUS = 'SUCCESS'
QUALIFY row_number() over(partition by FROM_ADDRESS order by block_timestamp asc) = 1
),
staking_growth as (
  SELECT 
  	'Sushiswap Legacy Pool' as pool,
  	date_trunc(day, block_timestamp) as date, 
  	count(wallet) as new_users
  FROM staking
  GROUP BY date 
)
SELECT * FROM staking_growth
UNION 
SELECT * FROM onsen_growth

Our focus in this article is to study the ethereum.core.fact_blocks table,

• Are there certain miners that prefer mining blocks with fewer transactions?
• Are some miners only mining blocks with high transaction counts?
• By analyzing the distribution of transaction counts, you can determine what constitutes low or high transaction counts

Overview Of Ethereum Miners

On Ethereum’s blockchain, mining involves creating blocks of transactions. Traditionally, mining is used to describe crypto currencies as gold analogies. Digital tokens are also scarce, and mining is the only way to increase their volume. Ethereum is also the only currency that can be issued post launch through mining. The mining process creates, verifies, publishes, propagates and secures blocks in the blockchain, unlike these examples.

Keeping the network secure by mining ether. Ethereum is a decentralized system that needs everyone’s agreement on how transactions should be ordered. In order to protect the network from attacks, miners solve computationally difficult puzzles.

After Sep 14th 2022, we will no longer be able to mine Ethereum once the Ethereum merge is launched. The following tweet provides information about this proposal.

Before we get to the steps, what is happening again?

Ethereum is going through an upgrade where it will transition from Proof of Work to Proof of Stake. After the transition, ETH miners can no longer mine. Miners are forking ETH to keep a PoW version so they can continue mining.

— Bobby Ong (@bobbyong) September 5, 2022

Approach

Using the ethereum.core.fact_blocks table in this dashboard,

• Our focus was on finding the number of transactions mined per block, as well as the distribution of blocks with the number of transactions
• As a next step, we can see the numbers of transactions processed by miners compared to average transactions, as well as their percentages on a daily basis.
• In the next part, we will see how miners are distributed by the number of transactions mined per block
• Furthermore, we can also see the miners who frequently mined more than 500 txns per block
• Lastly, we will look at the top 10 miners and their top 5 block sizes, which are selected individually by each miner.

From the graph below, you can see the minimum, maximum, and average transactions mined per block for the past 60 days. According to the graph below, the minimum number of transactions mined per block is between 2-3.  During July 26 2022, a maximum of 273.42 average transactions were recorded. On Sep 04 2022, we can observe a maximum of 1418 maximum transactions, and on August 30, 2022, we can observe a minimum of 702 maximum transactions. The maximum transactions that are mined on a blockwise basis are showing a downward trend. There may be a reason for this because the Ethereum merge is removing the mining. 

We can see here the distribution of blocks based on the number of transactions. The total number of mined blocks across all buckets is 371,708. 46.84% of the total mined blocks came from the top two buckets, while 64.5% came from the top three buckets. The lowest number of Mined Blocks is 41 (S.901 to 950 txns), while the highest number is 87,056 (A.1 to 50 txns).

Between July 11, 2022 and September 9, 2022, there were 3.1K miners. Out of the two categories, Processed Txns.Below Average contributes the most (68.12%) to the total Miners. In this case, the lowest number of processed transactions is 987 (Processed Txns. Above Average), whereas the highest number is 2.11K (Processed Txns. Below Average). It was observed that the maximum number of miners was 55 on July 29, 2022, and the minimum number of miners was 46 on September 1, 2022. Here we can see processed Txns.below Average has a steady percentage of Miners.

From the below graph out of the two categories, Processed Txns.Below Average contributes the most to the total miners which is almost 70%.

According to the graph below, we can see how miners have distributed the number of transactions mined per block over the past 60 days. We can see that a maximum of 50 txns are mined per block by a maximum number of miners. There are a total of 19 categories of transactions taking place with miners per block. Among the top 5 mining categories, transactions per block are between 1 and 250. A very small number of miners fall under the category of 901-950 transactions mined per block. 

The following graph shows the miners who mined more than 500 Txns per block frequently for the past 60 days. We can see that the total number of blocks mined is 1,272. A total of 49.69% of total blocks were mined by 0xea674fdde714fd979de3edf0f56aa9716b898ec8 Miners, and 66.9% were mined by the top 2 miners. A total of 42.06% of total blocks mined were from K.501 to 550 txns, and 57.94% of total blocks mined were from the Top 2 blocks.  The lowest total number of blocks mined is 5 (0x2a20380dca5bc24d052acfbf79ba23e988ad0050), while the highest total number of blocks mined is 632 (0xea674fdde714fd979de3edf0f56aa9716b898ec8). A total of 24 blocks have been mined (S.901 to 950 tracts) and 535 blocks have been mined (K.501 to 550 tracts).

Below is a graph that shows miners who mine less than 500 Txns per block frequently. The total number of blocks mined is 365.58K. In total, the 0xea674fdde714fd979de3edf0f56aa9716b898ec8 Miners contributed for 27.57%, and the Top 3 Miners contributed for 52.78%. 47.36% of total blocks mined came from the top two blocks, and 65.2% came from the top three blocks. 0x6a0806cca96c0600224de365f45b9e042c03e35b is the lowest total Blocks Mined and 0xea674fdde714fd979de3edf0f56aa9716b898ec8 is the highest total Blocks Mined. The low total number of Blocks Mined is 910 (J.451 to 500 txns) and the highest total number of Blocks Mined is 86,593 (B.51 to 100 txns). 

The total number of mined blocks across the top 10 miners is 292K . More than 30% of total mined blocks were contributed by 0xea674fdde714fd979de3edf0f56aa9716b898ec8, while more than half contributed by the Top 2 Miners. The lowest mined blocks total is 9K (0x3ecef08d0e2dad803847e052249bb4f8bf2d5bb) while the highest is 101K (0xea674fdde714fd979de3edf0f56aa9716b898ec).

Based on the top 5 block sizes selected by Miner #1, the maximum number of transactions chosen by this miner is 1-50 transactions, followed by 51-100 transactions. The most popular transaction categories for Miner#2 and 3 out of their top 5 block sizes are 1-50 transactions and 51-100 transactions.  From Miner#4 and Miner#5, 51-100 transactions were selected out of their total transactions from each. Miner#8 can be seen to have almost 60% of his transactions falling between the 1-50 range of transactions. Most of the categories of miner#10’s top 5 chosen categories are in more than 20%, except the category ‘1 to 50 transactions’. That means this miner doesn’t choose the category of ‘1-50 transactions’ very often.

Based on individual analyses of these Top 10 miners, the majority of the miners have selected the ‘1-50 transactions’ and ’51-100 transactions’ categories for their transactions.

Observations

• From the above analysis, we can see that the minimum number of transactions mined per block is 2-3.  A maximum of 273.42 average transactions were recorded during July 26 2022. The maximum number of transactions on Sep 4 2022 was 1418, while the minimum number of transactions on August 30, 2022 was 702.
• There is a downward trend in the maximum number of transactions mined on a block-by-block basis. Possibly, the mining has been removed as a result of the Ethereum merge. 
• Also, from the above analysis, we see that a maximum number of miners mines a maximum of 50 transactions per block.  There are just a few miners who mine between 901 and 950 transactions per block. 
• A total of 1,272 blocks have been mined by miners who mine more than 500 transactions per block frequently. There are 365.58K blocks mined by miners who mine fewer than 500 transactions per block. As can be seen from the graph, more miners use fewer than 500 transaction categories for mining.
• According to the individual analyses of these Top 10 miners, the majority of their transactions fall into the categories of ‘1-50 transactions’ and ’51-100 transactions’.

SQL Reference

with 
miner_txns as (
  SELECT 
    	MINER,
    	tx_count,
  		block_number,
    	width_bucket(tx_count, 1, 1500, 20) as bucket_number,
    	concat(chr(64+bucket_number), '.', ((bucket_number - 1) * 50) + 1 , ' to ', bucket_number * 50, ' txns') as bucket,
  		tx_count
  FROM ethereum.core.fact_blocks
  where tx_count > 1
  
  and block_timestamp >= CURRENT_DATE - {{days}}
),
miner_blocks as (
  	select 
  		miner,
  		count(block_number) as total_blocks_mined
  	from miner_txns
  	GROUP BY miner
),
miner_buckets as (
  	select 
  		miner as miner,
  		bucket,
  		count(block_number) as blocks_mined
  	from miner_txns
  	group by miner, bucket
),
miner_blocks_bucket as (
  	select 
  		miner_buckets.*,
  		blocks_mined / total_blocks_mined * 100 as perct_mined
  	from miner_blocks
  	INNER JOIn miner_buckets using (miner)
)
SELECT * FROM miner_blocks_bucket

Introduction

The BendDAO protocol is the first NFT liquidity protocol that is built on the peer-to-pool model. Depositors earn interest by providing ETH liquidity through the lending pool, while NFT holders borrow ETH with NFTs as collateral. Leveraged NFT trading is based on instant NFT-backed loans. The BendDAO protocol supports instant NFT-backed loans, collateral listing, and NFT down payments. With an entirely seamless experience that enables users to make down payments, borrow funds, and list their NFTs, a one-stop liquidity solution is created.

NFT holders who want liquidity but do not want to sell their NFTs can take advantage of lending protocols like BendDAO, but such lending services are also vulnerable to liquidity issues.In essence, the goal is to entice buyers to acquire the NFT collateral with liquidation. 

Benefits of Introducing BendDAO in NFT System

• There will be equal rights for borrowers: Bluechip NFT collections will receive airdrops regularly. When NFTs are used in the collateral pool, BendDAO will collect and distribute airdrops to borrowers.
• A NFT will be converted into an ERC-721 boundNFT that represents an NFT loan, and it will never be stolen. Due to their transferability, boundNFTs cannot be stolen. 
• There is often a lack of liquidity in the NFT market, resulting in price fluctuations. In order to avoid losses, BendDAO has a mechanism that allows users to repay their loans within 48 hours.

From the below graph we can see the ETH deposited and withdrawn into BendDAO over a time period. As well as we can see the NET ETH also here .

• Between August 7, 2022 and September 7, 2022, there were 168.11K ETH deposits. In August 25, 2022, the maximum ETH Deposits were recorded at 22.46K, while the minimum ETH Deposits were recorded at 197.33 on August 9, 2022. The total number of Ethereum deposits increased by 3.54 times from 2.02K in August 7, 2022 to 9.19K in September 7, 2022. The total number of ETH deposits in August 28, 2022 and August 26, 2022 is lower than usual. The number of deposits initially appears to be less. As time went on, they began to increase. The ETH deposits can see here are in increasing trend. 
• As of September 7, 2022, -87.51K ETH were withdrawn. The maximum withdrawal of -113.74 ETH was observed on August 7, 2022, and the minimum withdrawal of -16.17 ETH was observed on August 20, 2022. In August 20, 2022, the total amount of Ethereum withdrew was lower than usual, and in August 22, 2022 and September 3, 2022, it was higher than usual.
• A total of 80.6K Net ETH Change was observed between August 7, 2022 and September 7, 2022. The maximum Net ETH Change of 21.61K was observed on August 25, 2022, and the minimum Net ETH Change of -9.85K was observed on September 6, 2022. The trend for Net ETH Change is upward. August 28, 2022 and August 26, 2022 had lower Net ETH Change than normal, while September 7, 2022 had higher Net ETH Change than normal

Here from the below graph we can see the number of transactions of ETH deposited and withdrawn for past 1 month into BendDAO. Here we can see more number of ETH Deposited transactions was happened into BendDAO than withdrawn txns for past 1 month.

Between August 7, 2022 and September 7, 2022, 3.52K transactions were deposited. August 21, 2022, recorded the maximum number of deposits of 470, while August 9, 2022, recorded the minimum number of deposits of 8. Between August 7, 2022 and September 7, 2022, 1.19K withdrawals were made. The maximum number of withdrawals was 106 on September 6, 2022, and the minimum number was 12 on August 8, 2022. As compared to normal, the total number of withdrawals in September 6, 2022 was higher than normal

Here we can see the total ETH Volume of Bend DAO as 27.90K (ETH).

Observations

• According to the above analysis, Bend DAO has a total ETH volume of 27.90K (ETH).
• It appears that there are fewer deposits at first. Eventually, they began to increase. You can see that the ETH deposits are in an upward trend. 
• There was a maximum Net ETH Change of 21.61K on August 25, 2022, and a minimum Net ETH Change of -9.85K on September 6, 2022. In terms of Net ETH Change, there is an upward trend.
• For the past 1 month, almost three quarters of transactions were for deposited ETH, based on our analysis. Therefore, we can say that deposits are increasing compared to withdrawals. 

In this article, we are going to build a comprehensive balance sheet dashboard for BendDAO. Here are some of the metrics we are going to include: collateral by collection, total debt, total reserves, utilization rates, and anything else you feel is relevant.

Introduction

The BendDAO protocol is the first NFT liquidity protocol that is built on the peer-to-pool model. Depositors earn interest by providing ETH liquidity through the lending pool, while NFT holders borrow ETH with NFTs as collateral. Leveraged NFT trading is based on instant NFT-backed loans. The BendDAO protocol supports instant NFT-backed loans, collateral listing, and NFT down payments. With an entirely seamless experience that enables users to make down payments, borrow funds, and list their NFTs, a one-stop liquidity solution is created.

NFT holders who want liquidity but do not want to sell their NFTs can take advantage of lending protocols like BendDAO, but such lending services are also vulnerable to liquidity issues.In essence, the goal is to entice buyers to acquire the NFT collateral with liquidation. 

Approach

Our goal here is to build a comprehensive balance sheet dashboard for BendDAO. In order to accomplish this, we approached it as follows:

• An overview of BendDAO’s statistics can be found here
• Next, we can see how much ETH has been deposited and withdrew from BendDAO over time
• The next batch of BendDAO’s NFT collaterals
• The Distribution of NFTs Deposited as Collateral follows
• The next step is to find the NFTs deposited as collateral by collection
• Additionally, here is a list of BendDAO Unique NFT Collateral Depositors by Collection.
• Last but not least, we can see the Percentage of NFTs deposited into BendDAO as collateral

From the below section, we can see BendDAO’s statistics for the past six months. As we can see in this section, the overall collateral value is 27.90K(ETH). We can see here that there are 952 collaterals. It is clear from the data that there are more borrowers than depositors, so we can conclude that the intent of BendDAO is being achieved.

From the below graph we can see the ETH deposited and withdrawn into BendDAO over a time period. As well as we can see the NET ETH also here .

• Between March, 2022 and Sept, 2022, there were 698.57K ETH deposits. There was a maximum ETH deposit of 100.08K observed in W17(Apr 24-30), 2022, and a minimum ETH deposit of 1.91K in W12. The amount of Ethereum deposits is decreasing. A higher total amount of Ethereum deposits was made in W17, 2022, and W34, 2022, compared to normal. The number of deposits initially appears to be higher. As time went on, they began to decrease. The increase in deposits can be seen again during the week of August 21-27,2022. 
• Between March, 2022 and Sept, 2022 427.16K ETH were withdrawn. A maximum withdrawal of -72.08K ETH was observed on Jun 5-11 , 2022, and a minimum withdrawal of -844.6 ETH was observed in March 20-26, 2022.   It can be seen that withdrawals were less initially, but later increased. Once again it is apparent that the amount of withdrawals into BendDAO is increasing.
• The total Net ETH Change between March, 2022 and Sept, 2022 was 271.41K. A maximum Net Eth Change of 73.28K was observed in W17, 2022, and a minimum Net Eth Change of -14.8K was observed in W23, 2022. There is a lower than normal Net ETH Change in W23, 2022 and a higher than normal Net Eth Change in W34, 2022, and W17, 2022.

A total of 27.95K is the total collateral value across all NFT collections. Collateral Value (ETH) contributed 79.64% to the Top 2 NFT Collections. The lowest total Collateral Value (eth) is 44.16  and the highest total Collateral Value (eth) is 18.63K . Total NFTs across all NFT Collection is 953. The Top NFTCollections contributed for 28.44% of total Nfts and Top 2 Nft Collections contributed for 54.14% of total Nfts. The lowest total Nfts is 6 and the highest total Nfts is 271 .

Accordingly, BendDAO is a Liquidity Protocol with Leverages that leverages NFT.  In addition to BAYC and CryptoPunks, MAYC, Azuki, CloneX, and Doodles are supported as collateral. Below is a graph showing the distribution of NFTs deposited as collateral. Based on the below graph, we can see that the lowest NFTs Deposited are $44 (WPUNKS) and the highest average NFTs Deposited are $271 (MAYC).

We can see from the following graph the NFTs deposited as collateral by their collection over time. By collection wise, the largest amount of collateral was deposited by MAYC NFTs. Next in line was BAYC.  It is $7.4 for the lowest average NFT Deposited (SDOODLE) and $290.3 for the highest average NFT Deposited (MAYC). In W23, 2022, the maximum NFTs Deposited was $225.43, and the minimum NFTs Deposited was $5. It is higher than normal in W17, 2022, the average number of NFTs deposited. 

The below graph shows the BendDAO unique NFT collateral depositors based on their collections over time. Total Depositors are 531. Bored Ape Yacht Club Collections account for 28.06 % of total Depositors, and Top 2 Collections account for 54.43 %. Space Doodles has the lowest total depositors at 4 and Bore Ape Yacht Club has the highest total depositors at 149.

In order to see what percentage of NFTs have been deposited into BendDAO as collateral, here is the breakdown for the past 6 months. For example, Space Doodles deposited 0.1 of NFTs (percentage of NFTs collected). For bored ape yacht club, the percentage of NFT that was collected was 2.54. In all seven NFT collections, the percentage of NFT from collection was relatively even, with only a small variation.

Observations

• According to the above analysis, the overall collateral value is 27.90K(ETH). Here we can see that there are 952 collaterals. We can conclude from the data that BendDAO is achieving its intent by having more borrowers than depositors.
• There is a total debt of 13.43K(ETH).
• There are 14.97K(ETH) in Total Reserves.
• A utilization ratio of 81.95% has been achieved.
• A maximum ETH deposit of 100.08K was observed in W17 (Apr 24-30), 2022, and a minimum deposit of 1.91K in W12. 
•  There was a maximum withdrawal of -72.08K ETH on June 5-11, 2022, and a minimum withdrawal of -844.6 ETH on March 20-26, 2022. 
• We observed a maximum Net Eth Change of 73.28K in W17 (Apr 24-30), 2022, and a minimum Net Eth Change of -14.8K in W23 (Apr 24-30), 2022.
• Based on BendDAO’s NFT Collaterals, the lowest total Collateral Value (ETH) is 44.16 and the highest total Collateral Value (ETH) is 18.63K. 
• According to the distribution of NFTs deposited as collateral, the lowest average NFTs deposited were $44 (WPUNKS) and the highest average NFTs deposited were $271 (MAYC).
• When we analyze the NFTs deposited as collateral by collection, MAYC NFTs deposited the largest amount of collateral. BAYC was the next in line. 
•  With 4 depositors, Space Doodles has the lowest total depositors, while Bore Ape Yacht Club has the highest total depositors with 149.
• According to the percentage of collected NFTs, Space Doodles deposited 0.1. For bored ape yacht club, the percentage of NFT that was collected was 2.54. Overall, the percentage of collected NFTs was relatively even.

SQL Reference

WITH deposits as (
  SELECT 
  	date_trunc(day, block_timestamp) as date,
  	sum(amount) as deposited_eth,
  	count(tx_hash) as deposit_txns
  FROM ethereum.core.ez_eth_transfers
  WHERE tx_hash IN (
    SELECT 
     tx_hash
    from ethereum.core.fact_event_logs
    where contract_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
    	and event_name = 'Deposit'
        and ORIGIN_TO_ADDRESS = '0x3b968d2d299b895a5fcf3bba7a64ad0f566e6f88'
    	and TX_STATUS = 'SUCCESS'
  		and block_timestamp >= '2022-03-01'
    )
  AND block_timestamp >= '2022-03-01'
  GROUP BY date
),
withdrawls as (
  SELECT 
  	date_trunc(day, block_timestamp) as date,
  	sum(amount) as withdrawn_eth,
  	count(tx_hash) as withdrawn_txns
  FROM ethereum.core.ez_eth_transfers
  WHERE tx_hash IN (
    SELECT 
     tx_hash
    from ethereum.core.fact_event_logs
    where contract_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
    	and event_name = 'Withdrawal'
        and ORIGIN_TO_ADDRESS = '0x3b968d2d299b895a5fcf3bba7a64ad0f566e6f88'
    	and TX_STATUS = 'SUCCESS'
  		and block_timestamp >= '2022-03-01'
    )
  AND block_timestamp >= '2022-03-01'
  GROUP BY date
)
SELECT 
  *,
  deposited_eth - withdrawn_eth as net_eth
FROM deposits
LEFT JOIN withdrawls USING (date)

The purpose of this article is to examine the project the team and the community have been building with $DUST. As we already know, $Dust is the utility token that powers the most popular NFT project on Solana – Degods. Here we are going to explain about this DUST token. What is the use of $DUST in the Solana ecosystem? From where do $DUST buyers come and what are their most popular uses? Describe the trend in $DUST in Solana using at least three metrics.

What is DeGods?

DeGods, a deflationary collection by Solana from 10,000 virtual gods displaying artistry through their creative outfits and eye-pleasing colors, is a collection that focuses on art and style. Magic Eden is the marketplace that sells the collection’s NFTs. 

NFT: Cryptographic assets on blockchain with unique identifiers and metadata are known as “non-fungible tokens,” and some of the prices being paid for them are insane.

The only way that DeGod holders can access DeDAO’s channels is to belong to the collection’s Discord Community, which is exclusive to the collection’s owners. DeDAO is an autonomous, decentralized organization that receives funds through marketplace fees of 9.99%. DeDAO receives 6.66% of this fee, while DeGods’ core team receives 3.33%.  

DUST Tokens : How to get them?

There will be a limited supply of 33,300,000 Dust Tokens available as the collection’s native digital currency. As part of DUST’s halving periods, the token’s stake rewards will be reduced by 50%. These periods will occur three (3) times. 

DUST tokens can be earned in two (2) ways. First, by staking. Staking their NFTs will earn DeGods holders 10 DUST coins every day in addition to passive income and ready ROI. Second, Burning .Furthermore, holders have the option of burning their DeGods, so the god has been permanently removed from circulation after being burned. DeGod’s collection will gain value when the god is gone. 

The DeGods x Dust Experiment (not financial advice) pic.twitter.com/wTJyngz4FY

— DeGods (33.3%) (@DeGodsNFT) January 15, 2022

Approach

The purpose of this dashboard is to examine how $DUST is used in the Solana ecosystem:

• The amount of transactions, the number of wallets using $DUST Tokens, and also their volume can be determined.
• Additionally, we can also see how many transactions are made by different tokens to get DUST. Also, here are the Most Commonly Used Tokens By Their Amount To Get DUST.
• According to DUST’s swap program, we can see the Swap volume, Swap number, and swapped users.
• DUST’s Swap Volume, Swap Number, and Swapped Users are displayed here based on their swap direction.
• You can also see the average amount of DUST swapped by both directions and programs?
• In addition, we can see the median amount of dust swapped per week based on direction as well as by different swap programs.

Solana Ecosystem: How Is $DUST Being Used?

From the below section we can see the Transaction Volume, Transactions and Active Wallets which are using DUST Tokens in the Solana ecosystem can be seen from the past 6 months.

from the below graph we can see the transaction volume which is made by DUST tokens in the Solana ecosystem for the past 6 months. The total volume between March, 2022 and Sept, 2022 was 75.43M. The largest volume was observed in Jun(19-25), 2022, and the smallest was observed in March (13-19) , 2022. There has been an increase in total volume from April 2022 to September 2022. There is a higher volume than usual in Jun(19-25), 2022.

The total number of transactions from March, 2022 and Sept, 2022 was 230.76K. There were a maximum of 20.25K transactions in Aug28-Sep03, 2022, and a minimum of 1.29K transactions in initially. In the period from W10, 2022 to W36, 2022, the total number of transactions increased by almost 5 times. In terms of transactions, the trend is upward. Transactions in W36, 2022 are lower than normal, while transactions in W23, 2022 are higher than normal.

The total number of Active Wallets between March, 2022 and Sept, 2022 was 98.43K. A maximum of 9.88K Active Wallets were observed in Aug28-Sep03, 2022, while a minimum of 795 were observed in the beginning . March 2022 to Sept 2022 saw an increase in Active Wallets of 5.80 times. The number of active wallets is on the rise. There were initially not many active wallets, but later we can see that wallet growth was increasing. And in Jun5-11, 2022, we can see that there were suddenly more active wallets than usual. 

What Are The Sources(Tokens) Of $DUST Buyers?

We can see the number of transactions made by different tokens to get DUST from the below section and also what tokens are most frequently used by showing their participation amount in getting DUST over time. 

In the graph below, we can see the transactions that are made by the tokens that are used to get the DUST for the DeGods NFTs. A total of 189.88K transactions were processed between W10, 2022 and W36, 2022. The top two tokens (Wrapped SOL and USD Coin) accounted for 97.02% of transactions. The lowest number of Transactions is 1 (luna (wormhole)) and the highest number is 139.27K (wrapped sol). A maximum of 21.94K transactions were observed in W24, 2022, and a minimum of 107 transactions were observed in W10. From March 2022 to September 2022, total transactions increased by 29.83 times. There is a positive correlation between wrapped sol transactions and USD coin transactions.

Early on we can see the transactions, but not much later we can see the increasing trend of transactions with different tokens, especially wrapped sol and USD coins. In addition, we can see that the number of transactions is again on the rise, suggesting that more people are buying Dust and Degod’s NFTs. 

Using DUST, Different Swap Metrics By Program And By Direction Of Swap

This chart shows the $DUST trends in Solana based on the swapping transactions, the number of swappers, and the swapped volume by swap program. It also shows how the dust is coming from or going to DeGods NFTs.

Based on the below graph, we can see which active users are interacting with DUST tokens over time by means of different swap programs and swap directions.Total Swappers between March 7, 2022 to September 5, 2022 was 127.52K.Swap Program jupiter aggregator v2 is the highest contributor (50.25%) to the total Swappers out of the 2 Swap Program. Maximum Swappers of 12.95K was observed in August 29, 2022 and minimum Swappers of 171 was observed in March 7, 2022. The swappers in both cases are almost correlated with each other. 

A total of 128K swappers have been recorded. Of the 2 directions, Swapped To DUST accounts for the most Swappers (57.23%). Swapping from DUST resulted in 54.5K Swappers, and swapping to DUST resulted in 72.98k Swappers. This indicates a greater number of users are attracted to DUST, as well as that more people are buying Dust and Degod’s NFTs.. 

Based on the below graph, we can see the number of transactions are interacting with DUST tokens over time by means of different swap programs and swap directions.Total transactions between March 7, 2022 to September 5, 2022 was 329.71K. Swap Program jupiter aggregator v2 is the highest contributor (57.94%) to the total transactions out of the 2 Swap Program. Maximum transactions  of 39.41K was observed in Jun 13, 2022 and minimum transactions of 331 was observed in March 7, 2022.

The total number of transactions in both directions Swap to DUST and Swap from DUST is 329.7K. Swap to DUST is the direction that contributes the most (61.46%) to the total transactions. Swapped To DUST and Swapped From DUST have a steady percentage of transactions.

The total swap volume between March 7, 2022 and September 5, 2022 was 29.52M. Among the two Swap Programs, Jupiter aggregator v2 contributes the most (61.52%) to the total Swap Volume. Raydium v4 has the lowest total Swap Volume of 11.36M, while Jupiter aggregator v2 has the highest total Swap Volume of 18.16M. The maximum Swap Volume was 3.16M on August 29, 2022, and the minimum Swap Volume was 61.51K on March 7, 2022. In terms of swap volume, there has been an increase.  For past 2 weeks we can observe the Swap Volume is in increasing peak .

In total, 29M Swap Volume has been traded. The Swaps Swapped From DUST account for the highest percentage of the total Swap Volume (50.75%). For all directions, there is a relatively even swap volume with a low variation of 2.11%

The total average swap between March 7, 2022 and September 5, 2022 was 10.31K. Of the two Swap Programs, Jupiter aggregator v2 contributes the most (58.65%) to the total Average Swap. Raydium v4 has the lowest total Average Swap of 4.26K and Jupiter aggregator v2 has the highest total Average Swap of 6.05K. July 18, 2022 saw the maximum Average Swap of 555.46, while April 11, 2022 saw the minimum Average Swap of 196.35. The total Average Swap in July 18, 2022 was higher than normal.

Among the two directions, directions swapped from dust make up the highest percentage (59.65%) of the Average Swap.

Based on the graph below, we can see how much DUST has been swapped on a weekly basis over the past six months. We can see that DUST does not have any median observed in this case with the raydium V4 swap program. Later, we can see how raydim v4 contributes to DUST swapping. In fact, we can observe later that it contributes more than Jupiter aggreagator v2.

Observations

• We can see from the above analysis what DUST tokens are and how they can be obtained. 
• According to the above analysis, DUST’s impact on Solana ecosystem was 75.43M between March, 2022 and Sept, 2022. The highest volume was observed in June (19-25), 2022.
• There was an increase of almost five times in the number of transactions. There is an upward trend in terms of transactions.
• A growing number of wallets are active. When compared to the initial period, it has almost six times increased. Initial wallet growth was not significant, but later it was apparent that the number of active wallets was growing. 
• As we examine the sources of DUST buyers, we first see transactions, but we notice the increasing trend of transactions with different tokens, such as wrapped sols and USD coins, not long after. Additionally, we see an increase in transactions, indicating that more people are buying Dust and Degod’s NFTs. 
• As we can see, these DUSTs are bought to invest on DeGods through raydium v4 and jupiter aggregator v2 swap programs. 
• According to the $DUST trends in Solana based on swapping transactions, swappers, and swapped volume, Jupiter Aggregator v2 is used for the majority of swaps instead of Raydium v4. 
• The number of swap transactions and active swappers are on the rise in the swapped to DUST direction, which suggests that more people are buying Dust and Degod’s NFTs. 

Reference Query

WITH swap_txns as (
select 
  	block_timestamp,
  	tx_id,
  	SWAP_PROGRAM,
  	swap_from_mint,
  	swap_from_amount,
  	address_name,
  	SWAPPER
from solana.core.fact_swaps swap 
INNER JOIN solana.core.dim_labels lbl ON swap.swap_from_mint = lbl.ADDRESS
where (SWAP_TO_MINT='DUSTawucrTsGU8hcqRdHDCbuYhCPADMLM2VcCb8VnFnQ')
and block_timestamp >= CURRENT_DATE - {{days}}
  and SUCCEEDED
)
SELECT 
  date_trunc(week, block_timestamp) as date,
  address_name as from_token_name,
  count(distinct tx_id )as transactions,
  sum(swap_from_amount) as from_token_amount
FROM swap_txns 
GROUP BY date , address_name
QUALIFY row_number() over(partition by date order by transactions desc) <= 10

Throughout this article, we aim to analyze the total volume on Overtime Markets over the past two weeks. Which games had the most activity, both in terms of total users and dollar volume? On a daily basis, which sports receive the most bets in terms of total dollar volume? Describe any interesting data findings.

What is Thales?How does it Works?

The Thales protocol is an Ethereum-based peer-to-peer parimutuel market protocol, which is open to all participants. Building blocks like this are the foundation of a number of novel on-chain initiatives, including positional market platforms based on AMMs, gamified experiences, and much more. With Thales, users have access to uncensorable sUSD as collateral, immutable chainlink data feeds for market settlement, and all the benefits of an Optimism-centric network, such as speed, costs, and security.

How Do Overtime Markets Work?

Ultimately, Overtime Markets is the first permissionless AMM based on the Thales Protocol. Thales Protocol is an elegant and novel core design on which Overtime Markets is built.  On the Optimism network, Thales protocol is currently operating. As a fully on-chain sports AMM, Overtime markets offers Chainlink sport feeds that allow users to bet on Soccer, Football, MMA, and Baseball. The Thales markets have generated millions of dollars in volume through their immutable smart contracts, which are completely decentralized and  controlled.Through Overtime, communities can trade sports without relying on centralized entities for exchange of goods and services.  There are four stablecoins supported by Overtime: sUSD, USDT, USDC, and DAI.

With Overtime, you are not only bringing the game to blockchain, you are doing so with some of the best odds available across all sportsbooks, not just cryptocurrency ones. This odds are provided by Pinnacle Sportsbook, a highly regarded bookmaker that has a customer base in over 100 countries. In 1998, Pinnacle was founded and is considered one of the most reputable sportsbooks on the internet.By using Chainlink data feeds, Overtime receives these odds in real-time and uses them to price their positional tokens for each market.  There is one update for each game every six hours, except on game days when it is updated hourly.

Approach

This dashboard will explain about ,

• The Daily Number of Users and Volume for Overtime Markets for the Past Two Weeks
• Transactions and volume by token for the past two weeks on the Overtime Markets
• Transactions and volume by sport in Overtime Markets for past two weeks
• As well as showing each sport’s total volume and transaction for the past two weeks 

Overtime Markets: Users and Volume 

This section displays Overtime Market’s daily users and volume for the past two weeks.  Based on the number of users and volume, the graphs below show Overtime Markets’ performance over the past two weeks.  

A total of 969 users were active between August 11, 2022 and August 25, 2022. The maximum number of users was 136 on August 21, 2022. Initially, there were more than 50 users. There was decrease of less than 50 for a couple of days. Suddenly, from August 19 2022 onward, the number of users almost doubled. There we can see the total users on Aug 23,2022 are lower than normal.

Total transactions between August 11, 2022 and August 25, 2022 were 2.12K.  A maximum of 261 transactions were observed on August 13, 2022, and a minimum of 78 transactions were observed on August 16, 2022.  The number of transactions increased from August 11, 2022 to August 25, 2022.

Overtime’s Odds : In order to price their positional tokens for each market, Overtime receives these odds through Chainlink data feeds on-chain. Dollars of potential profit are priced based on implied win probability instead of percentages. Based on Pinnacle’s data, we can assume that the implied win probability of a Home win is 45% if it has a price of 0.45 per $1 of potential profit. There are different kinds of odds,

• An implied probability of success expressed as a decimal of one is called a Normalized Implied Odds (NIO). The odds will always add up to 1 in this format when pricing a single positional token (unless no liquidity is available for that position, in which case the odds will display as 0).
• If a position of 1 dollar is successful, Decimal Odds displays the payoff amount.

As a result of the multiple odds format being enabled on Aug 11th 2022, we can see that the volume has been increasing since Aug 11th and spiking maximum on Aug 14th 2022. From the below tweet we can see ,

Thursday’s updates are ready for you!

THALES & OP Reward page is now LIVE
Multiple odds format is enable

SoonTM
UFC
Sports trivia with sUSD vouchers to win
sUSD AMM input

1/4 pic.twitter.com/Ll3IGewN9q

— Overtime Markets (@OvertimeMarkets) August 11, 2022

The overall volume between August 11, 2022 and August 25, 2022 was 252.52K.  A maximum volume of 70.12K was observed on August 14, 2022, and a minimum volume of 2.01K was observed on August 16, 2022. There is a downward trend in the total volume. August 14, 2022 had a higher total volume than usual.

Overtime Markets: Number Of Transactions And Volume By Token Wise

As we already known , There are four stablecoins supported by Overtime: sUSD, USDT, USDC, and DAI. Here in this section we can see the number of trasactions and the volume made by each stablecoin on Overtime Markets for the past two weeks period. Comparatively most of the Overtime Volume is from sUSD tokens.

Note : sUSD is a Synthetix stablecoin asset with a value that tracks the US dollar. By staking SNX tokens in the staking smart contract, users can mint sUSD tokens. As a result, sUSD tokens can be exchanged on the Synthetix platform for other synthetic assets.

Based on the graph below, we can see the volume of different stablecoins on Overtime Markets for the past two weeks. The total volume from August 11, 2022 to August 25, 2022 was 252.52K.  The token sUSD contributes the most to the total volume out of the 4 tokens. The lowest total Volume is 261.99 (USDT), and the highest is 173.56K (sUSD). There was a maximum volume of 70.12K observed on August 14, 2022, and a minimum volume of 2.01K observed on August 16, 2022. It has been a decreasing trend for the past two weeks in terms of total volume. August 14, 2022 had a higher total volume than usual. 

Here from the below graph we can see daily percentages of different tokens volume for the past 2 weeks . The highest contributor to the total Volume is the Token sUSD (68.73%). In this graph, we see a positive correlation between sUSD volume and USDC volume.

It is calculated that there is a total volume of 252K.  Based on the percentage of total volume contributed by each token, Token sUSD contributes the most (68.73%) to the total volume. A difference of 66,147% is found between the lowest volume at 261.99 (USDT) and the highest volume at 173K (sUSD).

Here from the below graph we can see the number of transactions by token wise on Overtime markets for the past 2 weeks . Between August 11, 2022 and August 25, 2022, 2,183 token transactions took place. Out of the 4 tokens, sUSD contributes the most to total Transactions. The lowest total Transactions are 32 (USDT) and the highest are 1,738 (sUSD). August 13, 2022 recorded the highest number of transactions with 261.

If we look at the daily transaction percentage by token wise , we can see sUSD contributes almost 79% of the total Transactions. The total number of transactions is decreasing trend. A majority of USDC and sUSD transactions declined. There were almost more than 90% of USDC transactions that trended downward.  

 Out of the 4 tokens, sUSD contributes the more than 79% of total Transactions. In Overtime Markets, sUSD currency has had the most transactions, followed by USDC currency in second place. 

Overtime Markets: Number Of Transactions And Volume By Sport

Here in this section , we can see the number of transactions and volume by sport on Overtime markets for the past 2 weeks period. Between August 11, 2022 and August 25, 2022, total volume by sports was 252.52K. More than 80% of the total volume came from the top 3 sports (MLB, EPL, and NFL).  There is a low total Volume of 3.63K (MLS), and a high total Volume of 153.09K (MLB). The maximum Volume of 70.12K was observed on August 14, 2022, and the minimum Volume of 2.01K was observed on August 16, 2022. There is a decreasing trend in total volume. The total volume in August 14, 2022 is higher than normal. In comparison with the first week, 5 sports saw declines in volume, with the EPL dropping the most at more than 99%.

From the below graph we can see the percentage of daily volume by sports oin Overtime market for the past 2 weeks .  In comparison with the first week, 5 sports saw declines in volume, with the EPL dropping the most at more than 99%.

As can be seen from the below graph, the Top 3 Sports Baseball, English Premier League, and NFL accounted for 80.24% of total volume out of all games. Volumes are lowest in the Major League Soccer (MLS) and highest in the Major League Baseball (MLB). In comparison with Major League Soccer, MLB generates almost 40 times more volume.As you can see, the EPL generates the second highest amount of volume. In the following order is Serie A.

From the below graph we can see the percentage of volume by sport for the past 2 weeks . Here in this graph we can see more than half (60%) of the total volume is contributed by MLB. According to this information, MLB receives the most bets in total dollar volume compared to other sports. A comparison between MLS and other sports also shows that MLS receives the least amount of bets on a daily basis.

From August 11, 2022 to August 25, 2022, there were 2,183 Total Transactions on Overtime markets.  In terms of total transactions, MLB Sports contributed 40.72% and Top 2 Sports contributed 61.61%. The lowest number of transactions is 94 (Ligue 1) and the highest number is 889 (MLB). The maximum number of transactions was 261 on August 13, 2022. The multiple odds format will be enabled on August 11th 2022. THALES and OP will be awarded to traders with negative PnL, so everyone wins. More users may be attracted to make more transactions on Aug 13, 2022 as a result of this.

In the graph below, we can see the maximum number of bets placed with the MLB over the past two weeks. The EPL is followed by the second place. 

40.72% of the total transactions were attributed to MLB Sports, and 61.61% were attributed to the top two sports (MLB and English Premier League). Ligue 1 has the lowest total Transactions with 4.5%, while MLB has the highest with 40.9%.

Observations

From the above analysis,

• A total volume of 252.52K has been recorded by Overtime Markets in the last two weeks. In August 14th 2022, overtime exceeded 70K in a single day. Though it went down volume-wise again, it is now increasing. As long as things continue like this, by September the volume will definitely exceed 300K.
• There have been 969 users on Overtime markets in the past two weeks. There was a sudden increase in users that nearly doubled on August 19 2022.
• Token sUSD contributes almost 68% of the total volume contributed by tokens on Overtime markets. USDT token generates the lowest volume and sUSD token generates the highest volume.
• By looking at the daily transactions by token, we can see that sUSD contributes almost 79% of them.
• Transactions by token show a decreasing trend in total number of transactions. USDC and sUSD transactions declined in the majority. Most USDC transactions trended downwards, almost 90%.  
• Volumes are lowest in the Major League Soccer (MLS) and highest in the Major League Baseball (MLB). Major League Soccer generates almost 40 times more volume than the English Premier League. As you can see, the EPL generates the second highest volume. Serie A is ranked in the following order.
• Based on this information, MLB receives the most bets in total dollar volume compared to other sports. According to a comparison between MLS and other sports, MLS receives the least amount of daily bets.
• Based on the above analysis, if we look at the transactions by sport, we can see that August 13, 2022 had the most transactions. August 11th, 2022 will mark the day that multiple odds become available. The THALES and OP will be awarded to traders with negative PnL, so everyone wins. This may attract more users on Aug 13, 2022 to make more transactions.

Reference Query:

with ctrs as (
select
     ADDRESS,
    SYMBOL,
    DECIMALS
  from
    optimism.core.dim_contracts
  where
    ADDRESS in (
      '0x7f5c764cbc14f9669b88837ca1490cca17c31607',
      '0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9',
      '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1',
      '0x94b008aa00579c1307b0ef2c499ad98a8ce58e58'
    )
),
tags as ( -- https://github.com/thales-markets/contracts/blob/67d12f1c549026ff6a8d1fdaac832ff427a17573/scripts/deployExoticMarkets/deploy_ExoticTags.js
  SELECT 'Sport' AS label, '1'as tag UNION 
SELECT 'Crypto' AS label, '2'as tag UNION 
SELECT 'Politics' AS label, '3'as tag UNION 
SELECT 'Pop-culture' AS label, '4'as tag UNION 
SELECT 'Esports' AS label, '5'as tag UNION 
SELECT 'Football' AS label, '101'as tag UNION 
SELECT 'Basketball' AS label, '102'as tag UNION 
SELECT 'Bitcoin' AS label, '201'as tag UNION 
SELECT 'Ethereum' AS label, '202'as tag UNION 
SELECT 'Finance' AS label, '6'as tag UNION 
SELECT 'TradFi' AS label, '601'as tag UNION 
SELECT 'NCAA Men''s Football' AS label, '9001'as tag UNION 
SELECT 'NFL' AS label, '9002'as tag UNION 
SELECT 'MLB' AS label, '9003'as tag UNION 
SELECT 'NBA' AS label, '9004'as tag UNION 
SELECT 'NCAA Men''s Basketball' AS label, '9005'as tag UNION 
SELECT 'NHL' AS label, '9006'as tag UNION 
SELECT 'WNBA' AS label, '9008'as tag UNION 
SELECT 'MLS' AS label, '9010'as tag UNION 
SELECT 'EPL' AS label, '9011'as tag UNION 
SELECT 'Ligue 1' AS label, '9012'as tag UNION 
SELECT 'Bundesliga' AS label, '9013'as tag UNION 
SELECT 'La Liga' AS label, '9014'as tag UNION 
SELECT 'Serie A' AS label, '9015'as tag UNION 
SELECT 'UEFA Champions League' AS label, '9016'as tag  
)
game_tags as (
  select 
  	label as sport,
  	game_address,
  	tag,
  	game_name
  from games INNER JOIN tags using (tag)
),
txns as (
  	SELECT 
  		block_timestamp,
  		tx_hash,
  		origin_from_address as player,
  		RAW_AMOUNT / pow(10, DECIMALS) as amount_bet,
  		SYMBOL,
 		concat('0x', substr(regexp_substr_all(SUBSTR(input_data, 11, len(input_data)), '.{64}')[0], 25, 40)) AS game_address,
  		Sport,
  		game_name
  	FROM  optimism.core.fact_token_transfers trnf
  	INNER JOIN ctrs ON trnf.contract_address = ctrs.address
  	INNER JOIN optimism.core.fact_transactions as txn using (tx_hash)
  	INNER JOIN game_tags ON game_tags.game_address = concat('0x', substr(regexp_substr_all(SUBSTR(input_data, 11, len(input_data)), '.{64}')[0], 25, 40))
  	WHERE origin_from_address = from_address
  	and ORIGIN_TO_ADDRESS = '0x170a5714112daeff20e798b6e92e25b86ea603c1'
  	and block_timestamp >= CURRENT_DATE - {{days_ago}}
)
SELECT 
  	date_trunc(day, block_timestamp) as date, 
  	count(distinct player) as players,
  	count(distinct tx_hash) as transactions,
  	count(distinct sport) as sports, 
  	count(distinct game_name) as games,
  	sum(amount_bet) as volume_usd
FROM txns 
GROUP BY date