SUM(AMOUNT_USD) "Amount USD",

COUNT(DISTINCT T1.tx_hash) "Number of transactions",

COUNT (DISTINCT T1.eth_from_address) "Number of Users",

("Amount USD" / "Number of transactions") "Average amount per transaction",

AVG(TX_FEE) "Average gas fee"

FROM ethereum.core.ez_eth_transfers T1

join ethereum.core.fact_transactions T2 ON T1.TX_HASH = T2.TX_HASH

WHERE STATUS = 'SUCCESS'

AND T1.BLOCK_NUMBER >= 15537351

AND T1.BLOCK_TIMESTAMP::DATE - INTERVAL '1 WEEK' <= '2022-09-15'