date_trunc ('WEEK',HOUR) as tIME,SYMBOL,

avg (price) as Price

FROM crosschain.core.ez_hourly_prices

WHERE symbol like '%ETH%'

GROUP BY 1,2),

Deposit AS (SELECT

date_trunc ('week',BLOCK_TIMESTAMP) as date,

count (DISTINCT TX_HASH) as TXN,

count (DISTINCT DEPOSITOR) as Users,

sum (AMOUNT_DEPOSITED * price) as USD

FROM ethereum.maker.ez_deposits d

LEFT JOIN price P on (tIME = date_trunc ('WEEK',BLOCK_TIMESTAMP) and d.SYMBOL = p.SYMBOL)

WHERE TX_STATUS = 'SUCCESS'

AND d.SYMBOL like '%ETH%'

GROUP BY 1),

Withdraw AS (SELECT

date_trunc ('week',BLOCK_TIMESTAMP) as date,

count (DISTINCT TX_HASH) as TXN,

count (DISTINCT WITHDRAWER) as Users,

sum (AMOUNT_WITHDRAWN * price) as USD

FROM ethereum.maker.ez_withdrawals d

LEFT JOIN price P on (tIME = date_trunc ('WEEK',BLOCK_TIMESTAMP) and d.SYMBOL = p.SYMBOL)

WHERE TX_STATUS = 'SUCCESS'

AND d.SYMBOL like '%ETH%'

GROUP BY 1)

SELECT t1.date,

t1.TXN - t2.TXN as Net_TXN,

t1.Users - t2.Users as Net_Users,