Afonso_Diaz2023-02-03 02:57 PM
    Updated 2023-02-03
    with t1 as (
    select tx_sender,
    count (distinct tx_id) as txns_count,
    count (distinct block_timestamp::date) as active_days,
    sum (fee) as total_fee
    from terra.core.fact_transactions
    where fee_denom = 'uluna'
    group by 1
    )

    select avg (txns_count) as average_txns_count,
    avg (total_fee) as average_fee,
    avg (active_days) as average_active_days
    from t1
    Run a query to Download Data