Consider only successful transfer transactions of native SOL with at least 0.001 SOL (1000000 lamports) transferred.

List the top 50 addresses with the highest total count of transactions for the week preceding today. (If today is the 12th of March, your solution should use transfers for 5,6,7,8,9,10,11 of March)

The result should include the following data:

1. Total transactions count (you need to get the top 50 by this column)
2. Incoming transactions count
3. Outgoing transactions count
4. Incoming total SOL volume
5. Outgoing total SOL volume

Bonus points (up to 10 addresses):

Select any of the top 50 addresses and find out:

1. What is the company (entity) behind this address?
2. Explain how this address is used.

Example:

ADaUMid9yfUytqMBgopwjb2DTLSokTSzL1zt6iGPaS49

It is an address of JITO used to collect transaction fees.

Solana data:

I would recommend using Dune’s tokens_solana.transfers link, but you can use any data source.