Alammex

> Alammex is a DEX aggregator for swaps on the Algorand blockchain. Alammex provides the best price for any swap (compared to any DEX)

Why choose Alammex?

Best Price Guaranteed: Alammex will always provide the best quote for any swap, compared to any single DEX.
Profit-Based Commissions: Alammex will only charge a commission if it is able to make a profit for the user. The majority (70%) of profits will go to the user, the remainder is the commission. The commission is only charged if all swap transactions succeed.
Secure: Alammex only leverages smart contracts that have been audited by trusted sources and endorsed by the Algorand Foundation.
Transparent: All costs are displayed up front. What you see is what you get!

twitter

website

\n

Description of Work

In this bounty, we examine all swaps that pass through Alammex. To analyze and examine the following items:

Total volume and number of swaps that through Alammex and Compare with other
Volume and number of swaps go through Alammex per day
Compare Dex that swaps go through Alammex
Top asset (From/To) that swaps go through Alammex
Top swapper that swaps go through Alammex

Note

We use the algorand schema, transactions and ==swaps== tables
In order to get the list of swap transactions that pass through Alammex, we need to find the entire list of tx_group_ids using the tx_message field in the transactions table, then join this list with the swaps table using tx_group_id to get the result. we have:
- Condition to find Alammex transactions: In ==transactions table:
  - select parse_json(try_base64_decode_string(tx_message:txn:note::string)):groupIds → It gives us an json array of group_ids like:
```
"groupIds": [
    "ahFj6rLF1uxZfu0K9KtJscP0z50Nh23fxmQDMCidBPY=",
    "z/N10HJWX5L9MHNcfB9RrUW+GRAULwVhe1Bwj5Qg2XM=",
    "fVPyNkPiofCysqegu11ac3755vVTGlLBaW9r9P/dDXM="
  ]
```
  - where contains(try_base64_decode_string(tx_message:txn:note::string), 'groupIds') → All swaps that pass through Alammex have their tx_group_id recorded in the tx_message
  - and block_timestamp::date >= '2022-06-27' → Alammex starting on June 27th
- After obtaining an json array of tx_group_ids, we must extract each of the arrays item that have a separate tx_group_id into a separate row:
  - We should get this output:
```
[0]: "ahFj6rLF1uxZfu0K9KtJscP0z50Nh23fxmQDMCidBPY="
[1]: "z/N10HJWX5L9MHNcfB9RrUW+GRAULwVhe1Bwj5Qg2XM="
[2]: "fVPyNkPiofCysqegu11ac3755vVTGlLBaW9r9P/dDXM="
.
.
[N]: "nth group_id"
```
- So we use the following for this:
  - table (flatten (input => group_id_array) )
- After obtaining the tx_group_ids, we join them with the swap table and perform the required analysis

1 → Total volume and number of swaps that through Alammex and Compare with other

Conclusion of part 1

Since Alammex started working, the total Number of Swaps is 228,335, of which 406 were done through Alammex, that is, about 0.17% of the total number of swaps done through Alammex
Since Alammex started working, the total Volume of Swaps is 17,842,848.0003 USD, of which 56208.940856975 USD has been done through Alammex, that is, about 0.31% of the total volume of swaps has been done with Alammex.
Since Alammex started working, the Total number of unique swappers is 7,270, of which 43 have swapped through Alammex, that is, about 0.59% of all swappers have swapped with Alammex.

2 → Volume and Number of Swaps and Number of Swapper go through Alammex per day

Conclusion of part 2

The highest number of swaps is on Jun 28 with 69 swaps followed by Jul 6 with 45 swaps.
On July 2 and July 3, the number of swaps Decreased by almost 50% compared to July 1, and then increased again.
The largest volume of swaps is related to Jul 7 with 28.84k USD, which is approximately 51.31% of the total volume of swaps related to Jul 7
The highest number of swappers is related to Jun 28 with 23 unique swappers, followed by Jul 6 with 21

It can be seen that the number of swaps and the number of swappers have a stable trend, but the volume of swaps is increasing and the use of Alammex may increase in the future.

\

3 → Compare Dex that swaps go through Alammex

Conclusion of part 3

It can be seen that the highest Number of Swaps done through Alammex is on pactfi with 219 swaps (53.9%), followed by tinyman with 120 swaps (29.6%) and algofi is in last place with 67 swaps (16.5%).
It can be seen that the highest Volume of Swap done through Alammex is on tinyman with 31.98k USD (56.9%), followed by pactfi with 20.5k USD (36.5%) and algofi is in the last place with 3.7k USD (6.62%)

\

It is interesting that more swaps are done through Alammex on pactfi, but the largest volume of swaps is related to tinyman, which recently and on July 7, the largest volume of swaps was on tinyman (sharp growth).

4 → Top asset (==From/To==) that swaps go through Alammex

Conclusion of part 4

The most asset Swapped From other assets via Alammex was USDC at 30.75k USD, followed by ALGO at 10.45k USD and USDT at 7.66k USD.
The most Swapped To asset through Alammex is ALGO at 27.83k USD, followed by USDC at 14.16k USD and USDT at 3.11k USD.
It is interesting that the swap From USDC was mostly on tinyman, but the swap To USDC was mostly on pactfi

5 → Top swapper that swaps go through Alammex

Conclusion of part 5

Interestingly, the wallet UWPTQP34HYROPOJIFGHF3F6NIZRH4HN43H7PHNL3KHRJBN7RE3UY4DB464 has the largest volume of swaps through Alammex with a volume of 24389.99695225 USD, which was done in only 2 transactions of this swap. After that ZJPANYIHXRHXGA3B33CB3VTBFZSEX4DPPLI5NMPYWK2N4MGUTAEMOROPCA wallet has the highest volume of swaps through Alammex with 18318.823992642 USD in 84 swap transactions.

Final Conclusion

Since Alammex started operating (June 27), the swaps made through Alammex, both in terms of volume and number of swaps, are below 1% of the total swaps made in this period. But it can be seen that the volume of swaps through Alammex is increasing (but not much), also, most of the swaps in terms of swap volume were on tinyman, and the largest number of swaps was on pactfi, and ALGO, USDC, and USDT assets have the largest swap ==(From/To)== volume.

flipside