SELECT DISTINCT nft_to_address, project_name, block_timestamp, tx_hash

FROM aptos.nft.ez_nft_mints

UNION

SELECT DISTINCT buyer_address AS nft_to_address, project_name, block_timestamp, tx_hash

FROM aptos.nft.ez_nft_sales

),

daus as (

SELECT

distinct sender as users,

trunc(block_timestamp,'week') as weeks,

count(distinct trunc(block_timestamp,'day')) as active_days

from aptos.core.fact_transactions

group by 1,2

having active_days>=4

),

active_users AS (

SELECT

TRUNC(block_timestamp, 'week') AS date,

project_name,

COUNT(DISTINCT nft_to_address) AS n_users,

COUNT(DISTINCT tx_hash) AS txs

FROM nfts

GROUP BY 1, 2

SELECT

date,

project_name,

n_users,

txs,

ranks

FROM (

SELECT

date,

project_name,

n_users,