vahid-2jsEENToken Staking and NFT Expeditions each day
Updated 2022-07-20
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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