from solana.core.fact_transactions

where BLOCK_TIMESTAMP::date >= '2022-12-01'

group by 1),solana as (

select wallet

from solana1 where first_tx::date >= '2023-01-01'

),

near1 as (select TX_SIGNER wallet,min(BLOCK_TIMESTAMP) first_tx

from near.core.fact_transactions

where BLOCK_TIMESTAMP::date >= '2023-01-01'

group by 1),

near as (

select wallet

from near1 where first_tx::date >= '2023-01-01'

),

flow1 as (select PROPOSER wallet,min(BLOCK_TIMESTAMP) first_tx

from flow.core.fact_transactions

where BLOCK_TIMESTAMP::date >= '2023-01-01'

group by 1),

flow as ( select wallet

from flow1 where first_tx::date >= '2023-01-01')

select 'Solana' label,

count(distinct SIGNERS[0]) stakers

from solana.core.fact_staking_lp_actions

where SIGNERS[0] in (select distinct wallet from solana)

and BLOCK_TIMESTAMP::date >= '2023-01-01'

union ALL

select 'Near' label,

count(distinct TX_SIGNER) stakers

from near.core.dim_staking_actions

where TX_SIGNER in (select distinct wallet from near)

and BLOCK_TIMESTAMP::date >= '2023-01-01'

union ALL

select 'Flow' label,

count(distinct DELEGATOR) stakers

from flow.core.ez_staking_actions