avg (price) as price

from ethereum.core.fact_hourly_token_prices

where symbol ='WETH'

group by 1

)

select date_trunc('day', block_timestamp) as days,

count (distinct tx_hash) as trxs,

count (distinct origin_from_address) as users,

sum (event_inputs:value/1e18) as volume,

sum (event_inputs:value/1e18*price) as usd_Volume,

case when origin_function_signature = '0x58c22be7' then 'Deposit'

when origin_function_signature = '0x36118b52' then 'Withdraw'

else null end as type

from ethereum.core.fact_event_logs t1

join price t2 on t1.block_timestamp::date = t2.date

where origin_to_address = '0x3b968d2d299b895a5fcf3bba7a64ad0f566e6f88'--WETH Gateway

and block_timestamp::date >= CURRENT_DATE - 30

and contract_name = 'WETH9'

and event_name = 'Transfer'

and type is not null

group by 1, 6