Pmisha-bmlMdxcount.wallets.Monkdao
Updated 2022-02-19
9
1
2
3
4
5
6
7
8
9
›
⌄
with w as (
SELECT block_timestamp::date as date,
count(distinct instruction:parsed:info:stakeAccount) as unique_account_per_day,
count (tx_id) as total_transaction_per_day
fROM solana.events
WHERE block_timestamp >= '2022-02-01'
and event_type = 'delegate'
and instruction:parsed:info:voteAccount ='DfpdmTsSCBPxCDwZwgBMfjjV8mF8xHkGRcXP8dJBVmrq' Group By 1)
select sum (unique_account_per_day) as total_delegated_wallet, avg(unique_account_per_day) as average_delegated_wallet from w
Run a query to Download Data