count(*) as transfers,

count(DISTINCT from_address)

FROM optimism.core.fact_token_transfers

LEFT OUTER JOIN optimism.core.dim_contracts

ON contract_address = address

WHERE not contract_address is NULL

AND (origin_from_address IN (

SELECT

address

FROM optimism.core.dim_labels

WHERE address_name like '%velodrome%'

or origin_to_address IN (

SELECT

address

FROM optimism.core.dim_labels

WHERE address_name like '%velodrome%'

AND not symbol is NULL