MLDZMNsolend2
    Updated 2022-08-04
    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