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

avg (price) as Price

FROM crosschain.core.ez_hourly_prices

GROUP BY 1,2),

final as (SELECT

'Deposit' AS TYPE,

d.SYMBOL,

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'

GROUP BY 1,2)

SELECT * FROM final WHERE users > 10