Total Value Locked (TVL) is simultaneously the most popular and most misinterpreted metric in DeFi. Total Capital Allocated (TCA) is perhaps the more accurate phrasing. TVL insinuates that value is “locked” in a protocol, loyal and unwavering. Unfortunately for many projects, this is not the case. Short-term money games dominate…

Note: full code to this article can be found on GitHub.

Art by Will Tempest on behalf of the Ethereum Foundation (CC BY 4.0)

Previously I shared how to access blockchain data for DeFi projects using various centralized APIs like DeFi Llama and decentralized APIs like The Graph. This time around we’re going to query the blockchain directly using the Web3.py Python library.

Doge using Dapps // Art by Will Tempest.

Note: nothing herein is financial advice. Crypto projects are inherently associated with risk, largely unaudited, and experimental in nature. No charts, images, statistics, or observations herein should be used for investment decisions.

In this article we’ll access these APIs while providing sample code for how to work with REST, GraphQL…

Note: nothing herein is financial advice. Crypto projects are inherently associated with risk, largely unaudited, and experimental in nature. No charts, images, statistics, or observations herein should be used for investment decisions.

You can find the full code associated with this article here: GitHub Repo.

This article should act as…

Before we start

Welcome to the Spawner blog on Medium. We want this blog to fill the gap in finance blogs on this platform. Our goal is to provide you with information that is engaging, accurate, and fun. We’re not here to spam you with listicles or tell you what stocks to buy…

Posey

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store