Afonso_Diaz2023-02-03 03:03 PM
    Updated 2023-02-03
    select
    date_trunc (week, block_timestamp)::date as week,
    count (distinct tx_id) as txns_count,
    count (distinct tx_sender) as active_users_count,
    txns_count / active_users_count as txn_per_user,
    sum (txns_count) over (order by week) as cumulative_txns_count,
    sum (active_users_count) over (order by week) as cumulative_active_users_count,
    sum (txn_per_user) over (order by week) as cumulative_txn_per_user
    from terra.core.fact_transactions
    where fee_denom = 'uluna'
    group by 1
    order by 1
    Run a query to Download Data