block_timestamp::date as date,

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'

group by 1,2

union ALL

select 'Mint' as type,

block_timestamp::date as date,

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'

group by 1,2

union ALL

select 'Transfer' as type,

block_timestamp::date as date,

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'

group by 1,2