select distinct from_address

from base.core.fact_transactions

where

block_timestamp >= '2024-01-01'

AND block_timestamp < '2025-01-01'

and nonce >=99

)

-- DATE_TRUNC('month', d.block_timestamp) AS month_,

CASE

WHEN d.platform IN ('uniswap-v2', 'uniswap-v3') THEN 'Uniswap'

WHEN d.platform IN ('sushiswap-v2', 'sushiswap-v3') THEN 'Sushiswap'

WHEN d.platform IN ('camelot-v2', 'camelot-v3') THEN 'Camelot'

WHEN d.platform IN ('dodo-v1', 'dodo-v2') THEN 'Dodo'

when d.platform in ('trader-joe-v1', 'trader-joe-v2') then 'Trader-Joe'

when d.platform in ('zyberswap-v2','zyberswap-v3') then 'Zyberswap'

when d.platform in ('ramses-v2') then 'Ramses'

when d.platform in ('hashflow-v3') then 'Hashflow'

when d.platform ilike '%pancakeswap%' then 'Pancakeswap'

ELSE initcap(d.platform)

END AS platform_name,

COUNT(DISTINCT d.origin_from_address) AS super_users

FROM base.defi.ez_dex_swaps d

INNER JOIN t1 on t1.from_address = d.origin_from_address

WHERE d.block_timestamp >= '2024-01-01'

AND d.block_timestamp < '2025-01-01'

group by 1

order by 2 desc

limit 5