Solana - 4. The Solana Smart Money

Create a dashboard that tracks the most profitable traders on Solana (both in terms of token swaps and with NFTs). Use parameters to help define who falls under the category of most profitable and over what timeframe. What has "smart money" been doing on Solana over the past month? Over the past week? Are they active traders or do they hold positions for days at a time? What projects have yielded the most profit for Solana traders? Are there any indicators of what their next trades or strategy will be? How does your dashboard compare to Hellomoon's smart money inflows and outflows?

Methodology

Find NFT sales from solana.fact_nft_sales with filters
For Top 10 buying and selling, we look at each sale and find the corresponding buyer and seller using lag function

    lag(purchaser, 1) ignore nulls over (partition by mint order by block_timestamp asc) as seller,
    lag(sales_amount, 1) ignore nulls over (partition by mint order by block_timestamp asc) as bought_price

For Token Sales we look at solana.core.fact_swaps and convert the token price into USD using solana.core.ez_token_prices_hourly
This analysis looks at the Top 10 Traders for both NFTs and Tokens.

The number of days can be updated by the parameter above.

What has "smart money" been doing on Solana over the past month? Over the past week?

Are they active traders or do they hold positions for days at a time?

As seen below all the most profitable traders are quite active in terms of the number trades.
They do a lot more NFT trades as compared to token trades which is kind of surprising.
Once thing we see is they don’t get attached to their NFTs with an average holding period of 0.5 to 2.4 days.
We have the activities the top traders have been doing over the past 30 days(default) for both NFT and Token Traders.

The number of days can be updated by the parameter above.

How does your dashboard compare to Hellomoon's smart money inflows and outflows?

Hellomoon's dashboard is more focused on the NFTS and each ones floor price, it doesn’t go down at the wallet level.
This dashboard is more about Top Trader for both NFTs and Tokens, and the details on what kind of things the top traders do.

Most Profitable Token Traders

We look at the total profit while swapping tokens and then look at the following metrics
- BmArwWweKjMmQ9nLGvPUHWA8rkDBHB3ADuxnvh5NTftK is the most profitable trader for Tokens, with a total profit of 45M $USD.
  - Total Investment
    - BmArwWweKjMmQ9nLGvPUHWA8rkDBHB3ADuxnvh5NTftK had a total investment of 42.7k $USD
  - Total # of Swaps
    - BmArwWweKjMmQ9nLGvPUHWA8rkDBHB3ADuxnvh5NTftK only did 64 traders to make45M $USD in profit

Most Profitable NFT Traders

We look at the total profit while swapping tokens and then look at the following metrics
- 8JQwG9NbgbAynSGM5NuV2wxXtZKagLGVpFwueeuSvtF2 is the most profitable trader for NFTs, with a total profit of 0.68M $USD.
- Total Investment
  - 8JQwG9NbgbAynSGM5NuV2wxXtZKagLGVpFwueeuSvtF2 had a total investment of 35.2K $USD
- Total # of NFT Trades
  - 8JQwG9NbgbAynSGM5NuV2wxXtZKagLGVpFwueeuSvtF2 did a total of 650 traders to make 0.68M $USD in profit
- Average Time NFT Held
  - The average time holding period for 8JQwG9NbgbAynSGM5NuV2wxXtZKagLGVpFwueeuSvtF2 was 2.42 days.

What projects have yielded the most profit for Solana traders? Are there any indicators of what their next trades or strategy will be?

Okay Bears has been the most profitable for NFT Solana Traders.
Generating a total profit of over 500K, towering over all the other projects.
The next big project was DeGods, and even they have now moved on to Polygon.
In terms of next indicators, there is nothing indicating what the will do next, it just seems to be the most popular project at the moment that is the most profitable and can be flipped quickly.
This can be verified by the average number of days held, with Okay Bears only being held around 2 days by average trader.

flipside