SELECT

block_timestamp::date AS date,

args:new_account_id AS wallet

FROM near.core.fact_actions_events_function_call

WHERE predecessor_id = 'meteor-relayer.near'

AND method_name = 'create_account')

,

stakers as (select SIGNER_ID as user,

sum(amount) as staked_amount

from near.gov.fact_staking_actions

where action in ('staking')

and ADDRESS = 'meteor.poolv1.near'

and signer_id in (select wallet from create_account)

and block_timestamp::date >= '2024-06-22'

group by 1)

select count(DISTINCT user) as stakers,

case when staked_amount < 5 then 'a. < 5 Near'

when staked_amount = 5 then 'b. 5 Near'

when staked_amount <= 10 then 'c. 5-10 Near'

when staked_amount <= 15 then 'd. 10-15 Near'

when staked_amount <= 25 then 'e. 15-25 Near'

when staked_amount <= 50 then 'f. 25-50 Near'

when staked_amount <= 75 then 'g. 50-75 Near'

when staked_amount <= 100 then 'h. 75-100 Near'

when staked_amount > 100 then 'i. > 100 Near' end as cat

from stakers

group by 2