sum(eth_value) as deposit_vol, count (distinct from_address) as address_count_dep, count (distinct tx_hash) as tx_count_dep

from ethereum.core.fact_transactions

where to_address = '0xae0ee0a63a2ce6baeeffe56e7714fb4efe48d419' and eth_value > 0

group by 1),

wd as (select date_trunc('day', block_timestamp) as dt, sum(event_inputs:amount/1e18) as withdraw_vol,

count (distinct origin_from_address) as address_count_wd, count (distinct tx_hash) as tx_count_wd

from ethereum.core.fact_event_logs

where contract_address = '0xae0ee0a63a2ce6baeeffe56e7714fb4efe48d419' and event_name = 'LogWithdrawal'

group by 1),

total as (select *

from dep a

left join wd b on a.dt = b.dt)

select *, (deposit_vol-withdraw_vol) as daily_nett

from total

where withdraw_vol is not null