SELECT

block_timestamp,

fact_traces.tx_hash,

CASE

WHEN substr(fact_traces.input, 0, 10) = '0x23b872dd' THEN substr(fact_traces.input, 17, 20)

ELSE fact_traces.from_address

END AS tx_from,

CASE

WHEN fact_traces.bnb_value > 0 THEN '0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c'

ELSE fact_traces.from_address

END AS contract_address,

CASE substr(fact_traces.input, 0, 10)

WHEN '0xa9059cbb' THEN ethereum.public.udf_hex_to_int(SUBSTRING(input, 75, 64))

WHEN '0x23b872dd' THEN ethereum.public.udf_hex_to_int(SUBSTRING(input, 139, 64))

ELSE fact_traces.bnb_value

END AS amount,

SUBSTRING(fact_traces.identifier, len(type)+2) AS trace_address,

tx_status,

IDENTIFIER,

SUB_TRACES

from bsc.core.fact_traces

WHERE

DATE_TRUNC('month', fact_traces.block_timestamp) > DATEADD('month', -4, CURRENT_TIMESTAMP())

AND (substr(fact_traces.input, 0, 10) IN ('0xa9059cbb', '0x23b872dd') OR fact_traces.bnb_value > 0)

and tx_hash = '0x7dbbf9574a9068e24c5b1390b1b917bc45167279b77fbc000189145cf51ebda2'

LEFT JOIN bsc.core.fact_hourly_token_prices pu ON pu.token_address = transfers.contract_address

AND pu.hour = date_trunc('hour', transfers.block_timestamp)

AND pu.token_address NOT IN (SELECT * FROM incorrect_tokens)