date_trunc(week,block_timestamp)::date as date

,case

when inner_instruction:instructions[0]:parsed:type = 'burn' then 'Burn'

when inner_instruction:instructions[0]:parsed:type = 'mintTo' then 'Mint'

when inner_instruction:instructions[0]:parsed:type = 'transfer' then 'Transfer'

end as type

,count(distinct tx_id) as tx_count

,sum(tx_count) over(partition by type order by date) as growth_type

from solana.core.fact_events

where program_id = 'HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T'

and succeeded = true

and type is not null

group by 1,2

order by 1