anomoneTotal gas fees collected
Updated 2022-11-28
9
1
2
3
4
5
6
›
⌄
SELECT CASE WHEN (TO_LABEL= 'sushiswap' or FROM_LABEL = 'sushiswap' )THEN 'Sushiswap' ELSE 'Uniswap' END as "Platform",
sum(tx_fee) as "Total Gas fees collected in ETH" , sum(fee_usd) as "Total Gas fees collected 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