date_trunc('week',block_timestamp) as date,

tx_event as action,

count(DISTINCT tx_hash) as tx_count,

count(DISTINCT ORIGIN_FROM_ADDRESS) as user_count,

sum(AMOUNT_DELEGATED * price) as action_volume

from ethereum.maker.ez_delegations a join ethereum.core.fact_hourly_token_prices b on a.block_timestamp::date=b.hour::date

where TX_STATUS = 'SUCCESS'

and token_address = lower('0x9f8F72aA9304c8B593d555F12eF6589cC3A579A2')

and block_timestamp >= '2022-01-01'

group by 1,2