select
--block_timestamp::date as day,
count(distinct(instruction:parsed:info:stakeAuthority)) as NumberofAccounts
from solana.events
where instruction:program = 'stake' and instruction:parsed:info:voteAccount ilike 'DfpdmTsSCBPxCDwZwgBMfjjV8mF8xHkGRcXP8dJBVmrq'
and event_type LIKE 'delegate'
and block_timestamp::date >= '2022-02-01'
--group by 1