superflyThe payment fee of all pools on the eth platform
    Updated 2022-07-14
    with M as
    (SELECT lending_pool,tx_hash from ethereum.sushi.ez_lending),
    C as(SELECT TX_HASH,tx_fee from ethereum.core.fact_transactions)
    SELECT lending_pool as POOLS,
    sum(tx_fee) as fee_payment
    from M left join C on M.tx_hash=C.tx_hash
    group by 1 order by 2 desc
    Run a query to Download Data