0xaimanGas Efficiency
Updated 2022-06-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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