vahid-2jsEENToken Staking and NFT Expeditions each day
    Updated 2022-07-20
    SELECT 'token staking' AS lbl , COUNT(DISTINCT tx_id) AS val ,trunc(block_timestamp, 'DAY') AS date FROM solana.fact_events
    WHERE program_id='STkwf3sbMapjy7KV3hgrJtcVvY4SvRxWQ8pj4Enw1i5'
    GROUP BY date

    UNION

    SELECT 'nft expedition' AS lbl , COUNT(DISTINCT pre_token_balances[0]:mint) AS val,trunc(block_timestamp, 'DAY') AS date
    FROM solana.fact_transactions
    WHERE pre_token_balances[0]:mint IN (SELECT DISTINCT mint FROM solana.dim_nft_metadata WHERE contract_name ilike 'Aurory')
    AND instructions[0]:programId='EXpwP3pqPzA4arF8i89w7smtvxHzyYETmCpPspLPrR7J' AND post_token_balances[0]:owner='ASGSU7Eeyz5wprVfqbKXQ5xB2sCqrCPUFFzmHggbX8Dm'
    GROUP BY date
    Run a query to Download Data