#12.Sablier Top 10 Users
Q10. List 10 users who received the most funds and 10 users who sent the most funds through cash streams. Use Ethereum_core schema.
What is Sablier?
Sablier is a protocol for real-time finance built on the Ethereum blockchain which allows you to create money streams. Similar to streaming a movie or song, Sablier lets you stream money or payments in real-time.
Sablier's money streams can be used in many different ways. As a worker, streams allow you to see your earnings increasing in real-time in the Sablier wallet. As an organisation, Sablier’s technology helps you get rid of the hassle of payroll admin. As a protocol, Sablier makes token vesting easy. After a one-time deposit, Sablier’s smart contracts will start "streaming" the money towards the payees, without you lifting a finger again.
Who is the Most Fund Sender/Receiver over Sablier?
In this analysis, we are looking for the wallets (users) who have made the most money transfers through Sablier.
For this purpose, we first obtain all the transactions sent to Sablier and then, using the hourly-price table of Ethereum tokens(ethereum_core.fact_hourly_token_prices
), find the amount of tokens sent in dollar, and finally, by adding the amount of dollars sent by each wallet,we find the top 10 user.
We do the same for the receivers section.
For each group of users, we have obtained the number of transactions performed by the top users as well as the ten transactions that had the highest amount received or sent.
In this analysis, we have not considered the cancellation of submitted transactions
The following graphs show the output of this analysis, which in the final installment, we have a quick analysis of the results:
Key Findings
- Top users usually have a low number of transactions, ie they do not use this platform continuously.
- The average amount of tokens sent in a high volume transaction is higher than the average number of received transactions. This is probably due to the fact that users have sent a large amount of their assets, but receiving all of those assets is time consuming and is done gradually and over several transactions.