from solana.core.fact_events

where instruction:programId='Stake11111111111111111111111111111111111111' and event_type='delegate' )

,

stake as ( select date(block_timestamp) as date , count(DISTINCT(tx_id)) as total, sum(total) over (order by date asc ) as Cumulative

from solana.core.fact_events

where instruction:programId='Stake11111111111111111111111111111111111111' and event_type='delegate' and block_timestamp::date >= CURRENT_DATE - 100

group by 1)

,

txs as ( select date(block_timestamp) as date , count(DISTINCT(tx_id)) as total, sum(total) over (order by date asc ) as Cumulative

from solana.core.fact_events

where tx_id not in ( select tx_id from stake_tx) and block_timestamp::date >= CURRENT_DATE - 100 and event_type is not null

group by 1)

select 'Stake' as type, *

from stake

UNION

select 'Other Activities' as type , *

from txs