(select address as id,

address_name

from avalanche.core.dim_labels

where label_subtype like 'token_contract'

),

nextlink as

(select count(*),

address_name,

project_name,

contract_address

from avalanche.core.fact_token_transfers f

left outer join avalanche.core.dim_labels d on

f.contract_address = d.address

where contract_address in (select id from link)

and address_name not like '%bridge%'

group by 2,3,4

order by 1 desc

limit 20)

select distinct address_name,

count(*),

date_trunc('day', block_timestamp)

from avalanche.core.fact_token_transfers f

left outer join avalanche.core.dim_labels d on

f.contract_address = d.address

where contract_address in (select contract_address from nextlink)

group by 1,3