count(distinct pre_token_balances[0]:mint) as unique_Aurorians

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'

and block_timestamp>='2022-04-17'