Algorand - Ultimate On-Chain Exchange Dashboard


Algofi → Image Source
Algofi is a DEX and lending protocol which allows users to lend different Algorand assets to earn interest. In addition to that, users can also borrow digital assets while leveraging the existing assets already placed on deposit as collateral. → Source


Algorand On-Chain Exchange → Image Source
Decentralized exchanges further build on the promise of decentralized finance, users are able to provide liquidity to facilitate the exchange of their favorite ASAs and stablecoins. Most importantly, users can transact their assets without any intermediary facilitating the exchange. DEXs on Algorand include tinyman, algofi, pactfi, wagmiswap, humbleswap, fxdx. → Source

WAGMI Swap → Image Source
A community-driven DEX with fast settlement and low transaction fees powered by Algorand. WAGMIswap brings the best trading opportunities to find and maximize your yield. → Source


✍️ Description of Work
On this dashboard, we built the ultimate on-chain exchange dashboard that will keep Algorand ecosystem users informed about Algorand ecosystem exchanges and allow them to compare their options. To do this, we examine the following:
- Total number of swaps, swap volume (USD) and number of unique swappers on each exchange
- Number of swaps, swap volume (USD) and number of unique swappers on each exchange over time
- % of market share of each exchanges
- Top asset that swapped from/to other asset by number of swaps and swap volume (USD) on each exchange
- Top swappers by number of swaps and swap volume (USD) on each exchange
- Date of creation of the swapper wallets on each exchange
- The amount of $ALGO held by swappers on each exchange
- Other Assets that swappers hold on each exchange
🧠 Methodology
To deal with this dashboard, we use the algorand.defi schema and ez_price_pool_balances, fact_swap, fact_account_current_balance==, ==dim_account tables.
In this dashboard, we use defined parameters that include Days, Exchange and Date_Trunc to display results based on your desired parameter(s).
-
Days: Last days by number of days
-
Exchange: The exchange(s) you choose and the results and charts are displayed based on them.
- You can see the results of all exchanges or compare them two by two, or see the results of a specific exchange
-
Date_Trunc: Date_Trunc based on which over time charts are displayed (Daily, Weekly or Monthly)
\
-
We get the asset prices from the ==ez_price_pool_balances== table, and since we have asset prices from ==2022-01-19== onwards, we consider All time since 2==022-01-19== for all calculations in order to have a correct analysis
-
All results are updated every day
-
To apply the parameters, first log in to flipsidecrypto, then select the desired parameters in the parameters section and finally click the Apply All Parameters button to have the results updated for you.
-
We ignore transactions that exceed ==$500,000== per swap because these types of transactions are not valid.


🔗 Links
- Tweet link for this dashboard: Ultimate On-Chain Exchange Dashboard
- Discord: Yousefi_1994#7190
- Twitter: Yousefi_1994