Peimantest2
    Updated 2022-02-09
    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