Table Of Content
- Introduction
- Example1: Market Health Analysis
- Example2: Analysis of Liquidation
- Conclusion
Introduction
In the world of decentralized finance (DeFi), the importance of data analysis and visualization cannot be overstated. These tools not only help in understanding market dynamics but are also pivotal in gauging the health and trends of projects. While we can extract a wealth of raw data from Chainbase, this data often requires further cleaning and processing to provide us with more intuitive and specific information. This is where Flipside comes into play, offering a powerful data visualization platform that allows us to effortlessly transform the raw data extracted from Chainbase into vivid and insightful charts and analyses.
This article, using two illustrative examples, will walk you through the process of extracting MakerDAO data from Chainbase and visualizing it effectively with Flipside, enabling you to uncover the deeper insights and value hidden within the data.
Relevant links for this article:
Market Health Analysis
To assess the health of the MakerDAO market, we first need to focus on the following key indicators:
cumulativeBorrowUSD
: Represents the accumulated borrowing amount.
cumulativeDepositUSD
: Represents the accumulated deposit amount.
totalValueLockedUSD
: Indicates the total value locked within the market.
isActive
: Denotes whether the market is active or not.
We can extract this information using the following Chainbase query:
# chainbase
query MyQuery {
ilks {
marketAddress
}
markets {
createdTimestamp
cumulativeBorrowUSD
cumulativeDepositUSD
isActive
totalValueLockedUSD
}
To delve deeper into the analysis, we can import this data into Flipside and query for specific marketAddress
values.
# filpside
SELECT
round(VALUE:"cumulativeBorrowUSD",2) AS "cumulativeBorrowUSD" ,
round(VALUE:"cumulativeDepositUSD",2) AS "cumulativeDepositUSD" ,
round(VALUE:"totalValueLockedUSD",2) AS "totalValueLockedUSD" ,
VALUE:"isActive"::string AS "isActive"
FROM
(
SELECT
chainbase_utils.post('/v1/subgraphs/ethereum_makerdao/1.0.0',
{
'operationName':'MyQuery',
'query':
'query MyQuery {
ilks(where: {marketAddress: "{{marketAddress}}"}) {
marketAddress
}
markets {
cumulativeBorrowUSD
cumulativeDepositUSD
isActive
totalValueLockedUSD
}
}'}) :: variant AS resp
) AS subquery,
LATERAL FLATTEN(input => resp:data:data:markets)
Where isActive = āTRUEā
## eg.
marketAddress: 0x24e459f61ceaa7b1ce70dbaea938940a7c5ad46e
Through visualization, we can get some insight from the data:
- Borrow-Lend Balance: By comparing
cumulativeBorrowUSD
with cumulativeDepositUSD
, we can assess whether the market is in a healthy borrowing-lending equilibrium. In Flipside, we use a dual Y-axis chart to display the variations of these two indicators over time.
- Total Value Locked (TVL): By analyzing
totalValueLockedUSD
, we can gauge the market's liquidity and attractiveness. A high TVL typically indicates a healthier and more appealing market. In Flipside, we can use a time series chart to showcase the evolution of TVL over time.
Analysis of Liquidation
Liquidation events are a crucial metric in the DeFi market, helping us understand the risk conditions of the market. Here are the key data points we can analyze:
**amountUSD**
: Represents the amount in USD associated with the liquidation event.
lastPriceUSD
: Indicates the most recent price of the asset in USD. This could be used to determine the asset's current market value at the time of liquidation.
name
: The name of the asset being liquidated. For example, it could be "Ethereum" or "DAI".
symbol
: The ticker symbol or abbreviation for the asset. For instance, "ETH" for Ethereum or "DAI" for DAI stablecoin.
query MyQuery2 {
liquidates {
amountUSD
asset {
lastPriceUSD
name
symbol
}
timestamp
}
}
To delve deeper into the analysis, we can import this data into Flipside (similar to the first example).
We can conduct the following two analyses:
- Time Series Chart
Display the changes in amountUSD
over time to observe the frequency and scale of liquidation events. A high frequency of liquidation events might indicate market instability or high risks.
- Analysis of Liquidated Assets
Using pie charts, showcase the average liquidation amounts and counts for different assets. This can help identify certain assets that might be more prone to liquidation, possibly due to their market volatility or liquidity.
After creating the dashboard, the final presentation is as shown below:
Linkļ¼https://flipsidecrypto.xyz/pyours/makerdao-1vJUeJ
Conclusion
MakerDAO stands as a pivotal player in the DeFi landscape. Analyzing and visualizing its data offers profound insights, proving indispensable for investors and market researchers alike. Through the analysis methods mentioned above, we can delve deeper into the market's vitality, potential risks, and liquidation patterns. We hope this guide offers valuable insights and guidance for you.
About Chainbase
Chainbase is an open Web3 data infrastructure for accessing, organizing, and analyzing on-chain data at scale.Ā It helps people to better utilize on-chain data by combining rich datasets with open computing technologies in one data platform. Chainbaseās ultimate goal is to increase data freedom in the crypto.
More than 5,000 developers actively interact with our platform and over 200Mn data requests per day as their data backend and integrate chainbase into their main workflow.Ā Additionally, we are working with ~10 top-tier public chains as first-tier validators and managing over US $500Mn tokens non-custodially as a validator provider. Find out more at:Ā chainbase.com
Want to learn more about Chainbase?
Sign up for aĀ free account, and Check out ourĀ documentation.
Websiteļ½Blogļ½Twitterļ½Discordļ½Link3