ENS Analytics

Screenshots

Problem Statement

Project Provides Dashboard for ENS Domains, where It's possible to View Life of any ENS Domain ever exists in the history of Ethereum.We are tracking different lifecycle stages of ENS domain like Domain Registered, Domain Transferred, Domain Renewed.Dashboard has following features:Detailed Tabular view of all the ENS domains and It's life cycle stagesFilter lifecycle records on Dashboard by ENS domainFilter lifecycle records by owners AddressFunnel analytics for domain owners. Track whales and mini whales who own many domainsTrack new domain registrations and new domain expiring with trend charts.Different Colouring of different life cycle method.

Solution

Technology UsedENS SubgraphPostgresSQL queryTypescriptI am using below ENS subgraph to pull Data.https://thegraph.com/explorer/subgraph/ensdomains/ensFollowing Entities are pulled and stored in Postgres Tables.1.RegistrationEventRegistrationDomainNameRegisteredNameRenewedNameTransferredSQL query is designed to Join different entities and generate Lifecycle of ENS Domain.Also, Search by ENS Domain Name and Owner address is available, this search is directly performed on the database.