SELECT DISTINCT nft_to_address AS user_address

FROM ethereum.nft.ez_nft_mints

WHERE block_timestamp::date >= '2024-01-01'

AND block_timestamp::date <= CURRENT_DATE()

),

purchased_users AS (

SELECT DISTINCT buyer_address AS user_address

FROM ethereum.nft.ez_nft_sales

WHERE block_timestamp::date >= '2024-01-01'

AND block_timestamp::date <= CURRENT_DATE()

),

all_users AS (

SELECT user_address FROM minted_users

UNION

SELECT user_address FROM purchased_users

),

ranked_mints AS (

SELECT

block_timestamp,

nft_to_address AS user_address,

project_name AS collection_name

FROM ethereum.nft.ez_nft_mints

WHERE block_timestamp::date >= '2024-01-01'

AND block_timestamp::date <= CURRENT_DATE()

qualify row_number() over (partition by nft_to_address order by block_timestamp asc) = 1

),

ranked_sales AS (

SELECT

block_timestamp,

buyer_address AS user_address,

project_name AS collection_name

FROM ethereum.nft.ez_nft_sales

WHERE block_timestamp::date >= '2024-01-01'