activity_type,

COUNT(DISTINCT tx_hash) AS transaction_count,

SUM(olas_amount) AS total_volume

FROM (

SELECT

'Locking' AS activity_type,

tx_hash,

olas_amount

FROM crosschain.olas.ez_olas_locking

WHERE event_name = 'Deposit'

UNION ALL

SELECT

'Unlocking' AS activity_type,

tx_hash,

olas_amount

FROM crosschain.olas.ez_olas_locking

WHERE event_name = 'Withdraw'

) activity_data

GROUP BY activity_type;