What this dashboard is offering ?

In this project, we are going to analyze Makerdao flashloans , including number of wallets, number of loans, value of loans,tot Loan Value $ share by token and etc . the time range in flexible and you can alter days_back box on top left to get the results in your preferred time range.

---

Method

All data retrived from Flipsidecrypto platform, and the tables used are

ethereum.maker.ez_flash_loans 
ethereum.core.fact_hourly_token_prices
ethereum.core.ez_token_transfers

---

Metrics provided

• Loan Frequency and wallets
• Number of Total Wallets and loans
• Loan Volume $
• correlation between ETH price and number of Loans
• correlation between ETH price and number of users
• tot Loan Value $ share by token
• tot Loan /frequency share by token
• tot Loaners share by token
• loan frequency growth by symbol
• loan value growth by symbol
• flashloans user profile based on times used and volume $
• top 10 most popular defi platforms among in flashloan users
• balance change of flashloan users
• 10 most popular tokens to swap to by flashloan users
• 10 most popular tokens to SWAP FROM by flashloan users

What is a Flash Loan?

Flash Loans allow users to borrow any available assets without putting up any collateral, as long as the liquidity is returned to the protocol within one block transaction.

Flash loans are a feature designed for developers, due to the technical knowledge required to execute one. Flash Loans allow you to borrow any available amount of assets without putting up any collateral, as long as the liquidity is returned to the protocol within one block transaction. To do a Flash Loan, you will need to build a contract that requests a Flash Loan. The contract will then need to execute the instructed steps and pay back the loan + interest and fees all within the same transaction.[1]

Introduction

What is MakerDAO?

MakerDAO is an organization developing technology for borrowing, savings, and a stable cryptocurrency on the Ethereum blockchain.

In brief :

• MakerDAO is a decentralized organization built on Ethereum to allow lending and borrowing of cryptocurrencies without the need for a middle man

• MakerDAO is made up of a smart contract service that manages borrowing and lending, as well as two currencies: DAI and MKR to regulate the value of loans.

• MakerDAO is a part of the "DeFi" movement - a catch-all term for financial tools and services that don't rely on centralized parties to coordinate and control access.

• The protocol works by allowing anyone to take out loans in DAI using other cryptocurrencies as collateral. Crucially, these loans are overcollateralized, meaning that you will have to deposit more cryptocurrency than you put in. As of August 2022, the minimum collateralization rate of a “vault” of ETH is 170%, meaning that you would have to collateralize $170,000 worth of ETH to receive $100,000 worth of DAI.

  The reason for overcollateralization is to protect against crashes of ETH or the other coins that back DAI, which include wrapped bitcoin (wBTC) and centralized U.S. dollar stablecoins USDC and USDP.

Conclusion

(based on 1 year data) -- > please set the days_back to 365 and read the conclusion

• In past 365 days , 1940 wallets got 16.99B $ as Flashloans from MakerDAO in 11k Loans.
• Except for some days like June 13 2022, May 11 2022 , Jan 21 2022 and Dec 4th 2021, in other days, the trend of loan and wallet count trend was steady.
• Dec 10th to 24th and mid June, were the days with highest amount of loans .
• It seems there is a relatively positive correlation between ETH price and number of Loans, but as said, its not strong.
• It seems there is a relatively positive correlation between ETH price and number of users . but its not strong as well.
• In terms of tot Loan Value $ share by token, DAI is ranked first with 67%,as expected, and USDC and WETH with less than 10% are in the next ranks
• In terms of tot Loan frequency share by token, again DAI is ranked first, but this time, with 33.4% of total loans, and WETH with 28.5% and USDC with 18.5% are following it.
• In terms of tot Loaners share by token, the situation is same as tot Loan frequency.
• In terms of loan value growth by symbol, DAI has no rivals with the highest exponential rate by far.
• In terms of loan frequency growth by symbol, still DAI has the most exponential rate, followed by WETH and USDC.
• Most of users (46.5%) , used the loans 2-5 times and 39% used it just for one time. the rest used it for more than 5 times.
• 41.3% of users got +500K $ as loan (whale alert!) and 26.4% o