Try Quests to earn cryptoAlgorand Bounties
Description of work: step 1: Get number of trades to/from gALGO3 for each day and compare step 2: Get number of gALGO3 swaps(to or from) by day for each dex and compare step 3: Get top 10 most popular to swap from to get gALGO3 step 4: Get top 10 most popular to swap to from gALGO3 In this question, we use table algorand.swaps for each section
In this question we want to get the number of transactions to / from gALGO3 per day. We get the number of trades to / from gALGO3 and the trade date from the algorand.swaps table, then group and order by the date block_timestamp and get the number of trades to/ from gALGO3.
Since October 2021, the Algorand ecosystem has moved to a decentralized Governance model. Algo holders can commit their own Algo, becoming governors, and participate in the Governance decisions. Unfortunately, the Algo holders have to lock their Algo for a quarter losing the possibility to use their own liquidity for that commitment period. Folks Finance designed a new system that allows the users who wish to participate in the Algorand Governance not to lose the liquidity for the voting period by distributing a liquid asset named gALGO, minted at 1:1 to the value of Algo. Users can continually mint gALGO at a one-to-one rate after the commitment period has ended and they can make any kind of operations following their strategies.
According to the chart on 13 April 2022 the conversion trade to/from gALGO3 has increased dramatically and this may indicate that ALGO governors has been increase. also this chart is shows that the number of trades to gALGO3 per day is greater than the number of trades from gaALGO3
To find the number of trades on each dex, we group by the swap list to / from gALGO3 on date and dex.
According to the result of the query and the chart, it is clear that all trades to / from gALGO3 were performed on tinyman and pactfi. There have also been more trades on tinyman.
In this question, we will find top 10 most popular to swap to from gALGO3. To do this, join the two tables algorand.asset and algorand.swaps on asset_id and to_asset_id, and then filter the list of swaps from gALGO3, group them by asset name and asset_id, and get the top 10
In this question, we will find top 10 most popular to swap from to get gALGO3. To do this, join the two tables algorand.asset and algorand.swaps on asset_id and to_asset_id, and then filter the list of swaps to gALGO3, group them by asset name and asset_id, and get the top 10
Asset_id = 0 means that ALGO users have locked themselves in Folks.finance for governance and received gALGO3 when their ALGO is locked.
The value asset_id = 0 indicates the end of governance period that all users can burn their gALGO for ALGO at a one-to-one rate.