headitmanagerunique wallets
Updated 2022-03-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
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