Merry $BONK-ing Christmas

    Introduction

    Bonk is the first Solana dog coin for the people, by the people with 50% of the total supply airdropped to the Solana community. The Bonk contributors were tired of toxic “Alameda” tokenomics and wanted to make a fun memecoin where everyone gets a fair shot. 

    Method

    The solana.core.fact_transfers table has used to track the $BONK token holder activities to find total number of holders, average balance and etc. Also I tried to find the major activities that holders desired to do after token launch in December 12th, 2022. To find the origin and destinations of transferred tokens I classified from and to addresses by their labels and concated those by their label type and subtypes as belo:

    from_label_type || ' => ' || to_label_type as from_type_to,
    from_label_subtype || ' => ' || to_label_subtype as from_subtype_to,
    

    I used solana.core.fact_swaps table by method of t1.SYMBOL || ' => ' || t2.SYMBOL as swap_pairs to find the most popular swaps pairs among holders.

    At end, I used solana.core.fact_nft_sales and solana.core.dim_nft_metadata tables to find holders top 10 desired NFTs as second holders activity.

    Analysis

    :hourglass_flowing_sand: Overall View

    There are 118.1K unique addresses as $BONK holders, that their balance is 639M in average and 120.9T token are in circulation.

    Also, there were 82.03K eligible addresses that claimed receive their tokens.

    The most transferring tokens took place as wallet to wallet after airdrop address to airdrop address.

    ✍🏻 Conclusion

    As of Findings above:

    There are 118.1K unique addresses as $BONK holders, that their balance is 639M in average and 120.9T token are in circulation.

    99.1% of holders transactions, have executed to take a swap and the rest 0.9%, were belong to NFT, Add liquidity, Remove liquidity, Stake/Unstake and Voting, respectively.

    Over 40% of swap transactions took place by holders to swap USDC & SOL (33.6 + 5.84) to BONK and 21.3% other belong to buy $SOL.

    Degods, with about 440K buying volume and 736 buying transactions was the most popular NFT project among holders.

    And finally, I’m glad to share this research with those who care about this issue via Twitter link, and will be pleased by your comments.

    About:

    It's still Christmas for Solana's dog coin $BONK — people all over crypto twitter are giving away billions of $BONK tokens, and its price has risen over 40% in the last day (NFA). Bring the world up to speed on Bonk Inu, with all of our favorite metrics:

    • Total # of holders
    • % of holders that are active wallets
    • Average amount $bonk in holder wallets
    • Average time holding bonk
    • Any other notable trends or outliers you see

    Then, give us context!

    What kinds of Solana users are $bonk holders?

    How active are they, what other tokens do they tend to hold, etc. Has Solana activity as a whole risen in conjunction with recent $bonk activity, and how much Solana activity does Bonk Inu account for?

    Hey there 👋!

    Firstly, I appreciate you sticking with it until the conclusion.

    I'm Hamed, a civil engineering Ph.D.

    student interested in data analysis.

    I've made many similar dashboards and visualizations since I started at Flipside in January.

    Please take a look at my various contact details and let me know what you think.

    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...

    :mag_right: Findings:

    As of chart right the daily number of active wallets increased after dropping from 30K in Dec 25, the day of claiming, to below 5K in Dec 26th, it raised again to closely 25K in Jan 4th.


    :hourglass_flowing_sand: Now, we want to know what activities were desirable of holders.

    The following visuals show the desirable activities by holders.

    As can be seen 99.1% of holders transactions executed to take a swap and the rest 0.9%, were belong to NFT, Add liquidity, Remove liquidity, Stake/Unstake and Voting, respectively.

    :mag_right: Findings:

    As of charts right can be observed, the most popular activity after swapping was the NFT trading.

    The most popular NFT projects among the holders are shown in the charts right below.

    Degods, with about 440K buying volume and 736 buying transactions was the most popular NFT project among holders.

    :mag_right: Findings:

    The charts right show the most popular swap pairs that holders have tended to swap after launch date (Dec 24th).

    As can be seen, more than 40% of swap transactions took place by holders to swap USDC & SOL (33.6 + 5.84) to BONK and 21.3% other belong to buy $SOL.