anomoneAvg gas fees per transactions
Updated 2022-11-28
9
1
2
3
4
5
›
⌄
SELECT CASE WHEN (TO_LABEL= 'sushiswap' or FROM_LABEL = 'sushiswap' )THEN 'Sushiswap' ELSE 'Uniswap' END as "Platform",
avg(tx_fee) as "Avg Gas Fee per Txn in ETH" , avg(fee_usd) as "Avg Gas Fee per Txn in USD" FROM ethereum.transactions
where --tx_id = '0x477628c71e27abee051ac19b7e3d4bda87797f1bd843d21ae1c90221ceb9011e'
(TO_LABEL= 'sushiswap' or FROM_LABEL = 'sushiswap' or TO_LABEL= 'uniswap' or FROM_LABEL = 'uniswap' )
GROUP BY CASE WHEN (TO_LABEL= 'sushiswap' or FROM_LABEL = 'sushiswap' )THEN 'Sushiswap' ELSE 'Uniswap' END
Run a query to Download Data