Sock Explorer

Screenshots

Problem Statement

This is a visual representation of all current SOCKS holdersPeople can see the $SOCKS whales and click to view their wallet in etherscanPeople can zoom in and out, and view holdings, when bought, and if they have one, their ENS name Future plans include search and filterSockstory page for adding history, culture, and story of $SOCKSThis is a fun community project that we can roll out (by current demand already from Jordan) for $SACKS, and no doubt more!

Solution

'- React and D3Currently using JSON file scraped from etherscan APIHand-rolled scssHosted on IPFS using FLEEKENS domain sockexplorer.eth.linkPOAP for current $SOCKS holdersWe haven't yet set up our subGraph - however over the next few weeks we will, to automate and decentralise the data-collection processUse the Etherscan API to get all token transactions from a contract addressRestructure the data so each transaction has 2 records, one for the sender, and one for the receiverGroup data by wallet address and calculate wallet token value after each transactionCalculate initial token transaction date and last token transaction dateFilter data to the last transaction for each wallet, giving us the current token valueCheck wallet addresses with with reverse ENS lookup using Infura/Web3Export data to json file