binhachonFirst Time Deposits at Mango Markets - How many account created
    Updated 2022-02-18
    with new_account_transactions as (
    select
    block_timestamp,
    inner_instruction:instructions[0]:parsed:info:newAccount::string as account
    from solana.events
    where block_timestamp::date >= '2022-02-10'
    and inner_instruction:instructions[0]:parsed:info:owner::string = 'mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68'
    and inner_instruction:instructions[0]:parsed:type::string = 'createAccount'
    and instruction:programId::string = 'mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68'
    )
    select
    block_timestamp::date as blocktime,
    count(distinct account) as number_of_new_accounts
    from new_account_transactions
    group by blocktime

    Run a query to Download Data