week,

useractivity,

count(distinct ORIGIN_FROM_ADDRESS) as N_Users

(

select

distinct ORIGIN_FROM_ADDRESS,

count(distinct tx_hash) as "# of Swaps",

date_trunc('week', block_timestamp) as week,

case

when "# of Swaps" < 2 then 'A: 1 Swap'

when "# of Swaps" >= 2

and "# of Swaps" < 5 then 'B: 2-5 Swaps'

when "# of Swaps" >= 5

and "# of Swaps" < 10 then 'C: 5-10 Swaps'

when "# of Swaps" >= 10

and "# of Swaps" < 20 then 'D: 10-20 Swaps'

when "# of Swaps" >= 20

and "# of Swaps" < 50 then 'E: 20-50 Swaps'

when "# of Swaps" >= 50

and "# of Swaps" < 100 then 'F: 50-100 Swaps'

else 'G: >= 100'

end as useractivity

from

base.defi.ez_dex_swaps

where platform = '{{DEX}}'

group by

ORIGIN_FROM_ADDRESS,

week

)

group by

week,