BLOCK_TIMESTAMP,

ROW_NUMBER() OVER (partition by FROM_ADDRESS order by BLOCK_TIMESTAMP) as row_n,

FROM_ADDRESS,TO_ADDRESS,tx_hash

from ethereum.core.ez_token_transfers)

select

b.label,

b.LABEL_TYPE,

TO_ADDRESS,

count(distinct tx_hash) as no_use

from s left outer join ethereum.core.dim_labels b on s.TO_ADDRESS=b.ADDRESS

where tx_hash in (select tx_hash from s where row_n = 1)

and LABEL_TYPE!='token'

group by 1,2,3 having label is not null

order by 4 desc