date_trunc('week', block_timestamp) as week,

count(DISTINCT tx_hash) as events,

count(DISTINCT DEPOSITOR) as users,

sum(amount_deposited * price) as volume

FROM ethereum.maker.ez_deposits

LEFT outer JOIN ethereum.core.fact_hourly_token_prices

ON hour = date_trunc('day', block_timestamp)

AND ethereum.maker.ez_deposits.symbol = ethereum.core.fact_hourly_token_prices.symbol

WHERE block_timestamp > '2021-01-01'

GROUP BY 1