theericstoneUnique Transaction Initiators and Fees
    select
    tr.date,
    tr.from_label_type,
    tr.daily_fees_usd,
    tr.initiators,
    tr.daily_fees_usd / tr.initiators as fees_per_user,
    tr.daily_fees_usd / tr.transactions as fees_per_transaction
    from
    ( select
    date_trunc('day',block_timestamp) as date,
    from_label_type,
    sum(fee_usd) as daily_fees_usd,
    count(distinct tx_id) as transactions,
    count( distinct from_address ) as initiators
    from
    gold.ethereum_transactions
    where block_timestamap > getdate() - interval '8 weeks'
    group by 1,2
    order by 1,2 desc
    )tr;
    Run a query to Download Data