select BLOCK_TIMESTAMP::date as date,sum(EVENT_INPUTS:value)/1e18 as neth_lp_amount

from arbitrum.core.fact_event_logs

where ORIGIN_TO_ADDRESS='0x1c3fe783a7c06bfabd124f2708f5cc51fa42e102'

and CONTRACT_ADDRESS='0xd70a52248e546a3b260849386410c7170c7bd1e9'

and EVENT_INPUTS:from='0x0000000000000000000000000000000000000000'

group by 1),

tab2 as (

select BLOCK_TIMESTAMP::date as date,-sum(EVENT_INPUTS:value)/1e18 as neth_lp_remove

from arbitrum.core.fact_event_logs

where ORIGIN_TO_ADDRESS='0x1c3fe783a7c06bfabd124f2708f5cc51fa42e102'

and CONTRACT_ADDRESS='0xd70a52248e546a3b260849386410c7170c7bd1e9'

and EVENT_INPUTS:to='0x0000000000000000000000000000000000000000'

group by 1)

select tab2.date,neth_lp_amount,neth_lp_remove

from tab1

full outer join tab2

on tab1.date=tab2.date