Try Quests to earn SOL
Method
In this dashboard i’ve used tables below to analyze BONK airdrop.
from solana.core.fact_transfers
from flipside_prod_db.solana.dim_labels
from flipside_prod_db.solana.fact_swaps
where date> '2022-12-24'
and mint='DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'
and tx_from in (
'9AhKqLR67hwapvG8SA2JFXaCshXc9nALJjpKaHZrsbkw',
'6JZoszTBzkGsskbheswiS6z2LRGckyFY4SpEGiLZqA9p'
bar chart shows the top 50 wallets which received
the most amount of BONK,and the most significant ones are going to list below order by day:
27th December:
4CUMsJG7neKqZuuLeoBoMuqufaNBc2wdwQiXnoH4aJcD
(5T)
2yBBKgCwGdVpo192D8WZeAtqyhyP8DkCMnmTLeVYfKtA
(4.8T)
28th December:
DBR2ZUvjZTcgy6R9US64t96pBEZMyr9DPW6G2scrctQK
(15T)
3rd January:
6JZoszTBzkGsskbheswiS6z2LRGckyFY4SpEGiLZqA9p
(9T)
Graphs above show that Although the number of holders were decreasing since 25th of December, but the volume of airdrop held by users were increasing till 30th of December .
Since then the number of holders slightly increased and the volume started to decreased.
In these graphs it can be seen that the most swap to token amount related to Wrapped sol and Usd coin in the second place;
The vast majority of Swap to token transactions amount belongs to Usd coin (84.5%) and wrapped sol in the second place (14.8%).
At first sight it can be seen that Jupiter swap v4 has the most amount of both volume (55.3 %) and transaction count (87.9%) and highest volume on 4th of January on both as well.
same story goes for jupiter aggregator v2 as well but being in second place.
Conclusion
it seem that the vast majority of BONK volume devided to only 4 wallets from 27 th December till 3rd of January; and the volume of airdrop held by user increased overall since 25th December.
also the number of started to increasing after 26th December .
coming up to swap to token, the most dominant were Usd coin and wrapped sol on both volume and transaction.
Finally Jupiter swap v4 and Jupiter aggregator v2 were the most popular Solana swap programs used by people.