Pmisha-bmlMdxFRI.5
Updated 2022-03-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with t1 as(Select
distinct inner_instruction:instructions[0]:parsed:info:source as uniquesolwallet,
sum(inner_instruction:instructions[1]:parsed:info:amount/1e6) as amountbtc
From Solana.events
Where block_timestamp:: date >= '2022-01-28'
and index=1
And INSTRUCTION:programId='VoLT1mJz1sbnxwq5Fv2SXjdVDgPXrb9tJyC8WpMDkSp'
and POSTTOKENBALANCES[1]:mint='3BjcHXvyzMsjmeqE2qFLx45K4XFx3JPiyRnjJiF5MAHt'
and INNER_INSTRUCTION:instructions[1]:parsed:type='transfer'
and SUCCEEDED = 'TRUE' group by 1)
select
distinct inner_instruction:instructions[0]:parsed:info:authority as wallet,
s.instruction:programId as protocol,
b.label,
count(wallet) as no_app
from solana.events s
LEFT OUTER JOIN Solana.labels b ON s.instruction:programId = b.address
where inner_instruction:instructions[0]:parsed:info:authority in (select uniquesolwallet from t1)
and block_timestamp:: date >= '2022-01-28' and label is not null
group by 1,2,3
order by 4 DESC
Run a query to Download Data