roketExpedition Token statistics of Aurory collection
    Updated 2022-07-20
    SELECT block_timestamp::date as day , count(distinct post_token_balances[0]:mint) as Aurorians_count from solana.fact_transactions
    where day > '2022-03-01' and instructions[0]:programId='EXpwP3pqPzA4arF8i89w7smtvxHzyYETmCpPspLPrR7J'
    and POST_TOKEN_BALANCES[0]:owner='ASGSU7Eeyz5wprVfqbKXQ5xB2sCqrCPUFFzmHggbX8Dm'
    and post_token_balances[0]:mint in (select mint from solana.dim_nft_metadata where CONTRACT_NAME='Aurory')
    group by day order by day asc
    Run a query to Download Data