headitmanagerunique wallets
    Updated 2022-03-19
    with wallets as (select INNER_INSTRUCTION:instructions[1]:parsed:info:authority as wallet,
    (INNER_INSTRUCTION:instructions[1]:parsed:info:amount/1e6) as amount,
    block_timestamp::date as ddate
    from solana.events where inner_instruction:index=1
    and INNER_INSTRUCTION:instructions[0]:parsed:info:owner='VoLT1mJz1sbnxwq5Fv2SXjdVDgPXrb9tJyC8WpMDkSp'
    and INNER_INSTRUCTION:instructions[0]:parsed:type='createAccount'
    and INNER_INSTRUCTION:instructions[1]:parsed:type='transfer'
    and POSTTOKENBALANCES[0]:mint='9n4nbM75f5Ui33ZbPYXn59EwSgE8CGsHtAeTH5YFeJ9E'
    and ddate >= '2022-01-28'
    )

    select count(distinct wallet) from wallets




    Run a query to Download Data