<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/">
    <channel>
        <title>Douglas Fir</title>
        <link>https://paragraph.com/@douglas-fir</link>
        <description>Learning to write. Writing to learn.
Dune: https://dune.com/dcooper
Twitter: https://twitter.com/The_Douglas_Fir</description>
        <lastBuildDate>Tue, 23 Jun 2026 18:23:51 GMT</lastBuildDate>
        <docs>https://validator.w3.org/feed/docs/rss2.html</docs>
        <generator>https://github.com/jpmonette/feed</generator>
        <language>en</language>
        <copyright>All rights reserved</copyright>
        <item>
            <title><![CDATA[LI.FI - Aggregating The Bridges & DEXes]]></title>
            <link>https://paragraph.com/@douglas-fir/li-fi-aggregating-the-bridges-dexes</link>
            <guid>aWN0lNTol7vtpqCi21PX</guid>
            <pubDate>Sun, 19 Mar 2023 07:14:57 GMT</pubDate>
            <description><![CDATA[The number of blockchains in existence continues to rise. The value is still concentrated on a few chains, but the diversity has increased in recent years (Figure 1). Put differently, the future is modular and multi-chain. In such world, blockchains need to be able to talk to each other to avoid fragmentation. Blockchain bridges enable this. Initially focused on moving tokens across blockchains, solutions have emerged that allow for more generic cross-chain communication. There are now dozens...]]></description>
            <content:encoded><![CDATA[<p>The number of blockchains in existence continues to rise. The value is still concentrated on a few chains, but the diversity has increased in recent years (Figure 1). Put differently, the future is modular and multi-chain. In such world, blockchains need to be able to talk to each other to avoid fragmentation. Blockchain bridges enable this. Initially focused on moving tokens across blockchains, solutions have emerged that allow for more generic cross-chain communication. There are now dozens of blockchain bridges in existence.</p><figure float="none" data-type="figure" class="img-center" style="max-width: null;"><img src="https://storage.googleapis.com/papyrus_images/b8bc319563a63e01b9f00415ec7ec38f5d6dbe81419e4f507539bd2ab2ef8bd5.png" alt="Figure 1: TVL per chain (source: defillama.com)" blurdataurl="data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=" nextheight="600" nextwidth="800" class="image-node embed"><figcaption HTMLAttributes="[object Object]" class="">Figure 1: TVL per chain (source: defillama.com)</figcaption></figure><p>In a multi-chain world, interoperability protocols are a key piece of the infrastructure. The problem is that this segment is still very experimental and often unsafe. Indeed, bridge exploits are by far the largest category with around <a target="_blank" rel="noopener noreferrer nofollow ugc" class="dont-break-out" href="https://twitter.com/tokenterminal/status/1582376876143968256">$2.5bn in stolen funds since 2020</a>. Despite the challenges, the interoperability landscape continues to innovate at a rapid pace. Users and builders are struggling to chose the right bridge, i.e. one that is secure and convenient. There are <a target="_blank" rel="noopener noreferrer nofollow ugc" class="dont-break-out" href="https://blog.connext.network/the-interoperability-trilemma-657c2cf69f17">interoperability trilemma’s</a> to consider, think about <a target="_blank" rel="noopener noreferrer nofollow ugc" class="dont-break-out" href="https://blog.li.fi/li-fi-with-bridges-trust-is-a-spectrum-354cd5a1a6d8">trust assumptions</a>, ...</p><p>Enter <a target="_blank" rel="noopener noreferrer nofollow ugc" class="dont-break-out" href="https://li.fi/">LI.FI</a>. It’s a bridge aggregation protocol that enables cross-chain asset swaps by aggregating bridges and connecting them to DEXes &amp; aggregators. In other words, it can route any asset on any chain to any desired asset on any chain.</p><p>They are primarily a B2B business by providing an SDK and widget that other projects can use. LI.FI is thus the middle layer between DeFi infrastructure and the application (Figure 2). For example, LI.FI is integrated in MetaMask for cross-chain swaps (<a target="_blank" rel="noopener noreferrer nofollow ugc" class="dont-break-out" href="https://dune.com/lifi/metamask-bridge">80-90% of MM’s cross-chain swaps</a> is routed via LI.FI). While LI.FI’s focus is on B2B, the team recently recently launched <a target="_blank" rel="noopener noreferrer nofollow ugc" class="dont-break-out" href="https://jumper.exchange/">Jumper</a> (formerly transferto.xyz), an exchange to swap assets across chain.</p><figure float="none" data-type="figure" class="img-center" style="max-width: null;"><img src="https://storage.googleapis.com/papyrus_images/110948a297e186c8d07771750ca7268713120064e94033a261745efb169a0559.png" alt="Figure 2: LI.FI as the bridge/DEX aggregator" blurdataurl="data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=" nextheight="600" nextwidth="800" class="image-node embed"><figcaption HTMLAttributes="[object Object]" class="">Figure 2: LI.FI as the bridge/DEX aggregator</figcaption></figure><p><strong>Dune Dashboard</strong></p><p>I created a <a target="_blank" rel="noopener noreferrer nofollow ugc" class="dont-break-out" href="https://dune.com/dcooper/lifi">Dune dashboard</a> that tracks the usage of LI.FI. Note that the dashboard does not give a 100% complete overview of LI.FI usage: 1) Dune doesn&apos;t cover all chains and 2) Dune doesn&apos;t have all pricing info of each wrapped asset (which in turn relies on Coinpaprika data). I semi-fixed the latter issue by manually relabeling some of the addresses of wrapped tokens to the underlying asset.</p><p>LI.FI currently covers about 20 chains and over a dozen bridges. Since its launch, over 400k transactions or about $400m in value has been transacted via LI.FI. Over 150k unique users have transacted with LI.FI.</p><p>Let’s take a look at some of the Dune charts. In recent months, several bridges including Multichain, Hyphen, cBridge and Hop (Figure 3). In terms of volume, most of it has been routed via Multichain and cBridge (Figure 4). Which applications are routing most via LI.FI? Figure 5 shows that the bulk of the daily unique users (+85%) are utilizing either Jumper (transgferto.xyz) or MetaMask. Most of the $ volume also comes from these two applications. Finally it’s interesting to look at the origin and destination chains of the swaps that LI.FI routes. This is shown in Figure 6. Most of the volume is routed between L2s (Arbitrum and Optimism) and Ethereum.</p><figure float="none" data-type="figure" class="img-center" style="max-width: null;"><img src="https://storage.googleapis.com/papyrus_images/c3e4aae7caf7b9c9bea23c13b6f09f642857205c3580d26c1f409a08a4bfe921.png" alt="Figure 3: Daily transactions by bridge" blurdataurl="data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=" nextheight="600" nextwidth="800" class="image-node embed"><figcaption HTMLAttributes="[object Object]" class="">Figure 3: Daily transactions by bridge</figcaption></figure><figure float="none" data-type="figure" class="img-center" style="max-width: null;"><img src="https://storage.googleapis.com/papyrus_images/358c448b2680f474e982e2d4a6c134e0543847fdfa7a0e73a5fefacbd4379358.png" alt="Figure 4: Daily volume by bridge" blurdataurl="data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=" nextheight="600" nextwidth="800" class="image-node embed"><figcaption HTMLAttributes="[object Object]" class="">Figure 4: Daily volume by bridge</figcaption></figure><figure float="none" data-type="figure" class="img-center" style="max-width: null;"><img src="https://storage.googleapis.com/papyrus_images/72ed0aaeb5af8e08833db306258576ab6c05fc3568f990b0076d5c2e13db8d10.png" alt="Figure 5: Daily unique users by application" blurdataurl="data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=" nextheight="600" nextwidth="800" class="image-node embed"><figcaption HTMLAttributes="[object Object]" class="">Figure 5: Daily unique users by application</figcaption></figure><figure float="none" data-type="figure" class="img-center" style="max-width: null;"><img src="https://storage.googleapis.com/papyrus_images/861d3f0f8ad909c94aa952f514f192ed5221776eec53abfc4b350185d3cc17d5.png" alt="Figure 6: Origin and destination chains of the swaps" blurdataurl="data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=" nextheight="600" nextwidth="800" class="image-node embed"><figcaption HTMLAttributes="[object Object]" class="">Figure 6: Origin and destination chains of the swaps</figcaption></figure><p><strong>Concluding thoughts</strong></p><p>It’s still early days for interoperability protocols, so it remains to be seen how it will evolve. But it’s an exciting area that I will keep a close eye on. Especially use cases that interoperability protocols can enable. Think about lending and borrowing in a chain agnostic way, where the loan and collateral would sit on different blockchains. Or decentralized exchanges that pool liquidity from different chains. Other examples that would rely on interoperability infrastructure are NFTs that would allow the user to access its utility on another chain. Or governance that allows users to vote cross-chain.</p><p>More and more protocols need interoperability, but teams often don’t have the time or expertise to navigate that labyrinth. LI.FI’s solution takes away that burden so others can focus on their own value proposition. I think LI.FI is well-positioned (see also this recent piece on how LI.FI fits in the <a target="_blank" rel="noopener noreferrer nofollow ugc" class="dont-break-out" href="https://www.decentralised.co/p/revisiting-aggregation-theory">aggregation theory</a>). Finally, worth to note is that LI.FI has an excellent research team, and I always learn a lot from their <a target="_blank" rel="noopener noreferrer nofollow ugc" class="dont-break-out" href="https://blog.li.fi/">writings</a>.</p>]]></content:encoded>
            <author>douglas-fir@newsletter.paragraph.com (Douglas Fir)</author>
        </item>
        <item>
            <title><![CDATA[Ghost In The Machine: Liquidations in Aave]]></title>
            <link>https://paragraph.com/@douglas-fir/ghost-in-the-machine-liquidations-in-aave</link>
            <guid>YxuATYLocpgtzWULWroL</guid>
            <pubDate>Fri, 27 Jan 2023 13:58:01 GMT</pubDate>
            <description><![CDATA[This post looks at liquidations in Aave - one of the most popular decentralized lending protocols. Specifically, I walk through a Dune Dashboard that I built - any feedback welcome! The first part explains how liquidations work in Aave. The subsequent sections walks through some of the charts from the Dune dashboard. I cover on-chain data on liquidations, the liquidated users and the liquidators. The piece also looks into May 19th 2021, the day Aave saw it’s highest amount of liquidations. No...]]></description>
            <content:encoded><![CDATA[<p>This post looks at liquidations in <a target="_blank" rel="noopener noreferrer nofollow ugc" class="dont-break-out" href="https://aave.com/">Aave</a> - one of the most popular decentralized lending protocols. Specifically, I walk through a <a target="_blank" rel="noopener noreferrer nofollow ugc" class="dont-break-out" href="https://dune.com/dcooper/aave-liquidations">Dune Dashboard</a> that I built - any feedback welcome!</p><p>The first part explains how liquidations work in Aave. The subsequent sections walks through some of the charts from the Dune dashboard. I cover on-chain data on liquidations, the liquidated users and the liquidators. The piece also looks into May 19th 2021, the day Aave saw it’s highest amount of liquidations. Note that the analysis is restricted to Aave V2 on Ethereum.</p><figure float="none" data-type="figure" class="img-center" style="max-width: null;"><img src="https://storage.googleapis.com/papyrus_images/e8d5c1010ab2d741f678adceb34e5438e0d8130745a5b477a0820ddfe7097e94.webp" alt="" blurdataurl="data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=" nextheight="600" nextwidth="800" class="image-node embed"><figcaption HTMLAttributes="[object Object]" class="hide-figcaption"></figcaption></figure><p><strong>1. How do liquidations work in Aave?</strong></p><p>Aave is a collateralised lending protocol. Specifically, Aave applies the concept of over-collateralisation, which means that users can borrow less than the value of the collateral they provide. This design choice is not surprising given the price volatility of crypto assets and Aave only considers the quality of the collateral when issuing loans. No information about the borrower such as income, past defaults, … is used.</p><p>The maximum amount that can be borrowed depends on the quality of the collateral. This is determined by factors such as smart contract risk, counter-party risk and market risk. For more information, Aave has some good <a target="_blank" rel="noopener noreferrer nofollow ugc" class="dont-break-out" href="https://docs.aave.com/risk/v/aave-v2/asset-risk/methodology">documentation</a>. For example, USDC has a loan to value of 86%, meaning that for each $100 worth of USDC that is deposited as collateral a user can borrow up to $86 worth of another asset. SNX is deemed more risky and has a loan to value of 49%. Only $49 worth of assets can be borrowed when pledging $100 worth of SNX. <a target="_blank" rel="noopener noreferrer nofollow ugc" class="dont-break-out" href="https://docs.aave.com/risk/v/aave-v2/asset-risk/risk-parameters">This table</a> gives a full overview of the assets that can be pledged as collateral and how much can be borrowed against it.</p><p>The loan to value ratio is of course not constant due price fluctuations. The borrower has to ensure that the value of the collateral sufficiently covers the value of the loan at all times. If not, the loan can become under-collateralised. The liquidation threshold specifies at what loan to value ratio a loan is under-collateralised. This threshold also depends on the type of collateral. For example, USDC has a liquidation threshold of 88%, which means if the loan to value rises to 88%, it becomes available for liquidation. The liquidation threshold for SNX collateral is 65%.</p><p>It’s important to note that Aave looks at the aggregate health of each user (address). Users can have multiple loans and deposited different collateral assets and it’s this aggregate picture of loans and collateral that matters when it comes to liquidations. Aave calls this aggregate view the <em>health factor</em>, which is calculated as follows:</p><figure float="none" data-type="figure" class="img-center" style="max-width: null;"><img src="https://storage.googleapis.com/papyrus_images/c25d81b783219201f8a45377644a7fdf7cff0af48291e0be54f2f06291473b09.png" alt="" blurdataurl="data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=" nextheight="600" nextwidth="800" class="image-node embed"><figcaption HTMLAttributes="[object Object]" class="hide-figcaption"></figcaption></figure><p>The higher the health factor, the better. When the health factor falls below 1, positions can be liquidated. There isn’t a centralised party that is responsible for liquidating loans. Instead, anyone can be a liquidator. This is done by making a <a target="_blank" rel="noopener noreferrer nofollow ugc" class="dont-break-out" href="https://docs.aave.com/developers/guides/liquidations">liquidation call</a>, pay back a part of the loan and receive the collateral valued at the repaid loan plus a liquidation bonus (or a liquidation penalty from the perspective of the borrower).</p><p>The <a target="_blank" rel="noopener noreferrer nofollow ugc" class="dont-break-out" href="https://dune.com/queries/1912164">histogram</a> below shows the distribution of the health factor of all users of Aave V2</p><figure float="none" data-type="figure" class="img-center" style="max-width: null;"><img src="https://storage.googleapis.com/papyrus_images/64e72f0810ccc70c0e0be93a0c9d103262d4c49a0a1f1475e16b61f2cb073dff.png" alt="Health factors of all Aave V2 users" blurdataurl="data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=" nextheight="600" nextwidth="800" class="image-node embed"><figcaption HTMLAttributes="[object Object]" class="">Health factors of all Aave V2 users</figcaption></figure><p>Let’s look at a simplified example that explains the above:</p><ol><li><p>Stewart deposits 1 WETH when it has a price of $1,500 and borrows 1,000 USDC worth $1,000 (if he wanted he could <a target="_blank" rel="noopener noreferrer nofollow ugc" class="dont-break-out" href="https://docs.aave.com/risk/v/aave-v2/asset-risk/risk-parameters">borrow up to $1,245 worth of USDC</a>). His loan to value ratio is 66%</p></li><li><p>Due to a sharp decline in prices, the deposited WETH is suddenly worth only $1,175. Since the loan of 1,000 USDC is still $1,000, the loan to value rise above the <a target="_blank" rel="noopener noreferrer nofollow ugc" class="dont-break-out" href="https://docs.aave.com/risk/v/aave-v2/asset-risk/risk-parameters">liquidation threshold of 85%</a>. Stewart has only one loan outstanding (and only 1 WETH as collateral), so his health factor drops below 1. The position can now be liquidated</p></li><li><p>Liquidators (bots) are constantly monitoring the health factor of each Aave borrower. Andy’s liquidation bot notices that Stewart’s health factor has fallen below 1. Immediately, Andy’s bot makes a liquidation call and repays 50% of the loan, i.e. 500 USDC. In return he receives 500 USDC worth of WETH + a <a target="_blank" rel="noopener noreferrer nofollow ugc" class="dont-break-out" href="https://docs.aave.com/risk/v/aave-v2/asset-risk/risk-parameters">liquidation bonus of 5%</a>. Note that with Aave V2 up to 50% of a loan can be liquidated (with V3 it is possible to liquidate 100% of a loan)</p></li><li><p>Stewart is left with a debt of 500 USDC and $650 worth of WETH as collateral ($1,175 - $500 - $25). His health factor has increased to 1.1. Andy has $525 worth of WETH. His profit is $25 minus the gas fees he paid. Note that I have ignored interest payments throughout the example for simplicity</p></li></ol><p>With the basic concepts of liquidations in Aave out of the way, it’s time to dig in the data!</p><p><strong>2. Liquidations</strong></p><p>Since its launch on Ethereum Mainnet in December 2020, the Aave V2 protocol has seen over 27,000 liquidations, amounting to more than $1.1bn. The chart below shows the liquidations on a daily basis. Unsurprisingly, the amount of liquidations spiked during days of high price volatility. For example, liquidations reached +$170m on May 19th 2021, +$60m (Nov 22nd 2022) and +$50m (June 14th 2022). We will look closer into the events on May 19th at the end of this post. Interestingly, almost all liquidations from Nov 22nd can be traced back to one single user (more on that below)!</p><figure float="none" data-type="figure" class="img-center" style="max-width: null;"><img src="https://storage.googleapis.com/papyrus_images/90ef8557a19b20c5e2a41bfa8505157a7fcb360d19ec59ef76741d7e9bbcf60e.png" alt="Daily liquidations in Aave V2 per collateral asset" blurdataurl="data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=" nextheight="600" nextwidth="800" class="image-node embed"><figcaption HTMLAttributes="[object Object]" class="">Daily liquidations in Aave V2 per collateral asset</figcaption></figure><p>So which tokens have been liquidated the most (in $ value)? The piechart shows that the liquidations are very concentrated in just a few tokens. Around $610m or 55% of all liquidations was WETH. Moreover, the top three tokens (WETH, WBTC and LINK) account for almost 80% of all liquidations.</p><figure float="none" data-type="figure" class="img-center" style="max-width: null;"><img src="https://storage.googleapis.com/papyrus_images/eb3a40a2d0e4f708362a99651e7692adcd71b1f02442c1cba6a0478fba1d199f.png" alt="Liquidations per collateral asset" blurdataurl="data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=" nextheight="600" nextwidth="800" class="image-node embed"><figcaption HTMLAttributes="[object Object]" class="">Liquidations per collateral asset</figcaption></figure><p>What about the borrowed assets? The next chart shows the total dollar amount that has been liquidated (y-axis) for each type of collateral (x-axis). Per collateral asset you can see which debt asset was repaid. Stablecoins were the most popular borrowed assets that were repaid. For example, from the $620m WETH collateral that has been liquidated, 80% of the repaid loans were USDC ($280m), USDT ($180m) and DAI ($100m).</p><figure float="none" data-type="figure" class="img-center" style="max-width: null;"><img src="https://storage.googleapis.com/papyrus_images/bba002ada950586bd22d4bce7a4dae6eedcac25a167a4e9d854428edbfc2c8e4.png" alt="Liquidation (USD) per collateral and debt asset" blurdataurl="data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=" nextheight="600" nextwidth="800" class="image-node embed"><figcaption HTMLAttributes="[object Object]" class="">Liquidation (USD) per collateral and debt asset</figcaption></figure><p><strong>3. Liquidated users</strong></p><p>A total of 5,650 addresses have seen their Aave loan(s) liquidated. The piechart shows there is quite some variability of the total dollar amount that is liquidated per user. Seven users account for about 25% of all liquidations!</p><figure float="none" data-type="figure" class="img-center" style="max-width: null;"><img src="https://storage.googleapis.com/papyrus_images/76870f02a07bac27970a451ceee53da9b6fb29b419625dcdeb295057f926e484.png" alt="Liquidations per user" blurdataurl="data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=" nextheight="600" nextwidth="800" class="image-node embed"><figcaption HTMLAttributes="[object Object]" class="">Liquidations per user</figcaption></figure><p>Let’s take a closer look at the users that have seen the largest liquidations. The table below ranks all users by total liquidated amount in USD. The address 0x57e04786e231af3343562c062e0d058f25dace9e has the ‘honor’ to lead the list, having been liquidated 385 times for a total of almost $64m. Who is behind the 0x57e account? It turns out it is <a target="_blank" rel="noopener noreferrer nofollow ugc" class="dont-break-out" href="https://platform.arkhamintelligence.com/explorer/address/0x57e04786e231af3343562c062e0d058f25dace9e">Avi Eisenberg</a>. Interestingly, all liquidations happened on the same day, namely November 22nd. He is thus responsible for the day that saw the second largest amount of liquidations! For more background, he <a target="_blank" rel="noopener noreferrer nofollow ugc" class="dont-break-out" href="https://decrypt.co/115390/mango-market-hacker-loses-millions-in-failed-aave-scheme">borrowed CRV tokens to short</a>, but ultimately failed.</p><figure float="none" data-type="figure" class="img-center" style="max-width: null;"><img src="https://storage.googleapis.com/papyrus_images/7f703aed751d395682ba4fe0872f9096a24918c771a5ccff7b3881a6b6fe6d7d.png" alt="Liquidations leaderboard" blurdataurl="data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=" nextheight="600" nextwidth="800" class="image-node embed"><figcaption HTMLAttributes="[object Object]" class="">Liquidations leaderboard</figcaption></figure><p><strong>4. Liquidators</strong></p><p>Since the launch of Aave V2 300 unique addresses have acted as liquidators, by repaying a part of the loan and receiving some collateral as a bonus. The piechart and table below shows that 0xb7990f251451a89728eb2aa7b0a529f51d127478 has liquidated the most in terms of dollar value ($210m), and more than half of those liquidations took place on May 19th 2021. Looking at the other liquidators, it is worth noting that the top-5 liquidators account for almost 50% of all liquidations.</p><figure float="none" data-type="figure" class="img-center" style="max-width: null;"><img src="https://storage.googleapis.com/papyrus_images/d4293d0b9d66a04ce7db4a563c83ee64fc8500f5c142fefb4dc3443084ce2085.png" alt="Liquidations per liquidator" blurdataurl="data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=" nextheight="600" nextwidth="800" class="image-node embed"><figcaption HTMLAttributes="[object Object]" class="">Liquidations per liquidator</figcaption></figure><figure float="none" data-type="figure" class="img-center" style="max-width: null;"><img src="https://storage.googleapis.com/papyrus_images/80a71f1601cfc6f1141f0088faec20008036ddbc5526d9ce588ae009bb557224.png" alt="Liquidator leaderboard" blurdataurl="data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=" nextheight="600" nextwidth="800" class="image-node embed"><figcaption HTMLAttributes="[object Object]" class="">Liquidator leaderboard</figcaption></figure><p><strong>5. May 19th 2021</strong></p><p>May 19th 2021: What a day - I was actually listening to a presentation about crypto at that time. I don’t think the presenter and the rest of the audience realized the crypto market was burning down. I remember searching for exchanges or websites that could still give accurate prices!</p><p>It was also a memorable day for Aave, seeing a record $172m in liquidations! A total of 670 loans were liquidated by 17 different liquidators.</p><p>The chart below shows that WETH was the collateral used most to liquidated loans (60m), followed by WBTC (45m) and LINK (20m). The most popular loans that were liquidated were stablecoins (USDT, USDC and DAI).</p><figure float="none" data-type="figure" class="img-center" style="max-width: null;"><img src="https://storage.googleapis.com/papyrus_images/d1575d323e1e0c087bbb92d556805d878ef304d5de759724643e730947e954c9.png" alt="Liquidation (USD) per collateral and debt asset on May 19th 2021" blurdataurl="data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=" nextheight="600" nextwidth="800" class="image-node embed"><figcaption HTMLAttributes="[object Object]" class="">Liquidation (USD) per collateral and debt asset on May 19th 2021</figcaption></figure><p>Who got liquidated? A total of 414 users saw their loan(s) liquidated. One user lost more than $25m - 0xe47d5cc33517d5b8433ff249efe094b989989acc is third on the leaderboard</p><figure float="none" data-type="figure" class="img-center" style="max-width: null;"><img src="https://storage.googleapis.com/papyrus_images/d0fee8062f0083644f1f95115c3d0b0631c64635f83c439ebeaac125c763ce5b.png" alt="Liquidated users on May 19th 2021" blurdataurl="data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=" nextheight="600" nextwidth="800" class="image-node embed"><figcaption HTMLAttributes="[object Object]" class="">Liquidated users on May 19th 2021</figcaption></figure><p><strong>6. Future analysis</strong></p><p>This is just a very basic analysis, but there is more interesting data to look at. Ideas for future analysis:</p><ul><li><p>Liquidations in Aave V3 (just launched on Ethereum Mainnet!)</p></li><li><p>Gas fees paid by liquidators</p></li><li><p>Profitability of liquidators</p></li><li><p>…</p></li></ul><p>Thanks for reading! Link to Dune dashboard: <a target="_blank" rel="noopener noreferrer nofollow ugc" class="dont-break-out" href="https://dune.com/dcooper/aave-liquidations">https://dune.com/dcooper/aave-liquidations</a></p>]]></content:encoded>
            <author>douglas-fir@newsletter.paragraph.com (Douglas Fir)</author>
        </item>
        <item>
            <title><![CDATA[Quality of Token Pairs on Uniswap]]></title>
            <link>https://paragraph.com/@douglas-fir/quality-of-token-pairs-on-uniswap</link>
            <guid>EQINnlwUB94VXFCbyJp7</guid>
            <pubDate>Mon, 09 Jan 2023 00:36:15 GMT</pubDate>
            <description><![CDATA[This post is part of competition organized by Dune and the Uniswap Foundation. It follows a 12-day Dune course focusing on Uniswap. It’s a great course that I highly recommend. More info can be found here: https://www.notion.so/12-Days-of-Dune-2022-2c30c5a875ce4650b19c1ef7dd60a11d The purpose of the competition is to write a Dune query that analyzes the quality of token pairs on Uniswap. The definition of ‘quality’ can be defined in many ways, but one possibility is to consider a pair of high...]]></description>
            <content:encoded><![CDATA[<p>This post is part of competition organized by Dune and the Uniswap Foundation. It follows a 12-day Dune course focusing on Uniswap. It’s a great course that I highly recommend. More info can be found here: <a target="_blank" rel="noopener noreferrer nofollow ugc" class="dont-break-out" href="https://www.notion.so/12-Days-of-Dune-2022-2c30c5a875ce4650b19c1ef7dd60a11d">https://www.notion.so/12-Days-of-Dune-2022-2c30c5a875ce4650b19c1ef7dd60a11d</a></p><p>The purpose of the competition is to write a Dune query that analyzes the quality of token pairs on Uniswap. The definition of ‘quality’ can be defined in many ways, but one possibility is to consider a pair of high quality if it has high usage (e.g. trading volume) and has a good stability. I decided to keep it simple and look at the size of the liquidity pools and trading volume to assess the usage of each pair. The stability of a pair is measured by the variability of the liquidity pool. Ideally you want to have a liquidity pool that is stable over time.</p><p>Rather than looking at all token pairs on Uniswap, I restrict the analysis to DAI token pairs (DAI-WETH, DAI-USDC, …). It turns out there are over 150 trading pairs on Uniswap V2 that have DAI.</p><p>The first metric to consider is the amount of liquidity that each pool has. Figure 1 shows the development for all DAI pools over the past six months. What stands out is the dominance of the DAI-USDC pair. Currently the DAI-USDC pool has over $30m in liquidity, accounting for almost 60% of all DAI pools on Uniswap V2. The second largest pool is DAI-WETH, with almost $15m in liquidity, followed by DAI-USDT ($7m). These three pools alone cover 90% of all DAI pools. Since November 2022, liquidity has been relatively stable across the largest pools. The total liquidity of all DAI pools is around $60m, which is down from $200m six months ago. The significant decline is largely due to the DAI-USDC pool that had a liquidity of $190m in August 2022.</p><figure float="none" data-type="figure" class="img-center" style="max-width: null;"><img src="https://storage.googleapis.com/papyrus_images/6a8f7cf912a3fb3fac3c01b36e57146e9005afb630f01dffcb958e29b3515d27.png" alt="The liquidity of all DAI token pairs on Uniswap V2" blurdataurl="data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=" nextheight="600" nextwidth="800" class="image-node embed"><figcaption HTMLAttributes="[object Object]" class="">The liquidity of all DAI token pairs on Uniswap V2</figcaption></figure><p>A second metric is the trading volume of each DAI pair. Figure 2 shows the daily trading volume of these pairs in USD. The DAI-WETH, of accounting for well over 50% of the daily trading volume of all DAI pairs. Most of the pairs see very little volume on a daily basis.</p><figure float="none" data-type="figure" class="img-center" style="max-width: null;"><img src="https://storage.googleapis.com/papyrus_images/6e260faa58cdb7340adaa03a993b848b796925226b7efb7af85d1a928e5340f4.png" alt="The daily trading volume of all DAI token pairs on Uniswap V2" blurdataurl="data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=" nextheight="600" nextwidth="800" class="image-node embed"><figcaption HTMLAttributes="[object Object]" class="">The daily trading volume of all DAI token pairs on Uniswap V2</figcaption></figure><p>Figure 3 puts these metrics together in a scatterplot. The X-axis shows the liquidity of each pool, expressed in USD. The Y-axis shows the variability of the liquidity pools. This is measured by the standard deviation of the liquidity pools over the past six months. The size of the bubbles represent the total trading volume seen over the past six months.</p><p>As one would expect from the prior charts, DAI-USDC and DAI-WETH stand out. Comparing these two pairs, DAI-WETH has seen a notably higher trading volume as can be seen from the size of the bubble. At the same time the pool of the token pair DAI-USDC is the most volatile pair (Figure 1 already showed the dramatic decline in the DAI-USDC pool).</p><p>It’s worth noting that only five pools have a balance of over $1m and only ten pools saw a trading volume over $1m over the past six months. That doesn’t look very positive for the other pairs...</p><figure float="none" data-type="figure" class="img-center" style="max-width: null;"><img src="https://storage.googleapis.com/papyrus_images/7f67c38b2257e0778449128145b6d8fafc50e59fd45c876adf5ee31bc966ac26.png" alt="Liquidity of DAI token pairs on Uniswap V2 (USD and stdev). Bubbles represent trading volume of the past 6m" blurdataurl="data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=" nextheight="600" nextwidth="800" class="image-node embed"><figcaption HTMLAttributes="[object Object]" class="">Liquidity of DAI token pairs on Uniswap V2 (USD and stdev). Bubbles represent trading volume of the past 6m</figcaption></figure><p>Based on these simple metrics, one could argue that only DAI-USDC, DAI-WETH, and to some extent DAI-USDT, are the higher quality pairs. The rest has seen very little usage (low trading volume, low pool balances). It’s not a real surprise that the WETH and USDC pairs come out as the ones with higher quality, given their market cap and high usage in general. Arguably the current bear market doesn’t play in the favor of the other pairs either. Another caveat is that I only looked at Uniswap V2.</p><p>The Dune dashboard can be found here: <a target="_blank" rel="noopener noreferrer nofollow ugc" class="dont-break-out" href="https://dune.com/dcooper/dai-pools-uniswap">https://dune.com/dcooper/dai-pools-uniswap</a></p>]]></content:encoded>
            <author>douglas-fir@newsletter.paragraph.com (Douglas Fir)</author>
        </item>
    </channel>
</rss>