tokens_list as

(SELECT block_timestamp,

PLATFORM,

TOKEN_IN as token,

from base.defi.ez_dex_swaps

where

PLATFORM ilike '%uniswap%'

union

SELECT block_timestamp,

PLATFORM,

TOKEN_out as token,

from base.defi.ez_dex_swaps

where

PLATFORM ilike '%uniswap%'),

valid_tokens as (

select DISTINCT token

from tokens_list

GROUP by 1

having count(distinct tx_hash) > 9),

time_tokens as (

SELECT

DISTINCT token ,

min(block_timestamp::date) as f_date,

max(block_timestamp::date) as l_date,

l_date-f_date as life