t1 as (

select

block_timestamp,

buyer_address,

tx_hash,

price_usd

from ethereum.core.ez_nft_sales

join ethereum.core.fact_transactions

using(tx_hash)

where to_address = '0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b'

),

t2 as (

select

buyer_address,

min(block_timestamp) as min_date

from t1

where price_usd > 0

group by buyer_address

),

t3 as (

select

min_date::date as day,

count(distinct buyer_address) as new_users_count

from t2

group by day

),

t4 as (

select

block_timestamp::date as day,

count(distinct buyer_address) as users_count

from ethereum.core.ez_nft_sales

join ethereum.core.fact_transactions