Sushi Revenue

    The Question :

    What is the breakdown of revenue by unit for sushi?

    Approach :

    Methodology :

    to identify addresses of sushiswap platform in Ethereum tables, I have used the following query :

     where
    to_address in (select
    address
    from 
    flipside_prod_db.ethereum_core.dim_labels
    where label ilike '%sushiswap%'
    

    and then , joined to transaction table to get the gas. gas has a price. to get the eth paid for fees, we can multiply the gas price to gas amount and then get the amount. to get the usd ,amount of fees, we should join the RTH price to transaction table and multiply the price to the ETH amount .

    lets look at the results :

    Results :

    Loading...

    Paragraph

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

    Findings :

    • fee per tx for Add liquidity event is more than other studdied events

    • swapping has got the most fee and generated the most fees ,among in events analyzed in this dashboard. Repaying a loan is ranked second and Removing collateral ranked third.

    • looking at the fee growth chart, swapping,repaying loan and removing collateral had have the most exponential growh in generating fees among in analyzed events

    • overall transactions related to sushiswap in Ethereum network is decreasing by the time , so the fees paid by users is decreasing too

    • total fee generated from kashi is 20K usd