Moestakers on Marinade
Updated 2022-04-16
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
date_trunc(day,block_timestamp) as day,
count(distinct ACCOUNT_KEYS[0]:pubkey) as distinct_staker
FROM solana.fact_transactions
WHERE INSTRUCTIONS[0]:programId = 'MarBmsSgKXdrN1egZf5sqe1TMai9K1rChYNDJgjq7aD' and BLOCK_TIMESTAMP >= '2022-03-01' and BLOCK_TIMESTAMP < CURRENT_DATE-2
group by day order by 2 DESC
Run a query to Download Data