keshanMonkedao query 2
    Updated 2022-02-19
    with delegators_perday as (
    SELECT block_timestamp::date as date, count(distinct instruction:parsed:info:stakeAuthority) as NumberofAccounts
    FROM solana.events
    WHERE block_timestamp::date >= '2022-02-01'
    AND Event_type = 'delegate'
    AND succeeded = 'TRUE'
    AND instruction:parsed:info:voteAccount = 'DfpdmTsSCBPxCDwZwgBMfjjV8mF8xHkGRcXP8dJBVmrq'
    Group By date
    )

    SELECT instruction:parsed:info:stakeAuthority as user, max(block_timestamp::date) as day, count(distinct block_timestamp::date) as times, 1 as New, (times - New) as Recurring
    FROM solana.events
    WHERE block_timestamp::date >= '2022-02-01'
    AND Event_type = 'delegate'
    AND succeeded = 'TRUE'
    AND instruction:parsed:info:voteAccount = 'DfpdmTsSCBPxCDwZwgBMfjjV8mF8xHkGRcXP8dJBVmrq'
    Group By user

    Run a query to Download Data