elsina2024-07-08: single numbers
    Updated 2024-07-08
    SELECT
    COUNT(DISTINCT tx_hash) AS total_transaction_count,
    COUNT(DISTINCT origin_from_address) AS unique_trader_count,
    SUM(amount_in_usd) AS total_transaction_volume,
    total_transaction_count / unique_trader_count AS average_transactions_per_user,
    total_transaction_volume / unique_trader_count AS average_volume_per_user,
    total_transaction_volume / total_transaction_count AS average_volume_per_transaction
    FROM
    arbitrum.defi.ez_dex_swaps

    QueryRunArchived: QueryRun has been archived