SELECT x.tx_hash,

x.origin_from_address,

x.contract_address,

y.tx_fee,

x.block_timestamp,

CASE

WHEN LOWER(x.contract_address) = LOWER('0x1b97100ea1d7126c4d60027e231ea4cb25314bdb') THEN 'ankrFLOWEVM'

WHEN LOWER(x.contract_address) = LOWER('0x7f27352d5f83db87a5a3e00f4b07cc2138d8ee52') THEN 'USDC.e'

WHEN LOWER(x.contract_address) = LOWER('0x5598c0652b899eb40f169dd5949bdbe0bf36ffde') THEN 'stFlow'

WHEN LOWER(x.contract_address) = LOWER('0xd3bf53dac106a0290b0483ecbc89d40fcc961f3e') THEN 'WFLOW'

ELSE 'FLOW'

END AS asset,

x.event_index,

x.data,

CASE

WHEN LOWER(x.contract_address) = LOWER('0x1b97100ea1d7126c4d60027e231ea4cb25314bdb') THEN 18

WHEN LOWER(x.contract_address) = LOWER('0x7f27352d5f83db87a5a3e00f4b07cc2138d8ee52') THEN 6

WHEN LOWER(x.contract_address) = LOWER('0x5598c0652b899eb40f169dd5949bdbe0bf36ffde') THEN 18

WHEN LOWER(x.contract_address) = LOWER('0xd3bf53dac106a0290b0483ecbc89d40fcc961f3e') THEN 18

ELSE 18

END AS decimals

FROM flow.core_evm.fact_event_logs x

JOIN flow.core_evm.fact_transactions y

ON x.tx_hash = y.tx_hash

WHERE (LOWER(y.to_address) = LOWER('0x3EF68D3f7664b2805D4E88381b64868a56f88bC4')

AND x.origin_function_signature = '0xac9650d8')

AND x.tx_succeeded = TRUE

AND LOWER(x.contract_address) IN (

LOWER('0x1b97100ea1d7126c4d60027e231ea4cb25314bdb'),

LOWER('0x7f27352d5f83db87a5a3e00f4b07cc2138d8ee52'),

LOWER('0xd3bf53dac106a0290b0483ecbc89d40fcc961f3e'),

LOWER('0x5598c0652b899eb40f169dd5949bdbe0bf36ffde')

)

),

ranked_data AS (