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

count (DISTINCT iff(EVENT_NAME ='Withdraw',ORIGIN_FROM_ADDRESS,NULL) ) - 1 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 ,

count (DISTINCT tx_hash) num_lock_unlock_txns ,

min (iff(EVENT_NAME ='Deposit',OLAS_AMOUNT,pow(10,10000))) min_locked_amount ,

max (iff(EVENT_NAME ='Deposit',OLAS_AMOUNT,0)) max_locked_amount ,

median (OLAS_AMOUNT) median_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 ,

min (iff(EVENT_NAME ='Deposit',OLAS_AMOUNT_USD,pow(10,10000))) min_locked_amount_USD ,

max (iff(EVENT_NAME ='Deposit',OLAS_AMOUNT_USD,0)) max_locked_amount_USD ,

median (OLAS_AMOUNT_USD) median_locked_unlocked_amount_USD ,

max (UNLOCK_TIMESTAMP) max_unlock_date

from crosschain.olas.ez_olas_locking