SELECT

block_number,

tx_hash,

position,

tx_fee

FROM

ethereum.core.fact_transactions

),

jared_swaps AS (

SELECT

a.block_timestamp,

a.block_number,

b.position,

a.tx_hash,

a.platform,

a.origin_from_address,

a.origin_to_address,

a.contract_address,

a.amount_in,

a.amount_in_usd,

a.amount_out,

a.amount_out_usd,

a.symbol_in,

a.symbol_out,

a.token_in,

a.token_out,

b.tx_fee AS total_tx_fee

FROM

ethereum.defi.ez_dex_swaps a

INNER JOIN transactions b ON a.block_number = b.block_number

AND a.tx_hash = b.tx_hash

WHERE

a.origin_to_address = LOWER('0x1f2F10D1C40777AE1Da742455c65828FF36Df387')

),