anabelaTotal Transaction of Jumbo Exchange in last 3 months
    Updated 2022-12-17
    select
    count(distinct(tx_hash)) as tx_count,
    count(distinct tx_signer) as users_count,
    count(distinct tx_receiver) as receivers_count,
    sum (transaction_fee / 1e24) as total_fee,
    avg (transaction_fee / 1e24) as avg_fee,
    median (transaction_fee / 1e24) as median_fee
    from near.core.fact_transactions
    where tx_receiver = 'v1.jumbo_exchange.near'
    and block_timestamp >= current_date - interval '3 month'
    and tx_status = 'Success'
    Run a query to Download Data