SELECT

eth_to_address,

MIN(block_timestamp) AS first_ts

FROM

ethereum.core.ez_eth_transfers

GROUP BY

1

),

new_wallets AS (

SELECT

eth_to_address

FROM

first_tx

WHERE

first_ts >= '2022-12-01'

),

contract_activity AS (

SELECT

to_address,

COUNT(*) AS tx

FROM

ethereum.core.fact_transactions

JOIN new_wallets ON eth_to_address = from_address

WHERE

block_timestamp >= '2022-12-01'

GROUP BY 1

ORDER BY 2 DESC

limit 10

SELECT

to_address,

label,

CASE

WHEN to_address = '0x06450dee7fd2fb8e39061434babcfc05599a6fb8' THEN 'xen token'

WHEN to_address = '0x6dfc34609a05bc22319fa4cce1d1e2929548c0d7' THEN 'unlabeled'