select

INSTRUCTION:parsed:info:mint::string as mint_tk,

tx_id,

signers[0]::string as minter_address,

BLOCK_TIMESTAMP

from eclipse.core.fact_events_inner

where INSTRUCTION:parsed:info:mintAuthority = '3x6Gqc2qFTgwq87LEe1wmybPJLFZPiE8QnSXxDkrAC9E'

and INSTRUCTION_PROGRAM_ID in (

'RariUNM3vz1rwxPg8UJyRAN7rSKXxgd2ncS2ddCa4ZE',

'5hEa5j38yNJRM9vQA44Q6gXVj4Db8y3mWxkDtQeofKKs'

)

and EVENT_TYPE = 'mintTo'

),

all_transfers as (

select

mint::string as mint,

TX_TO::string as holder,

BLOCK_TIMESTAMP

from eclipse.core.fact_transfers

where mint in (select mint_tk from minting_events)

),

all_ownership_changes as (

select

mint_tk::string as mint,

minter_address::string as holder,

BLOCK_TIMESTAMP

from minting_events

union all

select

mint::string,

holder::string,