AndreRusaOverview DEX Stats
    Updated 2025-01-28
    with A as (
    select
    sum(abs(AMOUNT_IN_USD)) as total_dex_volume,
    count(distinct TX_HASH) as total_dex_txn,
    count (distinct ORIGIN_FROM_ADDRESS) as total_dex_users
    from
    base.defi.ez_dex_swaps
    )
    select
    total_dex_volume,
    total_dex_txn,
    total_dex_users,
    total_dex_volume / total_dex_txn as avg_volume_per_swap
    from
    A
    Last run: 3 months ago
    TOTAL_DEX_VOLUME
    TOTAL_DEX_TXN
    TOTAL_DEX_USERS
    AVG_VOLUME_PER_SWAP
    1
    252486383206.6938049979492589574663.565098295
    1
    52B
    59s