keshanMonkedao query 2
Updated 2022-02-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
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