shreexmints burn ratio
    Updated 2022-10-11
    with events as ((select
    'burn' as event,
    count(distinct tx_id) as event_count
    from
    solana.core.fact_events
    where program_id='HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T' and succeeded='TRUE'
    and inner_instruction:instructions[0]:parsed:type = 'burn'
    )
    UNION
    ( select
    'mint' as event,
    count(distinct tx_id) as event_count
    from
    solana.core.fact_events
    where program_id='HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T' and succeeded='TRUE'
    and inner_instruction:instructions[0]:parsed:type = 'mintTo'
    )),
    ratios as (
    select
    count(distinct tx_id) as event_ratio_total
    from solana.core.fact_events
    where program_id='HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T' and succeeded='TRUE'
    )
    select
    event,
    event_count,
    (event_count/event_ratio_total)*100 as ratbscio
    from events,ratios

    Run a query to Download Data