Peimantest2
Updated 2022-02-09
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT 'Sushiswap' AS DEX, SUM(tx_fee) As "Total gas fee collected", Avg(tx_fee)::string As "Average gas fee"
FROM ethereum.transactions
where to_label= 'sushiswap'
And block_timestamp >= current_date - 60
UNION
SELECT 'Uniswap', SUM(tx_fee),Avg(tx_fee)::string
FROM ethereum.transactions
where to_label= 'uniswap'
And block_timestamp >= current_date - 60
Run a query to Download Data