Pmisha-bmlMdxcount.wallets.Monkdao
    Updated 2022-02-19
    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