pimi1356-HdnUm3main events
    Updated 2022-10-09
    with burn as (
    select count (distinct tx_id) as Burn_Count
    from solana.core.fact_events
    where program_id = 'HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T'
    and inner_instruction:instructions[0]:parsed:type = 'burn'
    and succeeded = 'TRUE'),

    Mint as (
    select count (distinct tx_id) as Mint_Count
    from solana.core.fact_events
    where program_id = 'HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T'
    and inner_instruction:instructions[0]:parsed:type = 'mintTo'
    and succeeded = 'TRUE'),

    transfer as (
    select count (distinct tx_id) as Transfers_Count
    from solana.core.fact_events
    where program_id = 'HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T'
    and inner_instruction:instructions[0]:parsed:type = 'transfer'
    and succeeded = 'TRUE'),

    alll as (
    select count (distinct tx_id) as All_Count
    from solana.core.fact_events
    where program_id = 'HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T'
    and succeeded = 'TRUE')

    select 'Burn Ratio' as Type, (Burn_Count/All_Count) * 100 as percent
    from burn,alll
    UNION
    select 'Mint Ratio',(Mint_Count/All_Count) * 100
    from mint,alll
    UNION
    select 'Transfers Ratio',(Transfers_Count/All_Count) * 100
    from transfer,alll

    Run a query to Download Data