--farokh
select
date_trunc('day',block_timestamp) as date,
count(distinct pre_token_balances[0]:mint)
as unique_Aurory,
count(distinct signers[0]) as users_unique
from
solana.fact_transactions
where
pre_token_balances[0]:mint
in (select mint
from
solana.dim_nft_metadata
where CONTRACT_NAME='Aurory')
and
instructions[0]:programId='EXpwP3pqPzA4arF8i89w7smtvxHzyYETmCpPspLPrR7J'
and
POST_TOKEN_BALANCES[0]:owner='ASGSU7Eeyz5wprVfqbKXQ5xB2sCqrCPUFFzmHggbX8Dm'
group by 1