2844Untitled Query
Updated 2022-11-23Copy Reference Fork
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
block_timestamp::date as "DATE",
count(DISTINCT b.value) as uniq_staker_user,
sum(uniq_staker_user) over (order by "DATE" ASC) as cum_grwoth_uniq_staker_user
FROM solana.core.fact_transactions, lateral flatten(input => signers) b
where block_timestamp::date > '2022-08-21'
and instructions[0]:programmed = 'Stake11111111111111111111111111111111111111'
GROUP BY 1
Run a query to Download Data