Popex404fees and fees per user
    Updated 2022-11-30
    with a as (select date_trunc('d', block_timestamp) as date,
    count (distinct tx_sender) as active_address,
    sum(fee) as fee_amount
    from terra.core.fact_transactions
    where tx_succeeded = true
    group by 1)

    select date, fee_amount, fee_amount/active_address as fee_amount_per_user
    from a
    Run a query to Download Data