DeFi Address Overview

Dashboard covering network-wide active address counts, active address counts by sector (DEXES, NFTs, etc.), and active addresses by contract interactions. The dashboard aims at introducing a new way to look at on-chain active addresses that deviates from the traditional calculation. This is done to get a better sense of the real number of addresses actively contributing to a network's ecosystem of applications, and playing part in the network effects that drive the growth of DeFi.

Definitions

DeFi Address: Addresses that have interacted with any DeFi protocol (including lending/ borrowing, DEXES, NFTs, bridges, etc.).
DEX Address: Address that have interacted with at least one DEX related contract (including swaps, LP, etc.).
NFT Address: Addresses that have used NFTs to any capacity (minting, buying, selling, etc.). Transferring NFTs is not included.
Layer 2 Address: Addresses that have passed assets through applications moving assets from a network's Layer 1 to its Layer 2, and vice versa.
Dead Weight Address: The address count delta between the traditional count of daily active addresses (typically expressed as count(from_address)) and the count of DeFi addresses.
Interaction: Unique touch points with a smart contract. For this analysis, a touch point is considered to be user address > smart contract and not smart contract > user address. This is done to ensure actions performed by users are the only points counted.

See the Data for Other Networks

Tables and Schema

Tables Used

Ethereum
Arbitrum

Schema Used

dim_labels
fact_transactions

Links to Queries

Follow me on Twitter and check out my Medium