from (select scf.block_timestamp::date as date_time,

count (case when inner_instruction:instructions[0]:parsed:type = 'mintTo' then 1 end) as total,

count(*) as totals

from solana.core.fact_events scf

where scf.block_timestamp >= '2022-01-01'

and scf.program_id in ('HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T')

group by date_time

order by date_time)