COUNT(DISTINCT platform) DEXs,

COUNT(DISTINCT Swapper) Users,

Count(DISTINCT tx_id) Swaps,

swaps/Count(DISTINCT Date_trunc('day', block_timestamp)) as Avg_swap_per_day,

Users/Count(DISTINCT Date_trunc('day', block_timestamp)) as Avg_users_per_day

FROM sei.defi.fact_dex_swaps