freemartianWeekly Fee & Transactions Count
    Updated 2022-12-06
    select
    date_trunc('week', block_timestamp::date) as TIME,
    sum(fee) as fee,
    count(tx_id) as transactions_count
    from terra.core.fact_transactions
    where TX_SUCCEEDED = 'TRUE'
    and block_timestamp >= CURRENT_DATE - {{Past_X_Days}}
    group by TIME
    Run a query to Download Data