Hessishsushiswaps fees
    Updated 2022-06-26
    with meta as (
    SELECT distinct tx_hash
    FROM ethereum.core.fact_transactions
    WHERE to_address = lower('0x881D40237659C251811CEC9c364ef91dC08D300C')
    and block_timestamp >= CURRENT_DATE - 180),

    sush as ( SELECT tx_hash
    from ethereum.core.ez_dex_swaps
    where tx_hash not in (select tx_hash from meta)
    and platform = 'sushiswap'
    and block_timestamp >= CURRENT_DATE - 180)
    SELECT sum(a.FEE_USD) as fees
    from flipside_prod_db.ethereum.transactions a
    join sush b
    on a.TX_ID=b.tx_hash



    Run a query to Download Data