replace(replace(replace(replace(PLATFORM, '-v1', ''), '-v2', ''), '-v3', ''), '-slipstream', '') as dex,

sum(nvl(amount_in_usd,amount_out_usd)) as monthly_dex_volume,

count(distinct ORIGIN_FROM_ADDRESS) as monthly_users,

count(distinct TX_HASH) as monthly_txn

base.defi.ez_dex_swaps

BLOCK_TIMESTAMP >= CURRENT_TIMESTAMP - interval '30 days'

group by

dex

order by

2 desc