granadohoTotal New Trading Account Since February 10th
    Updated 2022-02-18
    with tx_list as (
    select
    distinct tx_id
    from solana.events
    Where block_timestamp::date >='2022-02-10'
    AND Succeeded = 'True' AND Index = 3
    AND instruction:programId = 'mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68'
    AND inner_instruction:instructions[0]:parsed:info:destination = 'AVn3JRGhifPCxjxZsU3tQuo4U4dTHizHzBDGW983tx47'
    )

    select
    count(distinct(instruction:parsed:info:newAccount)) as total_new_trading_accounts
    from solana.events
    Where block_timestamp::date >='2022-02-10'
    and tx_id in (select * from tx_list)
    AND Succeeded = 'True' AND Index = 1
    AND event_type = 'createAccount'
    AND pretokenbalances[0]:mint::string = 'So11111111111111111111111111111111111111112'
    AND instruction:programId = '11111111111111111111111111111111'
    Run a query to Download Data