Trading & Data Analytics Platform for Crypto DeFi
Futureswap, a startup in the cryptocurrency sector, has created a Decentralized Leverage Trading Exchange on multiple blockchains, specifically Arbitrum and Avalanche. With an increasing volume of data being processed on their platform, they aimed to introduce an Analytics Dashboard Solution that would display key performance indicators (KPIs) and insights derived from pre-aggregated results and pre-indexed data. Consequently, we considered DuneAnalytics as a potential option for showcasing the required KPIs for our client. Whenever we take on a new project from our clients, we assess existing solutions and alternate packages before deciding to build from scratch. At the time we designed our solution, DuneAnalytics did not support the Layer 2 Arbitrum network or Avalanche. By April 2022, Dune's support extended only to Ethereum, Polygon, Binance Smart Chain, Optimism, and Gnosis Chain. Our Analytics Dashboard Solution was fully implemented using AWS Cloud, following an Agile Software Development approach led by a small team comprising two developers and a Technical Lead/Architect. The Dashboard provides near real-time metrics and KPIs related to the DeFi platform. Among other metrics, it includes various essential statistics. Additionally, utilizing Sagemaker Jupyter notebooks allowed us to leverage the storage layer for conducting ad hoc aggregations and metrics analysis using Python code. Our core library stack included tools such as Pandas, Plotly, and Seaborn.