SELECT

ft.block_timestamp,

ft.value,

ft.tx_fee

FROM

ink.core.fact_transactions ft

WHERE

ft.tx_hash IN (

SELECT DISTINCT el.tx_hash

FROM ink.core.fact_event_logs el

WHERE

el.contract_address = '0xfb2cd41a8aec89efbb19575c6c48d872ce97a0a5'

AND el.topics[0] = '0x2d764d30e21994e86d9ea9925aa0095caac83736bb99f47ae5eeb3f2256239a7'

AND el.tx_succeeded = 'TRUE')

SELECT SUM(value) AS total_volume,

SUM(tx_fee) AS total_fee

FROM znsvalue