0xaimanTransaction Fees Paid by Metamask Users
    Updated 2022-06-25
    select * from (with swapsx as (with
    -- '0x881d40237659c251811cec9c364ef91dc08d300c')
    mm as (select distinct from_address from ethereum.core.fact_transactions where to_address=lower('0x881d40237659c251811cec9c364ef91dc08d300c') ),


    txn as (select block_timestamp, mm.from_address,tx_fee, tx_hash, to_address from ethereum.core.fact_transactions as ft inner join mm on mm.from_address=ft.from_address where status='SUCCESS')

    select from_address,block_timestamp, tx_hash,tx_fee, ADDRESS, ADDRESS_NAME, LABEL_TYPE, LABEL from ethereum.core.dim_labels as l inner join txn on txn.to_address=l.address
    where label_type='dex')




    select label, min(tx_fee)/10e17 as min_tx_fee_non_adjusted, max(tx_fee) as max_tx_fee , avg(tx_fee) as avg_tx_fee
    from swapsx

    where label='uniswap' or
    label='metamask' or
    label ='sushiswap' or
    label ='1inch' or
    label='0x'
    group by 1
    )



    Run a query to Download Data