select

tx_hash,

block_timestamp::date date ,

event_name type ,

origin_from_address user ,

UPPER(REGEXP_REPLACE(contract_name, '^EVK Vault e(.*?)ETH-[1-2]$', '\\1ETH')) symbol,

( decoded_log:assets) / 1e18 amount

from swell.core.ez_decoded_event_logs

where origin_to_address = '0x08739cbede6e28e387685ba20e6409bd16969cde'

and event_name in ( 'Borrow','Deposit', 'Withdraw','Repay' )

and UPPER(REGEXP_REPLACE(contract_name, '^EVK Vault e(.*?)ETH-1$', '\\1ETH')) is not null

and block_timestamp::date >='2025-01-17'

),

prices as (

SELECT

DATE_TRUNC(day, hour) date,

symbol,

median(price) price

FROM ethereum.price.ez_prices_hourly join euler_txns using (symbol)

where date_trunc(day,hour)::date >= '2025-01-17'

GROUP BY 1,2

),

final as (

select * exclude price , amount*price amount_usd from euler_txns join prices using (date , symbol)

select

count (distinct tx_hash) num_txns ,

count (distinct user) num_users ,

sum (iff(type='Deposit',amount_usd,0)) Deposit_amount_usd ,