select BLOCK_TIMESTAMP::date as date ,sum(EVENT_INPUTS:value)/1e18 as nusd_lp
, avg(nusd_lp)over(order by date asc)as daily_avg_nusd_lp
from arbitrum.core.fact_event_logs
where ORIGIN_TO_ADDRESS='0x9dd329f5411466d9e0c488ff72519ca9fef0cb40'
and EVENT_INPUTS:from='0x0000000000000000000000000000000000000000'
and CONTRACT_ADDRESS='0xcfd72be67ee69a0dd7cf0f846fc0d98c33d60f16'
group by 1