Learning to write. Writing to learn. Dune: https://dune.com/dcooper Twitter: https://twitter.com/The_Douglas_Fir
LI.FI - Aggregating The Bridges & DEXes
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...
LI.FI - Aggregating The Bridges & DEXes
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...
Ghost In The Machine: Liquidations in Aave
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...
Ghost In The Machine: Liquidations in Aave
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...
Quality of Token Pairs on Uniswap
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...
Quality of Token Pairs on Uniswap
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...
