SELECT

events.tx_id,

events.block_timestamp,

events.signers[0]::STRING AS user_address,

events.instruction AS JSON_for_Burned_Tokens_Fees,

post_balances[0] - pre_balances[0] as Raw_Transfer_SOL,

post_balances, pre_balances,

CASE WHEN events.instruction:parsed:type = 'burn' then events.instruction:parsed:info:mint END AS burn_token_address,

CASE WHEN events.instruction:parsed:type = 'burn' then events.instruction:parsed:info:amount END AS burn_token_amount,

CASE WHEN events.instruction:parsed:type = 'transfer' then events.instruction:parsed:info:lamports END AS raw_incinerator_fee_sol,

CASE WHEN events.instruction:parsed:type = 'transfer' then events.instruction:parsed:info:destination END AS incinerator_deposit_address,

CASE WHEN events.instruction:parsed:type = 'burn' then events.instruction:parsed:info:account END AS closed_account

FROM

(

SELECT

tx_id,

block_timestamp,

signers,

inner_instruction,

instruction

FROM

solana.core.fact_events

WHERE

succeeded = 'true'

AND

program_id = 'F6fmDVCQfvnEq2KR8hhfZSEczfM9JK9fWbCsYJNbTGn7'

AND

block_timestamp::date >= '{{Start}}')

events JOIN

SELECT

tx_id,

block_timestamp,