pimi1356-HdnUm3Top 10 programs in which the USDH had the most transactions-time analysis
    Updated 2022-10-09
    select date_trunc('{{date_range}}', block_timestamp) as date,
    case when instructions[0]:programId = '6LtLpnUFNByNXLyCoK9wA2MykKAmQNZKBdY8s47dehDc' then 'Kamino Program'
    when instructions[0]:programId = 'JUP3c2Uh3WA4Ng34tw6kPd2G4C5BB21Xo36Je1s32Ph' then 'jupiter aggregator v3'
    when instructions[0]:programId = 'whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc' then 'Orca'
    when instructions[0]:programId = 'JUP4Fb2cqiRUcaTHdrPC8h2gNsA2ETXiPDD33WcGuJB' then 'jupiter aggregator v4'
    when instructions[0]:programId = 'HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T' then 'Hubble Protocol'
    when instructions[0]:programId = 'TLPv2tuSVvn3fSk8RgW3yPddkp5oFivzZV3rA9hQxtX' then 'Tulip Protocol'
    when instructions[0]:programId = 'EN1GMA5PDSgoAUgBEdSKCcGWA4xik8qjbZ58BiRs1cEY' then 'Raydium Enigma Protocol'
    when instructions[0]:programId = 'ComputeBudget111111111111111111111111111111' then 'ComputeBudget111111111111111111111111111111'
    else address_name end as title,
    count (distinct tx_id) as TX_Count,
    count (distinct signers[0]) as Users_Count
    from solana.core.fact_transactions t1 full outer join solana.core.dim_labels t2 on t1.instructions[0]:programId = t2.address
    where (inner_instructions[1]:instructions[0]:parsed:info:mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'
    or inner_instructions[0]:instructions[0]:parsed:info:mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'
    or pre_token_balances[0]:mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'
    or pre_token_balances[1]:mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX')
    and succeeded = 'TRUE'
    and block_timestamp >= CURRENT_DATE - 30
    group by 1,2
    order by 1
    Run a query to Download Data