mattkstewMetamask vs. Other Platforms 9
    Updated 2022-06-23
    with tab1 as (
    select
    tx_hash

    from ethereum.core.ez_dex_swaps
    where platform like 'sushiswap'
    group by 1
    )

    , tabSUSHI as (
    select
    date_trunc('day', block_timestamp) as date1,
    sum(tx_fee) as Sushi_fees

    from ethereum.core.fact_transactions
    where tx_hash in (select * from tab1)
    and block_timestamp > current_date - 90
    group by 1 )

    , tab2 as (
    select
    tx_hash

    from ethereum.core.ez_dex_swaps
    where platform like '%uniswap%'
    and amount_in_usd < 1000000000
    group by 1
    )


    , tabUNI as (
    select
    date_trunc('day', block_timestamp) date2,
    sum(tx_fee) as Uni_fees

    from ethereum.core.fact_transactions
    Run a query to Download Data