defianalystOverview DEX Stats
    Updated 2024-09-13
    -- forked from Alex_Dyan / Overview DEX Stats @ https://flipsidecrypto.xyz/Alex_Dyan/q/0VGecKS9ryq5/overview-dex-stats

    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
    polygon.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


    QueryRunArchived: QueryRun has been archived