CONTRACT_NAME,

contract_address,

min(CASE

when

event_name LIKE 'OwnershipTransferred'

AND DECODED_LOG['previousOwner'] LIKE '0x0000000000000000000000000000000000000000'

then

block_timestamp

end) as vault_deployment_time,

count(DISTINCT origin_from_address) as vault_users

FROM avalanche.core.ez_decoded_event_logs

WHERE contract_address in (

SELECT

address

FROM avalanche.core.dim_labels

WHERE project_name LIKE '%beefy%'

)

GROUP BY 1,2

HAVING NOT contract_name IS NULL

ORDER BY 4 DESC