with

tokens_list as

(SELECT block_timestamp,

TOKEN_IN as tokenx,

symbol_in as sym,

from base.defi.ez_dex_swaps

where

PLATFORM ilike '%uniswap%'

union

SELECT block_timestamp,

TOKEN_out as tokenx,

symbol_out as sym,

from base.defi.ez_dex_swaps

where

PLATFORM ilike '%uniswap%'),

valid_tokens as (

select DISTINCT tokenx

from tokens_list

GROUP by all

having count(distinct tx_hash) > 9),

sells as (SELECT

DISTINCT TOKEN_IN , symbol_in,

count(DISTINCT TX_HASH) as "Selling swaps"

FROM base.defi.ez_dex_swaps

WHERE TOKEN_IN in (SELECT tokenx FROM valid_tokens)

GROUP BY all),