select

date_trunc(week, block_timestamp)::date date ,

count (DISTINCT iff(EVENT_NAME='Deposit',ORIGIN_FROM_ADDRESS,NULL) ) num_lockers,

count (DISTINCT iff(EVENT_NAME ='Withdraw',ORIGIN_FROM_ADDRESS,NULL) ) num_unlockers ,

sum (iff(EVENT_NAME ='Deposit',OLAS_AMOUNT,0)) Total_locked_Olas ,

sum (iff(EVENT_NAME ='Withdraw',OLAS_AMOUNT,0)) Total_Unlocked_Olas ,

Total_locked_Olas - Total_Unlocked_Olas net_locked_olas ,

sum (net_locked_olas) over (order by date ) cum_net_locked_olas ,

count (DISTINCT tx_hash) num_lock_unlock_txns ,

avg (OLAS_AMOUNT) avg_locked_unlocked_amount ,

sum (iff(EVENT_NAME ='Deposit',OLAS_AMOUNT_USD,0)) Total_locked_Olas_USD ,

sum (iff(EVENT_NAME ='Withdraw',OLAS_AMOUNT_USD,0)) Total_Unlocked_Olas_USD ,

Total_locked_Olas_USD - Total_Unlocked_Olas_USD net_locked_olas_USD ,

sum (net_locked_olas_USD) over (order by date ) cum_net_locked_olas_USD

from crosschain.olas.ez_olas_locking

group by 1