0xaimanGas Efficiency
    Updated 2022-06-08


    select * ,
    case
    when function_name='swap' or function_name='swapExactETHForTokens' or
    function_name='swapExactTokensForTokens' or
    function_name='swapETHForExactTokens' or
    function_name='swapExactTokensForETH' or
    function_name='swapExactTokensForTokensSupportingFeeOnTransferTokens' then 'Swaps' else null end as type
    from (select *
    from (select function_name, avg(tx_fee) as avg_fee, sum(tx_fee) as tot_fee

    from ethereum.transactions

    where to_label_subtype='swap_contract' and to_label='sushiswap'

    group by 1 order by 2 desc)
    where function_name='addLiquidity' OR
    function_name='removeLiquidity' or
    function_name='addLiquidityETH' or
    function_name='removeLiquidityETH' or
    function_name='swap' or
    function_name='swapExactETHForTokens' or
    function_name='swapExactTokensForTokens' or
    function_name='swapETHForExactTokens' or
    function_name='swapExactTokensForETH' or
    function_name='swapExactTokensForTokensSupportingFeeOnTransferTokens' or
    function_name='withdraw' or
    function_name='deposit'
    )
    Run a query to Download Data