alessio9567Hubble mint burn rates
    Updated 2022-10-10
    SELECT i.value:parsed:type
    ,COUNT(*)
    FROM solana.core.fact_events e, LATERAL flatten(input => inner_instruction:instructions) i
    WHERE program_id = 'HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T'
    AND i.value:parsed:type IN ('burn','mintTo')
    GROUP BY 1
    Run a query to Download Data