--Flipside crowd sourced data
-- Also see crosschain.core.dim_labels & crosschain.core.dim_tags
SELECT
NAME
,BLOCKCHAIN
,ADDRESS
FROM crosschain.core.dim_contracts
WHERE NAME IS NOT NULL
--defillama source
SELECT
PROTOCOL
, CHAIN
, CATEGORY
, ADDRESS
FROM external.defillama.dim_protocols
WHERE ADDRESS IS NOT NULL