Pmisha-bmlMdxKatana.total
Updated 2022-02-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
sum(inner_instruction:instructions[0]:parsed:info:amount/1e6) as WLUNAamountclaim
From solana.events
Where block_timestamp >= '2022-02-04'
And SUCCEEDED = 'TRUE'
And INSTRUCTION:accounts[4] = '3JU8iPVMrrhmct4RP7rTSBFwStv6oksEsSj4C6mkk2Yg'
and INSTRUCTION:accounts[7] = 'FzJ3VxEBuKxpX6meAWtFeAmoGjN8xw8fVNnArKwDp4os'
--group by 1
),
t2 as (Select
count(distinct PRETOKENBALANCES[1]:owner) as UniqueUser
From solana.events
Where block_timestamp >= '2022-02-04'
And SUCCEEDED = 'TRUE'
And INSTRUCTION:accounts[4] = '3JU8iPVMrrhmct4RP7rTSBFwStv6oksEsSj4C6mkk2Yg'
and INSTRUCTION:accounts[7] = 'FzJ3VxEBuKxpX6meAWtFeAmoGjN8xw8fVNnArKwDp4os'
)
select sum(WLUNAamountclaim) as totalCliam, sum (UniqueUser) as totalUser, totalCliam/totalUser as averageClaimperUser from t1,t2
Run a query to Download Data