MLDZMNsolend2
Updated 2022-08-04
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
distinct ADDRESS_NAME as mint,
--POST_TOKEN_BALANCES[0]:uiTokenAmount:uiAmount as balance,
count(distinct SIGNERS[0]) as wallet,
count(tx_id) as usages
from solana.fact_transactions x join solana.core.dim_labels y on x.POST_TOKEN_BALANCES[0]:mint=y.ADDRESS
where instructions[1]:programId = 'So1endDq2YkqhipRh3WViPa8hdiSpxWy6z3Z6tMCpAo'
and inner_instructions[1]:instructions[1]:parsed:info:mintAuthority = 'DdZR6zRFiUt4S5mg7AV1uKB2z1f1WzcNYCaTEEWPAuby'
--and inner_instructions[1]:instructions[0]:parsed:info:destination = '8UviNr47S8eL6J3WfDxMRa3hvLta1VDJwNWqsDgtN3Cv'
and BLOCK_TIMESTAMP>=CURRENT_DATE-30
and SIGNERS[0]!='F4q2bm6k4AW2rgQMBfvoNnfn1xFkoD98We6uJd6tV7tq'
group by 1
Run a query to Download Data