with

regular_mints as (

select

block_timestamp

, mint

, 'NFTs' as label_type

from solana.core.fact_nft_mints

where succeeded

and not program_id = 'BGUMAp9Gq7iTEuizy4pqaxsTyUCBK68MDfK752saRPUY'

),

bgum_mints as (

select

block_timestamp

, concat(tx_id, row_number() over (partition by events.tx_id order by events.index)) as mint

, 'compressed NFTs' as label_type

from solana.core.fact_events events

inner join solana.core.fact_transactions txs

using(tx_id, block_timestamp, succeeded)

where succeeded

and program_id = 'BGUMAp9Gq7iTEuizy4pqaxsTyUCBK68MDfK752saRPUY'

and array_contains('Program log: Instruction: MintToCollectionV1' ::variant, log_messages)

and block_timestamp > '2023-02-07'

union all

select