COUNT(DISTINCT e.instruction:accounts[0]::STRING) AS unique_users

FROM

solana.defi.fact_token_burn_actions b

JOIN

solana.core.fact_events e

ON

b.tx_id = e.tx_id

WHERE

b.succeeded

AND e.program_id = 'oreV2ZymfyeXgNgBdqMkumTqqAprVqgBWQfoYkrtKWQ'

AND e.instruction:accounts[2] = 'oreoU2P8bN6jkk3jbaiVxYnG1dCXcYxwhwyK9jSybcp'

AND e.instruction:accounts[3] = 'oreoN2tQbHXVaZsr3pf66A48miqcBXCDJozganhEJgz'

AND CAST(e.block_timestamp AS DATE) > CURRENT_DATE - INTERVAL '365 days';