SELECT

b.block_timestamp,

b.tx_id,

b.burn_authority as signer

FROM

solana.defi.fact_token_burn_actions b

JOIN solana.core.fact_transfers t ON b.tx_id = t.tx_id

-- LEFT JOIN solana.core.dim_labels l ON b.mint = l.address

WHERE

1 = 1

AND t.tx_to = 'GbKKt2QquzQkGDeXH8Fdw1DjP1UMhszy7L4AHh68EFyw'

AND b.succeeded

UNION ALL

SELECT

n.block_timestamp,

n.tx_id,

n.burn_authority AS signer

FROM

solana.nft.fact_nft_burn_actions n

JOIN solana.core.fact_transfers t ON n.tx_id = t.tx_id

-- LEFT JOIN solana.core.dim_labels l ON n.mint = l.address

WHERE

t.tx_to = 'GbKKt2QquzQkGDeXH8Fdw1DjP1UMhszy7L4AHh68EFyw'

AND n.succeeded

),

closing_accounts AS (

SELECT

e.block_timestamp AS time,

e.tx_id,

e.signers [0] AS signer

FROM

solana.core.fact_transfers t

JOIN solana.core.fact_events e ON e.tx_id = t.tx_id