SELECT TX_HASH AS TX_ID

FROM ethereum.core.ez_dex_swaps

WHERE ORIGIN_TO_ADDRESS = lower('0x881D40237659C251811CEC9c364ef91dC08D300C')

AND SYMBOL_IN = 'WETH'

SELECT COUNT(DISTINCT TX_HASH) AS "Number of Transactions",

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS "Number of Wallets",

SUM((EVENT_INPUTS:value/1e18)) AS "ETH Amount",

(SUM((EVENT_INPUTS:value/1e18)) / COUNT(DISTINCT ORIGIN_FROM_ADDRESS)) AS "Average ETH Deposited Per Wallet"

FROM ethereum.core.fact_event_logs

WHERE TX_HASH IN (SELECT TX_ID FROM wallets)

AND EVENT_NAME = 'Deposit'