with d as (

select distinct

ca.dt

, ca.tx_id tx_hash

, ca.signers address

, ca.contract_address

, l.label contract_name

, l.label_type

from

(

select

c.dt

, c.tx_id

, c.signers

, c.contract

, cast(ft.mint as variant) mint_sol

from

(

select

date(date_trunc('day' , block_timestamp)) dt

, tx_id

, s.value signers

, instructions[0]:programId program_id

, m.value:mint mint

from solana.core.fact_transactions

, Table(Flatten(solana.core.fact_transactions.signers)) s

, Table(Flatten(case when ARRAY_SIZE(solana.core.fact_transactions.pre_token_balances) > 0 then solana.core.fact_transactions.pre_token_balances else [1] end)) m

where date(block_timestamp) >= '{{start_dt}}' and date(block_timestamp) <= '{{end_dt}}'

and succeeded = 'TRUE'

)

unpivot(contract for typ in (mint, program_id)) c

left join solana.core.fact_transfers ft

on c.tx_id = ft.tx_id

and ft.mint = 'So11111111111111111111111111111111111111112'

and date(ft.block_timestamp) >= '{{start_dt}}' and date(ft.block_timestamp) <= '{{end_dt}}'